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": "Stop And Shop Information In USA 1", "desc": "Stop And Shop Information include location,business time & service content", "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_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/by_table/city/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_e49e7f0fcb85c5451b03/stop_and_shop_information_in_usa_1/by_table/city/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0027399999999999998141764212533644240465946495532989501953125 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 339, "pages_total": 4 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "city.id": 1, "city.ts": "2018-11-19 21:44:06", "city.title": "Ansonia", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "2": { "city.id": 2, "city.ts": "2018-11-19 21:44:06", "city.title": "Berlin", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "3": { "city.id": 3, "city.ts": "2018-11-19 21:44:06", "city.title": "Bloomfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "4": { "city.id": 4, "city.ts": "2018-11-19 21:44:06", "city.title": "Branford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "5": { "city.id": 5, "city.ts": "2018-11-19 21:44:06", "city.title": "Bridgeport", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "6": { "city.id": 6, "city.ts": "2018-11-19 21:44:06", "city.title": "Bristol", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "7": { "city.id": 7, "city.ts": "2018-11-19 21:44:06", "city.title": "Canaan", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "8": { "city.id": 8, "city.ts": "2018-11-19 21:44:06", "city.title": "Cheshire", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "9": { "city.id": 9, "city.ts": "2018-11-19 21:44:06", "city.title": "Clinton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "10": { "city.id": 10, "city.ts": "2018-11-19 21:44:06", "city.title": "Colchester", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "11": { "city.id": 11, "city.ts": "2018-11-19 21:44:06", "city.title": "Cromwell", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "12": { "city.id": 12, "city.ts": "2018-11-19 21:44:06", "city.title": "Danbury", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "13": { "city.id": 13, "city.ts": "2018-11-19 21:44:06", "city.title": "Darien", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "14": { "city.id": 14, "city.ts": "2018-11-19 21:44:06", "city.title": "Dayville", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "15": { "city.id": 15, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hampton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "16": { "city.id": 16, "city.ts": "2018-11-19 21:44:06", "city.title": "East Hartford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "17": { "city.id": 17, "city.ts": "2018-11-19 21:44:06", "city.title": "East Haven", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "18": { "city.id": 18, "city.ts": "2018-11-19 21:44:06", "city.title": "East Lyme", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "19": { "city.id": 19, "city.ts": "2018-11-19 21:44:06", "city.title": "Enfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "20": { "city.id": 20, "city.ts": "2018-11-19 21:44:06", "city.title": "Fairfield", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "21": { "city.id": 21, "city.ts": "2018-11-19 21:44:06", "city.title": "Glastonbury", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "22": { "city.id": 22, "city.ts": "2018-11-19 21:44:06", "city.title": "Granby", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "23": { "city.id": 23, "city.ts": "2018-11-19 21:44:06", "city.title": "Greenwich", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "24": { "city.id": 24, "city.ts": "2018-11-19 21:44:06", "city.title": "Groton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "25": { "city.id": 25, "city.ts": "2018-11-19 21:44:06", "city.title": "Hamden", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "26": { "city.id": 26, "city.ts": "2018-11-19 21:44:06", "city.title": "Hartford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "27": { "city.id": 27, "city.ts": "2018-11-19 21:44:06", "city.title": "Litchfield", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "28": { "city.id": 28, "city.ts": "2018-11-19 21:44:06", "city.title": "Madison", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "29": { "city.id": 29, "city.ts": "2018-11-19 21:44:06", "city.title": "Manchester", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "30": { "city.id": 30, "city.ts": "2018-11-19 21:44:06", "city.title": "Meriden", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "31": { "city.id": 31, "city.ts": "2018-11-19 21:44:06", "city.title": "Middletown", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "32": { "city.id": 32, "city.ts": "2018-11-19 21:44:06", "city.title": "Milford", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "33": { "city.id": 33, "city.ts": "2018-11-19 21:44:06", "city.title": "Monroe", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "34": { "city.id": 34, "city.ts": "2018-11-19 21:44:06", "city.title": "Naugatuck", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "35": { "city.id": 35, "city.ts": "2018-11-19 21:44:06", "city.title": "New Britain", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "36": { "city.id": 36, "city.ts": "2018-11-19 21:44:06", "city.title": "New Fairfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "37": { "city.id": 37, "city.ts": "2018-11-19 21:44:06", "city.title": "New Haven", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "38": { "city.id": 38, "city.ts": "2018-11-19 21:44:06", "city.title": "New Milford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "39": { "city.id": 39, "city.ts": "2018-11-19 21:44:06", "city.title": "Newington", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "40": { "city.id": 40, "city.ts": "2018-11-19 21:44:06", "city.title": "Newtown", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "41": { "city.id": 41, "city.ts": "2018-11-19 21:44:06", "city.title": "North Haven", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "42": { "city.id": 42, "city.ts": "2018-11-19 21:44:06", "city.title": "Norwalk", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "43": { "city.id": 43, "city.ts": "2018-11-19 21:44:06", "city.title": "Norwich", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "44": { "city.id": 44, "city.ts": "2018-11-19 21:44:06", "city.title": "Old Saybrook", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "45": { "city.id": 45, "city.ts": "2018-11-19 21:44:06", "city.title": "Pawcatuck", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "46": { "city.id": 46, "city.ts": "2018-11-19 21:44:06", "city.title": "Putnam", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "47": { "city.id": 47, "city.ts": "2018-11-19 21:44:06", "city.title": "Ridgefield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "48": { "city.id": 48, "city.ts": "2018-11-19 21:44:06", "city.title": "Rocky Hill", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "49": { "city.id": 49, "city.ts": "2018-11-19 21:44:06", "city.title": "Seymour", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "50": { "city.id": 50, "city.ts": "2018-11-19 21:44:06", "city.title": "Shelton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "51": { "city.id": 51, "city.ts": "2018-11-19 21:44:06", "city.title": "Simsbury", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "52": { "city.id": 52, "city.ts": "2018-11-19 21:44:06", "city.title": "South Windsor", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "53": { "city.id": 53, "city.ts": "2018-11-19 21:44:06", "city.title": "Southbury", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "54": { "city.id": 54, "city.ts": "2018-11-19 21:44:06", "city.title": "Southington", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "55": { "city.id": 55, "city.ts": "2018-11-19 21:44:06", "city.title": "Stamford", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "56": { "city.id": 56, "city.ts": "2018-11-19 21:44:06", "city.title": "Stratford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "57": { "city.id": 57, "city.ts": "2018-11-19 21:44:06", "city.title": "Torrington", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "58": { "city.id": 58, "city.ts": "2018-11-19 21:44:06", "city.title": "Trumbull", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "59": { "city.id": 59, "city.ts": "2018-11-19 21:44:06", "city.title": "Uncasville", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "60": { "city.id": 60, "city.ts": "2018-11-19 21:44:06", "city.title": "Unionville", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "61": { "city.id": 61, "city.ts": "2018-11-19 21:44:06", "city.title": "Vernon", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "62": { "city.id": 62, "city.ts": "2018-11-19 21:44:06", "city.title": "Vernon Rockville", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "63": { "city.id": 63, "city.ts": "2018-11-19 21:44:06", "city.title": "Wallingford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "64": { "city.id": 64, "city.ts": "2018-11-19 21:44:06", "city.title": "Waterbury", "city.count": 3, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "65": { "city.id": 65, "city.ts": "2018-11-19 21:44:06", "city.title": "Waterford", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "66": { "city.id": 66, "city.ts": "2018-11-19 21:44:06", "city.title": "Watertown", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "67": { "city.id": 67, "city.ts": "2018-11-19 21:44:06", "city.title": "West Hartford", "city.count": 2, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "68": { "city.id": 68, "city.ts": "2018-11-19 21:44:06", "city.title": "West Haven", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "69": { "city.id": 69, "city.ts": "2018-11-19 21:44:06", "city.title": "Westport", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "70": { "city.id": 70, "city.ts": "2018-11-19 21:44:06", "city.title": "Wethersfield", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "71": { "city.id": 71, "city.ts": "2018-11-19 21:44:06", "city.title": "Willimantic", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "72": { "city.id": 72, "city.ts": "2018-11-19 21:44:06", "city.title": "Wilton", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "73": { "city.id": 73, "city.ts": "2018-11-19 21:44:06", "city.title": "Windsor", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "74": { "city.id": 74, "city.ts": "2018-11-19 21:44:06", "city.title": "Winsted", "city.count": 1, "state.id": 1, "state.ts": "2018-11-19 21:22:03", "state.title": "Connecticut" }, "75": { "city.id": 75, "city.ts": "2018-11-19 21:44:42", "city.title": "Abington", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "76": { "city.id": 76, "city.ts": "2018-11-19 21:44:42", "city.title": "Acton", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "77": { "city.id": 77, "city.ts": "2018-11-19 21:44:42", "city.title": "Allston", "city.count": 2, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "78": { "city.id": 78, "city.ts": "2018-11-19 21:44:42", "city.title": "Amesbury", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "79": { "city.id": 79, "city.ts": "2018-11-19 21:44:42", "city.title": "Andover", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "80": { "city.id": 80, "city.ts": "2018-11-19 21:44:42", "city.title": "Arlington", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "81": { "city.id": 81, "city.ts": "2018-11-19 21:44:42", "city.title": "Attleboro", "city.count": 2, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "82": { "city.id": 82, "city.ts": "2018-11-19 21:44:42", "city.title": "Bedford", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "83": { "city.id": 83, "city.ts": "2018-11-19 21:44:42", "city.title": "Belchertown", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "84": { "city.id": 84, "city.ts": "2018-11-19 21:44:42", "city.title": "Bellingham", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "85": { "city.id": 85, "city.ts": "2018-11-19 21:44:42", "city.title": "Beverly", "city.count": 2, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "86": { "city.id": 86, "city.ts": "2018-11-19 21:44:42", "city.title": "Boston", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "87": { "city.id": 87, "city.ts": "2018-11-19 21:44:42", "city.title": "Bourne", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "88": { "city.id": 88, "city.ts": "2018-11-19 21:44:42", "city.title": "Braintree", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "89": { "city.id": 89, "city.ts": "2018-11-19 21:44:42", "city.title": "Brockton", "city.count": 2, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "90": { "city.id": 90, "city.ts": "2018-11-19 21:44:42", "city.title": "Brookline", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "91": { "city.id": 91, "city.ts": "2018-11-19 21:44:42", "city.title": "Chelmsford", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "92": { "city.id": 92, "city.ts": "2018-11-19 21:44:42", "city.title": "Chicopee", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "93": { "city.id": 93, "city.ts": "2018-11-19 21:44:42", "city.title": "Cohasset", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "94": { "city.id": 94, "city.ts": "2018-11-19 21:44:42", "city.title": "Danvers", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "95": { "city.id": 95, "city.ts": "2018-11-19 21:44:42", "city.title": "Dartmouth", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "96": { "city.id": 96, "city.ts": "2018-11-19 21:44:42", "city.title": "Dedham", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "97": { "city.id": 97, "city.ts": "2018-11-19 21:44:42", "city.title": "Dorchester", "city.count": 3, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "98": { "city.id": 98, "city.ts": "2018-11-19 21:44:42", "city.title": "East Falmouth", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "99": { "city.id": 99, "city.ts": "2018-11-19 21:44:42", "city.title": "East Longmeadow", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" }, "100": { "city.id": 100, "city.ts": "2018-11-19 21:44:42", "city.title": "East Wareham", "city.count": 1, "state.id": 2, "state.ts": "2018-11-19 21:22:03", "state.title": "Massachusetts" } } } }