musiccaps
2 rows where aspect_list contains "brass melody" and audioset_ids contains "/m/015lz1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
hlHb9HwNxk8 | The low quality recording features a live performance of an opera that consists of a passionate female vocal singing over strings melody, brass melody and mellow percussion. It sounds emotional and passionate. | ["low quality", "noisy", "live performance", "opera", "passionate female vocal", "strings melody", "brass melody", "mellow percussions", "passionate", "emotional"] | ["Singing", "Music", "Opera", "Classical music"] | 4 | 110 | 120 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/05lls", "/m/0ggq0m"] | |
oBBTqXQFTiA | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing over punchy kick and snare, shimmering hi hats, groovy bass, brass melody and electric guitar melody. There are some crowd clapping and cheering sounds in the background. It sounds energetic, exciting and groovy. | ["live performance", "low quality", "crowd clapping", "crowd cheering", "pop", "harmonizing male vocals", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "brass melody", "electric guitar melody", "groovy", "energetic", "exciting"] | ["Singing", "Music of Latin America"] | 4 | 80 | 90 | 0 | 0 | ["/m/015lz1", "/m/0g293"] |
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 );