home / musiccaps

musiccaps

2 rows where aspect_list contains "male vocalist", aspect_list contains "medium fast tempo" and aspect_list contains "steady bass line"

✎ 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
Rhn6K9HCbC8 A male vocalist sings this passionate metal song. The tempo is medium fast with keyboard accompaniment, steady drumming and bass lines, electric guitar , sound of siren and vocal backup. The lead vocals are loud, passionate , volatile, hysterical ,disturbed,emphatic,sad, emotional, painful, disappointed and hurt. This song is Heavy/Goth Metal. ["male vocalist", "medium fast tempo", "loud", "disturbing", "crazy", "screaming", "metal", "heavy metal", "goth rock", "ambulance siren", "police van siren", "vocal backup", "keyboard accompaniment", "steady drumming", "intense", "passionate", "aggressive", "volatile", "vigorous", "steady bass line", "pain", "hurt", "mania", "psychopath", "hysteria"] ["Music", "Angry music"] 7 340 350 0 0 ["/m/04rlf", "/t/dd00036"]
XCQMJXkI5bA A male vocalist sings this upbeat song in a foreign language. The tempo is medium fast with a very perky and bouncy beat. The song is happy, cheerful, groovy, simple light and catchy with middle eastern music influences. This song is a contemporary Folk song. ["male vocalist", "medium fast tempo", "foreign language", "buoyant", "peppy", "happy", "cheerful", "middle eastern music", "upbeat", "catchy", "synthesiser arrangement", "conga", "hand percussion", "steady bass line", "flute melody", "folk song", "regional music"] ["Music of Africa", "Music"] 7 230 240 0 0 ["/m/0164x2", "/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 792.313ms · About: simonw/musiccaps-datasette