colorado-gov/cigarette-nicotine-products-and-tobacco-products-n4zq-tnn6
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 8 months ago
Indexed 2 hours ago

Cigarette, Nicotine Products, and Tobacco Products Excise Tax Report, 2021 to Date

The Cigarette, Nicotine Products, and Tobacco Products Excise Tax Report summarizes the number of wholesalers and distributors with excise taxes and aggregates the total taxes as reported on Cigarette, Nicotine Products, and Tobacco Products Excise Tax Returns. The data is available monthly for cigarette taxes, and quarterly for nicotine products and tobacco products taxes because Cigarette Excise Tax Returns are filed monthly and Nicotine Products and Tobacco Products Excise Tax Returns are filed quarterly. New data will be added to the report on a quarterly basis.

Because excise taxes are required to be collected by the wholesaler or distributor and not individual retailers, only state-level information is available.

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 \"colorado-gov/cigarette-nicotine-products-and-tobacco-products-n4zq-tnn6\".\"cigarette_nicotine_products_and_tobacco_products\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • cigarette_nicotine_products_and_tobacco_products