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" }, "prev": { "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/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.0011600000000000000068001160258290838100947439670562744140625 }, "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": { "145": { "city.id": 145, "city.ts": "2017-12-26 22:42:02", "city.title": "KEALIA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "146": { "city.id": 146, "city.ts": "2017-12-26 22:42:25", "city.title": "KEKAHA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "147": { "city.id": 147, "city.ts": "2017-12-26 22:49:38", "city.title": "KIHEI", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "148": { "city.id": 148, "city.ts": "2017-12-26 22:50:38", "city.title": "KILAUEA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "149": { "city.id": 149, "city.ts": "2017-12-26 22:53:17", "city.title": "KOLOA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "150": { "city.id": 150, "city.ts": "2017-12-26 22:53:23", "city.title": "KUKUIULA", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "151": { "city.id": 151, "city.ts": "2017-12-26 22:53:55", "city.title": "KURTISTOWN", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "152": { "city.id": 152, "city.ts": "2017-12-26 22:54:06", "city.title": "Kaaawa", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "153": { "city.id": 153, "city.ts": "2017-12-26 22:54:10", "city.title": "Kaanapali", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "154": { "city.id": 154, "city.ts": "2017-12-26 22:54:16", "city.title": "Kahana", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "155": { "city.id": 155, "city.ts": "2017-12-26 22:54:31", "city.title": "Kahuku", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "156": { "city.id": 156, "city.ts": "2017-12-26 22:55:42", "city.title": "Kahului", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "157": { "city.id": 157, "city.ts": "2017-12-26 22:57:27", "city.title": "Kailua", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "158": { "city.id": 158, "city.ts": "2017-12-26 23:00:34", "city.title": "Kailua Kona", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "162": { "city.id": 162, "city.ts": "2017-12-26 23:01:47", "city.title": "Kaneohe", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "165": { "city.id": 165, "city.ts": "2017-12-26 23:01:51", "city.title": "Kapalua", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "167": { "city.id": 167, "city.ts": "2017-12-26 23:03:00", "city.title": "Kaunakakai", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "168": { "city.id": 168, "city.ts": "2017-12-26 23:05:27", "city.title": "Kea'au", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "176": { "city.id": 176, "city.ts": "2017-12-26 23:05:32", "city.title": "Kona", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "177": { "city.id": 177, "city.ts": "2017-12-26 23:05:43", "city.title": "Kualapuu", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "178": { "city.id": 178, "city.ts": "2017-12-26 23:06:52", "city.title": "Kula", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "180": { "city.id": 180, "city.ts": "2017-12-26 23:07:04", "city.title": "LAUPAHOEHOE", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "181": { "city.id": 181, "city.ts": "2017-12-26 23:07:10", "city.title": "LAWAI", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "182": { "city.id": 182, "city.ts": "2017-12-26 23:08:14", "city.title": "LIHUE", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "183": { "city.id": 183, "city.ts": "2017-12-26 23:14:18", "city.title": "Lahaina", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "184": { "city.id": 184, "city.ts": "2017-12-26 23:14:28", "city.title": "Laie", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "185": { "city.id": 185, "city.ts": "2017-12-26 23:14:44", "city.title": "Lanai City", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "189": { "city.id": 189, "city.ts": "2017-12-26 23:16:32", "city.title": "MOUNTAIN VIEW", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "190": { "city.id": 190, "city.ts": "2017-12-26 23:17:11", "city.title": "Makawao", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "191": { "city.id": 191, "city.ts": "2017-12-26 23:17:16", "city.title": "Makena", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "192": { "city.id": 192, "city.ts": "2017-12-26 23:17:59", "city.title": "Maunaloa", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "193": { "city.id": 193, "city.ts": "2017-12-26 23:19:06", "city.title": "Mililani", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "195": { "city.id": 195, "city.ts": "2017-12-26 23:21:10", "city.title": "Mt View", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "196": { "city.id": 196, "city.ts": "2017-12-26 23:22:45", "city.title": "NAALEHU", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "197": { "city.id": 197, "city.ts": "2017-12-26 23:22:53", "city.title": "NINOLE", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "199": { "city.id": 199, "city.ts": "2017-12-26 23:23:00", "city.title": "Napili", "state.id": 2, "state.ts": "2017-12-26 03:15:37", "state.title": "Hawaii" }, "201": { "city.id": 201, "city.ts": "2017-12-26 23:23:29", "city.title": "Abington", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "202": { "city.id": 202, "city.ts": "2017-12-26 23:24:12", "city.title": "Acton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "203": { "city.id": 203, "city.ts": "2017-12-26 23:24:53", "city.title": "Acushnet", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "204": { "city.id": 204, "city.ts": "2017-12-26 23:25:24", "city.title": "Adams", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "205": { "city.id": 205, "city.ts": "2017-12-26 23:26:13", "city.title": "Agawam", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "206": { "city.id": 206, "city.ts": "2017-12-26 23:26:42", "city.title": "Alford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "207": { "city.id": 207, "city.ts": "2017-12-26 23:26:45", "city.title": "Allston", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "208": { "city.id": 208, "city.ts": "2017-12-26 23:27:30", "city.title": "Amesbury", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "209": { "city.id": 209, "city.ts": "2017-12-26 23:27:57", "city.title": "Amherst", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "210": { "city.id": 210, "city.ts": "2017-12-26 23:28:51", "city.title": "Andover", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "211": { "city.id": 211, "city.ts": "2017-12-26 23:28:58", "city.title": "Aquinnah", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "212": { "city.id": 212, "city.ts": "2017-12-26 23:29:38", "city.title": "Arlington", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "213": { "city.id": 213, "city.ts": "2017-12-26 23:30:07", "city.title": "Ashburnham", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "214": { "city.id": 214, "city.ts": "2017-12-26 23:30:20", "city.title": "Ashby", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "215": { "city.id": 215, "city.ts": "2017-12-26 23:30:28", "city.title": "Ashfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "216": { "city.id": 216, "city.ts": "2017-12-26 23:30:58", "city.title": "Ashland", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "217": { "city.id": 217, "city.ts": "2017-12-26 23:31:03", "city.title": "Ashley Falls", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "218": { "city.id": 218, "city.ts": "2017-12-26 23:31:10", "city.title": "Assonet", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "219": { "city.id": 219, "city.ts": "2017-12-26 23:31:56", "city.title": "Athol", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "220": { "city.id": 220, "city.ts": "2017-12-26 23:33:46", "city.title": "Attleboro", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "221": { "city.id": 221, "city.ts": "2017-12-26 23:33:50", "city.title": "Attleboro Falls", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "222": { "city.id": 222, "city.ts": "2017-12-26 23:34:31", "city.title": "Auburn", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "223": { "city.id": 223, "city.ts": "2017-12-26 23:34:35", "city.title": "Auburndale", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "224": { "city.id": 224, "city.ts": "2017-12-26 23:34:44", "city.title": "Avon", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "225": { "city.id": 225, "city.ts": "2017-12-26 23:35:15", "city.title": "Ayer", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "226": { "city.id": 226, "city.ts": "2017-12-26 23:35:45", "city.title": "Barnstable", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "227": { "city.id": 227, "city.ts": "2017-12-26 23:36:06", "city.title": "Barre", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "228": { "city.id": 228, "city.ts": "2017-12-26 23:36:36", "city.title": "Bass River", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "229": { "city.id": 229, "city.ts": "2017-12-26 23:36:49", "city.title": "Bay State Village", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "230": { "city.id": 230, "city.ts": "2017-12-26 23:38:03", "city.title": "Becket", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "231": { "city.id": 231, "city.ts": "2017-12-26 23:38:15", "city.title": "Bedford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "232": { "city.id": 232, "city.ts": "2017-12-26 23:39:14", "city.title": "Belchertown", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "233": { "city.id": 233, "city.ts": "2017-12-26 23:39:45", "city.title": "Bellingham", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "234": { "city.id": 234, "city.ts": "2017-12-26 23:40:03", "city.title": "Belmont", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "235": { "city.id": 235, "city.ts": "2017-12-26 23:40:22", "city.title": "Berkley", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "236": { "city.id": 236, "city.ts": "2017-12-26 23:40:32", "city.title": "Berlin", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "237": { "city.id": 237, "city.ts": "2017-12-26 23:40:42", "city.title": "Bernardston", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "238": { "city.id": 238, "city.ts": "2017-12-26 23:41:36", "city.title": "Beverly", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "239": { "city.id": 239, "city.ts": "2017-12-26 23:42:25", "city.title": "Billerica", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "240": { "city.id": 240, "city.ts": "2017-12-26 23:42:46", "city.title": "Blackstone", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "241": { "city.id": 241, "city.ts": "2017-12-26 23:43:02", "city.title": "Blandford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "242": { "city.id": 242, "city.ts": "2017-12-26 23:43:28", "city.title": "Bolton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "243": { "city.id": 243, "city.ts": "2017-12-26 23:43:32", "city.title": "Bondsville", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "244": { "city.id": 244, "city.ts": "2017-12-26 23:51:47", "city.title": "Boston", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "245": { "city.id": 245, "city.ts": "2017-12-26 23:51:57", "city.title": "Boston College", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "246": { "city.id": 246, "city.ts": "2017-12-26 23:52:57", "city.title": "Bourne", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "247": { "city.id": 247, "city.ts": "2017-12-26 23:53:05", "city.title": "Boxboro", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "248": { "city.id": 248, "city.ts": "2017-12-26 23:53:18", "city.title": "Boxborough", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "249": { "city.id": 249, "city.ts": "2017-12-26 23:53:51", "city.title": "Boxford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "250": { "city.id": 250, "city.ts": "2017-12-26 23:54:01", "city.title": "Boylston", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "251": { "city.id": 251, "city.ts": "2017-12-26 23:54:13", "city.title": "Bradford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "252": { "city.id": 252, "city.ts": "2017-12-26 23:54:47", "city.title": "Braintree", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "253": { "city.id": 253, "city.ts": "2017-12-26 23:54:50", "city.title": "Brant Rock", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "254": { "city.id": 254, "city.ts": "2017-12-26 23:56:07", "city.title": "Brewster", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "255": { "city.id": 255, "city.ts": "2017-12-26 23:56:47", "city.title": "Bridgewater", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "256": { "city.id": 256, "city.ts": "2017-12-26 23:57:01", "city.title": "Brighton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "257": { "city.id": 257, "city.ts": "2017-12-26 23:57:28", "city.title": "Brimfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "258": { "city.id": 258, "city.ts": "2017-12-27 00:00:33", "city.title": "Brockton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "259": { "city.id": 259, "city.ts": "2017-12-27 00:00:51", "city.title": "Brookfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "260": { "city.id": 260, "city.ts": "2017-12-27 00:01:19", "city.title": "Brookline", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "261": { "city.id": 261, "city.ts": "2017-12-27 00:01:30", "city.title": "Buckland", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "262": { "city.id": 262, "city.ts": "2017-12-27 00:01:54", "city.title": "Burlington", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "263": { "city.id": 263, "city.ts": "2017-12-27 00:02:19", "city.title": "Buzzards Bay", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "264": { "city.id": 264, "city.ts": "2017-12-27 00:02:24", "city.title": "Byfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" } } } }