Formula 1 Race Data

circuitid CircuitId	circuitref CircuitRef	name Name	location Location	country Country	lat Lat	lng Lng	alt Alt	url Url
1	albert_park	Albert Park Grand Prix Circuit	Melbourne	Australia	-37.8497	144.968	10	http://en.wikipedia.org/wiki/Melbourne_Grand_Prix_Circuit
2	sepang	Sepang International Circuit	Kuala Lumpur	Malaysia	2.76083	101.738	18	http://en.wikipedia.org/wiki/Sepang_International_Circuit
3	bahrain	Bahrain International Circuit	Sakhir	Bahrain	26.0325	50.5106	7	http://en.wikipedia.org/wiki/Bahrain_International_Circuit
4	catalunya	Circuit de Barcelona-Catalunya	Montmeló	Spain	41.57	2.26111	109	http://en.wikipedia.org/wiki/Circuit_de_Barcelona-Catalunya
5	istanbul	Istanbul Park	Istanbul	Turkey	40.9517	29.405	130	http://en.wikipedia.org/wiki/Istanbul_Park
6	monaco	Circuit de Monaco	Monte-Carlo	Monaco	43.7347	7.42056	7	http://en.wikipedia.org/wiki/Circuit_de_Monaco
7	villeneuve	Circuit Gilles Villeneuve	Montreal	Canada	45.5	-73.5228	13	http://en.wikipedia.org/wiki/Circuit_Gilles_Villeneuve
8	magny_cours	Circuit de Nevers Magny-Cours	Magny Cours	France	46.8642	3.16361	228	http://en.wikipedia.org/wiki/Circuit_de_Nevers_Magny-Cours
9	silverstone	Silverstone Circuit	Silverstone	UK	52.0786	-1.01694	153	http://en.wikipedia.org/wiki/Silverstone_Circuit
10	hockenheimring	Hockenheimring	Hockenheim	Germany	49.3278	8.56583	103	http://en.wikipedia.org/wiki/Hockenheimring


CREATE TABLE circuits (
  "circuitid" BIGINT,
  "circuitref" VARCHAR,
  "name" VARCHAR,
  "location" VARCHAR,
  "country" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "alt" BIGINT,
  "url" VARCHAR
);