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/sub_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/sub_region/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.00161000000000000010290379659494419684051536023616790771484375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2082, "pages_total": 21 }, "struct": { "stem": { "0": "sub_region", "1": "region", "2": "state" }, "leaf": "sub_region.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "sub_region.id": 1, "sub_region.ts": "2018-05-27 23:25:22", "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" }, "2": { "sub_region.id": 2, "sub_region.ts": "2018-05-27 23:25:22", "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" }, "3": { "sub_region.id": 3, "sub_region.ts": "2018-05-27 23:25:52", "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" }, "4": { "sub_region.id": 4, "sub_region.ts": "2018-05-27 23:25:52", "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" }, "5": { "sub_region.id": 5, "sub_region.ts": "2018-05-27 23:27:22", "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" }, "6": { "sub_region.id": 6, "sub_region.ts": "2018-05-27 23:27:22", "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" }, "7": { "sub_region.id": 7, "sub_region.ts": "2018-05-27 23:28:08", "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" }, "8": { "sub_region.id": 8, "sub_region.ts": "2018-05-27 23:28:08", "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" }, "9": { "sub_region.id": 9, "sub_region.ts": "2018-05-27 23:28:22", "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" }, "10": { "sub_region.id": 10, "sub_region.ts": "2018-05-27 23:28:22", "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" }, "11": { "sub_region.id": 11, "sub_region.ts": "2018-05-27 23:28:22", "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" }, "12": { "sub_region.id": 12, "sub_region.ts": "2018-05-27 23:28:22", "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": { "sub_region.id": 13, "sub_region.ts": "2018-05-27 23:28:22", "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" }, "14": { "sub_region.id": 14, "sub_region.ts": "2018-05-27 23:28:22", "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" }, "15": { "sub_region.id": 15, "sub_region.ts": "2018-05-27 23:34:31", "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" }, "16": { "sub_region.id": 16, "sub_region.ts": "2018-05-27 23:34:31", "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" }, "17": { "sub_region.id": 17, "sub_region.ts": "2018-05-27 23:34:45", "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" }, "18": { "sub_region.id": 18, "sub_region.ts": "2018-05-27 23:34:45", "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" }, "19": { "sub_region.id": 19, "sub_region.ts": "2018-05-27 23:35:23", "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" }, "20": { "sub_region.id": 20, "sub_region.ts": "2018-05-27 23:35:23", "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" }, "21": { "sub_region.id": 21, "sub_region.ts": "2018-05-27 23:35:23", "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" }, "22": { "sub_region.id": 22, "sub_region.ts": "2018-05-27 23:38:21", "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" }, "23": { "sub_region.id": 23, "sub_region.ts": "2018-05-27 23:38:21", "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" }, "24": { "sub_region.id": 24, "sub_region.ts": "2018-05-27 23:39:32", "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" }, "25": { "sub_region.id": 25, "sub_region.ts": "2018-05-27 23:39:32", "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" }, "26": { "sub_region.id": 26, "sub_region.ts": "2018-05-27 23:42:54", "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" }, "27": { "sub_region.id": 27, "sub_region.ts": "2018-05-27 23:42:54", "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" }, "28": { "sub_region.id": 28, "sub_region.ts": "2018-05-27 23:43:31", "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" }, "29": { "sub_region.id": 29, "sub_region.ts": "2018-05-27 23:43:31", "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" }, "30": { "sub_region.id": 30, "sub_region.ts": "2018-05-27 23:43:31", "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" }, "31": { "sub_region.id": 31, "sub_region.ts": "2018-05-27 23:43:31", "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" }, "32": { "sub_region.id": 32, "sub_region.ts": "2018-05-27 23:43:31", "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" }, "33": { "sub_region.id": 33, "sub_region.ts": "2018-05-27 23:45:35", "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" }, "34": { "sub_region.id": 34, "sub_region.ts": "2018-05-27 23:45:35", "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" }, "35": { "sub_region.id": 35, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "36": { "sub_region.id": 36, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "37": { "sub_region.id": 37, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "38": { "sub_region.id": 38, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "39": { "sub_region.id": 39, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "40": { "sub_region.id": 40, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "41": { "sub_region.id": 41, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "42": { "sub_region.id": 42, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "43": { "sub_region.id": 43, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "44": { "sub_region.id": 44, "sub_region.ts": "2018-05-27 23:46:00", "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" }, "45": { "sub_region.id": 45, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "46": { "sub_region.id": 46, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "47": { "sub_region.id": 47, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "48": { "sub_region.id": 48, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "49": { "sub_region.id": 49, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "50": { "sub_region.id": 50, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "51": { "sub_region.id": 51, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "52": { "sub_region.id": 52, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "53": { "sub_region.id": 53, "sub_region.ts": "2018-05-27 23:46:39", "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" }, "54": { "sub_region.id": 54, "sub_region.ts": "2018-05-27 23:47:47", "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" }, "55": { "sub_region.id": 55, "sub_region.ts": "2018-05-27 23:47:47", "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" }, "56": { "sub_region.id": 56, "sub_region.ts": "2018-05-27 23:48:22", "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" }, "57": { "sub_region.id": 57, "sub_region.ts": "2018-05-27 23:48:22", "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" }, "58": { "sub_region.id": 58, "sub_region.ts": "2018-05-27 23:49:10", "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" }, "59": { "sub_region.id": 59, "sub_region.ts": "2018-05-27 23:49:10", "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" }, "60": { "sub_region.id": 60, "sub_region.ts": "2018-05-27 23:56:01", "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" }, "61": { "sub_region.id": 61, "sub_region.ts": "2018-05-27 23:56:01", "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" }, "62": { "sub_region.id": 62, "sub_region.ts": "2018-05-27 23:57:05", "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" }, "63": { "sub_region.id": 63, "sub_region.ts": "2018-05-27 23:57:05", "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" }, "64": { "sub_region.id": 64, "sub_region.ts": "2018-05-27 23:59:29", "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" }, "65": { "sub_region.id": 65, "sub_region.ts": "2018-05-27 23:59:29", "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" }, "66": { "sub_region.id": 66, "sub_region.ts": "2018-05-27 23:59:29", "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" }, "67": { "sub_region.id": 67, "sub_region.ts": "2018-05-27 23:59:29", "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" }, "68": { "sub_region.id": 68, "sub_region.ts": "2018-05-28 00:05:22", "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" }, "69": { "sub_region.id": 69, "sub_region.ts": "2018-05-28 00:05:22", "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" }, "70": { "sub_region.id": 70, "sub_region.ts": "2018-05-28 00:06:30", "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" }, "71": { "sub_region.id": 71, "sub_region.ts": "2018-05-28 00:06:30", "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" }, "72": { "sub_region.id": 72, "sub_region.ts": "2018-05-28 00:07:04", "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" }, "73": { "sub_region.id": 73, "sub_region.ts": "2018-05-28 00:07:04", "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" }, "74": { "sub_region.id": 74, "sub_region.ts": "2018-05-28 00:07:41", "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" }, "75": { "sub_region.id": 75, "sub_region.ts": "2018-05-28 00:07:41", "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" }, "76": { "sub_region.id": 76, "sub_region.ts": "2018-05-28 00:08:02", "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" }, "77": { "sub_region.id": 77, "sub_region.ts": "2018-05-28 00:08:02", "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" }, "78": { "sub_region.id": 78, "sub_region.ts": "2018-05-28 00:17:33", "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" }, "79": { "sub_region.id": 79, "sub_region.ts": "2018-05-28 00:17:33", "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" }, "80": { "sub_region.id": 80, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "81": { "sub_region.id": 81, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "82": { "sub_region.id": 82, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "83": { "sub_region.id": 83, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "84": { "sub_region.id": 84, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "85": { "sub_region.id": 85, "sub_region.ts": "2018-05-28 00:19:53", "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" }, "86": { "sub_region.id": 86, "sub_region.ts": "2018-05-28 00:20:55", "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" }, "87": { "sub_region.id": 87, "sub_region.ts": "2018-05-28 00:20:55", "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" }, "88": { "sub_region.id": 88, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "89": { "sub_region.id": 89, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "90": { "sub_region.id": 90, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "91": { "sub_region.id": 91, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "92": { "sub_region.id": 92, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "93": { "sub_region.id": 93, "sub_region.ts": "2018-05-28 00:21:09", "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" }, "94": { "sub_region.id": 94, "sub_region.ts": "2018-05-28 00:21:19", "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" }, "95": { "sub_region.id": 95, "sub_region.ts": "2018-05-28 00:21:19", "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" }, "96": { "sub_region.id": 96, "sub_region.ts": "2018-05-28 00:23:40", "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" }, "97": { "sub_region.id": 97, "sub_region.ts": "2018-05-28 00:23:40", "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" }, "98": { "sub_region.id": 98, "sub_region.ts": "2018-05-28 00:23:49", "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" }, "99": { "sub_region.id": 99, "sub_region.ts": "2018-05-28 00:23:49", "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" }, "100": { "sub_region.id": 100, "sub_region.ts": "2018-05-28 00:23:49", "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" } } } }