musiccaps
2 rows where aspect_list contains "relaxing" and audioset_ids = "["/m/015y_n", "/m/04rlf"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
L1s7KZgWXGc | The Swing song features an echoing male vocal singing over smooth double bass, offbeat soft piano chords and widely spread sustained strings melody. It sounds easygoing, relaxing, smooth, warm and euphoric as it reminds of Christmas. | ["swing", "smooth double bass", "offbeat sot piano chords", "wide sustained string melody", "echoing male vocal", "easygoing", "relaxing", "smooth", "euphoric", "warm"] | ["Swing music", "Music"] | 4 | 30 | 40 | 1 | 1 | ["/m/015y_n", "/m/04rlf"] | |
XKp670Yh0E0 | This is the opening of a reggae song played live during a performance. There is a saxophone playing a solo as the lead. An electric guitar and a bass guitar play the tune in the background. The acoustic drums follow a basic, repetitive reggae beat. The song could be played at a bar or a coffee house. | ["reggae", "live performance", "concert", "saxophone", "electric guitar", "bass guitar", "acoustic drums", "relaxing"] | ["Swing music", "Music"] | 9 | 0 | 10 | 0 | 1 | ["/m/015y_n", "/m/04rlf"] |
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 );