museado/geonames-data

1---2pretty_name: GeoNames Authority Data3license: mit4language:5- en6tags:7- geonames8- authority9- sqlite10- geography11viewer: false12task_categories:13- text-retrieval14---15 16# GeoNames Authority Data17 18GeoNames authority SQLite databases for countries, administrative areas, and country-specific populated places.19 20## Files21 22| File | Contents | Rows | Size |23| --- | --- | ---: | ---: |24| `ad.sqlite` | Andorra cities | 72 | 77.82 kB |25| `ae.sqlite` | United Arab Emirates cities | 2406 | 1.04 MB |26| `af.sqlite` | Afghanistan cities | 32572 | 25.80 MB |27| `ag.sqlite` | Antigua and Barbuda cities | 190 | 102.40 kB |28| `ai.sqlite` | Anguilla cities | 45 | 49.15 kB |29| `al.sqlite` | Albania cities | 4447 | 2.25 MB |30| `am.sqlite` | Armenia cities | 3161 | 2.15 MB |31| `an.sqlite` | Netherlands Antilles cities | 0 | 40.96 kB |32| `ao.sqlite` | Angola cities | 19704 | 4.64 MB |33| `aq.sqlite` | Antarctica cities | 30 | 106.50 kB |34| `ar.sqlite` | Argentina cities | 14884 | 4.90 MB |35| `as.sqlite` | American Samoa cities | 149 | 81.92 kB |36| `at.sqlite` | Austria cities | 20913 | 5.61 MB |37| `au.sqlite` | Australia cities | 19230 | 4.95 MB |38| `aw.sqlite` | Aruba cities | 172 | 86.02 kB |39| `ax.sqlite` | Aland Islands cities | 338 | 139.26 kB |40| `az.sqlite` | Azerbaijan cities | 5299 | 4.07 MB |41| `ba.sqlite` | Bosnia and Herzegovina cities | 21982 | 5.83 MB |42| `bb.sqlite` | Barbados cities | 588 | 184.32 kB |43| `bd.sqlite` | Bangladesh cities | 49052 | 13.80 MB |44| `be.sqlite` | Belgium cities | 12669 | 3.66 MB |45| `bf.sqlite` | Burkina Faso cities | 10293 | 2.58 MB |46| `bg.sqlite` | Bulgaria cities | 7239 | 4.16 MB |47| `bh.sqlite` | Bahrain cities | 124 | 135.17 kB |48| `bi.sqlite` | Burundi cities | 6977 | 1.49 MB |49| `bj.sqlite` | Benin cities | 3758 | 1.00 MB |50| `bl.sqlite` | Saint Barthelemy cities | 29 | 49.15 kB |51| `bm.sqlite` | Bermuda cities | 31 | 49.15 kB |52| `bn.sqlite` | Brunei cities | 309 | 167.94 kB |53| `bo.sqlite` | Bolivia cities | 25804 | 7.05 MB |54| `bq.sqlite` | Bonaire, Saint Eustatius and Saba cities | 119 | 73.73 kB |55| `br.sqlite` | Brazil cities | 72391 | 23.41 MB |56| `bs.sqlite` | Bahamas cities | 354 | 147.46 kB |57| `bt.sqlite` | Bhutan cities | 253 | 143.36 kB |58| `bv.sqlite` | Bouvet Island cities | 0 | 40.96 kB |59| `bw.sqlite` | Botswana cities | 1820 | 466.94 kB |60| `by.sqlite` | Belarus cities | 26603 | 11.55 MB |61| `bz.sqlite` | Belize cities | 528 | 212.99 kB |62| `ca.sqlite` | Canada cities | 21673 | 5.69 MB |63| `cc.sqlite` | Cocos Islands cities | 2 | 40.96 kB |64| `cd.sqlite` | Democratic Republic of the Congo cities | 37231 | 8.13 MB |65| `cf.sqlite` | Central African Republic cities | 5707 | 1.36 MB |66| `cg.sqlite` | Republic of the Congo cities | 5807 | 1.41 MB |67| `ch.sqlite` | Switzerland cities | 13199 | 4.14 MB |68| `ci.sqlite` | Ivory Coast cities | 12076 | 3.29 MB |69| `ck.sqlite` | Cook Islands cities | 56 | 49.15 kB |70| `cl.sqlite` | Chile cities | 6967 | 2.54 MB |71| `cm.sqlite` | Cameroon cities | 14374 | 3.39 MB |72| `geo.sqlite` | countries, admin1, admin2 | 252 / 3865 / 47549 | 16.15 MB |73| `hr.sqlite` | Croatia cities | 11631 | 3.55 MB |74| `hu.sqlite` | Hungary cities | 16015 | 5.23 MB |75| `it.sqlite` | Italy cities | 63013 | 16.35 MB |76| `pl.sqlite` | Poland cities | 47903 | 14.73 MB |77| `us.sqlite` | United States cities | 193759 | 75.48 MB |78 79## Publishing80 81Suggested Hugging Face dataset id:82 83`museado/geonames-data`84 85## Sample Rows86 87### `geo.sqlite` `country`88 89```bash90sqlite3 -header -column geo.sqlite "select * from country limit 3;"91```92 93```text94geoname_id  iso2  iso3  iso_numeric  fips  name     capital    area    population  continent  tld  currency_code  currency_name  phone  postal_format  postal_regex       languages             neighbors  95----------  ----  ----  -----------  ----  -------  ---------  ------  ----------  ---------  ---  -------------  -------------  -----  -------------  -----------------  --------------------  -----------9649518       RW    RWA   646          RW    Rwanda   Kigali     26338   12301939    AF         .rw  RWF            Franc          250                                      rw,en-RW,fr-RW,sw     TZ,CD,BI,UG9751537       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   9869543       YE    YEM   887          YM    Yemen    Sanaa      527970  28498687    AS         .ye  YER            Rial           967                                      ar-YE                 SA,OM      99```100 101### `geo.sqlite` `admin1`102 103```bash104sqlite3 -header -column geo.sqlite "select * from admin1 limit 3;"105```106 107```text108geoname_id  code   country_code  admin1_code  name             ascii_name     109----------  -----  ------------  -----------  ---------------  ---------------11050360       SO.20  SO            20           Woqooyi Galbeed  Woqooyi Galbeed11151230       SO.19  SO            19           Togdheer         Togdheer       11251966       SO.14  SO            14           Lower Shabeelle  Lower Shabeelle113```114 115### `geo.sqlite` `admin2`116 117```bash118sqlite3 -header -column geo.sqlite "select * from admin2 limit 3;"119```120 121```text122geoname_id  code         country_code  admin1_code  admin2_code  name               ascii_name       123----------  -----------  ------------  -----------  -----------  -----------------  -----------------1246550        IR.42.6550   IR            42           6550         Dāvarzan          Davarzan         12528354       IR.10.28354  IR            10           28354        Darrehshahr        Darrehshahr      12665061       SO.09.65061  SO            09           65061        Degmada Badhaadhe  Degmada Badhaadhe127```128 129### `us.sqlite` `city`130 131```bash132sqlite3 -header -column us.sqlite "select * from city limit 1;"133```134 135```text136geoname_id  name      ascii_name  alternate_names                                                                                                                                                           latitude  longitude  feature_class  feature_code  country_code  admin1_code  admin2_code  population  timezone      modification_date137----------  --------  ----------  ------------------------------------------------------------------------------------------------------------------------------------------------------------------------  --------  ---------  -------------  ------------  ------------  -----------  -----------  ----------  ------------  -----------------1384045510     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       139```140 141## Bundle Usage142 143```bash144./admin download145./admin build --force146./admin metadata147```148 149The SQLite file is intended to be fetched by `survos/geonames-bundle` and queried locally through the bundle's runtime lookup service.