musiccaps
2 rows where aspect_list contains "guitar" 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 |
---|---|---|---|---|---|---|---|---|---|---|
GcYeBWujhjw | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | 0 | 10 | 20 | 0 | 0 | ["/m/02hnl", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/06by7", "/m/07pt_g0"] | |
oyAAhjGTNvQ | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | 0 | 0 | 10 | 0 | 0 | ["/m/018j2", "/m/04rlf", "/m/04szw", "/m/09x0r", "/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 );