From a 500-row sample across 9 columns.
| establishment_record_dba | establishment_record_establishment_street | establishment_record_establishment_zip | establishment_record_establishment_borough | establishment_record_business_sector | establishment_record_establishment_category | establishment_record_actual_opening_date | number_of_employees | establishment_record_type_of_cuisine |
|---|---|---|---|---|---|---|---|---|
| Orchard Grocer Inc | 78 Orchard St | 10002 | Manhattan | Accommodations and Food | Restaurants and Other Eating Places | 2017-02-01T00:00:00.000 | — | — |
| Palermo Salumeria |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
establishment_record_dba | text | — | 0% | Pret A MangerTD BankFIKA |
establishment_record_establishment_street | text | — | 0% | 620 Atlantic Avenue (Loc…445 Gold Street445 Albee Square West |
establishment_record_establishment_zip | text | — | 0% | 100021120111211 |
establishment_record_establishment_borough | categorical | — | 0% | Manhattan |
GET /api/datasets/9b9u-8989 GET /api/datasets/9b9u-8989/quality GET /api/datasets/9b9u-8989/related GET /api/columns?dataset=9b9u-8989
| 33-35 Francis Lewis Blvd |
| 11358 |
| Queens |
| — |
| — |
| — |
| — |
| — |
| Foragers City Grocers | 300 West 22nd Street | 10011 | Manhattan | — | — | — | — | — |
| Cultural Xchange | 35 Lafayette Ave | 11217 | Brooklyn | — | — | — | 3 | — |
| ST. JOHNS CHURCH | 90-37 213 Street | 11428 | Queens | — | — | — | — | — |
| Parm | 248 Mulberry Street | 10012 | Manhattan | — | — | — | — | — |
| Marmar Restaurant | 370 Forest Ave. | 10301 | Staten Island | Accommodations and Food | Restaurants and Other Eating Places | 2017-01-21T00:00:00.000 | — | Mediterranean |
| Celestiano | 562 Halsey Street | 11233 | Brooklyn | — | — | — | 6 | — |
| Obao Cafe (Enfin Cafe) | 38 Water Street | 10004 | Manhattan | Other | — | — | — | — |
| Lucy's Lounge | 475 Third Ave | 11215 | Brooklyn | — | — | — | 10 | — |
BrooklynQueensestablishment_record_business_sector | categorical | — | 24% | Accommodations and FoodRetail TradeHealthcare/Social Assist…of 9 |
establishment_record_establishment_category | text | — | 26% | Restaurants and Other Ea…Drinking Places (Alcohol…Grocery Stores |
establishment_record_type_of_cuisine | text | — | 40% | AmericanCoffee HouseChinese |
number_of_employees | text | — | 26% | 432 |
establishment_record_actual_opening_date | datetime | — | 4% | 2017-06-16T00:00:00.0002012-09-28T00:00:00.0002014-11-01T00:00:00.000 |