musiccaps
2 rows where aspect_list contains "merry" and audioset_ids contains "/m/04szw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
q-sJu8CoZts | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | 7 | 50 | 60 | 0 | 0 | ["/m/018j2", "/m/01lyv", "/m/04rlf", "/m/04szw", "/m/074ft", "/m/0gg8l"] | |
rOOBAGxxjBk | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | 7 | 10 | 20 | 0 | 0 | ["/m/01kcd", "/m/04fq5q", "/m/04rlf", "/m/04szw", "/m/07c6l"] |
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 );