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.