musiccaps
2 rows where audioset_ids contains "/m/042v_gx" and end_s = 300
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 |
---|---|---|---|---|---|---|---|---|---|---|
3OLeJZF4oI0 | This guitar instruction audio features an acoustic guitar. This starts off with a male voice giving instructions on how to play the guitar. The bass note is played on the open string and the chord is strummed once. This is the Hendrix chord being played on the acoustic guitar. There are no other instruments in this song. There is no vocal melody in this song. This audio can be used in a guitar instruction video. | ["guitar instruction", "acoustic guitar", "male voice", "single strum", "7th chord", "no other instruments", "no vocal melody"] | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | 0 | 290 | 300 | 0 | 0 | ["/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/09x0r", "/m/0fx80y"] | |
PNT3hW4qFpQ | The low quality recording features a live performance of the percussive & arpeggiated acoustic guitar melody. There are some crowd chattering noises in the background, by which we can definitely conclude that it is, in fact, a live performance. Sounds a bit boomy and the high frequencies of the guitar are lacking volume. | ["low quality", "percussive arpeggiated acoustic guitar melody", "noisy", "crowd chattering", "live performance", "lacking high frequencies", "boomy"] | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument"] | 4 | 290 | 300 | 0 | 1 | ["/m/01glhc", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw"] |
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 );