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": "US Auto Parts Store Information 1", "desc": "US Auto Parts Store Information Data Set", "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/us_auto_parts_store_information_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/by_table/region/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/by_table/region/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/by_table/region/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.00120999999999999992110477631257481334614567458629608154296875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2923, "pages_total": 30 }, "struct": { "stem": { "0": "region", "1": "state" }, "leaf": "region.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "101": { "region.id": 101, "region.ts": "2018-05-27 23:13:43", "region.region": "Searcy", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "102": { "region.id": 102, "region.ts": "2018-05-27 23:13:43", "region.region": "Springdale", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "103": { "region.id": 103, "region.ts": "2018-05-27 23:13:43", "region.region": "Texarkana", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "104": { "region.id": 104, "region.ts": "2018-05-27 23:13:43", "region.region": "Van Buren", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "105": { "region.id": 105, "region.ts": "2018-05-27 23:13:43", "region.region": "West Memphis", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "106": { "region.id": 106, "region.ts": "2018-05-27 23:13:55", "region.region": "Chandler", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "107": { "region.id": 107, "region.ts": "2018-05-27 23:13:55", "region.region": "Glendale", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "108": { "region.id": 108, "region.ts": "2018-05-27 23:13:55", "region.region": "Mesa", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "109": { "region.id": 109, "region.ts": "2018-05-27 23:13:55", "region.region": "Phoenix", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "110": { "region.id": 110, "region.ts": "2018-05-27 23:13:55", "region.region": "Prescott Valley", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "111": { "region.id": 111, "region.ts": "2018-05-27 23:13:55", "region.region": "Scottsdale", "state.id": 3, "state.ts": "2018-05-25 02:15:49", "state.state": "Arizona" }, "112": { "region.id": 112, "region.ts": "2018-05-27 23:13:58", "region.region": "Arvada", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "113": { "region.id": 113, "region.ts": "2018-05-27 23:13:58", "region.region": "Aurora", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "114": { "region.id": 114, "region.ts": "2018-05-27 23:13:58", "region.region": "Boulder", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "115": { "region.id": 115, "region.ts": "2018-05-27 23:13:58", "region.region": "Brighton", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "116": { "region.id": 116, "region.ts": "2018-05-27 23:13:58", "region.region": "Broomfield", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "117": { "region.id": 117, "region.ts": "2018-05-27 23:13:58", "region.region": "Burlington", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "118": { "region.id": 118, "region.ts": "2018-05-27 23:13:58", "region.region": "Castle Rock", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "119": { "region.id": 119, "region.ts": "2018-05-27 23:13:58", "region.region": "Centennial", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "120": { "region.id": 120, "region.ts": "2018-05-27 23:13:58", "region.region": "Colorado Springs", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "121": { "region.id": 121, "region.ts": "2018-05-27 23:13:58", "region.region": "Commerce City", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "122": { "region.id": 122, "region.ts": "2018-05-27 23:13:58", "region.region": "Delta", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "123": { "region.id": 123, "region.ts": "2018-05-27 23:13:58", "region.region": "Denver", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "124": { "region.id": 124, "region.ts": "2018-05-27 23:13:58", "region.region": "Englewood", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "125": { "region.id": 125, "region.ts": "2018-05-27 23:13:58", "region.region": "Federal Heights", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "126": { "region.id": 126, "region.ts": "2018-05-27 23:13:58", "region.region": "Fort Collins", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "127": { "region.id": 127, "region.ts": "2018-05-27 23:13:58", "region.region": "Fountain", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "128": { "region.id": 128, "region.ts": "2018-05-27 23:13:58", "region.region": "Golden", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "129": { "region.id": 129, "region.ts": "2018-05-27 23:13:58", "region.region": "Grand Junction", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "130": { "region.id": 130, "region.ts": "2018-05-27 23:13:58", "region.region": "Greeley", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "131": { "region.id": 131, "region.ts": "2018-05-27 23:13:58", "region.region": "Greenwood Village", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "132": { "region.id": 132, "region.ts": "2018-05-27 23:13:58", "region.region": "Highlands Ranch", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "133": { "region.id": 133, "region.ts": "2018-05-27 23:13:58", "region.region": "Lafayette", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "134": { "region.id": 134, "region.ts": "2018-05-27 23:13:58", "region.region": "Lakewood", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "135": { "region.id": 135, "region.ts": "2018-05-27 23:13:58", "region.region": "Littleton", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "136": { "region.id": 136, "region.ts": "2018-05-27 23:13:58", "region.region": "Longmont", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "137": { "region.id": 137, "region.ts": "2018-05-27 23:13:58", "region.region": "Loveland", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "138": { "region.id": 138, "region.ts": "2018-05-27 23:13:58", "region.region": "Monument", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "139": { "region.id": 139, "region.ts": "2018-05-27 23:13:58", "region.region": "Parker", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "140": { "region.id": 140, "region.ts": "2018-05-27 23:13:58", "region.region": "Pueblo", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "141": { "region.id": 141, "region.ts": "2018-05-27 23:13:58", "region.region": "Silverthorne", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "142": { "region.id": 142, "region.ts": "2018-05-27 23:13:58", "region.region": "Steamboat Springs", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "143": { "region.id": 143, "region.ts": "2018-05-27 23:13:58", "region.region": "Thornton", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "144": { "region.id": 144, "region.ts": "2018-05-27 23:13:58", "region.region": "Westminster", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "145": { "region.id": 145, "region.ts": "2018-05-27 23:13:58", "region.region": "Wheat Ridge", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "146": { "region.id": 146, "region.ts": "2018-05-27 23:13:58", "region.region": "Woodland Park", "state.id": 4, "state.ts": "2018-05-25 02:15:49", "state.state": "Colorado" }, "147": { "region.id": 147, "region.ts": "2018-05-27 23:14:02", "region.region": "Avon", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "148": { "region.id": 148, "region.ts": "2018-05-27 23:14:02", "region.region": "Bloomfield", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "149": { "region.id": 149, "region.ts": "2018-05-27 23:14:02", "region.region": "Branford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "150": { "region.id": 150, "region.ts": "2018-05-27 23:14:02", "region.region": "Bridgeport", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "151": { "region.id": 151, "region.ts": "2018-05-27 23:14:02", "region.region": "Bristol", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "152": { "region.id": 152, "region.ts": "2018-05-27 23:14:02", "region.region": "Brookfield", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "153": { "region.id": 153, "region.ts": "2018-05-27 23:14:02", "region.region": "Brooklyn", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "154": { "region.id": 154, "region.ts": "2018-05-27 23:14:02", "region.region": "Cheshire", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "155": { "region.id": 155, "region.ts": "2018-05-27 23:14:02", "region.region": "Clinton", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "156": { "region.id": 156, "region.ts": "2018-05-27 23:14:02", "region.region": "Colchester", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "157": { "region.id": 157, "region.ts": "2018-05-27 23:14:02", "region.region": "Danbury", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "158": { "region.id": 158, "region.ts": "2018-05-27 23:14:02", "region.region": "Derby", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "159": { "region.id": 159, "region.ts": "2018-05-27 23:14:02", "region.region": "East Hartford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "160": { "region.id": 160, "region.ts": "2018-05-27 23:14:02", "region.region": "East Haven", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "161": { "region.id": 161, "region.ts": "2018-05-27 23:14:02", "region.region": "East Windsor", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "162": { "region.id": 162, "region.ts": "2018-05-27 23:14:02", "region.region": "Enfield", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "163": { "region.id": 163, "region.ts": "2018-05-27 23:14:02", "region.region": "Groton", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "164": { "region.id": 164, "region.ts": "2018-05-27 23:14:02", "region.region": "Hamden", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "165": { "region.id": 165, "region.ts": "2018-05-27 23:14:02", "region.region": "Hartford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "166": { "region.id": 166, "region.ts": "2018-05-27 23:14:02", "region.region": "Meriden", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "167": { "region.id": 167, "region.ts": "2018-05-27 23:14:02", "region.region": "Middletown", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "168": { "region.id": 168, "region.ts": "2018-05-27 23:14:02", "region.region": "Milford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "169": { "region.id": 169, "region.ts": "2018-05-27 23:14:02", "region.region": "Monroe", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "170": { "region.id": 170, "region.ts": "2018-05-27 23:14:02", "region.region": "Naugatuck", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "171": { "region.id": 171, "region.ts": "2018-05-27 23:14:02", "region.region": "New Britain", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "172": { "region.id": 172, "region.ts": "2018-05-27 23:14:02", "region.region": "New London", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "173": { "region.id": 173, "region.ts": "2018-05-27 23:14:02", "region.region": "New Milford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "174": { "region.id": 174, "region.ts": "2018-05-27 23:14:02", "region.region": "Newington", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "175": { "region.id": 175, "region.ts": "2018-05-27 23:14:02", "region.region": "North Haven", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "176": { "region.id": 176, "region.ts": "2018-05-27 23:14:02", "region.region": "North Windham", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "177": { "region.id": 177, "region.ts": "2018-05-27 23:14:02", "region.region": "Norwalk", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "178": { "region.id": 178, "region.ts": "2018-05-27 23:14:02", "region.region": "Norwich", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "179": { "region.id": 179, "region.ts": "2018-05-27 23:14:02", "region.region": "Old Saybrook", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "180": { "region.id": 180, "region.ts": "2018-05-27 23:14:02", "region.region": "Plainfield", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "181": { "region.id": 181, "region.ts": "2018-05-27 23:14:02", "region.region": "Plainville", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "182": { "region.id": 182, "region.ts": "2018-05-27 23:14:02", "region.region": "Putnam", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "183": { "region.id": 183, "region.ts": "2018-05-27 23:14:02", "region.region": "Southington", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "184": { "region.id": 184, "region.ts": "2018-05-27 23:14:02", "region.region": "Stafford Springs", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "185": { "region.id": 185, "region.ts": "2018-05-27 23:14:02", "region.region": "Stamford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "186": { "region.id": 186, "region.ts": "2018-05-27 23:14:02", "region.region": "Stratford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "187": { "region.id": 187, "region.ts": "2018-05-27 23:14:02", "region.region": "Terryville", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "188": { "region.id": 188, "region.ts": "2018-05-27 23:14:02", "region.region": "Torrington", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "189": { "region.id": 189, "region.ts": "2018-05-27 23:14:02", "region.region": "Vernon", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "190": { "region.id": 190, "region.ts": "2018-05-27 23:14:02", "region.region": "Wallingford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "191": { "region.id": 191, "region.ts": "2018-05-27 23:14:02", "region.region": "Waterbury", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "192": { "region.id": 192, "region.ts": "2018-05-27 23:14:02", "region.region": "Watertown", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "193": { "region.id": 193, "region.ts": "2018-05-27 23:14:02", "region.region": "West Hartford", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "194": { "region.id": 194, "region.ts": "2018-05-27 23:14:02", "region.region": "West Haven", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "195": { "region.id": 195, "region.ts": "2018-05-27 23:14:02", "region.region": "Willimantic", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "196": { "region.id": 196, "region.ts": "2018-05-27 23:14:02", "region.region": "Windsor Locks", "state.id": 5, "state.ts": "2018-05-25 02:15:49", "state.state": "Connecticut" }, "197": { "region.id": 197, "region.ts": "2018-05-27 23:14:06", "region.region": "Bear", "state.id": 6, "state.ts": "2018-05-25 02:15:49", "state.state": "Delaware" }, "198": { "region.id": 198, "region.ts": "2018-05-27 23:14:06", "region.region": "Delmar", "state.id": 6, "state.ts": "2018-05-25 02:15:49", "state.state": "Delaware" }, "199": { "region.id": 199, "region.ts": "2018-05-27 23:14:06", "region.region": "Dover", "state.id": 6, "state.ts": "2018-05-25 02:15:49", "state.state": "Delaware" }, "200": { "region.id": 200, "region.ts": "2018-05-27 23:14:06", "region.region": "Georgetown", "state.id": 6, "state.ts": "2018-05-25 02:15:49", "state.state": "Delaware" } } } }