Lottery Sales, Prizes, Commissions SFY 2010 - Current Annual County Revenue

data.pa.gov | Last Updated 12 Mar 2020

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).

Tags: lottery, lotto, ticket, sales, prizes, commission, retailer, dor, revenue

This dataset has the following 9 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
County NamecountytextPhysical county in Pennsylvania, as determined by retailer sites and sales location.
State Fiscal Yearfederal_fiscal_yeartextPennsylvania State Fiscal Year runs from July 1st - June 30th.
Ticket Salesticket_salesnumberNet sales of tickets in the county.
Prizes Paidprizes_paidnumberSum 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.
Retailer Commissionsretailer_commissionsnumberActual amount of money applied to a retailer’s account based on tickets sold, this includes bonus commissions and other amounts granted by regulation.
FIPS County Codefips_county_codetextThis 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/geo/reference/codes/cou.html
LatitudelatitudetextLatitude coordinates in degrees for a centroid point for geographic area.
LongitudelongitudetextLongitude coordinates in degrees for a centroid point for geographic area.
Georeferenced Latitude & Longitudegeocoded_columnpointGeoreferenced 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.