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 occupations descending
This data as json, CSV (advanced)
| Link | rowid | province_territory | employer | address | occupations ▲ | positions_approved | phase | zipcode | city | stream |
|---|---|---|---|---|---|---|---|---|---|---|
| 66893 | 66893 | Quebec | Teknion Roy & Breton Inc. | Saint-Vallier, QC G0R 4J0 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2019 | G0R4J0 | saint-vallier | Low Wage |
| 68534 | 68534 | Ontario | Finnie Distributing (1997) Inc. | St Marys, ON N4X 1C5 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2019 | N4X1C5 | st marys | Low Wage |
| 69675 | 69675 | Alberta | Genics Inc. | Acheson, AB T7X 6B1 | 9619-Other labourers in processing, manufacturing and utilities | 11 | 2019 | T7X6B1 | acheson | High Wage |
| 70609 | 70609 | Alberta | SHP Firewood Sales Ltd | Caroline, AB T0M 0M0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2019 | T0M0M0 | caroline | Low Wage |
| 70680 | 70680 | Alberta | United Capital Group Ltd. | EVANSBURG, AB T0E 0T0 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2019 | T0E0T0 | evansburg | Low Wage |
| 72133 | 72133 | British Columbia | 464612 BC Ltd | LANGLEY, BC V3A 7A3 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2019 | V3A7A3 | langley | Low Wage |
| 72266 | 72266 | British Columbia | Can-Italia Kitchen Ltd | SURREY, BC V3S 2A1 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2019 | V3S2A1 | surrey | Low Wage |
| 72397 | 72397 | British Columbia | Gillwood Remanufacturing Inc. | Chilliwack, BC V2R 4P4 | 9619-Other labourers in processing, manufacturing and utilities | 5 | 2019 | V2R4P4 | chilliwack | Low Wage |
| 72405 | 72405 | British Columbia | Gold Oak Custom Furniture Ltd | SURREY, BC V3W 3B2 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2019 | V3W3B2 | surrey | Low Wage |
| 74010 | 74010 | Quebec | Khrome Product - Transport (KPT) INC. | SHERBROOKE, QC J1L 1N6 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2018 | J1L1N6 | sherbrooke | Low Wage |
| 75576 | 75576 | Ontario | W.D. Potato Limited | Beeton, ON L0G 1A0 | 9619-Other labourers in processing, manufacturing and utilities | 8 | 2018 | L0G1A0 | beeton | Low Wage |
| 79284 | 79284 | Prince Edward Island | Trout River Industries Inc. | Coleman, PE C0B 1H0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | C0B1H0 | coleman | Low Wage | |
| 79367 | 79367 | Nova Scotia | East Coast Wild Blueberry Limited | Great Village, NS B0M 1L0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | B0M1L0 | great village | Low Wage | |
| 79508 | 79508 | New Brunswick | DJ Marine Supplies Ltee | Pointe-Sapin, NB E9A 1T4 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | E9A1T4 | pointe-sapin | Low Wage | |
| 79561 | 79561 | New Brunswick | West-Wood Industries Ltd. | Scoudouc, NB E4P 3P8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | E4P3P8 | scoudouc | Low Wage | |
| 80227 | 80227 | Quebec | Gelpac Sacs Inc. | Marieville, QC J3M 1R8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J3M1R8 | marieville | High Wage | |
| 80925 | 80925 | Quebec | 2539-2903 Québec inc | Val-Alain, QC G0S 3H0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0S3H0 | val-alain | Low Wage | |
| 80982 | 80982 | Quebec | 9090-5092 Québec inc | Lavaltrie, QC J5T 2H1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J5T2H1 | lavaltrie | Low Wage | |
| 81198 | 81198 | Quebec | Agrimetal Inc | Wicham, QC J0C 1S0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J0C1S0 | wicham | Low Wage | |
| 81223 | 81223 | Quebec | ARTOPEX-PLUS INC. | Laval, QC H7L 3M9 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | H7L3M9 | laval | Low Wage | |
| 81254 | 81254 | Quebec | Boisclair et fils Inc | PIEDMONT, QC J0R 1K0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J0R1K0 | piedmont | Low Wage | |
| 81337 | 81337 | Quebec | Corporation international Masonite | Windsor, QC J1S 2T2 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J1S2T2 | windsor | Low Wage | |
| 81371 | 81371 | Quebec | Éloi Moisan inc | St-Gilbert, QC G0A 3T0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0A3T0 | st-gilbert | Low Wage | |
| 81377 | 81377 | Quebec | Emballage St-Jean Ltée | St-Jean-sur-Richelieu, QC J2W 2M4 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J2W2M4 | st-jean-sur-richelieu | Low Wage | |
| 81401 | 81401 | Quebec | Euroverre inc. | Terrebonne, QC J6W 0E2 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J6W0E2 | terrebonne | Low Wage | |
| 81416 | 81416 | Quebec | Fenplast Inc. | Cardiac, QC J5R 1J3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J5R1J3 | cardiac | Low Wage | |
| 81463 | 81463 | Quebec | Groupe Cabico Inc. | Coaticook, QC J1A 0B4 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J1A0B4 | coaticook | Low Wage | |
| 81471 | 81471 | Quebec | Groupe Isolofoam inc. | Ste-Marie, QC G6E 1N4 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G6E1N4 | ste-marie | Low Wage | |
| 81480 | 81480 | Quebec | Groupe sacs Frontenac inc | Trois-Rivières, QC G8T 5M3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G8T5M3 | trois-rivières | Low Wage | |
| 81500 | 81500 | Quebec | Imprimeries Transcontinental Inc. | Beauceville, QC G5X 3P3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G5X3P3 | beauceville | Low Wage | |
| 81504 | 81504 | Quebec | Industries de la Rive-Sud ltée | Sainte-Croix, QC G0S 2H0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0S2H0 | sainte-croix | Low Wage | |
| 81513 | 81513 | Quebec | Interstar Materials, Inc. | Sherbrooke, QC J1L 3A5 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J1L3A5 | sherbrooke | Low Wage | |
| 81537 | 81537 | Quebec | L.S. Finition Industrielle inc | Plessisville, QC G6L 3T1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G6L3T1 | plessisville | Low Wage | |
| 81548 | 81548 | Quebec | Laboratoire Du-Var inc. | Boucherville, QC J4B 6H5 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J4B6H5 | boucherville | Low Wage | |
| 81619 | 81619 | Quebec | Les Industries Associées de l'Acier Ltée | Sainte Catherine, QC J5C 1B6 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J5C1B6 | sainte catherine | Low Wage | |
| 81679 | 81679 | Quebec | Marquis imprimeur inc. | Montmagny, QC G5V 4T1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G5V4T1 | montmagny | Low Wage | |
| 81700 | 81700 | Quebec | Mobilier de bureau logiflex inc. | Sherbrooke, QC J1N 0H2 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J1N0H2 | sherbrooke | Low Wage | |
| 81708 | 81708 | Quebec | Multiver Ltée | Québec, QC G1M 1C8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G1M1C8 | québec | Low Wage | |
| 81715 | 81715 | Quebec | NexKemia Pétrochimies Inc | Mansonville, QC J0E 1X0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J0E1X0 | mansonville | Low Wage | |
| 81746 | 81746 | Quebec | Picardie International Ltée | BATISCAN, QC G0X 1A0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0X1A0 | batiscan | Low Wage | |
| 81767 | 81767 | Quebec | Produits de Construction Derby Inc | Saint-Augustin-de-Desmaures, QC G3A 2K1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G3A2K1 | saint-augustin-de-desmaures | Low Wage | |
| 81840 | 81840 | Quebec | SANI-ECO INC. | Granby, QC J2G 3Z6 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J2G3Z6 | granby | Low Wage | |
| 81846 | 81846 | Quebec | SDF Abrasifs inc. | Trois-Rivières, QC G9A 5E1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G9A5E1 | trois-rivières | Low Wage | |
| 81899 | 81899 | Quebec | Techo-Bloc inc. | St-Hubert, QC J3Y 8Z8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | J3Y8Z8 | st-hubert | Low Wage | |
| 81901 | 81901 | Quebec | Teknion Groupe Québec Inc | Laurier-Station, QC G0S 1N0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0S1N0 | laurier-station | Low Wage | |
| 81902 | 81902 | Quebec | Teknion Roy & Breton Inc. | SAINT-VALLIER, QC G0R 4J0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G0R4J0 | saint-vallier | Low Wage | |
| 81903 | 81903 | Quebec | Teknion Roy et Breton Inc. | Lévis, QC G6Y 9E8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | G6Y9E8 | lévis | Low Wage | |
| 85231 | 85231 | Ontario | Albany Packaging Inc | Markham, ON L3R 8C3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | L3R8C3 | markham | Low Wage | |
| 85397 | 85397 | Ontario | Gienow Canada Inc | St.Thomas, ON N5P 3T2 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | N5P3T2 | st.thomas | Low Wage | |
| 85776 | 85776 | Ontario | Trillium Recycling Inc. | Ajax, ON L1S 2G3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | L1S2G3 | ajax | Low Wage | |
| 86808 | 86808 | Manitoba | Riverbend Building Supply Ltd | Carberry, MB R0K 0H0 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | R0K0H0 | carberry | Low Wage | |
| 87386 | 87386 | Alberta | COCHRANE BOTTLE DEPOT LTD. | COCHRANE, AB T4C 2C3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T4C2C3 | cochrane | High Wage | |
| 87520 | 87520 | Alberta | High River Bottle Depot Inc. | Calgary, AB T3P 1B | 9619-Other labourers in processing, manufacturing and utilities | 2022 | 1B | calgary | High Wage | |
| 87573 | 87573 | Alberta | JUPITER ENTERPRISES LTD | CALGARY, AB T2H 0R2 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T2H0R2 | calgary | High Wage | |
| 87626 | 87626 | Alberta | MARS ENTERPRISES LTD. | CALGARY, AB T3R 1R8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T3R1R8 | calgary | High Wage | |
| 88768 | 88768 | Alberta | All Span Building Systems Ltd. | Cochrane, AB T4C 2E1 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T4C2E1 | cochrane | Low Wage | |
| 88856 | 88856 | Alberta | Brydon Stairs Ltd. | Calgary, AB T2E 7A9 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T2E7A9 | calgary | Low Wage | |
| 88921 | 88921 | Alberta | Concrete Inc | Edmonton, AB T5S 2C6 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T5S2C6 | edmonton | Low Wage | |
| 89501 | 89501 | Alberta | Shanked Computer Recycling Inc. | Acheson, AB T7X 6C3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | T7X6C3 | acheson | Low Wage | |
| 89981 | 89981 | British Columbia | A-1 Trusses Ltd. | Surrey, BC V4N 3M9 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V4N3M9 | surrey | High Wage | |
| 92067 | 92067 | British Columbia | Adwood Manufacturing Ltd | Kamloops, BC V2H 1S9 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V2H1S9 | kamloops | Low Wage | |
| 92102 | 92102 | British Columbia | APEX ALUMINUM EXTRUSIONS LTD. | LANGLEY, BC V1M 3E7 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V1M3E7 | langley | Low Wage | |
| 92136 | 92136 | British Columbia | Atlantic Marble Manufacturing Ltd. | Vancouver, BC V5X 3E3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V5X3E3 | vancouver | Low Wage | |
| 92577 | 92577 | British Columbia | Gillwood Manufacturing Inc. | Chilliwack, BC V2R 4P4 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V2R4P4 | chilliwack | Low Wage | |
| 93062 | 93062 | British Columbia | New Eurowest Cabinets Ltd. | Surrey, BC V3W 1H8 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V3W1H8 | surrey | Low Wage | |
| 93105 | 93105 | British Columbia | Oasis Windows (Canada) Inc. | Surrey, BC V3S 8E5 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V3S8E5 | surrey | Low Wage | |
| 93471 | 93471 | British Columbia | Sunset Coast Distributors Ltd. | Powell River, BC V8A 1W3 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V8A1W3 | powell river | Low Wage | |
| 93692 | 93692 | British Columbia | Vitrum Industries Ltd. | LANGLEY, BC V1M 3E7 | 9619-Other labourers in processing, manufacturing and utilities | 2022 | V1M3E7 | langley | Low Wage | |
| 94885 | 94885 | Quebec | Soleno Inc. | SAINT-JEAN-SUR-RICHELIEU, QC J2X 4J5 | 9619-Other labourers in processing, manufacturing and utilities | 13 | 2018 | J2X4J5 | saint-jean-sur-richelieu | Low Wage |
| 96061 | 96061 | Ontario | Mucci Pac Ltd | Kingsville, ON N9Y 2N1 | 9619-Other labourers in processing, manufacturing and utilities | 15 | 2018 | N9Y2N1 | kingsville | Low Wage |
| 100228 | 100228 | Quebec | IMPRIMERIE F.L. WEB INC. | Saint-Germain-de-Grantham, QC J0C 1K0 | 9619-Other labourers in processing, manufacturing and utilities | 7 | 2022 | J0C1K0 | saint-germain-de-grantham | High Wage |
| 101723 | 101723 | Quebec | ATTRACTION.INC | Lac-Drolet, QC G0Y 1C0 | 9619-Other labourers in processing, manufacturing and utilities | 5 | 2022 | G0Y1C0 | lac-drolet | Low Wage |
| 101857 | 101857 | Quebec | Camping Marina Bellerive inc. | St-Ours, QC J0G 1P0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | J0G1P0 | st-ours | Low Wage |
| 101881 | 101881 | Quebec | Cascades Canada ULC | Kingsey Falls, QC J0A 1B0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | J0A1B0 | kingsey falls | Low Wage |
| 101887 | 101887 | Quebec | Cascades Sonoco inc | Kingsey Falls, QC J0A 1B0 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | J0A1B0 | kingsey falls | Low Wage |
| 102359 | 102359 | Quebec | Glendyne inc | Saint-Marc-Du-Lac-Long, QC G0L 1T0 | 9619-Other labourers in processing, manufacturing and utilities | 5 | 2022 | G0L1T0 | saint-marc-du-lac-long | Low Wage |
| 102373 | 102373 | Quebec | Groupe C. & G. Beaulieu Inc. | Saint-Basile-le-Grand, QC J3N 0E1 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | J3N0E1 | saint-basile-le-grand | Low Wage |
| 102400 | 102400 | Quebec | Groupe PureSphera inc. | Bécancour, QC G9H 0B6 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | G9H0B6 | bécancour | Low Wage |
| 102452 | 102452 | Quebec | Imprimeries Transcontinental Inc. | Montréal, QC H3B 0G | 9619-Other labourers in processing, manufacturing and utilities | 17 | 2022 | 0G | montréal | Low Wage |
| 102516 | 102516 | Quebec | L.H. Plante | Saint-Ignace de Loyola, QC J0K 2P0 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2022 | J0K2P0 | saint-ignace de loyola | Low Wage |
| 102548 | 102548 | Quebec | Laboratoire Du-Var inc. | Boucherville, QC J4B 6H5 | 9619-Other labourers in processing, manufacturing and utilities | 8 | 2022 | J4B6H5 | boucherville | Low Wage |
| 102731 | 102731 | Quebec | Les Mousses de l'Estrie inc | Lambton, QC G0M 1H0 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | G0M1H0 | lambton | Low Wage |
| 102897 | 102897 | Quebec | Marquis imprimeur inc. | Montmagny, QC G5V 4T1 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | G5V4T1 | montmagny | Low Wage |
| 102911 | 102911 | Quebec | Matelas Avanti Inc | St-Narcisse, QC G0X 2Y0 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | G0X2Y0 | st-narcisse | Low Wage |
| 102961 | 102961 | Quebec | Mobilier de bureau logiflex inc. | Sherbrooke, QC J1N 0H2 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | J1N0H2 | sherbrooke | Low Wage |
| 103329 | 103329 | Quebec | RPM Environnement | Blainville, QC J7C 5P9 | 9619-Other labourers in processing, manufacturing and utilities | 3 | 2022 | J7C5P9 | blainville | Low Wage |
| 103357 | 103357 | Quebec | Service de conditionnement Abeilles Busy Bees | Montréal, QC H1J 2Y5 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2022 | H1J2Y5 | montréal | Low Wage |
| 103464 | 103464 | Quebec | T.M.S. Construction Inc. | Saint-Henri, QC G0R 3E0 | 9619-Other labourers in processing, manufacturing and utilities | 3 | 2022 | G0R3E0 | saint-henri | Low Wage |
| 103474 | 103474 | Quebec | Teknion Groupe Québec Inc | Laurier-Station, QC G0S 1N0 | 9619-Other labourers in processing, manufacturing and utilities | 6 | 2022 | G0S1N0 | laurier-station | Low Wage |
| 103482 | 103482 | Quebec | Thermo 2000 Inc. | Richmond, QC J0B 2H0 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2022 | J0B2H0 | richmond | Low Wage |
| 103499 | 103499 | Quebec | Tourbière Ouellet et Fils inc | L'ISLE-VERTE, QC G0L 1L0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | G0L1L0 | l'isle-verte | Low Wage |
| 103557 | 103557 | Quebec | Valtech Fabrication inc | Salaberry-de-Valleyfield, QC J6T 6G4 | 9619-Other labourers in processing, manufacturing and utilities | 4 | 2022 | J6T6G4 | salaberry-de-valleyfield | Low Wage |
| 106959 | 106959 | Ontario | Supreme Wire Products Ltd. | Brampton, ON L6S 5M9 | 9619-Other labourers in processing, manufacturing and utilities | 3 | 2022 | L6S5M9 | brampton | High Wage |
| 108314 | 108314 | Ontario | Muskoka Lumber and Building Suipplies | Port Carling, ON P0B 1J0 | 9619-Other labourers in processing, manufacturing and utilities | 6 | 2022 | P0B1J0 | port carling | Low Wage |
| 110237 | 110237 | Saskatchewan | B.N. Steel & Metal (2002) Inc. | Saskatoon, SK S7K 1W4 | 9619-Other labourers in processing, manufacturing and utilities | 17 | 2022 | S7K1W4 | saskatoon | Low Wage |
| 110262 | 110262 | Saskatchewan | Hub City Iron & Metal (2017) Ltd | Saskatoon, SK S7P 0C3 | 9619-Other labourers in processing, manufacturing and utilities | 3 | 2022 | S7P0C3 | saskatoon | Low Wage |
| 111112 | 111112 | Alberta | Willow Creek Recycling Inc. | CLARESHOLM, AB T0L 0T0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | T0L0T0 | claresholm | High Wage |
| 112101 | 112101 | Alberta | AIRDRIE TRAILER SALES LTD. | Rocky View County, AB T4B 5C1 | 9619-Other labourers in processing, manufacturing and utilities | 2 | 2022 | T4B5C1 | rocky view county | Low Wage |
| 112757 | 112757 | Alberta | Maysfield Appliance Repair LTD | Edmonton, AB T6B 2Y2 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | T6B2Y2 | edmonton | Low Wage |
| 112771 | 112771 | Alberta | MJ Miracles Inc | Two Hills, AB T0B 4K0 | 9619-Other labourers in processing, manufacturing and utilities | 1 | 2022 | T0B4K0 | two hills | Low 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);