musiccaps
2 rows where aspect_list contains "ad jingle" and is_balanced_subset = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
D2w3qHmJrdU | The song is an instrumental. The song is medium tempo with a guitar playing solo, steady drum rhythm, groovy bass line and steady bass line. The song is funky and groovy in nature. The song is an ad jingle. | ["instrumental music", "cash register click", "passionate", "spirited", "exciting", "medium tempo", "groovy rhythm", "romantic", "energetic", "youthful", "jazz music influences", "dreamy", "enterprising", "guitar solo", "groovy bass line", "steady drumming rhythm", "ad jingle", "soundtrack", "funk jazz music", "shakers percussions", "groovy", "soul music", "medium tempo"] | ["Music", "Camera"] | 1 | 0 | 10 | 1 | 1 | ["/m/04rlf", "/m/0dv5r"] | |
qni67aUJbw4 | The song is an instrumental. The song is medium tempo with a steady drumming rhythm, cymbals crashing, piano accompaniment and a xylophone playing a cool melody. The song is emotional and passionate. The song is an ad jingle for a technology solutions company. | ["ad jingle", "medium tempo", "instrumental music", "cymbal crash", "piano accompaniment", "xylophone plays melody", "steady drumming rhythm", "piano plays percussively", "subtle bass line", "pop instrumental", "innovation", "emotional", "passion spirit", "work ethics", "creating solutions", "tech solutions", "advanced technology", "smart minds"] | ["Music", "Vibraphone"] | 1 | 160 | 170 | 1 | 1 | ["/m/04rlf", "/m/0dwt5"] |
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 );