musiccaps
1 row where aspect_list contains "passionate male singer" and audioset_ids contains "/m/01s0ps"
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"] |
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 );