home / musiccaps

musiccaps

1 row where aspect_list contains "complex harmony", audioset_ids contains "/m/06by7" and author_id = 7

✎ 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
VM-U7MyZAck This music is instrumental. The tempo is fast with an electric guitar playing a bright lead with infectious drumming and syncopated bass lines. The music is upbeat, energetic, youthful, animated, spirited, enthusiastic, groovy and funky. ["instrumental", "fast tempo", "amplified guitar", "loud electric guitar feedback", "sonic power", "sonic treat", "external amplification", "vibrations", "funk pop", "youthful", "punk rock", "energetic drumming", "funky bass line", "enthusiastic electric guitar lead", "infectious drumming", "catchy", "upbeat", "vibrant", "complex harmony", "loud", "enthusiastic", "youthful", "guitar harmony", "funky", "groovy", "upbeat catchy"] ["Blues", "Bass guitar", "Music", "Rock music", "Rock and roll"] 7 30 40 0 1 ["/m/0155w", "/m/018vs", "/m/04rlf", "/m/06by7", "/m/07sbbz2"]

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