musiccaps
1 row where aspect_list contains "acoustic guitar lead" and aspect_list contains "simple"
This data as json, CSV (advanced)
aspect_list (array) 20 ✖
- acoustic guitar lead · 1 ✖
- buoyant 1
- cheerful 1
- electric guitar harmony 1
- enthusiastic drumming 1
- female singer 1
- foreign language 1
- fresh 1
- funky bass lines 1
- happy 1
- medium tempo 1
- peppy 1
- perky 1
- pleasant melody 1
- pop song 1
- simple · 1 ✖
- teen pop 1
- vivacious 1
- vocal harmony 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
gBuLpP4klvI | A female vocalist sings this chirpy song. The tempo is medium with a melodic electric guitar harmony, acoustic guitar lead, sprightly drumming, funky bass lines and peppy backup. The song is youthful, perky, cheerful, vivacious ,bubbly and in a foreign language.This song is teen pop/ Pop. | ["female singer", "medium tempo", "foreign language", "electric guitar harmony", "funky bass lines", "acoustic guitar lead", "enthusiastic drumming", "vocal harmony", "youthful", "pleasant melody", "simple", "fresh", "happy", "perky", "cheerful", "vivacious", "buoyant", "peppy", "pop song", "teen pop"] | ["Jingle (music)", "Music", "Rhythm and blues", "Happy music"] | 7 | 30 | 40 | 1 | 1 | ["/m/03r5q_", "/m/04rlf", "/m/06j6l", "/t/dd00031"] |
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 );