Name: Is Lottery A Game Of Luck?
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Is Lottery A Game Of Luck?

Motivation to use this dataset:

Once in our lifetime, we are/were fascinated by the mechanism of the lottery and there was that urge to find out how it all works and whether we can figure out and outsmart all and win big time.

Well, your dream might just come true. I am providing several datasets from NYC with their winning numbers.

Try your luck and figure out if you can find any thread linking altogether.

About Dataset

The Dataset was downloaded from the official site of the NYC dataset site

Tables

Lottery Aid To Education Beginning 2002

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_aid_to_education_beginning_2002

156.01 kB
14,294 rows
5 columns

CREATE TABLE lottery_aid_to_education_beginning_2002 (
  "beginning_fiscal_year" BIGINT,
  "ending_fiscal_year" BIGINT,
  "county" VARCHAR,
  "school_district" VARCHAR,
  "n__amount_of_aid" DOUBLE  -- Amount Of Aid
);

Lottery Cash 4 Life Winning Numbers Beginning 2014

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_cash_4_life_winning_numbers_beginning_2014

41.38 kB
2,025 rows
3 columns

CREATE TABLE lottery_cash_4_life_winning_numbers_beginning_2014 (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR,
  "cash_ball" BIGINT
);

Lottery Daily Numbers Win 4 Winning Numbers Beginning 1980

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_daily_numbers_win_4_winning_numbers_beginning_1980

294.4 kB
15,579 rows
13 columns

CREATE TABLE lottery_daily_numbers_win_4_winning_numbers_beginning_1980 (
  "draw_date" TIMESTAMP,
  "midday_daily" DOUBLE  -- Midday Daily #,
  "midday_daily_sum" DOUBLE,
  "evening_daily" BIGINT  -- Evening Daily #,
  "evening_daily_sum" DOUBLE,
  "midday_win_4" DOUBLE  -- Midday Win 4 #,
  "midday_win_4_sum" DOUBLE,
  "evening_win_4" DOUBLE  -- Evening Win 4 #,
  "evening_win_4_sum" DOUBLE,
  "midday_daily_booster" DOUBLE,
  "evening_daily_booster" DOUBLE,
  "midday_win_4_booster" DOUBLE,
  "evening_win_4_booster" DOUBLE
);

Lottery Mega Millions Winning Numbers Beginning 2002

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_mega_millions_winning_numbers_beginning_2002

49.41 kB
2,213 rows
4 columns

CREATE TABLE lottery_mega_millions_winning_numbers_beginning_2002 (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR,
  "mega_ball" BIGINT,
  "multiplier" DOUBLE
);

Lottery Ny Lotto Winning Numbers Beginning 2001

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_ny_lotto_winning_numbers_beginning_2001

53.46 kB
2,286 rows
4 columns

CREATE TABLE lottery_ny_lotto_winning_numbers_beginning_2001 (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR,
  "bonus" BIGINT  -- Bonus #,
  "extra" DOUBLE  -- Extra #
);

Lottery Pick 10 Winning Numbers Beginning 1987

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_pick_10_winning_numbers_beginning_1987

513.78 kB
13,316 rows
2 columns

CREATE TABLE lottery_pick_10_winning_numbers_beginning_1987 (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR
);

Lottery Powerball Winning Numbers Beginning 2010

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_powerball_winning_numbers_beginning_2010

35.91 kB
1,508 rows
3 columns

CREATE TABLE lottery_powerball_winning_numbers_beginning_2010 (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR,
  "multiplier" DOUBLE
);

Lottery Quick Draw Winning Numbers Beginning 2013

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_quick_draw_winning_numbers_beginning_2013

44.14 MB
1,352,956 rows
5 columns

CREATE TABLE lottery_quick_draw_winning_numbers_beginning_2013 (
  "draw_date" TIMESTAMP,
  "draw_number" BIGINT,
  "draw_time" VARCHAR,
  "winning_numbers" VARCHAR,
  "extra" BIGINT
);

Lottery Sweet Million Winning Numbers 2009–2014 Retired Game

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_sweet_million_winning_numbers_2009_2014_retired_game

12.07 kB
495 rows
2 columns

CREATE TABLE lottery_sweet_million_winning_numbers_2009_2014_retired_game (
  "draw_date" TIMESTAMP,
  "winning_numbers" VARCHAR
);

Lottery Take 5 Winning Numbers

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_take_5_winning_numbers

188.31 kB
9,606 rows
5 columns

CREATE TABLE lottery_take_5_winning_numbers (
  "draw_date" TIMESTAMP,
  "evening_winning_numbers" VARCHAR,
  "evening_bonus" DOUBLE  -- Evening Bonus #,
  "midday_winning_numbers" VARCHAR,
  "midday_bonus" VARCHAR  -- Midday Bonus #
);

Nys Lottery Retailers

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.nys_lottery_retailers

1.04 MB
14,220 rows
10 columns

CREATE TABLE nys_lottery_retailers (
  "retailer" BIGINT,
  "name" VARCHAR,
  "street" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "quick_draw" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "georeference" VARCHAR
);

Scratch Off Game Daily Prize Status Report

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.scratch_off_game_daily_prize_status_report

25.79 kB
1,122 rows
6 columns

CREATE TABLE scratch_off_game_daily_prize_status_report (
  "game_number" BIGINT,
  "game_name" VARCHAR,
  "paid" BIGINT,
  "unpaid" BIGINT,
  "total" BIGINT,
  "prize_amount" VARCHAR
);