home / musiccaps

musiccaps

1 row where aspect_list contains "amateur recording", aspect_list contains "bass", aspect_list contains "crowd cheering" and aspect_list contains "moderate tempo"

✎ 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
MMGAKKhqxKg This amateur recording starts off with the sound of the crowd at a live show. This is followed by a male voice mouthing four blasting sounds over the mic. This is followed by a guitar playing a funk riff and another guitar playing a lower register melody. The percussion plays a fast beat. The bass plays only one note in a continuous pattern following the percussion. The mood of this song is upbeat. This song can be played in a retro club. ["amateur recording", "crowd cheering", "falsetto voice", "vocables", "guitar sounds", "fast paced percussion", "bass", "moderate tempo", "upbeat song"] ["Music", "Pop music", "Thump, thud"] 0 160 170 0 0 ["/m/04rlf", "/m/064t9", "/m/07qnq_y"]

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 809.285ms · About: simonw/musiccaps-datasette