Data license: http://open.canada.ca/en/open-government-licence-canada · Data source: https://open.canada.ca/data/en/dataset/90fed587-1364-4f33-a9ee-208181dc0b97

199,957 rows sorted by employer

View and edit SQL

Link rowid province_territory employer ▼ address occupations positions_approved phase zipcode city stream
33345 New Brunswick 057033 NB Inc Shediac, NB E4P 2K9 3413-Nurse aides, orderlies and patient service associates 3 2021 E4P2K9 shediac Low Wage
116165 New Brunswick 057033 NB Inc Shediac, NB E4P 2K9 3413-Nurse aides, orderlies and patient service associates 2 2021 E4P2K9 shediac Low Wage
133662 New Brunswick 057033 NB Inc Shediac, NB E4P 2K9 4412-Home support workers, housekeepers and related occupations 2 2021 E4P2K9 shediac Low Wage
99371 New Brunswick 058249 NB LTD Sussex, NB E4E 3E5 6311-Food service supervisors 11 2022 E4E3E5 sussex Low Wage
197695 British Columbia 0592820 B.C. Ltd Kelowna, BC V1Y 6C6 6311-Food service supervisors 1 2017 V1Y6C6 kelowna Low Wage
97931 British Columbia 0601289 BC Ltd DBA Kelly O'Bryan's Neighborhood Restaurant Vernon, BC V1T 5P3 6321-Chefs 2 2018 V1T5P3 vernon Low Wage
45998 British Columbia 0629515 BC Ltd DBA Fruiticana #19 Surrey, BC V3W 1S9 1311-Accounting technicians and bookkeepers 1 2020 V3W1S9 surrey High Wage
197696 British Columbia 0636060 B.C. Ltd Surrey, BC V3W 4G2 6211-Retail sales supervisors 1 2017 V3W4G2 surrey Low Wage
199270 British Columbia 0639503 B.C. Ltd Campbell River, BC V9H 0B5 6211-Retail sales supervisors 1 2017 V9H0B5 campbell river Permanent Resident Only
114433 British Columbia 0639503 BC LTD. Campbell River, BC V9W 2G5 6211-Retail sales supervisors 1 2022 V9W2G5 campbell river Low Wage
122032 British Columbia 0639503 BC LTD. Campbell River, BC V9W 2G5 0621-Retail and wholesale trade managers 1 2021 V9W2G5 campbell river High Wage
157302 British Columbia 0639503 BC Ltd o/a Campbell River Chevron Campbell River, BC V9W 1B2 6211-Retail sales supervisors 1 2022 V9W1B2 campbell river Low Wage
97932 British Columbia 0639503 BC Ltd. o/a Port Hardy Town Pantry Campbell River, BC V9H 0B5 6211-Retail sales supervisors 1 2018 V9H0B5 campbell river Low Wage
157303 British Columbia 0640203 BC Ltd Vancouver, BC V5V 3E1 6311-Food service supervisors 1 2022 V5V3E1 vancouver Low Wage
15534 British Columbia 0640548 B.C. LTD. Burnaby, BC V3N 1B9 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers 1 2019 V3N1B9 burnaby High Wage
23252 British Columbia 0640548 B.C. LTD. Burnaby, BC V3N 1B9 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers 1 2020 V3N1B9 burnaby High Wage
89827 British Columbia 0640548 B.C. LTD. Burnaby, BC V3N 1B9 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers   2022 V3N1B9 burnaby High Wage
130966 British Columbia 0640548 B.C. LTD. Burnaby, V3N1B9 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers 1 2020 N/A burnaby High Wage
197697 British Columbia 0652339 BC Ltd. (dba) Round Table Pizza & India Cuisine Richmond, BC V6Y 3Y8 6311-Food service supervisors 1 2017 V6Y3Y8 richmond Low Wage
15535 British Columbia 0663389 B.C. LTD. SURREY, BC V4N 0K1 6315-Cleaning supervisors 1 2019 V4N0K1 surrey High Wage
147731 British Columbia 0684849 Manitoba Limited HOUSTON, BC V0J 1Z0 6211-Retail sales supervisors 2 2019 V0J1Z0 houston Low Wage
174805 British Columbia 0688654 BC Inc. Surrey, BC V3W 3V6 0621-Retail and wholesale trade managers 1 2016 V3W3V6 surrey  
146721 British Columbia 0688654 BC Inc. o/a Best Choice Kitchen Cabinets Surrey, BC V3W 3V6 1221-Administrative officers 1 2019 V3W3V6 surrey High Wage
24545 British Columbia 0691503 BC Ltd Vancouver, BC V5N 4B9 6322-Cooks 2 2020 V5N4B9 vancouver Low Wage
46994 British Columbia 0691503 BC Ltd Vancouver, BC V5N 4B9 6311-Food service supervisors 1 2020 V5N4B9 vancouver Low Wage
91656 British Columbia 0691503 BC Ltd Vancouver, BC V5N 4B9 6322-Cooks   2022 V5N4B9 vancouver Low Wage
157304 British Columbia 0691503 BC Ltd Vancouver, BC V5N 4B9 6311-Food service supervisors 1 2022 V5N4B9 vancouver Low Wage
157305 British Columbia 0691503 BC Ltd Vancouver, BC V5N 4B9 6322-Cooks 1 2022 V5N4B9 vancouver Low Wage
91657 British Columbia 0691877 B.C. LTD. Vancouver, BC V5P 1J8 6311-Food service supervisors   2022 V5P1J8 vancouver Low Wage
91658 British Columbia 0691877 B.C. LTD. Vancouver, BC V5P 1J8 6322-Cooks   2022 V5P1J8 vancouver Low Wage
140219 British Columbia 0691877 B.C. LTD. Vancouver, BC V5P 1J8 6322-Cooks 2 2021 V5P1J8 vancouver Low Wage
123205 British Columbia 0691913 BC Ltd Kelowna, BC V1Y 9P6 4412-Home support workers, housekeepers and related occupations 1 2021 V1Y9P6 kelowna Low Wage
89828 British Columbia 0692925 B.C. LTD Nanaimo, BC V9R 3A2 0632-Accommodation service managers   2022 V9R3A2 nanaimo High Wage
46995 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6322-Cooks 1 2020 V3B5R5 coquitlam Low Wage
60302 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6311-Food service supervisors 1 2022 V3B5R5 coquitlam Low Wage
60303 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6322-Cooks 1 2022 V3B5R5 coquitlam Low Wage
114434 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6322-Cooks 1 2022 V3B5R5 coquitlam Low Wage
132009 British Columbia 0693642 B.C. LTD Coquitlam, V3B5R5 6322-Cooks 1 2020 N/A coquitlam Low Wage
140220 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6322-Cooks 1 2021 V3B5R5 coquitlam Low Wage
157306 British Columbia 0693642 B.C. LTD Coquitlam, BC V3B 5R5 6322-Cooks 2 2022 V3B5R5 coquitlam Low Wage
8651 British Columbia 0693642 BC Ltd Coquitlam, BC V3B 5R5 6322-Cooks 1 2017 V3B5R5 coquitlam Low Wage
174806 British Columbia 0693642 BC Ltd Coquitlam, BC V3B 5R5 6322-Cooks 1 2016 V3B5R5 coquitlam  
78036 British Columbia 0693642 BC Ltd. o/a Koya Japan Coquitlam, BC V3B 5R5 6322-Cooks 1 2018 V3B5R5 coquitlam Low Wage
174807 British Columbia 0694167 BC Ltd. New Westminster, BC V3L 3X5 6311-Food service supervisors 1 2016 V3L3X5 new westminster  
31720 British Columbia 0695313 BC Ltd PORT COQUITLAM, BC V3C 3B5 6711-Food counter attendants, kitchen helpers and related support occupations 1 2019 V3C3B5 port coquitlam Low Wage
3166 British Columbia 0695845 BC Ltd. Dawson Creek, BC V1G 4Y5 6315-Cleaning supervisors 1 2018 V1G4Y5 dawson creek High Wage
8652 British Columbia 0695845 BC Ltd. Dawson Creek, BC V1G 4Y5 6313-Accommodation, travel, tourism and related services supervisors 1 2017 V1G4Y5 dawson creek Low Wage
72006 British Columbia 0695845 BC Ltd. Dawson Creek, BC V1G 4Y5 6312-Executive housekeepers 1 2019 V1G4Y5 dawson creek Low Wage
197698 British Columbia 0695845 BC Ltd. Dawson Creek, BC V1G 4Y5 6315-Cleaning supervisors 1 2017 V1G4Y5 dawson creek Low Wage
78037 British Columbia 0695845 BC Ltd. o/a Aurora Park Inn & Suites Dawson Creek, BC V1G 4Y5 6313-Accommodation, travel, tourism and related services supervisors 1 2018 V1G4Y5 dawson creek Low Wage
174808 British Columbia 0696787BC LTD- Chop Shop Cycle Richmond, BC V6V 2X5 6211-Retail sales supervisors 1 2016 V6V2X5 richmond  
46996 British Columbia 0697655 B.C. LTD. Nanoose Bay, BC V9P 9C2 6322-Cooks 1 2020 V9P9C2 nanoose bay Low Wage
4306 British Columbia 0699840 B.C. Ltd. VANCOUVER, BC V5P 3S9 8252-Agricultural service contractors, farm supervisors and specialized livestock workers 2 2018 V5P3S9 vancouver Primary Agriculture
4307 British Columbia 0699840 B.C. Ltd. VANCOUVER, BC V5P 3S9 8431-General farm workers 10 2018 V5P3S9 vancouver Primary Agriculture
70776 British Columbia 07 GN Autobody Ltd BURNABY, BC V5C 3W9 7322-Motor vehicle body repairers 1 2019 V5C3W9 burnaby High Wage
15536 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 0631-Restaurant and food service managers 1 2019 V5H2G3 burnaby High Wage
24546 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 2 2020 V5H2G3 burnaby Low Wage
140221 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6322-Cooks 1 2021 V5H2G3 burnaby Low Wage
140222 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2021 V5H2G3 burnaby Low Wage
155993 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 0631-Restaurant and food service managers 1 2022 V5H2G3 burnaby High Wage
174809 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6322-Cooks 1 2016 V5H2G3 burnaby  
174810 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2016 V5H2G3 burnaby  
183333 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6321-Chefs 1 2017 V5H2G3 burnaby Low Wage
197699 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6322-Cooks 1 2017 V5H2G3 burnaby Low Wage
197700 British Columbia 0704250 BC Ltd. Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2017 V5H2G3 burnaby Low Wage
31721 British Columbia 0704250 BC Ltd. o/a Assi Supermarket Burnaby, BC V5H 2G3 6322-Cooks 1 2019 V5H2G3 burnaby Low Wage
31722 British Columbia 0704250 BC Ltd. o/a Assi Supermarket Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2019 V5H2G3 burnaby Low Wage
147732 British Columbia 0704250 BC Ltd. o/a Assi Supermarket Burnaby, BC V5H 2G3 6331-Butchers, meat cutters and fishmongers - retail and wholesale 2 2019 V5H2G3 burnaby Low Wage
60304 British Columbia 0704571 B.C. Ltd Surrey, BC V3R 8X8 6322-Cooks 1 2022 V3R8X8 surrey Low Wage
16866 British Columbia 0705388 B.C. LTD. Burnaby, BC V3N 3M9 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2019 V3N3M9 burnaby Low Wage
91659 British Columbia 0706925 BC LTD. MAPLE RIDGE, BC V2X 2R2 6322-Cooks   2022 V2X2R2 maple ridge Low Wage
114435 British Columbia 0706925 BC LTD. MAPLE RIDGE, BC V2X 2R2 6322-Cooks 1 2022 V2X2R2 maple ridge Low Wage
140223 British Columbia 0706925 BC LTD. MAPLE RIDGE, BC V2X 2R2 6322-Cooks 1 2021 V2X2R2 maple ridge Low Wage
8653 British Columbia 0706925 BC Ltd Maple Ridge, BC V3V 1C6 0631-Restaurant and food service managers 1 2017 V3V1C6 maple ridge Low Wage
162995 British Columbia 0706925 BC Ltd Maple Ridge, BC V3V 1C6 6322-Cooks 3 2018 V3V1C6 maple ridge Low Wage
25839 British Columbia 0707430 BC LTD Delta, BC V4G 1E2 8431-General farm workers 1 2020 V4G1E2 delta Primary Agriculture
183334 British Columbia 0707791 B.C Ltd. Richmond, BC V6X 3A5 3232-Practitioners of natural healing 1 2017 V6X3A5 richmond Low Wage
23253 British Columbia 0708278 B.C. LTD. Surrey, BC V3R 3P4 0631-Restaurant and food service managers 1 2020 V3R3P4 surrey High Wage
23254 British Columbia 0708278 B.C. LTD. Surrey, BC V3R 3P4 6322-Cooks 1 2020 V3R3P4 surrey High Wage
24547 British Columbia 0708278 B.C. LTD. Surrey, BC V3R 3P4 6322-Cooks 1 2020 V3R3P4 surrey Low Wage
78038 British Columbia 0708278 BC Ltd o/a Non Stop Pizza Inc. SURREY, BC V3W 3N1 6322-Cooks 1 2018 V3W3N1 surrey Low Wage
3685 British Columbia 0709945 BC Ltd. Pitt Meadows, BC V3Y 2W1 6311-Food service supervisors 1 2018 V3Y2W1 pitt meadows Low Wage
197701 British Columbia 0709945 BC Ltd. Pitt Meadows, BC V3Y 2W1 6311-Food service supervisors 1 2017 V3Y2W1 pitt meadows Low Wage
3167 British Columbia 0711584 BC Ltd. GIBSONS, BC V0N 1V8 0632-Accommodation service managers 1 2018 V0N1V8 gibsons High Wage
46997 British Columbia 0712261 BC LTD Coquitlam, BC V3K 4X8 6331-Butchers, meat cutters and fishmongers - retail and wholesale 1 2020 V3K4X8 coquitlam Low Wage
60305 British Columbia 0712261 BC LTD Coquitlam, BC V3K 4X8 6331-Butchers, meat cutters and fishmongers - retail and wholesale 2 2022 V3K4X8 coquitlam Low Wage
24548 British Columbia 0714400 B.C. LTD. Delta, BC V4C 6P5 6311-Food service supervisors 1 2020 V4C6P5 delta Low Wage
139120 British Columbia 0714576 B.C. Ltd. Courtenay, BC V9N 8P1 6211-Retail sales supervisors 1 2021 V9N8P1 courtenay High Wage
30823 British Columbia 0714576 B.C. Ltd. o/a Ashley Homestore COURTENAY, BC V9N 8P1 1241-Administrative assistants 1 2019 V9N8P1 courtenay High Wage
78039 British Columbia 0714576 B.C. Ltd. o/a Ashley Homestore COURTENAY, BC V9N 8P1 6211-Retail sales supervisors 1 2018 V9N8P1 courtenay Low Wage
122033 British Columbia 0714773 BC Ltd O/A Packaging Depot Burnaby, BC V5E 1C5 1221-Administrative officers 1 2021 V5E1C5 burnaby High Wage
77383 British Columbia 0714773 BC Ltd. Burnaby, BC V5E 1C5 1215-Supervisors, supply chain, tracking and scheduling co-ordination occupations 1 2018 V5E1C5 burnaby High Wage
24549 British Columbia 0715398 B.C. LTD DELTA, BC V4M 4G6 6311-Food service supervisors 1 2020 V4M4G6 delta Low Wage
60306 British Columbia 0715398 B.C. LTD DELTA, BC V4M 4G6 6311-Food service supervisors 1 2022 V4M4G6 delta Low Wage
4308 British Columbia 0717260 BC Ltd Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 7 2018 V0M1A2 agassiz Primary Agriculture
9116 British Columbia 0717260 BC Ltd Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 9 2017 V0M1A2 agassiz Primary Agriculture
18265 British Columbia 0717260 BC Ltd Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 9 2019 V0M1A2 agassiz Primary Agriculture
174811 British Columbia 0717260 BC Ltd Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 7 2016 V0M1A2 agassiz  
183865 British Columbia 0717260 BC Ltd Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 3 2017 V0M1A2 agassiz Primary Agriculture
25840 British Columbia 0717260BC LTD Agassiz, BC V0M 1A2 8432-Nursery and greenhouse workers 6 2020 V0M1A2 agassiz Primary Agriculture

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "all" (province_territory TEXT, employer TEXT, address TEXT, occupations TEXT, positions_approved INTEGER, phase INTEGER, zipcode TEXT, city TEXT, stream TEXT);