musiccaps
1 row where aspect_list contains "package opening" and aspect_list contains "piano"
This data as json, CSV (advanced)
aspect_list (array) 11 ✖
- acoustic drums 1
- background music 1
- brass 1
- cheerful 1
- clarinet 1
- jazz 1
- lively 1
- package opening · 1 ✖
- piano · 1 ✖
- toy review 1
- upright bass 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
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 );