From a 500-row sample across 25 columns.
borolatitudeapplication_type+22borolatitudeapplication_type+22borolatitudeapplication_type+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:32:09.000 | BIC-4651 | MASTROGIACOMO WASTE INC. | P.O. BOX 691 | SAINT JAMES | NY | 11780 | (516) 650-1044 | reliableamys@aol.com | CL2 - Broker | 2026-07-17 | 2025-06-01 |
| 2026-10-13T15:32: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 | 0% | 2021-12-21T11:45:48.0002021-12-21T11:45:49.0002022-09-08T15:32:11.000 |
bic_number | text | BIC File Number of the Entity | 0% | BIC-4554BIC-4651BIC-3902 |
account_name | text | Name of Entity | 0% | S.L.M. WASTE AND RECYCLI…WASTE MANAGEMENT OF NEW …REPUBLIC SERVICES NATION… |
trade_name | text | Doing Business As of Entity | 89% |
GET /api/datasets/krx7-u82t GET /api/datasets/krx7-u82t/quality GET /api/datasets/krx7-u82t/related GET /api/columns?dataset=krx7-u82t
borolatitudeapplication_type+22latitudeapplication_typeexport_date+13latitudecommunity_boardnta+5| BIC-4253 |
| KETER ENVIRONMENTAL SERVICES, LLC |
| 400 ATLANTIC STREET, SUITE 500 |
| STAMFORD |
| CT |
| 06901 |
| 9142607129 |
| kjeanpierre@wasteharmonics.com |
| CL2 - Broker |
| — |
| 2026-01-01 |
| 2026-10-13T15:32:09.000 | BIC-514654 | APPROVED STORAGE AND WASTE HAULING INC | 110 EDISON AVENUE | MOUNT VERNON | NY | 10550 | (914) 664-4791 | cd@approvedmedwaste.com | CL2 - Broker | 2025-04-24 | 2025-05-01 |
| 2026-10-13T15:32:09.000 | BIC-493187 | ECOTERRA CONSULTING LLC | 10 WILLOW DRIVE | EDISON | NJ | 08820 | (732) 770-6344 | nshah@ecoterrainc.com | CL2 - Broker | — | 2025-09-01 |
| 2026-10-13T15:32:09.000 | BIC-505476 | MATERIALS MANAGEMENT GROUP, LLC | 1000 ENCLAVE WAY | COLUMBIA | SC | 29233 | 801-244-8438 | jamesallen@materialsmanagementgroupllc.com | CL2 - Broker | 2026-08-04 | 2025-01-01 |
| 2026-10-13T15:32:09.000 | BIC-494137 | PROMINENT LOGISTICS INC | P.O BOX 110955 | BROOKLYN | NY | 11211 | (718) 797-3330 | finance@prominentlogistics.com | CL2 - Broker | 2026-09-18 | 2026-01-01 |
| 2026-10-13T15:32:09.000 | BIC-484097 | QUEST RESOURCE MANAGEMENT GROUP, LLC | P.O. BOX 560261 | THE COLONY | TX | 75056 | (972) 464-0004 | questcontracts@questrmg.com | CL2 - Broker | 2026-10-06 | 2025-03-01 |
| 2026-10-13T15:32:09.000 | BIC-512125 | JENACK ENVIRONMENTAL, LLC F/K/A JENACK CONSTRUCTION, LLC | 724 PHEASANT DR | FOREST HILL | MD | 21050 | 410-688-5573 | jen@jenackconstruction.com | CL2 - Broker | — | 2025-06-01 |
| 2026-10-13T15:32:09.000 | BIC-513223 | EASTSIDE BULK LLC | 781 ROUTE 15 S, SUITE 102 | LAKE HOPATCONG | NJ | 07849 | 973-303-1200 | compliance@eastsidebulk.com | CL2 - Broker | 2024-04-17 | 2024-05-01 |
| 2026-10-13T15:32:09.000 | BIC-494003 | AWT ENVIRONMENTAL SERVICES, INC. | 32 BIRCH ST | OLD BRIDGE | NJ | 08857 | (732) 613-1660 | ppostorino@awtenv.com | CL2 - Broker | — | 2026-03-01 |
Showing 12 of 15 columns. All of them are listed below.
BOX AND BOTTLE NYCDRM WASTE MANAGEMENTEARTHWATCH WASTE SYSTEMSaddress | text | Mailing address of entity | 0% | ONE AMERICAN WAY45 PARK PLACE SOUTH #140P.O. BOX 254 |
city | text | Mailing city of entity | 0% | NEW YORKBROOKLYNNEWARK |
state | text | Mailing state of entity | 0% | NYNJPA |
postcode | text | Mailing postcode of entity | 0% | 112300796006095 |
phone | phone | Phone number of entity | 0% | (330) 856-8800(585) 924-9640(972) 464-0004 |
email | — | 11% | kosilka@wm.comlegal@rts.comkmcmahon@awmsi.com |
application_type | date | Class of Trade Waste Application | 0% | CL2 - Broker2018-06-212018-06-22of 4 |
disposition_date | date | — | 42% | 2024-01-042023-06-092022-07-08 |
effective_date | date | — | 11% | 2018-06-012018-05-012022-05-01 |
expiration_date | date | — | 11% | 2020-05-312020-04-302024-04-30 |
renewal | boolean | — | 23% | TrueFalseof 2 |
export_date | datetime | Date data is exported from BIC | 0% | 2021-02-09T00:00:00.0002020-12-09T00:00:00.0002022-07-29T00:00:00.000 |
latitude | coordinate | Latitude of mailing address | 86% | 40.80617740.62308040.624164 |
longitude | coordinate | Longitude of mailing address | 86% | -73.942450-73.965068-73.963844 |
community_board | categorical | Community board based on mailing address | 86% | 561of 14 |
council_district | categorical | Council district based on mailing address | 86% | 44339of 17 |
census_tract | text | Census tract based on mailing address | 86% | 13200534 |
bin | text | BIN of mailing address | 86% | 317127230054431053465 |
bbl | text | BBL of mailing address | 86% | 101722003840283900393003720029 |
nta | text | NTA of mailing address | 86% | MidwoodCarroll Gardens-Columbia…Turtle Bay-East Midtown |
boro | categorical | BORO | 87% | MANHATTANBROOKLYNQUEENSof 16 |