musiccaps
2 rows where aspect_list contains "chill" and audioset_ids contains "/m/02sgy"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ALVS3Q_jNaU | This is the recording of a jazz reggae concert. There is a saxophone lead playing a solo. There is a keyboard and an electric guitar playing the main tune with the backing of a bass guitar. In the rhythmic background, there is an acoustic reggae drum beat. The atmosphere is groovy and chill. This piece could be playing in the background at a beach. It could also be included in the soundtrack of a summer/vacation/tropical themed movie. | ["jazz", "reggae", "live performance", "concert", "saxophone", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "relaxing", "calm", "chill", "tropical", "jam"] | ["Blues", "Effects unit", "Electric guitar", "Guitar", "Music", "Reggae", "Plucked string instrument", "Distortion"] | 9 | 30 | 40 | 1 | 1 | ["/m/0155w", "/m/02rr_", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/06cqb", "/m/0fx80y", "/m/0g12c5"] | |
ZmgkpmzvL6c | The low quality recording features a smooth buzzy bass guitar and chill, electric guitar melody playing. It is noisy and the stereo image is unbalanced, as the bass guitar is leaning toward the left channel. It sounds easygoing, chill and relaxing. | ["low quality", "smooth buzzy bass guitar", "chill electric guitar melody", "noisy", "unbalanced stereo", "chill", "easygoing", "relaxing"] | ["Bass guitar", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | 4 | 30 | 40 | 1 | 1 | ["/m/018vs", "/m/01glhc", "/m/02sgy", "/m/0342h", "/m/042v_gx", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );