Baselight
Sign In

Low-alcohol Drinks Consuption In Russia

Low alcohol, regions, seasons

@kaggle.puff1n_lowalcohol_drinks_consuption_in_russia

Loading...
Loading...

About this Dataset

Low-alcohol Drinks Consuption In Russia

The data was collected in preparation for the interview for the DS position.

Content

FIle avg_salary_per_year:
Column names correspond to region name, rows correspond to timestamps.

File low_alco_drinks_consumption:
The amount of consumed beverage in decalitres for the corresponding time period.

File population_by_region:
Population of the region by years.

Acknowledgements

Data was collected from official open government sources: fedstat.ru, rosstat.gov.ru.

Inspiration

How does consumption correlate with population, geographic location, and average wages? May be weather indicators or some seasons generally affect on consumpltion? Is there correlation between winter season, increasing population and consumption? Or average salary only can influence on this?

Tables

Low Alco Drinks Consumption

@kaggle.puff1n_lowalcohol_drinks_consuption_in_russia.low_alco_drinks_consumption
  • 95.95 KB
  • 46 rows
  • 86 columns
Loading... 

CREATE TABLE low_alco_drinks_consumption (
  "unnamed_0" TIMESTAMP,
  "belgorodskaja_oblast" DOUBLE,
  "brjanskaja_oblast" DOUBLE,
  "vladimirskaja_oblast" DOUBLE,
  "voronezhskaja_oblast" DOUBLE,
  "ivanovskaja_oblast" DOUBLE,
  "kaluzhskaja_oblast" DOUBLE,
  "kostromskaja_oblast" DOUBLE,
  "kurskaja_oblast" DOUBLE,
  "lipetskaja_oblast" DOUBLE,
  "moskovskaja_oblast" DOUBLE,
  "orlovskaja_oblast" DOUBLE,
  "rjazanskaja_oblast" DOUBLE,
  "smolenskaja_oblast" DOUBLE,
  "tambovskaja_oblast" DOUBLE,
  "tverskaja_oblast" DOUBLE,
  "tul_skaja_oblast" DOUBLE,
  "jaroslavskaja_oblast" DOUBLE,
  "g_moskva" DOUBLE,
  "respublika_karelija" DOUBLE,
  "respublika_komi" DOUBLE,
  "nenetskij_avtonomnyj_okrug_arhangel_skaja_oblast" DOUBLE,
  "vologodskaja_oblast" DOUBLE,
  "kaliningradskaja_oblast" DOUBLE,
  "leningradskaja_oblast" DOUBLE,
  "murmanskaja_oblast" DOUBLE,
  "novgorodskaja_oblast" DOUBLE,
  "pskovskaja_oblast" DOUBLE,
  "g_sankt_peterburg" DOUBLE,
  "arhangel_skaja_obl_bez_dannyh_po_nenetskomu_avt_okr" DOUBLE,
  "respublika_adygeja_adygeja" DOUBLE,
  "respublika_kalmykija" DOUBLE,
  "respublika_krym" DOUBLE,
  "krasnodarskij_kraj" DOUBLE,
  "astrahanskaja_oblast" DOUBLE,
  "volgogradskaja_oblast" DOUBLE,
  "rostovskaja_oblast" DOUBLE,
  "g_sevastopol" DOUBLE,
  "respublika_dagestan" DOUBLE,
  "respublika_ingushetija" DOUBLE,
  "kabardino_balkarskaja_respublika" DOUBLE,
  "karachaevo_cherkesskaja_respublika" DOUBLE,
  "respublika_severnaja_osetija_alanija" DOUBLE,
  "chechenskaja_respublika" DOUBLE,
  "stavropol_skij_kraj" DOUBLE,
  "respublika_bashkortostan" DOUBLE,
  "respublika_marij_el" DOUBLE,
  "respublika_mordovija" DOUBLE,
  "respublika_tatarstan_tatarstan" DOUBLE,
  "udmurtskaja_respublika" DOUBLE,
  "chuvashskaja_respublika_chuvashija" DOUBLE,
  "permskij_kraj" DOUBLE,
  "kirovskaja_oblast" DOUBLE,
  "nizhegorodskaja_oblast" DOUBLE,
  "orenburgskaja_oblast" DOUBLE,
  "penzenskaja_oblast" DOUBLE,
  "samarskaja_oblast" DOUBLE,
  "saratovskaja_oblast" DOUBLE,
  "ul_janovskaja_oblast" DOUBLE,
  "kurganskaja_oblast" DOUBLE,
  "sverdlovskaja_oblast" DOUBLE,
  "hanty_mansijskij_avtonomnyj_okrug_jugra_tjumenskaja_oblast" DOUBLE,
  "jamalo_nenetskij_avtonomnyj_okrug_tjumenskaja_oblast" DOUBLE,
  "cheljabinskaja_oblast" DOUBLE,
  "tjumenskaja_obl_bez_dannyh_po_hanty_mansijskomu_i_jama_b60039a0" DOUBLE,
  "respublika_altaj" DOUBLE,
  "respublika_tyva" DOUBLE,
  "respublika_hakasija" DOUBLE,
  "altajskij_kraj" DOUBLE,
  "krasnojarskij_kraj" DOUBLE,
  "irkutskaja_oblast" DOUBLE,
  "kemerovskaja_oblast" DOUBLE,
  "novosibirskaja_oblast" DOUBLE,
  "omskaja_oblast" DOUBLE,
  "tomskaja_oblast" DOUBLE,
  "respublika_burjatija" DOUBLE,
  "respublika_saha_jakutija" DOUBLE,
  "zabajkal_skij_kraj" DOUBLE,
  "kamchatskij_kraj" DOUBLE,
  "primorskij_kraj" DOUBLE,
  "habarovskij_kraj" DOUBLE,
  "amurskaja_oblast" DOUBLE,
  "magadanskaja_oblast" DOUBLE,
  "sahalinskaja_oblast" DOUBLE,
  "evrejskaja_avtonomnaja_oblast" DOUBLE,
  "chukotskij_avtonomnyj_okrug" DOUBLE
);

Population By Region

@kaggle.puff1n_lowalcohol_drinks_consuption_in_russia.population_by_region
  • 7.4 KB
  • 85 rows
  • 5 columns
Loading... 

CREATE TABLE population_by_region (
  "unnamed_0" VARCHAR,
  "n_2017" BIGINT,
  "n_2018" BIGINT,
  "n_2019" BIGINT,
  "n_2020" BIGINT
);

Avg Salary Per Year

@kaggle.puff1n_lowalcohol_drinks_consuption_in_russia.avg_salary_per_year
  • 89.34 KB
  • 46 rows
  • 86 columns
Loading... 

CREATE TABLE avg_salary_per_year (
  "unnamed_0" TIMESTAMP,
  "altajskij_kraj" DOUBLE,
  "amurskaja_oblast" DOUBLE,
  "arhangel_skaja_obl_bez_dannyh_po_nenetskomu_avt_okr" DOUBLE,
  "astrahanskaja_oblast" DOUBLE,
  "belgorodskaja_oblast" DOUBLE,
  "brjanskaja_oblast" DOUBLE,
  "vladimirskaja_oblast" DOUBLE,
  "volgogradskaja_oblast" DOUBLE,
  "vologodskaja_oblast" DOUBLE,
  "voronezhskaja_oblast" DOUBLE,
  "g_sevastopol" DOUBLE,
  "g_moskva" DOUBLE,
  "g_sankt_peterburg" DOUBLE,
  "evrejskaja_avtonomnaja_oblast" DOUBLE,
  "zabajkal_skij_kraj" DOUBLE,
  "ivanovskaja_oblast" DOUBLE,
  "irkutskaja_oblast" DOUBLE,
  "kabardino_balkarskaja_respublika" DOUBLE,
  "kaliningradskaja_oblast" DOUBLE,
  "kaluzhskaja_oblast" DOUBLE,
  "kamchatskij_kraj" DOUBLE,
  "karachaevo_cherkesskaja_respublika" DOUBLE,
  "kemerovskaja_oblast" DOUBLE,
  "kirovskaja_oblast" DOUBLE,
  "kostromskaja_oblast" DOUBLE,
  "krasnodarskij_kraj" DOUBLE,
  "krasnojarskij_kraj" DOUBLE,
  "kurganskaja_oblast" DOUBLE,
  "kurskaja_oblast" DOUBLE,
  "leningradskaja_oblast" DOUBLE,
  "lipetskaja_oblast" DOUBLE,
  "magadanskaja_oblast" DOUBLE,
  "moskovskaja_oblast" DOUBLE,
  "murmanskaja_oblast" DOUBLE,
  "nenetskij_avtonomnyj_okrug_arhangel_skaja_oblast" DOUBLE,
  "nizhegorodskaja_oblast" DOUBLE,
  "novgorodskaja_oblast" DOUBLE,
  "novosibirskaja_oblast" DOUBLE,
  "omskaja_oblast" DOUBLE,
  "orenburgskaja_oblast" DOUBLE,
  "orlovskaja_oblast" DOUBLE,
  "penzenskaja_oblast" DOUBLE,
  "permskij_kraj" DOUBLE,
  "primorskij_kraj" DOUBLE,
  "pskovskaja_oblast" DOUBLE,
  "respublika_adygeja_adygeja" DOUBLE,
  "respublika_altaj" DOUBLE,
  "respublika_bashkortostan" DOUBLE,
  "respublika_burjatija" DOUBLE,
  "respublika_dagestan" DOUBLE,
  "respublika_ingushetija" DOUBLE,
  "respublika_kalmykija" DOUBLE,
  "respublika_karelija" DOUBLE,
  "respublika_komi" DOUBLE,
  "respublika_krym" DOUBLE,
  "respublika_marij_el" DOUBLE,
  "respublika_mordovija" DOUBLE,
  "respublika_saha_jakutija" DOUBLE,
  "respublika_severnaja_osetija_alanija" DOUBLE,
  "respublika_tatarstan_tatarstan" DOUBLE,
  "respublika_tyva" DOUBLE,
  "respublika_hakasija" DOUBLE,
  "rostovskaja_oblast" DOUBLE,
  "rjazanskaja_oblast" DOUBLE,
  "samarskaja_oblast" DOUBLE,
  "saratovskaja_oblast" DOUBLE,
  "sahalinskaja_oblast" DOUBLE,
  "sverdlovskaja_oblast" DOUBLE,
  "smolenskaja_oblast" DOUBLE,
  "stavropol_skij_kraj" DOUBLE,
  "tambovskaja_oblast" DOUBLE,
  "tverskaja_oblast" DOUBLE,
  "tomskaja_oblast" DOUBLE,
  "tul_skaja_oblast" DOUBLE,
  "tjumenskaja_obl_bez_dannyh_po_hanty_mansijskomu_i_jama_b60039a0" DOUBLE,
  "udmurtskaja_respublika" DOUBLE,
  "ul_janovskaja_oblast" DOUBLE,
  "habarovskij_kraj" DOUBLE,
  "hanty_mansijskij_avtonomnyj_okrug_jugra_tjumenskaja_oblast" DOUBLE,
  "cheljabinskaja_oblast" DOUBLE,
  "chechenskaja_respublika" DOUBLE,
  "chuvashskaja_respublika_chuvashija" DOUBLE,
  "chukotskij_avtonomnyj_okrug" DOUBLE,
  "jamalo_nenetskij_avtonomnyj_okrug_tjumenskaja_oblast" DOUBLE,
  "jaroslavskaja_oblast" DOUBLE
);

Share link

Anyone who has the link will be able to view this.