musiccaps
2 rows where aspect_list contains "harmonics" 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 |
---|---|---|---|---|---|---|---|---|---|---|
6TSluKI0X54 | This clip features a home recording of a musical piece using low quality gear. The clip is of a bass guitar and the sound is captured on the video capturing device and not through a mixer. The bass is playing hammer ons and harmonic notes. The notes are played on a particular scale. No percussion is played and no other instruments are featured in this song. | ["low quality recording", "home recording", "video camera recording", "bass guitar", "harmonics", "bass hammer on"] | ["Music", "Musical instrument", "Harmonic"] | 0 | 30 | 40 | 0 | 1 | ["/m/04rlf", "/m/04szw", "/m/0b9m1"] | |
CM7jMnBXw2Y | This rock song features a guitar solo being played on a distortion guitar. This starts off with a string bend followed by a descending lick. A harmonic string scratch technique is played to produce a screeching sound. This is followed by a fast ascending scale run. This is accompanied by percussion playing a simple rock beat. The bass plays the root notes of the chords. There are no voices in this song. This is an instrumental. Due to the low audio quality, the instruments are not clearly heard. | ["rock song", "low quality audio", "no voices", "instrumental", "distortion guitar", "guitar solo", "percussion", "bass", "harmonics", "moderate tempo", "string bending"] | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Pulse", "Plucked string instrument", "Bowed string instrument"] | 0 | 20 | 30 | 0 | 0 | ["/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/07pt_g0", "/m/0fx80y", "/m/0l14_3"] |
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 );