musiccaps
3 rows where audioset_ids contains "/m/02rr_" and start_s = 90
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 |
---|---|---|---|---|---|---|---|---|---|---|
40i3_JH6FYw | This is a recording of an instrumental jam. There is a blues type solo being performed on an overdriven electric guitar. The guitar has an 80s sound. This recording could be sampled for use in beat-making or as an advertisement jingle. | ["jam", "instrumental", "single instrument", "overdriven electric guitar", "guitar solo", "80s sound", "blues"] | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion", "Bowed string instrument"] | 9 | 90 | 100 | 0 | 0 | ["/m/01b9nn", "/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y", "/m/0g12c5", "/m/0l14_3"] | |
KSFND-AdqZs | This audio contains a e-guitar running through a tremolo effect that gets into faster modulation speed. This is an amateur recording and may be used for educational purposes. | ["amateur recording", "e-guitar", "tremolo effect", "medium to fast tempo"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Rock music", "Harmonic", "Plucked string instrument", "Distortion"] | 6 | 90 | 100 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06by7", "/m/0b9m1", "/m/0fx80y", "/m/0g12c5"] | |
vKNGqQ3GRB8 | This song features an electric guitar playing arpeggiated chords. There are open strings being played in the arpeggios. A chorus effect is added to the guitar sound. At the end of the song, one guitar chord is played. There are no voices in this song. This is an instrumental song. There are no other instruments in this song. | ["electric guitar", "arpeggiated chords", "chorus effect", "no other instruments", "no voices", "instrumental"] | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | 0 | 90 | 100 | 0 | 0 | ["/m/02rr_", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07m2kt", "/m/0fx80y"] |
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 );