musiccaps

9 rows where audioset_ids contains "/m/04szw" and author_id = 2

✎ View and edit SQL

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
GG6XkHATIyw The music excerpt features a bass guitar that plays with the string slapping technique. This passage sounds as if it's meant to show some practicing exercises. ["bass guitarș string slapping technique"] ["Bass guitar", "Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] 2 90 100 0 1 ["/m/018vs", "/m/01glhc", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/0fx80y"]
JorNR3IXDyc The instrumental music features a marimba playing a simple melody in unison with another similar instrument and a xylophone accompanying them with fast repeating notes. A tambourine is playing once every beat. A drummer plays a repeating rhythm and drives the rhythm forward. ["drums", "instrumental", "no voice", "marimba", "xylophone", "tambourine"] ["Music", "Musical instrument", "Marimba, xylophone", "Percussion", "Steelpan"] 2 60 70 0 1 ["/m/04rlf", "/m/04szw", "/m/0dwsp", "/m/0l14md", "/m/0l156b"]
QHmGUrpOgAU The music features an ukulele playing a combination of melody and arpeggiated accompaniment. There are no other instruments, this is a solo interpretation. ["ukulele", "solo"] ["Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument", "Inside, small room"] 2 70 80 0 1 ["/m/0342h", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/07xzm", "/m/0fx80y", "/t/dd00125"]
TEoDtxjlctA The folk music excerpt features a group of male and female voices singing the same melody in unison which consists of yodeling. The instrumental consists of a few accordions, an acoustic guitar and an upright bass. The atmosphere is one of joy. ["male and female voices", "accordion", "acoustic guitar", "upright bass", "folk music", "yodeling", "joy"] ["Singing", "Yodeling", "Music", "Musical instrument"] 2 140 150 0 1 ["/m/015lz1", "/m/01swy6", "/m/04rlf", "/m/04szw"]
k2uiJXN3L6E The excerpt features an electric guitar playing a descending melody note by note with a slight distortion effect on. This doesn't sound like actual music but more like an exercise. ["electric guitar", "slight distortion effect", "no music", "exercise"] ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] 2 290 300 0 1 ["/m/0155w", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06w87", "/m/0fx80y"]
kg8FwhL_fqs The music is purely instrumental and it features two acoustic guitars. One of them is playing a melody in the high register while the other one is providing accompaniment by strumming chords. ["instrumental", "no voice", "acoustic guitars"] ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] 2 200 210 1 1 ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07xzm", "/m/0fx80y"]
nVsAyArtEh0 The music features an electric guitar playing what sounds to be a solo over a backing track or an actual recording of a song. The notes played in this passage are played fast. The vocabulary used by the guitarist resembles that of the jazz-fusion genre. ["electric guitar", "solo", "backing track", "fast notes", "jazz-fusion genre"] ["Electric guitar", "Jazz", "Music", "Musical instrument", "Bluegrass"] 2 30 40 1 1 ["/m/02sgy", "/m/03_d0", "/m/04rlf", "/m/04szw", "/m/0gg8l"]
w2vMywh5Nto The excerpt features a mandolin playing a folk song. This is the only musical instrument playing, there aren't others or any voices singing. The character of the song is joyful. ["mandolin", "instrumental", "no voice", "joyful", "folk song"] ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] 2 10 20 1 1 ["/m/0342h", "/m/04rlf", "/m/04rzd", "/m/04szw", "/m/0fx80y", "/m/0gg8l"]
zx_vcwOsDO4 The rock music is purely instrumental and features an electric guitar with a distortion effect on. The guitarist is playing a lot of notes with virtuosity. This music excerpt would make for a really good electric guitar solo. ["instrumental", "no voice", "electric guitar", "distortion effect", "virtuosity", "rock genre", "solo"] ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument"] 2 50 60 1 1 ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/04szw"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);