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" }, "prev": { "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/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.00396999999999999957089880098237699712626636028289794921875 }, "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": { "101": { "city.id": 101, "city.ts": "2017-10-18 17:49:03", "city.title": "Hartford", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "102": { "city.id": 102, "city.ts": "2017-10-18 17:57:22", "city.title": "Meriden", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "103": { "city.id": 103, "city.ts": "2017-10-18 18:03:42", "city.title": "Middletown", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "104": { "city.id": 104, "city.ts": "2017-10-18 18:12:00", "city.title": "Milford", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "105": { "city.id": 105, "city.ts": "2017-10-18 18:19:09", "city.title": "New Britain", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "106": { "city.id": 106, "city.ts": "2017-10-18 18:26:47", "city.title": "New Haven", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "107": { "city.id": 107, "city.ts": "2017-10-18 18:35:10", "city.title": "Norwalk", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "108": { "city.id": 108, "city.ts": "2017-10-18 18:36:50", "city.title": "Norwich", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "109": { "city.id": 109, "city.ts": "2017-10-18 18:46:00", "city.title": "Shelton", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "110": { "city.id": 110, "city.ts": "2017-10-18 19:04:43", "city.title": "Stamford", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "111": { "city.id": 111, "city.ts": "2017-10-18 19:13:07", "city.title": "Waterbury", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "112": { "city.id": 112, "city.ts": "2017-10-18 19:20:06", "city.title": "West Haven", "city.state": "Connecticut", "state.id": 7, "state.ts": "2017-10-17 02:32:26", "state.title": "Connecticut" }, "113": { "city.id": 113, "city.ts": "2017-10-18 19:21:35", "city.title": "Dover", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "114": { "city.id": 114, "city.ts": "2017-10-18 19:29:55", "city.title": "Elsmere", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "115": { "city.id": 115, "city.ts": "2017-10-18 19:31:06", "city.title": "Georgetown", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "116": { "city.id": 116, "city.ts": "2017-10-18 19:33:12", "city.title": "Middletown", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "117": { "city.id": 117, "city.ts": "2017-10-18 19:34:06", "city.title": "Milford", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "118": { "city.id": 118, "city.ts": "2017-10-18 19:41:13", "city.title": "New Castle", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "119": { "city.id": 119, "city.ts": "2017-10-18 19:48:22", "city.title": "Newark", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "120": { "city.id": 120, "city.ts": "2017-10-18 19:49:34", "city.title": "Seaford", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "121": { "city.id": 121, "city.ts": "2017-10-18 19:50:57", "city.title": "Smyrna", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "122": { "city.id": 122, "city.ts": "2017-10-18 20:07:06", "city.title": "Wilmington", "city.state": "Delaware", "state.id": 8, "state.ts": "2017-10-17 02:32:26", "state.title": "Delaware" }, "123": { "city.id": 123, "city.ts": "2017-10-18 20:17:36", "city.title": "Washington", "city.state": "Dist of Columbia", "state.id": 9, "state.ts": "2017-10-17 02:32:26", "state.title": "Dist of Columbia" }, "124": { "city.id": 124, "city.ts": "2017-10-18 20:22:46", "city.title": "Cape Coral", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "125": { "city.id": 125, "city.ts": "2017-10-18 20:36:00", "city.title": "Clearwater", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "126": { "city.id": 126, "city.ts": "2017-10-18 20:50:38", "city.title": "Coral Springs", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "127": { "city.id": 127, "city.ts": "2017-10-18 21:09:22", "city.title": "Davie", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "128": { "city.id": 128, "city.ts": "2017-10-18 21:11:30", "city.title": "Fort Lauderdale", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "129": { "city.id": 129, "city.ts": "2017-10-18 21:12:52", "city.title": "Gainesville", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "130": { "city.id": 130, "city.ts": "2017-10-18 21:30:27", "city.title": "Hialeah", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "131": { "city.id": 131, "city.ts": "2017-10-18 21:47:24", "city.title": "Hollywood", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "132": { "city.id": 132, "city.ts": "2017-10-18 21:51:53", "city.title": "Jacksonville", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "133": { "city.id": 133, "city.ts": "2017-10-18 21:56:52", "city.title": "Lakeland", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "134": { "city.id": 134, "city.ts": "2017-10-18 22:07:24", "city.title": "Miami", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "135": { "city.id": 135, "city.ts": "2017-10-18 22:17:40", "city.title": "Miami Beach", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "136": { "city.id": 136, "city.ts": "2017-10-18 22:38:46", "city.title": "Miami Gardens", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "137": { "city.id": 137, "city.ts": "2017-10-18 23:01:19", "city.title": "Miramar", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "138": { "city.id": 138, "city.ts": "2017-10-18 23:08:52", "city.title": "Orlando", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "139": { "city.id": 139, "city.ts": "2017-10-18 23:11:29", "city.title": "Palm Bay", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "140": { "city.id": 140, "city.ts": "2017-10-18 23:32:19", "city.title": "Pembroke Pines", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "141": { "city.id": 141, "city.ts": "2017-10-18 23:52:58", "city.title": "Plantation", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "142": { "city.id": 142, "city.ts": "2017-10-19 00:08:18", "city.title": "Pompano Beach", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "143": { "city.id": 143, "city.ts": "2017-10-19 00:12:26", "city.title": "Port St. Lucie", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "144": { "city.id": 144, "city.ts": "2017-10-19 00:17:30", "city.title": "St. Petersburg", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "145": { "city.id": 145, "city.ts": "2017-10-19 00:20:20", "city.title": "Tallahassee", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "146": { "city.id": 146, "city.ts": "2017-10-19 00:26:12", "city.title": "Tampa", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "147": { "city.id": 147, "city.ts": "2017-10-19 00:34:52", "city.title": "West Palm Beach", "city.state": "Florida", "state.id": 10, "state.ts": "2017-10-17 02:32:26", "state.title": "Florida" }, "148": { "city.id": 148, "city.ts": "2017-10-19 00:35:46", "city.title": "Albany", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "149": { "city.id": 149, "city.ts": "2017-10-19 00:58:19", "city.title": "Alpharetta", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "150": { "city.id": 150, "city.ts": "2017-10-19 01:00:34", "city.title": "Athens", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "151": { "city.id": 151, "city.ts": "2017-10-19 01:04:53", "city.title": "Atlanta", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "152": { "city.id": 152, "city.ts": "2017-10-19 01:07:58", "city.title": "Augusta", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "153": { "city.id": 153, "city.ts": "2017-10-19 01:29:44", "city.title": "Brookhaven", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "154": { "city.id": 154, "city.ts": "2017-10-19 01:32:11", "city.title": "Columbus", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "155": { "city.id": 155, "city.ts": "2017-10-19 01:54:03", "city.title": "Dunwoody", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "156": { "city.id": 156, "city.ts": "2017-10-19 02:23:23", "city.title": "Johns Creek", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "157": { "city.id": 157, "city.ts": "2017-10-19 02:25:11", "city.title": "Macon", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "158": { "city.id": 158, "city.ts": "2017-10-19 02:42:08", "city.title": "Marietta", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "159": { "city.id": 159, "city.ts": "2017-10-19 03:03:28", "city.title": "Peachtree Corners", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "160": { "city.id": 160, "city.ts": "2017-10-19 03:24:51", "city.title": "Roswell", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "161": { "city.id": 161, "city.ts": "2017-10-19 03:44:17", "city.title": "Sandy Springs", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "162": { "city.id": 162, "city.ts": "2017-10-19 03:47:02", "city.title": "Savannah", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "163": { "city.id": 163, "city.ts": "2017-10-19 04:07:12", "city.title": "Smyrna", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "164": { "city.id": 164, "city.ts": "2017-10-19 04:08:20", "city.title": "Valdosta", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "165": { "city.id": 165, "city.ts": "2017-10-19 04:10:06", "city.title": "Warner Robins", "city.state": "Georgia", "state.id": 11, "state.ts": "2017-10-17 02:32:26", "state.title": "Georgia" }, "166": { "city.id": 166, "city.ts": "2017-10-19 04:10:37", "city.title": "Hilo", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "167": { "city.id": 167, "city.ts": "2017-10-19 04:16:40", "city.title": "Honolulu", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "168": { "city.id": 168, "city.ts": "2017-10-19 04:17:52", "city.title": "Kahului", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "169": { "city.id": 169, "city.ts": "2017-10-19 04:24:11", "city.title": "Kailua", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "170": { "city.id": 170, "city.ts": "2017-10-19 04:29:56", "city.title": "Kaneohe", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "171": { "city.id": 171, "city.ts": "2017-10-19 04:31:10", "city.title": "Kihei", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "172": { "city.id": 172, "city.ts": "2017-10-19 04:34:22", "city.title": "Mililani Town", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "173": { "city.id": 173, "city.ts": "2017-10-19 04:39:46", "city.title": "Pearl City", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "174": { "city.id": 174, "city.ts": "2017-10-19 04:45:48", "city.title": "Waimalu", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "175": { "city.id": 175, "city.ts": "2017-10-19 04:51:38", "city.title": "Waipahu", "city.state": "Hawaii", "state.id": 12, "state.ts": "2017-10-17 02:32:26", "state.title": "Hawaii" }, "176": { "city.id": 176, "city.ts": "2017-10-19 04:55:15", "city.title": "Boise City", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "177": { "city.id": 177, "city.ts": "2017-10-19 05:00:02", "city.title": "Caldwell", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "178": { "city.id": 178, "city.ts": "2017-10-19 05:01:56", "city.title": "Coeur d'Alene", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "179": { "city.id": 179, "city.ts": "2017-10-19 05:02:56", "city.title": "Idaho Falls", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "180": { "city.id": 180, "city.ts": "2017-10-19 05:03:36", "city.title": "Lewiston", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "181": { "city.id": 181, "city.ts": "2017-10-19 05:07:46", "city.title": "Meridian", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "182": { "city.id": 182, "city.ts": "2017-10-19 05:08:14", "city.title": "Moscow", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "183": { "city.id": 183, "city.ts": "2017-10-19 05:12:44", "city.title": "Nampa", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "184": { "city.id": 184, "city.ts": "2017-10-19 05:13:43", "city.title": "Pocatello", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "185": { "city.id": 185, "city.ts": "2017-10-19 05:15:03", "city.title": "Twin Falls", "city.state": "Idaho", "state.id": 13, "state.ts": "2017-10-17 02:32:26", "state.title": "Idaho" }, "186": { "city.id": 186, "city.ts": "2017-10-19 05:35:28", "city.title": "Arlington Heights", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "187": { "city.id": 187, "city.ts": "2017-10-19 05:42:23", "city.title": "Aurora", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "188": { "city.id": 188, "city.ts": "2017-10-19 06:04:08", "city.title": "Berwyn", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "189": { "city.id": 189, "city.ts": "2017-10-19 06:05:26", "city.title": "Bloomington", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "190": { "city.id": 190, "city.ts": "2017-10-19 06:24:45", "city.title": "Bolingbrook", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "191": { "city.id": 191, "city.ts": "2017-10-19 06:26:22", "city.title": "Champaign", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "192": { "city.id": 192, "city.ts": "2017-10-19 06:37:29", "city.title": "Chicago", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "193": { "city.id": 193, "city.ts": "2017-10-19 06:58:34", "city.title": "Cicero", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "194": { "city.id": 194, "city.ts": "2017-10-19 06:59:29", "city.title": "Decatur", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "195": { "city.id": 195, "city.ts": "2017-10-19 07:20:42", "city.title": "Des Plaines", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "196": { "city.id": 196, "city.ts": "2017-10-19 07:27:48", "city.title": "Elgin", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "197": { "city.id": 197, "city.ts": "2017-10-19 07:48:47", "city.title": "Evanston", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "198": { "city.id": 198, "city.ts": "2017-10-19 07:58:57", "city.title": "Joliet", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "199": { "city.id": 199, "city.ts": "2017-10-19 08:20:59", "city.title": "Naperville", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" }, "200": { "city.id": 200, "city.ts": "2017-10-19 08:42:07", "city.title": "Oak Lawn", "city.state": "Illinois", "state.id": 14, "state.ts": "2017-10-17 02:32:26", "state.title": "Illinois" } } } }