About this Dataset

Texas Lottery® Sales By Fiscal Month/Year, Game And Retailer

Texas Lottery® sales by fiscal month/year, game and retailer with identifying information. DISCLOSURE: This information is not audited sales and reflects unadjusted sales data.
Organization: City of Austin
Last updated: 2023-08-25T22:32:44.620607
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_texas_lottery_sales_by_fiscal_month_yea_b87e0803.table_1

528.69 MB
40,517,406 rows
30 columns

CREATE TABLE table_1 (
  "row_id" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_month" BIGINT,
  "fiscal_month_name_and_number" VARCHAR,
  "calendar_year" BIGINT,
  "calendar_month" BIGINT,
  "calendar_month_name_and_number" VARCHAR,
  "month_ending_date" TIMESTAMP,
  "game_category" VARCHAR,
  "scratch_game_number" DOUBLE,
  "ticket_price" DOUBLE,
  "retailer_license_number" BIGINT,
  "retailer_location_name" VARCHAR,
  "retailer_number_and_location_name" VARCHAR,
  "retailer_location_address_1" VARCHAR,
  "retailer_location_address_2" VARCHAR,
  "retailer_location_city" VARCHAR,
  "retailer_location_state" VARCHAR,
  "retailer_location_zip_code" BIGINT,
  "retailer_location_zip_code_4" DOUBLE  -- Retailer Location Zip Code +4,
  "retailer_location_county" VARCHAR,
  "owning_entity_retailer_number" BIGINT,
  "owning_entity_retailer_name" VARCHAR,
  "owning_entity_chain_head_number_and_name" VARCHAR,
  "gross_ticket_sales_amount" DOUBLE,
  "promotional_tickets_amount" DOUBLE,
  "cancelled_tickets_amount" DOUBLE,
  "ticket_adjustments_amount" DOUBLE,
  "ticket_returns_amount" DOUBLE,
  "net_ticket_sales_amount" DOUBLE
);