Baselight
Sign In

Predicting The Lottery

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

@kaggle.thedevastator_uncovering_insights_from_us_state_lottery_scratc

Loading...
Loading...

About this Dataset

Predicting The Lottery

Predicting The Lottery

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

By [source]

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
  • 67.06 kB
  • 50 rows
  • 61 columns
Loading... 
CREATE TABLE azratingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.49 kB
  • 50 rows
  • 15 columns
Loading... 
CREATE TABLE azscratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 36.81 kB
  • 564 rows
  • 11 columns
Loading... 
CREATE TABLE azscratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 89.8 kB
  • 105 rows
  • 62 columns
Loading... 
CREATE TABLE caratingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.51 kB
  • 105 rows
  • 15 columns
Loading... 
CREATE TABLE cascratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 80.39 kB
  • 1,447 rows
  • 11 columns
Loading... 
CREATE TABLE cascratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.85 kB
  • 105 rows
  • 10 columns
Loading... 
CREATE TABLE catixlist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 78.37 kB
  • 84 rows
  • 63 columns
Loading... 
CREATE TABLE moratingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.6 kB
  • 84 rows
  • 15 columns
Loading... 
CREATE TABLE moscratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 63.22 kB
  • 1,180 rows
  • 11 columns
Loading... 
CREATE TABLE moscratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 17.03 kB
  • 86 rows
  • 13 columns
Loading... 
CREATE TABLE motixlist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 65.77 kB
  • 50 rows
  • 62 columns
Loading... 
CREATE TABLE nmratingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.42 kB
  • 50 rows
  • 15 columns
Loading... 
CREATE TABLE nmscratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 33.12 kB
  • 518 rows
  • 11 columns
Loading... 
CREATE TABLE nmscratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.6 kB
  • 52 rows
  • 9 columns
Loading... 
CREATE TABLE nmtixlist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 66.72 kB
  • 53 rows
  • 62 columns
Loading... 
CREATE TABLE okratingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.78 kB
  • 53 rows
  • 15 columns
Loading... 
CREATE TABLE okscratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 47.02 kB
  • 804 rows
  • 11 columns
Loading... 
CREATE TABLE okscratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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.36 kB
  • 54 rows
  • 10 columns
Loading... 
CREATE TABLE oktixlist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 77.98 kB
  • 85 rows
  • 61 columns
Loading... 
CREATE TABLE varatingstable (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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 Any Prize + 3 StdDevs,
  "odds_of_profit_prize_3_stddevs" DOUBLE  -- Odds Of Profit Prize + 3 StdDevs,
  "max_tickets_to_buy" DOUBLE,
  "expected_value_of_any_prize_as_of_cost" DOUBLE  -- Expected Value Of Any Prize (as % Of Cost),
  "change_in_expected_value_of_any_prize" DOUBLE,
  "expected_value_of_profit_prize_as_of_cost" DOUBLE  -- Expected Value Of Profit Prize (as % Of Cost),
  "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.47 kB
  • 85 rows
  • 15 columns
Loading... 
CREATE TABLE vascratcherslist (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
  • 58.37 kB
  • 1,022 rows
  • 11 columns
Loading... 
CREATE TABLE vascratchertables (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "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
);

Share link

Anyone who has the link will be able to view this.