Pennsylvania Lottery: Sales, Prizes And Commission

Pennsylvania Annual Summary Data on Ticket Sales, Prizes Paid, and Commissions

@kaggle.msjahid_lottery_sales_and_commissions

Table List

1 table(32.03 KB)

Pa Lottery Commissions Summary

@kaggle.msjahid_lottery_sales_and_commissions.pa_lottery_commissions_summary

32.03 KB
828 rows
9 columns

county_name County Name	state_fiscal_year State Fiscal Year	ticket_sales Ticket Sales	prizes_paid Prizes Paid	retailer_commissions Retailer Commissions	fips_county_code FIPS County Code	latitude Latitude	longitude Longitude	georeferenced_latitude_longitude Georeferenced Latitude \u0026 Longitude
Out Of Country	2018-2019		79759					nan
Bradford	2016-2017	20534654	13155059	1095124	42015	41.79117814	-76.51825624	POINT (-76.51825624 41.79117814)
Lycoming	2015-2016	47812695	30534452	2552885	42081	41.34459792	-77.06942457	POINT (-77.06942457 41.34459792)
Clarion	2012-2013	12014286	7480626	646040	42031	41.19279129	-79.42483608	POINT (-79.42483608 41.19279129)
Cameron	2013-2014	2094372	1879020	128029	42023	41.43880265	-78.20916932	POINT (-78.20916932 41.43880265)
Pike	2013-2014	9139680	7400074	495804	42103	41.332572	-75.03270924	POINT (-75.03270924 41.332572)
Lehigh	2015-2016	98341178	58283473	5184951	42077	40.61464794	-75.60099481	POINT (-75.60099481 40.61464794)
Lebanon	2010-2011	25163421	16879292	1352910	42075	40.367597	-76.46182575	POINT (-76.46182575 40.367597)
Franklin	2016-2017	36685903	25369377	1956555	42055	39.92786197	-77.72398845	POINT (-77.72398845 39.92786197)
Somerset	2015-2016	22655459	14475297	1209546	42111	39.97146299	-79.03100206	POINT (-79.03100206 39.97146299)


CREATE TABLE pa_lottery_commissions_summary (
  "county_name" VARCHAR,
  "state_fiscal_year" VARCHAR,
  "ticket_sales" DOUBLE,
  "prizes_paid" BIGINT,
  "retailer_commissions" DOUBLE,
  "fips_county_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "georeferenced_latitude_longitude" VARCHAR
);