musiccaps
2 rows where aspect_list contains "opera" and aspect_list contains "soft"
This data as json, CSV (advanced)
aspect_list (array) 37 ✖
- opera · 2 ✖
- soft · 2 ✖
- alternative/indie 1
- art rock 1
- ballad 1
- celestial 1
- celtic folk music 1
- celtic new age 1
- cymbal crash 1
- delicate 1
- downtempo 1
- electronic 1
- emphatic piano 1
- enigmatic 1
- ethereal 1
- female singer 1
- freddie mercury 1
- hard rock 1
- haunting 1
- hit songs 1
- male singer 1
- meditative 1
- melancholic 1
- mellow 1
- modern classical 1
- mysterious 1
- new age 1
- organ accompaniment 1
- pop 1
- progressive pop 1
- progressive rock 1
- queen 1
- rock 1
- slow tempo 1
- song introduction 1
- strong vocals 1
- sublime 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
4vWChPYkuwA | A male vocalist sings this Pop song. The tempo is slow with a melodic and emphatic piano accompaniment. This bit has minimal instrumentation as it is the introduction. The music is burgeoning with a cymbal crash introduced at the end of this clip. The song is slow, sad, poignant, reflective and nostalgic. This song is a hit Pop Rock. | ["male singer", "slow tempo", "soft", "emphatic piano", "cymbal crash", "strong vocals", "song introduction", "hard rock", "progressive rock", "alternative/indie", "progressive pop", "pop", "rock", "art rock", "queen", "hit songs", "freddie mercury", "ballad", "opera"] | ["Music", "Independent music"] | 7 | 70 | 80 | 0 | 0 | ["/m/04rlf", "/m/05rwpb"] | |
_nrz_BawPMY | A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. | ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] | ["New-age music", "Music"] | 7 | 160 | 170 | 0 | 0 | ["/m/02v2lh", "/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 );