Lottery Sales, Prizes, Commissions SFY 2010 - Current Annual County Revenue
This dataset contains Pennsylvania Lottery summary data for total ticket sales, prizes paid and retailer commissions, by county, for the State Fiscal year beginning 7/1/2010 and adding in each year as it becomes available. This information, with the exception of sales by county, is also available on the Pennsylvania Lottery’s Official Website.
More information about Sales, Profits, and Economic & Benefits Impact Reports: Pennsylvania Lottery Annual Sales & Benefit Reports.
PA Department of Revenue website: https://www.palottery.state.pa.us (or https://www.palottery.com).
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/lottery-sales-prizes-commissions-sfy-2010-current-hymg-bws9\".\"lottery_sales_prizes_commissions_sfy_2010_current\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.