INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Alsace',8280.3,1785000,'2003-01-01','fr');
INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Aquitaine',41309.0,3016000,'2003-01-01','fr');
INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Burgundy',31582.2,1621000,'2003-01-01','fr');
INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Corsica',8680.3,271000,'2003-01-01','fr');
INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Normandy',17589.6,1802000,'2004-01-01','fr');

INSERT INTO cities (name,country_iso_code,region_name,area,population,date_of_poll) VALUES ('Bordeaux','fr','Aquitaine',49.36,229500,'2004-01-01');
INSERT INTO cities (name,country_iso_code,region_name,area,population,date_of_poll) VALUES ('Dijon','fr','Burgundy',40.41,149900,'2004-01-01');


INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Lombardy',23863.3,9475202,'2006-01-01','it');
INSERT INTO regions (name,area,population,date_of_poll,country_iso_code) VALUES ('Trentino-South Tyrol',13607.1,985128,'2006-01-01','it');

INSERT INTO cities (name,country_iso_code,region_name,area,population,date_of_poll) VALUES ('Milan','it','Lombardy',182,1308735,'2006-01-01');
INSERT INTO cities (name,country_iso_code,region_name,area,population,date_of_poll) VALUES ('Trento','it','Trentino-South Tyrol',157.3,110142,'2005-12-01');