Restricted Flavored Tobacco Products

A list of flavored tobacco products that may not be sold within 500 feet of a school in Chicago. See http://www.cityofchicago.org/content/dam/city/depts/cdph/policy_planning/Board_of_Health/FlavoredTobaccoRules_Final_Dec112015.pdf for the specifics of the regulation. This list will be updated periodically. A list of tobacco flavor terms that may be used to determine if a product is flavored is available at https://data.cityofchicago.org/d/fkci-tsq8.

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 \"cityofchicago/restricted-flavored-tobacco-products-5wce-bks2\".\"restricted_flavored_tobacco_products\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.