musiccaps
1 row where aspect_list contains "depressed" and aspect_list contains "male singer"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- depressed · 1 ✖
- groovy bass line 1
- heart break 1
- hurt 1
- intense drumming 1
- lonely 1
- male singer · 1 ✖
- medium tempo 1
- poignant 1
- rock 1
- sad 1
- synthesiser arrangement 1
- vigorous electric guitar riff 1
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 );