INSERT INTO Capitales
VALUES
(1, 'Ámsterdam'),
(2, 'Atenas'),
(3, 'Berlín'),
(4, 'Bratislava'),
(5, 'Bruselas'),
(6, 'Bucarest'),
(7, 'Budapest'),
(8, 'Copenhage'),
(9, 'Dublín'),
(10, 'Estocolmo'),
(11, 'Helsinki'),
(12, 'La Valeta'),
(13, 'Lisboa'),
(14, 'Liubliana'),
(15, 'Luxemburgo'),
(16, 'Madrid'),
(17, 'Nicosia'),
(18, 'París'),
(19, 'Praga'),
(20, 'Riga'),
(21, 'Roma'),
(22, 'Sofía'),
(23, 'Tallin'),
(24, 'Varsovia'),
(25, 'Viena'),
(26, 'Vilna'),
(27, 'Zagreb');

INSERT INTO Paises
VALUES
(1, 'Alemania', 3),
(2, 'Austria', 25),
(3, 'Bélgica', 5),
(4, 'Bulgaria', 22),
(5, 'Chipre', 17),
(6, 'Croacia', 27),
(7, 'Dinamarca', 8),
(8, 'Eslovaquia', 4),
(9, 'Eslovenia', 14),
(10, 'España', 16),
(11, 'Estonia', 23),
(12, 'Finlandia', 11),
(13, 'Francia', 18),
(14, 'Grecia', 2),
(15, 'Hungría', 7),
(16, 'Irlanda', 9),
(17, 'Italia', 21),
(18, 'Letonia', 20),
(19, 'Lituania', 26),
(20, 'Luxemburgo', 15),
(21, 'Malta', 12),
(22, 'Países Bajos', 1),
(23, 'Polonia', 24),
(24, 'Portugal', 13),
(25, 'República Checa', 19),
(26, 'Rumanía', 6),
(27, 'Suecia', 10);

INSERT INTO Idiomas
VALUES
(1, 'alemán'),
(2, 'francés'),
(3, 'neerlandés'),
(4, 'búlgaro'),
(5, 'griego'),
(6, 'croata'),
(7, 'danés'),
(8, 'eslovaco'),
(9, 'esloveno'),
(10, 'español'),
(11, 'estonio'),
(12, 'finés'),
(13, 'sueco'),
(14, 'húngaro'),
(15, 'irlandés'),
(16, 'inglés'),
(17, 'italiano'),
(18, 'letón'),
(19, 'lituano'),
(20, 'maltés'),
(21, 'polaco'),
(22, 'portugués'),
(23, 'checo'),
(24, 'rumano');

INSERT INTO IdiomasPais
VALUES
(1, 1),
(2, 1),
(3, 1),
(3, 2),
(3, 3),
(4, 4),
(5, 5),
(6, 6),
(7, 7),
(8, 8),
(9, 9),
(10, 10),
(11, 11),
(12, 12),
(12, 13),
(13, 2),
(14, 5),
(15, 14),
(16, 15),
(16, 16),
(17, 17),
(18, 18),
(19, 19),
(20, 1),
(20, 2),
(21, 16),
(21, 20),
(22, 3),
(23, 21),
(24, 22),
(25, 23),
(26, 24),
(27, 13);

INSERT INTO Poblaciones
VALUES
(1, 2012, 80327900),
(1, 2013, 80523746),
(1, 2014, 80767463),
(1, 2015, 81197537),
(1, 2016, 82175684),
(1, 2017, 82521653),
(1, 2018, 82792351),
(1, 2019, 83019213),
(1, 2020, 83166711),
(1, 2021, 83155031),
(1, 2022, 83237124),
(1, 2023, 84358845),
(2, 2012, 8408121),
(2, 2013, 8451860),
(2, 2014, 8507786),
(2, 2015, 8584926),
(2, 2016, 8700471),
(2, 2017, 8772865),
(2, 2018, 8822267),
(2, 2019, 8858775),
(2, 2020, 8901064),
(2, 2021, 8932664),
(2, 2022, 8978929),
(2, 2023, 9104772),
(3, 2012, 11075889),
(3, 2013, 11137974),
(3, 2014, 11180840),
(3, 2015, 11237274),
(3, 2016, 11311117),
(3, 2017, 11351727),
(3, 2018, 11398589),
(3, 2019, 11455519),
(3, 2020, 11522440),
(3, 2021, 11554767),
(3, 2022, 11617623),
(3, 2023, 11754004),
(4, 2012, 7327224),
(4, 2013, 7284552),
(4, 2014, 7245677),
(4, 2015, 7202198),
(4, 2016, 7153784),
(4, 2017, 7101859),
(4, 2018, 7050034),
(4, 2019, 7000039),
(4, 2020, 6951482),
(4, 2021, 6916548),
(4, 2022, 6838937),
(4, 2023, 6447710),
(5, 2012, 862011),
(5, 2013, 865878),
(5, 2014, 858000),
(5, 2015, 847008),
(5, 2016, 848319),
(5, 2017, 854802),
(5, 2018, 864236),
(5, 2019, 875899),
(5, 2020, 888005),
(5, 2021, 896007),
(5, 2022, 904705),
(5, 2023, 920701),
(6, 2012, 4275984),
(6, 2013, 4262140),
(6, 2014, 4246809),
(6, 2015, 4225316),
(6, 2016, 4190669),
(6, 2017, 4154213),
(6, 2018, 4105493),
(6, 2019, 4076246),
(6, 2020, 4058165),
(6, 2021, 4036355),
(6, 2022, 3862305),
(6, 2023, 3850894),
(7, 2012, 5580516),
(7, 2013, 5602628),
(7, 2014, 5627235),
(7, 2015, 5659715),
(7, 2016, 5707251),
(7, 2017, 5748769),
(7, 2018, 5781190),
(7, 2019, 5806081),
(7, 2020, 5822763),
(7, 2021, 5840045),
(7, 2022, 5873420),
(7, 2023, 5932654),
(8, 2012, 5404322),
(8, 2013, 5410836),
(8, 2014, 5415949),
(8, 2015, 5421349),
(8, 2016, 5426252),
(8, 2017, 5435343),
(8, 2018, 5443120),
(8, 2019, 5450421),
(8, 2020, 5457873),
(8, 2021, 5459781),
(8, 2022, 5434712),
(8, 2023, 5428792),
(9, 2012, 2055496),
(9, 2013, 2058821),
(9, 2014, 2061085),
(9, 2015, 2062874),
(9, 2016, 2064188),
(9, 2017, 2065895),
(9, 2018, 2066880),
(9, 2019, 2080908),
(9, 2020, 2095861),
(9, 2021, 2108977),
(9, 2022, 2107180),
(9, 2023, 2116792),
(10, 2012, 46818219),
(10, 2013, 46727890),
(10, 2014, 46512199),
(10, 2015, 46449565),
(10, 2016, 46440099),
(10, 2017, 46528024),
(10, 2018, 46658447),
(10, 2019, 46937060),
(10, 2020, 47332614),
(10, 2021, 47398695),
(10, 2022, 47432893),
(10, 2023, 48059777),
(11, 2012, 1325217),
(11, 2013, 1320174),
(11, 2014, 1315819),
(11, 2015, 1314870),
(11, 2016, 1315944),
(11, 2017, 1315635),
(11, 2018, 1319133),
(11, 2019, 1324820),
(11, 2020, 1328976),
(11, 2021, 1330068),
(11, 2022, 1331796),
(11, 2023, 1365884),
(12, 2012, 5401267),
(12, 2013, 5426674),
(12, 2014, 5451270),
(12, 2015, 5471753),
(12, 2016, 5487308),
(12, 2017, 5503297),
(12, 2018, 5513130),
(12, 2019, 5517919),
(12, 2020, 5525292),
(12, 2021, 5533793),
(12, 2022, 5548241),
(12, 2023, 5563970),
(13, 2012, 65276983),
(13, 2013, 65600350),
(13, 2014, 66165980),
(13, 2015, 66458153),
(13, 2016, 66638391),
(13, 2017, 66809816),
(13, 2018, 67026224),
(13, 2019, 67290471),
(13, 2020, 67485531),
(13, 2021, 67656682),
(13, 2022, 67871925),
(13, 2023, 68070697),
(15, 2012, 9931925),
(15, 2013, 9908798),
(15, 2014, 9877365),
(15, 2015, 9855571),
(15, 2016, 9830485),
(15, 2017, 9797561),
(15, 2018, 9778371),
(15, 2019, 9772756),
(15, 2020, 9769526),
(15, 2021, 9730772),
(15, 2022, 9689010),
(15, 2023, 9597085),
(16, 2012, 4589287),
(16, 2013, 4609779),
(16, 2014, 4637852),
(16, 2015, 4677627),
(16, 2016, 4726286),
(16, 2017, 4784383),
(16, 2018, 4830392),
(16, 2019, 4904240),
(16, 2020, 4964440),
(16, 2021, 5006324),
(16, 2022, 5060004),
(16, 2023, 5194336),
(17, 2012, 59394207),
(17, 2013, 59685227),
(17, 2014, 60782668),
(17, 2015, 60795612),
(17, 2016, 60665551),
(17, 2017, 60589445),
(17, 2018, 60483973),
(17, 2019, 59816673),
(17, 2020, 59641488),
(17, 2021, 59236213),
(17, 2022, 59030133),
(17, 2023, 58850717),
(18, 2012, 2044813),
(18, 2013, 2023825),
(18, 2014, 2001468),
(18, 2015, 1986096),
(18, 2016, 1968957),
(18, 2017, 1950116),
(18, 2018, 1934379),
(18, 2019, 1919968),
(18, 2020, 1907675),
(18, 2021, 1893223),
(18, 2022, 1875757),
(18, 2023, 1883008),
(19, 2012, 3003641),
(19, 2013, 2971905),
(19, 2014, 2943472),
(19, 2015, 2921262),
(19, 2016, 2888558),
(19, 2017, 2847904),
(19, 2018, 2808901),
(19, 2019, 2794184),
(19, 2020, 2794090),
(19, 2021, 2795680),
(19, 2022, 2805998),
(19, 2023, 2857279),
(20, 2012, 524853),
(20, 2013, 537039),
(20, 2014, 549680),
(20, 2015, 562958),
(20, 2016, 576249),
(20, 2017, 590667),
(20, 2018, 602005),
(20, 2019, 613894),
(20, 2020, 626108),
(20, 2021, 634730),
(20, 2022, 645397),
(20, 2023, 660809),
(21, 2012, 417546),
(21, 2013, 422509),
(21, 2014, 429424),
(21, 2015, 439691),
(21, 2016, 450415),
(21, 2017, 460297),
(21, 2018, 475701),
(21, 2019, 493559),
(21, 2020, 514564),
(21, 2021, 516100),
(21, 2022, 520971),
(21, 2023, 542051),
(22, 2012, 16730348),
(22, 2013, 16779575),
(22, 2014, 16829289),
(22, 2015, 16900726),
(22, 2016, 16979120),
(22, 2017, 17081507),
(22, 2018, 17181084),
(22, 2019, 17282163),
(22, 2020, 17407585),
(22, 2021, 17475415),
(22, 2022, 17590672),
(22, 2023, 17811291),
(23, 2012, 38063792),
(23, 2013, 38062535),
(23, 2014, 38017856),
(23, 2015, 38005614),
(23, 2016, 37967209),
(23, 2017, 37972964),
(23, 2018, 37976687),
(23, 2019, 37972812),
(23, 2020, 37958138),
(23, 2021, 37840001),
(23, 2022, 37654247),
(23, 2023, 36753736),
(24, 2012, 10542398),
(24, 2013, 10487289),
(24, 2014, 10427301),
(24, 2015, 10374822),
(24, 2016, 10341330),
(24, 2017, 10309573),
(24, 2018, 10291027),
(24, 2019, 10276617),
(24, 2020, 10295909),
(24, 2021, 10298252),
(24, 2022, 10352042),
(24, 2023, 10467366),
(25, 2012, 10505445),
(25, 2013, 10516125),
(25, 2014, 10512419),
(25, 2015, 10538275),
(25, 2016, 10553843),
(25, 2017, 10578820),
(25, 2018, 10610055),
(25, 2019, 10649800),
(25, 2020, 10693939),
(25, 2021, 10494836),
(25, 2022, 10516707),
(25, 2023, 10827529),
(26, 2012, 20095996),
(26, 2013, 20020074),
(26, 2014, 19947311),
(26, 2015, 19870647),
(26, 2016, 19760585),
(26, 2017, 19643949),
(26, 2018, 19533481),
(26, 2019, 19414458),
(26, 2020, 19328838),
(26, 2021, 19201662),
(26, 2022, 19042455),
(26, 2023, 19051562),
(27, 2012, 9482855),
(27, 2013, 9555893),
(27, 2014, 9644864),
(27, 2015, 9747355),
(27, 2016, 9851017),
(27, 2017, 9995153),
(27, 2018, 10120242),
(27, 2019, 10230185),
(27, 2020, 10327589),
(27, 2021, 10379295),
(27, 2022, 10452326),
(27, 2023, 10521556);

