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": "Auto Repair Shops", "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_4db7936df78dfe468fc2/auto_repair_shops/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shops/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shops/by_table/city/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.001170000000000000033029134982598407077603042125701904296875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 741, "pages_total": 8 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city.id": 1, "city.ts": "2017-10-18 03:49:28", "city.title": "North Birmingham", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "2": { "city.id": 2, "city.ts": "2017-10-18 03:56:04", "city.title": "Mountain Brook", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "3": { "city.id": 3, "city.ts": "2017-10-18 04:00:27", "city.title": "Tarrant", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "4": { "city.id": 4, "city.ts": "2017-10-18 04:07:34", "city.title": "Homewood", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "5": { "city.id": 5, "city.ts": "2017-10-18 04:14:10", "city.title": "Irondale", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "6": { "city.id": 6, "city.ts": "2017-10-18 04:20:33", "city.title": "Vestavia", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "7": { "city.id": 7, "city.ts": "2017-10-18 04:25:41", "city.title": "Forestdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "8": { "city.id": 8, "city.ts": "2017-10-18 04:29:24", "city.title": "Fultondale", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 02:32:26", "state.title": "Alabama" }, "9": { "city.id": 9, "city.ts": "2017-10-18 04:31:37", "city.title": "Anchorage", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "10": { "city.id": 10, "city.ts": "2017-10-18 04:31:49", "city.title": "Barrow", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "11": { "city.id": 11, "city.ts": "2017-10-18 04:31:55", "city.title": "Bethel", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "12": { "city.id": 12, "city.ts": "2017-10-18 04:32:41", "city.title": "Fairbanks", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "13": { "city.id": 13, "city.ts": "2017-10-18 04:33:00", "city.title": "Juneau", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "14": { "city.id": 14, "city.ts": "2017-10-18 04:33:19", "city.title": "Kenai", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "15": { "city.id": 15, "city.ts": "2017-10-18 04:33:24", "city.title": "Ketchikan", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "16": { "city.id": 16, "city.ts": "2017-10-18 04:33:32", "city.title": "Kodiak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "17": { "city.id": 17, "city.ts": "2017-10-18 04:33:41", "city.title": "Sitka", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "18": { "city.id": 18, "city.ts": "2017-10-18 04:34:26", "city.title": "Wasilla", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 02:32:26", "state.title": "Alaska" }, "19": { "city.id": 19, "city.ts": "2017-10-18 04:53:57", "city.title": "Avondale", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "20": { "city.id": 20, "city.ts": "2017-10-18 04:54:19", "city.title": "Buckeye", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "21": { "city.id": 21, "city.ts": "2017-10-18 04:55:36", "city.title": "Bullhead City", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "22": { "city.id": 22, "city.ts": "2017-10-18 04:56:40", "city.title": "Casa Grande", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "23": { "city.id": 23, "city.ts": "2017-10-18 05:00:31", "city.title": "Chandler", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "24": { "city.id": 24, "city.ts": "2017-10-18 05:01:25", "city.title": "Flagstaff", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "25": { "city.id": 25, "city.ts": "2017-10-18 05:14:19", "city.title": "Gilbert", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "26": { "city.id": 26, "city.ts": "2017-10-18 05:24:38", "city.title": "Glendale", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "27": { "city.id": 27, "city.ts": "2017-10-18 05:43:54", "city.title": "Goodyear", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "28": { "city.id": 28, "city.ts": "2017-10-18 05:45:00", "city.title": "Lake Havasu City", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "29": { "city.id": 29, "city.ts": "2017-10-18 05:46:35", "city.title": "Marana", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "30": { "city.id": 30, "city.ts": "2017-10-18 05:48:43", "city.title": "Maricopa", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "31": { "city.id": 31, "city.ts": "2017-10-18 05:59:58", "city.title": "Mesa", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "32": { "city.id": 32, "city.ts": "2017-10-18 06:03:58", "city.title": "Oro Valley", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "33": { "city.id": 33, "city.ts": "2017-10-18 06:19:41", "city.title": "Peoria", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "34": { "city.id": 34, "city.ts": "2017-10-18 06:33:03", "city.title": "Phoenix", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "35": { "city.id": 35, "city.ts": "2017-10-18 06:34:41", "city.title": "Prescott", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "36": { "city.id": 36, "city.ts": "2017-10-18 06:36:26", "city.title": "Prescott Valley", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "37": { "city.id": 37, "city.ts": "2017-10-18 06:41:59", "city.title": "Scottsdale", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "38": { "city.id": 38, "city.ts": "2017-10-18 06:42:30", "city.title": "Sierra Vista", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "39": { "city.id": 39, "city.ts": "2017-10-18 06:58:35", "city.title": "Surprise", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "40": { "city.id": 40, "city.ts": "2017-10-18 07:22:24", "city.title": "Tempe", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "41": { "city.id": 41, "city.ts": "2017-10-18 07:29:37", "city.title": "Tucson", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "42": { "city.id": 42, "city.ts": "2017-10-18 07:31:00", "city.title": "Yuma", "city.state": "Arizona", "state.id": 3, "state.ts": "2017-10-17 02:32:26", "state.title": "Arizona" }, "43": { "city.id": 43, "city.ts": "2017-10-18 07:33:32", "city.title": "Bentonville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "44": { "city.id": 44, "city.ts": "2017-10-18 07:34:53", "city.title": "Conway", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "45": { "city.id": 45, "city.ts": "2017-10-18 07:36:40", "city.title": "Fayetteville", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "46": { "city.id": 46, "city.ts": "2017-10-18 07:36:43", "city.title": "Fort Smith", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "47": { "city.id": 47, "city.ts": "2017-10-18 07:37:51", "city.title": "Jonesboro", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "48": { "city.id": 48, "city.ts": "2017-10-18 07:42:09", "city.title": "Little Rock", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "49": { "city.id": 49, "city.ts": "2017-10-18 07:46:01", "city.title": "North Little Rock", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "50": { "city.id": 50, "city.ts": "2017-10-18 07:46:30", "city.title": "Pine Bluff", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "51": { "city.id": 51, "city.ts": "2017-10-18 07:49:19", "city.title": "Rogers", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "52": { "city.id": 52, "city.ts": "2017-10-18 07:51:31", "city.title": "Springdale", "city.state": "Arkansas", "state.id": 4, "state.ts": "2017-10-17 02:32:26", "state.title": "Arkansas" }, "53": { "city.id": 53, "city.ts": "2017-10-18 08:15:42", "city.title": "Anaheim", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "54": { "city.id": 54, "city.ts": "2017-10-18 08:20:14", "city.title": "Bakersfield", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "55": { "city.id": 55, "city.ts": "2017-10-18 08:33:44", "city.title": "Chula Vista", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "56": { "city.id": 56, "city.ts": "2017-10-18 08:53:51", "city.title": "Fontana", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "57": { "city.id": 57, "city.ts": "2017-10-18 09:14:47", "city.title": "Fremont", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "58": { "city.id": 58, "city.ts": "2017-10-18 09:19:12", "city.title": "Fresno", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "59": { "city.id": 59, "city.ts": "2017-10-18 09:40:21", "city.title": "Glendale", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "60": { "city.id": 60, "city.ts": "2017-10-18 10:03:47", "city.title": "Huntington Beach", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "61": { "city.id": 61, "city.ts": "2017-10-18 10:27:23", "city.title": "Irvine", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "62": { "city.id": 62, "city.ts": "2017-10-18 10:41:45", "city.title": "Long Beach", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "63": { "city.id": 63, "city.ts": "2017-10-18 11:10:46", "city.title": "Los Angeles", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "64": { "city.id": 64, "city.ts": "2017-10-18 11:16:49", "city.title": "Modesto", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "65": { "city.id": 65, "city.ts": "2017-10-18 11:29:11", "city.title": "Moreno Valley", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "66": { "city.id": 66, "city.ts": "2017-10-18 11:38:19", "city.title": "Oakland", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "67": { "city.id": 67, "city.ts": "2017-10-18 11:46:05", "city.title": "Oxnard", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "68": { "city.id": 68, "city.ts": "2017-10-18 11:51:16", "city.title": "Riverside", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "69": { "city.id": 69, "city.ts": "2017-10-18 11:58:13", "city.title": "Sacramento", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "70": { "city.id": 70, "city.ts": "2017-10-18 12:08:58", "city.title": "San Bernardino", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "71": { "city.id": 71, "city.ts": "2017-10-18 12:20:55", "city.title": "San Diego", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "72": { "city.id": 72, "city.ts": "2017-10-18 12:28:02", "city.title": "San Francisco", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "73": { "city.id": 73, "city.ts": "2017-10-18 12:44:12", "city.title": "San Jose", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "74": { "city.id": 74, "city.ts": "2017-10-18 13:06:13", "city.title": "Santa Ana", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "75": { "city.id": 75, "city.ts": "2017-10-18 13:26:43", "city.title": "Santa Clarita", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "76": { "city.id": 76, "city.ts": "2017-10-18 13:29:29", "city.title": "Stockton", "city.state": "California", "state.id": 5, "state.ts": "2017-10-17 02:32:26", "state.title": "California" }, "77": { "city.id": 77, "city.ts": "2017-10-18 13:50:47", "city.title": "Arvada", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "78": { "city.id": 78, "city.ts": "2017-10-18 14:01:16", "city.title": "Aurora", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "79": { "city.id": 79, "city.ts": "2017-10-18 14:06:46", "city.title": "Boulder", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "80": { "city.id": 80, "city.ts": "2017-10-18 14:16:19", "city.title": "Broomfield", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "81": { "city.id": 81, "city.ts": "2017-10-18 14:23:50", "city.title": "Castle Rock", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "82": { "city.id": 82, "city.ts": "2017-10-18 14:46:03", "city.title": "Centennial", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "83": { "city.id": 83, "city.ts": "2017-10-18 14:50:41", "city.title": "Colorado Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "84": { "city.id": 84, "city.ts": "2017-10-18 15:11:26", "city.title": "Commerce City", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "85": { "city.id": 85, "city.ts": "2017-10-18 15:23:07", "city.title": "Denver", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "86": { "city.id": 86, "city.ts": "2017-10-18 15:24:08", "city.title": "Fort Collins", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "87": { "city.id": 87, "city.ts": "2017-10-18 15:26:07", "city.title": "Grand Junction", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "88": { "city.id": 88, "city.ts": "2017-10-18 15:27:44", "city.title": "Greeley", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "89": { "city.id": 89, "city.ts": "2017-10-18 15:49:48", "city.title": "Lakewood", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "90": { "city.id": 90, "city.ts": "2017-10-18 16:12:06", "city.title": "Littleton", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "91": { "city.id": 91, "city.ts": "2017-10-18 16:14:57", "city.title": "Longmont", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "92": { "city.id": 92, "city.ts": "2017-10-18 16:19:33", "city.title": "Loveland", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "93": { "city.id": 93, "city.ts": "2017-10-18 16:29:32", "city.title": "Northglenn", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "94": { "city.id": 94, "city.ts": "2017-10-18 16:31:57", "city.title": "Parker", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "95": { "city.id": 95, "city.ts": "2017-10-18 16:33:14", "city.title": "Pueblo", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "96": { "city.id": 96, "city.ts": "2017-10-18 16:56:40", "city.title": "Thornton", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "97": { "city.id": 97, "city.ts": "2017-10-18 17:19:23", "city.title": "Westminster", "city.state": "Colorado", "state.id": 6, "state.ts": "2017-10-17 02:32:26", "state.title": "Colorado" }, "98": { "city.id": 98, "city.ts": "2017-10-18 17:27:52", "city.title": "Bridgeport", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "99": { "city.id": 99, "city.ts": "2017-10-18 17:36:17", "city.title": "Bristol", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "100": { "city.id": 100, "city.ts": "2017-10-18 17:41:59", "city.title": "Danbury", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" } } } }