Skip to content

Instantly share code, notes, and snippets.

@pnorman

pnorman/names.csv

Last active March 25, 2018 09:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pnorman/db4e39ae3e25034f1141e6adb5aa7c2f to your computer and use it in GitHub Desktop.
Save pnorman/db4e39ae3e25034f1141e6adb5aa7c2f to your computer and use it in GitHub Desktop.
Download ZIP
name data
Raw
names.csv
2808870 name:en
1035545 name:ru
559728 name:ja
488167 name:de
464426 name:fr
410579 name:ar
352527 name:zh
328441 name:uk
277724 name:fi
190678 name:es
177255 name:ko
177071 name:be
161042 name:pl
151793 name:he
143598 name:ko_rm
143555 name:prefix
138182 name:ga
135764 name:ar1
126094 name:sv
103569 name:it
101694 name:ja_rm
100001 name:lt
97477 name:sr
89519 name:cs
78848 name:ca
72924 name:nl
71981 name:kn
70443 name:th
69152 name:pt
65724 name:sr-Latn
65707 name:hu
65401 name:el
60995 name:genitive
60257 name:ka
59126 name:br
55771 name:vi
54037 name:zh_pinyin
53049 name:ro
52474 name:botanical
49140 name:ja_kana
46375 name:eo
45259 name:eu
39512 name:fa
37324 name:tr
37209 name:bg
36208 name:hy
34317 name:ku
33798 name:lv
33283 name:sk
32578 name:hsb
32328 name:tt
32273 name:kk
32002 name:hr
30762 name:sl
30579 name:oc
29931 name:la
29741 name:ta
29726 name:mr
29322 name:no
29213 name:ur
28812 name:cy
28629 name:gl
28550 name:my
28066 name:az
27812 name:mk
27649 name:en1
27293 name:hi
26877 name:mn
26752 name:et
26550 name:ms
26256 name:os
25792 name:af
25218 name:right
25198 name:left
24439 name:uz
24250 name:be-tarask
24205 name:da
23860 name:id
23807 name:cv
23189 name:gd
23187 name:nn
23137 name:etymology:wikidata
22824 name:fy
22552 name:ml
21749 name:sq
21367 name:bs
21220 name:lb
21160 name:bn
20568 name:ne
20518 name:am
19949 name:sh
19582 name:an
19511 name:is
19449 name:bo
19410 name:tg
19130 name:se
19099 name:ast
19009 name:gv
19008 name:kab
18997 name:ba
18954 name:ug
18926 name:io
18926 name:tl
18505 name:sw
18402 name:pa
18394 name:yi
18280 name:kw
18170 name:ce
17779 name:su
17383 name:ps
17366 name:qu
17305 name:vo
17214 name:fo
17174 name:tk
17037 name:ia
17035 name:scn
16748 name:pnb
16734 name:yo
16319 name:nds
16246 name:szl
16125 name:ht
16061 name:ckb
16000 name:frp
15978 name:te
15770 name:jv
15695 name:dsb
15686 name:war
15669 name:or
15648 name:sco
15526 name:li
15085 name:ie
15080 name:ky
15066 name:so
15061 name:sah
14927 name:wo
14922 name:tzl
14903 name:pms
14788 name:crh
14754 name:rw
14704 name:zh-yue
14701 name:lmo
14587 name:zh-min-nan
14581 name:ext
14539 name:xal
14432 name:nov
14293 name:mt
14271 name:diq
14269 name:sc
14239 name:lij
14176 name:jbo
14160 name:bat-smg
14154 name:vec
14070 name:nah
13992 name:dv
13985 name:arz
13964 name:gu
13734 name:bpy
13721 name:ber
13708 name:ceb
13700 name:mg
13607 name:ilo
13591 name:hif
13572 name:pam
13548 name:gag
13539 name:nv
13468 name:ln
13441 name:als
13426 name:bxr
13192 name:fiu-vro
13191 name:en2
13072 name:bcl
12886 name:zu
12820 name:gn
12764 name:hak
12605 name:kl
12476 name:ang
12455 name:wuu
12413 name:mi
12402 name:ace
12229 name:ee
12197 name:zea
12152 name:sa
12124 name:pih
12045 name:fur
12018 name:zh-classical
12017 name:kv
11999 name:rm
11922 name:na
11918 name:bar
11775 name:km
11764 name:pap
11760 name:stq
11647 name:ss
11594 name:co
11521 name:haw
11459 name:frr
11367 name:udm
11366 name:mhr
11202 name:kbd
11097 name:rue
11087 name:wa
11050 name:csb
10963 name:lad
10853 name:lez
10849 name:arc
10665 name:si
10530 name:ja-Latn
10503 name:mzn
10415 name:lo
10333 name:xmf
10182 name:kn:iso15919
10087 name:bm
10003 name:dz
9880 name:nds-nl
9698 name:mdf
9625 name:new
9606 name:mrj
9508 name:vep
9491 name:roa-tara
9440 name:source
9382 name:chr
9310 name:cu
9247 name:kg
9189 name:tpi
9042 name:krc
8970 name:ltg
8962 name:sg
8911 name:ki
8887 name:za
8841 name:bi
8811 name:kaa
8772 name:sm
8715 name:tet
8434 name:nap
8361 name:ha
8335 name:nrm
8316 name:gan
8127 name:cdo
8014 name:sn
8010 name:vls
7819 name:ay
7769 name:rn
7602 name:full
7405 name:pcd
7313 name:min
7287 name:ts
7242 name:to
7127 name:cbk-zam
7037 name:srn
7025 name:ff
6984 name:pdc
6982 name:ig
6950 name:nso
6801 name:ti
6792 name:iu
6788 name:mwl
6659 name:as
6549 name:tok
6546 name:rmy
6510 name:pag
6461 name:bjn
6412 name:ab
6389 name:lg
6363 name:roa-rup
6297 name:om
6258 name:myv
6245 name:ks
6234 name:en3
6200 name:chy
6192 name:koi
6192 name:ty
6034 name:statcan_rbuid
6004 name:tw
5987 name:pnt
5926 name:ak
5889 name:gsw
5811 name:av
5636 name:ksh
5563 name:ja-Hira
5514 name:bug
5492 name:alt
5409 name:pfl
5013 name:eml
4968 name:md
4957 name:simple
4823 name:st
4531 name:prefix:at
4416 name:sd
3952 name:map-bms
3945 name:tum
3761 name:he1
3618 name:xh
3605 name:zh_py
3546 name:ik
3423 name:jp
3233 name:lbe
2983 name:ch
2941 name:bh
2924 name:ko_hanja
2883 name:en4
2813 name:adjective
2771 name:yue
2741 name:ny
2638 name:ve
2627 name:zgh
2465 name:jam
2440 name:azb
2345 name:dty
2319 name:olo
2244 name:ady
2237 name:pi
2216 name:nb
2214 name:gom
2143 name:kbp
2064 name:UN:es
2064 name:UN:ru
2064 name:UN:zh
2064 name:UN:fr
2064 name:UN:en
2064 name:UN:ar
1994 name:mai
1928 name:language
1877 name:lrc
1690 name:glk
1660 name:tyv
1630 name:zh-simplified
1623 name:zh-traditional
1554 name:zh-hant
1440 name:suffix:en
1376 name:sme
1291 name:proposed
1278 name:tn
1268 name:fj
1203 name:pronunciation
1172 name:ru:word_stress
1103 name:prefix:bg
1089 name:fr-x-gallo
1081 name:ii
1077 name:en5
1061 name:gcf
1057 name:cr
1052 name:nan
966 name:th-Latn
936 name:old
880 name:historic
849 name:lld
848 name:short
835 name:suffix
762 name:np
747 name:egl
695 name:aa
670 name:tt-lat
662 name:desc
589 name:az-cyr
587 name:got
579 name:RATP
577 name:carnaval
553 name:he2
534 name:tcy
473 name:ku-Arab
470 name:pt-br
464 name:abbreviation
461 name:zh-hans
459 name:bridge
455 name:int
419 name:lo_rm
404 name:uz-cyr
356 name:mo
350 name:he3
342 name:cz
329 name:etymology
309 name:gr
306 name:highway
301 name:bua
300 name:suffix:fr
298 name:crh-cyr
292 name:signed
291 name:grc
288 name:ja_Latn
270 name:informal
268 name:prefix:de
265 name:zh_pyt
263 name:wae
261 name:plsr
255 name:tunnel
251 name:brx
247 name:en6
246 name:zh-py
245 name:loc
242 name:gem
240 name:wikipedia
239 name:railway
238 name:vi-hani
238 name:ua
224 name:uk:word_stress
220 name:note
214 name:etymology:wikipedia
213 name:t4t35.fr
212 name:el:en
200 name:svhl
195 name:abbr
194 name:oym
190 name:güterweg
185 name:fr-x-norman
179 name:smg
165 name:De_Lijn
163 name:cadastre
158 name:start_date
145 name:backward
145 name:zh-CN
142 name:forward
142 name:rcn_ref
141 name:krl
139 name:ဗမာ
138 name:viaduct
136 name:thv
133 name:cop
125 name:iso15919
125 name:al
123 name:mh
117 name:inh
114 name:teryt
114 name:kum
111 name:zh-cn
108 name:sign
107 name:TEC
106 name:fr_illenoo
104 name:swg
101 name:absent
100 name:sva_rm
98 name:atv
95 name:fkv
95 name:
93 name:woa
91 name:Census_Division_Type
91 name:Census_Division
91 name:Census_Type_Code
90 name:arq
89 name:link
88 name:zh_trad
87 name:chm
87 name:zn
85 name:start_date:source:wikidata
85 name:mhn
85 name:bal
85 name:cn
85 name:official
84 name:eme
84 name:rrp
83 name:syc
82 name:zh-Hant
82 name:nmn
78 name:kz
78 name:tzl_1
75 name:Transisère
75 name:ro_1
74 name:din
73 name:kr
73 name:2
73 name:zh-Hant-CN
73 name:pwn
72 name:dative
72 name:el-Latn
72 name:zn-cn
71 name:zh-Latn-pinyin
71 name:zh-Hans
71 name:smj
70 name:type
70 name:diff
68 name:ja_en
67 name:1
67 name:xiaoerjing
63 name:mos
63 name:dyu
63 name:en_1
61 name:ျမန္မာဘာသာ
60 name:IRIS
60 name:ja_hira
60 name:tibt
60 name:aba
58 name:ar2
57 name:zh-tw
56 name:zh-hk
56 name:OYO
54 name:sdn
53 name:ru:old
53 name:kjh
52 name:wikidata
52 name:local
52 name:fr-x-fc
52 name:em
52 name:aae
51 name:bg_Ltn
50 name:hil
49 name:nog
48 name:shn
48 name:ru1
48 name:cbk
48 name:Nawat
46 name:wya
46 name:prefix:en
45 name:sdc
44 name:yrk
44 name:ex
44 name:evn
42 name:at
42 name:technical
42 name:griffithsvaluation
41 name:ssa
41 name:en7
41 name:tmh
40 name:ru_rm
40 name:original
40 name:vn
39 name:en:pronunciation
39 name:rgn
39 name:vro
37 name:bat
37 name:lat
36 name:sms
36 name:smn
35 name:de_1
35 name:dar
34 name:oj
34 name:tab
33 name:ota
33 name:rar
32 name:fla
31 name:source:en
31 name:be-x-old
31 name:Lat
31 name:lou
31 name:induk_idn
30 name:bfs
30 name:1989-
30 name:ale
30 name:prefix:kk
29 name:1906--1920-04-12
29 name:1952-1989
29 name:clw
29 name:1900-1906
29 name:1920-04-12--1952
29 name:zh-sg
28 name:ibg
28 name:1952-1990
28 name:former
28 name:kazakh_arabicscript
28 name:zh-TW
28 name:zh_cn
27 name:1944-1952
27 name:species
27 name:description
27 name:ket
27 name:snk
27 name:eh
27 name:-1840
27 name:1877-1924
27 name:HVV
27 name:1840-1877
26 name:right:en
26 name:ypk
25 name:census1901
25 name:eng
25 name:fr-lor
24 name:Autrans
24 name:hafas
24 name:de:-1945
24 name:Pinyin
23 name:ar-Latn
23 name:kut
23 name:ko-rm
23 name:1947-1951
23 name:abq
23 name:see
23 name:zh-mo
23 name:kmr
23 name:en8
23 name:VBB
23 name:i-mingo
23 name:left:en
23 name:lit
22 name:2017-12-25-
22 name:dk
22 name:zh-Hant-tw
22 name:2016
22 name:zh-Hans-cn
22 name:alternative
22 name:-2017-12-25
22 name:fullname
21 name:right:ru
21 name:lanes
21 name:sma
21 name:ca-valencia
21 name:Gsw
21 name:saxon
21 name:honorary
21 name:Maps4BW
21 name:ru:alt
21 name:left:ru
20 name:left:zh
20 name:right:zh-classical
20 name:left:zh-classical
20 name:prs
20 name:ar3
20 name:right:zh-simplified
20 name:right:zh_trad
20 name:left:zh-traditional
20 name:bridge:de
20 name:bridge:en
20 name:left:zh_pinyin
20 name:liv
20 name:1924-1931
20 name:right:zh-traditional
20 name:T4T35.fr
20 name:left:zh_trad
20 name:right:zh
20 name:suffix:de
20 name:historical
20 name:myth
20 name:1931-1944
20 name:right:zh_pinyin
20 name:left:zh-simplified
19 name:fro
19 name:en:0--2017-04-12
19 name:1922--2016-04-15
19 name:suffix:bg
19 name:ko_hanja:0--2014-04-12
19 name:ru:0--2017-04-12
19 name:alt_name
19 name:ko_rm_2
19 name:0--2017-04-12
19 name:left:ko
19 name:-1994-10-17
19 name:right:ko
19 name:2017
19 name:tag
19 name:ko:0--2017-04-12
19 name:ro_2
18 name:bridge:sv
18 name:dialect
18 name:bridge:da
18 name:de:prefix
18 name:right:ko_hanja
18 name:je
18 name:2015
18 name:source_ref
18 name:left:ko_hanja
18 name:ko-han
18 name:smi
18 name:--2005-07-04
18 name:2010
17 name:hans
17 name:signposted
17 name:ja_kana:source_ref
17 name:zh-hant-CN
17 name:alter
16 name:krj
16 name:survey:date
16 name:practitioner
16 name:gbif_equivalent_tag
16 name:ms-Arab
16 name:old_name
16 name:ge
16 name:individualID
15 name:el_lat
15 name:te
15 name:ckb-Latn
15 name:fr:suffix
15 name:bto
15 name:kio
15 name:acronym
15 name:dru
15 name:pinyin
15 name:census1911
15 name:-2001-02-12
14 name:1609--
14 name:1939-12-12--1994-12-15
14 name:ksb
14 name:me
14 name:1863
14 name:ar_1
14 name:1585--1609
14 name:left:nl
14 name:long
14 name:by
14 name:fil
14 name:alt_1
14 name:teen
13 name:2014
13 name:Ber
13 name:rs
13 name:Alsacien
13 name:pjt
13 name:2013
13 name:2005
13 name:ja_eng
12 name:kor
12 name:chl
12 name:1956-2016
12 name:2006
12 name:source:ga
12 name:brand
12 name:1969
11 name:1947-1991
11 name:1961-1989_11_09
11 name:lo:prefix
11 name:operator
11 name:1945-1947
11 name:xtz
11 name:future
11 name:azafady
11 name:cobbles
11 name:ru_1
11 name:vernacular
11 name:mnc
11 name:left:fr
11 name:bnn
11 name:postfix
10 name:wrong
10 name:ru:loc
10 name:en9
10 name:room
10 name:cim
10 name:Dalatrafik
10 name:VL
10 name:xmz
10 name:maybe
10 name:short_name
10 name:sr-Latin-translit_bot
10 name:mtb
10 name:other
10 name:zh_arab
10 name:1888
10 name:trv
10 name:ms-jawi
10 name:source:date
9 name:sr-Latn-ai
9 name:lim
9 name:Transports_Scolaires
9 name:aec31
9 name:ami
9 name:color
9 name:bnt
9 name:2007
9 name:mus
9 name:zn-hk
9 name:bnt_rm
9 name:rut
9 name:vot
9 name:dak
8 name:ro_3
8 name:sardo
8 name:en-PH
8 name:invisible
8 name:lzh
8 name:2003
8 name:not
8 name:os-dig
8 name:OhreBus
8 name:squ
8 name:second
8 name:zh-Hant-hk
8 name:1973
8 name:2012
8 name:xbg
8 name:2008
8 name:3
8 name:sanskrit
8 name:cycleway
8 name:mhs
8 name:be_tarask
8 name:fr_1
8 name:1556--1922
8 name:1922--
7 name:railroad
7 name:1924-1944
7 name:1945-
7 name:mk_Latn
7 name:1900
7 name:1965
7 name:1972
7 name:es:pronunciation
7 name:disused
7 name:scenic
7 name:1968
7 name:1957
7 name:1940-1946
7 name:1907
7 name:sju
7 name:1995
7 name:en_us
7 name:street
7 name:2011
7 name:alt:pl
7 name:1963
7 name:fi:plural
7 name:building
7 name:third
7 name:osm:temporary
7 name:eo_1
7 name:hvv
6 name:1917
6 name:2001
6 name:2004
6 name:Amis
6 name:de_AT
6 name:1983
6 name:1929
6 name:2009
6 name:ja_roma
6 name:en10
6 name:-2016
6 name:2002
6 name:jingpho
6 name:Fil Vert
6 name:prefix:state
6 name:4
6 name:-1933
6 name:tai_tainua
6 name:1933-1940
6 name:izh
6 name:ga-2
6 name:ja_furigana
6 name:hu_1
6 name:1992
6 name:jp_Hira
6 name:0000-2010
6 name:international
6 name:romanji
6 name:KVG
6 name:ga-1
6 name:mse
6 name:ms-arab
6 name:cym
6 name:alt_2
6 name:Ruotsi
6 name:TER
6 name:-2013
6 name:zh_1
6 name:prefix:city
6 name:1890
6 name:jp_Latn
6 name:1556?-1922
6 name:1939-1945
6 name:-2017
5 name:kyrgyz_arabicscript
5 name:telebus
5 name:1998
5 name:ikt
5 name:1972-1998
5 name:os-lat
5 name:1914
5 name:win
5 name:fpr
5 name:1907-1945
5 name:ru:plural
5 name:Tamazight
5 name:1976
5 name:nl:left
5 name:nl:right
5 name:1938
5 name:1939-1975
5 name:mn_mong
5 name:2002-
5 name:gag-cyr
5 name:1989
5 name:right:fr
5 name:sr-Latin-ai-translit_bot
5 name:slr
5 name:popular
5 name:he4
5 name:1891
5 name:1925-
5 name:1926
5 name:explanation
5 name:1895
5 name:lisu
5 name:station
5 name:1997
5 name:2000
5 name:right:nl
5 name:ja_kan
5 name:900
5 name:road
5 name:lzz
5 name:Latn
5 name:zh_tw
5 name:ru-Latn
5 name:ga:absent
5 name:1988
5 name:esr
5 name:de_DE
5 name:kana
5 name:1998-2002
5 name:fi:alt
5 name:network
5 name:1892
4 name:bridge:official
4 name:sr_1
4 name:verkeiersverbond
4 name:1951
4 name:STAR
4 name:zh-Hant-TW
4 name:1979
4 name:asb
4 name:metrolor
4 name:rfi
4 name:translate:en
4 name:1987
4 name:1971
4 name:he_1
4 name:ACE
4 name:elf
4 name:intl
4 name:1936
4 name:1966
4 name:zh-Hans-CN
4 name:ban
4 name:1916
4 name:1954-1994
4 name:roma
4 name:1986
4 name:zh_hant
4 name:rad
4 name:2016-
4 name:en11
4 name:1954
4 name:zh_TW
4 name:1919-1939
4 name:1935-1942
4 name:roundabout
4 name:int_name
4 name:basemap
4 name:AST
4 name:Deutschmd
4 name:2017-
4 name:1901
4 name:1985-1990
4 name:1609
4 name:en-CN
4 name:Amtrak
4 name:sal
4 name:bridge:local
4 name:acryonym
4 name:possible
4 name:ga:source
4 name:1993
4 name:1927
4 name:hur
4 name:tzm
4 name:indonesia
4 name:demolished
4 name:alt_prefix
4 name:iw
4 name:1970
4 name:1932
4 name:1950
4 name:historic_1
4 name:1919
4 name:1885
4 name:Lila
4 name:Ladin
4 name:1946-1956
4 name:alt_3
4 name:1942-1946
4 name:1856
4 name:formerly
4 name:1856-2016
4 name:1982
4 name:PESEL
4 name:tai_tailu
4 name:CoTraL
4 name:中国
3 name:en_2
3 name:zh2
3 name:kaa-cyr
3 name:fi_1
3 name:1889
3 name:prefix:cs
3 name:tsu
3 name:Fiumalbino
3 name:1962
3 name:religion
3 name:name_1
3 name:1931-1939
3 name:Amazigh
3 name:Zh_py
3 name:alternate
3 name:project
3 name:1990
3 name:1974
3 name:kn:alt
3 name:1897
3 name:1896
3 name:1953-1990
3 name:1968-2010
3 name:1935-1943
3 name:Dialetto
3 name:1870
3 name:Ирон
3 name:800
3 name:was
3 name:1913
3 name:1923
3 name:Myanmar
3 name:wym
3 name:1894
3 name:Ja_Hira
3 name:1904
3 name:generic
3 name:1958
3 name:lut
3 name:changed
3 name:オンネナイ川
3 name:left:hu
3 name:botanical:de
3 name:1975
3 name:fa_1
3 name:en_rm
3 name:1880
3 name:aec
3 name:DB
3 name:rup
3 name:1900-1920
3 name:1945
3 name:fixme
3 name:1931
3 name:group
3 name:sort:sr
3 name:1981-2017
3 name:suburb
3 name:addition
3 name:1953
3 name:SMH
3 name:cat
3 name:generic:sr
3 name:slo
3 name:1920-
3 name:info
3 name:1911
3 name:-2015
3 name:TECL
3 name:1860
3 name:1920
3 name:mmr
3 name:therapist
3 name:TransGironde
3 name:prefix:be
3 name:1996
3 name:1959
3 name:innu
3 name:short:sr
3 name:മലയ്
3 name:roa_tara
3 name:Connexxion
3 name:-2014
3 name:dontshow
3 name:1994
3 name:srpski
3 name:bo_wylie
3 name:zawgyi
3 name:sort
3 name:right:hu
3 name:aus
3 name:ꆈꌠ꒿
3 name:qe
3 name:old:1
3 name:1886
2 name:ar_dz
2 name:south
2 name:gascon
2 name:rui
2 name:2014-
2 name:en13
2 name:actual
2 name:kana_rm
2 name:1971-1990
2 name:1922
2 name:gil
2 name:1991
2 name:فار
2 name:hydropower_project
2 name:SVG
2 name:1837
2 name:1912--2001
2 name:exchangecode
2 name:2005-07-04--
2 name:historic:1924
2 name:1961
2 name:1909
2 name:1160
2 name:2001-2012
2 name:ft
2 name:Texels
2 name:--2016
2 name:0
2 name:prefix2
2 name:1874
2 name:sakao
2 name:1943-1945
2 name:swb
2 name:CD31
2 name:kbr
2 name:1800
2 name:1180
2 name:1953-1994
2 name:historic:1999
2 name:1891-1997
2 name:Salar
2 name:gsw1
2 name:zh-min
2 name:Blloku
2 name:ko_rm_1
2 name:oldsq
2 name:branch
2 name:mok
2 name:non
2 name:br:2017-12-25-
2 name:1990-2016
2 name:verification_source
2 name:1978
2 name:780
2 name:1941
2 name:brewery
2 name:1887
2 name:de_CH
2 name:1946
2 name:fra-jer
2 name:1710
2 name:br:-2017-12-25
2 name:xxx
2 name:Swiss-German
2 name:full:nd:sr
2 name:tay
2 name:1878
2 name:gwi
2 name:movibus
2 name:1882
2 name:left:fy
2 name:teh
2 name:1996-1997
2 name:2005-2013
2 name:1942
2 name:1882-1997
2 name:1934
2 name:rap
2 name:1945-1946
2 name:sheip
2 name:tbz
2 name:historic:1915
2 name:1961-2014
2 name:generator
2 name:historic:1986
2 name:1931-1948
2 name:ru:alt_old
2 name:suffx
2 name:1967
2 name:ja_hrkt
2 name:botanical:ko
2 name:man
2 name:nqo
2 name:suspended
2 name:DKV
2 name:scs
2 name:historic:1956
2 name:bridge:ko_rm
2 name:1930
2 name:kqs
2 name:ko:Latn
2 name:atl
2 name:formal
2 name:informal:en
2 name:FANTOIR
2 name:1988-2017
2 name:full:nd
2 name:pt_BR
2 name:EuropeanCommission
2 name:de:pronunciation
2 name:英文
2 name:en-US
2 name:fr_2
2 name:zh_hans
2 name:Popular
2 name:Lignes de l'Agglo
2 name:xwj
2 name:1910
2 name:pt-BR
2 name:oldsr
2 name:1709
2 name:right:fy
2 name:crg
2 name:1981
2 name:1885-1919
2 name:amenity
2 name:1928
2 name:1850
2 name:house
2 name:ug-Latn
2 name:pyu
2 name:zn-hans
2 name:old:alt
2 name:TBM
2 name:syc-Latn
2 name:1818
2 name:Nissart
2 name:1993-2007
2 name:science
2 name:1945-2013
2 name:office
2 name:Caltrain
2 name:structure
2 name:1921
2 name:alt_spelling
2 name:mol
2 name:Bangla
2 name:de-1885
2 name:binomial
2 name:tly
2 name:es:source
2 name:place
2 name:west
2 name:1893
2 name:Passirano
2 name:1892-1912
2 name:zh_tradition
2 name:tkr
2 name:CazzagoSanMartino
2 name:2012-2014
2 name:khj
2 name:sohrabi
2 name:2017-11-01--
2 name:1857
2 name:sty
2 name:prefix:ru
2 name:xsl
2 name:-1995
2 name:FR:Cadastre
2 name:east
2 name:ru:old:alt
2 name:boat
2 name:hindi
2 name:1936-1945
2 name:1945-2000
2 name:1980
2 name:en12
2 name:alt2
2 name:-1943
2 name:pervious
2 name:中中
2 name:Naskapi
2 name:detail
2 name:samisk
2 name:1944-1945
2 name:sv_1
2 name:bet
2 name:ru:official
2 name:es1
2 name:lfn
2 name:1760-1891
2 name:-2017-02
2 name:vulgo
2 name:1948
2 name:postal
1 name:Zh-pinying
1 name:Duits
1 name:ja-kn
1 name:leader
1 name:street_sign
1 name:1957-1989
1 name:~1950
1 name:Glory
1 name:en_6
1 name:1870-1900
1 name:1942-1943
1 name:slň
1 name:漢文
1 name:1949-1952
1 name:historic:1919
1 name:ja小茂根在宅介護支援センター
1 name:historic:1984
1 name:1940-1945
1 name:ja_Hiraa
1 name:common
1 name:ar4
1 name:garage
1 name:idd
1 name:shs
1 name:historical:source
1 name:1918
1 name:agx
1 name:pau
1 name:Malaya
1 name:an:1863-1973
1 name:entrance
1 name:1937-1946
1 name:bre
1 name:1973-01-01-
1 name:1969-1971
1 name:1903-1932
1 name:before 2014
1 name:orv
1 name:uby
1 name:historic:1970
1 name:2012-2015
1 name:fr-g-fc
1 name:adot
1 name:lar
1 name:RFI
1 name:-1808
1 name:vulgar
1 name:1899-03-15-1969-05-05
1 name:older
1 name:zh3
1 name:fr_4
1 name:1963-1973
1 name:Армения
1 name:vice
1 name:cuzk:km
1 name:khk
1 name:0--2016
1 name:1916-1933
1 name:1865-1995
1 name:Euskera
1 name:plural
1 name:cel
1 name:previous
1 name:ar:3
1 name:1921-1925
1 name:ms-Latn
1 name:line
1 name:ganesh ceramic
1 name:alt_be
1 name:1975-1984
1 name:research
1 name:2016-2016
1 name:1:ja
1 name:hide
1 name:Oji-Cree:
1 name:1965-1991
1 name:1894-1993
1 name:-2008
1 name:ko-kr
1 name:phi
1 name:1934-1946
1 name:1811-
1 name:francique lorrain
1 name:2004-2009
1 name:miao
1 name:az_alt
1 name:location:source
1 name:tao
1 name:rol
1 name:atlas_de_catamarca
1 name:Genovese
1 name:1990-1991
1 name:hungary
1 name:-2007
1 name:1935
1 name:lc
1 name:1961-1993
1 name:Lakota
1 name:Boontling
1 name:2016-05-30--
1 name:1995-1996_1
1 name:alt:ru
1 name:zh:note
1 name:lus
1 name:alt:ga
1 name:2011-2013
1 name:Montenegrin
1 name:-2015-12-27
1 name:1910-1915
1 name:alt_ru
1 name:кг
1 name:lawyer
1 name:infix
1 name:Kurdi
1 name:nrf
1 name:中國
1 name:abbrev
1 name:1907-1920
1 name:Montipaùnisa
1 name:bre§
1 name:1930-1940
1 name:1921-1946
1 name:do
1 name:Mundart
1 name:2008--2016-06-17
1 name:English_alt
1 name:--2011-07-31
1 name:1902-1919
1 name:1892-1934
1 name:fi:right
1 name:lud
1 name:1997-2015
1 name:ja-Latn
1 name:tlingit
1 name:mhj
1 name:--2017-06-24
1 name:dutch
1 name:1890-1966
1 name:fi:alt:1
1 name:-1952
1 name:right:es
1 name:2017-03-12--
1 name:rumca
1 name:0:ja_rm
1 name:botanical:cs
1 name:har
1 name:uum
1 name:1996-2010
1 name:right:ga
1 name:1913--
1 name:1961-1972
1 name:doi
1 name:historic:1955
1 name:1872
1 name:abandoned:railway
1 name:prefix:uk
1 name:2010-2014
1 name:नेपाली
1 name:engels
1 name:1886-1914
1 name:ño
1 name:Englishthai
1 name:AVG
1 name:1920-1938
1 name:duits
1 name:left:uk
1 name:NaPTAN
1 name:1875-1888
1 name:ja-Hira尼崎貴布祢店
1 name:misspelling
1 name:წ
1 name:historic:1968
1 name:ru_Latn
1 name:tamang
1 name:en:1921-1961
1 name:هیدج
1 name:en:suffix
1 name:fi:alt:2
1 name:두
1 name:1939
1 name:zh_hk
1 name:1896-1928
1 name:1850-1945
1 name:1994-1997
1 name:face
1 name:1990-2013
1 name:1884-1919
1 name:historic:1977
1 name:en:el
1 name:ьmd
1 name:ttt
1 name:tuq
1 name:1942-1945
1 name:club
1 name:af:maybe
1 name:bsk
1 name:intt
1 name:mrh
1 name:riu
1 name:dagbanli
1 name:fi:2
1 name:1998-1999
1 name:2002-2013
1 name:Rif
1 name:日本語
1 name:kar
1 name:2016-07-23--
1 name:hromână
1 name:pycc
1 name:information
1 name:VOR
1 name:enThuthjingal
1 name:圓山隧道
1 name:hmd
1 name:1863-1973
1 name:1895-1900
1 name:Englishپاركى شار
1 name:en:translate
1 name:2002-2017
1 name:maďarčina
1 name:level2
1 name:1881
1 name:ko_hanjal
1 name:--2016-01-31
1 name:be_rm
1 name:2016-09-09--
1 name:old_fr
1 name:-1986
1 name:ruth
1 name:historic:1981
1 name:el_en
1 name:1996-10--2015-10
1 name:malay
1 name:1946-1952
1 name:ja_ra
1 name:pitch
1 name:tks
1 name:location:source2
1 name:1942-1962
1 name:monument
1 name:2011-08-01--2015-07-31
1 name:ср-
1 name:doctors
1 name:1903
1 name:ir
1 name:2010-2011
1 name:fr:pronunciation
1 name:ke
1 name:1995-2017
1 name:afi
1 name:العربية
1 name:fr_3
1 name:1924-1949
1 name:old_name:1
1 name:1919-1936
1 name:Ingles
1 name:below
1 name:zh_hamt
1 name:uk-Latn
1 name:gj
1 name:myn
1 name:secondary
1 name:-1992
1 name:loc:ru
1 name:S
1 name:mez
1 name:old:3
1 name:1760
1 name:1910-2008
1 name:geg
1 name:2010-2017
1 name:ja_reading
1 name:uyghur
1 name:ㅎ
1 name:2013-10-25--2016-11-17
1 name:internal
1 name:1800-1868
1 name:fiu
1 name:pa_1
1 name:kok
1 name:1869-2005
1 name:mn_1
1 name:2006-2017
1 name:agent
1 name:tsawout
1 name:1974-1975
1 name:ruotsi
1 name:1917-1927
1 name:armenia
1 name:2004-2011
1 name:文
1 name:en_rome
1 name:1853
1 name:Каза
1 name:1973-2008
1 name:1975-09-15--2005-11-22
1 name:zh_2
1 name:ru:loc:2
1 name:1988-2016
1 name:--2017-02-28
1 name:1934-1940
1 name:restaurant
1 name:2003-2014
1 name:1998-2001
1 name:2000-2010
1 name:akl
1 name:မြမြ
1 name:historical_monument
1 name:Zarma
1 name:1931-1945
1 name:2004-2007_1
1 name:1913-1918
1 name:bank
1 name:ru:loc:5
1 name:natural_monument
1 name:right:uk
1 name:mfa
1 name:1912-1919
1 name:xibe
1 name:1924
1 name:ru_BY
1 name:ttc
1 name:c19-c20
1 name:1788
1 name:1927-1939
1 name:1881-2016
1 name:日本語　鳥取津ノ井店
1 name:tram
1 name:on-site
1 name:1800-1850
1 name:1911-1913
1 name:1925
1 name:2003-2015
1 name:אינדי
1 name:gle
1 name:mnw
1 name:koy
1 name:north
1 name:Tayal
1 name:unsigned
1 name:sinha
1 name:historic:1952
1 name:tnq
1 name:吃
1 name:1952
1 name:ⵜⴰⵎⴰⵣⵉⵖⵜ
1 name:piu
1 name:Moba
1 name:Аҧсуа
1 name:2001-2004
1 name:mdh
1 name:Kihaya
1 name:2016--2017-04-28
1 name:hani
1 name:crnogorski
1 name:1949-1990
1 name:Kinaray-a
1 name:ary
1 name:orm
1 name:1909-1934
1 name:Kreol morisien
1 name:utbm
1 name:Calle
1 name:ru:loc:alt
1 name:1934-1945
1 name:bridge:it
1 name:1918-1946
1 name:akk
1 name:1922-1945
1 name:简化字
1 name:1981-2013
1 name:LuGyiMin (PhawKan)
1 name:한국의
1 name:1990-1995
1 name:moh
1 name:براندت
1 name:storico
1 name:mn_2
1 name:1983-06-16--2006-11-30
1 name:1910-1977
1 name:2011-02-19--2015-10-02
1 name:sje
1 name:2013-
1 name:1956
1 name:mn_3
1 name:Parapentismo
1 name:2002-2006
1 name:1930-1932
1 name:details
1 name:statue
1 name:tmz
1 name:morvarid
1 name:1898
1 name:de1
1 name:2013-2017
1 name:2009--2014
1 name:English-alt
1 name:en-ZH
1 name:iraqi
1 name:1923-1993
1 name:1280
1 name:old_name:1_1
1 name:1960-
1 name:ar:1
1 name:1995-2015
1 name:-2005
1 name:1934-1949
1 name:1885-1886
1 name:1835
1 name:1912
1 name:1935-1937
1 name:sv:other_end
1 name:1996-2016
1 name:euskara_alt
1 name:1985
1 name:-1983
1 name:1848
1 name:2004-2007
1 name:lmo:2
1 name:1902-1921
1 name:1918-1981
1 name:en_4
1 name:1946-1947
1 name:1893-1975
1 name:Kurpfälzisch
1 name:1876
1 name:1947
1 name:yly
1 name:1952-1953
1 name:lbj
1 name:en:ja
1 name:1969-1992
1 name:historic:1990
1 name:1788-1800
1 name:nature_reserve
1 name:1914-1964
1 name:2010-
1 name:1907-1930
1 name:en_3
1 name:hidden
1 name:1928-1935
1 name:1903-1995
1 name:swe
1 name:1938-05-07--1951-11-01
1 name:1907-1934
1 name:msk
1 name:tib
1 name:2007-2009
1 name:kh
1 name:mun
1 name:1923-1939
1 name:dpwh
1 name:201707-
1 name:Karlskronitiska
1 name:1947-1965
1 name:khi
1 name:1995-1996
1 name:1949-1968
1 name:zh-hang
1 name:ibl
1 name:1963-1968
1 name:Village arash
1 name:1848-1919
1 name:bai
1 name:botanical:de:alt
1 name:nvv
1 name:1936-1941
1 name:繁体中文
1 name:br_alt
1 name:1971-2013
1 name:historic_alt
1 name:other2
1 name:1975-1985
1 name:dres
1 name:atm
1 name:1939-1940
1 name:coo
1 name:sla
1 name:btw
1 name:an:1973-2008
1 name:1999
1 name:Mikmaq
1 name:1929-1951
1 name:2013-02-03--
1 name:1915
1 name:1882-1911
1 name:1783-1968
1 name:-1973-01-01
1 name:1999-2017
1 name:1892-1895
1 name:--2016-03-16
1 name:level3
1 name:xgf
1 name:1937
1 name:moe
1 name:1950-1962
1 name:2013-2015
1 name:end
1 name:ru:old:alt:3
1 name:historic:1945
1 name:1999-2012
1 name:1972-1989
1 name:kla
1 name:1921-1945
1 name:fon
1 name:xct
1 name:1971-1996
1 name:ာပ
1 name:old:ga
1 name:1894-1902
1 name:cbs
1 name:рус
1 name:1999--2005-07-04
1 name:de:translit
1 name:ono
1 name:Moselfränkisch
1 name:1946-1997
1 name:ru:loc:4
1 name:fi1
1 name:Kiswaili
1 name:1885-1909
1 name:dgr
1 name:727
1 name:gez
1 name:1869
1 name:en:source_ref
1 name:--2016-06-30
1 name:Grugliasco Fire Brigate
1 name:1919-1925
1 name:-2017-12-23
1 name:Bypass
1 name:ja-Larn
1 name:1872-1909
1 name:1946-1975
1 name:Nakau
1 name:1945-1981
1 name:1912-1994
1 name:--2016-02-28
1 name:1926-1976
1 name:mov
1 name:1879
1 name:el_2
1 name:1907-1919
1 name:2016-07-11--
1 name:Carnaval
1 name:1897-1940
1 name:1902-1964
1 name:maya
1 name:MT Bike
1 name:VGN
1 name:vehicle
1 name:roman
1 name:Rral
1 name:1847
1 name:englisch
1 name:戈日
1 name:ru:loc:old:2
1 name:future:he
1 name:abbrevation
1 name:1928-2003
1 name:1974-1987
1 name:1900-2000
1 name:kazakh_arabicscrip
1 name:en_IE
1 name:1884-1933
1 name:日本語　万代書店
1 name:ru:loc:old:1
1 name:hu:note
1 name:maori
1 name:фыва
1 name:subtitle
1 name:distillery
1 name:丹戎加东
1 name:ဲျမန္မာဘာသာ
1 name:trolleybus
1 name:1969-2016
1 name:izuhara Hongawa River
1 name:dhv
1 name:Tungag
1 name:الإصيقع
1 name:တႆး
1 name:conditional
1 name:Stibus
1 name:bbl
1 name:-201706
1 name:crh-Latn
1 name:1919-1930
1 name:STORAGE
1 name:bat-prg
1 name:bpv
1 name:bo_pinyin
1 name:ur-Latn
1 name:2015-2016
1 name:FAYZ
1 name:prefix:hr
1 name:ja_ref
1 name:niu
1 name:1937-1945
1 name:ar:2
1 name:doctor
1 name:ira
1 name:N
1 name:source:url
1 name:Länstrafiken_Kronoberg
1 name:Sächsisch
1 name:NATO
1 name:pt-PT
1 name:om_old
1 name:sloveno
1 name:1921-1994
1 name:Plaatselijk
1 name:1961-05-29–2014-10-26
1 name:secretary
1 name:2018
1 name:de4
1 name:bdcarthage
1 name:tumzabt
1 name:العرب
1 name:future:en
1 name:sr_2
1 name:1919-1924
1 name:country
1 name:1946-2010
1 name:1919-1926
1 name:По
1 name:Amis (Pangcah)
1 name:uk:-2017-12-25
1 name:srh
1 name:waterway
1 name:cantonese
1 name:Анг
1 name:-1960
1 name:source:wikidata
1 name:transformer
1 name:xct_pinyin
1 name:2006--2016-05-30
1 name:zh_jyutping
1 name:Temp
1 name:miq
1 name:sufix
1 name:historic:1935
1 name:cadastre-fr
1 name:1916-1919
1 name:1977
1 name:1898-1973
1 name:图们大桥
1 name:2006-12-01--2017-03-22
1 name:sus
1 name:0:ja
1 name:1955
1 name:brigde
1 name:1939-1941
1 name:2011-2014
1 name:2006-2016
1 name:shi
1 name:z229
1 name:1797-1806
1 name:1822-1971
1 name:नेपाली
1 name:historic:1928
1 name:Вовавто
1 name:review
1 name:1958-1964
1 name:left:ga
1 name:eea
1 name:1899-1903
1 name:ump
1 name:bft
1 name:tsauva
1 name:mvv
1 name:1964
1 name:1959-2012
1 name:sjw
1 name:2006-2009
1 name:dpmk
1 name:Patois
1 name:en_GB
1 name:level1
1 name:1901-1919
1 name:中文乡
1 name:alq
1 name:imo
1 name:1953--1991
1 name:ar_din
1 name:pe
1 name:-2001
1 name:1949
1 name:biodiv
1 name:ja-Kata
1 name:1948-2010
1 name:1919-1922
1 name:ko-kp
1 name:srbčina
1 name:1928-1984
1 name:ckt
1 name:1987-1989
1 name:stream
1 name:1993-2010
1 name:fuf
1 name:lu
1 name:Estima
1 name:shop
1 name:alt_4
1 name:lorrain
1 name:ar_trans
1 name:2005-2017
1 name:1928-1950
1 name:eʋegbeN
1 name:1980-1982
1 name:1876-1896
1 name:Tugpahanang Pangkalibutan sa Laguindingan
1 name:ng
1 name:wls
1 name:Ojibwe
1 name:STIF
1 name:1887--1968
1 name:ru:loc:3
1 name:jbn-zua
1 name:1933
1 name:zh-simpified
1 name:ru:loc:1
1 name:brs
1 name:de:suffix
1 name:--2015-07-31
1 name:city_map
1 name:Nēhiyawēwin / ᓀᐦᐃᔭᐍᐏᐣ (Cree)
1 name:2016-2017
1 name:todo_mogolian
1 name:left:es
1 name:de:botanical
1 name:ru:old:alt:1
1 name:lua
1 name:comment
1 name:Islenska
1 name:en14
1 name:transliteration
1 name:historic:1918
1 name:ru:1954-1994
1 name:2015-2017
1 name:Alt
1 name:ru2
1 name:2016-08-25--
1 name:--2017
1 name:en_5
1 name:2016-12-12--
1 name:1896-1918
1 name:de2
1 name:2010-2013
1 name:1883
1 name:2016-03-17--
1 name:de3
1 name:1905-1912
1 name:fonetic
1 name:discontinued
1 name:mis
1 name:he_rm
1 name:historic:1980
1 name:gdos
1 name:2013-2016
1 name:1720-1722
1 name:ja_kana_1
1 name:1983-2016
1 name:1974-2008
1 name:1891-1996
1 name:old:2
1 name:Filipino
1 name:1926-1939
1 name:1926-1960
1 name:bg-Latn
1 name:1997-2017
1 name:1591-1857
1 name:Kroatiska
1 name:ru:old:alt:2
1 name:1951-11-01--
1 name:Nigerian
1 name:sv:right
1 name:altrenative
1 name:1958-2009
1 name:한한국어
1 name:1904-2017
1 name:1935-1941
1 name:1966-2005
1 name:tox
1 name:1999-2004
1 name:Vijaygram
1 name:Mundang
1 name:ja_r
1 name:1960
Raw
query.sql
SELECT
COUNT(*), k
FROM (
SELECT skeys(tags) FROM planet_osm_point
UNION ALL SELECT skeys(tags) FROM planet_osm_line
UNION ALL SELECT skeys(tags) FROM planet_osm_polygon
) t(k)
WHERE k like 'name:%'
GROUP BY k
ORDER BY COUNT DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment