Dataset highlighting crimes reported to the Albany Police Department for the past year to date geocoded by Neighborhood. It is the same data as Patrol Zone. For purposes of crime statistics, the FBI Uniform Crime Report Hierarchy Rule requires when more than one offense occurs in an incident the highest priority crime is selected as the primary offense.
This dataset has the following 18 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Agency Case Number | agency_case_no | text | APD*21150565 APD*21151416 APD*21151529 APD*21151568 APD*21151647 view top 100 |
| Report Date | report_date | calendar_date | 2022-05-26T00:00:00.000 2022-08-19T00:00:00.000 2022-05-04T00:00:00.000 2022-11-01T00:00:00.000 2022-10-05T00:00:00.000 view top 100 |
| Time of Crime | time_of_crime | number | 17 16 20 12 0 view top 100 |
| Occur Begin Day | occur_begin_day | text | MON TUE SAT WED FRI view top 100 |
| Occur Begin Date | occur_begin_date | calendar_date | 2022-07-19T00:00:00.000 2022-07-09T00:00:00.000 2022-07-10T00:00:00.000 2022-09-04T00:00:00.000 2022-07-21T00:00:00.000 view top 100 |
| Occur Begin Time | occur_begin_time | text | 00:00 12:00 20:00 08:00 16:00 view top 100 |
| Occur End Day | occur_end_day | text | MON TUE WED THU SAT view top 100 |
| Occur End Date | occur_end_date | calendar_date | 2022-05-26T00:00:00.000 2022-08-19T00:00:00.000 2022-01-18T00:00:00.000 2022-07-20T00:00:00.000 2022-11-01T00:00:00.000 view top 100 |
| Occur End Time | occur_end_time | text | 08:00 12:00 09:00 17:00 16:00 view top 100 |
| Crime Class | crime_class | text | PL VTL view top 100 |
| Incident Type | incident_type | text | PETIT LARCENY HARRASSMENT 2ND- PHY CONTACT CRIM MIS INTENT DAMAGE PROPRTY CRIMINAL MISCHIEF 3RD:DAMAGE ANOTHER'S PROPERTY-AMOUNT> $250 ASLT W/INT CAUSES PHYS INJURY view top 100 |
| UCR | ucr | number | 6 24 19 33 4 view top 100 |
| Long ID | long_id | text | 1552500AM0 24026010V2 1450001AM4 1450502EF3 1200001AM3 view top 100 |
| Crime Attempt | crime_attempt | text | No Yes view top 100 |
| Class Description | class_description | text | PERSON PERSON DOM VIOLENCE THEFT FROM BUILDING SHOPLIFTING ALL OTHER LARCENIES view top 100 |
| Last 30 Days | last_30_days | checkbox | false true view top 100 |
| Neighborhood Association | neighborhood_association | text | West Hill Pine Hills South End Beverwyck West End view top 100 |
| Neighborhood XY | neighborhood_xy | point | {"coordinates":[-73.764844247,42.6666911887],"type":"Point"} {"coordinates":[-73.7866126905,42.6626959378],"type":"Point"} {"coordinates":[-73.7592617522,42.6392747943],"type":"Point"} {"coordinates":[-73.7822271336,42.6700629397],"type":"Point"} {"coordinates":[-73.7781040852,42.6749695802],"type":"Point"} view top 100 |