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": "ATMs in American states 1", "desc": "Find one of our Bank or ATM Locations in over 40 states", "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_4db7936df78dfe468fc2/atms_in_america_states_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/atms_in_america_states_1/by_table/city/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/atms_in_america_states_1/by_table/city/2/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/atms_in_america_states_1/by_table/city/4/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 3, "limit": 100, "limit_total": 400, "time": 0.0013300000000000000190125692967058057547546923160552978515625 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 1575, "pages_total": 16 }, "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-09 23:34:57", "city.title": "Menlo Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "202": { "city.id": 202, "city.ts": "2018-04-09 23:34:57", "city.title": "Mill Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "203": { "city.id": 203, "city.ts": "2018-04-09 23:34:57", "city.title": "Millbrae", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "204": { "city.id": 204, "city.ts": "2018-04-09 23:34:57", "city.title": "Milpitas", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "205": { "city.id": 205, "city.ts": "2018-04-09 23:34:57", "city.title": "Mira Loma", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "206": { "city.id": 206, "city.ts": "2018-04-09 23:34:57", "city.title": "Mission Viejo", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "207": { "city.id": 207, "city.ts": "2018-04-09 23:34:57", "city.title": "Modesto", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "208": { "city.id": 208, "city.ts": "2018-04-09 23:34:57", "city.title": "Monrovia", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "209": { "city.id": 209, "city.ts": "2018-04-09 23:34:57", "city.title": "Montclair", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "210": { "city.id": 210, "city.ts": "2018-04-09 23:34:57", "city.title": "Montebello", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "211": { "city.id": 211, "city.ts": "2018-04-09 23:34:57", "city.title": "Moreno Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "212": { "city.id": 212, "city.ts": "2018-04-09 23:34:57", "city.title": "Morgan Hill", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "213": { "city.id": 213, "city.ts": "2018-04-09 23:34:57", "city.title": "Mountain View", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "214": { "city.id": 214, "city.ts": "2018-04-09 23:34:57", "city.title": "Murrieta", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "215": { "city.id": 215, "city.ts": "2018-04-09 23:34:57", "city.title": "Napa", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "216": { "city.id": 216, "city.ts": "2018-04-09 23:34:57", "city.title": "Newark", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "217": { "city.id": 217, "city.ts": "2018-04-09 23:34:57", "city.title": "Newbury Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "218": { "city.id": 218, "city.ts": "2018-04-09 23:34:57", "city.title": "Newport Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "219": { "city.id": 219, "city.ts": "2018-04-09 23:34:57", "city.title": "Newport Coast", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "220": { "city.id": 220, "city.ts": "2018-04-09 23:34:57", "city.title": "North Hollywood", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "221": { "city.id": 221, "city.ts": "2018-04-09 23:34:57", "city.title": "Northridge", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "222": { "city.id": 222, "city.ts": "2018-04-09 23:34:57", "city.title": "Norwalk", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "223": { "city.id": 223, "city.ts": "2018-04-09 23:34:57", "city.title": "Novato", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "224": { "city.id": 224, "city.ts": "2018-04-09 23:34:57", "city.title": "Oakland", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "225": { "city.id": 225, "city.ts": "2018-04-09 23:34:57", "city.title": "Oceanside", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "226": { "city.id": 226, "city.ts": "2018-04-09 23:34:57", "city.title": "Ontario", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "227": { "city.id": 227, "city.ts": "2018-04-09 23:34:57", "city.title": "Orange", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "228": { "city.id": 228, "city.ts": "2018-04-09 23:34:57", "city.title": "Orland", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "229": { "city.id": 229, "city.ts": "2018-04-09 23:34:57", "city.title": "Oroville", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "230": { "city.id": 230, "city.ts": "2018-04-09 23:34:57", "city.title": "Oxnard", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "231": { "city.id": 231, "city.ts": "2018-04-09 23:34:57", "city.title": "Pacific Palisades", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "232": { "city.id": 232, "city.ts": "2018-04-09 23:34:57", "city.title": "Pacifica", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "233": { "city.id": 233, "city.ts": "2018-04-09 23:34:57", "city.title": "Palm Desert", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "234": { "city.id": 234, "city.ts": "2018-04-09 23:34:57", "city.title": "Palm Springs", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "235": { "city.id": 235, "city.ts": "2018-04-09 23:34:57", "city.title": "Palmdale", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "236": { "city.id": 236, "city.ts": "2018-04-09 23:34:57", "city.title": "Panorama City", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "237": { "city.id": 237, "city.ts": "2018-04-09 23:34:57", "city.title": "Paradise", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "238": { "city.id": 238, "city.ts": "2018-04-09 23:34:57", "city.title": "Paramount", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "239": { "city.id": 239, "city.ts": "2018-04-09 23:34:57", "city.title": "Pasadena", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "240": { "city.id": 240, "city.ts": "2018-04-09 23:34:57", "city.title": "Paso Robles", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "241": { "city.id": 241, "city.ts": "2018-04-09 23:34:57", "city.title": "Patterson", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "242": { "city.id": 242, "city.ts": "2018-04-09 23:34:57", "city.title": "Petaluma", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "243": { "city.id": 243, "city.ts": "2018-04-09 23:34:57", "city.title": "Pico Rivera", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "244": { "city.id": 244, "city.ts": "2018-04-09 23:34:57", "city.title": "Placentia", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "245": { "city.id": 245, "city.ts": "2018-04-09 23:34:57", "city.title": "Placerville", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "246": { "city.id": 246, "city.ts": "2018-04-09 23:34:57", "city.title": "Pleasant Hill", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "247": { "city.id": 247, "city.ts": "2018-04-09 23:34:57", "city.title": "Pleasanton", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "248": { "city.id": 248, "city.ts": "2018-04-09 23:34:57", "city.title": "Pollock Pines", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "249": { "city.id": 249, "city.ts": "2018-04-09 23:34:57", "city.title": "Pomona", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "250": { "city.id": 250, "city.ts": "2018-04-09 23:34:57", "city.title": "Poway", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "251": { "city.id": 251, "city.ts": "2018-04-09 23:34:57", "city.title": "Quincy", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "252": { "city.id": 252, "city.ts": "2018-04-09 23:34:57", "city.title": "Rancho Cordova", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "253": { "city.id": 253, "city.ts": "2018-04-09 23:34:57", "city.title": "Rancho Cucamonga", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "254": { "city.id": 254, "city.ts": "2018-04-09 23:34:57", "city.title": "Rancho Palos Verdes", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "255": { "city.id": 255, "city.ts": "2018-04-09 23:34:57", "city.title": "Rancho Santa Fe", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "256": { "city.id": 256, "city.ts": "2018-04-09 23:34:57", "city.title": "Rancho Santa Margarita", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "257": { "city.id": 257, "city.ts": "2018-04-09 23:34:57", "city.title": "Red Bluff", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "258": { "city.id": 258, "city.ts": "2018-04-09 23:34:57", "city.title": "Redding", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "259": { "city.id": 259, "city.ts": "2018-04-09 23:34:57", "city.title": "Redlands", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "260": { "city.id": 260, "city.ts": "2018-04-09 23:34:57", "city.title": "Redondo Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "261": { "city.id": 261, "city.ts": "2018-04-09 23:34:57", "city.title": "Redwood City", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "262": { "city.id": 262, "city.ts": "2018-04-09 23:34:57", "city.title": "Reseda", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "263": { "city.id": 263, "city.ts": "2018-04-09 23:34:57", "city.title": "Riverside", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "264": { "city.id": 264, "city.ts": "2018-04-09 23:34:57", "city.title": "Rocklin", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "265": { "city.id": 265, "city.ts": "2018-04-09 23:34:57", "city.title": "Rohnert Park", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "266": { "city.id": 266, "city.ts": "2018-04-09 23:34:57", "city.title": "Rolling Hills", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "267": { "city.id": 267, "city.ts": "2018-04-09 23:34:57", "city.title": "Rosemead", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "268": { "city.id": 268, "city.ts": "2018-04-09 23:34:57", "city.title": "Roseville", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "269": { "city.id": 269, "city.ts": "2018-04-09 23:34:57", "city.title": "Sacramento", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "270": { "city.id": 270, "city.ts": "2018-04-09 23:34:57", "city.title": "Salinas", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "271": { "city.id": 271, "city.ts": "2018-04-09 23:34:57", "city.title": "San Anselmo", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "272": { "city.id": 272, "city.ts": "2018-04-09 23:34:57", "city.title": "San Bernardino", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "273": { "city.id": 273, "city.ts": "2018-04-09 23:34:57", "city.title": "San Bruno", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "274": { "city.id": 274, "city.ts": "2018-04-09 23:34:57", "city.title": "San Carlos", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "275": { "city.id": 275, "city.ts": "2018-04-09 23:34:57", "city.title": "San Clemente", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "276": { "city.id": 276, "city.ts": "2018-04-09 23:34:57", "city.title": "San Diego", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "277": { "city.id": 277, "city.ts": "2018-04-09 23:34:57", "city.title": "San Dimas", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "278": { "city.id": 278, "city.ts": "2018-04-09 23:34:57", "city.title": "San Francisco", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "279": { "city.id": 279, "city.ts": "2018-04-09 23:34:57", "city.title": "San Jacinto", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "280": { "city.id": 280, "city.ts": "2018-04-09 23:34:57", "city.title": "San Jose", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "281": { "city.id": 281, "city.ts": "2018-04-09 23:34:57", "city.title": "San Leandro", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "282": { "city.id": 282, "city.ts": "2018-04-09 23:34:57", "city.title": "San Luis Obispo", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "283": { "city.id": 283, "city.ts": "2018-04-09 23:34:57", "city.title": "San Marcos", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "284": { "city.id": 284, "city.ts": "2018-04-09 23:34:57", "city.title": "San Mateo", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "285": { "city.id": 285, "city.ts": "2018-04-09 23:34:57", "city.title": "San Pedro", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "286": { "city.id": 286, "city.ts": "2018-04-09 23:34:57", "city.title": "San Rafael", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "287": { "city.id": 287, "city.ts": "2018-04-09 23:34:57", "city.title": "San Ramon", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "288": { "city.id": 288, "city.ts": "2018-04-09 23:34:57", "city.title": "San Ysidro", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "289": { "city.id": 289, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Ana", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "290": { "city.id": 290, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Barbara", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "291": { "city.id": 291, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Clara", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "292": { "city.id": 292, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Clarita", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "293": { "city.id": 293, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Cruz", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "294": { "city.id": 294, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Fe Springs", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "295": { "city.id": 295, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Maria", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "296": { "city.id": 296, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Monica", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "297": { "city.id": 297, "city.ts": "2018-04-09 23:34:57", "city.title": "Santa Rosa", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "298": { "city.id": 298, "city.ts": "2018-04-09 23:34:57", "city.title": "Santee", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "299": { "city.id": 299, "city.ts": "2018-04-09 23:34:57", "city.title": "Scotts Valley", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" }, "300": { "city.id": 300, "city.ts": "2018-04-09 23:34:57", "city.title": "Seal Beach", "city.state": "California", "state.id": 5, "state.ts": "2018-04-09 23:33:29", "state.title": "California" } } } }