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": "Location Information Of Bank In USA 1",
"desc": "Location information of bank in USA data set",
"point": {
"title": "Main",
"desc": "Main access point of this API. "
}
},
"input": {},
"links": {
"up": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/location_information_of_bank_in_usa_1/main/"
},
"home": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/location_information_of_bank_in_usa_1/main/list/?app=html-json"
},
"next": {
"href": "https://songer.datasn.com/data/api/v1/u_4db7936df78dfe468fc2/location_information_of_bank_in_usa_1/main/list/2/?app=html-json"
}
},
"meta": {
"query": {
"page": 1,
"limit": 20,
"limit_total": 400,
"time": 0.00476000000000000034194869158454821445047855377197265625
},
"stats": {
"raw_rows": 20,
"rows": 20,
"rows_total": 7069,
"pages_total": 354
},
"struct": {
"stem": {
"0": "bank"
},
"leaf": "bank.id",
"leaf_stem": {},
"leaf_stem_leaf": null
}
},
"output": {
"rows": {
"1": {
"bank.id": 1,
"bank.ts": "2017-12-03 20:58:41",
"bank.title": "Anthem",
"bank.street_address": "39518 N Gavilan Peak Pkwy",
"bank.address_locality": "Anthem,",
"bank.address_region": "AZ",
"bank.postal_code": 85086,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.8432090000000016516423784196376800537109375,
"bank.longitude": -112.1356770000000011577867553569376468658447265625,
"bank.phone": "(623) 551-4959",
"bank.opendate": "2005-12-16 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"1": {
"city_x_bank.id": 1,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"258": {
"city_x_bank.id": 258,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"356": {
"city_x_bank.id": 356,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"463": {
"city_x_bank.id": 463,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"516": {
"city_x_bank.id": 516,
"city.id": 11,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Flagstaff",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1227": {
"city_x_bank.id": 1227,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1278": {
"city_x_bank.id": 1278,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1432": {
"city_x_bank.id": 1432,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1596": {
"city_x_bank.id": 1596,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1700": {
"city_x_bank.id": 1700,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1821": {
"city_x_bank.id": 1821,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"1": {
"bank_x_hour.id": 1,
"hour.id": 1,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Monday",
"hour.value": "9:00 am - 5:00 pm"
},
"2": {
"bank_x_hour.id": 2,
"hour.id": 2,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Tuesday - Thursday",
"hour.value": "10:00 am - 5:00 pm"
},
"3": {
"bank_x_hour.id": 3,
"hour.id": 3,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Friday",
"hour.value": "9:00 am - 5:00 pm"
},
"4": {
"bank_x_hour.id": 4,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
}
}
},
"2": {
"bank.id": 2,
"bank.ts": "2017-12-03 20:59:52",
"bank.title": "I-17 & Carefree Highway",
"bank.street_address": "3110 W Carefree Hwy",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85086,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.79950000000000187583282240666449069976806640625,
"bank.longitude": -112.1264999999900027205512742511928081512451171875,
"bank.phone": "(623) 434-2260",
"bank.opendate": "2003-12-17 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"2": {
"city_x_bank.id": 2,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"257": {
"city_x_bank.id": 257,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"355": {
"city_x_bank.id": 355,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"466": {
"city_x_bank.id": 466,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1231": {
"city_x_bank.id": 1231,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1281": {
"city_x_bank.id": 1281,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1434": {
"city_x_bank.id": 1434,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1584": {
"city_x_bank.id": 1584,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1695": {
"city_x_bank.id": 1695,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1823": {
"city_x_bank.id": 1823,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"7": {
"bank_x_hour.id": 7,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"5": {
"bank_x_hour.id": 5,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"6": {
"bank_x_hour.id": 6,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"3": {
"bank.id": 3,
"bank.ts": "2017-12-03 20:59:57",
"bank.title": "I-17 & Happy Valley",
"bank.street_address": "2501 W Happy Valley Rd STE 46",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85085,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.7123500000000007048583938740193843841552734375,
"bank.longitude": -112.10966899999999668580130673944950103759765625,
"bank.phone": "(623) 580-7152",
"bank.opendate": "2005-06-20 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"3": {
"city_x_bank.id": 3,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"262": {
"city_x_bank.id": 262,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"359": {
"city_x_bank.id": 359,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"469": {
"city_x_bank.id": 469,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1153": {
"city_x_bank.id": 1153,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1239": {
"city_x_bank.id": 1239,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1289": {
"city_x_bank.id": 1289,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1437": {
"city_x_bank.id": 1437,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1541": {
"city_x_bank.id": 1541,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1575": {
"city_x_bank.id": 1575,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1687": {
"city_x_bank.id": 1687,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1831": {
"city_x_bank.id": 1831,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"10": {
"bank_x_hour.id": 10,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"8": {
"bank_x_hour.id": 8,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"9": {
"bank_x_hour.id": 9,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"4": {
"bank.id": 4,
"bank.ts": "2017-12-03 21:00:03",
"bank.title": "Cave Creek & Olesen",
"bank.street_address": "34317 W Cave Creek Rd",
"bank.address_locality": "Cave Creek,",
"bank.address_region": "AZ",
"bank.postal_code": 85331,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.7958840000000009240466170012950897216796875,
"bank.longitude": -111.9658400000000000318323145620524883270263671875,
"bank.phone": "",
"bank.opendate": "",
"bank.atm_services": "Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"4": {
"city_x_bank.id": 4,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"252": {
"city_x_bank.id": 252,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"352": {
"city_x_bank.id": 352,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"465": {
"city_x_bank.id": 465,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"517": {
"city_x_bank.id": 517,
"city.id": 11,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Flagstaff",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1234": {
"city_x_bank.id": 1234,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1285": {
"city_x_bank.id": 1285,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1433": {
"city_x_bank.id": 1433,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1854": {
"city_x_bank.id": 1854,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {}
},
"5": {
"bank.id": 5,
"bank.ts": "2017-12-03 21:00:09",
"bank.title": "Tatum Ranch",
"bank.street_address": "29822 N Cave Creek Rd",
"bank.address_locality": "Cave Creek,",
"bank.address_region": "AZ",
"bank.postal_code": 85331,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.75643000000000171212377608753740787506103515625,
"bank.longitude": -111.9905899999999974170350469648838043212890625,
"bank.phone": "(480) 718-6856",
"bank.opendate": "2015-07-20 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM with Teller Assist,ATM accepts deposits and credit card payments,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"5": {
"city_x_bank.id": 5,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"253": {
"city_x_bank.id": 253,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"353": {
"city_x_bank.id": 353,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"467": {
"city_x_bank.id": 467,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1238": {
"city_x_bank.id": 1238,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1286": {
"city_x_bank.id": 1286,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1435": {
"city_x_bank.id": 1435,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1852": {
"city_x_bank.id": 1852,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"12": {
"bank_x_hour.id": 12,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"11": {
"bank_x_hour.id": 11,
"hour.id": 11,
"hour.ts": "2017-12-03 21:00:09",
"hour.key": "Monday - Friday",
"hour.value": "10:00 am - 5:00 pm"
}
}
},
"6": {
"bank.id": 6,
"bank.ts": "2017-12-03 21:00:12",
"bank.title": "67th & Happy Valley",
"bank.street_address": "6510 W Happy Valley Rd",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85310,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.71255500000000182581061380915343761444091796875,
"bank.longitude": -112.2022750000000002046363078989088535308837890625,
"bank.phone": "(623) 537-2440",
"bank.opendate": "2003-12-22 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"6": {
"city_x_bank.id": 6,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"278": {
"city_x_bank.id": 278,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"371": {
"city_x_bank.id": 371,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"470": {
"city_x_bank.id": 470,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"957": {
"city_x_bank.id": 957,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1137": {
"city_x_bank.id": 1137,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1237": {
"city_x_bank.id": 1237,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1288": {
"city_x_bank.id": 1288,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1440": {
"city_x_bank.id": 1440,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1522": {
"city_x_bank.id": 1522,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1565": {
"city_x_bank.id": 1565,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1667": {
"city_x_bank.id": 1667,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1820": {
"city_x_bank.id": 1820,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"15": {
"bank_x_hour.id": 15,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"13": {
"bank_x_hour.id": 13,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"14": {
"bank_x_hour.id": 14,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"7": {
"bank.id": 7,
"bank.ts": "2017-12-03 21:00:17",
"bank.title": "Carefree",
"bank.street_address": "37217 N Tom Darlington Dr",
"bank.address_locality": "Carefree,",
"bank.address_region": "AZ",
"bank.postal_code": 85377,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.823340000000001737134880386292934417724609375,
"bank.longitude": -111.9242899999999991678123478777706623077392578125,
"bank.phone": "(480) 827-6430",
"bank.opendate": "1952-01-01 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"7": {
"city_x_bank.id": 7,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"251": {
"city_x_bank.id": 251,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"351": {
"city_x_bank.id": 351,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"464": {
"city_x_bank.id": 464,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"515": {
"city_x_bank.id": 515,
"city.id": 11,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Flagstaff",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1232": {
"city_x_bank.id": 1232,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1282": {
"city_x_bank.id": 1282,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1431": {
"city_x_bank.id": 1431,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1861": {
"city_x_bank.id": 1861,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"16": {
"bank_x_hour.id": 16,
"hour.id": 16,
"hour.ts": "2017-12-03 21:00:17",
"hour.key": "Monday - Friday",
"hour.value": "9:00 am - 5:00 pm"
}
}
},
"8": {
"bank.id": 8,
"bank.ts": "2017-12-03 21:00:36",
"bank.title": "Lake Pleasant Towne Center",
"bank.street_address": "25260 N Lake Pleasant Pkwy",
"bank.address_locality": "Peoria,",
"bank.address_region": "AZ",
"bank.postal_code": 85383,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.712879999999898927853791974484920501708984375,
"bank.longitude": -112.2756700000000051886672736145555973052978515625,
"bank.phone": "(623) 376-2447",
"bank.opendate": "2007-12-21 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"8": {
"city_x_bank.id": 8,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"182": {
"city_x_bank.id": 182,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"292": {
"city_x_bank.id": 292,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"384": {
"city_x_bank.id": 384,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"472": {
"city_x_bank.id": 472,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"946": {
"city_x_bank.id": 946,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1139": {
"city_x_bank.id": 1139,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1236": {
"city_x_bank.id": 1236,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1287": {
"city_x_bank.id": 1287,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1442": {
"city_x_bank.id": 1442,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1517": {
"city_x_bank.id": 1517,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1560": {
"city_x_bank.id": 1560,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1660": {
"city_x_bank.id": 1660,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1817": {
"city_x_bank.id": 1817,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"19": {
"bank_x_hour.id": 19,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"17": {
"bank_x_hour.id": 17,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"18": {
"bank_x_hour.id": 18,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"9": {
"bank.id": 9,
"bank.ts": "2017-12-03 21:00:44",
"bank.title": "67th Ave & Beardsley",
"bank.street_address": "20239 N 67th Ave",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85308,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.66898400000000179943526745773851871490478515625,
"bank.longitude": -112.202573999999998477505869232118129730224609375,
"bank.phone": "(623) 362-3679",
"bank.opendate": "2006-01-23 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"9": {
"city_x_bank.id": 9,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"150": {
"city_x_bank.id": 150,
"city.id": 3,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Avondale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"192": {
"city_x_bank.id": 192,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"283": {
"city_x_bank.id": 283,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"379": {
"city_x_bank.id": 379,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"475": {
"city_x_bank.id": 475,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"705": {
"city_x_bank.id": 705,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"942": {
"city_x_bank.id": 942,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1119": {
"city_x_bank.id": 1119,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1205": {
"city_x_bank.id": 1205,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1241": {
"city_x_bank.id": 1241,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1290": {
"city_x_bank.id": 1290,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1448": {
"city_x_bank.id": 1448,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1514": {
"city_x_bank.id": 1514,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1564": {
"city_x_bank.id": 1564,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1666": {
"city_x_bank.id": 1666,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1825": {
"city_x_bank.id": 1825,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"22": {
"bank_x_hour.id": 22,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"20": {
"bank_x_hour.id": 20,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"21": {
"bank_x_hour.id": 21,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"10": {
"bank.id": 10,
"bank.ts": "2017-12-03 21:00:49",
"bank.title": "Bell Road and Black Canyon",
"bank.street_address": "2903 W Bell Rd",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85053,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.63974999999989989873938611708581447601318359375,
"bank.longitude": -112.118999999999999772626324556767940521240234375,
"bank.phone": "(602) 734-0484",
"bank.opendate": "2011-05-09 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"10": {
"city_x_bank.id": 10,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"274": {
"city_x_bank.id": 274,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"370": {
"city_x_bank.id": 370,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"479": {
"city_x_bank.id": 479,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"696": {
"city_x_bank.id": 696,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"954": {
"city_x_bank.id": 954,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1127": {
"city_x_bank.id": 1127,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1178": {
"city_x_bank.id": 1178,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1248": {
"city_x_bank.id": 1248,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1300": {
"city_x_bank.id": 1300,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1454": {
"city_x_bank.id": 1454,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1528": {
"city_x_bank.id": 1528,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1572": {
"city_x_bank.id": 1572,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1681": {
"city_x_bank.id": 1681,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1837": {
"city_x_bank.id": 1837,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"25": {
"bank_x_hour.id": 25,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"23": {
"bank_x_hour.id": 23,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"24": {
"bank_x_hour.id": 24,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"11": {
"bank.id": 11,
"bank.ts": "2017-12-03 21:06:38",
"bank.title": "43rd & Bell",
"bank.street_address": "4301 W Bell Rd",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85308,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.6389599999998978319126763381063938140869140625,
"bank.longitude": -112.154730000000000700310920365154743194580078125,
"bank.phone": "(602) 564-8322",
"bank.opendate": "1974-09-30 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"11": {
"city_x_bank.id": 11,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"148": {
"city_x_bank.id": 148,
"city.id": 3,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Avondale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"198": {
"city_x_bank.id": 198,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"280": {
"city_x_bank.id": 280,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"378": {
"city_x_bank.id": 378,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"482": {
"city_x_bank.id": 482,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"689": {
"city_x_bank.id": 689,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"945": {
"city_x_bank.id": 945,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1118": {
"city_x_bank.id": 1118,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1183": {
"city_x_bank.id": 1183,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1247": {
"city_x_bank.id": 1247,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1299": {
"city_x_bank.id": 1299,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1455": {
"city_x_bank.id": 1455,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1518": {
"city_x_bank.id": 1518,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1569": {
"city_x_bank.id": 1569,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1672": {
"city_x_bank.id": 1672,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1833": {
"city_x_bank.id": 1833,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"28": {
"bank_x_hour.id": 28,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"26": {
"bank_x_hour.id": 26,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"27": {
"bank_x_hour.id": 27,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"12": {
"bank.id": 12,
"bank.ts": "2017-12-03 21:06:42",
"bank.title": "Desert Ridge",
"bank.street_address": "21001 N Tatum Blvd STE 90",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85050,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.67642000000000024328983272425830364227294921875,
"bank.longitude": -111.97244000000000596628524363040924072265625,
"bank.phone": "(480) 538-4901",
"bank.opendate": "2001-10-22 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"12": {
"city_x_bank.id": 12,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"256": {
"city_x_bank.id": 256,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"357": {
"city_x_bank.id": 357,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"473": {
"city_x_bank.id": 473,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"601": {
"city_x_bank.id": 601,
"city.id": 13,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Fountain Hills",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1250": {
"city_x_bank.id": 1250,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1297": {
"city_x_bank.id": 1297,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1439": {
"city_x_bank.id": 1439,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"31": {
"bank_x_hour.id": 31,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"29": {
"bank_x_hour.id": 29,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"30": {
"bank_x_hour.id": 30,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"13": {
"bank.id": 13,
"bank.ts": "2017-12-03 21:06:49",
"bank.title": "7th & Bell",
"bank.street_address": "605 E Bell Rd",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85022,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.64009999999989730667948606424033641815185546875,
"bank.longitude": -112.065999000000005025867721997201442718505859375,
"bank.phone": "(602) 564-8336",
"bank.opendate": "1987-09-14 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM with Teller Assist,ATM accepts deposits and credit card payments,Drive-up ATM,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"13": {
"city_x_bank.id": 13,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"268": {
"city_x_bank.id": 268,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"367": {
"city_x_bank.id": 367,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"478": {
"city_x_bank.id": 478,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"709": {
"city_x_bank.id": 709,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1144": {
"city_x_bank.id": 1144,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1180": {
"city_x_bank.id": 1180,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1254": {
"city_x_bank.id": 1254,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1301": {
"city_x_bank.id": 1301,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1449": {
"city_x_bank.id": 1449,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1544": {
"city_x_bank.id": 1544,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1586": {
"city_x_bank.id": 1586,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1694": {
"city_x_bank.id": 1694,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1850": {
"city_x_bank.id": 1850,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"34": {
"bank_x_hour.id": 34,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"32": {
"bank_x_hour.id": 32,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"33": {
"bank_x_hour.id": 33,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"14": {
"bank.id": 14,
"bank.ts": "2017-12-03 21:06:56",
"bank.title": "Arrowhead Towne Center - Macy's",
"bank.street_address": "7700 W Arrowhead Towne Ctr",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85308,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.63969300000000117734089144505560398101806640625,
"bank.longitude": -112.227248000000003003151505254209041595458984375,
"bank.phone": "",
"bank.opendate": "",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"14": {
"city_x_bank.id": 14,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"140": {
"city_x_bank.id": 140,
"city.id": 3,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Avondale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"176": {
"city_x_bank.id": 176,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"291": {
"city_x_bank.id": 291,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"390": {
"city_x_bank.id": 390,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"483": {
"city_x_bank.id": 483,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"692": {
"city_x_bank.id": 692,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"762": {
"city_x_bank.id": 762,
"city.id": 16,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Goodyear",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"932": {
"city_x_bank.id": 932,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1113": {
"city_x_bank.id": 1113,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1200": {
"city_x_bank.id": 1200,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1245": {
"city_x_bank.id": 1245,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1294": {
"city_x_bank.id": 1294,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1458": {
"city_x_bank.id": 1458,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1509": {
"city_x_bank.id": 1509,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1563": {
"city_x_bank.id": 1563,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1664": {
"city_x_bank.id": 1664,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1826": {
"city_x_bank.id": 1826,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {}
},
"15": {
"bank.id": 15,
"bank.ts": "2017-12-03 21:07:02",
"bank.title": "32nd St & Bell",
"bank.street_address": "3246 E Bell Rd",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85032,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.64071299999989861362337251193821430206298828125,
"bank.longitude": -112.0124890000000021927917259745299816131591796875,
"bank.phone": "(602) 569-4040",
"bank.opendate": "1989-06-14 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,ATM located inside",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"15": {
"city_x_bank.id": 15,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"263": {
"city_x_bank.id": 263,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"362": {
"city_x_bank.id": 362,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"476": {
"city_x_bank.id": 476,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"609": {
"city_x_bank.id": 609,
"city.id": 13,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Fountain Hills",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1189": {
"city_x_bank.id": 1189,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1256": {
"city_x_bank.id": 1256,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1304": {
"city_x_bank.id": 1304,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1446": {
"city_x_bank.id": 1446,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1602": {
"city_x_bank.id": 1602,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1858": {
"city_x_bank.id": 1858,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"37": {
"bank_x_hour.id": 37,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"35": {
"bank_x_hour.id": 35,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"36": {
"bank_x_hour.id": 36,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"16": {
"bank.id": 16,
"bank.ts": "2017-12-03 21:07:03",
"bank.title": "83rd Ave & Bell",
"bank.street_address": "8258 W Bell Rd",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85308,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.6383000000000009777068044058978557586669921875,
"bank.longitude": -112.23300000000000409272615797817707061767578125,
"bank.phone": "(623) 487-5864",
"bank.opendate": "1996-02-12 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"16": {
"city_x_bank.id": 16,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"137": {
"city_x_bank.id": 137,
"city.id": 3,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Avondale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"175": {
"city_x_bank.id": 175,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"294": {
"city_x_bank.id": 294,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"391": {
"city_x_bank.id": 391,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"484": {
"city_x_bank.id": 484,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"693": {
"city_x_bank.id": 693,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"759": {
"city_x_bank.id": 759,
"city.id": 16,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Goodyear",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"931": {
"city_x_bank.id": 931,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1112": {
"city_x_bank.id": 1112,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1203": {
"city_x_bank.id": 1203,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1246": {
"city_x_bank.id": 1246,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1295": {
"city_x_bank.id": 1295,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1461": {
"city_x_bank.id": 1461,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1508": {
"city_x_bank.id": 1508,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1561": {
"city_x_bank.id": 1561,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1662": {
"city_x_bank.id": 1662,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1824": {
"city_x_bank.id": 1824,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"40": {
"bank_x_hour.id": 40,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"38": {
"bank_x_hour.id": 38,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"39": {
"bank_x_hour.id": 39,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"17": {
"bank.id": 17,
"bank.ts": "2017-12-03 21:07:09",
"bank.title": "19th & Thunderbird",
"bank.street_address": "1910 W Thunderbird Rd",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85023,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.61131999999989972138791927136480808258056640625,
"bank.longitude": -112.0998699999999956844476400874555110931396484375,
"bank.phone": "(602) 564-8331",
"bank.opendate": "1973-12-17 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"17": {
"city_x_bank.id": 17,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"277": {
"city_x_bank.id": 277,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"376": {
"city_x_bank.id": 376,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"491": {
"city_x_bank.id": 491,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"687": {
"city_x_bank.id": 687,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"953": {
"city_x_bank.id": 953,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1129": {
"city_x_bank.id": 1129,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1169": {
"city_x_bank.id": 1169,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1258": {
"city_x_bank.id": 1258,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1309": {
"city_x_bank.id": 1309,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1459": {
"city_x_bank.id": 1459,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1531": {
"city_x_bank.id": 1531,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1580": {
"city_x_bank.id": 1580,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1686": {
"city_x_bank.id": 1686,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1845": {
"city_x_bank.id": 1845,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"41": {
"bank_x_hour.id": 41,
"hour.id": 1,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Monday",
"hour.value": "9:00 am - 5:00 pm"
},
"42": {
"bank_x_hour.id": 42,
"hour.id": 2,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Tuesday - Thursday",
"hour.value": "10:00 am - 5:00 pm"
},
"44": {
"bank_x_hour.id": 44,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"43": {
"bank_x_hour.id": 43,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"18": {
"bank.id": 18,
"bank.ts": "2017-12-03 21:07:30",
"bank.title": "Tatum & Bell",
"bank.street_address": "16851 N Tatum Blvd",
"bank.address_locality": "Phoenix,",
"bank.address_region": "AZ",
"bank.postal_code": 85032,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.640321000000000140062184073030948638916015625,
"bank.longitude": -111.9773459999999971614670357666909694671630859375,
"bank.phone": "(602) 569-4034",
"bank.opendate": "1995-04-28 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"18": {
"city_x_bank.id": 18,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"261": {
"city_x_bank.id": 261,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"360": {
"city_x_bank.id": 360,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"477": {
"city_x_bank.id": 477,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"597": {
"city_x_bank.id": 597,
"city.id": 13,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Fountain Hills",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1194": {
"city_x_bank.id": 1194,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1259": {
"city_x_bank.id": 1259,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1308": {
"city_x_bank.id": 1308,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1445": {
"city_x_bank.id": 1445,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"47": {
"bank_x_hour.id": 47,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"45": {
"bank_x_hour.id": 45,
"hour.id": 5,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Monday - Thursday",
"hour.value": "9:00 am - 5:00 pm"
},
"46": {
"bank_x_hour.id": 46,
"hour.id": 6,
"hour.ts": "2017-12-03 20:59:52",
"hour.key": "Friday",
"hour.value": "9:00 am - 6:00 pm"
}
}
},
"19": {
"bank.id": 19,
"bank.ts": "2017-12-01 01:20:02",
"bank.title": "59th & Thunderbird",
"bank.street_address": "5831 W Thunderbird Rd",
"bank.address_locality": "Glendale,",
"bank.address_region": "AZ",
"bank.postal_code": 85306,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.61055999999999954752638586796820163726806640625,
"bank.longitude": -112.1847999999999956344254314899444580078125,
"bank.phone": "(602) 564-8327",
"bank.opendate": "1984-08-27 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "",
"bank.city_x_bank_id": {
"19": {
"city_x_bank.id": 19,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"128": {
"city_x_bank.id": 128,
"city.id": 3,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Avondale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"177": {
"city_x_bank.id": 177,
"city.id": 4,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Buckeye",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"290": {
"city_x_bank.id": 290,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"385": {
"city_x_bank.id": 385,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"495": {
"city_x_bank.id": 495,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"677": {
"city_x_bank.id": 677,
"city.id": 15,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Glendale",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"757": {
"city_x_bank.id": 757,
"city.id": 16,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Goodyear",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"933": {
"city_x_bank.id": 933,
"city.id": 21,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Litchfield Park",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1111": {
"city_x_bank.id": 1111,
"city.id": 25,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Peoria",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1181": {
"city_x_bank.id": 1181,
"city.id": 26,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Phoenix",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1255": {
"city_x_bank.id": 1255,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1306": {
"city_x_bank.id": 1306,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1468": {
"city_x_bank.id": 1468,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1513": {
"city_x_bank.id": 1513,
"city.id": 34,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1567": {
"city_x_bank.id": 1567,
"city.id": 35,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sun City West",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1669": {
"city_x_bank.id": 1669,
"city.id": 37,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Surprise",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1832": {
"city_x_bank.id": 1832,
"city.id": 41,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Wickenburg",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {}
},
"20": {
"bank.id": 20,
"bank.ts": "2017-12-03 21:08:09",
"bank.title": "Pima Pinnacle Peak",
"bank.street_address": "8828 E Pinnacle Peak Rd",
"bank.address_locality": "Scottsdale,",
"bank.address_region": "AZ",
"bank.postal_code": 85255,
"bank.atm_hour": "24 Hours",
"bank.latitude": 33.6987400000000008049028110690414905548095703125,
"bank.longitude": -111.890129999999999199644662439823150634765625,
"bank.phone": "(602) 248-4843",
"bank.opendate": "1998-07-01 00:00:00",
"bank.atm_services": "Walk-up ATM,Cardless ATM,ATM accepts deposits and credit card payments,Drive-up ATM",
"bank.languages": "This ATM also provides instructions in non-English languages. English, Spanish, Chinese, Korean, French, Russian, Portuguese",
"bank.city_x_bank_id": {
"20": {
"city_x_bank.id": 20,
"city.id": 1,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Anthem",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"254": {
"city_x_bank.id": 254,
"city.id": 6,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Carefree",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"354": {
"city_x_bank.id": 354,
"city.id": 8,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cave Creek",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"471": {
"city_x_bank.id": 471,
"city.id": 10,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Cottonwood",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"580": {
"city_x_bank.id": 580,
"city.id": 13,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Fountain Hills",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1251": {
"city_x_bank.id": 1251,
"city.id": 28,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1298": {
"city_x_bank.id": 1298,
"city.id": 29,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Prescott Valley",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
},
"1436": {
"city_x_bank.id": 1436,
"city.id": 32,
"city.ts": "2017-12-01 01:03:04",
"city.title": "Sedona",
"city.state": "Arizona",
"state.id": 1,
"state.ts": "2017-12-01 00:58:44",
"state.title": "Arizona"
}
},
"bank.bank_x_hour_id": {
"49": {
"bank_x_hour.id": 49,
"hour.id": 4,
"hour.ts": "2017-12-03 20:58:41",
"hour.key": "Saturday",
"hour.value": "9:00 am - 1:00 pm"
},
"48": {
"bank_x_hour.id": 48,
"hour.id": 16,
"hour.ts": "2017-12-03 21:00:17",
"hour.key": "Monday - Friday",
"hour.value": "9:00 am - 5:00 pm"
}
}
}
}
}
}