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 1", "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_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shops_1/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shops_1/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/auto_repair_shops_1/by_table/city/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.00128000000000000010470790900996007621870376169681549072265625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 6766, "pages_total": 68 }, "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-17 05:24:03", "city.title": "Piedmont", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "102": { "city.id": 102, "city.ts": "2017-10-18 23:12:07", "city.title": "Pinson", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "103": { "city.id": 103, "city.ts": "2017-10-18 23:13:40", "city.title": "Pleasant Grove", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "104": { "city.id": 104, "city.ts": "2017-10-18 23:14:14", "city.title": "Prattville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "105": { "city.id": 105, "city.ts": "2017-10-18 23:14:31", "city.title": "Rainbow City", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "106": { "city.id": 106, "city.ts": "2017-10-18 23:14:50", "city.title": "Rainsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "107": { "city.id": 107, "city.ts": "2017-10-17 05:24:03", "city.title": "Roanoke", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "108": { "city.id": 108, "city.ts": "2017-10-17 05:24:03", "city.title": "Robertsdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "109": { "city.id": 109, "city.ts": "2017-10-17 05:24:03", "city.title": "Rogersville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "110": { "city.id": 110, "city.ts": "2017-10-17 05:24:03", "city.title": "Russellville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "111": { "city.id": 111, "city.ts": "2017-10-17 05:24:03", "city.title": "Salem", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "112": { "city.id": 112, "city.ts": "2017-10-18 23:15:07", "city.title": "Saraland", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "113": { "city.id": 113, "city.ts": "2017-10-17 05:24:03", "city.title": "Scottsboro", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "114": { "city.id": 114, "city.ts": "2017-10-18 23:15:43", "city.title": "Selma", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "115": { "city.id": 115, "city.ts": "2017-10-18 23:16:14", "city.title": "Semmes", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "116": { "city.id": 116, "city.ts": "2017-10-18 23:16:46", "city.title": "Sheffield", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "117": { "city.id": 117, "city.ts": "2017-10-17 05:24:03", "city.title": "Slocomb", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "118": { "city.id": 118, "city.ts": "2017-10-17 05:24:03", "city.title": "Smiths Station", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "119": { "city.id": 119, "city.ts": "2017-10-17 05:24:03", "city.title": "Somerville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "120": { "city.id": 120, "city.ts": "2017-10-18 23:17:19", "city.title": "Spanish Fort", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "121": { "city.id": 121, "city.ts": "2017-10-17 05:24:03", "city.title": "Springville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "122": { "city.id": 122, "city.ts": "2017-10-18 23:17:59", "city.title": "Sylacauga", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "123": { "city.id": 123, "city.ts": "2017-10-18 23:18:22", "city.title": "Talladega", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "124": { "city.id": 124, "city.ts": "2017-10-17 05:24:03", "city.title": "Tallassee", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "125": { "city.id": 125, "city.ts": "2017-10-18 23:18:51", "city.title": "Theodore", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "126": { "city.id": 126, "city.ts": "2017-10-17 05:24:03", "city.title": "Thomasville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "127": { "city.id": 127, "city.ts": "2017-10-17 05:24:03", "city.title": "Toney", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "128": { "city.id": 128, "city.ts": "2017-10-17 05:24:03", "city.title": "Trinity", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "129": { "city.id": 129, "city.ts": "2017-10-17 05:24:03", "city.title": "Troy", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "130": { "city.id": 130, "city.ts": "2017-10-18 23:19:20", "city.title": "Trussville", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "131": { "city.id": 131, "city.ts": "2017-10-18 23:19:43", "city.title": "Tuscaloosa", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "132": { "city.id": 132, "city.ts": "2017-10-18 23:20:00", "city.title": "Tuscumbia", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "133": { "city.id": 133, "city.ts": "2017-10-17 05:24:03", "city.title": "Tuskegee", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "134": { "city.id": 134, "city.ts": "2017-10-17 05:24:03", "city.title": "Union Springs", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "135": { "city.id": 135, "city.ts": "2017-10-18 23:20:11", "city.title": "Valley", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "136": { "city.id": 136, "city.ts": "2017-10-17 05:24:03", "city.title": "Vinemont", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "137": { "city.id": 137, "city.ts": "2017-10-17 05:24:03", "city.title": "Warrior", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "138": { "city.id": 138, "city.ts": "2017-10-18 23:20:33", "city.title": "Wetumpka", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "139": { "city.id": 139, "city.ts": "2017-10-17 05:24:03", "city.title": "Wilmer", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "140": { "city.id": 140, "city.ts": "2017-10-17 05:24:03", "city.title": "Winfield", "city.state": "Alabama", "state.id": 1, "state.ts": "2017-10-17 05:21:31", "state.title": "Alabama" }, "141": { "city.id": 141, "city.ts": "2017-10-17 05:24:08", "city.title": "Adak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "142": { "city.id": 142, "city.ts": "2017-10-17 05:24:08", "city.title": "Akiachak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "143": { "city.id": 143, "city.ts": "2017-10-17 05:24:08", "city.title": "Akiak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "144": { "city.id": 144, "city.ts": "2017-10-17 05:24:08", "city.title": "Akutan", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "145": { "city.id": 145, "city.ts": "2017-10-17 05:24:08", "city.title": "Alakanuk", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "146": { "city.id": 146, "city.ts": "2017-10-17 05:24:08", "city.title": "Ambler", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "147": { "city.id": 147, "city.ts": "2017-10-17 05:24:08", "city.title": "Anaktuvuk Pass", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "148": { "city.id": 148, "city.ts": "2017-10-17 05:24:08", "city.title": "Anchor Point", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "149": { "city.id": 149, "city.ts": "2017-10-17 05:24:08", "city.title": "Anchorage", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "150": { "city.id": 150, "city.ts": "2017-10-17 05:24:08", "city.title": "Angoon", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "151": { "city.id": 151, "city.ts": "2017-10-17 05:24:08", "city.title": "Aniak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "152": { "city.id": 152, "city.ts": "2017-10-17 05:24:08", "city.title": "Atqasuk", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "153": { "city.id": 153, "city.ts": "2017-10-17 05:24:08", "city.title": "Barrow", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "154": { "city.id": 154, "city.ts": "2017-10-17 05:24:08", "city.title": "Bethel", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "155": { "city.id": 155, "city.ts": "2017-10-17 05:24:08", "city.title": "Big Lake", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "156": { "city.id": 156, "city.ts": "2017-10-17 05:24:08", "city.title": "Brevig Mission", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "157": { "city.id": 157, "city.ts": "2017-10-17 05:24:08", "city.title": "Buckland", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "158": { "city.id": 158, "city.ts": "2017-10-17 05:24:08", "city.title": "Chefornak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "159": { "city.id": 159, "city.ts": "2017-10-17 05:24:08", "city.title": "Chevak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "160": { "city.id": 160, "city.ts": "2017-10-17 05:24:08", "city.title": "Chugiak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "161": { "city.id": 161, "city.ts": "2017-10-17 05:24:08", "city.title": "Clam Gulch", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "162": { "city.id": 162, "city.ts": "2017-10-17 05:24:08", "city.title": "Cooper Landing", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "163": { "city.id": 163, "city.ts": "2017-10-17 05:24:08", "city.title": "Copper Center", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "164": { "city.id": 164, "city.ts": "2017-10-17 05:24:08", "city.title": "Cordova", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "165": { "city.id": 165, "city.ts": "2017-10-17 05:24:08", "city.title": "Craig", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "166": { "city.id": 166, "city.ts": "2017-10-17 05:24:08", "city.title": "Delta Junction", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "167": { "city.id": 167, "city.ts": "2017-10-17 05:24:08", "city.title": "Dillingham", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "168": { "city.id": 168, "city.ts": "2017-10-17 05:24:08", "city.title": "Douglas", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "169": { "city.id": 169, "city.ts": "2017-10-17 05:24:08", "city.title": "Eagle River", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "170": { "city.id": 170, "city.ts": "2017-10-17 05:24:08", "city.title": "Eek", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "171": { "city.id": 171, "city.ts": "2017-10-17 05:24:08", "city.title": "Eielson Afb", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "172": { "city.id": 172, "city.ts": "2017-10-17 05:24:08", "city.title": "Elim", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "173": { "city.id": 173, "city.ts": "2017-10-17 05:24:08", "city.title": "Emmonak", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "174": { "city.id": 174, "city.ts": "2017-10-17 05:24:08", "city.title": "Fairbanks", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "175": { "city.id": 175, "city.ts": "2017-10-18 23:20:55", "city.title": "Fort Wainwright", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "176": { "city.id": 176, "city.ts": "2017-10-17 05:24:08", "city.title": "Fort Yukon", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "177": { "city.id": 177, "city.ts": "2017-10-17 05:24:08", "city.title": "Gakona", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "178": { "city.id": 178, "city.ts": "2017-10-17 05:24:08", "city.title": "Galena", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "179": { "city.id": 179, "city.ts": "2017-10-17 05:24:08", "city.title": "Gambell", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "180": { "city.id": 180, "city.ts": "2017-10-17 05:24:08", "city.title": "Girdwood", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "181": { "city.id": 181, "city.ts": "2017-10-17 05:24:08", "city.title": "Glennallen", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "182": { "city.id": 182, "city.ts": "2017-10-17 05:24:08", "city.title": "Goodnews Bay", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "183": { "city.id": 183, "city.ts": "2017-10-17 05:24:08", "city.title": "Gustavus", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "184": { "city.id": 184, "city.ts": "2017-10-17 05:24:08", "city.title": "Haines", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "185": { "city.id": 185, "city.ts": "2017-10-17 05:24:08", "city.title": "Healy", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "186": { "city.id": 186, "city.ts": "2017-10-17 05:24:08", "city.title": "Homer", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "187": { "city.id": 187, "city.ts": "2017-10-17 05:24:08", "city.title": "Hoonah", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "188": { "city.id": 188, "city.ts": "2017-10-17 05:24:08", "city.title": "Hooper Bay", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "189": { "city.id": 189, "city.ts": "2017-10-17 05:24:08", "city.title": "Houston", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "190": { "city.id": 190, "city.ts": "2017-10-17 05:24:08", "city.title": "Huslia", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "191": { "city.id": 191, "city.ts": "2017-10-17 05:24:08", "city.title": "Hydaburg", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "192": { "city.id": 192, "city.ts": "2017-10-17 05:24:08", "city.title": "Iliamna", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "193": { "city.id": 193, "city.ts": "2017-10-17 05:24:08", "city.title": "Indian", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "194": { "city.id": 194, "city.ts": "2017-10-18 23:21:41", "city.title": "Jber", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "195": { "city.id": 195, "city.ts": "2017-10-17 05:24:08", "city.title": "Juneau", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "196": { "city.id": 196, "city.ts": "2017-10-17 05:24:08", "city.title": "Kake", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "197": { "city.id": 197, "city.ts": "2017-10-17 05:24:08", "city.title": "Kaktovik", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "198": { "city.id": 198, "city.ts": "2017-10-17 05:24:08", "city.title": "Kasigluk", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "199": { "city.id": 199, "city.ts": "2017-10-17 05:24:08", "city.title": "Kasilof", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" }, "200": { "city.id": 200, "city.ts": "2017-10-17 05:24:08", "city.title": "Kenai", "city.state": "Alaska", "state.id": 2, "state.ts": "2017-10-17 05:21:31", "state.title": "Alaska" } } } }