musiccaps
2 rows where aspect_list contains "vocal harmony" 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| -XkbErI_7EU | This slow jazz song features male voices singing the main melody in harmony. This is accompanied by percussion playing a simple beat. The double bass plays the root notes of the chords. Trumpets play a fill in harmony in between lines. A piano plays an arpeggiated chord at the end of the first line. This song has a romantic mood. This song can be played in a classic romantic movie. | ["slow jazz song", "barbershop quartet", "trumpets", "double bass", "vocal harmony", "male voices", "piano", "slow tempo", "romantic song"] | ["Brass instrument", "French horn"] | 0 | 50 | 60 | 0 | 0 | ["/m/01kcd", "/m/0319l"] | |
| f4jW2H6V7gk | A male singer sings this exciting melody with female backup singers in vocal harmony. The song is medium fast tempo with a strong bass line, steady drumming rhythm, keyboard accompaniment and a car horn playing percussively. The song has pretty bad audio quality. The song is a retro hip hop dance tune. | ["male singer", "hip hop music", "car horn playing percussively", "female backup singers", "groovy dance rhythm", "vocal harmony", "poor audio quality", "energetic", "exciting", "cheerful", "dance song", "retro dance hits", "hip hop dance hits", "steady drumming rhythm", "strong bass line", "keyboard accompaniment", "hissing noise", "medium-fast tempo"] | ["Brass instrument", "Trumpet"] | 1 | 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 );