Alcohol Consumption Per Capita 2016

Pure alcohol consumption among persons (age 15+) in litres per capita 2016

@kaggle.mattop_alcohol_consumption_per_capita_2016

Table List

1 table(15.66 KB)

Alcohol Consumption

@kaggle.mattop_alcohol_consumption_per_capita_2016.alcohol_consumption

15.66 KB
189 rows
10 columns

country Country	total_consumption Total Consumption	recorded_consumption Recorded Consumption	unrecorded_consumption Unrecorded Consumption	beer_percentage Beer Percentage	wine_percentage Wine Percentage	spirits_percentage Spirits Percentage	other_percentage Other Percentage	n_2020_projection 2020 Projection	n_2025_projection 2025 Projection
Estonia	16.9	15.8	1.1	32.7	7.4	50.3	9.6	11.5	11.9
Lithuania	15	13.8	1.2	43.6	7.3	37.1	12.1	14.4	13.9
Czech Republic	14.3	12.4	1.4	53.3	21.3	25.4		11.2	11.4
Seychelles	13.8	12.4	1.4	68.9	22.4	6.3	2.5	10.4	10.6
Germany	13.4	11.3	1.4	52.6	28.4	18.9		12.8	12.6
Nigeria	13.4	9.6	3.8	7.9	0.4	0.6	91.1	13	12.5
Ireland	13	11.3	1.4	47	28	18.8	6.2	13.5	13.9
Moldova	13	11.5	1.4	35.4	44.6	20		12.6	12.4
Latvia	12.9	11.1	1.9	42.8	11.1	40	6.1	14	15.1
Bulgaria	12.7	11.4	1.3	38.8	17.2	42.9	1.2	13	13.4


CREATE TABLE alcohol_consumption (
  "country" VARCHAR,
  "total_consumption" DOUBLE,
  "recorded_consumption" DOUBLE,
  "unrecorded_consumption" DOUBLE,
  "beer_percentage" DOUBLE,
  "wine_percentage" DOUBLE,
  "spirits_percentage" DOUBLE,
  "other_percentage" DOUBLE,
  "n_2020_projection" DOUBLE,
  "n_2025_projection" DOUBLE
);