Overall summary

13 371 410 places and 18 647 997 alternate names in total. Constituent files:

Field usage overview

Legend for the tables below:

In total, 17 distinct fields are used.

Main table

field geonames r_p dist_vals e_vals n
name 13,371,410 100% 8,226,706 Dawa Musa (1)|Bull Trap Canyon (1)|Pont Sofia (2)|Daman Khahare (1)|Minde Village (2)|Rongrian Anuban Hankha (1)|Souéné (1) 13,371,410
asciiname 13,371,410 100% 8,099,596 Rio Vilcas (2)|San Rafael Spring (1)|Matade (3)|Dirty Spur (1)|Puerto El Cuyo (1)|Ulpotagava Oya (1)|Buker Hill (1) 13,371,410
latitude 13,371,410 100% 5,601,569 51.14905 (1)|-29.19731 (2)|65.81604 (1)|-33.18333 (87)|30.82681 (1)|20.60166 (3)|26.84333 (4) 13,371,410
dem 13,371,410 100% 6,856 3658 (97)|8505 (1)|2136 (854)|763 (3,119)|1547 (1,509)|3604 (78)|1124 (2,375) 13,371,410
modification_date 13,371,410 100% 8,977 2024-06-13 (55)|2014-01-03 (286)|1993-11-01 (171)|2015-05-11 (148)|2007-03-08 (5)|2008-01-12 (4)|2016-06-11 (58) 13,371,410
longitude 13,371,410 100% 7,855,047 34.00918 (1)|33.47783 (2)|-179.80301 (1)|-98.01972 (7)|138.42574 (1)|68.49194 (2)|84.9373 (1) 13,371,410
timezone 13,371,410 100% 419 Asia/Dili (7,886)|America/Curacao (503)|America/Guadeloupe (4,087)|America/Indiana/Knox (196)|America/Anchorage (20,947)|Asia/Famagusta (2,231)|America/Maceio (3,256) 13,371,410
population 13,371,408 100% 67,005 19000 (9)|33081 (3)|125373 (1)|22058 (3)|13719 (7)|14451 (8)|77017 (1) 13,371,408
feature_class 13,366,404 99.96% 9 S (2,534,396)|L (490,385)|R (57,403)|U (15,523)|V (122,889)|T (1,825,465)|P (5,176,636) 13,366,404
country_code 13,364,419 99.95% 253 CA (315,927)|PT (38,291)|TH (264,775)|SB (9,403)|PE (111,499)|GD (792)|MK (25,481) 13,364,419
admin1_code 13,334,666 99.73% 819 119 (157)|250 (18)|x83 (1)|99 (172)|22 (86,298)|97614 (12)|G6 (34) 13,334,666
feature_code 13,276,444 99.29% 678 FLD (51,648)|RDA (51)|MFGCU (5)|SPNS (13)|PND (99,288)|TERU (46)|RES (10,206) 13,276,444
admin2_code 9,577,116 71.62% 33,751 2412005 (18)|4811013 (2)|7268133 (20)|243 (1,494)|4111506 (7)|401 (3,890)|18200 (182) 9,577,116
admin3_code 3,948,437 29.53% 141,204 175322000 (64)|12096128 (20)|595578 (3)|533629 (5)|8736974 (1)|09913 (1)|582468 (3) 3,948,437
elevation 2,389,640 17.87% 5,831 1054 (278)|94 (3,346)|5758 (2)|853 (378)|1025 (441)|2534 (131)|4297 (4) 2,389,640
admin4_code 818,723 6.12% 229,650 57415 (3)|190088 (10)|12651145 (1)|3227015 (2)|7081574 (1)|11815068 (1)|44420010006 (2) 818,723
cc2 12,382 0.09% 776 HR,SI (1)|GU (1)|IT,MT,TN (1)|RW,TZ (1)|NO,FI,SE (1)|CY,GB (1)|QA (1) 12,382

Alternate names table

In total, 9 distinct fields are used.

field geonames r_p dist_vals e_vals n vals_per_rec geonames_with_mult_vals
is_historic 8,056,777 60.25% 2 false (18,611,304)|true (36,693) 18,647,997 2.31 4,967,808
alternate_name_id 8,056,777 60.25% 18,647,997 3267992 (1)|2297004 (1)|18263562 (1)|2185589 (1)|7380996 (1)|8029954 (1)|16841820 (1) 18,647,997 2.31 4,967,808
alternate_name 8,056,777 60.25% 11,908,039 Stop Falls (1)|Duuɗe Kap Weer (1)|Dahan-e Tangal (4)|Monte Chilalelo (1)|Circondario del Prignitz (1)|Geumho Bestville 2 Danji Apartment (1)|Lower Bois (1) 18,647,997 2.31 4,967,808
is_short_name 8,056,777 60.25% 2 true (129,382)|false (18,518,615) 18,647,997 2.31 4,967,808
is_colloquial 8,056,777 60.25% 2 true (4,767)|false (18,643,230) 18,647,997 2.31 4,967,808
is_preferred_name 8,056,777 60.25% 2 false (18,098,786)|true (549,211) 18,647,997 2.31 4,967,808
isolanguage 6,958,406 52.04% 711 khw (1)|en-GB (444)|nv (896)|wal (41)|mus (31)|de-AT (32)|stl (20) 11,392,914 1.64 1,597,967
to 3,125 0.02% 312 1816 (1)|669 (1)|2003 (9)|1762 (1)|1805 (4)|1963 (21)|20090903 (2) 6,076 1.94 957
from 3,064 0.02% 352 20200229 (1)|397 (1)|1759 (1)|1801 (2)|1926 (9)|1944 (8)|1958 (2) 5,240 1.71 914

Generation time: 33.9914560317993