From a 500-row sample across 45 columns.
_4_option4_4_option3location+15council_districtcommunity_boardbin+3longitudelatitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| uniqueid | inspectionid | inspectiondate | businessname | typeofbusiness | borough | location | question1 | question2 | question3 | question4 | _4_option4 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 1 | 2013-04-24T00:00:00.000Z | Chateau Drug & Homecare | Pharmacy | Manhattan | 181 Amsterdam Avenue 10023 | Yes | Yes | Yes | No | Yes |
| 3 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
uniqueid | integer | Unique Identifier of Establishments | 0% | 397128642758 |
inspectionid | integer | Unique Identifier of Inspection | 0% | 342754849848194 |
inspectiondate | datetime | Inspection Date | 0% | 2018-09-26T00:00:00.000Z2017-08-11T00:00:00.000Z2014-12-30T00:00:00.000Z |
businessname | text | Name of Business | 0% | Domino'sSubwayDomino's Pizza |
GET /api/datasets/tg3t-nh4h GET /api/datasets/tg3t-nh4h/quality GET /api/datasets/tg3t-nh4h/related GET /api/columns?dataset=tg3t-nh4h
longitudelatitudeborough| 2013-04-24T00:00:00.000Z |
| Gina la Fornarina |
| Food Establishment |
| Manhattan |
| 279 Amsterdam Avenue 10023 |
| Yes |
| No |
| Yes |
| No |
| — |
| 4 | 3 | 2013-04-24T00:00:00.000Z | Andy's Deli | Food Establishment | Manhattan | 295 Amsterdam Avenue 10023 | Yes | No | Yes | Yes | — |
| 5 | 4 | 2013-04-24T00:00:00.000Z | Freddie & Peppers | Food Establishment | Manhattan | 303 Amsterdam Avenue 10023 | Yes | No | Yes | No | Yes |
| 6 | 5 | 2013-04-24T00:00:00.000Z | Grand Sichuan 74 | Food Establishment | Manhattan | 307 Amsterdam Avenue 10023 | Yes | No | Yes | Yes | — |
| 7 | 6 | 2013-04-24T00:00:00.000Z | Fusha | Food Establishment | Manhattan | 311 Amsterdam Avenue 10023 | Yes | Yes | Yes | No | — |
| 11 | 7 | 2013-05-01T00:00:00.000Z | The Vitamin Peddler Inc | Other (Please specify) | Manhattan | 364 Amsterdam Avenue 10024 | Yes | No | Yes | No | — |
| 13 | 8 | 2013-05-01T00:00:00.000Z | Planet Sushi | Food Establishment | Manhattan | 380 Amsterdam Avenue 10024 | Yes | Yes | Yes | Yes | — |
| 14 | 9 | 2013-05-01T00:00:00.000Z | Bagels & Co. | Food Establishment | Manhattan | 391 Amsterdam Avenue 10024 | Yes | No | Yes | Yes | — |
| 1481 | 10 | 2013-04-30T00:00:00.000Z | Insomnia Cookies | Food Establishment | Manhattan | 1579 2 Avenue 10028 | Yes | No | Yes | Yes | — |
Showing 12 of 37 columns. All of them are listed below.
typeofbusiness |
| categorical |
| Type of Business |
| 0% |
Food EstablishmentOther (Please specify)Groceryof 4 |
borough | categorical | Borough | 0% | ManhattanBrooklynQueensof 4 |
location | address | Location | 0% | 77 Pearl Street 10004764 9 Avenue 10019754 10 Avenue 10019 |
question1 | categorical | Does the commercial establishment deliver using a bicycle? | 0% | YesNoof 2 |
question2 | categorical | Does business have proper and complete roster? | 0% | YesNoof 2 |
_2_option1 | text | No roster | 91% | Yesof 1 |
_2_option2 | text | Inadequate Roster (Please specify) | 100% | Yesof 1 |
_2_ticketnumber | text | Unique Identifier of Ticket | 91% | 1-000006-05202014-462009…1-000008-03192014-467998…1-000011-05012013-107164… |
_2_novcode | categorical | Unique Code of NOV | 91% | DF5DF6DF4of 4 |
_2_novnumber | text | Unique Identifier of NOV | 91% | 157146200180306015180306024 |
question3 | categorical | Does business have proper commercial bicyclist safety poster? | 0% | YesNoof 2 |
_3_option1 | text | No poster | 98% | Yesof 1 |
_3_option2 | text | Inaccurate/Missing information on poster (Please specify) | 100% | Yesof 1 |
_3_ticketnumber | text | Unique Identifier of Ticket | 98% | 1-000013-06302015-491870…1-000072-04042016-583914…1-000073-03202014-416693… |
_3_novcode | categorical | Unique Code of NOV | 98% | DF9DG1Df9of 3 |
_3_novnumber | text | Unique Identifier of NOV | 98% | 180306217180830302180830421 |
question4 | categorical | Is commercial delivery bicycle properly equipped? | 0% | YesNoof 2 |
_4_option1 | text | No headgear | 95% | Yesof 1 |
_4_option2 | text | Unsuitable headgear | 100% | Yesof 1 |
_4_option3 | text | No upper apparel | 95% | Yesof 1 |
_4_option4 | text | Inadequate upper apparel (Please specify) | 98% | Yesof 1 |
_4_option5 | text | No Bicyclist identification card | 98% | Yesof 1 |
_4_option6 | text | Improper identification card (Please specify) | 100% | Yesof 1 |
_4_ticketnumber | text | Unique Identifier of Ticket | 90% | 1-000004-06292015-488398…1-000004-08082019-557475…1-000004-10162015-536413… |
_4_novcode | categorical | Unique Code of NOV | 90% | DF3DF4DF6of 3 |
_4_novnumber | text | Unique Identifier of NOV | 90% | 157580324180306152180306208 |
question5 | categorical | Are bicycles properly equipped? | 0% | YesNoof 2 |
_5_option1 | text | No metal or plastic sign | 100% | Yesof 1 |
_5_option2 | text | Improper metal or plastic sign (Please specify) | 100% | Yesof 1 |
_5_option3 | text | No lamp | 97% | Yesof 1 |
_5_option4 | text | No audible device | 97% | Yesof 1 |
_5_option5 | text | Inadequate audible device (Please specify) | 100% | Yesof 1 |
_5_option6 | text | No brakes | 100% | Yesof 1 |
_5_option7 | text | No reflective tires or reflex reflectors | 98% | Yesof 1 |
_5_ticketnumber | text | Unique Identifier of Ticket | 95% | 1-000192-05182013-107165…1-000010-03192014-501808…1-00003-04242013-1071649… |
_5_novcode | categorical | Unique Code of NOV | 95% | DF7DF8DF5of 5 |
_5_novnumber | text | Unique Identifier of NOV | 95% | 180220226180306033180306060 |
complaintnumber | categorical | Complaint Number | 100% | 123456789125326325206276400of 4 |
postcode | text | Zipcode where the site is located | 0% | 100031001610025 |
latitude | float | Latitude of the site's location | 0% | 40.70395440.76263140.74369 |
longitude | float | Longitude of the site's location | 0% | -74.010297-73.988909-73.988465 |
community_board | integer | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. | 0% | 108104106 |
council_district | integer | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 0% | 324 |
bin | integer | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. | 1% | 100000040000003000000 |
bbl | integer | The BBL (Borough, Block, and Lot) is a combination of three numeric codes - a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes | 1% | 100765000110015000151001490003 |
census_tract_2020_ | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. | 0% | 3818321 |
neighborhood_tabulation_area_nta_2020_ | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 0% | MN0303MN0402MN0801 |