musiccaps
1 row where aspect_list contains "blues-rock", aspect_list contains "groovy bass line" and aspect_list contains "poignant"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
6JJMlY3Go9s | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | ["Blues", "Music"] | 7 | 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 );