Dataset: Population Of Ukraine By Sex And Age

Population of Ukraine by sex and age.
Structure:

region - region code from regions.csv
year - year (4-digit)
gender - (m for "male", f for "female")
age - age (0 to 100, "total" for total sum by appropriate year, "unknown" for unknown age)
count
**
Important**
For unknown reasons:
Total sum by some years is not eqal to sum all of age values.
Region code 0 means Ukraine as a whole. Do not remove it, and use it if you want total sum by whole counry, because total sum by code 0 is not equal to sum by regions.

@kaggle.mrmorj_population_of_ukraine_by_sex_and_age.population


CREATE TABLE population (
  "region" BIGINT,
  "year" BIGINT,
  "gender" VARCHAR,
  "age" VARCHAR,
  "count" BIGINT
);

@kaggle.mrmorj_population_of_ukraine_by_sex_and_age.region_0


CREATE TABLE region_0 (
  "code" BIGINT,
  "name" VARCHAR
);