musiccaps
3 rows where aspect_list contains "amateur recording" and audioset_ids contains "/m/03t3fj"
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 |
---|---|---|---|---|---|---|---|---|---|---|
nrj2zTr7U0o | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 1 | 30 | 40 | 0 | 0 | ["/m/0239kh", "/m/026t6", "/m/02hnl", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
tOb0M2k3deo | Someone is playing a drum groove on the ride with a lot of fill-ins on toms. This song may be playing during drum practice. | ["amateur recording", "drums", "medium to uptempo"] | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | 6 | 30 | 40 | 0 | 0 | ["/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03t3fj", "/m/06rvn", "/m/0bm02", "/m/0l14md"] | |
yMEMzSFbZ2s | This audio contains someone playing a fast paced drum groove with a lot of double hits on the kick and tom. The drumming stops and then a male voice starts talking. This may be used for a drum tutorial video. | ["acoustic drums", "amateur recording", "male voice speaking", "fast paced"] | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | 6 | 110 | 120 | 0 | 0 | ["/m/01qbl", "/m/026t6", "/m/02hnl", "/m/02k_mr", "/m/03qtq", "/m/03t3fj", "/m/0bm02", "/m/0l14md"] |
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 );