From a 500-row sample across 27 columns.
census_tractexpiration_datecity+22census_tractexpiration_datecity+22census_tractexpiration_datecity+22Mappable — 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:31:08.000 | BIC-511549 | AMBER WASTE OIL LLC | 2363 VALENTINE AVENUE, APT 16 | BRONX | NY | 10458 | (646) 363-9125 | info@amberwasteoil.com | License | 2026-10-05 | 2025-04-01 |
| 2026-10-13T15:31:08.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 | 0% | 2026-08-11T15:31:12.0002022-09-08T15:31:12.0002020-03-16T15:33:56.000 |
bic_number | text | BIC File Number of the Entity | 0% | BIC-1323BIC-4468BIC-280 |
account_name | text | Name of Entity | 0% | CENTURY WASTE SERVICES L…GREEN OIL RECYCLING INC.BESTWAY CARTING INC. |
trade_name | text | Doing Business As of Entity | 83% | INTER-REGIONAL DISPOSAL … |
GET /api/datasets/867j-5pgi GET /api/datasets/867j-5pgi/quality GET /api/datasets/867j-5pgi/related GET /api/columns?dataset=867j-5pgi
census_tractcouncil_districtnta+5cityaddressstatecensus_tractcitypostcode+9| BIC-1181 |
| ACTION CARTING ENVIRONMENTAL SERVICES INC. |
| 300 FRANK W. BURR BLVD, STE. 39 |
| TEANECK |
| NJ |
| 07666 |
| (973) 623-7600 |
| adambrosio@interstatewaste.com |
| License |
| 2025-10-28 |
| 2025-05-01 |
| 2026-10-13T15:31:08.000 | BIC-517457 | PARTNERS INDUSTRIAL SERVICES, INC. | 1020 N MONROE AVE | LINDENHURST | NY | 11757 | (631) 450-2238 | info@partnersindustrialservices.com | License | 2026-05-26 | 2026-06-01 |
| 2026-10-13T15:31:08.000 | BIC-483687 | CLEAN AIR GROUP TRUCKING CORP. | 154-05 12TH AVENUE | WHITESTONE | NY | 11357 | (718) 746-1497 | info@nyccag.com | License | 2026-09-15 | 2025-06-01 |
| 2026-10-13T15:31:08.000 | BIC-515355 | VIBEZ TRUCKING INC. | 24 BENJAMIN PLACE | STATEN ISLAND | NY | 10303 | 7185684644 | juleanchin1@gmail.com | License | 2025-05-30 | 2025-07-01 |
| 2026-10-13T15:31:08.000 | BIC-518569 | ACON CONCRETE CORP. | 6270 60TH ROAD | MASPETH | NY | 11378 | (347) 573-6323 | aconconcretecorp@gmail.com | License | 2026-09-16 | 2026-10-01 |
| 2026-10-13T15:31:08.000 | BIC-3674 | SALCO INDUSTRIES INC. | 621A OCEAN FRONT STREET | LONG BEACH | NY | 11561-4745 | (516) 578-6032 | salcoindustries@gmail.com | License | — | 2026-02-01 |
| 2026-10-13T15:31:08.000 | BIC-3113 | R & C RUBBISH REMOVAL, INC. | 10 MARCONI BLVD | COPIAGUE | NY | 11726 | (631) 608-9099 | office@1866wejunkit.com | License | 2026-07-10 | 2025-05-01 |
| 2026-10-13T15:31:08.000 | BIC-490924 | M&G OPERATING GROUP CORP | 136-44 222ND STREET | JAMAICA | NY | 11413 | (646) 377-7478 | samuelflrs1@gmail.com | License | 2026-09-29 | 2025-09-01 |
| 2026-10-13T15:31:08.000 | BIC-249 | CLASSIC RECYCLING NEW YORK CORP. | 409 RIVER ROAD SUITE #1 | CLIFTON | NJ | 07014 | (973) 777-0600 | office@classicrecycling.com | License | 2026-07-28 | 2025-07-01 |
Showing 12 of 27 columns. All of them are listed below.
TIME SHRED SERVICESPROSHRED SECURITYaddress | text | Mailing address of entity | 0% | 409 RIVER ROAD SUITE #1228 MILLER AVENUE127-50 NORTHERN BLVD |
city | text | Mailing city of entity | 0% | BROOKLYNSTATEN ISLANDBRONX |
state | text | Mailing state of entity | 0% | NYNJCT |
postcode | text | Mailing postcode of entity | 0% | 111011031411378 |
phone | phone | Phone number of entity | 1% | (973) 777-0600(516) 223-2010(718) 456-5000 |
email | — | 13% | office@classicrecycling.…cd@approvedmedwaste.comsleone@thesmartercarter.… |
application_type | date | Class of Trade Waste Application | 0% | LicenseMicro-Hauler License2021-01-31of 7 |
disposition_date | date | — | 54% | 2020-04-132022-02-112024-03-21 |
effective_date | date | — | 13% | 2018-09-012019-05-012019-10-01 |
expiration_date | date | — | 13% | 2020-08-312021-04-302021-09-30 |
renewal | boolean | — | 25% | TrueFalseof 2 |
authorized_recycling_collection_type | categorical | — | 29% | Source-Separated recycli…Single-stream collection…Co-collection of recycla…of 3 |
organic_waste_services_provided | text | — | 88% | Yesof 1 |
export_date | datetime | Date data is exported from BIC | 0% | 2021-02-09T00:00:00.0002020-12-09T00:00:00.0002018-05-31T00:00:00.000 |
latitude | coordinate | Latitude of mailing address | 46% | 40.80745740.76228240.706519 |
longitude | coordinate | Longitude of mailing address | 46% | -73.841955-73.877913-73.898474 |
community_board | categorical | Community board based on mailing address | 46% | 125of 18 |
council_district | text | Council district based on mailing address | 46% | 491930 |
census_tract | text | Census tract based on mailing address | 46% | 93 93449 |
bin | text | BIN of mailing address | 47% | 300000040000005000000 |
bbl | text | BBL of mailing address | 47% | 303685000140182900404036660007 |
nta | text | NTA of mailing address | 46% | Hunters Point-Sunnyside-…East New YorkJamaica |
boro | text | BORO | 49% | QUEENSBROOKLYNSTATEN IS |