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 Home for Sale", "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/us_home_for_sale/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_home_for_sale/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_home_for_sale/by_table/city/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.001170000000000000033029134982598407077603042125701904296875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 8517, "pages_total": 86 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city.id": 1, "city.ts": "2017-12-26 20:27:13", "city.title": "ADAMSVILLE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "2": { "city.id": 2, "city.ts": "2017-12-26 20:27:39", "city.title": "ADDISON", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "3": { "city.id": 3, "city.ts": "2017-12-26 20:27:44", "city.title": "ADGER", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "4": { "city.id": 4, "city.ts": "2017-12-26 20:27:48", "city.title": "AL", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "5": { "city.id": 5, "city.ts": "2017-12-26 20:29:35", "city.title": "ALABASTER", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "6": { "city.id": 6, "city.ts": "2017-12-26 20:30:55", "city.title": "ALBERTVILLE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "7": { "city.id": 7, "city.ts": "2017-12-26 20:32:05", "city.title": "ALEXANDER CITY", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "8": { "city.id": 8, "city.ts": "2017-12-26 20:32:35", "city.title": "ALEXANDRIA", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "9": { "city.id": 9, "city.ts": "2017-12-26 20:33:16", "city.title": "ALPINE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "10": { "city.id": 10, "city.ts": "2017-12-26 20:33:29", "city.title": "ALTOONA", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "11": { "city.id": 11, "city.ts": "2017-12-26 20:34:59", "city.title": "ANDALUSIA", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "12": { "city.id": 12, "city.ts": "2017-12-26 20:41:42", "city.title": "ANNISTON", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "13": { "city.id": 13, "city.ts": "2017-12-26 20:43:13", "city.title": "ARAB", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "14": { "city.id": 14, "city.ts": "2017-12-26 20:43:33", "city.title": "ARDMORE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "15": { "city.id": 15, "city.ts": "2017-12-26 20:43:39", "city.title": "ARGO", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "16": { "city.id": 16, "city.ts": "2017-12-26 20:47:08", "city.title": "ARLEY", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "17": { "city.id": 17, "city.ts": "2017-12-26 20:47:25", "city.title": "ASHLAND", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "18": { "city.id": 18, "city.ts": "2017-12-26 20:48:06", "city.title": "ASHVILLE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "19": { "city.id": 19, "city.ts": "2017-12-26 20:52:04", "city.title": "ATHENS", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "20": { "city.id": 20, "city.ts": "2017-12-26 20:54:16", "city.title": "ATMORE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "21": { "city.id": 21, "city.ts": "2017-12-26 20:54:39", "city.title": "ATTALLA", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "22": { "city.id": 22, "city.ts": "2017-12-26 20:59:12", "city.title": "AUBURN", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "23": { "city.id": 23, "city.ts": "2017-12-26 20:59:15", "city.title": "AXIS", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "24": { "city.id": 24, "city.ts": "2017-12-26 21:01:09", "city.title": "Abbeville", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "25": { "city.id": 25, "city.ts": "2017-12-26 21:01:21", "city.title": "Acmar", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "29": { "city.id": 29, "city.ts": "2017-12-26 21:01:26", "city.title": "Akron", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "31": { "city.id": 31, "city.ts": "2017-12-26 21:01:30", "city.title": "Alberta", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "33": { "city.id": 33, "city.ts": "2017-12-26 21:01:57", "city.title": "Alex City", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "34": { "city.id": 34, "city.ts": "2017-12-26 21:02:02", "city.title": "Alexandar City", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "37": { "city.id": 37, "city.ts": "2017-12-26 21:02:06", "city.title": "Aliceville", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "41": { "city.id": 41, "city.ts": "2017-12-26 21:02:10", "city.title": "Anderson", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "45": { "city.id": 45, "city.ts": "2017-12-26 21:02:21", "city.title": "Ariton", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "47": { "city.id": 47, "city.ts": "2017-12-26 21:03:11", "city.title": "Ashford", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "54": { "city.id": 54, "city.ts": "2017-12-26 21:03:28", "city.title": "Autaugaville", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "55": { "city.id": 55, "city.ts": "2017-12-26 21:03:51", "city.title": "Avon", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "57": { "city.id": 57, "city.ts": "2017-12-26 21:04:04", "city.title": "BAILEYTON", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "58": { "city.id": 58, "city.ts": "2017-12-26 21:05:42", "city.title": "BAY MINETTE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "59": { "city.id": 59, "city.ts": "2017-12-26 21:05:52", "city.title": "BAYOU LA BATRE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "60": { "city.id": 60, "city.ts": "2017-12-26 21:05:57", "city.title": "BEAUREGARD", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "61": { "city.id": 61, "city.ts": "2017-12-26 21:09:27", "city.title": "BESSEMER", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "62": { "city.id": 62, "city.ts": "2017-12-26 21:09:41", "city.title": "BILLINGSLEY", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "63": { "city.id": 63, "city.ts": "2017-12-26 21:39:23", "city.title": "BIRMINGHAM", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "64": { "city.id": 64, "city.ts": "2017-12-26 21:39:29", "city.title": "BLOUNT SPRINGS", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "65": { "city.id": 65, "city.ts": "2017-12-26 03:10:58", "city.title": "BLOUNTSVILLE", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "66": { "city.id": 66, "city.ts": "2017-12-26 21:40:37", "city.title": "BOAZ", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "67": { "city.id": 67, "city.ts": "2017-12-26 03:10:58", "city.title": "BREMEN", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "68": { "city.id": 68, "city.ts": "2017-12-26 21:42:23", "city.title": "BREWTON", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "69": { "city.id": 69, "city.ts": "2017-12-26 21:42:30", "city.title": "BRIERFIELD", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "70": { "city.id": 70, "city.ts": "2017-12-26 21:42:55", "city.title": "BRIGHTON", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "71": { "city.id": 71, "city.ts": "2017-12-26 21:43:07", "city.title": "BROOKWOOD", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "72": { "city.id": 72, "city.ts": "2017-12-26 21:43:22", "city.title": "BROWNSBORO", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "73": { "city.id": 73, "city.ts": "2017-12-26 21:43:31", "city.title": "Babbie", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "75": { "city.id": 75, "city.ts": "2017-12-26 21:44:28", "city.title": "Bakerhill", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "76": { "city.id": 76, "city.ts": "2017-12-26 21:44:40", "city.title": "Banks", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "79": { "city.id": 79, "city.ts": "2017-12-26 21:44:42", "city.title": "Bayou Labatre", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "80": { "city.id": 80, "city.ts": "2017-12-26 21:44:46", "city.title": "Bear Creek", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "81": { "city.id": 81, "city.ts": "2017-12-26 21:44:52", "city.title": "Beatrice", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "82": { "city.id": 82, "city.ts": "2017-12-26 21:44:59", "city.title": "Beaverton", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "83": { "city.id": 83, "city.ts": "2017-12-26 21:45:05", "city.title": "Berry", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "85": { "city.id": 85, "city.ts": "2017-12-26 21:46:08", "city.title": "Big Cove", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "88": { "city.id": 88, "city.ts": "2017-12-26 21:46:13", "city.title": "Black", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "90": { "city.id": 90, "city.ts": "2017-12-26 21:47:52", "city.title": "Bluff Park", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "92": { "city.id": 92, "city.ts": "2017-12-26 21:47:55", "city.title": "Boligee", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "93": { "city.id": 93, "city.ts": "2017-12-26 21:48:13", "city.title": "Bon Secour", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "94": { "city.id": 94, "city.ts": "2017-12-26 21:48:28", "city.title": "Borden Springs", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "95": { "city.id": 95, "city.ts": "2017-12-26 21:49:07", "city.title": "Branchville", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "96": { "city.id": 96, "city.ts": "2017-12-26 21:49:16", "city.title": "Brantley", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "97": { "city.id": 97, "city.ts": "2017-12-26 21:49:28", "city.title": "Brdn Sprngs", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "100": { "city.id": 100, "city.ts": "2017-12-26 21:49:34", "city.title": "Bridgeport", "state.id": 1, "state.ts": "2017-12-26 03:15:30", "state.title": "Alabama" }, "101": { "city.id": 101, "city.ts": "2017-12-26 21:49:49", "city.title": "ANAHOLA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "102": { "city.id": 102, "city.ts": "2017-12-26 21:50:44", "city.title": "Aiea", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "104": { "city.id": 104, "city.ts": "2017-12-26 21:52:35", "city.title": "CAPTAIN COOK", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "105": { "city.id": 105, "city.ts": "2017-12-26 21:52:38", "city.title": "Capt Cook", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "107": { "city.id": 107, "city.ts": "2017-12-26 21:52:41", "city.title": "ELEELE", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "108": { "city.id": 108, "city.ts": "2017-12-26 21:55:44", "city.title": "EWA BEACH", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "111": { "city.id": 111, "city.ts": "2017-12-26 21:55:51", "city.title": "HAKALAU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "112": { "city.id": 112, "city.ts": "2017-12-26 21:56:26", "city.title": "HANALEI", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "113": { "city.id": 113, "city.ts": "2017-12-26 21:56:30", "city.title": "HANAPEPE", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "114": { "city.id": 114, "city.ts": "2017-12-26 21:56:49", "city.title": "HAWI", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "115": { "city.id": 115, "city.ts": "2017-12-26 22:00:10", "city.title": "HILO", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "116": { "city.id": 116, "city.ts": "2017-12-26 22:00:42", "city.title": "HOLUALOA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "117": { "city.id": 117, "city.ts": "2017-12-26 22:01:08", "city.title": "HONOKAA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "118": { "city.id": 118, "city.ts": "2017-12-26 22:21:56", "city.title": "HONOLULU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "119": { "city.id": 119, "city.ts": "2017-12-26 22:21:58", "city.title": "HONOMU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "120": { "city.id": 120, "city.ts": "2017-12-26 22:22:01", "city.title": "Haena", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "121": { "city.id": 121, "city.ts": "2017-12-26 22:23:21", "city.title": "Haiku", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "123": { "city.id": 123, "city.ts": "2017-12-26 22:23:38", "city.title": "Haleiwa", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "124": { "city.id": 124, "city.ts": "2017-12-26 22:24:08", "city.title": "Hana", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "127": { "city.id": 127, "city.ts": "2017-12-26 22:24:29", "city.title": "Hauula", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "128": { "city.id": 128, "city.ts": "2017-12-26 22:24:34", "city.title": "Hawaiian Ocean View", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "131": { "city.id": 131, "city.ts": "2017-12-26 22:24:36", "city.title": "Hokuala", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "134": { "city.id": 134, "city.ts": "2017-12-26 22:24:44", "city.title": "Honokowai", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "137": { "city.id": 137, "city.ts": "2017-12-26 22:28:37", "city.title": "KAILUA-KONA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "138": { "city.id": 138, "city.ts": "2017-12-26 22:29:26", "city.title": "KALAHEO", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "139": { "city.id": 139, "city.ts": "2017-12-26 22:33:16", "city.title": "KAMUELA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "140": { "city.id": 140, "city.ts": "2017-12-26 22:35:03", "city.title": "KAPAA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "141": { "city.id": 141, "city.ts": "2017-12-26 22:35:34", "city.title": "KAPAAU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "142": { "city.id": 142, "city.ts": "2017-12-26 22:37:44", "city.title": "KAPOLEI", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "143": { "city.id": 143, "city.ts": "2017-12-26 22:41:16", "city.title": "KEAAU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "144": { "city.id": 144, "city.ts": "2017-12-26 22:41:55", "city.title": "KEALAKEKUA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" } } } }