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

152.36 KB
14294 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
);

Lottery Cash 4 Life Winning Numbers Beginning 2014

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_cash_4_life_winning_numbers_beginning_2014

40.41 KB
2025 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

287.5 KB
15579 rows
13 columns


CREATE TABLE lottery_daily_numbers_win_4_winning_numbers_beginning_1980 (
  "draw_date" TIMESTAMP,
  "midday_daily" DOUBLE,
  "midday_daily_sum" DOUBLE,
  "evening_daily" BIGINT,
  "evening_daily_sum" DOUBLE,
  "midday_win_4" DOUBLE,
  "midday_win_4_sum" DOUBLE,
  "evening_win_4" DOUBLE,
  "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

48.25 KB
2213 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

52.21 KB
2286 rows
4 columns


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

Lottery Pick 10 Winning Numbers Beginning 1987

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.lottery_pick_10_winning_numbers_beginning_1987

501.73 KB
13316 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.06 KB
1508 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

42.1 MB
1352956 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

11.79 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

183.9 KB
9606 rows
5 columns


CREATE TABLE lottery_take_5_winning_numbers (
  "draw_date" TIMESTAMP,
  "evening_winning_numbers" VARCHAR,
  "evening_bonus" DOUBLE,
  "midday_winning_numbers" VARCHAR,
  "midday_bonus" VARCHAR
);

Nys Lottery Retailers

@kaggle.sujaykapadnis_is_lottery_a_game_of_luck.nys_lottery_retailers

1019.7 KB
14220 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.19 KB
1122 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
);