From a 55-row sample across 34 columns.
boroughboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| location_id | zip_code | borough | council_district | requesting_precinct | conduct_or_complaint_that_1 | date_of_inspection | time_of_visitation_hh_mm | inspection_duration_min | inspectors_from_nypd_present | total_inspectors_from_city | closure_of_establishment |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 11105 | Queens | 22 | 114 | 5 | 2021-04-09T00:00:00.000 | 10:00:00 PM | 5 | 5 | 5 | false |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
location_id | integer | — | 0% | 123 |
zip_code | integer | — | 0% | 104721110310030 |
borough | categorical | — | 0% | QueensManhattanThe Bronxof 6 |
council_district | integer | — | 0% | 17944 |
requesting_precinct | categorical | — |
GET /api/datasets/b84a-xy2t GET /api/datasets/b84a-xy2t/quality GET /api/datasets/b84a-xy2t/related GET /api/columns?dataset=b84a-xy2t
zip_codeborough| 1 | 10037 | Manhattan | 9 | 32 | — | 2020-01-10T00:00:00.000 | 10:30:00 PM | 90 | 12 | 20 | false |
| 2 | 10027 | Manhattan | 9 | 32 | — | 2020-01-10T00:00:00.000 | 11:30:00 PM | 80 | 12 | 20 | false |
| 3 | 10030 | Manhattan | 9 | 32 | 1 | 2020-01-11T00:00:00.000 | 12:40:00 AM | 145 | 12 | 20 | false |
| 4 | 10463 | The Bronx | 11 | 50 | — | 2020-01-17T00:00:00.000 | 10:50:00 PM | 100 | 13 | 21 | false |
| 5 | 10302 | Staten Island | 49 | 121 | 1 | 2020-01-24T00:00:00.000 | 10:40:00 PM | 117 | 11 | 15 | false |
| 6 | 10302 | Staten Island | 49 | 121 | — | 2020-01-25T00:00:00.000 | 12:00:00 AM | 180 | 11 | 15 | false |
| 7 | 11103 | Queens | 22 | 114 | — | 2020-01-31T00:00:00.000 | 10:40:00 PM | 80 | 13 | 17 | false |
| 8 | 11103 | Queens | 22 | 121 | — | 2020-02-01T00:00:00.000 | 12:05:00 AM | 95 | 13 | 17 | false |
| 9 | 11103 | Queens | 26 | 114 | — | 2020-02-01T00:00:00.000 | 1:40:00 AM | 66 | 13 | 17 | false |
Showing 12 of 31 columns. All of them are listed below.
| 0% |
4332114of 19 |
conduct_or_complaint_that | categorical | — | 55% | 123of 4 |
conduct_or_complaint_that_1 | categorical | — | 64% | 154of 7 |
conduct_or_complaint_that_2 | categorical | — | 75% | 123of 3 |
conduct_or_complaint_that_3 | categorical | — | 60% | 123of 4 |
conduct_or_complaint_that_4 | categorical | — | 27% | 124of 7 |
conduct_or_complaint_that_5 | text | — | 100% | — |
conduct_or_complaint_that_6 | integer | — | 80% | 1of 1 |
conduct_or_complaint_that_7 | categorical | — | 93% | 134of 3 |
conduct_or_complaint_that_8 | categorical | — | 93% | 1310of 3 |
conduct_or_complaint_that_9 | categorical | — | 89% | 12of 2 |
conduct_or_complaint_that_10 | categorical | — | 51% | 123of 5 |
date_of_inspection | datetime | — | 0% | 2020-02-07T00:00:00.0002020-03-07T00:00:00.0002022-06-11T00:00:00.000 |
time_of_visitation_hh_mm | text | — | 0% | 10:40:00 PM12:05:00 AM10:30:00 PM |
m_a_r_c_h_inspection | integer | — | 2% | 1of 1 |
inspection_duration_min | integer | — | 0% | 11575100 |
inspectors_from_dep_present | categorical | — | 2% | 02of 2 |
inspectors_from_dob_present | categorical | — | 2% | 20of 2 |
inspectors_from_dohmh_present | categorical | — | 2% | 203of 3 |
inspectors_from_fdny_present | categorical | — | 2% | 20of 2 |
inspectors_from_nypd_present | categorical | — | 0% | 13710of 10 |
total_inspectors_from_city | categorical | — | 0% | 151917of 14 |
summonses_issed_by_dep | categorical | — | 13% | 01of 2 |
summonses_issed_by_dob | categorical | — | 13% | 012of 3 |
summonses_issed_by_dohmh | categorical | — | 2% | 057of 11 |
summonses_issed_by_fdny | categorical | — | 24% | 013of 5 |
summonses_issed_by_nypd | categorical | — | 2% | 021of 5 |
total_summonses_issued_by | categorical | — | 2% | 483of 15 |
closure_of_establishment | boolean | — | 0% | FalseTrueof 2 |
closure_duration_min | categorical | — | 91% | 945427of 5 |
written_notices_pursuant | integer | — | 44% | 1of 1 |