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 of United States_1", "point": { "title": "Main", "desc": "Main access point of this API. " } }, "input": {}, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/main/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/main/list/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/flower_shop_of_united_states_1/main/list/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 20, "limit_total": 400, "time": 0.0019699999999999999629463065531354004633612930774688720703125 }, "stats": { "raw_rows": 20, "rows": 20, "rows_total": 14490, "pages_total": 725 }, "struct": { "stem": { "0": "flower_shop" }, "leaf": "flower_shop.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "flower_shop.id": 1, "flower_shop.ts": "2018-04-15 22:37:40", "flower_shop.title": "The Flower Pot", "flower_shop.street": "515 Kirkland St", "flower_shop.address": "Abbeville, AL 36310", "flower_shop.phone": "334-585-4010", "flower_shop.city_x_flower_shop_id": { "1": { "city_x_flower_shop.id": 1, "city.id": 1, "city.ts": "2018-04-13 03:07:37", "city.title": "Abbeville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14495": { "city_x_flower_shop.id": 14495, "city.id": 8, "city.ts": "2018-04-13 03:07:37", "city.title": "Andalusia", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "2": { "flower_shop.id": 2, "flower_shop.ts": "2018-04-15 22:37:40", "flower_shop.title": "Elaine's Florist", "flower_shop.street": "409 Kirkland St", "flower_shop.address": "Abbeville, AL 36310", "flower_shop.phone": "334-585-3808", "flower_shop.city_x_flower_shop_id": { "2": { "city_x_flower_shop.id": 2, "city.id": 1, "city.ts": "2018-04-13 03:07:37", "city.title": "Abbeville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14496": { "city_x_flower_shop.id": 14496, "city.id": 8, "city.ts": "2018-04-13 03:07:37", "city.title": "Andalusia", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "3": { "flower_shop.id": 3, "flower_shop.ts": "2018-04-15 22:37:47", "flower_shop.title": "Adamsville Florist", "flower_shop.street": "3605 Gray Ave", "flower_shop.address": "Adamsville, AL 35005", "flower_shop.phone": "205-674-5638", "flower_shop.city_x_flower_shop_id": { "3": { "city_x_flower_shop.id": 3, "city.id": 2, "city.ts": "2018-04-13 03:07:37", "city.title": "Adamsville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14497": { "city_x_flower_shop.id": 14497, "city.id": 8, "city.ts": "2018-04-13 03:07:37", "city.title": "Andalusia", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "4": { "flower_shop.id": 4, "flower_shop.ts": "2018-04-15 22:37:52", "flower_shop.title": "Addison Floral & Gift", "flower_shop.street": "30639 Highway 278", "flower_shop.address": "Addison, AL 35540", "flower_shop.phone": "256-747-8400", "flower_shop.city_x_flower_shop_id": { "4": { "city_x_flower_shop.id": 4, "city.id": 3, "city.ts": "2018-04-13 03:07:37", "city.title": "Addison", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14498": { "city_x_flower_shop.id": 14498, "city.id": 35, "city.ts": "2018-04-13 03:07:38", "city.title": "Butler", "city.category_2": "B", "category_2.id": 2, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "B", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "5": { "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", "flower_shop.city_x_flower_shop_id": { "5": { "city_x_flower_shop.id": 5, "city.id": 3, "city.ts": "2018-04-13 03:07:37", "city.title": "Addison", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "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" } } }, "6": { "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", "flower_shop.city_x_flower_shop_id": { "6": { "city_x_flower_shop.id": 6, "city.id": 4, "city.ts": "2018-04-13 03:07:37", "city.title": "Alabaster", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "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" } } }, "7": { "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", "flower_shop.city_x_flower_shop_id": { "7": { "city_x_flower_shop.id": 7, "city.id": 4, "city.ts": "2018-04-13 03:07:37", "city.title": "Alabaster", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "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" } } }, "8": { "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", "flower_shop.city_x_flower_shop_id": { "8": { "city_x_flower_shop.id": 8, "city.id": 5, "city.ts": "2018-04-13 03:07:37", "city.title": "Albertville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "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" } } }, "9": { "flower_shop.id": 9, "flower_shop.ts": "2018-04-15 22:37:59", "flower_shop.title": "D Wright Designs", "flower_shop.street": "221 Rose Rd", "flower_shop.address": "Albertville, AL 35950", "flower_shop.phone": "256-878-0221", "flower_shop.city_x_flower_shop_id": { "9": { "city_x_flower_shop.id": 9, "city.id": 5, "city.ts": "2018-04-13 03:07:37", "city.title": "Albertville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14503": { "city_x_flower_shop.id": 14503, "city.id": 76, "city.ts": "2018-04-13 03:07:50", "city.title": "Ensley", "city.category_2": "E", "category_2.id": 5, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "E", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "10": { "flower_shop.id": 10, "flower_shop.ts": "2018-04-15 22:37:59", "flower_shop.title": "Blooms On Main, LLC", "flower_shop.street": "106 E Main St", "flower_shop.address": "Albertville, AL 35950", "flower_shop.phone": "256-878-0988", "flower_shop.city_x_flower_shop_id": { "10": { "city_x_flower_shop.id": 10, "city.id": 5, "city.ts": "2018-04-13 03:07:37", "city.title": "Albertville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14504": { "city_x_flower_shop.id": 14504, "city.id": 83, "city.ts": "2018-04-13 03:07:58", "city.title": "Fairhope", "city.category_2": "F", "category_2.id": 6, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "F", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "11": { "flower_shop.id": 11, "flower_shop.ts": "2018-04-15 22:37:59", "flower_shop.title": "The Flower Market", "flower_shop.street": "109 S Carlisle St", "flower_shop.address": "Albertville, AL 35950", "flower_shop.phone": "256-878-8712", "flower_shop.city_x_flower_shop_id": { "11": { "city_x_flower_shop.id": 11, "city.id": 5, "city.ts": "2018-04-13 03:07:37", "city.title": "Albertville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14505": { "city_x_flower_shop.id": 14505, "city.id": 83, "city.ts": "2018-04-13 03:07:58", "city.title": "Fairhope", "city.category_2": "F", "category_2.id": 6, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "F", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "12": { "flower_shop.id": 12, "flower_shop.ts": "2018-04-15 22:38:04", "flower_shop.title": "Grace's Flowers", "flower_shop.street": "951 Hillabee St", "flower_shop.address": "Alexander City, AL 35010", "flower_shop.phone": "256-234-4238", "flower_shop.city_x_flower_shop_id": { "12": { "city_x_flower_shop.id": 12, "city.id": 6, "city.ts": "2018-04-13 03:07:37", "city.title": "Alexander City", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" }, "14506": { "city_x_flower_shop.id": 14506, "city.id": 83, "city.ts": "2018-04-13 03:07:58", "city.title": "Fairhope", "city.category_2": "F", "category_2.id": 6, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "F", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "13": { "flower_shop.id": 13, "flower_shop.ts": "2018-04-15 22:38:04", "flower_shop.title": "Alexander City Flower Boutique", "flower_shop.street": "1031 Cherokee Rd", "flower_shop.address": "Alexander City, AL 35010", "flower_shop.phone": "256-234-3424", "flower_shop.city_x_flower_shop_id": { "13": { "city_x_flower_shop.id": 13, "city.id": 6, "city.ts": "2018-04-13 03:07:37", "city.title": "Alexander City", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "14": { "flower_shop.id": 14, "flower_shop.ts": "2018-04-15 22:38:09", "flower_shop.title": "Bonita's Flowers", "flower_shop.street": "111 Broad St NW", "flower_shop.address": "Aliceville, AL 35442", "flower_shop.phone": "205-373-6036", "flower_shop.city_x_flower_shop_id": { "14": { "city_x_flower_shop.id": 14, "city.id": 7, "city.ts": "2018-04-13 03:07:37", "city.title": "Aliceville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "15": { "flower_shop.id": 15, "flower_shop.ts": "2018-04-15 22:38:09", "flower_shop.title": "Aline's Flower Shop", "flower_shop.street": "307 Mobile Rd SW", "flower_shop.address": "Aliceville, AL 35442", "flower_shop.phone": "205-373-2297", "flower_shop.city_x_flower_shop_id": { "15": { "city_x_flower_shop.id": 15, "city.id": 7, "city.ts": "2018-04-13 03:07:37", "city.title": "Aliceville", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "16": { "flower_shop.id": 16, "flower_shop.ts": "2018-04-15 22:38:20", "flower_shop.title": "Gifts From The Heart", "flower_shop.street": "6293 Highway 207", "flower_shop.address": "Anderson, AL 35610", "flower_shop.phone": "256-247-5757", "flower_shop.city_x_flower_shop_id": { "16": { "city_x_flower_shop.id": 16, "city.id": 9, "city.ts": "2018-04-13 03:07:37", "city.title": "Anderson", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "17": { "flower_shop.id": 17, "flower_shop.ts": "2018-04-15 22:38:31", "flower_shop.title": "D & D Gift Shop & Florist", "flower_shop.street": "2403 AL Highway 202", "flower_shop.address": "Anniston, AL 36201", "flower_shop.phone": "256-237-1780", "flower_shop.city_x_flower_shop_id": { "17": { "city_x_flower_shop.id": 17, "city.id": 10, "city.ts": "2018-04-13 03:07:37", "city.title": "Anniston", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "18": { "flower_shop.id": 18, "flower_shop.ts": "2018-04-15 22:38:31", "flower_shop.title": "Alana's Flower Shop", "flower_shop.street": "280 E Glade Rd", "flower_shop.address": "Anniston, AL 32606", "flower_shop.phone": "256-240-2995", "flower_shop.city_x_flower_shop_id": { "18": { "city_x_flower_shop.id": 18, "city.id": 10, "city.ts": "2018-04-13 03:07:37", "city.title": "Anniston", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "19": { "flower_shop.id": 19, "flower_shop.ts": "2018-04-15 22:38:31", "flower_shop.title": "Jackie's Floral Gallery", "flower_shop.street": "2115 US Highway 78 E #3", "flower_shop.address": "Anniston, AL 36207", "flower_shop.phone": "256-835-0028", "flower_shop.city_x_flower_shop_id": { "19": { "city_x_flower_shop.id": 19, "city.id": 10, "city.ts": "2018-04-13 03:07:37", "city.title": "Anniston", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } }, "20": { "flower_shop.id": 20, "flower_shop.ts": "2018-04-15 22:38:31", "flower_shop.title": "Lenlock Flowers & Gifts", "flower_shop.street": "280 E Glade Rd", "flower_shop.address": "Anniston, AL 36206", "flower_shop.phone": "256-403-5401", "flower_shop.city_x_flower_shop_id": { "20": { "city_x_flower_shop.id": 20, "city.id": 10, "city.ts": "2018-04-13 03:07:37", "city.title": "Anniston", "city.category_2": "A", "category_2.id": 1, "category_2.ts": "2018-04-13 02:50:37", "category_2.title": "A", "category_2.state": "Alabama", "state.id": 1, "state.ts": "2018-04-13 02:41:10", "state.title": "Alabama" } } } } } }