musiccaps
1 row where aspect_list contains "exciting" and aspect_list contains "soaring melody"
This data as json, CSV (advanced)
aspect_list (array) 23 ✖
- adventurous 1
- bad audio quality 1
- blue band 1
- blues harmonica 1
- blues harp 1
- blues legends 1
- blues progression 1
- blues turn around 1
- exciting · 1 ✖
- groovy 1
- groovy bass line 1
- guitar rhythm 1
- harmonica player 1
- harpist 1
- instrumental music 1
- medium tempo 1
- passionate 1
- slow dance 1
- soaring melody · 1 ✖
- spirited 1
- steady drumming 1
- the blues 1
- walking bass line 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
GT9g4uqK9G8 | The song is an instrumental blues song. The song is medium tempo with a blues harmonica playing a cool melody, walking bass line, guitar accompaniment , steady drumming rhythm and other percussion hits. The song is exciting and groovy. The song has a bad audio quality. | ["blues harmonica", "blues harp", "harpist", "instrumental music", "harmonica player", "groovy bass line", "guitar rhythm", "steady drumming", "the blues", "blues progression", "instrumental music", "soaring melody", "bad audio quality", "blue band", "walking bass line", "blues turn around", "blues legends", "medium tempo", "adventurous", "exciting", "groovy", "slow dance", "passionate", "spirited"] | ["Blues", "Music"] | 1 | 30 | 40 | 0 | 0 | ["/m/0155w", "/m/04rlf"] |
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 );