All data of LMIAS Positive
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
This data as json, CSV (advanced)
| Link | rowid | province_territory | employer | address ▼ | occupations | positions_approved | phase | zipcode | city | stream |
|---|---|---|---|---|---|---|---|---|---|---|
| 31277 | 31277 | British Columbia | JTB Services Ltd. o/a Dents Unlimited | ABBOTSFORD, BC V2S 3J8 | 7322-Motor vehicle body repairers | 1 | 2019 | V2S3J8 | abbotsford | High Wage |
| 32429 | 32429 | British Columbia | PNY Enterprises Inc. o/a Shell Canada | ABBOTSFORD, BC V2S 3N4 | 6211-Retail sales supervisors | 1 | 2019 | V2S3N4 | abbotsford | Low Wage |
| 72688 | 72688 | British Columbia | PNY Enterprises Inc. o/a Shell Canada | ABBOTSFORD, BC V2S 3N4 | 6211-Retail sales supervisors | 1 | 2019 | V2S3N4 | abbotsford | Low Wage |
| 78490 | 78490 | British Columbia | PNY Enterprises Inc. o/a Shell Canada | ABBOTSFORD, BC V2S 3N4 | 6211-Retail sales supervisors | 5 | 2018 | V2S3N4 | abbotsford | Low Wage |
| 148251 | 148251 | British Columbia | PNY Enterprises Inc. o/a Shell Canada | ABBOTSFORD, BC V2S 3N4 | 6211-Retail sales supervisors | 3 | 2019 | V2S3N4 | abbotsford | Low Wage |
| 15984 | 15984 | British Columbia | Dolphin Radiators o/a Dolphin Automotive | ABBOTSFORD, BC V2S 3Y2 | 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers | 1 | 2019 | V2S3Y2 | abbotsford | High Wage |
| 32287 | 32287 | British Columbia | Little Wonders Montessori Childcare and Preschool Ltd. | ABBOTSFORD, BC V2S 3Y2 | 4214-Early childhood educators and assistants | 1 | 2019 | V2S3Y2 | abbotsford | Low Wage |
| 17027 | 17027 | British Columbia | 1124896 B.C. Ltd | ABBOTSFORD, BC V2S 4L5 | 6315-Cleaning supervisors | 1 | 2019 | V2S4L5 | abbotsford | Low Wage |
| 17897 | 17897 | British Columbia | PPMC GILL LTD. | ABBOTSFORD, BC V2S 4L5 | 6322-Cooks | 2 | 2019 | V2S4L5 | abbotsford | Low Wage |
| 72691 | 72691 | British Columbia | PPMC GILL LTD. | ABBOTSFORD, BC V2S 4L5 | 6322-Cooks | 1 | 2019 | V2S4L5 | abbotsford | Low Wage |
| 32754 | 32754 | British Columbia | Clear Blue Farms Inc | ABBOTSFORD, BC V2S 5Y4 | 8431-General farm workers | 4 | 2019 | V2S5Y4 | abbotsford | Primary Agriculture |
| 77854 | 77854 | British Columbia | Panther Express Ltd. | ABBOTSFORD, BC V2S 6H1 | 7511-Transport truck drivers | 4 | 2018 | V2S6H1 | abbotsford | High Wage |
| 78742 | 78742 | British Columbia | Chohan Farms Ltd. | ABBOTSFORD, BC V2S 6H1 | 8431-General farm workers | 18 | 2018 | V2S6H1 | abbotsford | Primary Agriculture |
| 98472 | 98472 | British Columbia | ACS Benipal Ltd. | ABBOTSFORD, BC V2S 6N5 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 2 | 2018 | V2S6N5 | abbotsford | Primary Agriculture |
| 98473 | 98473 | British Columbia | ACS Benipal Ltd. | ABBOTSFORD, BC V2S 6N5 | 8431-General farm workers | 15 | 2018 | V2S6N5 | abbotsford | Primary Agriculture |
| 31239 | 31239 | British Columbia | I Love Martial Arts Inc | ABBOTSFORD, BC V2S 6S2 | 5254-Program leaders and instructors in recreation, sport and fitness | 1 | 2019 | V2S6S2 | abbotsford | High Wage |
| 71969 | 71969 | British Columbia | West Abby Transport Ltd. | ABBOTSFORD, BC V2S 7A2 | 7511-Transport truck drivers | 2 | 2019 | V2S7A2 | abbotsford | High Wage |
| 147719 | 147719 | British Columbia | XPS Trucking Inc. | ABBOTSFORD, BC V2S 7A3 | 7511-Transport truck drivers | 3 | 2019 | V2S7A3 | abbotsford | High Wage |
| 17657 | 17657 | British Columbia | KSN Construction Ltd | ABBOTSFORD, BC V2S 7A4 | 7611-Construction trades helpers and labourers | 3 | 2019 | V2S7A4 | abbotsford | Low Wage |
| 147285 | 147285 | British Columbia | KSN Construction Ltd | ABBOTSFORD, BC V2S 7A4 | 7611-Construction trades helpers and labourers | 1 | 2019 | V2S7A4 | abbotsford | High Wage |
| 60710 | 60710 | British Columbia | ARS ENTERPRISES INC. | ABBOTSFORD, BC V2S 7M5 | 6211-Retail sales supervisors | 1 | 2022 | V2S7M5 | abbotsford | Low Wage |
| 60711 | 60711 | British Columbia | ARS ENTERPRISES INC. | ABBOTSFORD, BC V2S 7M5 | 6611-Cashiers | 1 | 2022 | V2S7M5 | abbotsford | Low Wage |
| 122898 | 122898 | British Columbia | QUADRA WOOD PRODUCTS LTD | ABBOTSFORD, BC V2S 7M6 | 1121-Human resources professionals | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 122899 | 122899 | British Columbia | QUADRA WOOD PRODUCTS LTD | ABBOTSFORD, BC V2S 7M6 | 1123-Professional occupations in advertising, marketing and public relations | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 122900 | 122900 | British Columbia | QUADRA WOOD PRODUCTS LTD | ABBOTSFORD, BC V2S 7M6 | 7242-Industrial electricians | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 187853 | 187853 | British Columbia | MIRAX LUMBER PRODUCTS LTD. | ABBOTSFORD, BC V2S 7M6 | 7312-Heavy-duty equipment mechanics | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 187935 | 187935 | British Columbia | QUADRA WOOD PRODUCTS LTD | ABBOTSFORD, BC V2S 7M6 | 7333-Electrical mechanics | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 187936 | 187936 | British Columbia | QUADRA WOOD PRODUCTS LTD | ABBOTSFORD, BC V2S 7M6 | 9215-Supervisors, forest products processing | 1 | 2021 | V2S7M6 | abbotsford | High Wage |
| 17223 | 17223 | British Columbia | Braber Equipment Ltd. | ABBOTSFORD, BC V2S 7P1 | 1521-Shippers and receivers | 3 | 2019 | V2S7P1 | abbotsford | Low Wage |
| 31580 | 31580 | British Columbia | SRT Diesel Truck & Trailer Repair Ltd | ABBOTSFORD, BC V2S 7P2 | 1241-Administrative assistants | 1 | 2019 | V2S7P2 | abbotsford | High Wage |
| 46839 | 46839 | British Columbia | SRT DIESEL TRUCK & TRAILER REPAIR LTD. | ABBOTSFORD, BC V2S 7P2 | 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers | 2 | 2020 | V2S7P2 | abbotsford | High Wage |
| 60097 | 60097 | British Columbia | SRT DIESEL TRUCK & TRAILER REPAIR LTD. | ABBOTSFORD, BC V2S 7P2 | 1221-Administrative officers | 1 | 2022 | V2S7P2 | abbotsford | High Wage |
| 77943 | 77943 | British Columbia | SRT Diesel Truck & Trailer Repair Ltd | ABBOTSFORD, BC V2S 7P2 | 7312-Heavy-duty equipment mechanics | 2 | 2018 | V2S7P2 | abbotsford | High Wage |
| 114291 | 114291 | British Columbia | SRT DIESEL TRUCK & TRAILER REPAIR LTD. | ABBOTSFORD, BC V2S 7P2 | 7321-Automotive service technicians, truck and bus mechanics and mechanical repairers | 3 | 2022 | V2S7P2 | abbotsford | High Wage |
| 157106 | 157106 | British Columbia | SRT DIESEL TRUCK & TRAILER REPAIR LTD. | ABBOTSFORD, BC V2S 7P2 | 1241-Administrative assistants | 1 | 2022 | V2S7P2 | abbotsford | High Wage |
| 70936 | 70936 | British Columbia | Anand Enterprises Ltd | ABBOTSFORD, BC V2S 7P7 | 7511-Transport truck drivers | 4 | 2019 | V2S7P7 | abbotsford | High Wage |
| 73082 | 73082 | British Columbia | Moundhi Farm Ltd | ABBOTSFORD, BC V2S 7T6 | 8431-General farm workers | 6 | 2019 | V2S7T6 | abbotsford | Primary Agriculture |
| 124477 | 124477 | British Columbia | Moundhi Farm Ltd | ABBOTSFORD, BC V2S 7T6 | 8431-General farm workers | 4 | 2021 | V2S7T6 | abbotsford | Primary Agriculture |
| 48186 | 48186 | British Columbia | Butter Farms Ltd. | ABBOTSFORD, BC V2S 7T7 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2020 | V2S7T7 | abbotsford | Primary Agriculture |
| 31447 | 31447 | British Columbia | Pattern Logistics Inc | ABBOTSFORD, BC V2S 7T9 | 1241-Administrative assistants | 1 | 2019 | V2S7T9 | abbotsford | High Wage |
| 31448 | 31448 | British Columbia | Pattern Logistics Inc | ABBOTSFORD, BC V2S 7T9 | 1311-Accounting technicians and bookkeepers | 1 | 2019 | V2S7T9 | abbotsford | High Wage |
| 31449 | 31449 | British Columbia | Pattern Logistics Inc | ABBOTSFORD, BC V2S 7T9 | 7511-Transport truck drivers | 5 | 2019 | V2S7T9 | abbotsford | High Wage |
| 15782 | 15782 | British Columbia | BD Engine Brake INC | ABBOTSFORD, BC V2S 7W2 | 1225-Purchasing agents and officers | 1 | 2019 | V2S7W2 | abbotsford | High Wage |
| 15983 | 15983 | British Columbia | Doerksen Roofing Ltd | ABBOTSFORD, BC V2S 7W2 | 7291-Roofers and shinglers | 3 | 2019 | V2S7W2 | abbotsford | High Wage |
| 48087 | 48087 | British Columbia | Westberry Farms Ltd | ABBOTSFORD, BC V2S 7Y8 | 9617-Labourers in food, beverage and associated products processing | 1 | 2020 | V2S7Y8 | abbotsford | Low Wage |
| 65868 | 65868 | British Columbia | HS & A Harvest Farms Ltd. | ABBOTSFORD, BC V2S 7Y8 | 8431-General farm workers | 6 | 2020 | V2S7Y8 | abbotsford | Primary Agriculture |
| 32713 | 32713 | British Columbia | 0798750 BC Ltd | ABBOTSFORD, BC V2S 7Z8 | 8432-Nursery and greenhouse workers | 2 | 2019 | V2S7Z8 | abbotsford | Primary Agriculture |
| 158827 | 158827 | British Columbia | 0798750 BC Ltd | ABBOTSFORD, BC V2S 7Z8 | 8432-Nursery and greenhouse workers | 3 | 2022 | V2S7Z8 | abbotsford | Primary Agriculture |
| 32752 | 32752 | British Columbia | Cheema Growers Ltd. | ABBOTSFORD, BC V2S 8A1 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2019 | V2S8A1 | abbotsford | Primary Agriculture |
| 32753 | 32753 | British Columbia | Cheema Growers Ltd. | ABBOTSFORD, BC V2S 8A1 | 8431-General farm workers | 4 | 2019 | V2S8A1 | abbotsford | Primary Agriculture |
| 62272 | 62272 | British Columbia | HIGH QUALITY DAILY FRESH PRODUCE LTD | ABBOTSFORD, BC V2S 8A1 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2022 | V2S8A1 | abbotsford | Primary Agriculture |
| 98521 | 98521 | British Columbia | Cheema Growers Ltd. | ABBOTSFORD, BC V2S 8A1 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2018 | V2S8A1 | abbotsford | Primary Agriculture |
| 98522 | 98522 | British Columbia | Cheema Growers Ltd. | ABBOTSFORD, BC V2S 8A1 | 8431-General farm workers | 5 | 2018 | V2S8A1 | abbotsford | Primary Agriculture |
| 17401 | 17401 | British Columbia | Emeralds Restaurants Inc. o/a Browns Socialhouse McCallum | ABBOTSFORD, BC V2S 8A2 | 6322-Cooks | 2 | 2019 | V2S8A2 | abbotsford | Low Wage |
| 32482 | 32482 | British Columbia | S&H Sushi Box Food Ltd | ABBOTSFORD, BC V2S 8A3 | 6322-Cooks | 1 | 2019 | V2S8A3 | abbotsford | Low Wage |
| 48431 | 48431 | British Columbia | SUNRISE HOLDINGS LTD. | ABBOTSFORD, BC V2S 8A3 | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 3 | 2020 | V2S8A3 | abbotsford | Primary Agriculture |
| 48432 | 48432 | British Columbia | SUNRISE HOLDINGS LTD. | ABBOTSFORD, BC V2S 8A3 | 8431-General farm workers | 15 | 2020 | V2S8A3 | abbotsford | Primary Agriculture |
| 122804 | 122804 | British Columbia | Norcoast Developments Ltd. | ABBOTSFORD, BC V2S 8A3 | 1221-Administrative officers | 1 | 2021 | V2S8A3 | abbotsford | High Wage |
| 159204 | 159204 | British Columbia | SUNRISE HOLDINGS LTD. | ABBOTSFORD, BC V2S 8A3 | 8431-General farm workers | 15 | 2022 | V2S8A3 | abbotsford | Primary Agriculture |
| 65869 | 65869 | British Columbia | HSS Farms | ABBOTSFORD, BC V2S 8A8 | 8431-General farm workers | 2 | 2020 | V2S8A8 | abbotsford | Primary Agriculture |
| 159024 | 159024 | British Columbia | HSS Farms | ABBOTSFORD, BC V2S 8A8 | 8431-General farm workers | 6 | 2022 | V2S8A8 | abbotsford | Primary Agriculture |
| 18425 | 18425 | British Columbia | Marion Road Farms Ltd. | ABBOTSFORD, BC V2S 8B4 | 8431-General farm workers | 7 | 2019 | V2S8B4 | abbotsford | Primary Agriculture |
| 71160 | 71160 | British Columbia | Dreamscape Painting Ltd. | ABBOTSFORD, BC V2S 8C4 | 7294-Painters and decorators (except interior decorators) | 1 | 2019 | V2S8C4 | abbotsford | High Wage |
| 17506 | 17506 | British Columbia | Handlers Used Equipment Ltd | ABBOTSFORD, BC V2S 8E5 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2019 | V2S8E5 | abbotsford | Low Wage |
| 32362 | 32362 | British Columbia | New Generations Early Learning Center Ltd. | ABBOTSFORD, BC V2S 8K4 | 4214-Early childhood educators and assistants | 1 | 2019 | V2S8K4 | abbotsford | Low Wage |
| 32736 | 32736 | British Columbia | Bakerview Ecodairy Ltd. | ABBOTSFORD, BC V2S 8R1 | 8431-General farm workers | 1 | 2019 | V2S8R1 | abbotsford | Primary Agriculture |
| 78714 | 78714 | British Columbia | Bakerview Greenhouses Incorporated | ABBOTSFORD, BC V2S 8R1 | 8432-Nursery and greenhouse workers | 8 | 2018 | V2S8R1 | abbotsford | Primary Agriculture |
| 78977 | 78977 | British Columbia | Sumas Ridge Greenhouses Incorporated | ABBOTSFORD, BC V2S 8R1 | 8432-Nursery and greenhouse workers | 7 | 2018 | V2S8R1 | abbotsford | Primary Agriculture |
| 39665 | 39665 | British Columbia | BATH BLUEBERRY FARMS | ABBOTSFORD, BC V2T 4W | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2021 | 4W | abbotsford | Primary Agriculture |
| 39666 | 39666 | British Columbia | BATH BLUEBERRY FARMS | ABBOTSFORD, BC V2T 4W | 8431-General farm workers | 3 | 2021 | 4W | abbotsford | Primary Agriculture |
| 18504 | 18504 | British Columbia | SUMAS VALLEY BERRY FARM LTD. | ABBOTSFORD, BC V2T 5N | 8431-General farm workers | 12 | 2019 | 5N | abbotsford | Primary Agriculture |
| 124538 | 124538 | British Columbia | SUMAS VALLEY BERRY FARM LTD. | ABBOTSFORD, BC V2T 5N | 8431-General farm workers | 12 | 2021 | 5N | abbotsford | Primary Agriculture |
| 159198 | 159198 | British Columbia | SUMAS VALLEY BERRY FARM LTD. | ABBOTSFORD, BC V2T 5N | 8431-General farm workers | 12 | 2022 | 5N | abbotsford | Primary Agriculture |
| 65808 | 65808 | British Columbia | Cedar Grove Farms Ltd. | ABBOTSFORD, BC V2T 6G | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2020 | 6G | abbotsford | Primary Agriculture |
| 3284 | 3284 | British Columbia | Canadian Furniture Manufacturing Limited | ABBOTSFORD, BC V2T 6W | 7204-Contractors and supervisors, carpentry trades | 1 | 2018 | 6W | abbotsford | High Wage |
| 31017 | 31017 | British Columbia | Canadian Furniture Manufacturing Limited | ABBOTSFORD, BC V2T 6W | 7271-Carpenters | 4 | 2019 | 6W | abbotsford | High Wage |
| 4385 | 4385 | British Columbia | HIGH POWER NURSERY LTD | ABBOTSFORD, BC V2T 9H | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 2 | 2018 | 9H | abbotsford | Primary Agriculture |
| 25964 | 25964 | British Columbia | High Power Nursery Ltd | ABBOTSFORD, BC V2T 9H | 8431-General farm workers | 9 | 2020 | 9H | abbotsford | Primary Agriculture |
| 78826 | 78826 | British Columbia | HIGH POWER NURSERY LTD | ABBOTSFORD, BC V2T 9H | 8431-General farm workers | 12 | 2018 | 9H | abbotsford | Primary Agriculture |
| 159012 | 159012 | British Columbia | High Power Nursery Ltd | ABBOTSFORD, BC V2T 9H | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 2 | 2022 | 9H | abbotsford | Primary Agriculture |
| 159013 | 159013 | British Columbia | High Power Nursery Ltd | ABBOTSFORD, BC V2T 9H | 8431-General farm workers | 9 | 2022 | 9H | abbotsford | Primary Agriculture |
| 188827 | 188827 | British Columbia | High Power Nursery Ltd | ABBOTSFORD, BC V2T 9H | 8252-Agricultural service contractors, farm supervisors and specialized livestock workers | 1 | 2021 | 9H | abbotsford | Primary Agriculture |
| 188828 | 188828 | British Columbia | High Power Nursery Ltd | ABBOTSFORD, BC V2T 9H | 8431-General farm workers | 8 | 2021 | 9H | abbotsford | Primary Agriculture |
| 32801 | 32801 | British Columbia | Grewal Riverside Farms Ltd. | ABBOTSFORD, BC V2T 0A4 | 8431-General farm workers | 1 | 2019 | V2T0A4 | abbotsford | Primary Agriculture |
| 92296 | 92296 | British Columbia | Casper Flooring Ltd | ABBOTSFORD, BC V2T 0A4 | 7611-Construction trades helpers and labourers | 2022 | V2T0A4 | abbotsford | Low Wage | |
| 71382 | 71382 | British Columbia | Jas Kular & Associates Inc. | ABBOTSFORD, BC V2T 0B1 | 1221-Administrative officers | 1 | 2019 | V2T0B1 | abbotsford | High Wage |
| 71383 | 71383 | British Columbia | Jas Kular & Associates Inc. | ABBOTSFORD, BC V2T 0B1 | 1311-Accounting technicians and bookkeepers | 2 | 2019 | V2T0B1 | abbotsford | High Wage |
| 71631 | 71631 | British Columbia | Parmeshar Sweet Shop & Restaurant Ltd. | ABBOTSFORD, BC V2T 0B1 | 6322-Cooks | 2 | 2019 | V2T0B1 | abbotsford | High Wage |
| 148300 | 148300 | British Columbia | Saddher's Hair & Beauty Salon Ltd. | ABBOTSFORD, BC V2T 0B1 | 6341-Hairstylists and barbers | 1 | 2019 | V2T0B1 | abbotsford | Low Wage |
| 15728 | 15728 | British Columbia | Aro Food Factory Inc. | ABBOTSFORD, BC V2T 0B5 | 0621-Retail and wholesale trade managers | 1 | 2019 | V2T0B5 | abbotsford | High Wage |
| 17441 | 17441 | British Columbia | FRASER GATE SMOOTHIES ENTERPRISES INC | ABBOTSFORD, BC V2T 0B5 | 6311-Food service supervisors | 1 | 2019 | V2T0B5 | abbotsford | Low Wage |
| 71551 | 71551 | British Columbia | MVR Construction Ltd. | ABBOTSFORD, BC V2T 0G4 | 7271-Carpenters | 4 | 2019 | V2T0G4 | abbotsford | High Wage |
| 113541 | 113541 | British Columbia | Abbotsford Stucco & Siding Ltd. | ABBOTSFORD, BC V2T 0G4 | 7611-Construction trades helpers and labourers | 1 | 2022 | V2T0G4 | abbotsford | High Wage |
| 113600 | 113600 | British Columbia | AVYAN ANALYTICS INC. | ABBOTSFORD, BC V2T 0G4 | 0015-Senior managers - trade, broadcasting and other services, n.e.c. | 1 | 2022 | V2T0G4 | abbotsford | High Wage |
| 113601 | 113601 | British Columbia | AVYAN ANALYTICS INC. | ABBOTSFORD, BC V2T 0G4 | 1221-Administrative officers | 1 | 2022 | V2T0G4 | abbotsford | High Wage |
| 98569 | 98569 | British Columbia | Gagan Blueberry Growers Ltd. | ABBOTSFORD, BC V2T 0H2 | 8431-General farm workers | 40 | 2018 | V2T0H2 | abbotsford | Primary Agriculture |
| 71170 | 71170 | British Columbia | E3 Logistics Inc | ABBOTSFORD, BC V2T 0H6 | 7511-Transport truck drivers | 2 | 2019 | V2T0H6 | abbotsford | High Wage |
| 71912 | 71912 | British Columbia | Townline Roofing Ltd | ABBOTSFORD, BC V2T 1B8 | 7291-Roofers and shinglers | 2 | 2019 | V2T1B8 | abbotsford | High Wage |
| 70975 | 70975 | British Columbia | AYS Holdings Inc. | ABBOTSFORD, BC V2T 1C8 | 7511-Transport truck drivers | 10 | 2019 | V2T1C8 | abbotsford | High Wage |
| 38507 | 38507 | British Columbia | LOGIC CONSTRUCTION LTD | ABBOTSFORD, BC V2T 1E1 | 1221-Administrative officers | 1 | 2021 | V2T1E1 | abbotsford | High Wage |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "all" (province_territory TEXT, employer TEXT, address TEXT, occupations TEXT, positions_approved INTEGER, phase INTEGER, zipcode TEXT, city TEXT, stream TEXT);