March Madness Data

CREATE TABLE tournament_locations (
  "year" BIGINT,
  "by_year_no" BIGINT,
  "by_round_no" BIGINT,
  "team_no" BIGINT,
  "team" VARCHAR,
  "seed" BIGINT,
  "round" BIGINT,
  "college_city" VARCHAR,
  "college_state" VARCHAR,
  "college_location" VARCHAR,
  "college_time_zone" VARCHAR,
  "college_time_zone_value" BIGINT,
  "daylight_savings_time" BOOLEAN,
  "college_latitude" DOUBLE,
  "college_longitude" DOUBLE,
  "game_city" VARCHAR,
  "game_state" VARCHAR,
  "game_location" VARCHAR,
  "game_time_zone" VARCHAR,
  "game_time_zone_value" BIGINT,
  "daylight_savings_time_1" BOOLEAN,
  "game_latitude" DOUBLE,
  "game_longitude" DOUBLE,
  "time_zone_combination" VARCHAR,
  "direction" VARCHAR,
  "longitude_diff" DOUBLE,
  "time_zones_crossed" BIGINT,
  "time_zones_crossed_value" BIGINT,
  "distance_km" DOUBLE,
  "distance_mi" DOUBLE
);