From a 500-row sample across 26 columns.
createdbincommunity_board+22createdbincommunity_board+22createdbincommunity_board+22Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| created | bic_number | account_name | address | city | state | postcode | phone | market | application_type | disposition_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-10-14T15:30:09.000 | HPA-514254 | BLUE HERBS, INC. | P.O. BOX 704606 | BRONX | NY | 10474 | 201-682-2666 | dantee@blueherbsinc.com | Adjacent to Hunts Point Market | Public Wholesale Market | 2025-07-03 |
| 2026-10-14T15:30: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% | 2022-09-08T15:30:28.0002020-03-16T15:33:02.0002017-12-22T15:30:12.000 |
bic_number | text | BIC File Number of the Entity | 0% | FFM-124FFM-131FFM-113 |
account_name | text | Name of Entity | 0% | NEW FULTON FISH MARKET C…JOHN W. WILLIAMS, INC.FITZ & PAL FOOD CENTER L… |
trade_name | text | Doing Business As of Entity | 92% | EMERALD FOOD SERVICE CO. |
GET /api/datasets/87fx-28ei GET /api/datasets/87fx-28ei/quality GET /api/datasets/87fx-28ei/related GET /api/columns?dataset=87fx-28ei
createdbincommunity_board+22bincommunity_boardaccount_name+13bincommunity_boardnta+5| HPM-491193 |
| FRIENDLY FOOD PROVISIONS, INC. |
| P.O. BOX 604154 |
| BAYSIDE |
| NY |
| 11360 |
| (917) 701-4847 |
| friendlyfoodprovisions@hotmail.com |
| Hunts Point Meat Market |
| Public Wholesale Market |
| — |
| 2026-10-14T15:30:09.000 | HPA-494737 | ACN TRUCKING CORP | 1373 RANDALL AVENUE | BRONX | NY | 10474 | (718) 402-1774 | anatoli@americanfoodnyc.com | Adjacent to Hunts Point Market | Market Business | — |
| 2026-10-14T15:30:09.000 | HPA-3 | CARIBBEAN PRODUCE INC. | 1360 LAFAYETTE AVE | BRONX | NY | 10474 | (718) 796-2949 | liz@produceny.com | Adjacent to Hunts Point Market | Public Wholesale Market | 2026-08-31 |
| 2026-10-14T15:30:09.000 | BMM-501280 | JACKIE'S APPLES CORP. | 5600 1ST AVENUE UNIT 5A | BROOKLYN | NY | 11220 | (718) 921-1719 | jackiesapplecorp1@gmail.com | Brooklyn Wholesale Meat Market | Public Wholesale Market | — |
| 2026-10-14T15:30:09.000 | BMM-511604 | MIDLAND MEAT TRADE (NY) INC. | 338 JOHNSON AVENUE | BROOKLYN | NY | 11206 | (718) 386-2476 | contact@midland-meat.com | Brooklyn Wholesale Meat Market | Public Wholesale Market | 2023-08-11 |
| 2026-10-14T15:30:09.000 | HPP-507508 | ETHAN PRODUCE CORP. | 13 CEDAR LANE | CLOSTER | NJ | 07624 | 917-217-0024 | adriana.nunez0211@gmail.com | Hunts Point Produce Market | Public Wholesale Market | 2026-03-09 |
| 2026-10-14T15:30:09.000 | HPA-69 | BRONX FREIGHT & FISH CORP. | 1349 EAST BAY AVENUE | BRONX | NY | 10474 | (718) 861-7944 | john@bronxff.com | Adjacent to Hunts Point Market | Public Wholesale Market | 2025-01-16 |
| 2026-10-14T15:30:09.000 | HPP-137 | COOSEMANS NEW YORK INC. | 243 ROW B NEW YORK CITY PRODUCE MARKET | BRONX | NY | 10474 | (718) 328-3060 | charlieb@coosemansny.com | Hunts Point Produce Market | Public Wholesale Market | 2026-02-24 |
| 2026-10-14T15:30:09.000 | FFM-25 | SOUTH STREET SEAFOOD CORP. | 800 FOOD CENTER DRIVE UNIT#51 | BRONX | NY | 10474 | (718) 328-2728 | southstreetseafood@gmail.com | Hunts Point New Fulton Fish Market | Public Wholesale Market | 2026-02-23 |
Showing 12 of 25 columns. All of them are listed below.
S & B FRUITS AND VEGETAB…NYC PRODUCEaddress | text | Mailing address of entity | 0% | 5600 FIRST AVENUE355 FOOD CENTER DRIVE5600 1ST AVENUE |
city | text | Mailing city of entity | 0% | BRONXBROOKLYNNEW YORK |
state | text | Mailing state of entity | 0% | NYNJCT |
postcode | text | Mailing postcode of entity | 0% | 104741122010014 |
phone | phone | Phone number of entity | 1% | (718) 589-7877(718) 991-4700(718) 861-1500 |
email | — | 15% | ttramutola@ajproduce.commei@rubinbros.comepetrino@chefswarehouse.… |
market | categorical | Market that the entity is located within | 0% | Hunts Point Produce Mark…Adjacent to Hunts Point …Hunts Point Meat Marketof 14 |
application_type | text | Type of business the entity is within the market | 0% | Public Wholesale MarketMarket BusinessWholesale Seafood |
disposition_date | date | — | 32% | 2022-07-292022-10-272020-02-04 |
effective_date | date | — | 14% | 2022-04-012019-04-012019-08-01 |
expiration_date | date | — | 14% | 2025-03-312022-03-312022-07-31 |
renewal | boolean | — | 26% | 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 | 41% | 40.80525540.80762940.646985 |
longitude | coordinate | Longitude of mailing address | 41% | -73.876414-73.871471-74.022721 |
community_board | categorical | Community board based on mailing address | 41% | 271of 12 |
council_district | text | Council district based on mailing address | 41% | 17383 |
census_tract | text | Census tract based on mailing address | 41% | 93 93 117 |
bin | text | BIN of mailing address | 41% | 208821521094833255737 |
bbl | text | BBL of mailing address | 41% | 202780007320278105003008190001 |
nta | text | NTA of mailing address | 41% | Hunts PointSunset Park WestWest Village |
boro | categorical | BORO | 44% | BRONXBROOKLYNMANHATTANof 5 |