musiccaps
1 row where aspect_list contains "anthem" and aspect_list contains "emotional"
This data as json, CSV (advanced)
aspect_list (array) 23 ✖
- anthem · 1 ✖
- baritone 1
- bass 1
- choral harmony 1
- devotion 1
- emotional · 1 ✖
- foreign language 1
- greek song 1
- hand drums 1
- hand percussion 1
- intense 1
- love 1
- loyalty 1
- male harmony 1
- medium tempo 1
- passionate 1
- patriotic 1
- patriotism 1
- sentimental 1
- sticks 1
- tambourine 1
- tenor 1
- unity 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
2JnlmS1zzls | A male chorus sings this passionate song in a foreign language which sounds like Greek. The song is medium tempo with hand percussion like drums, small hand drum, tambourine and a beat with sticks. The vocals are emphatic and sung in lively parts. The song is passionate, emotional, sentimental, and sounds like an anthem or a love song for the Country or a Leader. | ["male harmony", "medium tempo", "foreign language", "greek song", "anthem", "hand percussion", "tambourine", "hand drums", "sticks", "choral harmony", "unity", "patriotic", "anthem", "patriotism", "passionate", "emotional", "sentimental", "love", "devotion", "loyalty", "intense", "tenor", "baritone", "bass"] | ["Mantra", "Chant", "Folk music", "Music", "Vocal music"] | 7 | 30 | 40 | 1 | 1 | ["/m/01c194", "/m/02bk07", "/m/02w4v", "/m/04rlf", "/m/0y4f8"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );