About this Dataset

Winners List Of Texas Lottery® Prizes

List of winner claims for Texas Lottery® prizes with player (excluding identity of those designated anonymous), prize, game and selling retailer information.
GOV'T § 466.411: A prize winner, or owner of a legal entity that is a prize winner, of a lottery prize in an amount equal to $1 million or more may choose to remain anonymous. If the prize is an annuity, then the prize winner may be anonymous for 30 days after the prize is claimed.
Organization: City of Austin
Last updated: 2023-08-25T22:04:59.542578
Tags: all-or-nothing, bingo, cash-five, charitable-bingo, daily-4, draw, education, employee, employees, foundation-school-fund, fund-for-veterans-assistance, gaming, lottery, lotto-texas, mega-millions, pick-3, powerball, scratch-ticket, texas-education, texas-lottery, texas-lottery-commission, texas-two-step, texas-veterans, veterans

Tables

Table 1

@usgov.city_of_austin_winners_list_of_texas_lottery_prizes.table_1

152.88 MB
2,874,995 rows
35 columns

CREATE TABLE table_1 (
  "row_id" VARCHAR,
  "claim_number" BIGINT,
  "amount_won" DOUBLE,
  "date_claim_paid" TIMESTAMP,
  "player_id" DOUBLE,
  "annuity_indicator" VARCHAR,
  "anonymous_indicator" VARCHAR,
  "claim_center_location" VARCHAR,
  "claim_type" VARCHAR,
  "us_citizen_flag" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "claimant_name_and_player_id" VARCHAR,
  "claimant_city" VARCHAR,
  "claimant_state" VARCHAR,
  "claimant_county" VARCHAR,
  "claimant_country" VARCHAR,
  "prize_or_merchandise_indicator" VARCHAR,
  "scratch_ticket_or_draw_game" VARCHAR,
  "date_of_draw" TIMESTAMP,
  "draw_time_of_day" VARCHAR,
  "prize_level" VARCHAR,
  "date_ticket_sold" TIMESTAMP,
  "scratch_ticket_game_number" DOUBLE,
  "scratch_ticket_cost" DOUBLE,
  "retailer_number" DOUBLE,
  "retailer_name" VARCHAR,
  "retailer_number_and_name" VARCHAR,
  "retailer_address_1" VARCHAR,
  "retailer_address_2" VARCHAR,
  "retailer_city" VARCHAR,
  "retailer_state" VARCHAR,
  "retailer_zip_code" DOUBLE,
  "retailer_zip_code_4" DOUBLE  -- Retailer Zip Code +4,
  "retailer_county" VARCHAR
);