Our Data Source

https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410008301&pickMembers%5B0%5D=1.1&pickMembers%5B1%5D=3.1&pickMembers%5B2%5D=4.2&cubeTimeFrame.startYear=2006&cubeTimeFrame.endYear=2023&referencePeriods=20060101%2C20230101

We found this data source on Open Canada. The dataset allowed us to filter out specific Labour force characteristics as well as age groups. We decided to choose the age group of 25 to 54 years old. We choose data from all provinces, including Canada overall as well.

Unemployment Rate of individuals BORN in Canada

A chart showing the total average unemployment rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Unemploy_Rate=mean(`Born.in.Canada...Unemp..Rate`))
## # A tibble: 11 × 2
##    Province                  Avg_Unemploy_Rate
##    <chr>                                 <dbl>
##  1 Alberta                                5.8 
##  2 British Columbia                       4.51
##  3 Canada                                 5.08
##  4 Manitoba                               4.52
##  5 New Brunswick                          7.02
##  6 Newfoundland and Labrador             11.0 
##  7 Nova Scotia                            6.58
##  8 Ontario                                4.89
##  9 Prince Edward Island                   7.79
## 10 Quebec                                 4.48
## 11 Saskatchewan                           4.98

A Chart showing the average unemployment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Unemploy_Rate=mean(`Born.in.Canada...Unemp..Rate`))
## # A tibble: 9 × 2
##    Year Avg_Unemploy_Rate
##   <int>             <dbl>
## 1  2015              6.49
## 2  2016              6.79
## 3  2017              6.4 
## 4  2018              5.95
## 5  2019              5.51
## 6  2020              7.77
## 7  2021              6.45
## 8  2022              4.65
## 9  2023              4.53

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Born.in.Canada...Unemp..Rate`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Born in Canada",x="Year",y="Unemployment Rate")

Part Time employment of individuals BORN in Canada

A Chart showing the average part time employment rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Part_Time=mean(`Born.in.Canada...Part.time`))
## # A tibble: 11 × 2
##    Province                  Avg_Part_Time
##    <chr>                             <dbl>
##  1 Alberta                          131.  
##  2 British Columbia                 155.  
##  3 Canada                           946.  
##  4 Manitoba                          34.6 
##  5 New Brunswick                     16.4 
##  6 Newfoundland and Labrador         12.5 
##  7 Nova Scotia                       26.7 
##  8 Ontario                          324.  
##  9 Prince Edward Island               3.52
## 10 Quebec                           212.  
## 11 Saskatchewan                      30.9

A Chart showing the average part time employment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Part_Time=mean(`Born.in.Canada...Part.time`))
## # A tibble: 9 × 2
##    Year Avg_Part_Time
##   <int>         <dbl>
## 1  2015          185.
## 2  2016          184.
## 3  2017          185.
## 4  2018          180.
## 5  2019          173.
## 6  2020          160.
## 7  2021          164.
## 8  2022          157.
## 9  2023          159.

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Born.in.Canada...Part.time`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Born in Canada",x="Year",y="Part Time")

Full time employment of individuals BORN in Canada

A Chart showing the average employment rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Employment=mean(`Born.in.Canada...Employment`))
## # A tibble: 11 × 2
##    Province                  Avg_Employment
##    <chr>                              <dbl>
##  1 Alberta                           1095. 
##  2 British Columbia                  1077. 
##  3 Canada                            8622. 
##  4 Manitoba                           302. 
##  5 New Brunswick                      210. 
##  6 Newfoundland and Labrador          142. 
##  7 Nova Scotia                        257. 
##  8 Ontario                           3016. 
##  9 Prince Edward Island                41.8
## 10 Quebec                            2186. 
## 11 Saskatchewan                       295

A Chart showing the average employment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Employment=mean(`Born.in.Canada...Employment`))
## # A tibble: 9 × 2
##    Year Avg_Employment
##   <int>          <dbl>
## 1  2015          1591.
## 2  2016          1561.
## 3  2017          1572.
## 4  2018          1566.
## 5  2019          1571.
## 6  2020          1513.
## 7  2021          1538.
## 8  2022          1591.
## 9  2023          1607.

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Born.in.Canada...Employment`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Born in Canada",x="Year",y="Employment")

Unemployed individuals BORN in Canada

A Chart showing the average unemployed rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Unemployed=mean(`Born.in.Canada...Unemployed`))
## # A tibble: 11 × 2
##    Province                  Avg_Unemployed
##    <chr>                              <dbl>
##  1 Alberta                            67.5 
##  2 British Columbia                   50.8 
##  3 Canada                             NA   
##  4 Manitoba                           14.3 
##  5 New Brunswick                      15.9 
##  6 Newfoundland and Labrador          17.6 
##  7 Nova Scotia                        18.0 
##  8 Ontario                           155.  
##  9 Prince Edward Island                3.53
## 10 Quebec                            103.  
## 11 Saskatchewan                       15.4

A Chart showing the average unemployed rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Unemployed=mean(`Born.in.Canada...Unemployed`, na.rm=TRUE))
## # A tibble: 9 × 2
##    Year Avg_Unemployed
##   <int>          <dbl>
## 1  2015           51.2
## 2  2016           51.3
## 3  2017           46.4
## 4  2018           41.5
## 5  2019           39.1
## 6  2020           63.6
## 7  2021           49.9
## 8  2022           35.1
## 9  2023           36.4

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Born.in.Canada...Unemployed`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Born in Canada",x="Year",y="Unemployed")

Unemployment Rate of individuals LANDED IMMIGRANTS in Canada

A chart showing the total average unemployment rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Unemploy_Rate=mean(`Landed.Immigrants...Unemp..Rate`, na.rm = TRUE))
## # A tibble: 11 × 2
##    Province                  Avg_Unemploy_Rate
##    <chr>                                 <dbl>
##  1 Alberta                                7.43
##  2 British Columbia                       5.5 
##  3 Canada                                 6.62
##  4 Manitoba                               5.33
##  5 New Brunswick                          6.57
##  6 Newfoundland and Labrador              8.25
##  7 Nova Scotia                            7.03
##  8 Ontario                                6.44
##  9 Prince Edward Island                   8.38
## 10 Quebec                                 8   
## 11 Saskatchewan                           5.9

A Chart showing the average unemployment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Unemploy_Rate=mean(`Landed.Immigrants...Unemp..Rate`, na.rm = TRUE))
## # A tibble: 9 × 2
##    Year Avg_Unemploy_Rate
##   <int>             <dbl>
## 1  2015              7.43
## 2  2016              6.74
## 3  2017              6.92
## 4  2018              6.23
## 5  2019              5.63
## 6  2020              9.24
## 7  2021              7.84
## 8  2022              5.06
## 9  2023              5.9

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Landed.Immigrants...Unemp..Rate`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Landed Immigrants",x="Year",y="Unemployment Rate")

Employment of individuals LANDED IMMIGRANTS in Canada

A chart showing the total average employment rate by PROVINCE from 2015-2023

#Landed Immigrants Employment 
immi_data %>% group_by(Province) %>% summarize(Avg_Employment=mean(`Landed.Immigrants...Employment`, na.rm = TRUE))
## # A tibble: 11 × 2
##    Province                  Avg_Employment
##    <chr>                              <dbl>
##  1 Alberta                           397.  
##  2 British Columbia                  539.  
##  3 Canada                           3276.  
##  4 Manitoba                          105.  
##  5 New Brunswick                      15.7 
##  6 Newfoundland and Labrador           5.08
##  7 Nova Scotia                        23.9 
##  8 Ontario                          1598.  
##  9 Prince Edward Island                4.29
## 10 Quebec                            528.  
## 11 Saskatchewan                       60.0

A Chart showing the average employment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Employment=mean(`Landed.Immigrants...Employment`, na.rm = TRUE))
## # A tibble: 9 × 2
##    Year Avg_Employment
##   <int>          <dbl>
## 1  2015           512.
## 2  2016           542.
## 3  2017           557.
## 4  2018           585.
## 5  2019           608.
## 6  2020           580.
## 7  2021           633.
## 8  2022           662.
## 9  2023           684.

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Landed.Immigrants...Employment`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Landed Immigrants",x="Year",y="Employment")

Part Time Employment of individuals LANDED IMMIGRANTS in Canada

A chart showing the total average part time employment rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Part_Time=mean(`Landed.Immigrants...Part.time`, na.rm = TRUE))
## # A tibble: 11 × 2
##    Province                  Avg_Part_Time
##    <chr>                             <dbl>
##  1 Alberta                          50.8  
##  2 British Columbia                 71.2  
##  3 Canada                          388.   
##  4 Manitoba                         12.9  
##  5 New Brunswick                     1.8  
##  6 Newfoundland and Labrador         0.7  
##  7 Nova Scotia                       3.13 
##  8 Ontario                         178.   
##  9 Prince Edward Island              0.611
## 10 Quebec                           61.8  
## 11 Saskatchewan                      7.58

A Chart showing the average part time employment rate by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Part_Time=mean(`Landed.Immigrants...Part.time`, na.rm = TRUE))
## # A tibble: 9 × 2
##    Year Avg_Part_Time
##   <int>         <dbl>
## 1  2015          71.1
## 2  2016          68.5
## 3  2017          74.6
## 4  2018          68.0
## 5  2019          72.9
## 6  2020          68.8
## 7  2021          75.8
## 8  2022          74.6
## 9  2023          73.6

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Landed.Immigrants...Part.time`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Landed Immigrants",x="Year",y="Part Time")

Unemployment of individuals LANDED IMMIGRANTS in Canada

A chart showing the total average unemployed rate by PROVINCE from 2015-2023

immi_data %>% group_by(Province) %>% summarize(Avg_Unemployed=mean(`Landed.Immigrants...Unemployed`, na.rm = TRUE))
## # A tibble: 11 × 2
##    Province                  Avg_Unemployed
##    <chr>                              <dbl>
##  1 Alberta                           31.5  
##  2 British Columbia                  31.3  
##  3 Canada                           NaN    
##  4 Manitoba                           5.9  
##  5 New Brunswick                      1.11 
##  6 Newfoundland and Labrador          0.55 
##  7 Nova Scotia                        1.74 
##  8 Ontario                          110.   
##  9 Prince Edward Island               0.389
## 10 Quebec                            45.2  
## 11 Saskatchewan                       3.74

A Chart showing the average unemployed by YEAR throughout Canada

immi_data %>% group_by(Year) %>% summarize(Avg_Unemployed=mean(`Landed.Immigrants...Unemployed`, na.rm = TRUE))
## # A tibble: 9 × 2
##    Year Avg_Unemployed
##   <int>          <dbl>
## 1  2015           23.4
## 2  2016           24.5
## 3  2017           24.0
## 4  2018           21.3
## 5  2019           21.7
## 6  2020           33.8
## 7  2021           28.9
## 8  2022           20.2
## 9  2023           21.6

This graph is taking the data from both above charts and implementing them into graphs by Province for an easier visual of the data

immi_data %>% ggplot(aes(Year, `Landed.Immigrants...Unemployed`, color=Province))+
geom_line(linewidth=1, show.legend = FALSE)+facet_wrap(~Province)+
labs(title = "Landed Immigrants",x="Year",y="Unemployed")