musiccaps

2 rows where aspect_list contains "noisy" and audioset_ids contains "/m/02v2lh"

✎ 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
FE2kALvHjEU The low quality recording features an old video game song that consists of sustained synth strings melody, mellow percussions, groovy, thin bass and synth pad chords. The recording is very noisy and the stereo image is unbalanced as it is leaning towards the left channel. It sounds a bit glitchy and slightly detuned too. ["low quality", "noisy", "unbalanced stereo", "detuned", "glitchy", "sustained synth strings melody", "mellow percussions", "groovy thin bass", "synth pad chords", "video game song"] ["New-age music", "Music"] 4 30 40 0 1 ["/m/02v2lh", "/m/04rlf"]
LAxCq-s84F8 The low quality recording features a flat female vocal shortly talking on a very noisy microphone, after which a song fades in. The song consists of soft, reverberant female vocal singing over echoing dark rimshots, punchy kick and groovy piano melody. Overall it has a dark and mellow vibe to it. ["low quality", "fade in", "soft reverberant female vocal", "noisy", "flat female vocal", "echoing dark rimshot", "punchy kick", "groovy piano melody", "dark", "mellow"] ["New-age music"] 4 380 390 0 0 ["/m/02v2lh"]

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