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 address

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid employer occupations address ▼ phase province_territory stream all_fts docid __langid
105781 105781 7912200 Canada Inc 0015-Senior managers - trade, broadcasting and other services, n.e.c. ,Brampton, ON L6T 5P3 2022 Ontario High Wage   105781 0
186099 186099 2659611 Ontario INC. 6311-Food service supervisors ,Ridgeway, ON L0S 1N0 2021 Ontario Low Wage   186099 0
112896 112896 Pilot Flying J 6211-Retail sales supervisors . Calgary, AB T2Z 4M8 2022 Alberta Low Wage   112896 0
141790 141790 TE Boyle Farm & Forestry Ltd 8431-General farm workers ., NS B0H 1A0 2019 Nova Scotia Primary Agriculture   141790 0
159625 159625 TE Boyle Farm & Forestry Ltd 8431-General farm workers ., NS B0H 1A0 2018 Nova Scotia Primary Agriculture   159625 0
189311 189311 TE Boyle Farm & Forestry Ltd 8431-General farm workers ., NS B0H 1A0 2017 Nova Scotia Primary Agriculture   189311 0
46005 46005 0800126 BC Ltd 0632-Accommodation service managers 100 Mile House, BC V0K 2E1 2020 British Columbia High Wage   46005 0
15980 15980 Divine Touch Restaurant Inc. dba Subway 0631-Restaurant and food service managers 100 MILE HOUSE, BC V0K 2E0 2019 British Columbia High Wage   15980 0
16237 16237 Jacobsen Enterprises Ltd 0631-Restaurant and food service managers 100 MILE HOUSE, BC V0K 2E0 2019 British Columbia High Wage   16237 0
17034 17034 1155320 BC Ltd 0631-Restaurant and food service managers 100 MILE HOUSE, BC V0K 2E0 2019 British Columbia Low Wage   17034 0
17354 17354 Divine Touch Restaurant Inc. dba Subway 6311-Food service supervisors 100 MILE HOUSE, BC V0K 2E0 2019 British Columbia Low Wage   17354 0
17575 17575 Jacobsen Enterprises Ltd 6315-Cleaning supervisors 100 MILE HOUSE, BC V0K 2E0 2019 British Columbia Low Wage   17575 0
77384 77384 0729886 BC Ltd. o/a Husky 0621-Retail and wholesale trade managers 100 MILE HOUSE, BC V0K 2E0 2018 British Columbia High Wage   77384 0
78042 78042 0729886 BC Ltd. o/a Husky 0631-Restaurant and food service managers 100 MILE HOUSE, BC V0K 2E0 2018 British Columbia Low Wage   78042 0
97933 97933 0729886 BC Ltd. o/a Husky 6322-Cooks 100 MILE HOUSE, BC V0K 2E0 2018 British Columbia Low Wage   97933 0
139173 139173 1194773 BC Ltd 0015-Senior managers - trade, broadcasting and other services, n.e.c. 100 Mile House, BC V0K 2E 2021 British Columbia High Wage   139173 0
23297 23297 1091072 BC Ltd 0632-Accommodation service managers 100 Mile House, BC V0K 2E0 2020 British Columbia High Wage   23297 0
23310 23310 1155320 BC Ltd 0631-Restaurant and food service managers 100 Mile House, BC V0K 2E0 2020 British Columbia High Wage   23310 0
25014 25014 Divine Touch Restaurant Inc. dba Subway 6311-Food service supervisors 100 Mile House, BC V0K 2E0 2020 British Columbia Low Wage   25014 0
25219 25219 Jacobsen Enterprises Ltd 6322-Cooks 100 Mile House, BC V0K 2E0 2020 British Columbia Low Wage   25219 0
38145 38145 1014024 BC Ltd. 6211-Retail sales supervisors 100 Mile House, BC V0K 2E0 2021 British Columbia High Wage   38145 0
58862 58862 1155320 BC Ltd 6321-Chefs 100 Mile House, BC V0K 2E0 2022 British Columbia High Wage   58862 0
59544 59544 Imperial Motel (2005) Ltd. 6315-Cleaning supervisors 100 Mile House, BC V0K 2E0 2022 British Columbia High Wage   59544 0
114542 114542 1155320 BC Ltd 6311-Food service supervisors 100 Mile House, BC V0K 2E0 2022 British Columbia Low Wage   114542 0
122640 122640 Jacobsen Enterprises Ltd 0632-Accommodation service managers 100 Mile House, BC V0K 2E0 2021 British Columbia High Wage   122640 0
123070 123070 SUSHI & NOODLE 0631-Restaurant and food service managers 100 Mile House, BC V0K 2E0 2021 British Columbia High Wage   123070 0
140304 140304 1091072 BC Ltd 6525-Hotel front desk clerks 100 Mile House, BC V0K 2E0 2021 British Columbia Low Wage   140304 0
147228 147228 Jacobsen Enterprises Ltd o/a Lakewood Inn 0632-Accommodation service managers 100 Mile House, BC V0K 2E0 2019 British Columbia High Wage   147228 0
147733 147733 0729886 BC Ltd. o/a Husky 6211-Retail sales supervisors 100 Mile House, BC V0K 2E0 2019 British Columbia Low Wage   147733 0
147997 147997 Divine Touch Restaurant Inc. dba Subway 6311-Food service supervisors 100 Mile House, BC V0K 2E0 2019 British Columbia Low Wage   147997 0
148095 148095 Jacobsen Enterprises Ltd o/a Lakewood Inn 6315-Cleaning supervisors 100 Mile House, BC V0K 2E0 2019 British Columbia Low Wage   148095 0
148096 148096 Jacobsen Enterprises Ltd o/a Lakewood Inn 6322-Cooks 100 Mile House, BC V0K 2E0 2019 British Columbia Low Wage   148096 0
156626 156626 Imperial Motel (2005) Ltd. 0632-Accommodation service managers 100 Mile House, BC V0K 2E0 2022 British Columbia High Wage   156626 0
157421 157421 1091072 BC Ltd 6312-Executive housekeepers 100 Mile House, BC V0K 2E0 2022 British Columbia Low Wage   157421 0
174999 174999 100 Mile Realty Ltd. 1241-Administrative assistants 100 Mile House, BC V0K 2E0 2016 British Columbia     174999 0
175873 175873 Coral Reefer Holdings dba A&W 6311-Food service supervisors 100 Mile House, BC V0K 2E0 2016 British Columbia     175873 0
197067 197067 Kellermeier Contracting Ltd. 7294-Painters and decorators (except interior decorators) 100 Mile House, BC V0K 2E0 2017 British Columbia High Wage   197067 0
197814 197814 1058228 B.C Ltd. 100 Mile Chevron 6211-Retail sales supervisors 100 Mile House, BC V0K 2E0 2017 British Columbia Low Wage   197814 0
114629 114629 1351472 BC Ltd. 7611-Construction trades helpers and labourers 100 Mile House, BC V0K 2E1 2022 British Columbia Low Wage   114629 0
23299 23299 1093532 BC LTD 1224-Property administrators 100 Mile House, BC V0K 2Z0 2020 British Columbia High Wage   23299 0
131021 131021 1091072 BC Ltd 1241-Administrative assistants 100 Mile House, V0K2E0 2020 British Columbia High Wage   131021 0
131870 131870 SUSHI & NOODLE 0631-Restaurant and food service managers 100 Mile House, V0K2E0 2020 British Columbia High Wage   131870 0
92360 92360 Coral Reefer Holdings Inc. 6711-Food counter attendants, kitchen helpers and related support occupations 100 Miles House, BC V0K 2E0 2022 British Columbia Low Wage   92360 0
123526 123526 Coral Reefer Holdings Inc. 6311-Food service supervisors 100 Miles House, BC V0K 2E0 2021 British Columbia Low Wage   123526 0
157782 157782 Coral Reefer Holdings Inc. 6311-Food service supervisors 100 Miles House, BC V0K 2E0 2022 British Columbia Low Wage   157782 0
157783 157783 Coral Reefer Holdings Inc. 6711-Food counter attendants, kitchen helpers and related support occupations 100 Miles House, BC V0K 2E0 2022 British Columbia Low Wage   157783 0
141544 141544 EyeOn Imports Incorporated dba EyeOn Analytics 2172-Database analysts and data administrators 108 Mile Ranch, BC V0K 2Z 2021 British Columbia Global Talent Stream   141544 0
156034 156034 108 Mile Supermarket Ltd. 6211-Retail sales supervisors 108 Mile Ranch, BC V0K 2Z0 2022 British Columbia High Wage   156034 0
4481 4481 Amazing Discoveries Ministries Inc. 2175-Web designers and developers 150 MILE HOUSE, BC V0K 2G0 2018 British Columbia Global Talent Stream   4481 0
16859 16859 Zirnhelt Timber Frames Ltd 7271-Carpenters 150 Mile House, BC V0K 2G0 2019 British Columbia High Wage   16859 0
177444 177444 OT Timber Frames Ltd 7271-Carpenters 150 Mile House, BC V0K 2G0 2016 British Columbia     177444 0
197686 197686 Zirnhelt Timber Frames Ltd. 7271-Carpenters 150 Mile House, BC V0K 2G0 2017 British Columbia High Wage   197686 0
179380 179380 Minimax Brandbeveiliging B.V. 2232-Mechanical engineering technologists and technicians 3088 ED Rotterdam, 2016 Employers carrying on business in Canada with Head Office outside of Canada     179380 0
179381 179381 Minimax Brandbeveiliging B.V. 2233-Industrial engineering and manufacturing technologists and technicians 3088 ED Rotterdam, 2016 Employers carrying on business in Canada with Head Office outside of Canada     179381 0
113817 113817 Fromar Enterprises Ltd 0621-Retail and wholesale trade managers 70 MILE HOUSE, BC V0K 2K0 2022 British Columbia High Wage   113817 0
114945 114945 Fromar Enterprises Ltd 6211-Retail sales supervisors 70 MILE HOUSE, BC V0K 2K0 2022 British Columbia Low Wage   114945 0
2902 2902 Five Star Construction Ltd. 7291-Roofers and shinglers AB BEACH, AB T0E 0A1 2018 Alberta Low Wage   2902 0
97204 97204 Five Star Construction Ltd. 7291-Roofers and shinglers AB BEACH, AB T0E 0A1 2018 Alberta Low Wage   97204 0
29481 29481 Tarrickfic Aerial Ltd. 2271-Air pilots, flight engineers and flying instructors ABBEY, SK S0N 0A0 2019 Saskatchewan High Wage   29481 0
18452 18452 PBN Nurseries Ltd. 8252-Agricultural service contractors, farm supervisors and specialized livestock workers ABBOSTFORD, BC V4X 3R2 2019 British Columbia Primary Agriculture   18452 0
78912 78912 PBN Nurseries Ltd. 8432-Nursery and greenhouse workers ABBOSTFORD, BC V4X 3R2 2018 British Columbia Primary Agriculture   78912 0
77451 77451 Abbey Choice Construction Ltd 7271-Carpenters ABBOSTSFORD, BC V2T 6V5 2018 British Columbia High Wage   77451 0
72411 72411 Good Star Building Maintenance Ltd. 6315-Cleaning supervisors ABBOTSFORD, BC V2S 5N 2019 British Columbia Low Wage   72411 0
72412 72412 Good Star Building Maintenance Ltd. 6731-Light duty cleaners ABBOTSFORD, BC V2S 5N 2019 British Columbia Low Wage   72412 0
32783 32783 Eklund Farms Ltd. 8431-General farm workers ABBOTSFORD, BC V2S 0A1 2019 British Columbia Primary Agriculture   32783 0
98553 98553 Eklund Farms Ltd. 8431-General farm workers ABBOTSFORD, BC V2S 0A1 2018 British Columbia Primary Agriculture   98553 0
31694 31694 Westernstar Transport Ltd 7511-Transport truck drivers ABBOTSFORD, BC V2S 0E4 2019 British Columbia High Wage   31694 0
72711 72711 Ra Sushi Ltd 6322-Cooks ABBOTSFORD, BC V2S 0H9 2019 British Columbia Low Wage   72711 0
148194 148194 N.H. Operation Ltd 6311-Food service supervisors ABBOTSFORD, BC V2S 0H9 2019 British Columbia Low Wage   148194 0
60389 60389 0985459 B.C LTD 6211-Retail sales supervisors ABBOTSFORD, BC V2S 0L5 2022 British Columbia Low Wage   60389 0
89930 89930 1282099 B.C. LTD 7271-Carpenters ABBOTSFORD, BC V2S 1A2 2022 British Columbia High Wage   89930 0
89931 89931 1282099 B.C. LTD 7284-Plasterers, drywall installers and finishers and lathers ABBOTSFORD, BC V2S 1A2 2022 British Columbia High Wage   89931 0
72132 72132 3D IMAGE CONSTRUCTION LTD. 7611-Construction trades helpers and labourers ABBOTSFORD, BC V2S 1B8 2019 British Columbia Low Wage   72132 0
4487 4487 Aporime Technologies Inc 2173-Software engineers and designers ABBOTSFORD, BC V2S 1G7 2018 British Columbia Global Talent Stream   4487 0
47850 47850 RDL RECYCLING INC. 1241-Administrative assistants ABBOTSFORD, BC V2S 1L5 2020 British Columbia Low Wage   47850 0
71689 71689 RDL Recycling Inc. 1225-Purchasing agents and officers ABBOTSFORD, BC V2S 1L5 2019 British Columbia High Wage   71689 0
78256 78256 Directbuy Flooring (2013) Ltd. 1311-Accounting technicians and bookkeepers ABBOTSFORD, BC V2S 1L9 2018 British Columbia Low Wage   78256 0
97588 97588 Directbuy Flooring (2013) Ltd. 7302-Contractors and supervisors, heavy equipment operator crews ABBOTSFORD, BC V2S 1L9 2018 British Columbia High Wage   97588 0
147996 147996 Directbuy Flooring (2013) Ltd. 1241-Administrative assistants ABBOTSFORD, BC V2S 1L9 2019 British Columbia Low Wage   147996 0
15972 15972 Delta Plumbing & Heating Ltd 7313-Refrigeration and air conditioning mechanics ABBOTSFORD, BC V2S 1S5 2019 British Columbia High Wage   15972 0
31074 31074 Delta Plumbing & Heating Ltd 7251-Plumbers ABBOTSFORD, BC V2S 1S5 2019 British Columbia High Wage   31074 0
97583 97583 Delta Plumbing & Heating Ltd 7251-Plumbers ABBOTSFORD, BC V2S 1S5 2018 British Columbia High Wage   97583 0
31704 31704 Xtractor Logistics Ltd. 7312-Heavy-duty equipment mechanics ABBOTSFORD, BC V2S 2B1 2019 British Columbia High Wage   31704 0
31705 31705 Xtractor Logistics Ltd. 7511-Transport truck drivers ABBOTSFORD, BC V2S 2B1 2019 British Columbia High Wage   31705 0
17047 17047 1167771 BC Ltd 6322-Cooks ABBOTSFORD, BC V2S 2B5 2019 British Columbia Low Wage   17047 0
46125 46125 AMERI-CAN LOGISTICS LTD. 7511-Transport truck drivers ABBOTSFORD, BC V2S 2B5 2020 British Columbia High Wage   46125 0
70932 70932 Ameri-Can Logistics Ltd. 7511-Transport truck drivers ABBOTSFORD, BC V2S 2B5 2019 British Columbia High Wage   70932 0
72123 72123 1167771 BC Ltd 6322-Cooks ABBOTSFORD, BC V2S 2B5 2019 British Columbia Low Wage   72123 0
146778 146778 1119390 BC Ltd o/a Kojan Sushi Restaurant 0631-Restaurant and food service managers ABBOTSFORD, BC V2S 2B9 2019 British Columbia High Wage   146778 0
59140 59140 BFC RESTAURANT AND CATERING LTD 0631-Restaurant and food service managers ABBOTSFORD, BC V2S 2C3 2022 British Columbia High Wage   59140 0
31658 31658 Valley Eurotec Sales and Service Ltd 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers ABBOTSFORD, BC V2S 2C6 2019 British Columbia High Wage   31658 0
65751 65751 YOUNG SUSHI LTD. 6322-Cooks ABBOTSFORD, BC V2S 2C7 2020 British Columbia Low Wage   65751 0
92313 92313 Charm Nail & Spa (2018) Corporation 6562-Estheticians, electrologists and related occupations ABBOTSFORD, BC V2S 2C7 2022 British Columbia Low Wage   92313 0
93765 93765 YOUNG SUSHI LTD. 6322-Cooks ABBOTSFORD, BC V2S 2C7 2022 British Columbia Low Wage   93765 0
141262 141262 YOUNG SUSHI LTD. 6322-Cooks ABBOTSFORD, BC V2S 2C7 2021 British Columbia Low Wage   141262 0
158814 158814 YOUNG SUSHI LTD. 6322-Cooks ABBOTSFORD, BC V2S 2C7 2022 British Columbia Low Wage   158814 0
158039 158039 IDH Investments Ltd. 6311-Food service supervisors ABBOTSFORD, BC V2S 2E3 2022 British Columbia Low Wage   158039 0
4066 4066 Little Wonders Montessori Childcare and Preschool Ltd. 4214-Early childhood educators and assistants ABBOTSFORD, BC V2S 2P5 2018 British Columbia Low Wage   4066 0
71190 71190 Entsons Construction Inc. 7271-Carpenters ABBOTSFORD, BC V2S 2R1 2019 British Columbia High Wage   71190 0
16229 16229 J Dhhot Transportation Ltd. 7511-Transport truck drivers ABBOTSFORD, BC V2S 3B6 2019 British Columbia High Wage   16229 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]
);