musiccaps
3 rows where aspect_list contains "ballad", aspect_list contains "emotional" and author_id = 3
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
FgUSmmTEE3M | This is a piano-based ballad. The song is emotional, uplifting and generally pulls on your heartstrings. The singer sounds passionate and sings legato notes while the violins play sustained notes behind him to create an even more dramatic effect. | ["piano", "ballad", "emotional", "violins", "uplifting", "touching", "goosebumps", "passionate male singer"] | ["Electric piano", "Keyboard (musical)", "Piano"] | 3 | 0 | 10 | 0 | 0 | ["/m/01s0ps", "/m/05148p4", "/m/05r5c"] | |
cQWJeYfyw8Y | This feels like a romantic ballad. The bansuri plays a soothing melody and the male vocalist comes in with a beautiful and gentle voice. This is an Indian song and it is emotional and brings about stillness. The acoustic guitar plays arpeggios. | ["bansuri", "soothing indian male vocal", "gentle male vocal", "acoustic guitar arpeggio", "romantic", "emotional", "ballad", "south asian ballad"] | ["Music", "Middle Eastern music"] | 3 | 110 | 120 | 0 | 0 | ["/m/04rlf", "/m/06j64v"] | |
sL01xTmV_Fc | This is an emotional ballad played on the theremin. The audio quality is poor, but still we feel the sad and sombre effects of the melody played by the performer. | ["live recording", "theremin", "poor audio quality", "emotional", "sad", "outside", "ballad"] | ["Music", "Theremin"] | 3 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/07kc_"] |
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 );