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": "Roofing Contractors in US", "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/roofing_contractors_in_us/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/roofing_contractors_in_us/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00143000000000000006446232436729815162834711372852325439453125 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 2259, "pages_total": 23 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "201": { "city.id": 201, "city.ts": "2018-02-22 20:55:46", "city.title": "Long Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "202": { "city.id": 202, "city.ts": "2018-02-22 20:57:03", "city.title": "Los Angeles", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "203": { "city.id": 203, "city.ts": "2018-02-22 20:57:19", "city.title": "Mammoth Lakes", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "204": { "city.id": 204, "city.ts": "2018-02-22 20:57:30", "city.title": "Manteca", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "205": { "city.id": 205, "city.ts": "2018-02-22 20:57:38", "city.title": "Martinez", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "206": { "city.id": 206, "city.ts": "2018-02-22 01:28:43", "city.title": "Mc Farland", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "207": { "city.id": 207, "city.ts": "2018-02-22 20:57:52", "city.title": "Merced", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "208": { "city.id": 208, "city.ts": "2018-02-22 20:58:40", "city.title": "Modesto", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "209": { "city.id": 209, "city.ts": "2018-02-22 20:58:54", "city.title": "Monrovia", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "210": { "city.id": 210, "city.ts": "2018-02-22 21:00:07", "city.title": "Monterey", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "211": { "city.id": 211, "city.ts": "2018-02-22 21:00:31", "city.title": "Morgan Hill", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "212": { "city.id": 212, "city.ts": "2018-02-22 21:00:46", "city.title": "Mountain View", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "213": { "city.id": 213, "city.ts": "2018-02-22 21:01:10", "city.title": "Napa", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "214": { "city.id": 214, "city.ts": "2018-02-22 21:01:15", "city.title": "Needles", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "215": { "city.id": 215, "city.ts": "2018-02-22 21:02:34", "city.title": "North Hollywood", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "216": { "city.id": 216, "city.ts": "2018-02-22 21:02:44", "city.title": "Oakhurst", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "217": { "city.id": 217, "city.ts": "2018-02-22 21:03:43", "city.title": "Oakland", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "218": { "city.id": 218, "city.ts": "2018-02-22 21:03:58", "city.title": "Oroville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "219": { "city.id": 219, "city.ts": "2018-02-22 21:04:28", "city.title": "Oxnard", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "220": { "city.id": 220, "city.ts": "2018-02-22 21:04:52", "city.title": "Palm Desert", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "221": { "city.id": 221, "city.ts": "2018-02-22 21:05:03", "city.title": "Palm Springs", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "222": { "city.id": 222, "city.ts": "2018-02-22 21:05:21", "city.title": "Palmdale", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "223": { "city.id": 223, "city.ts": "2018-02-22 21:05:57", "city.title": "Pasadena", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "224": { "city.id": 224, "city.ts": "2018-02-22 21:05:59", "city.title": "Patterson", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "225": { "city.id": 225, "city.ts": "2018-02-22 21:06:28", "city.title": "Pinole", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "226": { "city.id": 226, "city.ts": "2018-02-22 21:07:04", "city.title": "Placerville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "227": { "city.id": 227, "city.ts": "2018-02-22 21:07:10", "city.title": "Portola", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "228": { "city.id": 228, "city.ts": "2018-02-22 21:08:01", "city.title": "Poway", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "229": { "city.id": 229, "city.ts": "2018-02-22 21:09:06", "city.title": "Rancho Cucamonga", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "230": { "city.id": 230, "city.ts": "2018-02-22 21:09:25", "city.title": "Red Bluff", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "231": { "city.id": 231, "city.ts": "2018-02-22 21:10:08", "city.title": "Redding", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "232": { "city.id": 232, "city.ts": "2018-02-22 21:10:32", "city.title": "Redlands", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "233": { "city.id": 233, "city.ts": "2018-02-22 21:10:36", "city.title": "Reedley", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "234": { "city.id": 234, "city.ts": "2018-02-22 21:10:44", "city.title": "Ridgecrest", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "235": { "city.id": 235, "city.ts": "2018-02-22 21:10:49", "city.title": "Rio Vista", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "236": { "city.id": 236, "city.ts": "2018-02-22 21:11:31", "city.title": "Riverside", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "237": { "city.id": 237, "city.ts": "2018-02-22 21:12:12", "city.title": "Roseville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "238": { "city.id": 238, "city.ts": "2018-02-22 21:13:23", "city.title": "Sacramento", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "239": { "city.id": 239, "city.ts": "2018-02-22 21:13:50", "city.title": "San Bernardino", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "240": { "city.id": 240, "city.ts": "2018-02-22 21:14:27", "city.title": "San Carlos", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "241": { "city.id": 241, "city.ts": "2018-02-22 21:15:11", "city.title": "San Clemente", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "242": { "city.id": 242, "city.ts": "2018-02-22 21:15:57", "city.title": "San Diego", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "243": { "city.id": 243, "city.ts": "2018-02-22 21:16:52", "city.title": "San Francisco", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "244": { "city.id": 244, "city.ts": "2018-02-22 01:28:43", "city.title": "San Joaquin", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "245": { "city.id": 245, "city.ts": "2018-02-22 21:18:27", "city.title": "San Jose", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "246": { "city.id": 246, "city.ts": "2018-02-22 21:19:14", "city.title": "San Luis Obispo", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "247": { "city.id": 247, "city.ts": "2018-02-22 21:20:05", "city.title": "San Mateo", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "248": { "city.id": 248, "city.ts": "2018-02-22 21:20:16", "city.title": "San Miguel", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "249": { "city.id": 249, "city.ts": "2018-02-22 21:20:56", "city.title": "San Rafael", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "250": { "city.id": 250, "city.ts": "2018-02-22 21:21:41", "city.title": "Santa Ana", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "251": { "city.id": 251, "city.ts": "2018-02-22 21:22:08", "city.title": "Santa Barbara", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "252": { "city.id": 252, "city.ts": "2018-02-22 21:22:32", "city.title": "Santa Clarita", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "253": { "city.id": 253, "city.ts": "2018-02-22 21:23:35", "city.title": "Santa Cruz", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "254": { "city.id": 254, "city.ts": "2018-02-22 21:23:51", "city.title": "Santa Maria", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "255": { "city.id": 255, "city.ts": "2018-02-22 21:24:22", "city.title": "Santa Monica", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "256": { "city.id": 256, "city.ts": "2018-02-22 21:25:32", "city.title": "Santa Rosa", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "257": { "city.id": 257, "city.ts": "2018-02-22 21:25:52", "city.title": "Simi Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "258": { "city.id": 258, "city.ts": "2018-02-22 21:25:57", "city.title": "Skyforest", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "259": { "city.id": 259, "city.ts": "2018-02-22 21:26:27", "city.title": "Sonora", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "260": { "city.id": 260, "city.ts": "2018-02-22 21:26:52", "city.title": "Stockton", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "261": { "city.id": 261, "city.ts": "2018-02-22 21:26:55", "city.title": "Susanville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "262": { "city.id": 262, "city.ts": "2018-02-22 21:26:59", "city.title": "Taft", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "263": { "city.id": 263, "city.ts": "2018-02-22 21:27:26", "city.title": "Temecula", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "264": { "city.id": 264, "city.ts": "2018-02-22 01:28:43", "city.title": "The Sea Ranch", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "265": { "city.id": 265, "city.ts": "2018-02-22 21:27:49", "city.title": "Thousand Oaks", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "266": { "city.id": 266, "city.ts": "2018-02-22 21:28:55", "city.title": "Torrance", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "267": { "city.id": 267, "city.ts": "2018-02-22 21:29:09", "city.title": "Tracy", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "268": { "city.id": 268, "city.ts": "2018-02-22 21:29:40", "city.title": "Truckee", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "269": { "city.id": 269, "city.ts": "2018-02-22 21:29:56", "city.title": "Vallejo", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "270": { "city.id": 270, "city.ts": "2018-02-22 21:30:37", "city.title": "Ventura", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "271": { "city.id": 271, "city.ts": "2018-02-22 21:30:57", "city.title": "Victorville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "272": { "city.id": 272, "city.ts": "2018-02-22 21:31:23", "city.title": "Visalia", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "273": { "city.id": 273, "city.ts": "2018-02-22 21:32:16", "city.title": "Walnut Creek", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "274": { "city.id": 274, "city.ts": "2018-02-22 21:32:22", "city.title": "Weaverville", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "275": { "city.id": 275, "city.ts": "2018-02-22 21:33:23", "city.title": "Westlake Village", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "276": { "city.id": 276, "city.ts": "2018-02-22 21:33:45", "city.title": "Whittier", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "277": { "city.id": 277, "city.ts": "2018-02-22 21:34:08", "city.title": "Woodland", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "278": { "city.id": 278, "city.ts": "2018-02-22 21:34:42", "city.title": "Yuba City", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "279": { "city.id": 279, "city.ts": "2018-02-22 21:34:56", "city.title": "Yucca Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-02-22 01:26:46", "state.title": "California" }, "280": { "city.id": 280, "city.ts": "2018-02-22 21:35:09", "city.title": "Alamosa", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "281": { "city.id": 281, "city.ts": "2018-02-22 21:35:24", "city.title": "Avon", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "282": { "city.id": 282, "city.ts": "2018-02-22 21:35:44", "city.title": "Boulder", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "283": { "city.id": 283, "city.ts": "2018-02-22 21:36:00", "city.title": "Brighton", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "284": { "city.id": 284, "city.ts": "2018-02-22 21:36:04", "city.title": "Burlington", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "285": { "city.id": 285, "city.ts": "2018-02-22 21:36:26", "city.title": "Canon City", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "286": { "city.id": 286, "city.ts": "2018-02-22 21:36:47", "city.title": "Carbondale", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "287": { "city.id": 287, "city.ts": "2018-02-22 21:37:10", "city.title": "Castle Rock", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "288": { "city.id": 288, "city.ts": "2018-02-22 21:38:11", "city.title": "Colorado Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "289": { "city.id": 289, "city.ts": "2018-02-22 21:38:17", "city.title": "Crested Butte", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "290": { "city.id": 290, "city.ts": "2018-02-22 21:39:11", "city.title": "Denver", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "291": { "city.id": 291, "city.ts": "2018-02-22 21:39:27", "city.title": "Durango", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "292": { "city.id": 292, "city.ts": "2018-02-22 21:39:31", "city.title": "Estes Park", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "293": { "city.id": 293, "city.ts": "2018-02-22 21:40:28", "city.title": "Fort Collins", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "294": { "city.id": 294, "city.ts": "2018-02-22 21:40:32", "city.title": "Granby", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "295": { "city.id": 295, "city.ts": "2018-02-22 21:40:51", "city.title": "Grand Junction", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "296": { "city.id": 296, "city.ts": "2018-02-22 21:41:39", "city.title": "Greeley", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "297": { "city.id": 297, "city.ts": "2018-02-22 21:41:45", "city.title": "Idaho Springs", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "298": { "city.id": 298, "city.ts": "2018-02-22 21:41:51", "city.title": "La Junta", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "299": { "city.id": 299, "city.ts": "2018-02-22 21:41:53", "city.title": "Lamar", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" }, "300": { "city.id": 300, "city.ts": "2018-02-22 21:42:24", "city.title": "Longmont", "city.state": "Colorado", "state.id": 6, "state.ts": "2018-02-22 01:26:46", "state.title": "Colorado" } } } }