home / musiccaps

musiccaps

1 row where aspect_list contains "folk song", aspect_list contains "low quality recording", aspect_list contains "moderate tempo" and aspect_list contains "tuba"

✎ 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
KubrAnJ0o0o This folk song features a choir singing the main melody. This is backed by percussion playing a simple beat in common time. A tambourine plays a continuous beat. The bass is played on a tuba. The tuba plays the root and fifth notes of the chords. At the beginning, a trumpet and accordion play a melody in harmony. The accordion continues to play chords in staccato while the choir sings the melody. The mood of this song is happy. This song can be played in a party where there is a large gathering. ["folk song", "accordion song", "foreign language", "choir song", "happy mood", "tuba", "low quality recording", "simple percussion", "tambourine", "trumpet music", "moderate tempo"] ["Christmas music", "Christian music", "Jingle (music)", "Music"] 0 360 370 0 1 ["/m/0140xf", "/m/02mscn", "/m/03r5q_", "/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 800.344ms · About: simonw/musiccaps-datasette