musiccaps
2 rows where aspect_list contains "percussion" and audioset_ids contains "/m/07xzm"
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 |
---|---|---|---|---|---|---|---|---|---|---|
LjxhswBV1UA | This song has a traditional Mexican mariachi sound. It is fun, vibrant and energetic and is led by rhythmic and melodic playing on the Mexican Vihuela. The maracas add an element of rhythmic percussion. There are sounds of laughter in the background. | ["maracas", "background laughter sounds", "mexican vihuela", "mexican traditional music", "percussion", "stringed instrument", "mariachi music", "fiesta", "celebration", "upbeat", "energetic", "fun"] | ["Guitar", "Music", "Musical instrument", "Rattle (instrument)", "Ukulele", "Plucked string instrument"] | 3 | 20 | 30 | 0 | 1 | ["/m/0342h", "/m/04rlf", "/m/04szw", "/m/05r5wn", "/m/07xzm", "/m/0fx80y"] | |
iBH5X5SKirU | This jazz song features a guitar solo. This is accompanied by percussion playing a simple beat. An acoustic guitar strums chords on each count of the bar. The bass plays the root notes of the chords. There are no voices in this song. The song has a happy mood. This song can be played in a coffee shop. | ["jazz song", "acoustic guitar", "guitar solo", "bass guitar", "instrumental", "no voices", "percussion", "moderate tempo", "easy listening", "happy mood"] | ["Music", "Ukulele"] | 0 | 80 | 90 | 1 | 1 | ["/m/04rlf", "/m/07xzm"] |
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 );