[{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Canada","province_code":"CA","is_national":1,"job_vacancies":445285,"payroll_employees":15088415,"vacancy_rate_pct":2.9,"unemployed_persons":1314600,"tightness_ratio":2.9522665259328296,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"c69dc73a6c914393"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Newfoundland and Labrador","province_code":"NL","is_national":0,"job_vacancies":null,"payroll_employees":203515,"vacancy_rate_pct":null,"unemployed_persons":34367,"tightness_ratio":null,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"a023eb10d83ea01a"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Prince Edward Island","province_code":"PE","is_national":0,"job_vacancies":null,"payroll_employees":58575,"vacancy_rate_pct":null,"unemployed_persons":8700,"tightness_ratio":null,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"e6f27eb4914c06ab"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Nova Scotia","province_code":"NS","is_national":0,"job_vacancies":10460,"payroll_employees":381070,"vacancy_rate_pct":2.7,"unemployed_persons":44933,"tightness_ratio":4.295697896749522,"tightness_rank":6,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"818144045f655996"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"New Brunswick","province_code":"NB","is_national":0,"job_vacancies":6095,"payroll_employees":284835,"vacancy_rate_pct":2.1,"unemployed_persons":39800,"tightness_ratio":6.52994257588187,"tightness_rank":8,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"3dd119f01c09f33f"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Quebec","province_code":"QC","is_national":0,"job_vacancies":67250,"payroll_employees":3336985,"vacancy_rate_pct":2.0,"unemployed_persons":336233,"tightness_ratio":4.999747211895911,"tightness_rank":7,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"86b95b2b2b119c5c"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Ontario","province_code":"ON","is_national":0,"job_vacancies":165260,"payroll_employees":5747640,"vacancy_rate_pct":2.8,"unemployed_persons":511433,"tightness_ratio":3.0947174149824517,"tightness_rank":5,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"453d65ed511c154d"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Manitoba","province_code":"MB","is_national":0,"job_vacancies":15450,"payroll_employees":562550,"vacancy_rate_pct":2.7,"unemployed_persons":37667,"tightness_ratio":2.4379935275080906,"tightness_rank":4,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"a4a857ff2df49368"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Saskatchewan","province_code":"SK","is_national":0,"job_vacancies":15475,"payroll_employees":466215,"vacancy_rate_pct":3.2,"unemployed_persons":28267,"tightness_ratio":1.8266235864297253,"tightness_rank":2,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"20985709fa8f27e0"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Alberta","province_code":"AB","is_national":0,"job_vacancies":83865,"payroll_employees":2025505,"vacancy_rate_pct":4.0,"unemployed_persons":125967,"tightness_ratio":1.5020211053478805,"tightness_rank":1,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"62ee103fa0b5466f"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"British Columbia","province_code":"BC","is_national":0,"job_vacancies":73240,"payroll_employees":1973085,"vacancy_rate_pct":3.6,"unemployed_persons":147233,"tightness_ratio":2.0102812670671764,"tightness_rank":3,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"3b6e2a7bc160335a"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Yukon","province_code":"YT","is_national":0,"job_vacancies":null,"payroll_employees":15750,"vacancy_rate_pct":null,"unemployed_persons":null,"tightness_ratio":null,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"a29b252b8a724a9b"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Northwest Territories","province_code":"NT","is_national":0,"job_vacancies":null,"payroll_employees":22360,"vacancy_rate_pct":null,"unemployed_persons":null,"tightness_ratio":null,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"77a4ba119457ad26"},{"quarter":"2015-01-01","country_code":"CAN","geo_name":"Nunavut","province_code":"NU","is_national":0,"job_vacancies":null,"payroll_employees":10330,"vacancy_rate_pct":null,"unemployed_persons":null,"tightness_ratio":null,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"430a33a4de9bc3b7"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"Canada","province_code":"CA","is_national":1,"job_vacancies":423815,"payroll_employees":15138940,"vacancy_rate_pct":2.7,"unemployed_persons":1329500,"tightness_ratio":3.1369819378738364,"tightness_rank":null,"tightness_z_12q":null,"vacancy_rate_qoq_pp":-0.19999999999999973,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":0.18471541194100682,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":1,"source_table":"14100398+14100287","row_hash":"127e777ec99b9165"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"Newfoundland and Labrador","province_code":"NL","is_national":0,"job_vacancies":4700,"payroll_employees":205470,"vacancy_rate_pct":2.2,"unemployed_persons":37400,"tightness_ratio":7.957446808510638,"tightness_rank":10,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"c224d845a839e5f7"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"Prince Edward Island","province_code":"PE","is_national":0,"job_vacancies":1260,"payroll_employees":57885,"vacancy_rate_pct":2.1,"unemployed_persons":9000,"tightness_ratio":7.142857142857143,"tightness_rank":9,"tightness_z_12q":null,"vacancy_rate_qoq_pp":null,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":null,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"d3d0d559ebe67fd0"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"Nova Scotia","province_code":"NS","is_national":0,"job_vacancies":11080,"payroll_employees":382660,"vacancy_rate_pct":2.8,"unemployed_persons":44367,"tightness_ratio":4.004241877256318,"tightness_rank":6,"tightness_z_12q":null,"vacancy_rate_qoq_pp":0.09999999999999964,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":-0.29145601949320454,"tightness_yoy":null,"tightening_flag":1,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"cbc598c2011cb584"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"New Brunswick","province_code":"NB","is_national":0,"job_vacancies":8915,"payroll_employees":285735,"vacancy_rate_pct":3.0,"unemployed_persons":41100,"tightness_ratio":4.610207515423443,"tightness_rank":7,"tightness_z_12q":null,"vacancy_rate_qoq_pp":0.8999999999999999,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":-1.919735060458427,"tightness_yoy":null,"tightening_flag":1,"loosening_flag":0,"source_table":"14100398+14100287","row_hash":"abad15b8214b2ee9"},{"quarter":"2015-04-01","country_code":"CAN","geo_name":"Quebec","province_code":"QC","is_national":0,"job_vacancies":62900,"payroll_employees":3344710,"vacancy_rate_pct":1.8,"unemployed_persons":344367,"tightness_ratio":5.47483306836248,"tightness_rank":8,"tightness_z_12q":null,"vacancy_rate_qoq_pp":-0.19999999999999996,"vacancy_rate_yoy_pp":null,"vacancies_yoy_pct":null,"tightness_qoq":0.47508585646656964,"tightness_yoy":null,"tightening_flag":0,"loosening_flag":1,"source_table":"14100398+14100287","row_hash":"338786bbafc3675c"}]