cityofnewyork-us/wholesale-markets-87fx-28ei
Icon for Socrata external plugin
 
Readme
Updated 8 hours ago
Indexed 4 hours ago

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

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/wholesale-markets-87fx-28ei\".\"wholesale_markets\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • wholesale_markets
     
Upstream Metadata