From a 218-row sample across 27 columns.
longitudestatecouncil_district+7longitudestatecouncil_district+7longitudestatecouncil_district+7statecityMappable — coordinate pair `y_coordinate` / `longitude`.
Open on the map →| dca_license_number | license_status | business_name | dba_trade_name | business_unique_id | darp_enrollment_status | rotow_enrollment_status | building_number | street | city | state | postcode |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0832835-DCA | Active | SCUFFY'S COLLISION INC. | PRO BODIES. | BA-1539279-2022 | Enrolled | Not Enrolled | 7011 | GARFIELD AVE | WOODSIDE | NY | 11377 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
dca_license_number | text | An identification number issued to a business or individual when their license application is approved by DCWP. | 0% | 2134192-DCWP2067407-DCA1157741-DCA |
license_status | text | Indicates the current status of the license. | 0% | Activeof 1 |
business_name | text | The legal business name as filed with the New York State Secretary of State or County Clerk or, if an individual, the person’s first name and last name. | 0% | CLUTCH TOWING INCFINEST AUTOMOTIVE RECOVE…J&J PRESTIGE AUTO COLLIS… |
dba_trade_name | categorical | The "Doing Business As" or "Trade Name" registered with the NYS Department of State. |
GET /api/datasets/q5u8-89nv GET /api/datasets/q5u8-89nv/quality GET /api/datasets/q5u8-89nv/related GET /api/columns?dataset=q5u8-89nv
longitudestatecouncil_district+8longitudecouncil_districtcensus_tract+5| 0832844-DCA |
| Active |
| CASINO TOWING SERVICE INC |
| — |
| BA-1218001-2022 |
| Enrolled |
| Enrolled |
| 7105A |
| AMSTEL BLVD |
| ARVERNE |
| NY |
| 11692 |
| 0832845-DCA | Active | E & L MOTORS CORP. | — | BA-1236453-2022 | Not Enrolled | Not Enrolled | 1062 | UTICA AVE | BROOKLYN | NY | 11203 |
| 0832860-DCA | Active | GENERAL AUTO BODY WORKS, INC. | — | BA-1221764-2022 | Enrolled | Enrolled | 10757 | MERRICK BLVD | JAMAICA | NY | 11433 |
| 0832867-DCA | Active | TRIANGLE AUTO BODY INC. | — | BA-1554754-2022 | Enrolled | Enrolled | 5711 | 79TH AVE | GLENDALE | NY | 11385 |
| 0832915-DCA | Active | GULLOTTA'S AUTO REPAIR, INC. | — | BA-1752878-2025 | Not Enrolled | Not Enrolled | 3737 | 58TH ST | WOODSIDE | NY | 11377 |
| 0832943-DCA | Active | METRO AUTO BODY INC. | — | BA-1467635-2022 | Enrolled | Not Enrolled | 9614 | NORTHERN BLVD | CORONA | NY | 11368 |
| 0833013-DCA | Active | JAMAICA TOWING, INC. | — | BA-1326432-2022 | Enrolled | Not Enrolled | 17028 | JAMAICA AVE | JAMAICA | NY | 11432 |
| 0833037-DCA | Active | jets towing | — | BA-1283984-2022 | Enrolled | Not Enrolled | 918 | E 51ST ST | BROOKLYN | NY | 11203 |
| 0833060-DCA | Active | CASINO AUTO BODY, INC | — | BA-1197753-2022 | Enrolled | Enrolled | 354 | BEACH 72 STREET | FAR ROCKAWAY | NY | 11692 |
Showing 12 of 25 columns. All of them are listed below.
| 91% |
5 Star Auto MallA-STAR TOWINGCITGOof 19 |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. | 0% | BA-1332222-2022BA-1242730-2022BA-1666827-2023 |
darp_enrollment_status | categorical | Indicates if the tow truck company is currently enrolled in the DARP program | 0% | EnrolledNot Enrolledof 2 |
rotow_enrollment_status | categorical | Indicates if the tow truck company is currently enrolled in the ROTOW program | 0% | Not EnrolledEnrolledof 2 |
building_number | text | The building number where the business is located. | 0% | 103216005 |
street | text | The name of the street where the business is located. | 0% | MERRICK BLVDATLANTIC AVEFRESH MEADOW LN |
unit_type | categorical | The type of unit of the business' address. | 99% | FLFRNTof 2 |
unit | text | The unit number of the business' address. | 100% | 1of 1 |
city | text | The city where the business is located. | 0% | BROOKLYNBRONXJAMAICA |
state | text | The state where the business is located. | 0% | NYof 1 |
postcode | text | The ZIP Code where the business is located. | 0% | 111011143310310 |
borough | categorical | The NYC Borough where the business is located. | 0% | QueensBrooklynBronxof 6 |
community_district | text | The NYC Community District where the business is located. | 2% | 412401405 |
council_district | text | The NYC City Council District where the business is located. | 2% | 272631 |
police_precinct | text | Police Precinct where the business is located. | 2% | 103114104 |
bin | text | The Building Identification Number where the business is located. | 3% | 300000040000002000000 |
bbl | text | The Borough-Block-Lot number where the business is located. | 3% | 402699003740904200014068870020 |
nta | text | The Neighborhood Tabulation Area where the business is located. | 2% | QN08SI22QN01 |
census_block_2010_ | text | The 2010 Census Block where the business is located. | 2% | 100020001004 |
census_tract | text | The 2010 Census Tract where the business is located. | 2% | 13302226352 |
latitude | coordinate | The latitudinal coordinate where the business is located. | 2% | 40.71918640.68915840.674709 |
longitude | coordinate | The longitudinal coordinate where the business is located. | 2% | -73.845276-73.837018-73.907096 |
x_coordinate | text | X Coordinate where the business is located | 2% | 101000310294591027159 |
y_coordinate | text | Y Coordinate where the business is located | 2% | 019039301869890185133 |