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": "Canada Yellowpage Information 1", "desc": "Canada Yellowpage Information Data set(Title, Website, Telephone Number, Latitude & Longitude)", "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/canada_yellowpage_information_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/canada_yellowpage_information_1/by_table/category_1/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/canada_yellowpage_information_1/by_table/category_1/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/canada_yellowpage_information_1/by_table/category_1/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.00158000000000000002421673972463622703799046576023101806640625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 20727, "pages_total": 208 }, "struct": { "stem": { "0": "category_1" }, "leaf": "category_1.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "101": { "category_1.id": 101, "category_1.ts": "2023-01-04 12:37:34", "category_1.category_industry": "Real-Estate & Insurance", "category_1.city": "Ardrossan", "category_1.state": "Alberta" }, "102": { "category_1.id": 102, "category_1.ts": "2023-01-04 12:37:34", "category_1.category_industry": "Shopping & Specialty Stores", "category_1.city": "Ardrossan", "category_1.state": "Alberta" }, "103": { "category_1.id": 103, "category_1.ts": "2023-01-04 12:37:34", "category_1.category_industry": "Sports & Recreation", "category_1.city": "Ardrossan", "category_1.state": "Alberta" }, "104": { "category_1.id": 104, "category_1.ts": "2023-01-04 12:37:34", "category_1.category_industry": "Transportation", "category_1.city": "Ardrossan", "category_1.state": "Alberta" }, "105": { "category_1.id": 105, "category_1.ts": "2023-01-04 12:37:34", "category_1.category_industry": "Travel & Lodging", "category_1.city": "Ardrossan", "category_1.state": "Alberta" }, "106": { "category_1.id": 106, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Agriculture, fishing & Forestry", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "107": { "category_1.id": 107, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Apparel & Accessories", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "108": { "category_1.id": 108, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Automotive", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "109": { "category_1.id": 109, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Business & Professional Services", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "110": { "category_1.id": 110, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Computers, Communications & Electronics", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "111": { "category_1.id": 111, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Construction & Renovation", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "112": { "category_1.id": 112, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Education", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "113": { "category_1.id": 113, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Entertainment & Media", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "114": { "category_1.id": 114, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Family & Community", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "115": { "category_1.id": 115, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Finance & Legal", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "116": { "category_1.id": 116, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Food & Beverages", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "117": { "category_1.id": 117, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Health & Medicine", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "118": { "category_1.id": 118, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Home & Garden", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "119": { "category_1.id": 119, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Industrial supplies & services", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "120": { "category_1.id": 120, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Personal Care", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "121": { "category_1.id": 121, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Public utilities & environment", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "122": { "category_1.id": 122, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Real-Estate & Insurance", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "123": { "category_1.id": 123, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Shopping & Specialty Stores", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "124": { "category_1.id": 124, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Sports & Recreation", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "125": { "category_1.id": 125, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Transportation", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "126": { "category_1.id": 126, "category_1.ts": "2023-01-04 12:37:41", "category_1.category_industry": "Travel & Lodging", "category_1.city": "Athabasca", "category_1.state": "Alberta" }, "127": { "category_1.id": 127, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Agriculture, fishing & Forestry", "category_1.city": "Banff", "category_1.state": "Alberta" }, "128": { "category_1.id": 128, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Apparel & Accessories", "category_1.city": "Banff", "category_1.state": "Alberta" }, "129": { "category_1.id": 129, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Automotive", "category_1.city": "Banff", "category_1.state": "Alberta" }, "130": { "category_1.id": 130, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Business & Professional Services", "category_1.city": "Banff", "category_1.state": "Alberta" }, "131": { "category_1.id": 131, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Computers, Communications & Electronics", "category_1.city": "Banff", "category_1.state": "Alberta" }, "132": { "category_1.id": 132, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Construction & Renovation", "category_1.city": "Banff", "category_1.state": "Alberta" }, "133": { "category_1.id": 133, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Education", "category_1.city": "Banff", "category_1.state": "Alberta" }, "134": { "category_1.id": 134, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Entertainment & Media", "category_1.city": "Banff", "category_1.state": "Alberta" }, "135": { "category_1.id": 135, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Family & Community", "category_1.city": "Banff", "category_1.state": "Alberta" }, "136": { "category_1.id": 136, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Finance & Legal", "category_1.city": "Banff", "category_1.state": "Alberta" }, "137": { "category_1.id": 137, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Food & Beverages", "category_1.city": "Banff", "category_1.state": "Alberta" }, "138": { "category_1.id": 138, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Health & Medicine", "category_1.city": "Banff", "category_1.state": "Alberta" }, "139": { "category_1.id": 139, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Home & Garden", "category_1.city": "Banff", "category_1.state": "Alberta" }, "140": { "category_1.id": 140, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Industrial supplies & services", "category_1.city": "Banff", "category_1.state": "Alberta" }, "141": { "category_1.id": 141, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Personal Care", "category_1.city": "Banff", "category_1.state": "Alberta" }, "142": { "category_1.id": 142, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Public utilities & environment", "category_1.city": "Banff", "category_1.state": "Alberta" }, "143": { "category_1.id": 143, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Real-Estate & Insurance", "category_1.city": "Banff", "category_1.state": "Alberta" }, "144": { "category_1.id": 144, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Shopping & Specialty Stores", "category_1.city": "Banff", "category_1.state": "Alberta" }, "145": { "category_1.id": 145, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Sports & Recreation", "category_1.city": "Banff", "category_1.state": "Alberta" }, "146": { "category_1.id": 146, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Transportation", "category_1.city": "Banff", "category_1.state": "Alberta" }, "147": { "category_1.id": 147, "category_1.ts": "2023-01-04 12:38:58", "category_1.category_industry": "Travel & Lodging", "category_1.city": "Banff", "category_1.state": "Alberta" }, "148": { "category_1.id": 148, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Agriculture, fishing & Forestry", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "149": { "category_1.id": 149, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Apparel & Accessories", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "150": { "category_1.id": 150, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Automotive", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "151": { "category_1.id": 151, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Business & Professional Services", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "152": { "category_1.id": 152, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Computers, Communications & Electronics", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "153": { "category_1.id": 153, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Construction & Renovation", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "154": { "category_1.id": 154, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Education", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "155": { "category_1.id": 155, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Entertainment & Media", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "156": { "category_1.id": 156, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Family & Community", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "157": { "category_1.id": 157, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Finance & Legal", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "158": { "category_1.id": 158, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Food & Beverages", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "159": { "category_1.id": 159, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Health & Medicine", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "160": { "category_1.id": 160, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Home & Garden", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "161": { "category_1.id": 161, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Industrial supplies & services", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "162": { "category_1.id": 162, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Personal Care", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "163": { "category_1.id": 163, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Public utilities & environment", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "164": { "category_1.id": 164, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Real-Estate & Insurance", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "165": { "category_1.id": 165, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Shopping & Specialty Stores", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "166": { "category_1.id": 166, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Sports & Recreation", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "167": { "category_1.id": 167, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Transportation", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "168": { "category_1.id": 168, "category_1.ts": "2023-01-04 12:39:03", "category_1.category_industry": "Travel & Lodging", "category_1.city": "Barrhead", "category_1.state": "Alberta" }, "169": { "category_1.id": 169, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Agriculture, fishing & Forestry", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "170": { "category_1.id": 170, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Apparel & Accessories", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "171": { "category_1.id": 171, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Automotive", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "172": { "category_1.id": 172, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Business & Professional Services", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "173": { "category_1.id": 173, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Computers, Communications & Electronics", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "174": { "category_1.id": 174, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Construction & Renovation", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "175": { "category_1.id": 175, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Education", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "176": { "category_1.id": 176, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Entertainment & Media", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "177": { "category_1.id": 177, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Family & Community", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "178": { "category_1.id": 178, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Finance & Legal", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "179": { "category_1.id": 179, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Food & Beverages", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "180": { "category_1.id": 180, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Health & Medicine", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "181": { "category_1.id": 181, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Home & Garden", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "182": { "category_1.id": 182, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Industrial supplies & services", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "183": { "category_1.id": 183, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Personal Care", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "184": { "category_1.id": 184, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Public utilities & environment", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "185": { "category_1.id": 185, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Real-Estate & Insurance", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "186": { "category_1.id": 186, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Shopping & Specialty Stores", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "187": { "category_1.id": 187, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Sports & Recreation", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "188": { "category_1.id": 188, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Transportation", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "189": { "category_1.id": 189, "category_1.ts": "2023-01-04 12:39:08", "category_1.category_industry": "Travel & Lodging", "category_1.city": "Bashaw", "category_1.state": "Alberta" }, "190": { "category_1.id": 190, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Agriculture, fishing & Forestry", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "191": { "category_1.id": 191, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Apparel & Accessories", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "192": { "category_1.id": 192, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Automotive", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "193": { "category_1.id": 193, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Business & Professional Services", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "194": { "category_1.id": 194, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Computers, Communications & Electronics", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "195": { "category_1.id": 195, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Construction & Renovation", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "196": { "category_1.id": 196, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Education", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "197": { "category_1.id": 197, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Entertainment & Media", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "198": { "category_1.id": 198, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Family & Community", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "199": { "category_1.id": 199, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Finance & Legal", "category_1.city": "Beaumont", "category_1.state": "Alberta" }, "200": { "category_1.id": 200, "category_1.ts": "2023-01-04 12:39:45", "category_1.category_industry": "Food & Beverages", "category_1.city": "Beaumont", "category_1.state": "Alberta" } } } }