Name: Canada National & Provincial Per Capita Income
Creator: Kaggle
License: http://opendatacommons.org/licenses/odbl/1.0/

About this Dataset

Canada National & Provincial Per Capita Income

Filtered data which only remains 10 provinces and national capita income, median income, with 16 years old & over, both sexes, in 2019 constant dollar

The raw data had been already adjusted by 2019 constant dollar, from 1976-2019
Please be aware territories of Canada were not listed in the original dataset
For example, the 2018 Canada national average income is not equal to the average of 10 provinces income, since territories are not in the list.
My practicing data exploration of this dataset:
Facts of Individuals Income in Canada, 1976 - 2019

Acknowledgements

Data source:
Income of individuals by age group, sex and income source, Canada, provinces and selected census metropolitan areas
**Raw data version: **
Table: 11-10-0239-01 (formerly CANSIM 206-0052)
**Release date: **
2021-03-23

Inspiration

I was really surprised when revealing these rows, it seems like there isn't much growth since 1976 Canada average income is 40,800 dollars while 2019 is 49,000 dollars. (Please be noticed these are adjusted by 2019 constant dollar)

Please correct me if I was wrong. Thank you

Tables

Canada Per Capita Income From 1976–2019

@kaggle.charlesluan_canada_national_provincial_capita_income_762019.canada_per_capita_income_from_1976_2019

9.53 kB
484 rows
8 columns

CREATE TABLE canada_per_capita_income_from_1976_2019 (
  "ref_date" BIGINT,
  "geo" VARCHAR,
  "income_source" VARCHAR,
  "average_income_excluding_zeros" BIGINT  -- Average Income (excluding Zeros),
  "median_income_excluding_zeros" BIGINT  -- Median Income (excluding Zeros),
  "sex" VARCHAR,
  "age_group" VARCHAR,
  "uom" VARCHAR
);