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": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/main/list/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/main/list/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/yellow_page_information_for_business_of_Canada_1/main/list/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 20, "limit_total": 400, "time": 0.0037799999999999999399091787921634022495709359645843505859375 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 3167986, "pages_total": 158400 }, "struct": { "stem": { "0": "company", "1": "city_x_category_industry", "2": "city", "3": "state", "4": "category_industry" }, "leaf": "company.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "41": { "company.id": 41, "company.company": "Hedd Automotive Inc", "company.description": "Situated at 10760 178 St NW near you, Hedd Automotive Inc is an enterprise included in the automobile repairing & service section of Canpages.ca online directory.Please call 780-486-0142 to do business with Hedd Automotive Inc that is near your area.Finally, please share this info with your contacts by using Facebook or Twitter icons.", "company.address": "10760 178 St NW Edmonton, AB, T5S 1J3", "company.telephone": "780-486-0142", "company.rating_index": "", "company.latitude": 53.55514600000000058344085118733346462249755859375, "company.longitude": -113.6273450000000053705662139691412448883056640625, "company.ts": "2018-05-11 01:52:09", "company.company_opne_time_id": {}, "company.company_detail_id": { "120": { "company_detail.id": 120, "company_detail.ts": "2018-05-11 01:52:09", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "668": { "company_detail_value.id": 668, "company_detail_value.ts": "2018-05-11 01:52:09", "company_detail_value.value": "Automobile repairing & service" } } }, "121": { "company_detail.id": 121, "company_detail.ts": "2018-05-11 01:52:09", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "669": { "company_detail_value.id": 669, "company_detail_value.ts": "2018-05-11 01:52:09", "company_detail_value.value": "Automobile Repairing & Service" }, "670": { "company_detail_value.id": 670, "company_detail_value.ts": "2018-05-11 01:52:09", "company_detail_value.value": "Engines - Rebuilding, Repair & Exchange" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "42": { "company.id": 42, "company.company": "West End Nissan", "company.description": "Situated at 10152 179th Street NW near you, West End Nissan is a merchant in the automobile radiators - repair category of Canpages.ca online directory.You can call 780-486-1780 to contact West End Nissan that is close to your area.Finally, please share this with your contacts by clicking Facebook or Twitter icons.", "company.address": "10152 179th Street NW Edmonton, AB, T5S 1S1", "company.telephone": "780-486-1780", "company.rating_index": "", "company.latitude": 53.5433170000000018262653611600399017333984375, "company.longitude": -113.6311199999999956844476400874555110931396484375, "company.ts": "2018-05-11 01:52:48", "company.company_opne_time_id": {}, "company.company_detail_id": { "122": { "company_detail.id": 122, "company_detail.ts": "2018-05-11 01:52:48", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "671": { "company_detail_value.id": 671, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automobile Radiators - Repair" }, "672": { "company_detail_value.id": 672, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automotive Services - Mechanical" }, "673": { "company_detail_value.id": 673, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automotive Services" }, "674": { "company_detail_value.id": 674, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automobile Tune-Up Services" }, "675": { "company_detail_value.id": 675, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automobile Repairing & Service" }, "676": { "company_detail_value.id": 676, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Oil Treating" }, "677": { "company_detail_value.id": 677, "company_detail_value.ts": "2018-05-11 01:52:48", "company_detail_value.value": "Automobile Alternators & Generators - Repair" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "43": { "company.id": 43, "company.company": "West End Nissan", "company.description": "Situated at 10152 179 Street NW near you, West End Nissan is a merchant in the automobile repairing & service section of Canpages.ca online directory.Phone 780-486-1910 to contact West End Nissan that is close to your area.Finally, feel free to share this with your contacts by clicking Facebook or Twitter icons.", "company.address": "10152 179 Street NW Edmonton, AB, T5S 1S1", "company.telephone": "780-486-1910", "company.rating_index": "", "company.latitude": 53.5433170000000018262653611600399017333984375, "company.longitude": -113.6311199999999956844476400874555110931396484375, "company.ts": "2018-05-11 01:53:14", "company.company_opne_time_id": {}, "company.company_detail_id": { "123": { "company_detail.id": 123, "company_detail.ts": "2018-05-11 01:53:14", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "678": { "company_detail_value.id": 678, "company_detail_value.ts": "2018-05-11 01:53:14", "company_detail_value.value": "Automobile Repairing & Service" }, "679": { "company_detail_value.id": 679, "company_detail_value.ts": "2018-05-11 01:53:14", "company_detail_value.value": "Automobile Dealers - New Cars" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "44": { "company.id": 44, "company.company": "West Side Acura", "company.description": "Situated at 17707 111 Ave NW in Edmonton, West Side Acura is a merchant included in the automobile repairing & service section of Canpages.ca online directory.Please call 780-484-5444 to contact West Side Acura that is close to your area.Finally, please share this with your contacts by clicking Facebook or Twitter icons.", "company.address": "17707 111 Ave NW Edmonton, AB, T5S 0A1", "company.telephone": "780-484-5444", "company.rating_index": "", "company.latitude": 53.5596120000000013305907486937940120697021484375, "company.longitude": -113.6256110000000063564584706909954547882080078125, "company.ts": "2018-05-11 01:53:43", "company.company_opne_time_id": {}, "company.company_detail_id": { "124": { "company_detail.id": 124, "company_detail.ts": "2018-05-11 01:53:43", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "680": { "company_detail_value.id": 680, "company_detail_value.ts": "2018-05-11 01:53:43", "company_detail_value.value": "Automobile Repairing & Service" }, "681": { "company_detail_value.id": 681, "company_detail_value.ts": "2018-05-11 01:53:43", "company_detail_value.value": "Automobile Dealers - New Cars" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "45": { "company.id": 45, "company.company": "Autopro Automation", "company.description": "Situated at 17870 102 Ave NW in Edmonton, Alberta, Autopro Automation is an enterprise within the garages section of Canpages.ca online directory.Dial 780-487-2811 to do business with Autopro Automation that is near your area.Finally, please share this info with your contacts by using Facebook or Twitter icons.", "company.address": "17870 102 Ave NW Edmonton, AB, T5S 1M9", "company.telephone": "780-487-2811", "company.rating_index": "", "company.latitude": 53.543329999999997426129993982613086700439453125, "company.longitude": -113.6297200000000060526872402988374233245849609375, "company.ts": "2018-05-11 01:54:10", "company.company_opne_time_id": {}, "company.company_detail_id": { "125": { "company_detail.id": 125, "company_detail.ts": "2018-05-11 01:54:10", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "682": { "company_detail_value.id": 682, "company_detail_value.ts": "2018-05-11 01:54:10", "company_detail_value.value": "Garages" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "46": { "company.id": 46, "company.company": "RCM Autopro Ltd", "company.description": "Located at 17870 102 Avenue NW in Edmonton, RCM Autopro Ltd is a company within the automobile dealers - new cars category of Canpages website.Dial 780-487-2889 to get in touch with RCM Autopro Ltd that is in your neighbourhood.Finally, feel free to send this page to your friends by accessing Facebook or Twitter links.", "company.address": "17870 102 Avenue NW Edmonton, AB, T5S 1M9", "company.telephone": "780-487-2889", "company.rating_index": "", "company.latitude": 53.543329999999997426129993982613086700439453125, "company.longitude": -113.6297200000000060526872402988374233245849609375, "company.ts": "2018-05-11 01:54:40", "company.company_opne_time_id": { "153": { "company_opne_time.id": 153, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Monday 9:00 am - 8:00 pm" }, "154": { "company_opne_time.id": 154, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Tuesday 9:00 am - 8:00 pm" }, "155": { "company_opne_time.id": 155, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Wednesday 9:00 am - 8:00 pm" }, "156": { "company_opne_time.id": 156, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Thursday 9:00 am - 8:00 pm" }, "157": { "company_opne_time.id": 157, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Friday 9:00 am - 6:00 pm" }, "158": { "company_opne_time.id": 158, "company_opne_time.ts": "2018-05-11 01:54:40", "company_opne_time.open_time": "Saturday 9:00 am - 6:00 pm" } }, "company.company_detail_id": { "126": { "company_detail.id": 126, "company_detail.ts": "2018-05-11 01:54:40", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "683": { "company_detail_value.id": 683, "company_detail_value.ts": "2018-05-11 01:54:40", "company_detail_value.value": "New car dealers" } } }, "127": { "company_detail.id": 127, "company_detail.ts": "2018-05-11 01:54:40", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "684": { "company_detail_value.id": 684, "company_detail_value.ts": "2018-05-11 01:54:40", "company_detail_value.value": "Automobile Dealers - New Cars" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "47": { "company.id": 47, "company.company": "BFF Auto Inc", "company.description": "Situated at 17841 102 Ave NW near you, BFF Auto Inc is an enterprise inside the automobile radiators - repair section of Canpages.ca online directory.Feel free to call 780-758-4343 to do business with BFF Auto Inc that is near your area.Finally, feel free to share this info with your contacts by using Facebook or Twitter icons.", "company.address": "17841 102 Ave NW Edmonton, AB, T5S 1R1", "company.telephone": "780-758-4343", "company.rating_index": "", "company.latitude": 53.543328999999999950887286104261875152587890625, "company.longitude": -113.6293730000000010704752639867365360260009765625, "company.ts": "2018-05-11 01:55:02", "company.company_opne_time_id": {}, "company.company_detail_id": { "128": { "company_detail.id": 128, "company_detail.ts": "2018-05-11 01:55:02", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "685": { "company_detail_value.id": 685, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automobile Radiators - Repair" }, "686": { "company_detail_value.id": 686, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automotive Services - Mechanical" }, "687": { "company_detail_value.id": 687, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automotive Services" }, "688": { "company_detail_value.id": 688, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automobile Tune-Up Services" }, "689": { "company_detail_value.id": 689, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automobile Repairing & Service" }, "690": { "company_detail_value.id": 690, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Oil Treating" }, "691": { "company_detail_value.id": 691, "company_detail_value.ts": "2018-05-11 01:55:02", "company_detail_value.value": "Automobile Alternators & Generators - Repair" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "48": { "company.id": 48, "company.company": "Napa Autopro", "company.description": "Situated at 13-40 South Ave in Spruce Grove, Alberta, Napa Autopro is an enterprise within the automobile radiators - repair section of Canpages.ca online directory.Phone 780-962-4707 to do business with Napa Autopro that is near your area.Finally, feel free to share this info with your contacts by using Facebook or Twitter icons.", "company.address": "13-40 South Ave Spruce Grove, AB, T7X 2K1", "company.telephone": "780-962-4707", "company.rating_index": "", "company.latitude": 53.53892499999999898818714427761733531951904296875, "company.longitude": -113.90690100000000484214979223906993865966796875, "company.ts": "2018-05-11 01:55:26", "company.company_opne_time_id": {}, "company.company_detail_id": { "129": { "company_detail.id": 129, "company_detail.ts": "2018-05-11 01:55:26", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "692": { "company_detail_value.id": 692, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automobile Radiators - Repair" }, "693": { "company_detail_value.id": 693, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automotive Services - Mechanical" }, "694": { "company_detail_value.id": 694, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automotive Services" }, "695": { "company_detail_value.id": 695, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automobile Tune-Up Services" }, "696": { "company_detail_value.id": 696, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automobile Repairing & Service" }, "697": { "company_detail_value.id": 697, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Oil Treating" }, "698": { "company_detail_value.id": 698, "company_detail_value.ts": "2018-05-11 01:55:26", "company_detail_value.value": "Automobile Alternators & Generators - Repair" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "49": { "company.id": 49, "company.company": "NAPA AUTOPRO & Tire Spruce Grove", "company.description": "Located at 13-40 South Avenue near you, NAPA AUTOPRO & Tire Spruce Grove is a local business in the garages category of Canpages website.You can call 780-962-4707 to get in contact with NAPA AUTOPRO & Tire Spruce Grove that is located in your neighbourhood.Finally, feel free to send this to your friends by clicking on Facebook or Twitter links.", "company.address": "13-40 South Avenue Spruce Grove, AB, T7X 4G3", "company.telephone": "780-962-4707", "company.rating_index": "", "company.latitude": 53.53892499999999898818714427761733531951904296875, "company.longitude": -113.90690100000000484214979223906993865966796875, "company.ts": "2018-05-11 01:55:56", "company.company_opne_time_id": { "159": { "company_opne_time.id": 159, "company_opne_time.ts": "2018-05-11 01:55:56", "company_opne_time.open_time": "Monday 7:30 am - 5:00 pm" }, "160": { "company_opne_time.id": 160, "company_opne_time.ts": "2018-05-11 01:55:56", "company_opne_time.open_time": "Tuesday 7:30 am - 5:00 pm" }, "161": { "company_opne_time.id": 161, "company_opne_time.ts": "2018-05-11 01:55:56", "company_opne_time.open_time": "Wednesday 7:30 am - 5:00 pm" }, "162": { "company_opne_time.id": 162, "company_opne_time.ts": "2018-05-11 01:55:56", "company_opne_time.open_time": "Thursday 7:30 am - 5:00 pm" }, "163": { "company_opne_time.id": 163, "company_opne_time.ts": "2018-05-11 01:55:56", "company_opne_time.open_time": "Friday 7:30 am - 5:00 pm" } }, "company.company_detail_id": { "130": { "company_detail.id": 130, "company_detail.ts": "2018-05-11 01:55:56", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "699": { "company_detail_value.id": 699, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "Auto Repair" } } }, "131": { "company_detail.id": 131, "company_detail.ts": "2018-05-11 01:55:56", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "700": { "company_detail_value.id": 700, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "American Express" }, "701": { "company_detail_value.id": 701, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "Cash" }, "702": { "company_detail_value.id": 702, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "Interac" }, "703": { "company_detail_value.id": 703, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "MasterCard" }, "704": { "company_detail_value.id": 704, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "Visa" } } }, "132": { "company_detail.id": 132, "company_detail.ts": "2018-05-11 01:55:56", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "705": { "company_detail_value.id": 705, "company_detail_value.ts": "2018-05-11 01:55:56", "company_detail_value.value": "Garages" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "50": { "company.id": 50, "company.company": "Chrysler Dodge Jeep Authorized Factory Service Centre", "company.description": "Situated at 17817 Stony Plain Rd NW in Edmonton, Alberta, Chrysler Dodge Jeep Authorized Factory Service Centre is an enterprise within the automobile parts & supplies - new - retail section of Canpages.ca online directory.Phone 780-483-5000 to do business with Chrysler Dodge Jeep Authorized Factory Service Centre that is near your area.Finally, you can share this info with your contacts by using Facebook or Twitter icons.", "company.address": "17817 Stony Plain Rd NW Edmonton, AB, T5S 1B4", "company.telephone": "780-483-5000", "company.rating_index": "", "company.latitude": 53.5410480000000035261109587736427783966064453125, "company.longitude": -113.6300729999999958863554638810455799102783203125, "company.ts": "2018-05-11 01:56:29", "company.company_opne_time_id": {}, "company.company_detail_id": { "133": { "company_detail.id": 133, "company_detail.ts": "2018-05-11 01:56:29", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "706": { "company_detail_value.id": 706, "company_detail_value.ts": "2018-05-11 01:56:29", "company_detail_value.value": "Automobile Parts & Supplies - New - Retail" }, "707": { "company_detail_value.id": 707, "company_detail_value.ts": "2018-05-11 01:56:29", "company_detail_value.value": "Trucks - Retail" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "51": { "company.id": 51, "company.company": "Westgate Chevrolet Ltd", "company.description": "", "company.address": "10145 178 St NW Edmonton, AB, T5S 1E4", "company.telephone": "587-401-7214", "company.rating_index": "", "company.latitude": 53.542766999999997779013938270509243011474609375, "company.longitude": -113.62731800000000248473952524363994598388671875, "company.ts": "2018-05-11 01:56:50", "company.company_opne_time_id": { "164": { "company_opne_time.id": 164, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Monday 8:00 am - 9:00 pm" }, "165": { "company_opne_time.id": 165, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Tuesday 8:00 am - 9:00 pm" }, "166": { "company_opne_time.id": 166, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Wednesday 8:00 am - 9:00 pm" }, "167": { "company_opne_time.id": 167, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Thursday 8:00 am - 9:00 pm" }, "168": { "company_opne_time.id": 168, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Friday 8:00 am - 9:00 pm" }, "169": { "company_opne_time.id": 169, "company_opne_time.ts": "2018-05-11 01:56:50", "company_opne_time.open_time": "Saturday 9:00 am - 6:00 pm" } }, "company.company_detail_id": { "134": { "company_detail.id": 134, "company_detail.ts": "2018-05-11 01:56:50", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "708": { "company_detail_value.id": 708, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Car Repair" }, "709": { "company_detail_value.id": 709, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Used Cars" }, "710": { "company_detail_value.id": 710, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Car Service" }, "711": { "company_detail_value.id": 711, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Car Parts" }, "712": { "company_detail_value.id": 712, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Body Shop" }, "713": { "company_detail_value.id": 713, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "New Vehicles" } } }, "135": { "company_detail.id": 135, "company_detail.ts": "2018-05-11 01:56:50", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "714": { "company_detail_value.id": 714, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Visa" }, "715": { "company_detail_value.id": 715, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "MasterCard" }, "716": { "company_detail_value.id": 716, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Cash" }, "717": { "company_detail_value.id": 717, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Interac" }, "718": { "company_detail_value.id": 718, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "American Express" } } }, "136": { "company_detail.id": 136, "company_detail.ts": "2018-05-11 01:56:50", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "719": { "company_detail_value.id": 719, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "English" } } }, "137": { "company_detail.id": 137, "company_detail.ts": "2018-05-11 01:56:50", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "720": { "company_detail_value.id": 720, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Automobile Repairing & Service" }, "721": { "company_detail_value.id": 721, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Automobile Dealers - New Cars" }, "722": { "company_detail_value.id": 722, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Trucks - Retail" }, "723": { "company_detail_value.id": 723, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Auto Leasing & Financing" }, "724": { "company_detail_value.id": 724, "company_detail_value.ts": "2018-05-11 01:56:50", "company_detail_value.value": "Trucks - Used" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "52": { "company.id": 52, "company.company": "Rick's Auto Service Inc", "company.description": "Situated at 300-16 Renault Cres in Saint-Albert, Alberta, Rick's Auto Service Inc is an enterprise part of the automobile repairing & service section of Canpages.ca online directory.You can call 780-418-1066 to do business with Rick's Auto Service Inc that is near your area.Finally, please share this info with your contacts by using Facebook or Twitter icons.", "company.address": "300-16 Renault Cres Saint-Albert, AB, T8N 4B8", "company.telephone": "780-418-1066", "company.rating_index": "", "company.latitude": 53.61619400000000013051248970441520214080810546875, "company.longitude": -113.6458889999999968267729855142533779144287109375, "company.ts": "2018-05-11 01:57:22", "company.company_opne_time_id": { "170": { "company_opne_time.id": 170, "company_opne_time.ts": "2018-05-11 01:57:22", "company_opne_time.open_time": "Monday 8:00 am - 5:30 pm" }, "171": { "company_opne_time.id": 171, "company_opne_time.ts": "2018-05-11 01:57:22", "company_opne_time.open_time": "Tuesday 8:00 am - 5:30 pm" }, "172": { "company_opne_time.id": 172, "company_opne_time.ts": "2018-05-11 01:57:22", "company_opne_time.open_time": "Wednesday 8:00 am - 5:30 pm" }, "173": { "company_opne_time.id": 173, "company_opne_time.ts": "2018-05-11 01:57:22", "company_opne_time.open_time": "Thursday 8:00 am - 5:30 pm" }, "174": { "company_opne_time.id": 174, "company_opne_time.ts": "2018-05-11 01:57:22", "company_opne_time.open_time": "Friday 8:00 am - 5:30 pm" } }, "company.company_detail_id": { "138": { "company_detail.id": 138, "company_detail.ts": "2018-05-11 01:57:22", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "725": { "company_detail_value.id": 725, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "Automotive repair" } } }, "139": { "company_detail.id": 139, "company_detail.ts": "2018-05-11 01:57:22", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "726": { "company_detail_value.id": 726, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "MasterCard" }, "727": { "company_detail_value.id": 727, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "Interac" }, "728": { "company_detail_value.id": 728, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "Cash" }, "729": { "company_detail_value.id": 729, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "Visa" } } }, "140": { "company_detail.id": 140, "company_detail.ts": "2018-05-11 01:57:22", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "730": { "company_detail_value.id": 730, "company_detail_value.ts": "2018-05-11 01:57:22", "company_detail_value.value": "Automobile Repairing & Service" } } } }, "city_x_category_industry.id": 2, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "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" }, "53": { "company.id": 53, "company.company": "Grove Collision Repairs Ltd", "company.description": "", "company.address": "120 South Ave Spruce Grove, AB, T7X 3B1", "company.telephone": "780-960-8555", "company.rating_index": 4, "company.latitude": 53.53893500000000216232365346513688564300537109375, "company.longitude": -113.9011349999999964666130836121737957000732421875, "company.ts": "2018-05-11 01:57:44", "company.company_opne_time_id": { "175": { "company_opne_time.id": 175, "company_opne_time.ts": "2018-05-11 01:57:44", "company_opne_time.open_time": "Monday 8:00 am - 5:00 pm" }, "176": { "company_opne_time.id": 176, "company_opne_time.ts": "2018-05-11 01:57:44", "company_opne_time.open_time": "Tuesday 8:00 am - 5:00 pm" }, "177": { "company_opne_time.id": 177, "company_opne_time.ts": "2018-05-11 01:57:44", "company_opne_time.open_time": "Wednesday 8:00 am - 5:00 pm" }, "178": { "company_opne_time.id": 178, "company_opne_time.ts": "2018-05-11 01:57:44", "company_opne_time.open_time": "Thursday 8:00 am - 5:00 pm" }, "179": { "company_opne_time.id": 179, "company_opne_time.ts": "2018-05-11 01:57:44", "company_opne_time.open_time": "Friday 8:00 am - 5:00 pm" } }, "company.company_detail_id": { "141": { "company_detail.id": 141, "company_detail.ts": "2018-05-11 01:57:44", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "731": { "company_detail_value.id": 731, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Auto Paint" }, "732": { "company_detail_value.id": 732, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Body Work" }, "733": { "company_detail_value.id": 733, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Autobody" }, "734": { "company_detail_value.id": 734, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Collision Repairs" }, "735": { "company_detail_value.id": 735, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Body Shop" } } }, "142": { "company_detail.id": 142, "company_detail.ts": "2018-05-11 01:57:44", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "736": { "company_detail_value.id": 736, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Visa" }, "737": { "company_detail_value.id": 737, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Cash" }, "738": { "company_detail_value.id": 738, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "MasterCard" }, "739": { "company_detail_value.id": 739, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Interac" } } }, "143": { "company_detail.id": 143, "company_detail.ts": "2018-05-11 01:57:44", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "740": { "company_detail_value.id": 740, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "English" } } }, "144": { "company_detail.id": 144, "company_detail.ts": "2018-05-11 01:57:44", "company_detail.title": "Brands Carried", "company_detail.company_detail_value_id": { "741": { "company_detail_value.id": 741, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Alberta Motor Association" }, "742": { "company_detail_value.id": 742, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Allstate" }, "743": { "company_detail_value.id": 743, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Wawanesa" }, "744": { "company_detail_value.id": 744, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "TD" }, "745": { "company_detail_value.id": 745, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "The Cooperators" }, "746": { "company_detail_value.id": 746, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "The State Farm" }, "747": { "company_detail_value.id": 747, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Carlson Body Shop" }, "748": { "company_detail_value.id": 748, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Intact" }, "749": { "company_detail_value.id": 749, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "ING" }, "750": { "company_detail_value.id": 750, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Economical" }, "751": { "company_detail_value.id": 751, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "AMA" }, "752": { "company_detail_value.id": 752, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "CAA" }, "753": { "company_detail_value.id": 753, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Peace Hills" }, "754": { "company_detail_value.id": 754, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Pembridge" }, "755": { "company_detail_value.id": 755, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Aviva" } } }, "145": { "company_detail.id": 145, "company_detail.ts": "2018-05-11 01:57:44", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "756": { "company_detail_value.id": 756, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Automobile Body Repair & Painting" }, "757": { "company_detail_value.id": 757, "company_detail_value.ts": "2018-05-11 01:57:44", "company_detail_value.value": "Frame Straightening" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "54": { "company.id": 54, "company.company": "Accord Collision & Painting Ltd", "company.description": "", "company.address": "10123 161 St NW Edmonton, AB, T5P 3H9", "company.telephone": "780-452-9600", "company.rating_index": "", "company.latitude": 53.54207000000000249428921961225569248199462890625, "company.longitude": -113.599188999999995530743035487830638885498046875, "company.ts": "2018-05-11 01:58:08", "company.company_opne_time_id": { "180": { "company_opne_time.id": 180, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Monday 8:00 am - 6:00 pm" }, "181": { "company_opne_time.id": 181, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Tuesday 8:00 am - 6:00 pm" }, "182": { "company_opne_time.id": 182, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Wednesday 8:00 am - 6:00 pm" }, "183": { "company_opne_time.id": 183, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Thursday 8:00 am - 6:00 pm" }, "184": { "company_opne_time.id": 184, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Friday 8:00 am - 6:00 pm" }, "185": { "company_opne_time.id": 185, "company_opne_time.ts": "2018-05-11 01:58:08", "company_opne_time.open_time": "Saturday 10:00 am - 3:00 pm" } }, "company.company_detail_id": { "146": { "company_detail.id": 146, "company_detail.ts": "2018-05-11 01:58:08", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "758": { "company_detail_value.id": 758, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "Autobody Repair & Painting Shop" }, "759": { "company_detail_value.id": 759, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "Wheel Alignment, Frame & Axle Services" }, "760": { "company_detail_value.id": 760, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "All Types of Autobody and Paint Jobs" } } }, "147": { "company_detail.id": 147, "company_detail.ts": "2018-05-11 01:58:08", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "761": { "company_detail_value.id": 761, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "English" } } }, "148": { "company_detail.id": 148, "company_detail.ts": "2018-05-11 01:58:08", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "762": { "company_detail_value.id": 762, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "Automobile Body Repair & Painting" }, "763": { "company_detail_value.id": 763, "company_detail_value.ts": "2018-05-11 01:58:08", "company_detail_value.value": "Frame Straightening" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "55": { "company.id": 55, "company.company": "Midas Auto Service Experts", "company.description": "Located at 34 Muir Dr in St. Albert, Alberta, Midas Auto Service Experts is a company in the automobile repairing & service category of Canpages website.Please call 780-459-3586 to get in touch with Midas Auto Service Experts that is in your neighbourhood.Finally, please send this to your friends by accessing Facebook or Twitter links.", "company.address": "34 Muir Dr St. Albert, AB, T8N 1G3", "company.telephone": "780-459-3586", "company.rating_index": "", "company.latitude": 53.638638299999996661426848731935024261474609375, "company.longitude": -113.6250572999999945977833704091608524322509765625, "company.ts": "2018-05-11 01:58:31", "company.company_opne_time_id": {}, "company.company_detail_id": { "149": { "company_detail.id": 149, "company_detail.ts": "2018-05-11 01:58:31", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "764": { "company_detail_value.id": 764, "company_detail_value.ts": "2018-05-11 01:58:31", "company_detail_value.value": "Automobile Repairing & Service" }, "765": { "company_detail_value.id": 765, "company_detail_value.ts": "2018-05-11 01:58:31", "company_detail_value.value": "Tires - Retail" }, "766": { "company_detail_value.id": 766, "company_detail_value.ts": "2018-05-11 01:58:31", "company_detail_value.value": "Mufflers & Exhaust Systems" }, "767": { "company_detail_value.id": 767, "company_detail_value.ts": "2018-05-11 01:58:31", "company_detail_value.value": "Automobile Brake Service - Retail" }, "768": { "company_detail_value.id": 768, "company_detail_value.ts": "2018-05-11 01:58:31", "company_detail_value.value": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "56": { "company.id": 56, "company.company": "Kevin McKort's Collision Center Ltd", "company.description": "", "company.address": "12871 141 Street NW Edmonton, AB, T5L 4N1", "company.telephone": "780-452-9992", "company.rating_index": "", "company.latitude": 53.5871977999999984376700012944638729095458984375, "company.longitude": -113.5641830999999939422195893712341785430908203125, "company.ts": "2018-05-11 01:58:59", "company.company_opne_time_id": { "186": { "company_opne_time.id": 186, "company_opne_time.ts": "2018-05-11 01:58:59", "company_opne_time.open_time": "Monday 8:00 am - 5:00 pm" }, "187": { "company_opne_time.id": 187, "company_opne_time.ts": "2018-05-11 01:58:59", "company_opne_time.open_time": "Tuesday 8:00 am - 5:00 pm" }, "188": { "company_opne_time.id": 188, "company_opne_time.ts": "2018-05-11 01:58:59", "company_opne_time.open_time": "Wednesday 8:00 am - 5:00 pm" }, "189": { "company_opne_time.id": 189, "company_opne_time.ts": "2018-05-11 01:58:59", "company_opne_time.open_time": "Thursday 8:00 am - 5:00 pm" }, "190": { "company_opne_time.id": 190, "company_opne_time.ts": "2018-05-11 01:58:59", "company_opne_time.open_time": "Friday 8:00 am - 5:00 pm" } }, "company.company_detail_id": { "150": { "company_detail.id": 150, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Specialities", "company_detail.company_detail_value_id": { "769": { "company_detail_value.id": 769, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Fleet Repair" } } }, "151": { "company_detail.id": 151, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "770": { "company_detail_value.id": 770, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Damage Repair" }, "771": { "company_detail_value.id": 771, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Body Repair" }, "772": { "company_detail_value.id": 772, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Painting" }, "773": { "company_detail_value.id": 773, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Frame Straighening" }, "774": { "company_detail_value.id": 774, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Unibody Repair" }, "775": { "company_detail_value.id": 775, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Full Frame Repair" } } }, "152": { "company_detail.id": 152, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "776": { "company_detail_value.id": 776, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Interac" }, "777": { "company_detail_value.id": 777, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "MasterCard" }, "778": { "company_detail_value.id": 778, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Visa" } } }, "153": { "company_detail.id": 153, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "779": { "company_detail_value.id": 779, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "English" } } }, "154": { "company_detail.id": 154, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Brands Carried", "company_detail.company_detail_value_id": { "780": { "company_detail_value.id": 780, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Glasurit Refinishing Systems" } } }, "155": { "company_detail.id": 155, "company_detail.ts": "2018-05-11 01:58:59", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "781": { "company_detail_value.id": 781, "company_detail_value.ts": "2018-05-11 01:58:59", "company_detail_value.value": "Automobile Body Repair & Painting" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "57": { "company.id": 57, "company.company": "JD Danmar", "company.description": "", "company.address": "12552 133rd Street NW Edmonton, AB, T5L 4R5", "company.telephone": "587-401-0060", "company.rating_index": "", "company.latitude": 53.582323000000002366505214013159275054931640625, "company.longitude": -113.555712999999997236955096013844013214111328125, "company.ts": "2018-05-11 01:59:25", "company.company_opne_time_id": {}, "company.company_detail_id": { "156": { "company_detail.id": 156, "company_detail.ts": "2018-05-11 01:59:25", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "782": { "company_detail_value.id": 782, "company_detail_value.ts": "2018-05-11 01:59:25", "company_detail_value.value": "Garage - Auto Repairing" } } }, "157": { "company_detail.id": 157, "company_detail.ts": "2018-05-11 01:59:25", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "783": { "company_detail_value.id": 783, "company_detail_value.ts": "2018-05-11 01:59:25", "company_detail_value.value": "English" } } }, "158": { "company_detail.id": 158, "company_detail.ts": "2018-05-11 01:59:25", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "784": { "company_detail_value.id": 784, "company_detail_value.ts": "2018-05-11 01:59:25", "company_detail_value.value": "Automobile Repairing & Service" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "58": { "company.id": 58, "company.company": "Orion Auto Centre Ltd", "company.description": "Situated at 13220 126 Ave NW near you, Orion Auto Centre Ltd is an enterprise part of the frame straightening section of Canpages.ca online directory.You can call 780-447-0109 to do business with Orion Auto Centre Ltd that is near your area.Finally, feel free to share this info with your contacts by using Facebook or Twitter icons.", "company.address": "13220 126 Ave NW Edmonton, AB, T5L 3E1", "company.telephone": "780-447-0109", "company.rating_index": "", "company.latitude": 53.58298899999999775900505483150482177734375, "company.longitude": -113.5546930000000003246896085329353809356689453125, "company.ts": "2018-05-11 02:00:02", "company.company_opne_time_id": {}, "company.company_detail_id": { "159": { "company_detail.id": 159, "company_detail.ts": "2018-05-11 02:00:02", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "785": { "company_detail_value.id": 785, "company_detail_value.ts": "2018-05-11 02:00:02", "company_detail_value.value": "Frame Straightening" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "59": { "company.id": 59, "company.company": "Tristar Collision", "company.description": "", "company.address": "12720 101 St NW Edmonton, AB, T5E 4E5", "company.telephone": "780-472-1544", "company.rating_index": 3.5, "company.latitude": 53.58569299999999913097781245596706867218017578125, "company.longitude": -113.493707000000000562067725695669651031494140625, "company.ts": "2018-05-11 02:00:25", "company.company_opne_time_id": { "191": { "company_opne_time.id": 191, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Monday 7:00 am - 6:00 pm" }, "192": { "company_opne_time.id": 192, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Tuesday 7:00 am - 6:00 pm" }, "193": { "company_opne_time.id": 193, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Wednesday 7:00 am - 6:00 pm" }, "194": { "company_opne_time.id": 194, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Thursday 7:00 am - 6:00 pm" }, "195": { "company_opne_time.id": 195, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Friday 7:00 am - 6:00 pm" }, "196": { "company_opne_time.id": 196, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Saturday 9:00 am - 12:00 pm" }, "197": { "company_opne_time.id": 197, "company_opne_time.ts": "2018-05-11 02:00:25", "company_opne_time.open_time": "Saturday: Estimates Only" } }, "company.company_detail_id": { "160": { "company_detail.id": 160, "company_detail.ts": "2018-05-11 02:00:25", "company_detail.title": "Products and Services", "company_detail.company_detail_value_id": { "786": { "company_detail_value.id": 786, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Paint Sealant" }, "787": { "company_detail_value.id": 787, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Paint Chip Protection" }, "788": { "company_detail_value.id": 788, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Rust Inhibiting" }, "789": { "company_detail_value.id": 789, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Undercoating" }, "790": { "company_detail_value.id": 790, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Vehicle Graphics" }, "791": { "company_detail_value.id": 791, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Laser Controlled Frame And Structure Alignment" }, "792": { "company_detail_value.id": 792, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Collision" }, "793": { "company_detail_value.id": 793, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Downdraft Painting" }, "794": { "company_detail_value.id": 794, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Automotive Collision Repair" }, "795": { "company_detail_value.id": 795, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Collision Repair" } } }, "161": { "company_detail.id": 161, "company_detail.ts": "2018-05-11 02:00:25", "company_detail.title": "Methods of Payment", "company_detail.company_detail_value_id": { "796": { "company_detail_value.id": 796, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Visa" }, "797": { "company_detail_value.id": 797, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "MasterCard" }, "798": { "company_detail_value.id": 798, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Cash" }, "799": { "company_detail_value.id": 799, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Interac" }, "800": { "company_detail_value.id": 800, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "American Express" } } }, "162": { "company_detail.id": 162, "company_detail.ts": "2018-05-11 02:00:25", "company_detail.title": "Getting There", "company_detail.company_detail_value_id": {} }, "163": { "company_detail.id": 163, "company_detail.ts": "2018-05-11 02:00:25", "company_detail.title": "Languages Spoken", "company_detail.company_detail_value_id": { "801": { "company_detail_value.id": 801, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "English" }, "802": { "company_detail_value.id": 802, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "French" }, "803": { "company_detail_value.id": 803, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Chinese" } } }, "164": { "company_detail.id": 164, "company_detail.ts": "2018-05-11 02:00:25", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "804": { "company_detail_value.id": 804, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Automobile Body Repair & Painting" }, "805": { "company_detail_value.id": 805, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "806": { "company_detail_value.id": 806, "company_detail_value.ts": "2018-05-11 02:00:25", "company_detail_value.value": "Frame Straightening" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" }, "60": { "company.id": 60, "company.company": "Southway Inn Of Ottawa", "company.description": "Located in Edmonton, Alberta, Southway Inn Of Ottawa is a company in the automobile wheel alignment, balancing, frame & axle service category of Canpages website.You can call 877-688-4929 to get in touch with Southway Inn Of Ottawa that is in your neighbourhood.Finally, please send this profile page to your friends by accessing Facebook or Twitter links.", "company.address": "Edmonton, AB", "company.telephone": "877-688-4929", "company.rating_index": "", "company.latitude": 53.54613499999999959300112095661461353302001953125, "company.longitude": -113.4912130000000018981154426001012325286865234375, "company.ts": "2018-05-11 02:00:53", "company.company_opne_time_id": {}, "company.company_detail_id": { "165": { "company_detail.id": 165, "company_detail.ts": "2018-05-11 02:00:53", "company_detail.title": "Categories", "company_detail.company_detail_value_id": { "807": { "company_detail_value.id": 807, "company_detail_value.ts": "2018-05-11 02:00:53", "company_detail_value.value": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" } } } }, "city_x_category_industry.id": 3, "city.id": 1, "city.ts": "2018-04-07 03:26:04", "city.city": "Acheson", "state.id": 1, "state.ts": "2018-03-29 03:05:50", "state.state": "Alberta", "category_industry.id": 3, "category_industry.ts": "2018-04-07 06:26:53", "category_industry.category_industry": "Automobile Wheel Alignment, Balancing, Frame & Axle Service" } } } }