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": 200 }, "api": { "title": "Flower Shop of United States_1", "point": { "title": "By Table", "desc": "Each API function returns data by 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_of_united_states_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/by_table/city_x_flower_shop/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/by_table/city_x_flower_shop/3/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/by_table/city_x_flower_shop/5/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 4, "limit": 30, "limit_total": 200, "time": 0.0033200000000000000344169137633798527531325817108154296875 }, "stats": { "raw_rows": 30, "rows": 30, "rows_total": 14506, "pages_total": 484 }, "struct": { "stem": { "0": "city_x_flower_shop", "1": "city", "2": "category_2", "3": "state", "4": "flower_shop" }, "leaf": "city_x_flower_shop.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "87": { "city_x_flower_shop.id": 87, "city.id": 44, "city.ts": "2018-04-13 03:07:45", "city.title": "Childersburg", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 87, "flower_shop.ts": "2018-04-15 22:44:05", "flower_shop.title": "Forget-Me-Not Flowers & Gifts", "flower_shop.street": "32499 US Highway 280", "flower_shop.address": "Childersburg, AL 35044", "flower_shop.phone": "256-378-5480" }, "88": { "city_x_flower_shop.id": 88, "city.id": 44, "city.ts": "2018-04-13 03:07:45", "city.title": "Childersburg", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 88, "flower_shop.ts": "2018-04-15 22:44:05", "flower_shop.title": "Ribbons & Roses", "flower_shop.street": "33606 US Highway 280", "flower_shop.address": "Childersburg, AL 35044", "flower_shop.phone": "256-346-3422" }, "89": { "city_x_flower_shop.id": 89, "city.id": 45, "city.ts": "2018-04-13 03:07:45", "city.title": "Citronelle", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 89, "flower_shop.ts": "2018-04-15 22:44:15", "flower_shop.title": "Jeanna's Flower Shop", "flower_shop.street": "19245 N 3rd St", "flower_shop.address": "Citronelle, AL 36522", "flower_shop.phone": "251-866-9775" }, "90": { "city_x_flower_shop.id": 90, "city.id": 46, "city.ts": "2018-04-13 03:07:45", "city.title": "Clanton", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 90, "flower_shop.ts": "2018-04-15 22:44:21", "flower_shop.title": "Pinedale Gardens", "flower_shop.street": "404 Lay Dam Rd", "flower_shop.address": "Clanton, AL 35045", "flower_shop.phone": "205-755-3480" }, "91": { "city_x_flower_shop.id": 91, "city.id": 46, "city.ts": "2018-04-13 03:07:45", "city.title": "Clanton", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 91, "flower_shop.ts": "2018-04-15 22:44:21", "flower_shop.title": "Clanton Florist", "flower_shop.street": "2009 4th Ave N", "flower_shop.address": "Clanton, AL 35045", "flower_shop.phone": "205-755-4358" }, "14499": { "city_x_flower_shop.id": 14499, "city.id": 47, "city.ts": "2018-04-13 03:07:45", "city.title": "Clayton", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 5, "flower_shop.ts": "2018-04-15 22:37:52", "flower_shop.title": "House Of Flowers", "flower_shop.street": "30524 Highway 278", "flower_shop.address": "Addison, AL 35540", "flower_shop.phone": "256-747-1635" }, "92": { "city_x_flower_shop.id": 92, "city.id": 48, "city.ts": "2018-04-13 03:07:45", "city.title": "Cleveland", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 92, "flower_shop.ts": "2018-04-15 22:44:47", "flower_shop.title": "Blackwood Crossing Florist", "flower_shop.street": "62475 US Highway 231", "flower_shop.address": "Cleveland, AL 35049", "flower_shop.phone": "205-274-7678" }, "14500": { "city_x_flower_shop.id": 14500, "city.id": 50, "city.ts": "2018-04-13 03:07:45", "city.title": "Collinsville", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 6, "flower_shop.ts": "2018-04-15 22:37:54", "flower_shop.title": "Flowerz N More", "flower_shop.street": "76 Fulton Springs Rd #B", "flower_shop.address": "Alabaster, AL 35007", "flower_shop.phone": "205-620-0000" }, "14501": { "city_x_flower_shop.id": 14501, "city.id": 51, "city.ts": "2018-04-13 03:07:45", "city.title": "Columbiana", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 7, "flower_shop.ts": "2018-04-15 22:37:54", "flower_shop.title": "Alabaster Florist", "flower_shop.street": "117 1st St N", "flower_shop.address": "Alabaster, AL 35007", "flower_shop.phone": "205-663-0529" }, "14502": { "city_x_flower_shop.id": 14502, "city.id": 51, "city.ts": "2018-04-13 03:07:45", "city.title": "Columbiana", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 8, "flower_shop.ts": "2018-04-15 22:37:59", "flower_shop.title": "Silver Rabbit Flowers & Gifts", "flower_shop.street": "401 Martling Rd", "flower_shop.address": "Albertville, AL 35951", "flower_shop.phone": "256-660-1115" }, "93": { "city_x_flower_shop.id": 93, "city.id": 52, "city.ts": "2018-04-13 03:07:45", "city.title": "Cordova", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 93, "flower_shop.ts": "2018-04-15 22:45:08", "flower_shop.title": "Hilltop Flowers", "flower_shop.street": "6830 Highway 78", "flower_shop.address": "Cordova, AL 35550", "flower_shop.phone": "205-648-7350" }, "94": { "city_x_flower_shop.id": 94, "city.id": 52, "city.ts": "2018-04-13 03:07:45", "city.title": "Cordova", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 94, "flower_shop.ts": "2018-04-15 22:45:08", "flower_shop.title": "The Flower Pot", "flower_shop.street": "3983 Massachusetts Ave N", "flower_shop.address": "Cordova, AL 35550", "flower_shop.phone": "205-483-8988" }, "95": { "city_x_flower_shop.id": 95, "city.id": 53, "city.ts": "2018-04-13 03:07:45", "city.title": "Creola", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 95, "flower_shop.ts": "2018-04-15 22:45:11", "flower_shop.title": "Tonya's Floral & Gift", "flower_shop.street": "9755 Highway 43 #B", "flower_shop.address": "Creola, AL 36525", "flower_shop.phone": "251-675-6559" }, "96": { "city_x_flower_shop.id": 96, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 96, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Cullman Florist", "flower_shop.street": "111 1st St NE #A", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-734-0263" }, "97": { "city_x_flower_shop.id": 97, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 97, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Burke's Florist", "flower_shop.street": "109 4th Ave NE", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-734-1323" }, "98": { "city_x_flower_shop.id": 98, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 98, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Water Valley Florist", "flower_shop.street": "13077 US Highway 278 W", "flower_shop.address": "Cullman, AL 35057", "flower_shop.phone": "256-747-4044" }, "99": { "city_x_flower_shop.id": 99, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 99, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Mary's Flower Market", "flower_shop.street": "302 1st Ave NW", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-734-3894" }, "100": { "city_x_flower_shop.id": 100, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 100, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "City Florist", "flower_shop.street": "1844 2nd Ave NW", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-739-6550" }, "101": { "city_x_flower_shop.id": 101, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 101, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Ring Around The Roses Floral", "flower_shop.street": "209 1st Ave SW #A", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-739-1176" }, "102": { "city_x_flower_shop.id": 102, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 102, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Town House Florist, Inc", "flower_shop.street": "223 2nd Ave SW #A", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-734-7770" }, "103": { "city_x_flower_shop.id": 103, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 103, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "Fairview Florist", "flower_shop.street": "312 2nd Ave SE", "flower_shop.address": "Cullman, AL 35055", "flower_shop.phone": "256-739-0315" }, "104": { "city_x_flower_shop.id": 104, "city.id": 55, "city.ts": "2018-04-13 03:07:45", "city.title": "Cullman", "city.category_2": "C", "category_2.id": 3, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "C", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 104, "flower_shop.ts": "2018-04-15 22:45:21", "flower_shop.title": "The Flower Store", "flower_shop.street": "2285 US Highway 278 W", "flower_shop.address": "Cullman, AL 35057", "flower_shop.phone": "256-739-5083" }, "105": { "city_x_flower_shop.id": 105, "city.id": 57, "city.ts": "2018-04-13 03:07:49", "city.title": "Dadeville", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 105, "flower_shop.ts": "2018-04-15 22:45:38", "flower_shop.title": "Lakay's Unique Designs", "flower_shop.street": "368 E South St", "flower_shop.address": "Dadeville, AL 36853", "flower_shop.phone": "256-825-2890" }, "106": { "city_x_flower_shop.id": 106, "city.id": 57, "city.ts": "2018-04-13 03:07:49", "city.title": "Dadeville", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 106, "flower_shop.ts": "2018-04-15 22:45:38", "flower_shop.title": "Pearson's Flowers & Gifts", "flower_shop.street": "127 N Tallassee St", "flower_shop.address": "Dadeville, AL 36853", "flower_shop.phone": "256-825-6267" }, "107": { "city_x_flower_shop.id": 107, "city.id": 58, "city.ts": "2018-04-13 03:07:49", "city.title": "Danville", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 107, "flower_shop.ts": "2018-04-15 22:45:51", "flower_shop.title": "Millie's Flowers", "flower_shop.street": "5522 Highway 36 W", "flower_shop.address": "Danville, AL 35619", "flower_shop.phone": "256-773-6515" }, "108": { "city_x_flower_shop.id": 108, "city.id": 59, "city.ts": "2018-04-13 03:07:49", "city.title": "Daphne", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 108, "flower_shop.ts": "2018-04-15 22:46:14", "flower_shop.title": "Flowers Etc", "flower_shop.street": "697 US Highway 98 S #A", "flower_shop.address": "Daphne, AL 36526", "flower_shop.phone": "251-626-6323" }, "109": { "city_x_flower_shop.id": 109, "city.id": 59, "city.ts": "2018-04-13 03:07:49", "city.title": "Daphne", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 109, "flower_shop.ts": "2018-04-15 22:46:14", "flower_shop.title": "Windsor Florist", "flower_shop.street": "28600 US Highway 98", "flower_shop.address": "Daphne, AL 36526", "flower_shop.phone": "251-626-0119" }, "110": { "city_x_flower_shop.id": 110, "city.id": 59, "city.ts": "2018-04-13 03:07:49", "city.title": "Daphne", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 110, "flower_shop.ts": "2018-04-15 22:46:14", "flower_shop.title": "Blooming Deals", "flower_shop.street": "2001 US Highway 98", "flower_shop.address": "Daphne, AL 36526", "flower_shop.phone": "251-625-4111" }, "111": { "city_x_flower_shop.id": 111, "city.id": 61, "city.ts": "2018-04-13 03:07:49", "city.title": "Dauphin Island", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 111, "flower_shop.ts": "2018-04-15 22:46:24", "flower_shop.title": "Island Florist", "flower_shop.street": "113 Dewberry St", "flower_shop.address": "Dauphin Island, AL 36528", "flower_shop.phone": "251-861-2694" }, "112": { "city_x_flower_shop.id": 112, "city.id": 63, "city.ts": "2018-04-13 03:07:49", "city.title": "Decatur", "city.category_2": "D", "category_2.id": 4, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "D", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama", "flower_shop.id": 112, "flower_shop.ts": "2018-04-15 22:46:45", "flower_shop.title": "Simpson's Florist", "flower_shop.street": "902 6th Ave SE", "flower_shop.address": "Decatur, AL 35601", "flower_shop.phone": "256-353-7654" } } } }