About this Dataset

Wholesale Markets

Dataset notating the approved wholesale market companies in the various markets BIC regulates. Companies as of the most recent export date are authorized to operate as a wholesale market company.

This data is collected on the entities that apply with the Commission to operate as wholesale market companies throughout the City of New York

Each record represents an entity that is approved to operate in the City of New York by the Commission.

The BIC Number field is unique to every company that applies to the Commission. For wholesale market companies, the beginning letters indicate the market for which the company is located:

HPA - Hunts Point Adjacent Area
HPP - Hunts Point Product Market
HPM - Hunts Point Meat Market
FFM - Hunts Point Fulton Fish Market
GMM - Gansevoort Meat Market
Organization: City of New York
Last updated: 2020-11-10T17:01:17.769922
Tags: bic, brooklyn, business-integrity-commission, fish, gansevoort, hunts-point, meat, nycbic, produce, wholesale-markets

Tables

Table 1

@usgov.city_of_new_york_wholesale_markets_4108f.table_1

117.65 kB
28,396 rows
26 columns

CREATE TABLE table_1 (
  "created" TIMESTAMP,
  "bic_number" VARCHAR,
  "account_name" VARCHAR,
  "trade_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "market" VARCHAR,
  "application_type" VARCHAR,
  "disposition_date" VARCHAR,
  "effective_date" VARCHAR,
  "expiration_date" VARCHAR,
  "renewal" VARCHAR,
  "export_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "boro" VARCHAR
);