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" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/us_auto_parts_store_information_1/by_table/region/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.00126000000000000005224987109642142968368716537952423095703125 }, "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": { "1": { "region.id": 1, "region.ts": "2018-05-27 23:13:13", "region.region": "Alabaster", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "2": { "region.id": 2, "region.ts": "2018-05-27 23:13:13", "region.region": "Albertville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "3": { "region.id": 3, "region.ts": "2018-05-27 23:13:13", "region.region": "Alexander City", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "4": { "region.id": 4, "region.ts": "2018-05-27 23:13:13", "region.region": "Andalusia", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "5": { "region.id": 5, "region.ts": "2018-05-27 23:13:13", "region.region": "Anniston", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "6": { "region.id": 6, "region.ts": "2018-05-27 23:13:13", "region.region": "Arab", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "7": { "region.id": 7, "region.ts": "2018-05-27 23:13:13", "region.region": "Athens", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "8": { "region.id": 8, "region.ts": "2018-05-27 23:13:13", "region.region": "Atmore", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "9": { "region.id": 9, "region.ts": "2018-05-27 23:13:13", "region.region": "Auburn", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "10": { "region.id": 10, "region.ts": "2018-05-27 23:13:13", "region.region": "Bay Minette", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "11": { "region.id": 11, "region.ts": "2018-05-27 23:13:13", "region.region": "Bessemer", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "12": { "region.id": 12, "region.ts": "2018-05-27 23:13:13", "region.region": "Birmingham", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "13": { "region.id": 13, "region.ts": "2018-05-27 23:13:13", "region.region": "Boaz", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "14": { "region.id": 14, "region.ts": "2018-05-27 23:13:13", "region.region": "Brent", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "15": { "region.id": 15, "region.ts": "2018-05-27 23:13:13", "region.region": "Brewton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "16": { "region.id": 16, "region.ts": "2018-05-27 23:13:13", "region.region": "Butler", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "17": { "region.id": 17, "region.ts": "2018-05-27 23:13:13", "region.region": "Calera", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "18": { "region.id": 18, "region.ts": "2018-05-27 23:13:13", "region.region": "Center Point", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "19": { "region.id": 19, "region.ts": "2018-05-27 23:13:13", "region.region": "Centre", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "20": { "region.id": 20, "region.ts": "2018-05-27 23:13:13", "region.region": "Chelsea", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "21": { "region.id": 21, "region.ts": "2018-05-27 23:13:13", "region.region": "Clanton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "22": { "region.id": 22, "region.ts": "2018-05-27 23:13:13", "region.region": "Cullman", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "23": { "region.id": 23, "region.ts": "2018-05-27 23:13:13", "region.region": "Daleville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "24": { "region.id": 24, "region.ts": "2018-05-27 23:13:13", "region.region": "Daphne", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "25": { "region.id": 25, "region.ts": "2018-05-27 23:13:13", "region.region": "Decatur", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "26": { "region.id": 26, "region.ts": "2018-05-27 23:13:13", "region.region": "Demopolis", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "27": { "region.id": 27, "region.ts": "2018-05-27 23:13:13", "region.region": "Dothan", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "28": { "region.id": 28, "region.ts": "2018-05-27 23:13:13", "region.region": "Enterprise", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "29": { "region.id": 29, "region.ts": "2018-05-27 23:13:13", "region.region": "Eufaula", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "30": { "region.id": 30, "region.ts": "2018-05-27 23:13:13", "region.region": "Fairfield", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "31": { "region.id": 31, "region.ts": "2018-05-27 23:13:13", "region.region": "Fairhope", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "32": { "region.id": 32, "region.ts": "2018-05-27 23:13:13", "region.region": "Fayette", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "33": { "region.id": 33, "region.ts": "2018-05-27 23:13:13", "region.region": "Flomaton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "34": { "region.id": 34, "region.ts": "2018-05-27 23:13:13", "region.region": "Florence", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "35": { "region.id": 35, "region.ts": "2018-05-27 23:13:13", "region.region": "Foley", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "36": { "region.id": 36, "region.ts": "2018-05-27 23:13:13", "region.region": "Fort Payne", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "37": { "region.id": 37, "region.ts": "2018-05-27 23:13:13", "region.region": "Gadsden", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "38": { "region.id": 38, "region.ts": "2018-05-27 23:13:13", "region.region": "Gardendale", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "39": { "region.id": 39, "region.ts": "2018-05-27 23:13:13", "region.region": "Geneva", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "40": { "region.id": 40, "region.ts": "2018-05-27 23:13:13", "region.region": "Grand Bay", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "41": { "region.id": 41, "region.ts": "2018-05-27 23:13:13", "region.region": "Greenville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "42": { "region.id": 42, "region.ts": "2018-05-27 23:13:13", "region.region": "Hartselle", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "43": { "region.id": 43, "region.ts": "2018-05-27 23:13:13", "region.region": "Harvest", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "44": { "region.id": 44, "region.ts": "2018-05-27 23:13:13", "region.region": "Hazel Green", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "45": { "region.id": 45, "region.ts": "2018-05-27 23:13:13", "region.region": "Hoover", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "46": { "region.id": 46, "region.ts": "2018-05-27 23:13:13", "region.region": "Hueytown", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "47": { "region.id": 47, "region.ts": "2018-05-27 23:13:13", "region.region": "Huntsville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "48": { "region.id": 48, "region.ts": "2018-05-27 23:13:13", "region.region": "Jackson", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "49": { "region.id": 49, "region.ts": "2018-05-27 23:13:13", "region.region": "Jacksonville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "50": { "region.id": 50, "region.ts": "2018-05-27 23:13:13", "region.region": "Jasper", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "51": { "region.id": 51, "region.ts": "2018-05-27 23:13:13", "region.region": "Leeds", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "52": { "region.id": 52, "region.ts": "2018-05-27 23:13:13", "region.region": "Luverne", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "53": { "region.id": 53, "region.ts": "2018-05-27 23:13:13", "region.region": "Madison", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "54": { "region.id": 54, "region.ts": "2018-05-27 23:13:13", "region.region": "Millbrook", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "55": { "region.id": 55, "region.ts": "2018-05-27 23:13:13", "region.region": "Mobile", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "56": { "region.id": 56, "region.ts": "2018-05-27 23:13:13", "region.region": "Monroeville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "57": { "region.id": 57, "region.ts": "2018-05-27 23:13:13", "region.region": "Montgomery", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "58": { "region.id": 58, "region.ts": "2018-05-27 23:13:13", "region.region": "Muscle Shoals", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "59": { "region.id": 59, "region.ts": "2018-05-27 23:13:13", "region.region": "Northport", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "60": { "region.id": 60, "region.ts": "2018-05-27 23:13:13", "region.region": "Oneonta", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "61": { "region.id": 61, "region.ts": "2018-05-27 23:13:13", "region.region": "Opelika", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "62": { "region.id": 62, "region.ts": "2018-05-27 23:13:13", "region.region": "Opp", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "63": { "region.id": 63, "region.ts": "2018-05-27 23:13:13", "region.region": "Pelham", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "64": { "region.id": 64, "region.ts": "2018-05-27 23:13:13", "region.region": "Pell City", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "65": { "region.id": 65, "region.ts": "2018-05-27 23:13:13", "region.region": "Phenix City", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "66": { "region.id": 66, "region.ts": "2018-05-27 23:13:14", "region.region": "Prattville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "67": { "region.id": 67, "region.ts": "2018-05-27 23:13:14", "region.region": "Rainbow City", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "68": { "region.id": 68, "region.ts": "2018-05-27 23:13:14", "region.region": "Rainsville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "69": { "region.id": 69, "region.ts": "2018-05-27 23:13:14", "region.region": "Roanoke", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "70": { "region.id": 70, "region.ts": "2018-05-27 23:13:14", "region.region": "Robertsdale", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "71": { "region.id": 71, "region.ts": "2018-05-27 23:13:14", "region.region": "Rogersville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "72": { "region.id": 72, "region.ts": "2018-05-27 23:13:14", "region.region": "Saraland", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "73": { "region.id": 73, "region.ts": "2018-05-27 23:13:14", "region.region": "Scottsboro", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "74": { "region.id": 74, "region.ts": "2018-05-27 23:13:14", "region.region": "Selma", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "75": { "region.id": 75, "region.ts": "2018-05-27 23:13:14", "region.region": "Springville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "76": { "region.id": 76, "region.ts": "2018-05-27 23:13:14", "region.region": "Sumiton", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "77": { "region.id": 77, "region.ts": "2018-05-27 23:13:14", "region.region": "Sylacauga", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "78": { "region.id": 78, "region.ts": "2018-05-27 23:13:14", "region.region": "Talladega", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "79": { "region.id": 79, "region.ts": "2018-05-27 23:13:14", "region.region": "Tallassee", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "80": { "region.id": 80, "region.ts": "2018-05-27 23:13:14", "region.region": "Theodore", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "81": { "region.id": 81, "region.ts": "2018-05-27 23:13:14", "region.region": "Thomasville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "82": { "region.id": 82, "region.ts": "2018-05-27 23:13:14", "region.region": "Troy", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "83": { "region.id": 83, "region.ts": "2018-05-27 23:13:14", "region.region": "Trussville", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "84": { "region.id": 84, "region.ts": "2018-05-27 23:13:14", "region.region": "Tuscaloosa", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "85": { "region.id": 85, "region.ts": "2018-05-27 23:13:14", "region.region": "Valley", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "86": { "region.id": 86, "region.ts": "2018-05-27 23:13:14", "region.region": "Warrior", "state.id": 1, "state.ts": "2018-05-25 02:15:49", "state.state": "Alabama" }, "87": { "region.id": 87, "region.ts": "2018-05-27 23:13:43", "region.region": "Batesville", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "88": { "region.id": 88, "region.ts": "2018-05-27 23:13:43", "region.region": "Benton", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "89": { "region.id": 89, "region.ts": "2018-05-27 23:13:43", "region.region": "Cabot", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "90": { "region.id": 90, "region.ts": "2018-05-27 23:13:43", "region.region": "Conway", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "91": { "region.id": 91, "region.ts": "2018-05-27 23:13:43", "region.region": "El Dorado", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "92": { "region.id": 92, "region.ts": "2018-05-27 23:13:43", "region.region": "Fort Smith", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "93": { "region.id": 93, "region.ts": "2018-05-27 23:13:43", "region.region": "Hot Springs", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "94": { "region.id": 94, "region.ts": "2018-05-27 23:13:43", "region.region": "Jonesboro", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "95": { "region.id": 95, "region.ts": "2018-05-27 23:13:43", "region.region": "Little Rock", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "96": { "region.id": 96, "region.ts": "2018-05-27 23:13:43", "region.region": "North Little Rock", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "97": { "region.id": 97, "region.ts": "2018-05-27 23:13:43", "region.region": "Paragould", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "98": { "region.id": 98, "region.ts": "2018-05-27 23:13:43", "region.region": "Pine Bluff", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "99": { "region.id": 99, "region.ts": "2018-05-27 23:13:43", "region.region": "Rogers", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" }, "100": { "region.id": 100, "region.ts": "2018-05-27 23:13:43", "region.region": "Russellville", "state.id": 2, "state.ts": "2018-05-25 02:15:49", "state.state": "Arkansas" } } } }