musiccaps
2 rows where aspect_list contains "people talking" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
NgniX3tg_Mo | The low quality recording features a live performance of a traditional song and it consists of a flat male vocal singing over sustained strings melody and mellow, subtle percussive element. There are some people talking in the background, followed by a cough. It sounds passionate and emotional, even though the recording is noisy and in mono. | ["low quality", "traditional", "live performance", "noisy", "mono", "flat male vocal", "mellow wooden percussion", "sustained strings melody", "passionate", "emotional", "people talking", "cough"] | ["Tabla", "Drum", "Percussion"] | 4 | 50 | 60 | 0 | 0 | ["/m/01p970", "/m/026t6", "/m/0l14md"] | |
zCGGb7Eh_f4 | The low quality recording features a hollow male talking over a traditional strings melody, while there are sounds of people talking and some wooden impacts in the background. The recording is noisy and the volume of the song slowly goes up, as the male vocal stops talking. | ["low quality", "hollow male vocal", "traditional strings melody", "wooden percussions", "noisy", "people talking", "wooden impacts", "music fade in"] | ["Tabla", "Percussion"] | 4 | 160 | 170 | 0 | 0 | ["/m/01p970", "/m/0l14md"] |
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 );