musiccaps
1 row where aspect_list contains "pleasant" and aspect_list contains "pop hit"
This data as json, CSV (advanced)
aspect_list (array) 15 ✖
- bright electric guitar 1
- buoyant 1
- emotional 1
- energetic drumming 1
- enthusiastic vocals 1
- keyboard accompaniment 1
- love song 1
- male vocalist 1
- melodious acoustic guitar rhythm 1
- passionate 1
- pleasant · 1 ✖
- pop hit · 1 ✖
- soft rock 1
- teen pop 1
- youtube video 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
QutCXtWmzIs | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | ["Music", "Punk rock", "Independent music", "Song"] | 7 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/05r6t", "/m/05rwpb", "/m/074ft"] |
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 );