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": "KFC locations information in US 1", "desc": "state,city,address,zip code", "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/kfc_locations_in_us_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/kfc_locations_in_us_1/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/kfc_locations_in_us_1/by_table/city/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_bc75445a318997106583/kfc_locations_in_us_1/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.00127000000000000007847889005319075295119546353816986083984375 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 3161, "pages_total": 32 }, "struct": { "stem": { "0": "city", "1": "state" }, "leaf": "city.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "201": { "city.id": 201, "city.ts": "2018-04-11 05:24:32", "city.title": "Baldwin Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "202": { "city.id": 202, "city.ts": "2018-04-11 05:24:32", "city.title": "Banning", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "203": { "city.id": 203, "city.ts": "2018-04-11 05:24:32", "city.title": "Bell Gardens", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "204": { "city.id": 204, "city.ts": "2018-04-11 05:24:32", "city.title": "Bellflower", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "205": { "city.id": 205, "city.ts": "2018-04-11 05:24:32", "city.title": "Benicia", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "206": { "city.id": 206, "city.ts": "2018-04-11 05:24:32", "city.title": "Bermuda Dunes", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "207": { "city.id": 207, "city.ts": "2018-04-11 05:24:32", "city.title": "Big Bear Lake", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "208": { "city.id": 208, "city.ts": "2018-04-11 05:24:32", "city.title": "Bishop", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "209": { "city.id": 209, "city.ts": "2018-04-11 05:24:32", "city.title": "Bonita", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "210": { "city.id": 210, "city.ts": "2018-04-11 05:24:32", "city.title": "Brawley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "211": { "city.id": 211, "city.ts": "2018-04-11 05:24:32", "city.title": "Brentwood", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "212": { "city.id": 212, "city.ts": "2018-04-11 05:24:32", "city.title": "Buena Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "213": { "city.id": 213, "city.ts": "2018-04-11 05:24:32", "city.title": "Burbank", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "214": { "city.id": 214, "city.ts": "2018-04-11 05:24:32", "city.title": "Calexico", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "215": { "city.id": 215, "city.ts": "2018-04-11 05:24:32", "city.title": "Camarillo", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "216": { "city.id": 216, "city.ts": "2018-04-11 05:24:32", "city.title": "Cameron Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "217": { "city.id": 217, "city.ts": "2018-04-11 05:24:32", "city.title": "Campbell", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "218": { "city.id": 218, "city.ts": "2018-04-11 05:24:32", "city.title": "Canoga Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "219": { "city.id": 219, "city.ts": "2018-04-11 05:24:32", "city.title": "Canyon Country", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "220": { "city.id": 220, "city.ts": "2018-04-11 05:24:32", "city.title": "Capitola", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "221": { "city.id": 221, "city.ts": "2018-04-11 05:24:32", "city.title": "Carlsbad", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "222": { "city.id": 222, "city.ts": "2018-04-11 05:24:32", "city.title": "Carson", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "223": { "city.id": 223, "city.ts": "2018-04-11 05:24:32", "city.title": "Castro Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "224": { "city.id": 224, "city.ts": "2018-04-11 05:24:32", "city.title": "Cathedral City", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "225": { "city.id": 225, "city.ts": "2018-04-11 05:24:32", "city.title": "Ceres", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "226": { "city.id": 226, "city.ts": "2018-04-11 05:24:32", "city.title": "Cerritos", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "227": { "city.id": 227, "city.ts": "2018-04-11 05:24:32", "city.title": "Chico", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "228": { "city.id": 228, "city.ts": "2018-04-11 05:24:32", "city.title": "Chino", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "229": { "city.id": 229, "city.ts": "2018-04-11 05:24:32", "city.title": "Chino Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "230": { "city.id": 230, "city.ts": "2018-04-11 05:24:32", "city.title": "Chowchilla", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "231": { "city.id": 231, "city.ts": "2018-04-11 05:24:32", "city.title": "Chula Vista", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "232": { "city.id": 232, "city.ts": "2018-04-11 05:24:32", "city.title": "Citrus Heights", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "233": { "city.id": 233, "city.ts": "2018-04-11 05:24:32", "city.title": "Cloverdale", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "234": { "city.id": 234, "city.ts": "2018-04-11 05:24:32", "city.title": "Clovis", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "235": { "city.id": 235, "city.ts": "2018-04-11 05:24:32", "city.title": "Coachella", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "236": { "city.id": 236, "city.ts": "2018-04-11 05:24:32", "city.title": "Coalinga", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "237": { "city.id": 237, "city.ts": "2018-04-11 05:24:32", "city.title": "Colton", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "238": { "city.id": 238, "city.ts": "2018-04-11 05:24:32", "city.title": "Compton", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "239": { "city.id": 239, "city.ts": "2018-04-11 05:24:32", "city.title": "Concord", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "240": { "city.id": 240, "city.ts": "2018-04-11 05:24:32", "city.title": "Corona", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "241": { "city.id": 241, "city.ts": "2018-04-11 05:24:32", "city.title": "Corona Del Mar", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "242": { "city.id": 242, "city.ts": "2018-04-11 05:24:32", "city.title": "Coronado", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "243": { "city.id": 243, "city.ts": "2018-04-11 05:24:32", "city.title": "Costa Mesa", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "244": { "city.id": 244, "city.ts": "2018-04-11 05:24:32", "city.title": "Covina", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "245": { "city.id": 245, "city.ts": "2018-04-11 05:24:32", "city.title": "Cupertino", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "246": { "city.id": 246, "city.ts": "2018-04-11 05:24:32", "city.title": "Cypress", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "247": { "city.id": 247, "city.ts": "2018-04-11 05:24:32", "city.title": "Daly City", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "248": { "city.id": 248, "city.ts": "2018-04-11 05:24:32", "city.title": "Davis", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "249": { "city.id": 249, "city.ts": "2018-04-11 05:24:32", "city.title": "Delano", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "250": { "city.id": 250, "city.ts": "2018-04-11 05:24:32", "city.title": "Desert Hot Springs", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "251": { "city.id": 251, "city.ts": "2018-04-11 05:24:32", "city.title": "Diamond Bar", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "252": { "city.id": 252, "city.ts": "2018-04-11 05:24:32", "city.title": "Dinuba", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "253": { "city.id": 253, "city.ts": "2018-04-11 05:24:32", "city.title": "Downey", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "254": { "city.id": 254, "city.ts": "2018-04-11 05:24:32", "city.title": "Duarte", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "255": { "city.id": 255, "city.ts": "2018-04-11 05:24:32", "city.title": "Dublin", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "256": { "city.id": 256, "city.ts": "2018-04-11 05:24:32", "city.title": "El Cajon", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "257": { "city.id": 257, "city.ts": "2018-04-11 05:24:32", "city.title": "El Centro", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "258": { "city.id": 258, "city.ts": "2018-04-11 05:24:32", "city.title": "El Cerrito", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "259": { "city.id": 259, "city.ts": "2018-04-11 05:24:32", "city.title": "El Monte", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "260": { "city.id": 260, "city.ts": "2018-04-11 05:24:32", "city.title": "Elk Grove", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "261": { "city.id": 261, "city.ts": "2018-04-11 05:24:32", "city.title": "Emeryville", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "262": { "city.id": 262, "city.ts": "2018-04-11 05:24:32", "city.title": "Encinitas", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "263": { "city.id": 263, "city.ts": "2018-04-11 05:24:32", "city.title": "Escondido", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "264": { "city.id": 264, "city.ts": "2018-04-11 05:24:32", "city.title": "Fair Oaks", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "265": { "city.id": 265, "city.ts": "2018-04-11 05:24:32", "city.title": "Fairfield", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "266": { "city.id": 266, "city.ts": "2018-04-11 05:24:32", "city.title": "Fallbrook", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "267": { "city.id": 267, "city.ts": "2018-04-11 05:24:32", "city.title": "Folsom", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "268": { "city.id": 268, "city.ts": "2018-04-11 05:24:32", "city.title": "Fontana", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "269": { "city.id": 269, "city.ts": "2018-04-11 05:24:32", "city.title": "Fountain Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "270": { "city.id": 270, "city.ts": "2018-04-11 05:24:32", "city.title": "Fremont", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "271": { "city.id": 271, "city.ts": "2018-04-11 05:24:32", "city.title": "Fresno", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "272": { "city.id": 272, "city.ts": "2018-04-11 05:24:32", "city.title": "Fullerton", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "273": { "city.id": 273, "city.ts": "2018-04-11 05:24:32", "city.title": "Galt", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "274": { "city.id": 274, "city.ts": "2018-04-11 05:24:32", "city.title": "Garden Grove", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "275": { "city.id": 275, "city.ts": "2018-04-11 05:24:32", "city.title": "Gardena", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "276": { "city.id": 276, "city.ts": "2018-04-11 05:24:32", "city.title": "Gilroy", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "277": { "city.id": 277, "city.ts": "2018-04-11 05:24:32", "city.title": "Glendale", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "278": { "city.id": 278, "city.ts": "2018-04-11 05:24:32", "city.title": "Goleta", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "279": { "city.id": 279, "city.ts": "2018-04-11 05:24:32", "city.title": "Granada Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "280": { "city.id": 280, "city.ts": "2018-04-11 05:24:32", "city.title": "Grass Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "281": { "city.id": 281, "city.ts": "2018-04-11 05:24:32", "city.title": "Hacienda Heights", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "282": { "city.id": 282, "city.ts": "2018-04-11 05:24:32", "city.title": "Hanford", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "283": { "city.id": 283, "city.ts": "2018-04-11 05:24:32", "city.title": "Hawaiian Gardens", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "284": { "city.id": 284, "city.ts": "2018-04-11 05:24:32", "city.title": "Hawthorne", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "285": { "city.id": 285, "city.ts": "2018-04-11 05:24:32", "city.title": "Hayward", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "286": { "city.id": 286, "city.ts": "2018-04-11 05:24:32", "city.title": "Hemet", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "287": { "city.id": 287, "city.ts": "2018-04-11 05:24:32", "city.title": "Hesperia", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "288": { "city.id": 288, "city.ts": "2018-04-11 05:24:32", "city.title": "Highland", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "289": { "city.id": 289, "city.ts": "2018-04-11 05:24:32", "city.title": "Hollister", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "290": { "city.id": 290, "city.ts": "2018-04-11 05:24:32", "city.title": "Huntington Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "291": { "city.id": 291, "city.ts": "2018-04-11 05:24:32", "city.title": "Huntington Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "292": { "city.id": 292, "city.ts": "2018-04-11 05:24:32", "city.title": "Imperial Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "293": { "city.id": 293, "city.ts": "2018-04-11 05:24:32", "city.title": "Indio", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "294": { "city.id": 294, "city.ts": "2018-04-11 05:24:32", "city.title": "Inglewood", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "295": { "city.id": 295, "city.ts": "2018-04-11 05:24:32", "city.title": "Irvine", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "296": { "city.id": 296, "city.ts": "2018-04-11 05:24:32", "city.title": "Jackson", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "297": { "city.id": 297, "city.ts": "2018-04-11 05:24:32", "city.title": "Kerman", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "298": { "city.id": 298, "city.ts": "2018-04-11 05:24:32", "city.title": "King City", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "299": { "city.id": 299, "city.ts": "2018-04-11 05:24:32", "city.title": "La Canada Flintridge", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" }, "300": { "city.id": 300, "city.ts": "2018-04-11 05:24:32", "city.title": "La Habra", "city.state": "California", "state.id": 5, "state.ts": "2018-04-11 05:22:33", "state.title": "California" } } } }