Lottery Sales, Prizes, Commissions SFY 2010 - Current Annual County Revenue
data.pa.gov | Last Updated 17 Oct 2022This 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).
This dataset has the following 9 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
County Name | county | text | Physical county in Pennsylvania, as determined by retailer sites and sales location. | Adams Allegheny Armstrong Beaver Bedford view top 100 |
State Fiscal Year | federal_fiscal_year | text | Pennsylvania State Fiscal Year runs from July 1st - June 30th. | 2012-2013 2016-2017 2019-2020 2014-2015 2021-2022 view top 100 |
Ticket Sales | ticket_sales | number | Net sales of tickets in the county. | 33324576 14325583 2331246 68061711 95756359 view top 100 |
Prizes Paid | prizes_paid | number | Sum of all tickets actually paid in each county; the claim location is not the same as the sales location, and prizes claimed at Lottery Headquarters are sourced to Dauphin County. | 3478456 32656052 7983150 73012707 9917851 view top 100 |
Retailer Commissions | retailer_commissions | number | Actual amount of money applied to a retailer’s account based on tickets sold, this includes bonus commissions and other amounts granted by regulation. | 5788206 335329 509812 992577 22336604 view top 100 |
FIPS County Code | fips_county_code | text | This is a 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html | 42069 42067 42089 42091 42131 view top 100 |
Latitude | latitude | text | Latitude coordinates in degrees for a centroid point for geographic area. | 40.61464794 41.77333834 41.42819416 41.40341259 40.49127491 view top 100 |
Longitude | longitude | text | Longitude coordinates in degrees for a centroid point for geographic area. | -76.01813003 -75.11291241 -78.64947713 -78.71894174 -79.00101814 view top 100 |
Georeferenced Latitude & Longitude | geocoded_column | point | Georeferenced column as a point used for creating visuals such as maps. A generic point for reach county is supplied so a map can be created. | {"coordinates":[-75.60099481,40.61464794],"type":"Point"} {"coordinates":[-78.71894174,40.49127491],"type":"Point"} {"coordinates":[-75.61218345,41.43910064],"type":"Point"} {"coordinates":[-80.22943817,39.85480393],"type":"Point"} {"coordinates":[-75.140236,40.00444354],"type":"Point"} view top 100 |