musiccaps
2 rows where aspect_list contains "country" and audioset_ids contains "/m/02mscn"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Y7mTjfgcybQ | A female and male duo yodeling over a fast bluegrass band. The bass and drums are steady and simple as is the chord progression. The guitarist and other instrumentalists are virtuosic. | ["yodeling", "female and male yodeling", "country", "fast", "bluegrass", "steady bass and drums", "guitar", "virtuosic", "simple rhythms", "simple chord progression"] | ["Christmas music", "Singing", "Gospel music", "Yodeling", "Christian music", "Music", "Song"] | 8 | 30 | 40 | 1 | 1 | ["/m/0140xf", "/m/015lz1", "/m/016cjb", "/m/01swy6", "/m/02mscn", "/m/04rlf", "/m/074ft"] | |
mlpTCec4igo | The low quality recording features a country song that contains harmonizing vocals singing over electric guitar solo melody, smooth bass guitar, acoustic rhythm guitar, snappy rimshots, shimmering hi hats and soft kick hits. It sounds soulful, emotional and passionate. | ["low quality", "country", "harmonizing vocals", "electric guitar solo melody", "smooth bass guitar", "snappy rimshot", "shimmering hi hats", "soft kick hits", "acoustic rhythm guitar", "soulful", "emotional", "passionate"] | ["Gospel music", "Christian music", "Music", "Happy music"] | 4 | 90 | 100 | 0 | 0 | ["/m/016cjb", "/m/02mscn", "/m/04rlf", "/t/dd00031"] |
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 );