Datasetpublic

museado/geonames-data

GeoNames Authority Data GeoNames authority SQLite databases for countries, administrative areas, and country-specific populated places. Files File Contents Rows Size ad.sqlite Andorra cities 72 77.82 kB ae.sqlite United Arab Emirates cities 2406 1.04 MB af.sqlite Afghanistan cities 32572 25.80 MB ag.sqlite Antigua and Barbuda cities 190 102.40 kB ai.sqlite Anguilla cities 45 49.15 kB al.sqlite Albania cities 4447 2.25 MB am.sqlite Armenia… See the full description on the dataset page: https://huggingface.co/datasets/museado/geonames-data.

sourceHugging Facemitupdated 2mo agoView on Hugging Face

0likes217downloads

Dataset Card

GeoNames Authority Data

GeoNames authority SQLite databases for countries, administrative areas, and country-specific populated places.

Files

File	Contents	Rows	Size
`ad.sqlite`	Andorra cities	72	77.82 kB
`ae.sqlite`	United Arab Emirates cities	2406	1.04 MB
`af.sqlite`	Afghanistan cities	32572	25.80 MB
`ag.sqlite`	Antigua and Barbuda cities	190	102.40 kB
`ai.sqlite`	Anguilla cities	45	49.15 kB
`al.sqlite`	Albania cities	4447	2.25 MB
`am.sqlite`	Armenia cities	3161	2.15 MB
`an.sqlite`	Netherlands Antilles cities	0	40.96 kB
`ao.sqlite`	Angola cities	19704	4.64 MB
`aq.sqlite`	Antarctica cities	30	106.50 kB
`ar.sqlite`	Argentina cities	14884	4.90 MB
`as.sqlite`	American Samoa cities	149	81.92 kB
`at.sqlite`	Austria cities	20913	5.61 MB
`au.sqlite`	Australia cities	19230	4.95 MB
`aw.sqlite`	Aruba cities	172	86.02 kB
`ax.sqlite`	Aland Islands cities	338	139.26 kB
`az.sqlite`	Azerbaijan cities	5299	4.07 MB
`ba.sqlite`	Bosnia and Herzegovina cities	21982	5.83 MB
`bb.sqlite`	Barbados cities	588	184.32 kB
`bd.sqlite`	Bangladesh cities	49052	13.80 MB
`be.sqlite`	Belgium cities	12669	3.66 MB
`bf.sqlite`	Burkina Faso cities	10293	2.58 MB
`bg.sqlite`	Bulgaria cities	7239	4.16 MB
`bh.sqlite`	Bahrain cities	124	135.17 kB
`bi.sqlite`	Burundi cities	6977	1.49 MB
`bj.sqlite`	Benin cities	3758	1.00 MB
`bl.sqlite`	Saint Barthelemy cities	29	49.15 kB
`bm.sqlite`	Bermuda cities	31	49.15 kB
`bn.sqlite`	Brunei cities	309	167.94 kB
`bo.sqlite`	Bolivia cities	25804	7.05 MB
`bq.sqlite`	Bonaire, Saint Eustatius and Saba cities	119	73.73 kB
`br.sqlite`	Brazil cities	72391	23.41 MB
`bs.sqlite`	Bahamas cities	354	147.46 kB
`bt.sqlite`	Bhutan cities	253	143.36 kB
`bv.sqlite`	Bouvet Island cities	0	40.96 kB
`bw.sqlite`	Botswana cities	1820	466.94 kB
`by.sqlite`	Belarus cities	26603	11.55 MB
`bz.sqlite`	Belize cities	528	212.99 kB
`ca.sqlite`	Canada cities	21673	5.69 MB
`cc.sqlite`	Cocos Islands cities	2	40.96 kB
`cd.sqlite`	Democratic Republic of the Congo cities	37231	8.13 MB
`cf.sqlite`	Central African Republic cities	5707	1.36 MB
`cg.sqlite`	Republic of the Congo cities	5807	1.41 MB
`ch.sqlite`	Switzerland cities	13199	4.14 MB
`ci.sqlite`	Ivory Coast cities	12076	3.29 MB
`ck.sqlite`	Cook Islands cities	56	49.15 kB
`cl.sqlite`	Chile cities	6967	2.54 MB
`cm.sqlite`	Cameroon cities	14374	3.39 MB
`geo.sqlite`	countries, admin1, admin2	252 / 3865 / 47549	16.15 MB
`hr.sqlite`	Croatia cities	11631	3.55 MB
`hu.sqlite`	Hungary cities	16015	5.23 MB
`it.sqlite`	Italy cities	63013	16.35 MB
`pl.sqlite`	Poland cities	47903	14.73 MB
`us.sqlite`	United States cities	193759	75.48 MB

Publishing

Suggested Hugging Face dataset id:

museado/geonames-data

Sample Rows

`geo.sqlite` `country`

bash

sqlite3 -header -column geo.sqlite "select * from country limit 3;"

text

geoname_id  iso2  iso3  iso_numeric  fips  name     capital    area    population  continent  tld  currency_code  currency_name  phone  postal_format  postal_regex       languages             neighbors  
----------  ----  ----  -----------  ----  -------  ---------  ------  ----------  ---------  ---  -------------  -------------  -----  -------------  -----------------  --------------------  -----------
49518       RW    RWA   646          RW    Rwanda   Kigali     26338   12301939    AF         .rw  RWF            Franc          250                                      rw,en-RW,fr-RW,sw     TZ,CD,BI,UG
51537       SO    SOM   706          SO    Somalia  Mogadishu  637657  15008154    AF         .so  SOS            Shilling       252    @@  #####      ^([A-Z]{2}\d{5})$  so-SO,ar-SO,it,en-SO  ET,KE,DJ   
69543       YE    YEM   887          YM    Yemen    Sanaa      527970  28498687    AS         .ye  YER            Rial           967                                      ar-YE                 SA,OM

`geo.sqlite` `admin1`

bash

sqlite3 -header -column geo.sqlite "select * from admin1 limit 3;"

text

geoname_id  code   country_code  admin1_code  name             ascii_name     
----------  -----  ------------  -----------  ---------------  ---------------
50360       SO.20  SO            20           Woqooyi Galbeed  Woqooyi Galbeed
51230       SO.19  SO            19           Togdheer         Togdheer       
51966       SO.14  SO            14           Lower Shabeelle  Lower Shabeelle

`geo.sqlite` `admin2`

bash

sqlite3 -header -column geo.sqlite "select * from admin2 limit 3;"

text

geoname_id  code         country_code  admin1_code  admin2_code  name               ascii_name       
----------  -----------  ------------  -----------  -----------  -----------------  -----------------
6550        IR.42.6550   IR            42           6550         Dāvarzan          Davarzan         
28354       IR.10.28354  IR            10           28354        Darrehshahr        Darrehshahr      
65061       SO.09.65061  SO            09           65061        Degmada Badhaadhe  Degmada Badhaadhe

`us.sqlite` `city`

bash

sqlite3 -header -column us.sqlite "select * from city limit 1;"

text

geoname_id  name      ascii_name  alternate_names                                                                                                                                                           latitude  longitude  feature_class  feature_code  country_code  admin1_code  admin2_code  population  timezone      modification_date
----------  --------  ----------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------  --------  ---------  -------------  ------------  ------------  -----------  -----------  ----------  ------------  -----------------
4045510     Amchitka  Amchitka    AHT,Amchitka,Amcitka,Amčitka,Isla Amchitka,a mu qi te ka dao,amshytka,amuchitoka dao,Амчитка,אמציטקה,أمشيتكا,アムチトカ島,阿姆奇特卡島  51.56722  178.8775   P              PPL           US            AK           016          0           America/Adak  2010-01-30

Bundle Usage

bash

./admin download
./admin build --force
./admin metadata

The SQLite file is intended to be fetched by survos/geonames-bundle and queried locally through the bundle's runtime lookup service.

GeoNames Authority Data

Files

Publishing

Sample Rows

geo.sqlite country

geo.sqlite admin1

geo.sqlite admin2

us.sqlite city

Bundle Usage

`geo.sqlite` `country`

`geo.sqlite` `admin1`

`geo.sqlite` `admin2`

`us.sqlite` `city`