musiccaps
2 rows where aspect_list contains "saxophone" and audioset_ids contains "/m/07c6l"
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 |
---|---|---|---|---|---|---|---|---|---|---|
IGyDtKAU1u8 | This is a jazz music piece. It is an instrumental piece. The saxophone and the trumpet are playing the melody. The piano, the electric guitar and the bass guitar are accompanying them in the background. The tempo is slow. The atmosphere is chill. This piece could be playing in the background at a coffee shop. | ["jazz music", "instrumental", "saxophone", "trumpet", "electric guitar", "piano", "bass guitar", "acoustic drums", "slow tempo", "chill"] | ["Brass instrument", "Saxophone", "Trombone"] | 9 | 550 | 560 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/07c6l"] | |
rOOBAGxxjBk | This music is a lively instrumental. The tempo is fast with the charming harmony of trumpet, saxophone, tuba and a rhythmic accordion accompaniment. The music is fresh, spirited,lively, pleasant, merry, cheerful, charming and entertaining. This music is a classical piece. | ["instrumental", "fast tempo", "brass band", "tuba", "wind instruments", "wood wind", "acordion", "trombone", "trumpet", "saxophone", "melodious harmony", "pleasant harmonious", "cheerful", "happy", "merry", "classical"] | ["Brass instrument", "Foghorn", "Music", "Musical instrument", "Trombone"] | 7 | 10 | 20 | 0 | 0 | ["/m/01kcd", "/m/04fq5q", "/m/04rlf", "/m/04szw", "/m/07c6l"] |
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 );