From a 500-row sample across 13 columns.
agencyagencyagencyagency| agency | geographic_unit | geographic_identifier | indicator | fy2011 | fy2012 | fy2013 | fy2014 | fy2015 | fy2016 | fy2017 | fy2018 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| NYPD | Precinct | 113 | Hate Crimes (total) | 1 | 3 | 0 | 0 | 0 | 2 | 2 | 0 |
| NYPD | Precinct | 112 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
agency | categorical | The acronym of the agency's name | 0% | NYPDDSNYDOHMHof 12 |
geographic_unit | categorical | Relevant geographic sub-unit: Police Precinct, School District, Community District, or Borough. | 0% | Community DistrictPrecinctSchool districtof 4 |
geographic_identifier | text | Identifies which Community District, Police Precinct, or School District the indicator relates to. | 0% | Bronx 9Bronx 1Bronx 6 |
indicator | text | Measure of agency performance for given geographic sub-unit. | 0% |
GET /api/datasets/gsj6-6rwm GET /api/datasets/gsj6-6rwm/quality GET /api/datasets/gsj6-6rwm/related GET /api/columns?dataset=gsj6-6rwm
| Hate Crimes (total) |
| 1 |
| 3 |
| 14 |
| 3 |
| 4 |
| 5 |
| 0 |
| 2 |
| DCA | Community District | Staten Island 3 | Resolved Consumer Complaints | 44 | 40 | 53 | 38 | 38 | 33 | 22 | 29 |
| DCA | Community District | Staten Island 2 | Resolved Consumer Complaints | 46 | 57 | 56 | 43 | 29 | 63 | 23 | 25 |
| DCA | Community District | Staten Island 1 | Resolved Consumer Complaints | 75 | 56 | 29 | 61 | 42 | 65 | 46 | 28 |
| DCA | Community District | Queens 14 | Resolved Consumer Complaints | 17 | 25 | 9 | 8 | 8 | 11 | 14 | 23 |
| DCA | Community District | Queens 13 | Resolved Consumer Complaints | 64 | 36 | 22 | 41 | 44 | 61 | 36 | 45 |
| DCA | Community District | Queens 12 | Resolved Consumer Complaints | 125 | 144 | 113 | 113 | 112 | 122 | 94 | 59 |
| DCA | Community District | Queens 11 | Resolved Consumer Complaints | 35 | 45 | 35 | 58 | 37 | 45 | 42 | 36 |
| DCA | Community District | Queens 10 | Resolved Consumer Complaints | 55 | 48 | 55 | 54 | 51 | 58 | 37 | 46 |
Showing 12 of 13 columns. All of them are listed below.
BurglaryHate Crime Related Murde…Domestic Violence Relate…fy2011 | text | The fiscal year actual for 2011 (July 2010 through June 2011) | 0% | 0NA1 |
fy2012 | text | The fiscal year actual for 2012 (July 2011 through June 2012) | 0% | NA01 |
fy2013 | text | The fiscal year actual for 2013 (July 2012 through June 2013) | 0% | 012 |
fy2014 | text | The fiscal year actual for 2014 (July 2013 through June 2014) | 0% | 012 |
fy2015 | text | The fiscal year actual for 2015 (July 2014 through June 2015) | 0% | 012 |
fy2016 | text | The fiscal year actual for 2016 (July 2015 through June 2016) | 0% | 0NA1 |
fy2017 | text | The fiscal year actual for 2017 (July 2016 through June 2017) | 0% | 01NA |
fy2018 | text | The fiscal year actual for 2018 (July 2017 through June 2018) | 0% | 0NA1 |
fy2019 | text | The fiscal year actual for 2019 (July 2018 through June 2019) | 0% | NA01 |