musiccaps
1 row where aspect_list contains "greatest love sings" and aspect_list contains "keyboard accompaniment"
This data as json, CSV (advanced)
aspect_list (array) 21 ✖
- ambient noises 1
- bad audio quality 1
- bell tones 1
- church organ playing 1
- emotional 1
- eternal love 1
- ethereal harmony 1
- greatest love sings · 1 ✖
- groovy bass line 1
- instrumental music 1
- keyboard accompaniment · 1 ✖
- live performance 1
- love song 1
- medium tempo 1
- never give up 1
- passionate 1
- pop super hits 1
- retro pop hits 1
- romantic 1
- song cover 1
- together forever 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
Pgpd1yxLcLI | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | 1 | 30 | 40 | 0 | 0 | ["/m/013y1f", "/m/01s0ps", "/m/03xq_f", "/m/05148p4", "/m/05r5c"] |
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 );