musiccaps
1 row where aspect_list contains "guitar notes playing" and aspect_list contains "madly in love"
This data as json, CSV (advanced)
aspect_list (array) 23 ✖
- ambient crowd noise 1
- blues music 1
- blues turnaround 1
- female singer 1
- fret noise 1
- guitar notes playing · 1 ✖
- guitar playing 1
- hissing ambient sound 1
- lilting vocals 1
- live audience 1
- live performance 1
- love song 1
- madly in love · 1 ✖
- passionate 1
- poor audio quality 1
- pop diva 1
- pop song 1
- pop super hits 1
- romantic 1
- singer talking 1
- song introduction 1
- soul music 1
- soul singer 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
B90BOtSOD2Q | A female singer sings this bluesy melody. The song is medium tempo with minimal guitar accompaniment and no other instrumentation. The song's medium tempo is very emotional and passionate. The song is a modern pop hit but with poor audio quality. | ["female singer", "blues music", "live audience", "romantic", "hissing ambient sound", "madly in love", "love song", "passionate", "ambient crowd noise", "guitar playing", "singer talking", "song introduction", "blues turnaround", "fret noise", "pop song", "pop super hits", "pop diva", "poor audio quality", "guitar notes playing", "live performance", "lilting vocals", "soul singer", "soul music"] | ["Singing", "Music", "/t/dd00004", "Inside, large room or hall"] | 1 | 410 | 420 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/t/dd00004", "/t/dd00126"] |
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 );