musiccaps
2 rows where aspect_list contains "danceable" and audioset_ids contains "/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"] | |
nyLpME6YH20 | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | ["Music", "Ska"] | 9 | 190 | 200 | 0 | 0 | ["/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 );