From a 175-row sample across 18 columns.
binbblnta_code+4address_stbinbbl+2binbblnta_code+4binbbllongitude+1Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| permit_number | expiration_date | status | business_name | address_no | address_st | borough | city | state | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 50142309 | 2026-03-31T00:00:00.000 | Current | MAXIMUM ENVIRONMENTAL MANAGEMENT, INC. | 1170 | LINCOLN AVE | OUTSIDE NYC | HOLBROOK | NY | 11741 | 40.77990564 | -73.08531958 |
| 41684938 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
permit_number | text | Permit number | 0% | 409303025001437041684938 |
expiration_date | datetime | Date the permit expires | 0% | 2024-03-31T00:00:00.0002025-03-31T00:00:00.0002022-03-31T00:00:00.000of 18 |
status | categorical | — | 0% | HistoricalCurrentof 2 |
business_name | text | The legal business name as filed with the New York State Department of State or County Clerk or, if an individual, the person’s first name and last name. | 0% |
GET /api/datasets/v8i9-yfpr GET /api/datasets/v8i9-yfpr/quality GET /api/datasets/v8i9-yfpr/related GET /api/columns?dataset=v8i9-yfpr
bincitystate+5binbbllongitude+2longitudelatitudeborough+1binbbllongitude+2| 2026-03-31T00:00:00.000 |
| Current |
| BARCLAY WATER MANAGEMENT, INC |
| 55 |
| CHAPEL STREET |
| OUTSIDE NYC |
| NEWTON |
| MA |
| 2458 |
| 42.36366598 |
| -71.20170427 |
| 50108146 | 2026-03-31T00:00:00.000 | Current | CHEM-AQUA | 2727 | CHEMSEARCH BLVD | OUTSIDE NYC | IRVING | TX | 75065 | 32.84266885 | -96.92372852 |
| 50045007 | 2026-03-31T00:00:00.000 | Current | CLARITY WATER TECHNOLOGIES, LLC | 50 | N HARRISON AVE STE 10 | OUTSIDE NYC | CLARKSTOWN | NY | 10920 | 41.15380614 | -73.94152121 |
| 41601700 | 2026-03-31T00:00:00.000 | Current | ENRICH PRODUCTS INC | 1018 | PENN AVENUE | OUTSIDE NYC | WILKINSBURG | PA | 15221 | 40.44173699 | -79.87800034 |
| 50064057 | 2026-03-31T00:00:00.000 | Current | FORSYTHE PLUMBING AND HEATING CORP | 1424 | 118TH ST | QUEENS | COLLEGE POINT | NY | 11356 | 40.78507453 | -73.84949713 |
| 50107527 | 2026-03-31T00:00:00.000 | Current | GARRATT-CALLAHAN CO | 50 | INGOLD RD | OUTSIDE NYC | BURLINGAME | CA | 94010 | 37.59514159 | -122.3784458 |
| 40930302 | 2026-03-31T00:00:00.000 | Current | GOTHAM REFINING CHEMICAL CORP | 23-74 | 48TH ST | QUEENS | ASTORIA | NY | 11103 | 40.76612866 | -73.90437688 |
| 50104503 | 2026-03-31T00:00:00.000 | Current | INNOVATIVE WATER CONSULTING LLC | 2999 | COVENTRY LN | OUTSIDE NYC | GREENWOOD | IN | 46143 | 39.57149856 | -86.20783266 |
| 50038533 | 2026-03-31T00:00:00.000 | Current | KLENZOID, INC | 460 | BRIELLE AVE | STATEN ISLAND | STATEN ISLAND | NY | 10314 | 40.59379066 | -74.1354368 |
Showing 12 of 18 columns. All of them are listed below.
GOTHAM REFINING CHEMICAL…NALCO COMPANYMICROMANAGEMENT, INCaddress_no | text | Building number of the business's premise address. | 3% | 50551501 |
address_st | text | Street name of the business's premise address. | 0% | BROADWAYEISENHOWER LANE SOUTH48TH ST |
borough | categorical | Borough where the business is located. | 0% | OUTSIDE NYCQUEENSMANHATTANof 5 |
city | text | City where the business's premise is located. | 0% | LONG ISLAND CITYNEW YORKASTORIA |
state | categorical | State where the business's premise is located. | 0% | NYPAILof 10 |
zipcode | text | Zipcode where the business's premise is located. | 0% | 111011935560148 |
bbl | categorical | Borough-Block-Lot | 58% | 400733007240010400011010150029of 11 |
bin | categorical | Building Identification Number | 58% | 400074910247064013608of 11 |
census_tract_2010 | categorical | Census Tract | 58% | 1190014100100of 11 |
city_council_district | categorical | NYC Council District | 58% | 22263of 7 |
community_district | categorical | Community Board | 58% | 401105402of 8 |
nta_code | categorical | Neighborhood Tabulation Area | 58% | QN70QN31MN17of 11 |
latitude | float | Latitude | 3% | 40.741052840.7661286641.84051809 |
longitude | float | Longitude | 3% | -73.947259-73.90437688-88.02411516 |