musiccaps
1 row where aspect_list contains "meditational" and aspect_list contains "patriotic"
This data as json, CSV (advanced)
aspect_list (array) 17 ✖
- ambient crowd noise 1
- bad audio quality 1
- cheering sounds 1
- cymbals crashing 1
- devotional 1
- instrumental music 1
- jewish traditional music 1
- meditational · 1 ✖
- national spirit 1
- patriotic · 1 ✖
- people clapping 1
- percussions playing 1
- prayer 1
- self identity 1
- slow tempo 1
- tambourine percussions 1
- traditional horn instruments 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
zqbHYVH6Wqo | The song is an instrumental. The tempo is medium with traditional horn instruments playing, tambourine percussion, keyboard harmony and cymbal crashes. The song is devotional and spirited. The song has a bad audio quality with ambient crowd noises. | ["traditional horn instruments", "devotional", "ambient crowd noise", "instrumental music", "bad audio quality", "cymbals crashing", "percussions playing", "tambourine percussions", "people clapping", "cheering sounds", "devotional", "prayer", "national spirit", "patriotic", "self identity", "slow tempo", "jewish traditional music", "meditational"] | ["Wind instrument, woodwind instrument", "Shofar"] | 1 | 30 | 40 | 0 | 0 | ["/m/085jw", "/m/0l14l2"] |
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 );