From a 500-row sample across 13 columns.
boroughmonthdistrictHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| month | borough | community_board | district | cleaning_section | acceptable_streets_feb_2014 | same_month_prev_year_1 | acceptable_streets_previous_month | filthy_streets_feb_2014 | previous_month_2 | same_month_prev_year_2 | avergage_street_cleanliness_feb_2014 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023 / 09 | Manhattan | 11 | MN11 | MN111 | 94.6 | 100.0 | 74.3 | 97.1 | 94.4 | 94.3 | 94.6 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
month | text | Year / Month | 0% | 2022 / 022022 / 012022 / 03 |
borough | categorical | Borough (Bronx, Manhattan, Brooklyn, Queens, Staten Island) | 0% | BrooklynQueensManhattanof 5 |
community_board | categorical | Community Board | 0% | 1237of 18 |
district | text | Equivalent to community board | 0% | QE07QE13SI03 |
GET /api/datasets/rqhp-hivt GET /api/datasets/rqhp-hivt/quality GET /api/datasets/rqhp-hivt/related GET /api/columns?dataset=rqhp-hivt
community_boardboroughmonth| 2023 / 09 | Manhattan | 12 | MN12 | MN121 | 89.7 | 96.4 | 80.0 | 100.0 | 88.2 | 100.0 | 85.2 |
| 2023 / 09 | Manhattan | 10 | MN10 | MN101 | 100.0 | 97.3 | 100.0 | 100.0 | — | — | 85.7 |
| 2023 / 09 | Manhattan | 10 | MN10 | MN104 | 94.7 | 90.9 | 92.3 | 100.0 | — | — | 87.2 |
| 2023 / 09 | Manhattan | 11 | MN11 | MN112 | 84.2 | 85.7 | 92.3 | 100.0 | 92.1 | 93.9 | 89.7 |
| 2023 / 09 | Manhattan | 11 | MN11 | MN113 | 90.0 | 89.7 | 91.4 | 88.5 | 96.8 | 96.7 | 97.1 |
| 2023 / 09 | Manhattan | 1 | MN01 | MN011 | 95.0 | 100.0 | 100.0 | 100.0 | 100.0 | 100.0 | 98.4 |
| 2023 / 09 | Manhattan | 1 | MN01 | MN013 | 96.3 | 98.1 | 93.0 | 100.0 | — | — | 98.1 |
| 2023 / 09 | Manhattan | 10 | MN10 | MN103 | 81.6 | 100.0 | 97.5 | 86.5 | — | — | 92.3 |
| 2023 / 09 | Manhattan | 12 | MN12 | MN122 | 100.0 | 100.0 | 82.8 | 100.0 | 87.5 | 100.0 | 87.2 |
Showing 12 of 13 columns. All of them are listed below.
cleaning_section |
| text |
| District subdivision |
| 0% |
BKN092QE111BKN013 |
acceptable_streets_feb_2014 | float | Percentage of streets observed acceptably clean | 4% | 100.095.096.0 |
same_month_prev_year_1 | float | Percentage of sidewalks observed acceptably clean | 4% | 100.095.096.0 |
acceptable_streets_previous_month | float | Percentage of acceptable clean streets for previous month | 4% | 100.095.096.0 |
filthy_streets_feb_2014 | float | Percentage of acceptable clean sidewalks for previous month | 4% | 100.095.096.0 |
previous_month_2 | float | Percentage of acceptable clean streets for previous year | 6% | 100.095.096.0 |
same_month_prev_year_2 | float | Percentage of acceptable clean sidewalks for previous year | 6% | 100.095.096.0 |
avergage_street_cleanliness_feb_2014 | float | Percentage of acceptable streets for previous fiscal quarter | 5% | 100.095.096.0 |
previous_month_3 | float | Percentage of acceptable sidewalks for previous fiscal quarter | 5% | 100.095.096.0 |