musiccaps
2 rows where aspect_list contains "male singer" and audioset_ids contains "/m/016cjb"
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 |
---|---|---|---|---|---|---|---|---|---|---|
BUzsQ6WohH4 | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | ["Singing", "Gospel music", "Music", "Wedding music"] | 7 | 30 | 40 | 0 | 1 | ["/m/015lz1", "/m/016cjb", "/m/04rlf", "/m/04wptg"] | |
wPmTJWybq_E | A male singer leads backup singers into a gospel song in vocal harmony. The tempo is medium with a groovy bass line , organ accompaniment, tambourine percussion, guitar strumming and keyboard accompaniment. The song is prayerful and spirited. The song has bad audio quality. | ["male singer", "backup singers", "vocal harmony", "medium tempo", "percussive bass line", "tambourine percussions", "christian contemporary music", "praise and worship", "meditational", "congregational music", "hymns", "prayers", "rejoicing", "bad audio quality", "organ accompaniment", "gospel band", "church service", "steady drumming rhythm", "piano acc"] | ["Gospel music", "Christian music", "Music"] | 1 | 210 | 220 | 0 | 0 | ["/m/016cjb", "/m/02mscn", "/m/04rlf"] |
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 );