musiccaps
2 rows where aspect_list contains "piano", aspect_list contains "saxophone" and audioset_ids contains "/m/0g293"
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 |
---|---|---|---|---|---|---|---|---|---|---|
FYux89o7Hhk | This is a live recording of the outro of a latin american salsa song. There are brass instruments like the saxophone and trumpet. There is a man who speaks in Spanish once the music stops. It was the end section or outro of a song. | ["latin american music", "salsa", "spanish", "outro", "brass instruments", "saxophone", "trumpet", "spanish speaking", "live recording", "live performance", "bongo drums", "drum roll", "piano"] | ["Singing", "Music", "Speech", "Music of Latin America", "Salsa music"] | 3 | 390 | 400 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/09x0r", "/m/0g293", "/m/0ln16"] | |
gMgN50wSnNc | This salsa song features a female voice singing the main melody. This is accompanied by percussion on a drum kit as well as on a congo. The congo gives this song the salsa feel. The drum kit plays the cowbell and high pitched snare drum to add more of the salsa vibe. The bass plays groovy fills. Trumpets, trombones and saxophones play fills in between lines. They play in harmony. A piano plays jazzy chords in the background. This song can be played in a dance club for a salsa night. | ["salsa song", "female voice", "percussion", "trumpets", "congo", "cowbell", "trombone", "saxophone", "dance song", "bass", "piano", "moderate tempo"] | ["Music", "Music of Latin America", "Salsa music"] | 0 | 200 | 210 | 0 | 0 | ["/m/04rlf", "/m/0g293", "/m/0ln16"] |
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 );