musiccaps
2 rows where aspect_list contains "important" and audioset_ids contains "/m/01kcd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
kmmK69N3Om0 | This clip is regal, momentous, big, impressive. We hear a loud bang on the timpani percussion instrument, followed by a motif on the french horn. This is the type of piece that would be played for the arrival of a king, or the return of an epic war hero. | ["regal", "important", "presence", "brass instrument", "french horn", "timpani", "orchestral", "momentous", "king", "queen", "march"] | ["Brass instrument", "Trumpet"] | 3 | 20 | 30 | 0 | 0 | ["/m/01kcd", "/m/07gql"] | |
sOJSjVp6UTc | This music is instrumental. The tempo is slow with a single note played on a horn-like instrument . The instrument sounds like a Jewish Ram’s horn. It is loud, emphatic, and authoritative with the sound of running water in the background . It is a celebratory,festive ritual music for making announcements. This music is Ritual music. | ["instrumental", "jewish horn", "bugle like sound", "ritual music", "religious significance", "festive", "important", "sound of water in background", "ram’s horn", "horn blowing", "wake up call", "celebration", "announcement", "loud", "authoritative"] | ["Brass instrument", "Trumpet"] | 7 | 30 | 40 | 0 | 0 | ["/m/01kcd", "/m/07gql"] |
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 );