musiccaps
2 rows where aspect_list contains "positive" and audioset_ids contains "/m/07y_7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
8DQbnR7hwpc | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | 1 | 30 | 40 | 0 | 0 | ["/m/03m5k", "/m/07y_7", "/m/0d8_n", "/m/0l14_3"] | |
fcpVyvn5vKk | This is a stringed quartet playing a piece that feels positive and happy. The instruments are violin and cello and the style of playing is reminiscent of Indian style violin playing. | ["stringed instrument", "violin", "orchestral violin playing", "staccato", "quarter", "indian style violin playing", "cello", "positive", "happy"] | ["Cello", "String section", "Violin, fiddle", "Bowed string instrument"] | 3 | 170 | 180 | 0 | 0 | ["/m/01xqw", "/m/02qmj0d", "/m/07y_7", "/m/0l14_3"] |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );