musiccaps
2 rows where aspect_list contains "wide brass section" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
7y9RfZXJZsk | The low quality recording features a regional Mexican song that consists of a reverberant male vocal singing over widely spread groovy piano chord progression, brass section, shimmering shakers, groovy percussive elements and smooth bass. It sounds tropical, exotic and fun, like something you would hear at latin weddings. | ["low quality", "groovy piano chord progression", "wide brass section", "shimmering shakers", "wide groovy percussive elements", "smooth bass", "reverberant make vocal", "traditional", "regional mexican", "tropical", "exotic", "fun"] | ["Music", "Salsa music"] | 4 | 90 | 100 | 0 | 1 | ["/m/04rlf", "/m/0ln16"] | |
8pYHLfKqHL4 | The Jazz song features a wide brass section playing over soft kick and rimshot hits, smooth bass guitar, mellow keys chords and soft electric guitar arpeggiated melody. It sounds relaxing, warm and calming - like something you would hear in waiting rooms. | ["wide brass section", "jazzy", "soft kick hits", "soft rimshot hits", "soft electric guitar arpeggiated melody", "mellow keys chords", "jazz", "relaxing", "calming", "smooth bass guitar", "warm"] | ["Foghorn", "Music", "Inside, large room or hall"] | 4 | 230 | 240 | 0 | 1 | ["/m/04fq5q", "/m/04rlf", "/t/dd00126"] |
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 );