musiccaps
3 rows where aspect_list contains "crowd noises" and audioset_ids contains "/m/04szw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0_QcatLmg7c | The low quality recording features a pop song performed by passionate male vocalists, followed by acoustic guitar arpeggiated melody and mellow piano melody. It sounds heartfelt and emotional. There are some crowd noises in the background. | ["low quality", "pop", "acoustic guitar arpeggiated melody", "passionate male vocal", "crowd noises", "mellow piano melody", "heartfelt", "emotional"] | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "/t/dd00003"] | 4 | 30 | 40 | 0 | 0 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/0fx80y", "/t/dd00003"] | |
GuHDy--gWiM | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 30 | 40 | 0 | 0 | ["/m/018j2", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
dNK9bD3LNCc | The low quality recording features a live performance of a country song that consists of a steel guitar melody, acoustic rhythm guitar chords and a walking bass guitar. There are some crowd noises in the background by which we can conclude that it is a live performance. | ["low quality", "country", "live performance", "walking bass guitar", "acoustic rhythm guitar chords", "acoustic steel guitar melody", "crowd noises"] | ["Banjo", "Country", "Music", "Musical instrument", "Bluegrass"] | 4 | 60 | 70 | 0 | 1 | ["/m/018j2", "/m/01lyv", "/m/04rlf", "/m/04szw", "/m/0gg8l"] |
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 );