From a 500-row sample across 30 columns.
statelongitudecity+4statelongitudecity+4statelongitudecity+4address_typedba_trade_namebusiness_category+9Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| certificate_of_inspection | inspection_number | date_of_occurance | business_unique_id | business_name | business_category | inspection_type | device_category | device_class | device_type | devices_inspected | devices_approved |
|---|---|---|---|---|---|---|---|---|---|---|---|
| A0126762 | INS-000650749 | 2023-07-03T00:00:00.000 | BA-1519222-2022 | THE KOSHER GARDEN INC. | Supermarket - 819 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 2 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
certificate_of_inspection | text | An identification number assigned to track DCWP inspections at a business. | 0% | A0264640A0142168A0278178 |
inspection_number | text | An identification number assigned to an inspection of a business. | 0% | INS-000922855INS-000947830INS-000681734 |
date_of_occurance | datetime | The date the inspection was conducted. | 0% | 2026-04-22T00:00:00.0002026-05-20T00:00:00.0002026-04-14T00:00:00.000 |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. | 0% |
GET /api/datasets/8fei-z6rz GET /api/datasets/8fei-z6rz/quality GET /api/datasets/8fei-z6rz/related GET /api/columns?dataset=8fei-z6rz
address_typestatedba_trade_name+12| 2 |
| A0126767 | INS-000650470 | 2023-07-03T00:00:00.000 | BA-1543123-2022 | The Stop & Shop Supermarket Company LLC | Supermarket - 819 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 1 | 1 |
| A0126771 | INS-000650580 | 2023-07-03T00:00:00.000 | BA-1521873-2022 | VICTORINO LAUNDROMAT & DRY CLEANER INC | Retail Laundry | Scale | Scale | Laundry Scales | Platform Scale - 02 | 1 | 1 |
| A0126776 | INS-000651286 | 2023-07-03T00:00:00.000 | BA-1667935-2023 | CATON DELI & LUNCHEONETTE CORP. | Grocery-Retail - 808 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 1 | 1 |
| A0126778 | INS-000651288 | 2023-07-03T00:00:00.000 | BA-1431248-2022 | MY GOLAN INC. | Grocery-Retail - 808 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 2 | 2 |
| A0126785 | INS-000651301 | 2023-07-03T00:00:00.000 | BA-1600129-2023 | DREAM GOURMET DELI INC | Grocery-Retail - 808 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 1 | 1 |
| A0126795 | INS-000651313 | 2023-07-03T00:00:00.000 | — | GLENDA FOOD CORP. | Supermarket - 819 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 13 | 13 |
| A0126797 | INS-000651318 | 2023-07-03T00:00:00.000 | BA-1428223-2022 | PARADISE LAUNDROMAT INC | Retail Laundry | Scale | Scale | Laundry Scales | Platform Scale - 02 | 1 | 1 |
| A0126804 | INS-000651326 | 2023-07-03T00:00:00.000 | BA-1451676-2022 | MANNIX FAMILY MARKET @ HYLAN BLVD LLC | Supermarket - 819 | Scale | Scale | Scale Inspection | Computing Scale - 01 | 59 | 59 |
| A0126806 | INS-000651328 | 2023-07-03T00:00:00.000 | BA-1431425-2022 | NEPTUNE FUEL STOP INC | Gas Station-Retail - 815 | WAM - Petroleum | Gas Station | Gas Pumps | Octane Sample | 4 | 0 |
Showing 12 of 28 columns. All of them are listed below.
BA-1545133-2022BA-1105443-2022BA-1766980-2026 |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk. | 0% | BOLLA OPERATING CORP.SPEEDWAY LLCSPRAGUE OPERATING RESOUR… |
dba_trade_name | text | If applicable, the Doing-Business-As (DBA), or trade name of the business. | 73% | BPMOBILSHELL |
business_category | text | The business activity or business category requiring a DCWP-issued license in order to operate legally within NYC. | 0% | Grocery-Retail - 808Gas Station-Retail - 815Supermarket - 819 |
inspection_type | categorical | The type of inspection being conducted. | 0% | ScaleWAM - PetroleumWAM - Otherof 5 |
device_category | categorical | The category of the test being performed. | 0% | ScaleGas StationFuel Oilof 5 |
device_class | categorical | The class of device, usually for specific business categories. | 0% | Scale InspectionGas PumpsLaundry Scalesof 9 |
device_type | text | The type of device, usually has certain capacity limits. | 0% | Computing Scale - 01Petrol Pump BlendOctane Sample |
devices_inspected | integer | The total number of devices inspected or measurements taken. | 0% | 123 |
devices_approved | integer | The number of devices or measurements that passed inspection. | 0% | 120 |
devices_condemned_confiscated | categorical | The number of devices or measurements that did not pass inspection. | 0% | 021of 7 |
address_type | categorical | The type of address where the inspection was conducted. | 0% | Complete AddressCross Street (Intersecti…Place (Landmark)of 3 |
building_no | text | The building number where the inspection was conducted. | 1% | 2451200 |
street_1 | text | The name of the street where the inspection was conducted. | 0% | MESEROLE AVEBROADWAYMESEROLE AVENUE |
street_2 | text | The name of the cross street where the inspection was conducted. | 99% | WEST 67 STREETEAST 72 STREETUNION SQUARE WEST |
unit_type | categorical | The type of unit where the inspection was conducted. | 98% | STEFRNTAPTof 10 |
apt_suite | text | The unit number where inspection was conducted. | 98% | 1A2 |
city | text | The city where the inspection was conducted. | 0% | BROOKLYNNEW YORKBRONX |
state | categorical | The state where the inspection was conducted. | 0% | NYNJCAof 6 |
zip_code | text | The ZIP Code where the inspection was conducted. | 0% | 112221136811385 |
borough | categorical | The NYC Borough where the inspection was conducted. | 0% | BrooklynQueensManhattanof 6 |
community_district | text | The NYC Community District where the inspection was conducted. | 0% | 301401412 |
city_council_district | text | The NYC City Council District where the inspection was conducted. | 0% | 332622 |
bin | text | The Building Identification Number where inspection was conducted. | 2% | 306544240000003000000 |
bbl | text | The Borough-Block-Lot number where the inspection was conducted. | 2% | 302604000140092600012027390001 |
nta | text | The Neighborhood Tabulation Area where inspection was conducted. | 3% | BK76QN31QN70 |
latitude | float | The latitudinal coordinate where the inspection was conducted. | 0% | 40.7292320040.7292319140.77303200 |
longitude | float | The longitudinal coordinate where the inspection was conducted. | 0% | -73.94616800-73.94616813-73.97828300 |