Member States Of The European Union

What divides and unites the 28 countries in the European Union?

@kaggle.eurostat_european_union

Table List

1 table(14.99 KB)

States

@kaggle.eurostat_european_union.states

14.99 KB
37 rows
17 columns

country Country	european_union European Union	accession_year Accession Year	council_votes Council Votes	european_parliament_seats European Parliament Seats	european_free_trade_agreement European Free Trade Agreement	european_single_market European Single Market	european_monetary_union European Monetary Union	currency Currency	currency_code Currency Code	language Language	population Population	area_km Area (km²)	population_density Population Density	gdp_millions GDP (€, Millions)	gdp_millions_03af25 GDP ($, Millions)	gdp_per_capita_millions GDP Per Capita ($, Millions)
Albania	Candidate				nan	nan	nan	Lek	ALL	Albanian	2892302	28748	101	10267	11398	3945
Austria	Member	1995	10	18	nan	Member	Member	Euro	EUR	German	8576261	83855	102	339896	376950	43775
Belgium	Member	1958	12	21	nan	Member	Member	Euro	EUR	Dutch, French, German	11237274	30528	368	410351	455086	40324
Bulgaria	Member	2007	10	17	nan	Member	Candidate	Lev	BGN	Bulgarian	7202198	110994	65	45287	50199	6994
Croatia	Member	2013	7	11	nan	Member	Candidate	Kuna	HRK	Croatian	4225316	56594	75	43847	48732	11536
Cyprus	Member	2004	4	6	nan	Member	Member	Euro	EUR	Greek, Turkish	847008	9251	92	17637	19560	23243
Czech Republic	Member	2004	12	21	nan	Member	Candidate	Koruna	CZK	Czech	10538275	78866	134	166964	185156	17548
Denmark	Member	1973	7	13	nan	Member	Not Applicable	Krone	DKK	Danish	5659715	43075	131	271786	295091	51989
Estonia	Member	2004	4	6	nan	Member	Member	Euro	EUR	Estonian	1314870	45227	29	20252	22459	17119
Finland	Member	1995	7	13	nan	Member	Member	Euro	EUR	Finnish, Swedish	5471753	338424	16	209511	231950	42311


CREATE TABLE states (
  "country" VARCHAR,
  "european_union" VARCHAR,
  "accession_year" DOUBLE,
  "council_votes" DOUBLE,
  "european_parliament_seats" DOUBLE,
  "european_free_trade_agreement" VARCHAR,
  "european_single_market" VARCHAR,
  "european_monetary_union" VARCHAR,
  "currency" VARCHAR,
  "currency_code" VARCHAR,
  "language" VARCHAR,
  "population" BIGINT,
  "area_km" BIGINT,
  "population_density" BIGINT,
  "gdp_millions" DOUBLE,
  "gdp_millions_03af25" DOUBLE,
  "gdp_per_capita_millions" DOUBLE
);