From a 500-row sample across 25 columns.
bic_numberapplication_typedisposition_date+22bic_numberapplication_typedisposition_date+22binlongitudelatitude+5Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| created | bic_number | account_name | address | city | state | postcode | phone | application_type | effective_date | expiration_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-14T15:34:08.000 | BIC-509396 | VALIANT CONTRACTING LLC | 226 PROSPECT POINT ROAD | LAKE HOPATCONG | NJ | 07849 | (973) 234-5668 | trucks@valiantnj.com | CL2 - Exempt | 2026-09-01 | 2028-08-31 |
| 2026-10-14T15:34: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% | 2022-09-08T15:34:12.0002020-03-16T15:36:19.0002017-12-22T15:34:44.000 |
bic_number | text | BIC File Number of the Entity | 0% | BIC-4350BIC-1350BIC-1072 |
account_name | text | Name of Entity | 0% | METRO GENERAL CONTRACTIN…MASPETH GENERAL CONTRACT…ALASIA WASTE REMOVAL INC… |
trade_name | text | Doing Business As of Entity | 89% | J AND D TRUCKING OF NEW … |
GET /api/datasets/cspg-yi7g GET /api/datasets/cspg-yi7g/quality GET /api/datasets/cspg-yi7g/related GET /api/columns?dataset=cspg-yi7g
binlongitudelatitude+9binlongitudelatitude+5community_boardstatecityaddressbinstatecommunity_board+1| BIC-516035 |
| PRO INDUSTRIES TWO INC. |
| 31 SPENCER STREET SUITE 101 |
| BROOKLYN |
| NY |
| 11205 |
| 718-388-5800 |
| proindustriestwo@gmail.com |
| CL2 - Exempt |
| 2026-02-01 |
| 2028-01-31 |
| 2026-10-14T15:34:08.000 | BIC-485088 | LAWS CONSTRUCTION CORP | 34 IRVINGTON ST. | PLEASANTVILLE | NY | 10570 | (914) 741-2100 | jvescio@lawscc.com | CL2 - Exempt | 2025-09-01 | 2027-08-31 |
| 2026-10-14T15:34:08.000 | BIC-518362 | JEREMY EXPRESS LIMITED LIABILITY COMPANY | 35 SPRINGFIELD AVENUE | NEWARK | NJ | 07107 | 9737044188 | jeremyexpress09@gmail.com | CL2 - Exempt | 2026-10-01 | 2028-09-30 |
| 2026-10-14T15:34:08.000 | BIC-3872 | T.Z. BROTHERS GENERAL CONTRACTORS, INC. | 6808 13TH AVENUE 1F | BROOKLYN | NY | 11219 | (718) 331-5853 | leotzbros@gmail.com | CL2 - Exempt | 2025-10-01 | 2027-09-30 |
| 2026-10-14T15:34:08.000 | BIC-485073 | A & V ENTERPRISE, INC. | 34 TYNDALE PL | YONKERS | NY | 10701 | (914) 469-8940 | avtruckone@gmail.com | CL2 - Exempt | 2025-04-01 | 2027-03-31 |
| 2026-10-14T15:34:08.000 | BIC-514150 | D R V XPRESS LLC | P.O BOX 337 | HILLSIDE | NJ | 07205 | (908) 875-9829 | drvxpressllc@gmail.com | CL2 - Exempt | 2025-07-01 | 2027-06-30 |
| 2026-10-14T15:34:08.000 | BIC-2830 | BRANDENBURG INDUSTRIAL SERVICE COMPANY | 501 W. LAKE STREET, SUITE 204 | ELMHURST | IL | 60126 | (312) 326-5800 | email@brandenburg.com | CL2 - Exempt | 2026-07-01 | 2028-06-30 |
| 2026-10-14T15:34:08.000 | BIC-511782 | FERRAN CONTRACTING CORP. | 98 GAZZA BLVD | FARMINGDALE | NY | 11735 | (631) 301-3980 | office@ferrancontracting.com | CL2 - Exempt | 2025-05-01 | 2027-04-30 |
| 2026-10-14T15:34:08.000 | BIC-2279 | JDJ TRUCKING CORP. | P.O. BOX 575025 | WHITESTONE | NY | 11357 | (718) 746-0714 | jdjtruckingcorp1@gmail.com | CL2 - Exempt | 2025-09-01 | 2027-08-31 |
Showing 12 of 24 columns. All of them are listed below.
JC TANPORTABCO FACILITY MAINTENANC…address | text | Mailing address of entity | 0% | 1818 FALMOUTH AVENUE58-83 54TH STREET95-11 147 PLACE |
city | text | Mailing city of entity | 0% | BROOKLYNSTATEN ISLANDBRONX |
state | categorical | Mailing state of entity | 0% | NYNJCTof 14 |
postcode | text | Mailing postcode of entity | 0% | 113781135710314 |
phone | phone | Phone number of entity | 1% | (718) 378-2600(516) 352-7868(646) 434-9737 |
email | — | 14% | zalman54@gmail.comCL2 - Exemptacostanza226@gmail.com |
application_type | date | Class of Trade Waste Application | 0% | CL2 - Exempt2018-06-222018-06-26of 8 |
disposition_date | date | — | 49% | 2022-07-292023-10-272023-09-13 |
effective_date | date | — | 14% | 2018-06-012018-04-012018-07-01 |
expiration_date | date | — | 14% | 2020-05-312020-03-312020-06-30 |
renewal | boolean | — | 27% | 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 | 39% | 40.71808140.80922940.649409 |
longitude | coordinate | Longitude of mailing address | 39% | -73.911201-73.914897-73.892749 |
community_board | categorical | Community board based on mailing address s | 39% | 127of 18 |
council_district | text | Council district based on mailing address | 39% | 195030 |
census_tract | text | Census tract based on mailing address | 39% | 93226 93 |
bin | text | BIN of mailing address | 40% | 500000040000003000000 |
bbl | text | BBL of mailing address | 40% | 308119005320276800234100280001 |
nta | text | NTA of mailing addres | 39% | WhitestoneMaspethHunters Point-Sunnyside-… |
boro | text | BORO | 43% | QUEENSBROOKLYNSTATEN IS |