Geocode Result

Use this query to check the results:

select * from all_data_result;

Use this query to verify the successful geocoded results:

select country,count(country) from all_data_result 
where parse_json(address):status = 'OK' 
group by country;

Use this query to verify the records that were unable to geocode:

select country,count(country) from all_data_result 
where parse_json(address):status != 'OK'
group by country;