From a 500-row sample across 25 columns.
statedisposition_datelongitude+22statedisposition_datelongitude+22statelongitudeaddress+9Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| created | bic_number | account_name | address | city | state | postcode | phone | application_type | disposition_date | effective_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-13T15:33:09.000 | BIC-516531 | FABCO ENTERPRISES, INC. | 52-55 74TH STREET | ELMHURST | NY | 11373 | 718-898-4200 | pm@pernorm.com | CL1 | 2025-12-05 | 2026-01-01 |
| 2026-10-13T15:33:09.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
created | datetime | Timestamp of when data is processed for OpenData s | 0% | 2022-09-08T15:33:10.0002020-03-16T15:35:29.0002025-07-18T15:33:08.000 |
bic_number | text | BIC File Number of the Entity | 0% | BIC-1703BIC-1683BIC-1680 |
account_name | text | Name of Entity | 0% | THE SALVATION ARMYBEST LANDSCAPING & CONST…A.C.P. LANDSCAPING, INC. |
trade_name | text | Doing Business As of Entity | 71% | CARLOS LANDSCAPING |
GET /api/datasets/a8wp-rerh GET /api/datasets/a8wp-rerh/quality GET /api/datasets/a8wp-rerh/related GET /api/columns?dataset=a8wp-rerh
longitudebblcommunity_board+5stateaddresscity| BIC-491121 |
| QG LANDSCAPE INC. |
| 154-10 CROSS ISLAND PKWY |
| WHITESTONE |
| NY |
| 11357 |
| 718-746-5431 |
| peter@qgfloral.com |
| CL1 |
| 2025-08-21 |
| 2025-05-01 |
| 2026-10-13T15:33:09.000 | BIC-504224 | OLIVA LANDSCAPING INC. | 15 WEST HITCHCOCK AVENUE | FLORAL PARK | NY | 11001 | (516) 750-8764 | olivalandscaping2018@gmail.com | CL1 | — | 2026-03-01 |
| 2026-10-13T15:33:09.000 | BIC-492386 | ANGELA G. ESCOBAR | 61 WALNUT ROAD | INWOOD | NY | 11096 | (347) 530-6111 | sandigomez339@gmail.com | CL1 | 2025-09-30 | 2025-06-01 |
| 2026-10-13T15:33:09.000 | BIC-4661 | ALEXANDER LANDSCAPING CORP. | 729 MAGNOLIA DRIVE | FRANKLIN SQUARE | NY | 11010 | (516) 808-7900 | alexanderlandscaping@aol.com | CL1 | 2026-09-25 | 2026-04-01 |
| 2026-10-13T15:33:09.000 | BIC-436 | G&D LANDSCAPING CORP. | 2139 57 STREET | BROOKLYN | NY | 11204 | (718) 256-7600 | angelogallogd@gmail.com | CL1 | 2025-09-19 | 2025-06-01 |
| 2026-10-13T15:33:09.000 | BIC-3412 | S C R LANDSCAPING CORP. | 118 HAIG ROAD | VALLEY STREAM | NY | 11581 | (516) 284-6436 | santocrivas@yahoo.com | CL1 | 2026-01-14 | 2025-10-01 |
| 2026-10-13T15:33:09.000 | BIC-3403 | JUAN A ROMERO LANDSCAPING CORP. | 154 WANSER AVENUE | INWOOD | NY | 11096 | (516) 371-0383 | romero.juan132@gmail.com | CL1 | 2025-10-20 | 2025-09-01 |
| 2026-10-13T15:33:09.000 | BIC-497069 | ALEX F LANDSCAPING & GARDENING INC | 261 MORRIS AVE | INWOOD | NY | 11096 | (516) 239-3062 | victor.flores@icloud.com | CL1 | — | 2026-07-01 |
| 2026-10-13T15:33:09.000 | BIC-505020 | COZUMEL LAWN SPRINKLERS, CORP. | 33-29 110TH STREET | CORONA | NY | 11368 | (718) 651-9268 | cozumellawnsprinklers@yahoo.com | CL1 | — | 2026-10-01 |
Showing 12 of 25 columns. All of them are listed below.
BASSO LANDSCAPINGCOREAS LANDSCAPING ENTER…address | text | Mailing address of entity | 0% | 12 LAGRANGE PLACE2270 STILLWELL AVENUE188 PULASKI AVENUE |
city | text | Mailing city of entity | 0% | STATEN ISLANDBROOKLYNINWOOD |
state | categorical | Mailing state of entity | 0% | NYNJof 2 |
postcode | text | Mailing postcode of entity | 0% | 103141109610306 |
phone | phone | Phone number of entity | 1% | (718) 946-7544(347) 500-3879(347) 276-1381 |
email | — | 15% | lbusiness11096@yahoo.comfred091076@aol.comroseann@mdgardens.com |
application_type | date | Class of Trade Waste Application | 0% | CL12018-06-212018-06-22of 4 |
disposition_date | date | — | 36% | 2022-06-102022-05-202022-06-14 |
effective_date | date | — | 15% | 2018-05-012018-07-012018-04-01 |
expiration_date | date | — | 15% | 2020-04-302020-03-312020-06-30 |
renewal | boolean | — | 29% | TrueFalseof 2 |
export_date | datetime | Date data is exported from BIC | 0% | 2018-01-31T00:00:00.0002021-02-09T00:00:00.0002020-12-09T00:00:00.000 |
latitude | coordinate | Latitude of mailing address | 38% | 40.76155740.62953940.592090 |
longitude | coordinate | Longitude of mailing address | 38% | -73.817731-74.139062-73.984366 |
community_board | categorical | Community board based on mailing address | 38% | 132of 17 |
council_district | text | Council district based on mailing address | 38% | 495051 |
census_tract | text | Census tract based on mailing address | 38% | 10320130302247 |
bin | text | BIN of mailing address | 38% | 411478750250355026636 |
bbl | text | BBL of mailing address | 38% | 405052003650105600525011550153 |
nta | text | NTA of mailing address | 38% | Mariner's Harbor-Arlingt…New Springville-Bloomfie…Port Richmond |
boro | text | BORO | 42% | STATEN ISQUEENSBROOKLYN |