Fine Wine & Good Spirits Retail Stores Sales by County, Annual, FY 2016-17 to Current, Liquor Control Board
This dataset contains dollar sales by county for Fine Wine & Good Spirits retail stores for fiscal years 2016-17, 2017-18 and 2018-19 (July 1 through June 30). Dollar amounts reflect sales of wine, spirits and accessories, including the 18% liquor tax, but excluding state and local sales taxes. Dollar amounts include sales to individual consumers and licensees transacted at all retail locations open during a fiscal year, but exclude sales from licensee service centers and FWGS.com; licensee wholesale transactions taking place outside of retail stores; and Lottery ticket sales.
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 \"pa-gov/fine-wine-good-spirits-retail-stores-sales-by-fhz7-8ncd\".\"fine_wine_good_spirits_retail_stores_sales_by\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.