musiccaps
2 rows where aspect_list contains "joyful" and audioset_ids = "["/m/04rlf", "/m/06rqw"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
KV99GJg0tvA | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | ["Music", "Ska"] | 9 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/06rqw"] | |
xUVvBF9BWdg | A male singer sings this jazz melody with the backup singer in vocal harmony. The song is medium tempo, with saxophone harmony, ska drumming rhythm and a good bass line. The song is entertaining and groovy. The song is a classic jazz tune played in ska style. | ["male singer", "reggae music", "ska band", "dance rhythm", "people dancing", "band recording", "classy", "medium tempo", "guitar accompaniment", "bass guitar", "saxophones harmony", "backup singer", "vocal harmony", "groovy bass line", "jazz music", "funky jazz", "percussive horn section", "joyful", "passionate", "medium tempo", "syncopated vocals", "ska orchestra", "jazz hits", "life’s truths"] | ["Music", "Ska"] | 1 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/06rqw"] |
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 );