musiccaps
2 rows where aspect_list contains "jazz" and audioset_ids contains "/m/01wy6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
588osm3C4bw | The low quality recording features a live performance of a jazz song that consists of a clarinet solo melody played over groovy piano, mellow brass melody, shimmering hi hats and mellow kick hits. It sounds emotional, easygoing and chill. | ["low quality", "live performance", "jazz", "clarinet solo melody", "mellow brass melody", "groovy piano melody", "shimmering hi hats", "mellow kick hits", "passionate", "emotional", "easygoing", "chill"] | ["Brass instrument", "Clarinet", "Trombone", "Trumpet"] | 4 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/01wy6", "/m/07c6l", "/m/07gql"] | |
Pzp_oTEn0Yk | This is a toy package opening video with a jazz music piece in the background. In the piece, there is a clarinet playing the leading melody while other brass elements, the piano and the upright bass are accompanying it with backing tunes. The rhythm is being played by the upbeat jazz acoustic drums. The atmosphere of the piece is lively. If the package opening sounds could be removed, the piece would suit well in the soundtrack of a feelgood animation movie. | ["toy review", "package opening", "background music", "jazz", "clarinet", "brass", "upright bass", "piano", "acoustic drums", "cheerful", "lively"] | ["Brass instrument", "Clarinet", "Trombone", "Trumpet", "Wind instrument, woodwind instrument"] | 9 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/01wy6", "/m/07c6l", "/m/07gql", "/m/085jw"] |
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 );