A tag is in the database if it has ever been used in a diary or a diary draft whether or not it stayed in the diary or whether the draft was published. There are many tags that have been used five times that have not actually been used outside the tag database.
Half of all tags have not been used twice.
Nine out of ten tags have not been used more than a dozen times.
More than half of tags used ten times have been used twenty times.
More than half of tags used twenty times have been used fifty times.
I've looked at least once at every tag used 238 times.
The problematic ones I've noted are in the second blockquote below. Most are acronyms that should be linked to the longform version. Some are vague. Scrollover to see the tags I mean.
The Scale of the problem.
Used at least 0 times: 383,335
Used at least 1 times: 377,197
Used at least 2 times: 186,065
Used at least 3 times: 132,958
Used at least 4 times: 104,944
Used at least 5 times: 86,722
Used at least 6 times: 74,127
Used at least 7 times: 65,021
Used at least 8 times: 57,759
Used at least 9 times: 52,014
Used at least 10 times: 47,456
Used at least 11 times: 43,544
Used at least 12 times: 40,309
Used at least 13 times: 37,507
Used at least 14 times: 35,219
Used at least 15 times: 33,166
Used at least 16 times: 31,370
Used at least 17 times: 29,745
Used at least 18 times: 28,451
Used at least 19 times: 27,133
Used at least 20 times: 26,010
Used at least 25 times: 21,512
Used at least 30 times: 18,512
Used at least 35 times: 16,247
Used at least 40 times: 14,558
Used at least 45 times: 13,244
Used at least 50 times: 12,169
Used at least 60 times: 10,549
Used at least 70 times: 9,283
Used at least 80 times: 8,293
Used at least 90 times: 7,519
Used at least 100 times: 6,852
Used at least 110 times: 6,298
Used at least 120 times: 5,836
130: 5,436
140: 5,110
150: 4,821
160: 4,582
170: 4,381
180: 4,161
190: 3,961
200: 3,797
210: 3,654
220: 3,511
230: 3,389
240: 3,279
250: 3,167
300: 2,706
350: 2,329
400: 2,047
450: 1,830
500: 1,653
600: 1,411
700: 1,255
800: 1,071
900: 947
1000: 865
1200: 699
1400: 608
1600: 542
1800: 475
2000: 426
2500: 338
3000: 262
3500: 224
4000: 198
5000: 149
6000: 121
7000: 104
8000: 86
9000: 75
10000: 67
15000: 40
Barack Obama 105804
Community 75232
Economy 50702
Republicans 42726
Elections 41124
Environment 38203
George W. Bush 37083
Iraq 35161
Health Care 33973
Congress 33324
Hillary Clinton 32761
Civil Rights 31394
Mitt Romney 30717
Democrats 30601
John McCain 29407
Media 29230
Education 25650
2008 elections 25101
Labor 24803
President 23055
2008 22244
Senate 22141
Politics 21852
GOP 20479
Climate Change 20323
Science 20095
Culture 19956
Wisconsin 19198
Meta 18699
2012 17697
Snark 17487
Law 17058
Racism 17048
Energy 16886
Tea Party 16403
LGBT 16284
Election 16229
War 15819
Sarah Palin 15524
Teaching 15495
http://www.dailykos.com/... http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... Chealcy
SCOTUS V Supreme Court
http://www.dailykos.com/...
http://www.dailykos.com/... link to general motors
http://www.dailykos.com/...
http://www.dailykos.com/... http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...(President) Should be able to split tags up in code.
http://www.dailykos.com/... http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...(BDCP)
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... This one is vague
http://www.dailykos.com/...
http://www.dailykos.com/... Check freddiemac
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... Massachusetts or vague?
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... That's entertainment
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... ku and/or klu?
http://www.dailykos.com/... vague
http://www.dailykos.com/... Vague
99 generally
http://www.dailykos.com/...
http://www.dailykos.com/... Macando?
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
occupy generally
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... African Americans
http://www.dailykos.com/... vague
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... Vague
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... Vague or historical?
http://www.dailykos.com/... Accounting or accoutability?
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... Probably left alone.
attacks
https://www.dailykos.com/... link
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/... vague
http://www.dailykos.com/...
http://www.dailykos.com/... ?
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...(MLPA)%20Initiative
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
http://www.dailykos.com/...
238 uses 19Jul2014
http://www.dailykos.com/...