all_fts

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

This data as json, CSV (advanced)

Link rowid employer ▼ occupations address phase province_territory stream all_fts docid __langid
64965 64965 "Real Estate Movers" Inc. 7511-Transport truck drivers Calgary, AB T2C 2E3 2020 Alberta Low Wage   64965 0
3681 3681 #1 Happy Hair Cut & Beauty Parlor Ltd. 6341-Hairstylists and barbers Surrey, BC V3W 3N1 2018 British Columbia Low Wage   3681 0
183332 183332 #1 Happy Hair Cut & Beauty Parlor Ltd. 6341-Hairstylists and barbers Surrey, BC V3W 3N1 2017 British Columbia Low Wage   183332 0
122031 122031 #1 Impex Canada Ltd. 6211-Retail sales supervisors Surrey, BC V3W 0K8 2021 British Columbia High Wage   122031 0
16864 16864 #4 Happy Haircut & Beauty Salon Ltd. 6341-Hairstylists and barbers Surrey, BC V4N 0Y3 2019 British Columbia Low Wage   16864 0
24543 24543 #4 Happy Haircut & Beauty Salon Ltd. 6341-Hairstylists and barbers Surrey, BC V4N 0Y3 2020 British Columbia Low Wage   24543 0
70775 70775 #4 Happy Haircut & Beauty Salon Ltd. 0651-Managers in customer and personal services, n.e.c. Surrey, BC V4N 0Y3 2019 British Columbia High Wage   70775 0
174801 174801 #4 Happy Haircut and Beauty Salon 6341-Hairstylists and barbers Surrey, BC V4N 0Y3 2016 British Columbia     174801 0
3164 3164 #4 Happy Haircut and Beauty Salon Ltd 0651-Managers in customer and personal services, n.e.c. Surrey, BC V4N 0Y3 2018 British Columbia High Wage   3164 0
3682 3682 #4 Happy Haircut and Beauty Salon Ltd 6341-Hairstylists and barbers Surrey, BC V4N 0Y3 2018 British Columbia Low Wage   3682 0
146720 146720 #4 Happy Haircut and Beauty Salon Ltd 6341-Hairstylists and barbers SURREY, BC V4N 0Y3 2019 British Columbia High Wage   146720 0
103592 103592 (9221-6043 Québec Inc.) Pép. Gravel et Filles 8432-Nursery and greenhouse workers Blainville, QC J7B 0C6 2022 Quebec Primary Agriculture   103592 0
117018 117018 (9221-6043 Québec Inc.) Pép. Gravel et Filles 8432-Nursery and greenhouse workers BLAINVILLE, QC J7E 4H5 2021 Quebec Primary Agriculture   117018 0
126047 126047 (9221-6043 Québec Inc.) Pép. Gravel et Filles 8432-Nursery and greenhouse workers BLAINVILLE, J7E4H5 2020 Quebec Primary Agriculture   126047 0
150356 150356 (9221-6043 Québec Inc.) Pép. Gravel et Filles 8432-Nursery and greenhouse workers BLAINVILLE, QC J7E 4H5 2022 Quebec Primary Agriculture   150356 0
94895 94895 (9221-6043 Québec inc.) Pépinière Gravel et Filles 8432-Nursery and greenhouse workers Blainville, QC J7E 4H5 2018 Quebec Primary Agriculture   94895 0
142531 142531 (9221-6043 Québec inc.) Pépinière Gravel et Filles 8432-Nursery and greenhouse workers Blainville, QC J7E 4H5 2019 Quebec Primary Agriculture   142531 0
10218 10218 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2019 Quebec Primary Agriculture   10218 0
34036 34036 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2021 Quebec Primary Agriculture   34036 0
63184 63184 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2020 Quebec Primary Agriculture   63184 0
81950 81950 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2022 Quebec Primary Agriculture   81950 0
103593 103593 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2022 Quebec Primary Agriculture   103593 0
117019 117019 (9274-5678 QC inc.) Vignoble St-Thomas 8431-General farm workers SAINT-THOMAS, QC J0K 3L0 2021 Quebec Primary Agriculture   117019 0
10219 10219 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2019 Quebec Primary Agriculture   10219 0
34037 34037 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2021 Quebec Primary Agriculture   34037 0
41252 41252 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2020 Quebec Primary Agriculture   41252 0
63185 63185 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2020 Quebec Primary Agriculture   63185 0
81951 81951 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2022 Quebec Primary Agriculture   81951 0
103594 103594 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2022 Quebec Primary Agriculture   103594 0
134682 134682 (9386-9584 Québec inc.) Les Jardins Hervieux 8431-General farm workers L'ASSOMPTION, QC J5W 1Z8 2021 Quebec Primary Agriculture   134682 0
166676 166676 (Formely PWGSC) SPAC-PSPC 5125-Translators, terminologists and interpreters Ottawa, ON K1A 0S5 2016 Ontario     166676 0
72982 72982 (blank) 6311-Food service supervisors Pitt Meadows, BC V3Y 2J4 2019 British Columbia Low Wage   72982 0
72983 72983 (blank) 6322-Cooks Surrey, BC V3W 1R1 2019 British Columbia Low Wage   72983 0
73438 73438 (blank) 1111-Financial auditors and accountants Snoqualmie, 98065 2019 Employers carrying on business in Canada with Head Office outside of Canada High Wage   73438 0
73439 73439 (blank) 2174-Computer programmers and interactive media developers Snoqualmie, 98065 2019 Employers carrying on business in Canada with Head Office outside of Canada High Wage   73439 0
73440 73440 (blank) 4011-University professors and lecturers Snoqualmie, 98065 2019 Employers carrying on business in Canada with Head Office outside of Canada High Wage   73440 0
79583 79583 .ct tech inc. 5241-Graphic designers and illustrators Québec, QC G1N 4L2 2022 Quebec High Wage   79583 0
159663 159663 /NSPRO Inc. 2171-Information systems analysts and consultants Montréal, QC H2Y 2R6 2018 Quebec High Wage   159663 0
3683 3683 002 Wings Tap & Grill Kingsway Ltd. 6322-Cooks Burnaby, BC V5E 1E4 2018 British Columbia Low Wage   3683 0
190722 190722 002154248 Ontario Inc. 1123-Professional occupations in advertising, marketing and public relations Toronto, ON M9W 5M7 2017 Ontario High Wage   190722 0
190723 190723 002154248 Ontario Inc. 1221-Administrative officers Toronto, ON M9W 5M7 2017 Ontario High Wage   190723 0
166677 166677 002173263 Aum Associates Inc. 6311-Food service supervisors Pickering, ON L1T 2W4 2016 Ontario     166677 0
12245 12245 002298554 Ontario Inc. 6562-Estheticians, electrologists and related occupations Brampton, ON L6R 3P1 2019 Ontario Low Wage   12245 0
42972 42972 002298554 Ontario Inc. 6341-Hairstylists and barbers Brampton, ON L6R 3P1 2020 Ontario Low Wage   42972 0
151628 151628 002365781 Ontairo Inc 7251-Plumbers Toronto, ON M4G 1Z3 2022 Ontario High Wage   151628 0
166678 166678 002365781 Ontario Inc. 7251-Plumbers Toronto, ON M4G 1Z3 2016 Ontario     166678 0
190724 190724 002365781 Ontario Inc. 7251-Plumbers Toronto, ON M4G 1Z3 2017 Ontario High Wage   190724 0
27845 27845 002419322 Ontario Inc. o/a Khinda Construction Ltd. 1241-Administrative assistants BRAMPTON, ON L6W 3J5 2019 Ontario High Wage   27845 0
74746 74746 002419322 Ontario Inc. o/a Khinda Construction Ltd. 1221-Administrative officers BRAMPTON, ON L6W 3J5 2018 Ontario High Wage   74746 0
105421 105421 002555592 Ontario Inc. 1241-Administrative assistants Brampton, ON L6V 2A3 2022 Ontario High Wage   105421 0
118371 118371 002555592 Ontario Inc. 1311-Accounting technicians and bookkeepers Brampton, ON L6V 2A3 2021 Ontario High Wage   118371 0
151629 151629 002555592 Ontario Inc. 1311-Accounting technicians and bookkeepers Brampton, ON L6V 2A3 2022 Ontario High Wage   151629 0
107150 107150 00949710 ONTARIO LIMITED 7237-Welders and related machine operators MISSISSAUGA, ON L4T 3M6 2022 Ontario Low Wage   107150 0
97929 97929 00993938 BC Ltd 6211-Retail sales supervisors HOPE, BC V0X 1L2 2018 British Columbia Low Wage   97929 0
97930 97930 00993938 BC Ltd 6611-Cashiers HOPE, BC V0X 1L2 2018 British Columbia Low Wage   97930 0
197692 197692 00993938 BC Ltd 6211-Retail sales supervisors Hope, BC V0X 1L2 2017 British Columbia Low Wage   197692 0
4304 4304 0137474 B.C. LTD. 8431-General farm workers ABBOTSFORD, BC V3G 2G2 2018 British Columbia Primary Agriculture   4304 0
4305 4305 0137474 B.C. LTD. 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3G 2G2 2018 British Columbia Primary Agriculture   4305 0
9115 9115 0137474 B.C. LTD. 8432-Nursery and greenhouse workers Abbotsford, BC V3G 2G2 2017 British Columbia Primary Agriculture   9115 0
72984 72984 0137474 B.C. LTD. 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3G 2G2 2019 British Columbia Primary Agriculture   72984 0
98453 98453 0137474 B.C. LTD. 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3G 2G2 2018 British Columbia Primary Agriculture   98453 0
18264 18264 0137474 BC Ltd 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3A 2A2 2019 British Columbia Primary Agriculture   18264 0
25838 25838 0137474 BC Ltd 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3G 2G2 2020 British Columbia Primary Agriculture   25838 0
48110 48110 0137474 BC Ltd 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3G 2G2 2020 British Columbia Primary Agriculture   48110 0
65753 65753 0137474 BC Ltd 8432-Nursery and greenhouse workers ABBOTSFORD, BC V3A 2A2 2020 British Columbia Primary Agriculture   65753 0
174802 174802 0137474 BC Ltd 8432-Nursery and greenhouse workers Abbotsford, BC V3G 2G2 2016 British Columbia     174802 0
188750 188750 0137474 BC Ltd 8431-General farm workers ABBOTSFORD, BC V3G 2G2 2021 British Columbia Primary Agriculture   188750 0
198758 198758 0137474 BC Ltd 8432-Nursery and greenhouse workers Abbotsford, BC V3G 2G2 2017 British Columbia Primary Agriculture   198758 0
12246 12246 02442736 ONTARIO INC 6211-Retail sales supervisors Kingston, ON K7M 3E9 2019 Ontario Low Wage   12246 0
180748 180748 0301 Inc. 1311-Accounting technicians and bookkeepers Milton, ON L9T 1N8 2017 Ontario High Wage   180748 0
8650 8650 0345892 BC Ltd 6321-Chefs Kamloops, BC V2C 2A3 2017 British Columbia Low Wage   8650 0
24544 24544 0345892 BC Ltd. 0631-Restaurant and food service managers Kamloops, BC V2C 2A3 2020 British Columbia Low Wage   24544 0
91654 91654 0345892 BC Ltd. 6322-Cooks Kamloops, BC V2C 2A3 2022 British Columbia Low Wage   91654 0
114432 114432 0345892 BC Ltd. 0631-Restaurant and food service managers Kamloops, BC V2C 2A3 2022 British Columbia Low Wage   114432 0
123204 123204 0345892 BC Ltd. 6322-Cooks Kamloops, BC V2C 2A3 2021 British Columbia Low Wage   123204 0
78034 78034 0345892 BC Ltd. o/a Carlos O'Bryan Pub 6322-Cooks Kamloops, BC V2C 2A3 2018 British Columbia Low Wage   78034 0
23250 23250 0348706 bc ltd 1123-Professional occupations in advertising, marketing and public relations surrey, BC V3T 4X8 2020 British Columbia High Wage   23250 0
3684 3684 0371204 B.C. Ltd. 6311-Food service supervisors Richmond, BC V6Y 4M6 2018 British Columbia Low Wage   3684 0
31718 31718 0371204 B.C. Ltd. 6711-Food counter attendants, kitchen helpers and related support occupations Richmond, BC V6Y 4M6 2019 British Columbia Low Wage   31718 0
78035 78035 0371204 B.C. Ltd. 6311-Food service supervisors Richmond, BC V6Y 4M6 2018 British Columbia Low Wage   78035 0
197693 197693 0371204 B.C. Ltd. 6311-Food service supervisors Richmond, BC V6Y 4M6 2017 British Columbia Low Wage   197693 0
16865 16865 0371204 BC Ltd. 6311-Food service supervisors DELTA, BC V4K 1W4 2019 British Columbia Low Wage   16865 0
89826 89826 0371204 BC Ltd. 0631-Restaurant and food service managers DELTA, BC V4K 1W4 2022 British Columbia High Wage   89826 0
91655 91655 0371204 BC Ltd. 6711-Food counter attendants, kitchen helpers and related support occupations DELTA, BC V4K 1W4 2022 British Columbia Low Wage   91655 0
60301 60301 0395603 B.C. LTD. 7452-Material handlers SURREY, BC V3W 8V3 2022 British Columbia Low Wage   60301 0
23251 23251 0402 Holding Ltd. 0632-Accommodation service managers KAMLOOPS, BC V1S 1P4 2020 British Columbia High Wage   23251 0
48819 48819 041216 NB LTD 6731-Light duty cleaners Moncton, NB E1C 0M4 2022 New Brunswick Low Wage   48819 0
113459 113459 0459478 BC LTD 6315-Cleaning supervisors Burnaby, BC V5J 4M3 2022 British Columbia High Wage   113459 0
31719 31719 0459478 BC LTD o/a Paul Davis Greater Vancouver 6315-Cleaning supervisors North Vancouver, BC V7J 1E9 2019 British Columbia Low Wage   31719 0
3165 3165 0499692 BC Ltd 0124-Advertising, marketing and public relations managers PRINCE GEORGE, BC V2N 2S9 2018 British Columbia High Wage   3165 0
174803 174803 0499692 BC Ltd 1311-Accounting technicians and bookkeepers Prince George, BC V2L 2K5 2016 British Columbia     174803 0
174804 174804 0499692 BC Ltd 6311-Food service supervisors Prince George, BC V2L 2K5 2016 British Columbia     174804 0
197694 197694 0499692 BC Ltd 6311-Food service supervisors Prince George, BC V2N 2S9 2017 British Columbia Low Wage   197694 0
13342 13342 05 Systems Inc. 2174-Computer programmers and interactive media developers Toronto, ON M5T 1Z7 2019 Ontario Global Talent Stream   13342 0
73574 73574 053636 NB Ltd. 7511-Transport truck drivers Dieppe, NB E1A 1Y6 2018 New Brunswick High Wage   73574 0
164295 164295 053636 NB Ltd. 7511-Transport truck drivers Dieppe, NB E1A 1Y6 2016 New Brunswick     164295 0
189319 189319 053636 NB Ltd. 7511-Transport truck drivers Dieppe, NB E1A 1Y6 2017 New Brunswick High Wage   189319 0
116164 116164 056178 N.B. Inc 6322-Cooks Moncton, NB E1G 1A5 2021 New Brunswick Low Wage   116164 0
46993 46993 0565450 B.C. Ltd. 6311-Food service supervisors Langley, BC V1M 3A6 2020 British Columbia Low Wage   46993 0
105 105 057033 N.B. INC o/a Manoir Pascal Poirier 6731-Light duty cleaners SHEDIAC, NB E4P 2K9 2018 New Brunswick Low Wage   105 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE [all_fts] USING FTS4 (
    [employer], [occupations], [address], [phase], [province_territory], [stream],
    content=[all]
);