Open rlmead opened 1 year ago
Tag counts in the db (for tags that occur more than once) as of 4/23/23:
select * from
(select count(*) as count, unnest(tags) as tag from events
group by unnest(tags) order by count(*)::numeric desc, tag asc) unnested
where count > 1
and not tag like 'mode:%' and not tag like 'category:%' and not tag like 'condition:%';
count | tag
-------+--------------------------
974 | music
182 | theater
171 | festival
128 | gallery
104 | talk
92 | film
57 | holiday
42 | dance
40 | archived-online-resource
38 | market
37 | art
36 | fundraiser
23 | comedy
19 | craft
12 | not-yet-implemented
9 | outdoor
8 | convention
7 | children
6 | art-class
6 | poetry
6 | trivia
5 | community
5 | food
5 | musical
5 | reading
4 | class
4 | exhibit
4 | juneteenth
4 | lexingtonartleague
4 | opera
4 | photography
4 | radio
3 | art education
3 | ballet
3 | book
3 | childrens
3 | halloween
3 | healthcare
3 | literary arts
3 | m
3 | nonprofit
3 | orchestra
3 | party
3 | sculpture
2 | Accents Publishing
2 | Dance
2 | Dance
2 | Institute 193
2 | all ages
2 | benefit
2 | camp
2 | conference
2 | crafts
2 | exhibition
2 | fashion
2 | jewelry
2 | kentucky writers
2 | kentucky writers
2 | kids
2 | lexington
2 | literary
2 | literature
2 | live music
2 | medical education
2 | medical education
2 | medicine
2 | movie
2 | outdoors
2 | painting
2 | performance
2 | writing
(71 rows)
Not sure why we've got some duplicates in there 🤔
Explore the database to see what tags are used most often; consider adding frequently-used tags and removing un-frequently-used tags.
Recently suggested/requested tags: