musiccaps
3 rows where aspect_list contains "piano" and audioset_ids contains "/m/0342h"
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 |
---|---|---|---|---|---|---|---|---|---|---|
4M0njWKFsME | Here we have a powerful rock ballad instrumental in a minor key. The guitar is grungy and overdriven, and the piano is clean and plays the same chords as the guitar at the same time. | ["rock music", "piano", "electric guitar strumming", "minor key", "rock power ballad", "ballad", "grungy electric guitar strumming", "overdrive"] | ["Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | 3 | 30 | 40 | 0 | 0 | ["/m/02sgy", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/07s0s5r", "/m/0fx80y"] | |
hVVrl9FkKnY | This is an instrumental rock music piece recording in the style of blues. There is an electric guitar playing a solo using the shredding technique. The backing track consists of a piano, a bass guitar and acoustic drums. There is a groovy feel to it. Parts of this recording could be sampled for use in beat-making. | ["rock music", "jam", "no singer", "instrumental", "electric guitar", "guitar solo", "shredding", "backing track", "piano", "bass guitar", "acoustic drums", "groovy", "blues"] | ["Blues", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 9 | 240 | 250 | 0 | 0 | ["/m/0155w", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
qAgZ__fk9LY | This slow blues song features a solo played on a guitar. The tempo of this song is slow. This is accompanied by percussion playing a simple beat. The bass follows the 12 bar blues pattern. The piano plays chords in the background. The mood of this song is romantic and the pattern played on the guitar is similar to a call-response theme. This song can be played in a bar. | ["slow blues song", "instrumental", "guitar solo", "bass", "simple percussion", "12 bar blues", "piano", "slow tempo", "no voices"] | ["Guitar", "Jazz", "Music", "Musical instrument", "Plucked string instrument"] | 0 | 50 | 60 | 1 | 1 | ["/m/0342h", "/m/03_d0", "/m/04rlf", "/m/04szw", "/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 );