musiccaps

1 row where aspect_list contains "amateur drumming" and audioset_ids contains "/m/026z9"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: audioset_ids (array)

ytid ▼ url caption aspect_list audioset_names author_id start_s end_s is_balanced_subset is_audioset_eval audioset_ids
UUJ1DNycpiQ This song is an energetic electronic instrumental. The song is medium fast tempo with an insistent synthesiser rhythm, dissonant tambourine funky bass and basic , amateur drumming, recurring vocal riff and vocal backup . The song is youthful, spirited, punchy and catchy with a dance groove. This song is an Electro Pop song. ["instrumental", "fast tempo", "electro pop", "amateur drumming", "house", "dj", "dance music", "punchy", "funky", "youthful", "buoyant", "synthesiser arrangement", "tambourine", "punchy bass lines", "straight drumming", "recurring vocal riff", "dance music", "synth pop", "pop", "pop hits", "vocal backup"] ["Disco", "House music", "Music", "Electronic dance music", "Dance music", "Electronica"] 7 30 40 0 1 ["/m/026z9", "/m/03mb9", "/m/04rlf", "/m/08cyft", "/m/0ggx5q", "/m/0m0jc"]

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