You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Yellow Page Information For Business Of Canada 1", "desc": "Yellow Page Information Of Canada Data Set", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/by_table/city_x_category_industry/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/by_table/city_x_category_industry/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/by_table/city_x_category_industry/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.0020799999999999998177846460833961828029714524745941162109375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 102842, "pages_total": 1029 }, "struct": { "stem": { "0": "city_x_category_industry", "1": "city", "2": "state", "3": "category_industry" }, "leaf": "city_x_category_industry.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "107": { "city_x_category_industry.id": 107, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 2, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Repairing & Service" }, "126": { "city_x_category_industry.id": 126, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 9, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Contractors" }, "127": { "city_x_category_industry.id": 127, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 10, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Contractors - General" }, "132": { "city_x_category_industry.id": 132, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 15, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Excavating Contractors" }, "148": { "city_x_category_industry.id": 148, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 17, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Home Builders" }, "153": { "city_x_category_industry.id": 153, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 20, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Landscape Contractors" }, "162": { "city_x_category_industry.id": 162, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 24, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Oil Field Services" }, "174": { "city_x_category_industry.id": 174, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 43, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Recreational Vehicles - Rental & Leasing" }, "176": { "city_x_category_industry.id": 176, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 47, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Renovations & Home Improvements" }, "177": { "city_x_category_industry.id": 177, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 48, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Rental Service Stores & Yards" }, "178": { "city_x_category_industry.id": 178, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 49, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Restaurants" }, "182": { "city_x_category_industry.id": 182, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 53, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Roofing Contractors" }, "183": { "city_x_category_industry.id": 183, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 55, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Safety Consultants & Training" }, "186": { "city_x_category_industry.id": 186, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 60, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Siding Contractors" }, "191": { "city_x_category_industry.id": 191, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 76, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Tires - Retail" }, "193": { "city_x_category_industry.id": 193, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 86, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Travel Services" }, "194": { "city_x_category_industry.id": 194, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 91, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Truck Lines" }, "197": { "city_x_category_industry.id": 197, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 99, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Welding Shops" }, "101": { "city_x_category_industry.id": 101, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 101, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Accountants & Bookkeeping Services" }, "102": { "city_x_category_industry.id": 102, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 102, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Accountants - Certified General" }, "103": { "city_x_category_industry.id": 103, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 103, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Air Conditioning Contractors & Systems" }, "104": { "city_x_category_industry.id": 104, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 104, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Associations, Clubs & Organizations" }, "105": { "city_x_category_industry.id": 105, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 105, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Automobile Dealers - New Cars" }, "106": { "city_x_category_industry.id": 106, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 106, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Automobile Parts & Supplies - New - Retail" }, "108": { "city_x_category_industry.id": 108, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 108, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Bakers - Retail" }, "109": { "city_x_category_industry.id": 109, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 109, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Bankruptcy Trustees" }, "110": { "city_x_category_industry.id": 110, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 110, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Banks" }, "111": { "city_x_category_industry.id": 111, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 111, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Bars, Lounges, Pubs, Taverns & Other Drinking Places" }, "112": { "city_x_category_industry.id": 112, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 112, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Beauty Products" }, "113": { "city_x_category_industry.id": 113, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 113, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Beauty Treatments" }, "114": { "city_x_category_industry.id": 114, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 114, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Beer & Liquor Stores" }, "115": { "city_x_category_industry.id": 115, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 115, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Building Contractors" }, "116": { "city_x_category_industry.id": 116, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 116, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Building Materials - Retail" }, "117": { "city_x_category_industry.id": 117, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 117, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Buildings - Pre-Cut, Prefabricated & Modular" }, "118": { "city_x_category_industry.id": 118, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 118, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Buses - Charter & Rental" }, "119": { "city_x_category_industry.id": 119, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 119, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Car Rental" }, "120": { "city_x_category_industry.id": 120, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 120, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Car Washing & Polishing" }, "121": { "city_x_category_industry.id": 121, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 121, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Caterers" }, "122": { "city_x_category_industry.id": 122, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 122, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Child Care & Day Care Services" }, "123": { "city_x_category_industry.id": 123, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 123, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Chiropractors DC" }, "124": { "city_x_category_industry.id": 124, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 124, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Coffee Shops, Cafes & Espresso Bars" }, "125": { "city_x_category_industry.id": 125, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 125, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Computers, Laptops & Parts" }, "128": { "city_x_category_industry.id": 128, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 128, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Counselling & Counsellors" }, "129": { "city_x_category_industry.id": 129, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 129, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Dentists" }, "130": { "city_x_category_industry.id": 130, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 130, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Electrical Contractors" }, "131": { "city_x_category_industry.id": 131, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 131, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Engineers" }, "133": { "city_x_category_industry.id": 133, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 133, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Facial Skin Care" }, "134": { "city_x_category_industry.id": 134, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 134, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Fences & Fence Contractors" }, "135": { "city_x_category_industry.id": 135, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 135, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Floor Laying, Refinishing & Resurfacing" }, "136": { "city_x_category_industry.id": 136, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 136, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Floor Materials - Retail" }, "137": { "city_x_category_industry.id": 137, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 137, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Franchising" }, "138": { "city_x_category_industry.id": 138, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 138, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Furnaces - Repair & Cleaning" }, "139": { "city_x_category_industry.id": 139, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 139, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Furniture - Retail" }, "140": { "city_x_category_industry.id": 140, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 140, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Gas Fitters" }, "141": { "city_x_category_industry.id": 141, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 141, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Gift Shops" }, "142": { "city_x_category_industry.id": 142, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 142, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Glass Replacement & Repair" }, "143": { "city_x_category_industry.id": 143, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 143, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Hair Goods - Retail" }, "144": { "city_x_category_industry.id": 144, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 144, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Hairstyling" }, "145": { "city_x_category_industry.id": 145, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 145, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Health & Diet Foods - Retail" }, "146": { "city_x_category_industry.id": 146, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 146, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Health Clubs & Fitness Centres" }, "147": { "city_x_category_industry.id": 147, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 147, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Heating Contractors & Furnaces" }, "149": { "city_x_category_industry.id": 149, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 149, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Hotels, Motels & Other Accommodations" }, "150": { "city_x_category_industry.id": 150, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 150, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Insurance Agents & Brokers" }, "151": { "city_x_category_industry.id": 151, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 151, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Insurance Companies" }, "152": { "city_x_category_industry.id": 152, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 152, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Interior Decorators & Designers" }, "154": { "city_x_category_industry.id": 154, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 154, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Lawyers" }, "155": { "city_x_category_industry.id": 155, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 155, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Limousine Services" }, "156": { "city_x_category_industry.id": 156, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 156, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Massage Therapists - Registered" }, "157": { "city_x_category_industry.id": 157, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 157, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Medical Clinics" }, "158": { "city_x_category_industry.id": 158, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 158, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Mortgages & Mortgage Brokers" }, "159": { "city_x_category_industry.id": 159, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 159, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Motorcycles & Motor Scooters - Retail" }, "160": { "city_x_category_industry.id": 160, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 160, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Nail Salons" }, "161": { "city_x_category_industry.id": 161, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 161, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Oil Burners - Service" }, "163": { "city_x_category_industry.id": 163, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 163, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Opticians - Glasses, Frames & Contact Lenses" }, "164": { "city_x_category_industry.id": 164, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 164, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Optometrists" }, "165": { "city_x_category_industry.id": 165, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 165, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Paint - Retail" }, "166": { "city_x_category_industry.id": 166, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 166, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Pet Supplies & Food" }, "167": { "city_x_category_industry.id": 167, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 167, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Pet Washing & Grooming" }, "168": { "city_x_category_industry.id": 168, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 168, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Pharmacies" }, "169": { "city_x_category_industry.id": 169, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 169, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Pipe Fittings" }, "170": { "city_x_category_industry.id": 170, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 170, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Plumbing Contractors" }, "171": { "city_x_category_industry.id": 171, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 171, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Pre-Schools" }, "172": { "city_x_category_industry.id": 172, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 172, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Psychologists, Therapy & Psychology" }, "173": { "city_x_category_industry.id": 173, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 173, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Real Estate Agencies & Brokers" }, "175": { "city_x_category_industry.id": 175, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 175, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Religious Organizations" }, "179": { "city_x_category_industry.id": 179, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 179, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Restaurants - Chinese" }, "180": { "city_x_category_industry.id": 180, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 180, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Restaurants - Fast Food" }, "181": { "city_x_category_industry.id": 181, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 181, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Restaurants - Pizza" }, "184": { "city_x_category_industry.id": 184, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 184, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Schools & Educational Services" }, "185": { "city_x_category_industry.id": 185, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 185, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Schools - Public" }, "187": { "city_x_category_industry.id": 187, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 187, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Skin Care Products & Treatments" }, "188": { "city_x_category_industry.id": 188, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 188, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Storage - Boat & Recreational Vehicles" }, "189": { "city_x_category_industry.id": 189, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 189, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Tax Return Preparation" }, "190": { "city_x_category_industry.id": 190, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 190, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Taxicabs" }, "192": { "city_x_category_industry.id": 192, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 192, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Towing Services" }, "195": { "city_x_category_industry.id": 195, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 195, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Trucks - Rental & Leasing" }, "196": { "city_x_category_industry.id": 196, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 196, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Veterinarians" }, "198": { "city_x_category_industry.id": 198, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 198, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Window Coverings - Draperies, Blinds, Shutters & Shades" }, "199": { "city_x_category_industry.id": 199, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 199, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Windows & Doors" }, "200": { "city_x_category_industry.id": 200, "city.id": 2, "city.ts": "2018-04-07 03:26:04", "city.city": "Airdrie", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 200, "category_industry.ts": "2018-04-07 06:28:22", "category_industry.category_industry": "Women's Apparel - Retail" } } } }