Predicting The Lottery by Kaggle | Ecommerce and Consumer Trends

About this Dataset

Predicting The Lottery

US State Lottery History. Impossible To Predict Or Not, Let's try!

About this dataset

This dataset consists of comprehensive data from various U.S. State Lottery Scratcher games in California, Missouri, New Mexico, Oklahoma and Virginia. It contains comprehensive information for researchers to evaluate the probability of winning for each lottery game and any related statistical values associated with each game.
The columns include information such as price, gameNumber, topPrize, overallOdds, topPrizeAvail ExtraChances, secondChance and lots more. Also included is detailed data on Winning Tickets At Start (Regardless if they were claimed or not), Total Prize Money at start alongside Total Prize Money Unclaimed at end date. Users will also find useful odds and probability calculation including Probability of Winning Any Prize + 3 StdDevs alongside Max Tickets To Buy & Expected Value Of Any Prize (as % of cost). Last but certainly not least is information regarding Odds Ranking By Best Probability Of Winning Any Prize all the way to Overall Rank!
Studying this dataset allows players an informed look towards making smarter choices when it comes to taking their chances in using state lotteries – May The Odds be ever in your favor!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

This guide will explain how to use this dataset in detail. It will provide step-by-step instructions on how to interact with and analyze the data contained in this Kaggle dataset so that you can gain insight into your own research or project related to state lottery scratchers!

Understand the Dataset Contents

The contents include price information (e.g., price per play), game name and number, top prize amounts/overall odds/top prize availability/extra chances available/second chance option offered by a particular game as well as date fields indicating when a certain ticket was started/ended/exported etc., different prize amounts available per ticket along with their corresponding probabilities & expected value etc., total prize money at start & total prize money remaining (as %) along with rank according to best probability of winning any type of prize or best change in corresponding probabilities etc.. This detailed information can help an experienced researcher to perform sophisticated analysis on US state lottery tickets’ success rates and effects over time period etc..
In short – understanding what kind of variables are included in this dataset is necessary for analyzing these variables effectively!

Describe each variable & their corresponding categories properly
Describing individual variables will be helpful for users by providing them more detailed insights about those variables & their categories – especially if there are many different types of categories associated within a single variable (like prizes won). Furthermore – some formulae should also be introduced where applicable since users may not understand why certain calculations were done (such as calculating expected value). All such things should be clarified properly via descriptions instead of just listing down numerical values without explaining anything else related to them!

Analyze differences between states using appropriate graphs & diagrams
Data visualization plays an essential role while trying out various

Research Ideas

Analyzing the effectiveness of marketing campaigns for various state lotteries by examining sales of different scractcher tickets.

Examining the lottery scratcher game price points to identify selling opportunities or trends in preferences across states.

Utilizing the data to apply statistics and modeling techniques to project future expected values from similar scratch games across different states

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: CAratingstable.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
Winning Tickets At Start	The percentage of tickets that have already been taken home by other players playing the same game. (Numeric)
Winning Tickets Unclaimed	The percentage of tickets that are still up for grabs. (Numeric)
Photo	A photo of the lottery game ticket. (Image)
FAQ	Frequently asked questions about the lottery game. (Text)
About	Information about the lottery game. (Text)
Directory	A directory of lottery games. (Text)
Data Date
Change in Current Odds of Top Prize	The change in the current odds of winning the top prize in a given lottery game. (Numeric)
Change in Current Odds of Any Prize	The change in the current odds of winning any prize in a given lottery game. (Numeric)
Odds of Profit Prize	The odds of winning a profit prize in a given lottery game. (Numeric)
Starting Odds of Profit Prize	The starting odds of winning a profit prize in a given lottery game. (Numeric)

File: CAscratcherslist.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)

File: CAscratchertables.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
Winning Tickets At Start	The percentage of tickets that have already been taken home by other players playing the same game. (Numeric)
Winning Tickets Unclaimed	The percentage of tickets that are still up for grabs. (Numeric)
gameNumber	Unique identifier for each lottery game. (String)
gameName	Name of the lottery game. (String)
prizeamount	The top prize of each given lottery game. (Numeric)
Prize Probability	Your chances of winning anything in a given scratcher game regardless if you win 1st place or not. (Numeric)
Percent Tix Remaining	The percentage of tickets that are still available for purchase. (Numeric)
Starting Expected Value	The expected value of the game at the start of its validity period. (Numeric)
dateexported	The date the data was exported. (Date)

File: CAtixlist.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameName	Name of the lottery game. (String)
gameNumber	Unique identifier for each lottery game. (String)

File: MOratingstable.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameNumber	Unique identifier for each lottery game. (String)
dateexported	The date the data was exported. (Date)
gameName	Name of the lottery game. (String)
Winning Tickets At Start	The percentage of tickets that have already been taken home by other players playing the same game. (Numeric)
Winning Tickets Unclaimed	The percentage of tickets that are still up for grabs. (Numeric)
Change in Current Odds of Top Prize	The change in the current odds of winning the top prize in a given lottery game. (Numeric)
Change in Current Odds of Any Prize	The change in the current odds of winning any prize in a given lottery game. (Numeric)
Odds of Profit Prize	The odds of winning a profit prize in a given lottery game. (Numeric)
Starting Odds of Profit Prize	The starting odds of winning a profit prize in a given lottery game. (Numeric)
Photo	A photo of the lottery game ticket. (Image)
FAQ	Frequently asked questions about the lottery game. (Text)
About	Information about the lottery game. (Text)
Directory	A directory of lottery games. (Text)
Data Date
Days Since Start	The number of days since the start of a given lottery game. (Numeric)
Rank Average	Average of all

File: MOscratcherslist.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameName	Name of the lottery game. (String)
gameNumber	Unique identifier for each lottery game. (String)
dateexported	The date the data was exported. (Date)

File: MOscratchertables.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameNumber	Unique identifier for each lottery game. (String)
gameName	Name of the lottery game. (String)
prizeamount	The top prize of each given lottery game. (Numeric)
Winning Tickets At Start	The percentage of tickets that have already been taken home by other players playing the same game. (Numeric)
Winning Tickets Unclaimed	The percentage of tickets that are still up for grabs. (Numeric)
Prize Probability	Your chances of winning anything in a given scratcher game regardless if you win 1st place or not. (Numeric)
Percent Tix Remaining	The percentage of tickets that are still available for purchase. (Numeric)
Starting Expected Value	The expected value of the game at the start of its validity period. (Numeric)
dateexported	The date the data was exported. (Date)

File: MOtixlist.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameName	Name of the lottery game. (String)
gameNumber	Unique identifier for each lottery game. (String)

File: NMratingstable.csv

Column name	Description
Price	The cost of each lottery game ticket. (Numeric)
gameNumber	Unique identifier for each lottery game. (String)
dateexported	The date the data was exported. (Date)
gameName	Name of the lottery game. (String)
Winning Tickets At Start	The percentage of tickets that have already been taken home by other players playing the same game. (Numeric)
Winning Tickets Unclaimed	The percentage of tickets that are still up for grabs. (Numeric)
Change in Current Odds of Top Prize	The change in the current odds of winning the top prize in a given lottery game. (Numeric)
Change in Current Odds of Any Prize	The change in the current odds of winning any prize in a given lottery game. (Numeric)
Odds of Profit Prize	The odds of winning a profit prize in a given lottery game. (Numeric)
Starting Odds of Profit Prize	The starting odds of winning a profit prize in a given lottery game. (Numeric)
Photo	A photo of the lottery game ticket. (Image)
FAQ	Frequently asked questions about the lottery game. (Text)
About	Information about the lottery game. (Text)
Directory	A directory of lottery games. (Text)
Data Date
Days Since Start	The number of days since the start of a given lottery game. (Numeric)
Rank Average	Average of all

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Azratingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.azratingstable

65.49 KB
50 rows
61 columns


CREATE TABLE azratingstable (
  "unnamed_0" BIGINT,
  "price" DOUBLE,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "topprizeodds" DOUBLE,
  "overallodds" DOUBLE,
  "topprizeremain" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" VARCHAR,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" BIGINT,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Azscratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.azscratcherslist

13.17 KB
50 rows
15 columns


CREATE TABLE azscratcherslist (
  "unnamed_0" BIGINT,
  "price" DOUBLE,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "topprizeodds" DOUBLE,
  "overallodds" DOUBLE,
  "topprizeremain" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" VARCHAR
);

Azscratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.azscratchertables

35.95 KB
564 rows
11 columns


CREATE TABLE azscratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" VARCHAR
);

Caratingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.caratingstable

87.7 KB
105 rows
62 columns


CREATE TABLE caratingstable (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "overallodds" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" VARCHAR,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "topprizestarting" DOUBLE,
  "topprizeremain" DOUBLE,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "topprizeodds" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" DOUBLE,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Cascratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.cascratcherslist

14.17 KB
105 rows
15 columns


CREATE TABLE cascratcherslist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "overallodds" DOUBLE,
  "topprizestarting" DOUBLE,
  "topprizeremain" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" VARCHAR,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP
);

Cascratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.cascratchertables

78.5 KB
1447 rows
11 columns


CREATE TABLE cascratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" TIMESTAMP
);

Catixlist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.catixlist

19.39 KB
105 rows
10 columns


CREATE TABLE catixlist (
  "unnamed_0" BIGINT,
  "price" DOUBLE,
  "gamename" VARCHAR,
  "gamenumber" DOUBLE,
  "topprize" DOUBLE,
  "startdate" VARCHAR,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "gameurl" VARCHAR,
  "gamephoto" VARCHAR
);

Moratingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.moratingstable

76.53 KB
84 rows
63 columns


CREATE TABLE moratingstable (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "overallodds" DOUBLE,
  "topprizestarting_x" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "lastdatetoclaim" VARCHAR,
  "dateexported" TIMESTAMP,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "topprizestarting_y" DOUBLE,
  "topprizeremain" DOUBLE,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "topprizeodds" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" BIGINT,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Moscratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.moscratcherslist

13.28 KB
84 rows
15 columns


CREATE TABLE moscratcherslist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "overallodds" DOUBLE,
  "topprizestarting" DOUBLE,
  "topprizeremain" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "lastdatetoclaim" VARCHAR,
  "dateexported" TIMESTAMP
);

Moscratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.moscratchertables

61.74 KB
1180 rows
11 columns


CREATE TABLE moscratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" TIMESTAMP
);

Motixlist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.motixlist

16.63 KB
86 rows
13 columns


CREATE TABLE motixlist (
  "unnamed_0" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "price" BIGINT,
  "gameurl" VARCHAR,
  "topprize" BIGINT,
  "startdate" VARCHAR,
  "enddate" VARCHAR,
  "total_prize_money_at_start" DOUBLE,
  "total_prize_money_won" BIGINT,
  "total_prize_money_remaining" BIGINT,
  "percent_of_prize_money_won" DOUBLE,
  "gamephoto" VARCHAR
);

Nmratingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.nmratingstable

64.23 KB
50 rows
62 columns


CREATE TABLE nmratingstable (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "overallodds" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" VARCHAR,
  "lastdatetoclaim" VARCHAR,
  "dateexported" TIMESTAMP,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "topprizestarting" BIGINT,
  "topprizeremain" BIGINT,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "topprizeodds" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" BIGINT,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Nmscratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.nmscratcherslist

12.13 KB
50 rows
15 columns


CREATE TABLE nmscratcherslist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "overallodds" DOUBLE,
  "topprizestarting" BIGINT,
  "topprizeremain" BIGINT,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" VARCHAR,
  "lastdatetoclaim" VARCHAR,
  "dateexported" TIMESTAMP
);

Nmscratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.nmscratchertables

32.35 KB
518 rows
11 columns


CREATE TABLE nmscratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" TIMESTAMP
);

Nmtixlist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.nmtixlist

9.37 KB
52 rows
9 columns


CREATE TABLE nmtixlist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "startdate" TIMESTAMP,
  "overallodds" DOUBLE,
  "gameurl" VARCHAR,
  "gamephoto" VARCHAR
);

Okratingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.okratingstable

65.15 KB
53 rows
62 columns


CREATE TABLE okratingstable (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "overallodds" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "topprizestarting" DOUBLE,
  "topprizeremain" DOUBLE,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "topprizeodds" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" BIGINT,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Okscratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.okscratcherslist

12.48 KB
53 rows
15 columns


CREATE TABLE okscratcherslist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" DOUBLE,
  "overallodds" DOUBLE,
  "topprizestarting" DOUBLE,
  "topprizeremain" DOUBLE,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP
);

Okscratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.okscratchertables

45.92 KB
804 rows
11 columns


CREATE TABLE okscratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" TIMESTAMP
);

Oktixlist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.oktixlist

10.12 KB
54 rows
10 columns


CREATE TABLE oktixlist (
  "unnamed_0" BIGINT,
  "price" DOUBLE,
  "gamename" VARCHAR,
  "gamenumber" DOUBLE,
  "topprize" DOUBLE,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "gameurl" VARCHAR,
  "gamephoto" VARCHAR
);

Varatingstable

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.varatingstable

76.15 KB
85 rows
61 columns


CREATE TABLE varatingstable (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "topprizeodds" BIGINT,
  "overallodds" DOUBLE,
  "topprizeremain" BIGINT,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP,
  "gamename" VARCHAR,
  "winning_tickets_at_start" BIGINT,
  "winning_tickets_unclaimed" BIGINT,
  "total_at_start" DOUBLE,
  "total_remaining" DOUBLE,
  "non_prize_at_start" DOUBLE,
  "non_prize_remaining" DOUBLE,
  "current_odds_of_top_prize" DOUBLE,
  "change_in_current_odds_of_top_prize" DOUBLE,
  "current_odds_of_any_prize" DOUBLE,
  "change_in_current_odds_of_any_prize" DOUBLE,
  "odds_of_profit_prize" DOUBLE,
  "starting_odds_of_profit_prize" DOUBLE,
  "change_in_odds_of_profit_prize" DOUBLE,
  "probability_of_winning_any_prize" DOUBLE,
  "starting_probability_of_winning_any_prize" DOUBLE,
  "change_in_probability_of_any_prize" DOUBLE,
  "probability_of_winning_profit_prize" DOUBLE,
  "starting_probability_of_winning_profit_prize" DOUBLE,
  "change_in_probability_of_profit_prize" DOUBLE,
  "stddev_of_all_prizes" DOUBLE,
  "stddev_of_profit_prizes" DOUBLE,
  "odds_of_any_prize_3_stddevs" DOUBLE,
  "odds_of_profit_prize_3_stddevs" DOUBLE,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE,
  "change_in_expected_value_of_profit_prize" DOUBLE,
  "percent_of_prizes_remaining" DOUBLE,
  "percent_of_profit_prizes_remaining" DOUBLE,
  "ratio_of_decline_in_prizes_to_decline_in_losing_ticket" DOUBLE,
  "photo" VARCHAR,
  "faq" VARCHAR,
  "about" VARCHAR,
  "directory" VARCHAR,
  "data_date" TIMESTAMP,
  "days_since_start" BIGINT,
  "rank_by_best_probability_of_winning_any_prize" DOUBLE,
  "rank_by_best_probability_of_winning_profit_prize" DOUBLE,
  "rank_by_least_expected_losses" DOUBLE,
  "rank_by_most_available_prizes" DOUBLE,
  "rank_by_best_change_in_probabilities" DOUBLE,
  "rank_average" DOUBLE,
  "overall_rank" DOUBLE,
  "rank_by_cost" DOUBLE,
  "stats_page" VARCHAR
);

Vascratcherslist

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.vascratcherslist

14.13 KB
85 rows
15 columns


CREATE TABLE vascratcherslist (
  "unnamed_0" BIGINT,
  "price" BIGINT,
  "gamename" VARCHAR,
  "gamenumber" BIGINT,
  "topprize" BIGINT,
  "topprizeodds" BIGINT,
  "overallodds" DOUBLE,
  "topprizeremain" BIGINT,
  "topprizeavail" VARCHAR,
  "extrachances" VARCHAR,
  "secondchance" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "lastdatetoclaim" TIMESTAMP,
  "dateexported" TIMESTAMP
);

Vascratchertables

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc.vascratchertables

57 KB
1022 rows
11 columns


CREATE TABLE vascratchertables (
  "unnamed_0" BIGINT,
  "gamenumber" BIGINT,
  "gamename" VARCHAR,
  "prizeamount" VARCHAR,
  "winning_tickets_at_start" DOUBLE,
  "winning_tickets_unclaimed" DOUBLE,
  "prize_probability" DOUBLE,
  "percent_tix_remaining" DOUBLE,
  "starting_expected_value" DOUBLE,
  "expected_value" DOUBLE,
  "dateexported" TIMESTAMP
);