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/3/?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/5/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 4, "limit": 100, "limit_total": 400, "time": 0.00144000000000000009069134332406747489585541188716888427734375 }, "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": { "301": { "city.id": 301, "city.ts": "2018-04-15 22:23:48", "city.title": "Ramer", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "302": { "city.id": 302, "city.ts": "2018-04-15 22:23:48", "city.title": "Ranburne", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "303": { "city.id": 303, "city.ts": "2018-04-15 22:23:48", "city.title": "Randolph", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "304": { "city.id": 304, "city.ts": "2018-04-15 22:23:48", "city.title": "Red Bay", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "305": { "city.id": 305, "city.ts": "2018-04-15 22:23:48", "city.title": "Red Level", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "306": { "city.id": 306, "city.ts": "2018-04-15 22:23:48", "city.title": "Redstone Arsenal", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "307": { "city.id": 307, "city.ts": "2018-04-15 22:23:48", "city.title": "Reform", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "308": { "city.id": 308, "city.ts": "2018-04-15 22:23:48", "city.title": "Rehobeth", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "309": { "city.id": 309, "city.ts": "2018-04-15 22:23:48", "city.title": "River Falls", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "310": { "city.id": 310, "city.ts": "2018-04-15 22:23:48", "city.title": "Riverchase", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "311": { "city.id": 311, "city.ts": "2018-04-15 22:23:48", "city.title": "Riverside", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "312": { "city.id": 312, "city.ts": "2018-04-15 22:23:48", "city.title": "Roanoke", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "313": { "city.id": 313, "city.ts": "2018-04-15 22:23:48", "city.title": "Robertsdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "314": { "city.id": 314, "city.ts": "2018-04-15 22:23:48", "city.title": "Rockford", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "315": { "city.id": 315, "city.ts": "2018-04-15 22:23:48", "city.title": "Roebuck", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "316": { "city.id": 316, "city.ts": "2018-04-15 22:23:48", "city.title": "Rogersville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "317": { "city.id": 317, "city.ts": "2018-04-15 22:23:48", "city.title": "Russellville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "318": { "city.id": 318, "city.ts": "2018-04-15 22:23:48", "city.title": "Rutledge", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "319": { "city.id": 319, "city.ts": "2018-04-15 22:23:48", "city.title": "Saint Elmo", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "320": { "city.id": 320, "city.ts": "2018-04-15 22:23:48", "city.title": "Saks", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "321": { "city.id": 321, "city.ts": "2018-04-15 22:23:48", "city.title": "Salem", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "322": { "city.id": 322, "city.ts": "2018-04-15 22:23:48", "city.title": "Samson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "323": { "city.id": 323, "city.ts": "2018-04-15 22:23:48", "city.title": "Saraland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "324": { "city.id": 324, "city.ts": "2018-04-15 22:23:48", "city.title": "Satsuma", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "325": { "city.id": 325, "city.ts": "2018-04-15 22:23:48", "city.title": "Scottsboro", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "326": { "city.id": 326, "city.ts": "2018-04-15 22:23:48", "city.title": "Seale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "327": { "city.id": 327, "city.ts": "2018-04-15 22:23:48", "city.title": "Section", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "328": { "city.id": 328, "city.ts": "2018-04-15 22:23:48", "city.title": "Selma", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "329": { "city.id": 329, "city.ts": "2018-04-15 22:23:48", "city.title": "Seminole", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "330": { "city.id": 330, "city.ts": "2018-04-15 22:23:48", "city.title": "Semmes", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "331": { "city.id": 331, "city.ts": "2018-04-15 22:23:48", "city.title": "Sheffield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "332": { "city.id": 332, "city.ts": "2018-04-15 22:23:48", "city.title": "Shorter", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "333": { "city.id": 333, "city.ts": "2018-04-15 22:23:48", "city.title": "Shorterville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "334": { "city.id": 334, "city.ts": "2018-04-15 22:23:48", "city.title": "Silverhill", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "335": { "city.id": 335, "city.ts": "2018-04-15 22:23:48", "city.title": "Sipsey", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "336": { "city.id": 336, "city.ts": "2018-04-15 22:23:48", "city.title": "Skipperville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "337": { "city.id": 337, "city.ts": "2018-04-15 22:23:48", "city.title": "Skyline", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "338": { "city.id": 338, "city.ts": "2018-04-15 22:23:48", "city.title": "Slocomb", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "339": { "city.id": 339, "city.ts": "2018-04-15 22:23:48", "city.title": "Smiths Station", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "340": { "city.id": 340, "city.ts": "2018-04-15 22:23:48", "city.title": "Somerville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "341": { "city.id": 341, "city.ts": "2018-04-15 22:23:48", "city.title": "Southside", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "342": { "city.id": 342, "city.ts": "2018-04-15 22:23:48", "city.title": "Spanish Fort", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "343": { "city.id": 343, "city.ts": "2018-04-15 22:23:48", "city.title": "Springville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "344": { "city.id": 344, "city.ts": "2018-04-15 22:23:48", "city.title": "Stapleton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "345": { "city.id": 345, "city.ts": "2018-04-15 22:23:48", "city.title": "Sterrett", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "346": { "city.id": 346, "city.ts": "2018-04-15 22:23:48", "city.title": "Stevenson", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "347": { "city.id": 347, "city.ts": "2018-04-15 22:23:48", "city.title": "Stockton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "348": { "city.id": 348, "city.ts": "2018-04-15 22:23:48", "city.title": "Straughn", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "349": { "city.id": 349, "city.ts": "2018-04-15 22:23:48", "city.title": "Sulligent", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "350": { "city.id": 350, "city.ts": "2018-04-15 22:23:48", "city.title": "Sumiton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "351": { "city.id": 351, "city.ts": "2018-04-15 22:23:48", "city.title": "Summerdale", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "352": { "city.id": 352, "city.ts": "2018-04-15 22:23:48", "city.title": "Sycamore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "353": { "city.id": 353, "city.ts": "2018-04-15 22:23:48", "city.title": "Sylacauga", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "354": { "city.id": 354, "city.ts": "2018-04-15 22:23:48", "city.title": "Sylvania", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "355": { "city.id": 355, "city.ts": "2018-04-15 22:23:48", "city.title": "Talladega", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "356": { "city.id": 356, "city.ts": "2018-04-15 22:23:48", "city.title": "Tallassee", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "357": { "city.id": 357, "city.ts": "2018-04-15 22:23:48", "city.title": "Tanner", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "358": { "city.id": 358, "city.ts": "2018-04-15 22:23:48", "city.title": "Tarrant", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "359": { "city.id": 359, "city.ts": "2018-04-15 22:23:48", "city.title": "Taylor", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "360": { "city.id": 360, "city.ts": "2018-04-15 22:23:48", "city.title": "Theodore", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "361": { "city.id": 361, "city.ts": "2018-04-15 22:23:48", "city.title": "Thorsby", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "362": { "city.id": 362, "city.ts": "2018-04-15 22:23:48", "city.title": "Toney", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "363": { "city.id": 363, "city.ts": "2018-04-15 22:23:48", "city.title": "Town Creek", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "364": { "city.id": 364, "city.ts": "2018-04-15 22:23:48", "city.title": "Trinity", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "365": { "city.id": 365, "city.ts": "2018-04-15 22:23:48", "city.title": "Troy", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "366": { "city.id": 366, "city.ts": "2018-04-15 22:23:48", "city.title": "Trussville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "367": { "city.id": 367, "city.ts": "2018-04-15 22:23:48", "city.title": "Tuscaloosa", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "368": { "city.id": 368, "city.ts": "2018-04-15 22:23:48", "city.title": "Tuscumbia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "369": { "city.id": 369, "city.ts": "2018-04-15 22:23:48", "city.title": "Tuskegee", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "370": { "city.id": 370, "city.ts": "2018-04-15 22:23:48", "city.title": "Union Grove", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "371": { "city.id": 371, "city.ts": "2018-04-15 22:23:48", "city.title": "Union Springs", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "372": { "city.id": 372, "city.ts": "2018-04-15 22:23:48", "city.title": "Valhermoso Springs", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "373": { "city.id": 373, "city.ts": "2018-04-15 22:23:48", "city.title": "Valley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "374": { "city.id": 374, "city.ts": "2018-04-15 22:23:48", "city.title": "Valley Grande", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "375": { "city.id": 375, "city.ts": "2018-04-15 22:23:48", "city.title": "Valley Head", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "376": { "city.id": 376, "city.ts": "2018-04-15 22:23:48", "city.title": "Vance", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "377": { "city.id": 377, "city.ts": "2018-04-15 22:23:48", "city.title": "Verbena", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "378": { "city.id": 378, "city.ts": "2018-04-15 22:23:48", "city.title": "Vestavia", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "379": { "city.id": 379, "city.ts": "2018-04-15 22:23:48", "city.title": "Vestavia Hills", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "380": { "city.id": 380, "city.ts": "2018-04-15 22:23:48", "city.title": "Vina", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "381": { "city.id": 381, "city.ts": "2018-04-15 22:23:48", "city.title": "Vincent", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "382": { "city.id": 382, "city.ts": "2018-04-15 22:23:48", "city.title": "Vinemont", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "383": { "city.id": 383, "city.ts": "2018-04-15 22:23:48", "city.title": "Wadley", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "384": { "city.id": 384, "city.ts": "2018-04-15 22:23:48", "city.title": "Waverly", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "385": { "city.id": 385, "city.ts": "2018-04-15 22:23:48", "city.title": "Weaver", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "386": { "city.id": 386, "city.ts": "2018-04-15 22:23:48", "city.title": "Wedowee", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "387": { "city.id": 387, "city.ts": "2018-04-15 22:23:48", "city.title": "Weogufka", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "388": { "city.id": 388, "city.ts": "2018-04-15 22:23:48", "city.title": "West Blocton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "389": { "city.id": 389, "city.ts": "2018-04-15 22:23:48", "city.title": "West Greene", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "390": { "city.id": 390, "city.ts": "2018-04-15 22:23:48", "city.title": "West Point", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "391": { "city.id": 391, "city.ts": "2018-04-15 22:23:48", "city.title": "Wetumpka", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "392": { "city.id": 392, "city.ts": "2018-04-15 22:23:48", "city.title": "Whitehouse Forks", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "393": { "city.id": 393, "city.ts": "2018-04-15 22:23:48", "city.title": "Wilmer", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "394": { "city.id": 394, "city.ts": "2018-04-15 22:23:48", "city.title": "Wilton", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "395": { "city.id": 395, "city.ts": "2018-04-15 22:23:48", "city.title": "Winfield", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "396": { "city.id": 396, "city.ts": "2018-04-15 22:23:48", "city.title": "Woodland", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "397": { "city.id": 397, "city.ts": "2018-04-15 22:23:48", "city.title": "Woodstock", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "398": { "city.id": 398, "city.ts": "2018-04-15 22:23:48", "city.title": "Woodville", "city.state": "Alabama", "state.id": 1, "state.ts": "2018-04-15 22:13:26", "state.title": "Alabama" }, "399": { "city.id": 399, "city.ts": "2018-04-15 22:23:49", "city.title": "Anchorage", "city.state": "Alaska", "state.id": 2, "state.ts": "2018-04-15 22:13:26", "state.title": "Alaska" }, "400": { "city.id": 400, "city.ts": "2018-04-15 22:23:49", "city.title": "Angoon", "city.state": "Alaska", "state.id": 2, "state.ts": "2018-04-15 22:13:26", "state.title": "Alaska" } } } }