musiccaps
2 rows where aspect_list contains "lonely" and aspect_list contains "male singer"
This data as json, CSV (advanced)
aspect_list (array) 33 ✖
- lonely · 2 ✖
- male singer · 2 ✖
- poignant 2
- sad 2
- acoustic guitar 1
- atmospheric 1
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- breakup song 1
- depressed 1
- dream pop 1
- droning keyboard harmony 1
- emotional 1
- groovy bass line 1
- heart break 1
- hurt 1
- intense drumming 1
- longing 1
- medium tempo 1
- movie soundtrack 1
- passionate 1
- pop rock 1
- regretful 1
- rock 1
- sentimental 1
- slow tempo 1
- sombre 1
- synthesiser arrangement 1
- vigorous electric guitar riff 1
- wistful 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"] | |
gTX4SG70cEY | A male vocalist sings this sad melody. The tempo is slow with an acoustic guitar accompaniment and a droning keyboard harmony. The song is soft ,mellow, sad, emotional, sentimental, regretful , lonely and poignant. This song is an Alternative Rock/Indie. | ["male singer", "slow tempo", "acoustic guitar", "atmospheric", "poignant", "dream pop", "lonely", "pop rock", "longing", "sombre", "breakup song", "passionate", "sad", "wistful", "emotional", "sentimental", "regretful", "wistful", "movie soundtrack", "droning keyboard harmony"] | ["Music", "Theremin"] | 7 | 230 | 240 | 0 | 0 | ["/m/04rlf", "/m/07kc_"] |
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 );