Is there English geolocation data in Big Query's public dataset for GeoLite by Maxmind?

Question

When querying the geolite public dataset in Big Query found here, the results are for the 'es' locale. Is there 'en' locale data available in the public dataset or do we need to manually download the english data from Maxmind and insert it to our own Big Query datasets? I was hoping this data was maintained by Big Query public dataset owner.

Sample query:

SELECT * FROM 'bigquery-public-data.geolite2.ipv4_city_locations' WHERE city_name = 'Vancouver';

Result:

For more context: Big Query and Geolocation

Answer 1

As far as I know, there is no table with en locale in geolite Bigquery public datasets.

The best solution would be placing english data in BigQuery manually. Firstly, please download .zip file at Maxmind, which contains a single directory with 13 files. Eight CSV files contains data location for each locale code, where locale can be de, en, es, fr, ja, pt-BR, ru, and zh-CN. You should see csv similar to this one: GeoLite2-{Content}-Locations-en.csv.

I hope you find the above pieces of information useful.

Answer 2

I filed an issue to get this fixed. Track it at https://issuetracker.google.com/issues/149249389.

In the meantime, use my tables. This one only encodes for 'en':

SELECT *
FROM `fh-bigquery.geocode.201806_geolite2_city_locations_en`  
WHERE city_name = 'Vancouver'