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/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/us_home_for_sale/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00139999999999999998577526749699018182582221925258636474609375 }, "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": { "265": { "city.id": 265, "city.ts": "2017-12-27 00:03:17", "city.title": "Cambridge", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "266": { "city.id": 266, "city.ts": "2017-12-27 00:03:47", "city.title": "Canton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "267": { "city.id": 267, "city.ts": "2017-12-27 00:04:01", "city.title": "Carlisle", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "268": { "city.id": 268, "city.ts": "2017-12-27 00:04:39", "city.title": "Carver", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "269": { "city.id": 269, "city.ts": "2017-12-27 00:04:47", "city.title": "Cataumet", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "270": { "city.id": 270, "city.ts": "2017-12-27 00:05:39", "city.title": "Centerville", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "271": { "city.id": 271, "city.ts": "2017-12-27 00:05:53", "city.title": "Charlemont", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "272": { "city.id": 272, "city.ts": "2017-12-27 00:06:09", "city.title": "Charlestown", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "273": { "city.id": 273, "city.ts": "2017-12-27 00:07:04", "city.title": "Charlton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "274": { "city.id": 274, "city.ts": "2017-12-27 00:08:31", "city.title": "Chatham", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "275": { "city.id": 275, "city.ts": "2017-12-27 00:09:07", "city.title": "Chelmsford", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "276": { "city.id": 276, "city.ts": "2017-12-27 00:09:29", "city.title": "Chelsea", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "277": { "city.id": 277, "city.ts": "2017-12-27 00:09:36", "city.title": "Cherry Valley", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "278": { "city.id": 278, "city.ts": "2017-12-27 00:09:53", "city.title": "Cheshire", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "279": { "city.id": 279, "city.ts": "2017-12-27 00:10:05", "city.title": "Chester", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "280": { "city.id": 280, "city.ts": "2017-12-27 00:10:10", "city.title": "Chesterfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "281": { "city.id": 281, "city.ts": "2017-12-27 00:10:23", "city.title": "Chestnut Hill", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "282": { "city.id": 282, "city.ts": "2017-12-27 00:11:59", "city.title": "Chicopee", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "283": { "city.id": 283, "city.ts": "2017-12-27 00:12:16", "city.title": "Chilmark", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "284": { "city.id": 284, "city.ts": "2017-12-27 00:12:38", "city.title": "Clarksburg", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "285": { "city.id": 285, "city.ts": "2017-12-27 00:13:16", "city.title": "Clinton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "286": { "city.id": 286, "city.ts": "2017-12-27 00:13:43", "city.title": "Cohasset", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "287": { "city.id": 287, "city.ts": "2017-12-27 00:13:49", "city.title": "Colrain", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "288": { "city.id": 288, "city.ts": "2017-12-27 00:14:39", "city.title": "Concord", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "289": { "city.id": 289, "city.ts": "2017-12-27 00:14:51", "city.title": "Conway", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "290": { "city.id": 290, "city.ts": "2017-12-27 00:15:12", "city.title": "Cotuit", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "291": { "city.id": 291, "city.ts": "2017-12-27 00:15:16", "city.title": "Cummaquid", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "292": { "city.id": 292, "city.ts": "2017-12-27 00:15:21", "city.title": "Cummington", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "293": { "city.id": 293, "city.ts": "2017-12-27 00:15:39", "city.title": "Cushman", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "294": { "city.id": 294, "city.ts": "2017-12-27 00:15:45", "city.title": "Cuttyhunk", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "295": { "city.id": 295, "city.ts": "2017-12-27 00:16:14", "city.title": "Dalton", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "296": { "city.id": 296, "city.ts": "2017-12-27 00:16:55", "city.title": "Danvers", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "297": { "city.id": 297, "city.ts": "2017-12-27 00:17:52", "city.title": "Dartmouth", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "298": { "city.id": 298, "city.ts": "2017-12-27 00:18:16", "city.title": "Dedham", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "299": { "city.id": 299, "city.ts": "2017-12-27 00:18:26", "city.title": "Deerfield", "state.id": 3, "state.ts": "2017-12-26 03:15:43", "state.title": "Massachusetts" }, "300": { "city.id": 300, "city.ts": "2017-12-27 00:18:32", "city.title": "*other", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "301": { "city.id": 301, "city.ts": "2017-12-27 00:27:33", "city.title": "ALAMOGORDO", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "302": { "city.id": 302, "city.ts": "2017-12-27 00:31:40", "city.title": "ALTO", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "303": { "city.id": 303, "city.ts": "2017-12-27 00:38:16", "city.title": "ANGEL FIRE", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "304": { "city.id": 304, "city.ts": "2017-12-27 00:39:29", "city.title": "ANTHONY", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "305": { "city.id": 305, "city.ts": "2017-12-27 00:39:38", "city.title": "ARREY", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "306": { "city.id": 306, "city.ts": "2017-12-27 00:42:08", "city.title": "AZTEC", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "307": { "city.id": 307, "city.ts": "2017-12-27 00:42:41", "city.title": "Abiquiu", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "308": { "city.id": 308, "city.ts": "2017-12-27 00:43:47", "city.title": "Alameda", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "309": { "city.id": 309, "city.ts": "2017-12-27 00:44:04", "city.title": "Alamo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "311": { "city.id": 311, "city.ts": "2017-12-27 01:24:16", "city.title": "Albuquerque", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "312": { "city.id": 312, "city.ts": "2017-12-27 01:24:20", "city.title": "Alcalde", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "313": { "city.id": 313, "city.ts": "2017-12-27 01:24:29", "city.title": "Algodones", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "315": { "city.id": 315, "city.ts": "2017-12-27 01:24:36", "city.title": "Amalia", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "316": { "city.id": 316, "city.ts": "2017-12-27 01:25:02", "city.title": "Ancho", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "319": { "city.id": 319, "city.ts": "2017-12-27 01:25:13", "city.title": "Angus", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "320": { "city.id": 320, "city.ts": "2017-12-27 01:25:16", "city.title": "Animas", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "322": { "city.id": 322, "city.ts": "2017-12-27 01:25:23", "city.title": "Anton Chico", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "323": { "city.id": 323, "city.ts": "2017-12-27 01:25:28", "city.title": "Arabela", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "324": { "city.id": 324, "city.ts": "2017-12-27 01:25:31", "city.title": "Aragon", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "325": { "city.id": 325, "city.ts": "2017-12-27 01:25:38", "city.title": "Arenas Valley", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "327": { "city.id": 327, "city.ts": "2017-12-27 01:26:02", "city.title": "Arroyo Hondo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "328": { "city.id": 328, "city.ts": "2017-12-27 01:26:20", "city.title": "Arroyo Seco", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "329": { "city.id": 329, "city.ts": "2017-12-27 01:27:51", "city.title": "Artesia", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "331": { "city.id": 331, "city.ts": "2017-12-27 01:31:43", "city.title": "BELEN", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "332": { "city.id": 332, "city.ts": "2017-12-27 01:31:49", "city.title": "BLANCO", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "333": { "city.id": 333, "city.ts": "2017-12-27 01:33:17", "city.title": "BLOOMFIELD", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "334": { "city.id": 334, "city.ts": "2017-12-27 01:33:29", "city.title": "Bayard", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "336": { "city.id": 336, "city.ts": "2017-12-27 01:33:31", "city.title": "Bent", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "337": { "city.id": 337, "city.ts": "2017-12-27 01:33:35", "city.title": "Berino", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "338": { "city.id": 338, "city.ts": "2017-12-27 01:33:40", "city.title": "Bernal", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "339": { "city.id": 339, "city.ts": "2017-12-27 01:34:22", "city.title": "Bernalillo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "340": { "city.id": 340, "city.ts": "2017-12-27 01:34:27", "city.title": "Bernardo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "341": { "city.id": 341, "city.ts": "2017-12-27 01:34:29", "city.title": "Bingham", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "342": { "city.id": 342, "city.ts": "2017-12-27 01:34:33", "city.title": "Black Lake", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "345": { "city.id": 345, "city.ts": "2017-12-27 01:34:40", "city.title": "Bluewater", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "346": { "city.id": 346, "city.ts": "2017-12-27 01:35:01", "city.title": "Border Hill", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "347": { "city.id": 347, "city.ts": "2017-12-27 01:35:09", "city.title": "Bosque", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "348": { "city.id": 348, "city.ts": "2017-12-27 01:35:36", "city.title": "Bosque Farms", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "349": { "city.id": 349, "city.ts": "2017-12-27 01:35:40", "city.title": "Brazos", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "350": { "city.id": 350, "city.ts": "2017-12-27 01:35:43", "city.title": "Buckhorn", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "351": { "city.id": 351, "city.ts": "2017-12-27 01:35:45", "city.title": "Budaghers", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "352": { "city.id": 352, "city.ts": "2017-12-27 01:35:50", "city.title": "Buena Vista", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "353": { "city.id": 353, "city.ts": "2017-12-27 01:35:54", "city.title": "CHAMBERINO", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "354": { "city.id": 354, "city.ts": "2017-12-27 01:37:08", "city.title": "CHAPARRAL", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "355": { "city.id": 355, "city.ts": "2017-12-27 01:43:50", "city.title": "CLOVIS", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "356": { "city.id": 356, "city.ts": "2017-12-27 01:43:56", "city.title": "Caballo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "357": { "city.id": 357, "city.ts": "2017-12-27 01:43:58", "city.title": "Canjilon", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "358": { "city.id": 358, "city.ts": "2017-12-27 01:45:30", "city.title": "Cannon Airforcebase", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "359": { "city.id": 359, "city.ts": "2017-12-27 01:45:35", "city.title": "Canoncito", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "360": { "city.id": 360, "city.ts": "2017-12-27 01:45:54", "city.title": "Capitan", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "361": { "city.id": 361, "city.ts": "2017-12-27 01:48:25", "city.title": "Carlsbad", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "362": { "city.id": 362, "city.ts": "2017-12-27 01:49:02", "city.title": "Carrizozo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "363": { "city.id": 363, "city.ts": "2017-12-27 01:49:10", "city.title": "Carson", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "364": { "city.id": 364, "city.ts": "2017-12-27 01:49:17", "city.title": "Cebolla", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "365": { "city.id": 365, "city.ts": "2017-12-27 01:49:46", "city.title": "Cedar Crest", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "366": { "city.id": 366, "city.ts": "2017-12-27 01:49:52", "city.title": "Central", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "367": { "city.id": 367, "city.ts": "2017-12-27 01:50:39", "city.title": "Cerrillos", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "368": { "city.id": 368, "city.ts": "2017-12-27 01:50:43", "city.title": "Cerro", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "369": { "city.id": 369, "city.ts": "2017-12-27 01:50:48", "city.title": "Chacon", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "370": { "city.id": 370, "city.ts": "2017-12-27 01:52:45", "city.title": "Chama", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "372": { "city.id": 372, "city.ts": "2017-12-27 01:52:47", "city.title": "Chamisal", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "373": { "city.id": 373, "city.ts": "2017-12-27 01:52:53", "city.title": "Chamita", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "375": { "city.id": 375, "city.ts": "2017-12-27 01:52:57", "city.title": "Chili", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" }, "376": { "city.id": 376, "city.ts": "2017-12-27 01:53:11", "city.title": "Chimayo", "state.id": 4, "state.ts": "2017-12-26 03:15:50", "state.title": "New Mexico" } } } }