home / musiccaps

musiccaps

2 rows where aspect_list contains "guitar rhythm", aspect_list contains "instrumental music", aspect_list contains "poor audio quality" and aspect_list contains "steady drumming rhythm"

✎ 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
OwUzGq0ceT8 The song is an instrumental. The tempo is medium with theremin playing passionately, steady drumming rhythm ,groovy bass line and keyboard accompaniment . The tunes are Christmas carols with poor audio quality. ["theremin", "christmas carols", "medium tempo", "carols", "christmas time", "santa claus", "poor audio quality", "reggae music influence", "steady drumming rhythm", "strong bass line", "emotional", "passionate", "exciting", "cheerful", "melancholic", "keyboard accompaniment", "theremin player", "instrumental music", "steady drumming rhythm", "strong bas slime", "live audience", "live performance", "guitar rhythm"] ["Music", "Theremin"] 1 30 40 0 0 ["/m/04rlf", "/m/07kc_"]
h2f_CKjQQg8 The song is instrumental. The song is medium tempo with an electric guitar lead, groovy bass line, steady drumming rhythm, cymbal crashes and keyboard harmony. The song is exciting and energetic. The song is a rock tune with poor audio quality. ["guitar lead", "medium tempo", "people cheering", "screaming sounds", "strong bass line", "guitar rhythm", "instrumental music", "poor audio quality", "live show performance", "cymbals crashing tones", "exciting", "energetic", "emotional", "cast introduction", "rock band playing", "steady drumming rhythm"] ["Applause", "Music"] 1 70 80 0 1 ["/m/028ght", "/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
);
Powered by Datasette · Queries took 793.577ms · About: simonw/musiccaps-datasette