musiccaps
2 rows where aspect_list contains "drums" and audioset_ids contains "/t/dd00126"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ESbtW0CUmp4 | This audio contains someone playing a gospel/jazz melody when a very loud drum comes in with a fill-in on the toms. This is an amateur recording and of poor audio-quality. This song may be playing in a gospel church. | ["amateur recording", "gospel", "piano", "drums", "jazzy", "slower to medium tempo"] | ["Music", "Keyboard (musical)", "Harmonic", "Inside, large room or hall"] | 6 | 0 | 10 | 0 | 0 | ["/m/04rlf", "/m/05148p4", "/m/0b9m1", "/t/dd00126"] | |
qie2k2gZ7wA | The rock music features a screaming male voice singing a melody. One of the electric guitars accompanies the singer with strummed chords while the other, for the second part of the music excerpt, plays a melody. Both guitars have a distortion effect on. The drums play a well grounded rhythm and together with the bass guitar drive the pulse of the music. The quality of the audio recording is not that good, most probably this is an old live recording. | ["low quality audio recording", "rock genre", "screaming male voice", "electric guitars", "distortion effect", "drums", "bass guitar", "live recording"] | ["Music", "Yell", "Inside, large room or hall"] | 2 | 490 | 500 | 1 | 1 | ["/m/04rlf", "/m/07sr1lc", "/t/dd00126"] |
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 );