address_geocoding: 90

This data as json

rowid	rowid	full_name	address	latitude	longitude	opencage_result
90	90	John Lyons	City Hall, Dublin 2	47.28167	8.45023	{"documentation": "https://opencagedata.com/api", "licenses": [{"name": "see attribution guide", "url": "https://opencagedata.com/credits"}], "rate": {"limit": 2500, "remaining": 2410, "reset": 1732147200}, "results": [{"annotations": {"DMS": {"lat": "47\u00b0 16' 54.01200'' N", "lng": "8\u00b0 27' 0.82800'' E"}, "MGRS": "32TMT5842336612", "Maidenhead": "JN47fg47ao", "Mercator": {"x": 940675.301, "y": 5956763.843}, "NUTS": {"NUTS0": {"code": "CH"}, "NUTS1": {"code": "CH0"}, "NUTS2": {"code": "CH04"}, "NUTS3": {"code": "CH040"}}, "OSM": {"note_url": "https://www.openstreetmap.org/note/new#map=16/47.28167/8.45023&layers=N", "url": "https://www.openstreetmap.org/?mlat=47.28167&mlon=8.45023#map=16/47.28167/8.45023"}, "UN_M49": {"regions": {"CH": "756", "EUROPE": "150", "WESTERN_EUROPE": "155", "WORLD": "001"}, "statistical_groupings": ["MEDC"]}, "callingcode": 41, "currency": {"alternate_symbols": ["SFr", "Fr"], "decimal_mark": ".", "format": "%u %n", "html_entity": "", "iso_code": "CHF", "iso_numeric": "756", "name": "Swiss Franc", "smallest_denomination": 5, "subunit": "Rappen", "subunit_to_unit": 100, "symbol": "CHF", "symbol_first": 1, "thousands_separator": ","}, "flag": "\ud83c\udde8\ud83c\udded", "geohash": "u0qhbr378wh5twsjwwwq", "qibla": 124.74, "roadinfo": {"drive_on": "right", "speed_in": "km/h"}, "sun": {"rise": {"apparent": 1732084740, "astronomical": 1732078260, "civil": 1732082700, "nautical": 1732080420}, "set": {"apparent": 1732117500, "astronomical": 1732123920, "civil": 1732119480, "nautical": 1732121760}}, "timezone": {"name": "Europe/Zurich", "now_in_dst": 0, "offset_sec": 3600, "offset_string": "+0100", "short_name": "CET"}, "what3words": {"words": "animate.polygraph.apprehend"}}, "components": {"ISO_3166-1_alpha-2": "CH", "ISO_3166-1_alpha-3": "CHE", "_category": "place", "_normalized_city": "Affoltern am Albis", "_type": "municipality", "continent": "Europe", "country": "Switzerland", "country_code": "ch", "county": "Bezirk Affoltern", "local_administrative_area": "Affoltern am Albis", "state": "Zurich", "state_code": "ZH"}, "confidence": 9, "formatted": "Affoltern am Albis, Bezirk Affoltern, Switzerland", "geometry": {"lat": 47.28167, "lng": 8.45023}}], "status": {"code": 200, "message": "OK"}, "stay_informed": {"blog": "https://blog.opencagedata.com", "mastodon": "https://en.osm.town/@opencage"}, "thanks": "For using an OpenCage API", "timestamp": {"created_http": "Wed, 20 Nov 2024 23:24:28 GMT", "created_unix": 1732145068}, "total_results": 1}