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
132986 British Columbia 0717260BC LTD Agassiz, V0M1A2 8431-General farm workers 1 2020 N/A agassiz Primary Agriculture
158823 British Columbia 0717260BC LTD Agassiz, BC V0M 1A2 8431-General farm workers 1 2022 V0M1A2 agassiz Primary Agriculture
188751 British Columbia 0717260BC LTD Agassiz, BC V0M 1A2 8431-General farm workers 4 2021 V0M1A2 agassiz Primary Agriculture
174812 British Columbia 0718090 BC Ltd Burnaby, BC V5H 2E8 6322-Cooks 1 2016 V5H2E8 burnaby  
183335 British Columbia 0718090 BC Ltd Burnaby, BC V5H 2E8 6322-Cooks 2 2017 V5H2E8 burnaby Low Wage
174813 British Columbia 0719016 BC Ltd. Salmo, BC V0G 1Z0 6311-Food service supervisors 1 2016 V0G1Z0 salmo  
183336 British Columbia 0719016 BC Ltd. Salmo, BC V0G 1Z0 6311-Food service supervisors 1 2017 V0G1Z0 salmo Low Wage
31723 British Columbia 0719016 BC Ltd. o/a Subway Sandwiches and Salads Salmo, BC V0G 1Z0 6311-Food service supervisors 1 2019 V0G1Z0 salmo Low Wage
60307 British Columbia 0719016 bc ltd Salmo, BC V0G 1Z0 6711-Food counter attendants, kitchen helpers and related support occupations 2 2022 V0G1Z0 salmo Low Wage
122034 British Columbia 0719016 bc ltd Salmo, BC V0G 1Z0 0631-Restaurant and food service managers 1 2021 V0G1Z0 salmo High Wage
155994 British Columbia 0719016 bc ltd Salmo, BC V0G 1Z0 0631-Restaurant and food service managers 1 2022 V0G1Z0 salmo High Wage
132010 British Columbia 0719542 B.C. Ltd. (dba Ali Baba Pizza -Saanich VICTORIA, V8X1J8 6311-Food service supervisors 1 2020 N/A victoria Low Wage
31724 British Columbia 0719542 BC Ltd. dba ALI BABA PIZZA - SAANICH Victoria, BC V8W 1G9 6311-Food service supervisors 1 2019 V8W1G9 victoria Low Wage
31725 British Columbia 0719685 B.C. Ltd Port Hardy, BC V0N 2P0 6711-Food counter attendants, kitchen helpers and related support occupations 1 2019 V0N2P0 port hardy Low Wage
91660 British Columbia 0719685 BC Ltd Port Hardy, BC V0N 2P0 6711-Food counter attendants, kitchen helpers and related support occupations   2022 V0N2P0 port hardy Low Wage
16867 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6311-Food service supervisors 1 2019 V6V2R8 richmond Low Wage
16868 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6322-Cooks 2 2019 V6V2R8 richmond Low Wage
91661 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6311-Food service supervisors   2022 V6V2R8 richmond Low Wage
91662 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6322-Cooks   2022 V6V2R8 richmond Low Wage
123206 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6311-Food service supervisors 2 2021 V6V2R8 richmond Low Wage
123207 British Columbia 0720554 B.C. LTD RICHMOND, BC V6V 2R8 6322-Cooks 1 2021 V6V2R8 richmond Low Wage
91663 British Columbia 0721415 BC Ltd. VANCOUVER, BC V6B 2M8 6322-Cooks   2022 V6B2M8 vancouver Low Wage
140224 British Columbia 0722767 BC Ltd Vancouver, BC V6B 3N6 6211-Retail sales supervisors 2 2021 V6B3N6 vancouver Low Wage
24550 British Columbia 0722802 BC LTD. Burnaby, BC V3N 4N3 0651-Managers in customer and personal services, n.e.c. 1 2020 V3N4N3 burnaby Low Wage
24551 British Columbia 0722802 BC LTD. Burnaby, BC V3N 4N3 6211-Retail sales supervisors 1 2020 V3N4N3 burnaby Low Wage
60308 British Columbia 0722802 BC LTD. Burnaby, BC V3N 4N3 1311-Accounting technicians and bookkeepers 1 2022 V3N4N3 burnaby Low Wage
89829 British Columbia 0722802 BC LTD. Burnaby, BC V3N 4N3 0651-Managers in customer and personal services, n.e.c.   2022 V3N4N3 burnaby High Wage
132011 British Columbia 0722802 BC LTD. Burnaby, V3N4N3 0651-Managers in customer and personal services, n.e.c. 1 2020 N/A burnaby Low Wage
155995 British Columbia 0722802 BC LTD. Burnaby, BC V3N 4N3 1211-Supervisors, general office and administrative support workers 1 2022 V3N4N3 burnaby High Wage
70777 British Columbia 0722802 BC Ltd. BURNABY, BC V3N 4N3 0631-Restaurant and food service managers 1 2019 V3N4N3 burnaby High Wage
70778 British Columbia 0722802 BC Ltd. BURNABY, BC V3N 4N3 1123-Professional occupations in advertising, marketing and public relations 1 2019 V3N4N3 burnaby High Wage
70779 British Columbia 0722802 BC Ltd. BURNABY, BC V3N 4N3 1211-Supervisors, general office and administrative support workers 1 2019 V3N4N3 burnaby High Wage
70780 British Columbia 0722802 BC Ltd. BURNABY, BC V3N 4N3 3232-Practitioners of natural healing 2 2019 V3N4N3 burnaby High Wage
130967 British Columbia 0723206 B.C. LTD. Delta, V4C6R6 0112-Human resources managers 1 2020 N/A delta High Wage
78040 British Columbia 0724135 BC Ltd. SQUAMISH, BC V0N 1T0 6311-Food service supervisors 1 2018 V0N1T0 squamish Low Wage
78041 British Columbia 0724135 BC Ltd. SQUAMISH, BC V0N 1T0 6711-Food counter attendants, kitchen helpers and related support occupations 1 2018 V0N1T0 squamish Low Wage
139121 British Columbia 0726091 B.C. LTD. Surrey, BC V4N 0Y3 0631-Restaurant and food service managers 1 2021 V4N0Y3 surrey High Wage
162996 British Columbia 0726091 BC Ltd Surrey, BC V4N 0Y3 6322-Cooks 1 2018 V4N0Y3 surrey Low Wage
174814 British Columbia 0726091 BC Ltd Surrey, BC V4N 0Y3 6322-Cooks 1 2016 V4N0Y3 surrey  
38853 British Columbia 0726953 B.C. LTD. Abbotsford, BC V2T 1V6 6321-Chefs 1 2021 V2T1V6 abbotsford Low Wage
157307 British Columbia 0726953 B.C. LTD. ABBOTSFORD, BC V2T 1V6 6311-Food service supervisors 1 2022 V2T1V6 abbotsford Low Wage
188077 British Columbia 0726953 B.C. LTD. ABBOTSFORD, BC V2T 1V6 6322-Cooks 1 2021 V2T1V6 abbotsford Low Wage
3686 British Columbia 0726953 BC Ltd. Abbotsford, BC V2T 1V6 6322-Cooks 3 2018 V2T1V6 abbotsford Low Wage
174815 British Columbia 0726953 BC Ltd. Abbotsford, BC V2T 1V6 6322-Cooks 3 2016 V2T1V6 abbotsford  
183337 British Columbia 0726953 BC Ltd. Abbotsford, BC V2T 1V6 6322-Cooks 1 2017 V2T1V6 abbotsford Low Wage
197702 British Columbia 0726953 BC Ltd. Abbotsford, BC V2T 1V6 6322-Cooks 2 2017 V2T1V6 abbotsford Low Wage
16869 British Columbia 0726953 LTD. Abbotsford, BC V2T 1V6 6322-Cooks 1 2019 V2T1V6 abbotsford Low Wage
130968 British Columbia 0726953 LTD. Abbotsford, V2T1V6 0631-Restaurant and food service managers 1 2020 N/A abbotsford High Wage
60309 British Columbia 0727159 BC LTD Prime Rentals Sechelt, BC V7Z 0G1 1241-Administrative assistants 1 2022 V7Z0G1 sechelt Low Wage
24552 British Columbia 0729408 BC Ltd Port Hardy, BC V0N 2P0 6313-Accommodation, travel, tourism and related services supervisors 1 2020 V0N2P0 port hardy Low Wage
24553 British Columbia 0729886 BC LTD. Williams Lake, BC V2G 2W3 6322-Cooks 1 2020 V2G2W3 williams lake Low Wage
123208 British Columbia 0729886 BC LTD. Williams Lake, BC V2G 2W3 6211-Retail sales supervisors 1 2021 V2G2W3 williams lake Low Wage
130969 British Columbia 0729886 BC LTD. Williams Lake, V2G2W3 0621-Retail and wholesale trade managers 2 2020 N/A williams lake High Wage
132012 British Columbia 0729886 BC LTD. Williams Lake, V2G2W3 6211-Retail sales supervisors 1 2020 N/A williams lake Low Wage
139122 British Columbia 0729886 BC LTD. Williams Lake, BC V2G 2W3 1311-Accounting technicians and bookkeepers 1 2021 V2G2W3 williams lake High Wage
77384 British Columbia 0729886 BC Ltd. o/a Husky 100 MILE HOUSE, BC V0K 2E0 0621-Retail and wholesale trade managers 1 2018 V0K2E0 100 mile house High Wage
78042 British Columbia 0729886 BC Ltd. o/a Husky 100 MILE HOUSE, BC V0K 2E0 0631-Restaurant and food service managers 1 2018 V0K2E0 100 mile house Low Wage
97933 British Columbia 0729886 BC Ltd. o/a Husky 100 MILE HOUSE, BC V0K 2E0 6322-Cooks 2 2018 V0K2E0 100 mile house Low Wage
147733 British Columbia 0729886 BC Ltd. o/a Husky 100 Mile House, BC V0K 2E0 6211-Retail sales supervisors 1 2019 V0K2E0 100 mile house Low Wage
3687 British Columbia 0729886 BC Ltd. o/a Husky Restaurant Williams Lake, BC V2G 2W3 6211-Retail sales supervisors 2 2018 V2G2W3 williams lake Low Wage
18266 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8252-Agricultural service contractors, farm supervisors and specialized livestock workers 1 2019 V0H1T1 oliver Primary Agriculture
25841 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8252-Agricultural service contractors, farm supervisors and specialized livestock workers 1 2020 V0H1T1 oliver Primary Agriculture
25842 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8431-General farm workers 2 2020 V0H1T1 oliver Primary Agriculture
65754 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8431-General farm workers 4 2020 V0H1T1 oliver Primary Agriculture
124288 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8431-General farm workers 4 2021 V0H1T1 oliver Primary Agriculture
132987 British Columbia 0729928 BC LTD Oliver, V0H1T1 8431-General farm workers 2 2020 N/A oliver Primary Agriculture
141270 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8431-General farm workers 2 2021 V0H1T1 oliver Primary Agriculture
158824 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8252-Agricultural service contractors, farm supervisors and specialized livestock workers 1 2022 V0H1T1 oliver Primary Agriculture
158825 British Columbia 0729928 BC LTD Oliver, BC V0H 1T1 8431-General farm workers 4 2022 V0H1T1 oliver Primary Agriculture
98454 British Columbia 0729928 BC Ltd Oliver, BC V0H 1T1 8431-General farm workers 3 2018 V0H1T1 oliver Primary Agriculture
148486 British Columbia 0729928 BC Ltd Oliver, BC V0H 1T1 8431-General farm workers 5 2019 V0H1T1 oliver Primary Agriculture
198759 British Columbia 0729928 BC Ltd Oliver, BC V0H 1T1 8252-Agricultural service contractors, farm supervisors and specialized livestock workers 2 2017 V0H1T1 oliver Primary Agriculture
198760 British Columbia 0729928 BC Ltd Oliver, BC V0H 1T1 8431-General farm workers 5 2017 V0H1T1 oliver Primary Agriculture
78664 British Columbia 0729947 BC Ltd. SURREY, BC V3S 3H5 8431-General farm workers 6 2018 V3S3H5 surrey Primary Agriculture
60310 British Columbia 0730316 B.C. Ltd Gold River, BC V0P 1G0 6731-Light duty cleaners 1 2022 V0P1G0 gold river Low Wage
23255 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 1241-Administrative assistants 1 2020 V3R3P6 surrey High Wage
23256 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers 1 2020 V3R3P6 surrey High Wage
58806 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 1241-Administrative assistants 1 2022 V3R3P6 surrey High Wage
60311 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 1411-General office support workers 1 2022 V3R3P6 surrey Low Wage
139123 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 0124-Advertising, marketing and public relations managers 1 2021 V3R3P6 surrey High Wage
139124 British Columbia 0731534 BC Ltd. Surrey, BC V3R 3P6 7301-Contractors and supervisors, mechanic trades 1 2021 V3R3P6 surrey High Wage
162604 British Columbia 0731973 BC Ltd dba Kay Mart Vancouver, BC V5R 4G8 0621-Retail and wholesale trade managers 1 2018 V5R4G8 vancouver High Wage
174816 British Columbia 0731973 BC Ltd dba Kay Mart Vancouver, BC V5R 4G8 6211-Retail sales supervisors 1 2016 V5R4G8 vancouver  
197703 British Columbia 0733078 BC LTD Vancouver, BC V6B 2W1 0631-Restaurant and food service managers 1 2017 V6B2W1 vancouver Low Wage
16870 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6211-Retail sales supervisors 1 2019 V8J1A8 prince rupert Low Wage
16871 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6316-Other services supervisors 1 2019 V8J1A8 prince rupert Low Wage
16872 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6322-Cooks 1 2019 V8J1A8 prince rupert Low Wage
60312 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6316-Other services supervisors 1 2022 V8J1A8 prince rupert Low Wage
72007 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6313-Accommodation, travel, tourism and related services supervisors 1 2019 V8J1A8 prince rupert Low Wage
91664 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6322-Cooks   2022 V8J1A8 prince rupert Low Wage
157308 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6311-Food service supervisors 1 2022 V8J1A8 prince rupert Low Wage
157309 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6313-Accommodation, travel, tourism and related services supervisors 1 2022 V8J1A8 prince rupert Low Wage
157310 British Columbia 0733244 BC LTD Prince Rupert, BC V8J 1A8 6322-Cooks 2 2022 V8J1A8 prince rupert Low Wage
18267 British Columbia 0733885 B.C. LTD dba Horsting's Farm Market Chilliwack, BC V2P 7N1 8431-General farm workers 18 2019 V2P7N1 chilliwack Primary Agriculture
25843 British Columbia 0733885 B.C. LTD dba Horsting's Farm Market CHILLIWACK, BC V2P 7N1 8431-General farm workers 4 2020 V2P7N1 chilliwack Primary Agriculture
39621 British Columbia 0733885 B.C. LTD dba Horsting's Farm Market Chilliwack, BC V2P 7N1 8431-General farm workers 5 2021 V2P7N1 chilliwack Primary Agriculture
62155 British Columbia 0733885 B.C. LTD dba Horsting's Farm Market Chilliwack, BC V2P 7N1 8431-General farm workers 1 2022 V2P7N1 chilliwack Primary Agriculture
158826 British Columbia 0733885 B.C. LTD dba Horsting's Farm Market Chilliwack, BC V2P 7N1 8431-General farm workers 14 2022 V2P7N1 chilliwack Primary Agriculture
48111 British Columbia 0733885 BC LTD Cache Creek, BC V0K 1H0 8431-General farm workers 17 2020 V0K1H0 cache creek Primary Agriculture
188752 British Columbia 0733885 BC LTD CACHE CREEK, BC V0K 1H0 8431-General farm workers 3 2021 V0K1H0 cache creek 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);