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": "Flower Shop in the United States and Canada_3", "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_bc75445a318997106583/flower_shop_in_the_united_states_and_canada_3/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_in_the_united_states_and_canada_3/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_in_the_united_states_and_canada_3/by_table/city/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_in_the_united_states_and_canada_3/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00186999999999999991749655148254305458976887166500091552734375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 19412, "pages_total": 195 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "201": { "city.id": 201, "city.ts": "2018-04-15 22:23:48", "city.title": "Joppa", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "202": { "city.id": 202, "city.ts": "2018-04-15 22:23:48", "city.title": "Kellyton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "203": { "city.id": 203, "city.ts": "2018-04-15 22:23:48", "city.title": "Kennedy", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "204": { "city.id": 204, "city.ts": "2018-04-15 22:23:48", "city.title": "Killen", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "205": { "city.id": 205, "city.ts": "2018-04-15 22:23:48", "city.title": "Kinston", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "206": { "city.id": 206, "city.ts": "2018-04-15 22:23:48", "city.title": "Laceys Spring", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "207": { "city.id": 207, "city.ts": "2018-04-15 22:23:48", "city.title": "Lafayette", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "208": { "city.id": 208, "city.ts": "2018-04-15 22:23:48", "city.title": "Lanett", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "209": { "city.id": 209, "city.ts": "2018-04-15 22:23:48", "city.title": "Lawley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "210": { "city.id": 210, "city.ts": "2018-04-15 22:23:48", "city.title": "Lawrenceville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "211": { "city.id": 211, "city.ts": "2018-04-15 22:23:48", "city.title": "Leeds", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "212": { "city.id": 212, "city.ts": "2018-04-15 22:23:48", "city.title": "Leesburg", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "213": { "city.id": 213, "city.ts": "2018-04-15 22:23:48", "city.title": "Leighton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "214": { "city.id": 214, "city.ts": "2018-04-15 22:23:48", "city.title": "Lester", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "215": { "city.id": 215, "city.ts": "2018-04-15 22:23:48", "city.title": "Letohatchee", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "216": { "city.id": 216, "city.ts": "2018-04-15 22:23:48", "city.title": "Level Plains", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "217": { "city.id": 217, "city.ts": "2018-04-15 22:23:48", "city.title": "Lexington", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "218": { "city.id": 218, "city.ts": "2018-04-15 22:23:48", "city.title": "Lillian", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "219": { "city.id": 219, "city.ts": "2018-04-15 22:23:48", "city.title": "Lincoln", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "220": { "city.id": 220, "city.ts": "2018-04-15 22:23:48", "city.title": "Lineville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "221": { "city.id": 221, "city.ts": "2018-04-15 22:23:48", "city.title": "Lipscomb", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "222": { "city.id": 222, "city.ts": "2018-04-15 22:23:48", "city.title": "Loachapoka", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "223": { "city.id": 223, "city.ts": "2018-04-15 22:23:48", "city.title": "Logan", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "224": { "city.id": 224, "city.ts": "2018-04-15 22:23:48", "city.title": "Louisville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "225": { "city.id": 225, "city.ts": "2018-04-15 22:23:48", "city.title": "Loxley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "226": { "city.id": 226, "city.ts": "2018-04-15 22:23:48", "city.title": "Luverne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "227": { "city.id": 227, "city.ts": "2018-04-15 22:23:48", "city.title": "Lynn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "228": { "city.id": 228, "city.ts": "2018-04-15 22:23:48", "city.title": "Madison", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "229": { "city.id": 229, "city.ts": "2018-04-15 22:23:48", "city.title": "Magnolia Springs", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "230": { "city.id": 230, "city.ts": "2018-04-15 22:23:48", "city.title": "Maplesville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "231": { "city.id": 231, "city.ts": "2018-04-15 22:23:48", "city.title": "Marbury", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "232": { "city.id": 232, "city.ts": "2018-04-15 22:23:48", "city.title": "Margaret", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "233": { "city.id": 233, "city.ts": "2018-04-15 22:23:48", "city.title": "Marion", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "234": { "city.id": 234, "city.ts": "2018-04-15 22:23:48", "city.title": "Mccalla", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "235": { "city.id": 235, "city.ts": "2018-04-15 22:23:48", "city.title": "Mccullough", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "236": { "city.id": 236, "city.ts": "2018-04-15 22:23:48", "city.title": "Mckenzie", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "237": { "city.id": 237, "city.ts": "2018-04-15 22:23:48", "city.title": "Meadowbrook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "238": { "city.id": 238, "city.ts": "2018-04-15 22:23:48", "city.title": "Mentone", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "239": { "city.id": 239, "city.ts": "2018-04-15 22:23:48", "city.title": "Meridianville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "240": { "city.id": 240, "city.ts": "2018-04-15 22:23:48", "city.title": "Midfield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "241": { "city.id": 241, "city.ts": "2018-04-15 22:23:48", "city.title": "Midland City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "242": { "city.id": 242, "city.ts": "2018-04-15 22:23:48", "city.title": "Midway", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "243": { "city.id": 243, "city.ts": "2018-04-15 22:23:48", "city.title": "Millbrook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "244": { "city.id": 244, "city.ts": "2018-04-15 22:23:48", "city.title": "Mobile", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "245": { "city.id": 245, "city.ts": "2018-04-15 22:23:48", "city.title": "Montgomery", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "246": { "city.id": 246, "city.ts": "2018-04-15 22:23:48", "city.title": "Montrose", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "247": { "city.id": 247, "city.ts": "2018-04-15 22:23:48", "city.title": "Moody", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "248": { "city.id": 248, "city.ts": "2018-04-15 22:23:48", "city.title": "Moulton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "249": { "city.id": 249, "city.ts": "2018-04-15 22:23:48", "city.title": "Moundville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "250": { "city.id": 250, "city.ts": "2018-04-15 22:23:48", "city.title": "Mount Hebron", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "251": { "city.id": 251, "city.ts": "2018-04-15 22:23:48", "city.title": "Mount Hope", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "252": { "city.id": 252, "city.ts": "2018-04-15 22:23:48", "city.title": "Mount Vernon", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "253": { "city.id": 253, "city.ts": "2018-04-15 22:23:48", "city.title": "Mountain Brook", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "254": { "city.id": 254, "city.ts": "2018-04-15 22:23:48", "city.title": "Munford", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "255": { "city.id": 255, "city.ts": "2018-04-15 22:23:48", "city.title": "Muscle Shoals", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "256": { "city.id": 256, "city.ts": "2018-04-15 22:23:48", "city.title": "Natural Bridge", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "257": { "city.id": 257, "city.ts": "2018-04-15 22:23:48", "city.title": "Nauvoo", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "258": { "city.id": 258, "city.ts": "2018-04-15 22:23:48", "city.title": "Nesmith-cullman", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "259": { "city.id": 259, "city.ts": "2018-04-15 22:23:48", "city.title": "New Brockton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "260": { "city.id": 260, "city.ts": "2018-04-15 22:23:48", "city.title": "New Hope", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "261": { "city.id": 261, "city.ts": "2018-04-15 22:23:48", "city.title": "New Market", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "262": { "city.id": 262, "city.ts": "2018-04-15 22:23:48", "city.title": "New Site", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "263": { "city.id": 263, "city.ts": "2018-04-15 22:23:48", "city.title": "Newton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "264": { "city.id": 264, "city.ts": "2018-04-15 22:23:48", "city.title": "Newville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "265": { "city.id": 265, "city.ts": "2018-04-15 22:23:48", "city.title": "Northport", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "266": { "city.id": 266, "city.ts": "2018-04-15 22:23:48", "city.title": "Notasulga", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "267": { "city.id": 267, "city.ts": "2018-04-15 22:23:48", "city.title": "Oakman", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "268": { "city.id": 268, "city.ts": "2018-04-15 22:23:48", "city.title": "Odenville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "269": { "city.id": 269, "city.ts": "2018-04-15 22:23:48", "city.title": "Ohatchee", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "270": { "city.id": 270, "city.ts": "2018-04-15 22:23:48", "city.title": "Ono Island", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "271": { "city.id": 271, "city.ts": "2018-04-15 22:23:48", "city.title": "Opelika", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "272": { "city.id": 272, "city.ts": "2018-04-15 22:23:48", "city.title": "Opp", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "273": { "city.id": 273, "city.ts": "2018-04-15 22:23:48", "city.title": "Orange Beach", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "274": { "city.id": 274, "city.ts": "2018-04-15 22:23:48", "city.title": "Owens Cross Roads", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "275": { "city.id": 275, "city.ts": "2018-04-15 22:23:48", "city.title": "Oxford", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "276": { "city.id": 276, "city.ts": "2018-04-15 22:23:48", "city.title": "Ozark", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "277": { "city.id": 277, "city.ts": "2018-04-15 22:23:48", "city.title": "Panola", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "278": { "city.id": 278, "city.ts": "2018-04-15 22:23:48", "city.title": "Parrish", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "279": { "city.id": 279, "city.ts": "2018-04-15 22:23:48", "city.title": "Patsburg", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "280": { "city.id": 280, "city.ts": "2018-04-15 22:23:48", "city.title": "Pelham", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "281": { "city.id": 281, "city.ts": "2018-04-15 22:23:48", "city.title": "Pell City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "282": { "city.id": 282, "city.ts": "2018-04-15 22:23:48", "city.title": "Perdido", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "283": { "city.id": 283, "city.ts": "2018-04-15 22:23:48", "city.title": "Perote", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "284": { "city.id": 284, "city.ts": "2018-04-15 22:23:48", "city.title": "Peterson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "285": { "city.id": 285, "city.ts": "2018-04-15 22:23:48", "city.title": "Petrey", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "286": { "city.id": 286, "city.ts": "2018-04-15 22:23:48", "city.title": "Phenix City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "287": { "city.id": 287, "city.ts": "2018-04-15 22:23:48", "city.title": "Phil Campbell", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "288": { "city.id": 288, "city.ts": "2018-04-15 22:23:48", "city.title": "Pickensville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "289": { "city.id": 289, "city.ts": "2018-04-15 22:23:48", "city.title": "Pike Road", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "290": { "city.id": 290, "city.ts": "2018-04-15 22:23:48", "city.title": "Pinckard", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "291": { "city.id": 291, "city.ts": "2018-04-15 22:23:48", "city.title": "Pinegrove", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "292": { "city.id": 292, "city.ts": "2018-04-15 22:23:48", "city.title": "Pinson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "293": { "city.id": 293, "city.ts": "2018-04-15 22:23:48", "city.title": "Pleasant Grove", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "294": { "city.id": 294, "city.ts": "2018-04-15 22:23:48", "city.title": "Pleasant Home", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "295": { "city.id": 295, "city.ts": "2018-04-15 22:23:48", "city.title": "Point Clear", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "296": { "city.id": 296, "city.ts": "2018-04-15 22:23:48", "city.title": "Prattville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "297": { "city.id": 297, "city.ts": "2018-04-15 22:23:48", "city.title": "Priceville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "298": { "city.id": 298, "city.ts": "2018-04-15 22:23:48", "city.title": "Ragland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "299": { "city.id": 299, "city.ts": "2018-04-15 22:23:48", "city.title": "Rainbow City", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "300": { "city.id": 300, "city.ts": "2018-04-15 22:23:48", "city.title": "Rainsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" } } } }