From a 500-row sample across 112 columns.
| agency | geographic_unit | geographic_identifier | indicator | jul_10 | aug_10 | sep_10 | oct_10 | nov_10 | dec_10 | jan_11 | feb_11 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| DSNY | Community District | Staten Island 3 | Streets rated acceptably clean (%) | 100.00 | 100.00 | 100.00 | 100.00 | 99.30 | 100.00 | 98.30 | 100.00 |
| DSNY | Community District |
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% | NYPDDSNYFDNYof 3 |
geographic_unit | categorical | Relevant geographic sub-unit: Police Precinct, School District, Community District, or Borough. | 0% | PrecinctCommunity Districtof 2 |
geographic_identifier | text | Identifies which Community District, Police Precinct, or School District the indicator relates to. | 0% | Staten Island 1Manhattan 2Queens 4 |
indicator | text | Measure of agency performance for given geographic sub-unit. | 0% |
GET /api/datasets/phxt-vb3r GET /api/datasets/phxt-vb3r/quality GET /api/datasets/phxt-vb3r/related GET /api/columns?dataset=phxt-vb3r
| Staten Island 2 |
| Streets rated acceptably clean (%) |
| 96.10 |
| 99.10 |
| 100.00 |
| 98.80 |
| 98.10 |
| 98.20 |
| 100.00 |
| 99.10 |
| DSNY | Community District | Staten Island 1 | Streets rated acceptably clean (%) | 92.10 | 94.40 | 94.10 | 96.40 | 95.10 | 96.90 | 100.00 | 82.20 |
| DSNY | Community District | Queens 14 | Streets rated acceptably clean (%) | 97.00 | 97.80 | 97.50 | 95.70 | 96.60 | 99.10 | 96.00 | 88.60 |
| DSNY | Community District | Queens 13 | Streets rated acceptably clean (%) | 95.60 | 95.90 | 97.20 | 99.70 | 99.40 | 97.90 | 99.40 | 97.60 |
| DSNY | Community District | Queens 12 | Streets rated acceptably clean (%) | 89.60 | 94.80 | 97.60 | 98.00 | 97.80 | 95.80 | 97.60 | 96.60 |
| DSNY | Community District | Queens 11 | Streets rated acceptably clean (%) | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 | 97.90 | 99.20 |
| DSNY | Community District | Queens 10 | Streets rated acceptably clean (%) | 94.70 | 97.40 | 94.80 | 96.40 | 96.00 | 98.90 | 100.00 | 80.30 |
| DSNY | Community District | Queens 9 | Streets rated acceptably clean (%) | 91.70 | 95.40 | 90.70 | 94.10 | 98.70 | 96.60 | 100.00 | 79.20 |
| DSNY | Community District | Queens 8 | Streets rated acceptably clean (%) | 98.50 | 99.00 | 98.00 | 98.40 | 100.00 | 96.60 | 100.00 | 89.60 |
Showing 12 of 112 columns. All of them are listed below.
Grand larceny autoMurder and non-negligent…Major felony crimejul_10 | text | — | 0% | 0-1 |
aug_10 | text | — | 0% | 0-1 |
sep_10 | text | — | 0% | -01 |
oct_10 | text | — | 0% | -01 |
nov_10 | text | — | 0% | 0-1 |
dec_10 | text | — | 0% | 0-1 |
jan_11 | text | — | 0% | 0-1 |
feb_11 | text | — | 0% | 01- |
mar_11 | text | — | 0% | 0-1 |
apr_11 | text | — | 0% | 0-1 |
may_11 | text | — | 0% | -01 |
jun_11 | text | — | 0% | 0-1 |
jul_11 | text | — | 0% | -01 |
aug_11 | text | — | 0% | -01 |
sep_11 | text | — | 0% | 0-1 |
oct_11 | text | — | 0% | -01 |
nov_11 | text | — | 0% | -02 |
dec_11 | text | — | 0% | 0-1 |
jan_12 | text | — | 0% | 0-1 |
feb_12 | text | — | 0% | -01 |
mar_12 | text | — | 0% | -01 |
apr_12 | text | — | 0% | -01 |
may_12 | text | — | 0% | -01 |
jun_12 | text | — | 0% | -01 |
jul_12 | text | — | 0% | -01 |
aug_12 | text | — | 0% | -01 |
sep_12 | text | — | 0% | -01 |
oct_12 | text | — | 0% | -01 |
nov_12 | text | — | 0% | 0-1 |
dec_12 | text | — | 0% | 0-1 |
jan_13 | text | — | 0% | 0-1 |
feb_13 | text | — | 0% | 0-1 |
mar_13 | text | — | 0% | 0-1 |
apr_13 | text | — | 0% | 0-1 |
may_13 | text | — | 0% | 0-1 |
jun_13 | text | — | 0% | 0-1 |
jul_13 | text | — | 0% | 0-1 |
aug_13 | text | — | 0% | 0-1 |
sep_13 | text | — | 0% | 0-1 |
oct_13 | text | — | 0% | 0-1 |
nov_13 | text | — | 0% | 0-1 |
dec_13 | text | — | 0% | 0-1 |
jan_14 | text | — | 0% | 0-1 |
feb_14 | text | — | 0% | 0-1 |
mar_14 | text | — | 0% | 0-1 |
apr_14 | text | — | 0% | 0-1 |
may_14 | text | — | 0% | 0-1 |
jun_14 | text | — | 0% | -01 |
jul_14 | text | — | 0% | -01 |
aug_14 | text | — | 0% | 0-1 |
sep_14 | text | — | 0% | 0-1 |
oct_14 | text | — | 0% | 0-1 |
nov_14 | text | — | 0% | 0-1 |
dec_14 | text | — | 0% | 0-1 |
jan_15 | text | — | 0% | 0-1 |
feb_15 | text | — | 0% | 0NA1 |
mar_15 | text | — | 0% | 01- |
apr_15 | text | — | 0% | 0-1 |
may_15 | text | — | 0% | 0-1 |
jun_15 | text | — | 0% | 0-1 |
jul_15 | text | — | 0% | 0-1 |
aug_15 | text | — | 0% | -01 |
sep_15 | text | — | 0% | 0-1 |
oct_15 | text | — | 0% | 0-1 |
nov_15 | text | — | 0% | 0-1 |
dec_15 | text | — | 0% | 0-1 |
jan_16 | text | — | 0% | 0-1 |
feb_16 | text | — | 0% | 0-1 |
mar_16 | text | — | 0% | 0-1 |
apr_16 | text | — | 0% | -01 |
may_16 | text | — | 0% | -01 |
jun_16 | text | — | 0% | 0-NA |
jul_16 | text | — | 0% | -01 |
aug_16 | text | — | 0% | NA01 |
sep_16 | text | — | 0% | -01 |
oct_16 | text | — | 0% | -01 |
nov_16 | text | — | 0% | -01 |
dec_16 | text | — | 0% | 0-1 |
jan_17 | text | — | 0% | -01 |
feb_17 | text | — | 0% | 0-1 |
mar_17 | text | — | 0% | NA-0 |
apr_17 | text | — | 0% | NA-0 |
may_17 | text | — | 0% | -01 |
jun_17 | text | — | 0% | -01 |
jul_17 | text | — | 0% | -01 |
aug_17 | text | — | 0% | 0-1 |
sep_17 | text | — | 0% | 0-1 |
oct_17 | text | — | 0% | -01 |
nov_17 | text | — | 0% | -01 |
dec_17 | text | — | 0% | -01 |
jan_18 | text | — | 0% | 0-1 |
feb_18 | text | — | 0% | 0-1 |
mar_18 | text | — | 0% | 0-1 |
apr_18 | text | — | 0% | 012 |
may_18 | text | — | 0% | -01 |
jun_18 | text | — | 0% | -0100.00 |
jul_18 | text | — | 0% | -01 |
aug_18 | text | — | 0% | -01 |
sep_18 | text | — | 0% | -01 |
oct_18 | text | — | 0% | -01 |
nov_18 | text | — | 0% | NA01 |
dec_18 | text | — | 0% | NA01 |
jan_19 | text | — | 0% | NA01 |
feb_19 | text | — | 0% | NA01 |
mar_19 | text | — | 0% | NA01 |
apr_19 | text | — | 0% | NA01 |
may_19 | text | — | 0% | NA01 |
jun_19 | text | — | 0% | NA01 |