musiccaps

1 row where aspect_list contains "bouncy snare", aspect_list contains "groovy" and aspect_list contains "outro"

✎ View and edit SQL

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
Pm6vRblouxc The low quality recording features a R&B song that consists flat male vocal singing over layered repetitive plucked arpeggiated melody and synth arpeggiated melody, followed by smooth synth bass, bouncy snare, punchy kick, bright hi hats triplets and low toms. It sounds energetic and groovy, although it seems that the song is finishing, judging by the arrangement. ["low quality", "repetitive plucked arpeggiated melody", "arpeggiated synth melody", "low toms", "punchy kick", "bouncy snare", "bright hi hats triplets", "r&b", "flat male vocal", "smooth synth bass", "energetic", "outro", "groovy"] ["Timpani", "Music"] 4 170 180 0 1 ["/m/011k_j", "/m/04rlf"]

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);