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 in the United States and Canada_3", "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_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": 50, "limit_total": 200, "time": 0.0139500000000000005939693181744587491266429424285888671875 }, "stats": { "raw_rows": 50, "rows": 50, "rows_total": 19412, "pages_total": 389 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "101": { "city.id": 101, "city.ts": "2018-04-15 22:23:48", "city.title": "Delmar", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "102": { "city.id": 102, "city.ts": "2018-04-15 22:23:48", "city.title": "Dora", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "103": { "city.id": 103, "city.ts": "2018-04-15 22:23:48", "city.title": "Dothan", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "104": { "city.id": 104, "city.ts": "2018-04-15 22:23:48", "city.title": "Double Springs", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "105": { "city.id": 105, "city.ts": "2018-04-15 22:23:48", "city.title": "Dozier", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "106": { "city.id": 106, "city.ts": "2018-04-15 22:23:48", "city.title": "Duncanville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "107": { "city.id": 107, "city.ts": "2018-04-15 22:23:48", "city.title": "Dutton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "108": { "city.id": 108, "city.ts": "2018-04-15 22:23:48", "city.title": "Eastaboga", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "109": { "city.id": 109, "city.ts": "2018-04-15 22:23:48", "city.title": "Eclectic", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "110": { "city.id": 110, "city.ts": "2018-04-15 22:23:48", "city.title": "Edwardsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "111": { "city.id": 111, "city.ts": "2018-04-15 22:23:48", "city.title": "Edwin", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "112": { "city.id": 112, "city.ts": "2018-04-15 22:23:48", "city.title": "Elba", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "113": { "city.id": 113, "city.ts": "2018-04-15 22:23:48", "city.title": "Elberta", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "114": { "city.id": 114, "city.ts": "2018-04-15 22:23:48", "city.title": "Elkmont", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "115": { "city.id": 115, "city.ts": "2018-04-15 22:23:48", "city.title": "Enterprise", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "116": { "city.id": 116, "city.ts": "2018-04-15 22:23:48", "city.title": "Ethelsville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "117": { "city.id": 117, "city.ts": "2018-04-15 22:23:48", "city.title": "Eufaula", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "118": { "city.id": 118, "city.ts": "2018-04-15 22:23:48", "city.title": "Eutaw", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "119": { "city.id": 119, "city.ts": "2018-04-15 22:23:48", "city.title": "Eva", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "120": { "city.id": 120, "city.ts": "2018-04-15 22:23:48", "city.title": "Evergreen", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "121": { "city.id": 121, "city.ts": "2018-04-15 22:23:48", "city.title": "Fackler", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "122": { "city.id": 122, "city.ts": "2018-04-15 22:23:48", "city.title": "Fairfield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "123": { "city.id": 123, "city.ts": "2018-04-15 22:23:48", "city.title": "Fairhope", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "124": { "city.id": 124, "city.ts": "2018-04-15 22:23:48", "city.title": "Fairview", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "125": { "city.id": 125, "city.ts": "2018-04-15 22:23:48", "city.title": "Fayette", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "126": { "city.id": 126, "city.ts": "2018-04-15 22:23:48", "city.title": "Fitzpatrick", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "127": { "city.id": 127, "city.ts": "2018-04-15 22:23:48", "city.title": "Flomaton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "128": { "city.id": 128, "city.ts": "2018-04-15 22:23:48", "city.title": "Florence", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "129": { "city.id": 129, "city.ts": "2018-04-15 22:23:48", "city.title": "Foley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "130": { "city.id": 130, "city.ts": "2018-04-15 22:23:48", "city.title": "Forest Home", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "131": { "city.id": 131, "city.ts": "2018-04-15 22:23:48", "city.title": "Forestdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "132": { "city.id": 132, "city.ts": "2018-04-15 22:23:48", "city.title": "Forkland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "133": { "city.id": 133, "city.ts": "2018-04-15 22:23:48", "city.title": "Fort Davis", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "134": { "city.id": 134, "city.ts": "2018-04-15 22:23:48", "city.title": "Fort Deposit", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "135": { "city.id": 135, "city.ts": "2018-04-15 22:23:48", "city.title": "Fort Mitchell", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "136": { "city.id": 136, "city.ts": "2018-04-15 22:23:48", "city.title": "Fort Payne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "137": { "city.id": 137, "city.ts": "2018-04-15 22:23:48", "city.title": "Fort Rucker", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "138": { "city.id": 138, "city.ts": "2018-04-15 22:23:48", "city.title": "Fosters", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "139": { "city.id": 139, "city.ts": "2018-04-15 22:23:48", "city.title": "Fruithurst", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "140": { "city.id": 140, "city.ts": "2018-04-15 22:23:48", "city.title": "Fultondale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "141": { "city.id": 141, "city.ts": "2018-04-15 22:23:48", "city.title": "Fyffe", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "142": { "city.id": 142, "city.ts": "2018-04-15 22:23:48", "city.title": "Gadsden", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "143": { "city.id": 143, "city.ts": "2018-04-15 22:23:48", "city.title": "Gainesville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "144": { "city.id": 144, "city.ts": "2018-04-15 22:23:48", "city.title": "Gantt", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "145": { "city.id": 145, "city.ts": "2018-04-15 22:23:48", "city.title": "Gardendale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "146": { "city.id": 146, "city.ts": "2018-04-15 22:23:48", "city.title": "Geneva", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "147": { "city.id": 147, "city.ts": "2018-04-15 22:23:48", "city.title": "Georgiana", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "148": { "city.id": 148, "city.ts": "2018-04-15 22:23:48", "city.title": "Geraldine", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "149": { "city.id": 149, "city.ts": "2018-04-15 22:23:48", "city.title": "Glencoe", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "150": { "city.id": 150, "city.ts": "2018-04-15 22:23:48", "city.title": "Glenwood", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" } } } }