musiccaps
3 rows where aspect_list contains "piano" and audioset_ids contains "/m/0l14jd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
01hjVJN9xCg | A low fidelity recording of a gospel choir with group vocals, a female singer, a male rapper, piano, a busy kick pattern, finger snaps and a slow tempo. The mood is hopeful and spiritual. | ["low fidelity recording", "gospel", "choir", "piano", "group vocals", "female singer", "male rapper", "busy kick pattern", "finger snaps", "slow tempo", "hopeful", "spiritual"] | ["Music", "Choir", "/t/dd00003", "Synthetic singing"] | 8 | 30 | 40 | 0 | 0 | ["/m/04rlf", "/m/0l14jd", "/t/dd00003", "/t/dd00006"] | |
2zo5z1I0CeM | This pop song is sung by a female children's choir. The voices are soprano and alto. The soprano voice sings high pitch notes in vocals. The alto voices sing the words in parts. This is accompanied by the bass playing the root notes of the chords. A piano plays arpeggiated chords. The mood of this song is sad. This song can be played in a movie scene about reminiscing the past. | ["children's choir", "female voices", "soprano voices", "alto voices", "bass", "piano", "slow tempo", "sad melody"] | ["Singing", "Music", "Choir"] | 0 | 150 | 160 | 0 | 0 | ["/m/015lz1", "/m/04rlf", "/m/0l14jd"] | |
oNqBsQiNoAU | This song contains a female acapella choir singing together a melody in minor along with a piano. A e-guitar panned to the ride side of the speakers is providing a supporting melody. This song may be playing as a live performance in a theater. | ["acapella", "female choir", "piano", "e-guitar", "medium tempo"] | ["Choir"] | 6 | 40 | 50 | 0 | 0 | ["/m/0l14jd"] |
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 );