Asimmetricity GDP-TertiaryEducation

Exploring the Link Between Education and Economic Performance in Europe

@kaggle.albertomarini88_asimmetricity_gdp_tertiaryeducation

Table List

1 table(19.02 KB)

Gdp Terted

@kaggle.albertomarini88_asimmetricity_gdp_tertiaryeducation.gdp_terted

19.02 KB
35 rows
21 columns

country Country	gdp_per_cap2014 GDP Per Cap2014	gdp_per_cap2015 GDP Per Cap2015	gdp_per_cap2016 GDP Per Cap2016	gdp_per_cap2017 GDP Per Cap2017	gdp_per_cap2018 GDP Per Cap2018	gdp_per_cap2019 GDP Per Cap2019	gdp_per_cap2020 GDP Per Cap2020	gdp_per_cap2021 GDP Per Cap2021	gdp_per_cap2022 GDP Per Cap2022	gdp_per_cap2023 GDP Per Cap2023	tert_ed2014 Tert Ed2014	tert_ed2015 Tert Ed2015	tert_ed2016 Tert Ed2016	tert_ed2017 Tert Ed2017	tert_ed2018 Tert Ed2018	tert_ed2019 Tert Ed2019	tert_ed2020 Tert Ed2020	tert_ed2021 Tert Ed2021	tert_ed2022 Tert Ed2022	tert_ed2023 Tert Ed2023
Belgium	36130	36860	37810	38980	40210	41730	40190	43670	48250	50620	43.8	42.7	45.6	45.9	47.6	47.5	47.8	49.9	53.1	50.2
Bulgaria	11900	12820	13830	15090	16360	18120	18480	21450	26040	28730	30.9	32.1	33.8	32.8	33.7	32.5	33.4	32.8	33.5	35
Czechia	416800	442710	460640	492290	519810	558170	554960	600690	655220	700360	28.2	30.1	32.8	34.2	33.7	35.1	35	36.5	36.5	34.9
Denmark	350900	357280	366840	379800	387230	396020	399090	438560	481550	471540	43.6	45.7	46.7	48.4	48.7	49.4	49.8	52.5	52.3	52.7
Germany	36860	37770	38810	40300	41390	42540	41480	44190	47180	49520	31.4	32.3	33.2	34	34.9	35.5	36.6	38.9	38.9	41
Estonia	15480	16000	16860	18480	20040	21490	20960	23650	27360	27960	43.2	42.7	43.3	45.6	44.6	44	41.5	43.1	45.7	47.3
Ireland	43160	58040	58120	63990	68470	73210	75920	88220	100180	96290	54.6	53.8	54.6	54.5	56.3	55.4	58.1	62.4	62.6	63.7
Greece	16160	16210	16190	16490	16830	17270	15660	17350	19650	21350	37.2	40.4	42.7	43.7	44.3	43.1	43.9	44.3	44.8	45.1
Spain	22380	23440	24190	25160	25950	26620	23850	26090	28750	30970	42.3	40.9	40.1	41.2	42.4	44.7	44.8	46.2	48.7	50.6
France	32620	33200	33530	34290	35080	36090	34280	36950	39010	41330	43.7	45.1	43.7	44.4	46.2	47.5	48.8	49.5	49.2	51.5


CREATE TABLE gdp_terted (
  "country" VARCHAR,
  "gdp_per_cap2014" BIGINT,
  "gdp_per_cap2015" BIGINT,
  "gdp_per_cap2016" BIGINT,
  "gdp_per_cap2017" BIGINT,
  "gdp_per_cap2018" BIGINT,
  "gdp_per_cap2019" BIGINT,
  "gdp_per_cap2020" VARCHAR,
  "gdp_per_cap2021" VARCHAR,
  "gdp_per_cap2022" VARCHAR,
  "gdp_per_cap2023" VARCHAR,
  "tert_ed2014" DOUBLE,
  "tert_ed2015" DOUBLE,
  "tert_ed2016" DOUBLE,
  "tert_ed2017" DOUBLE,
  "tert_ed2018" DOUBLE,
  "tert_ed2019" DOUBLE,
  "tert_ed2020" VARCHAR,
  "tert_ed2021" VARCHAR,
  "tert_ed2022" VARCHAR,
  "tert_ed2023" VARCHAR
);