musiccaps
2 rows where aspect_list contains "live performance" and audioset_ids = "["/m/015lz1", "/m/04rlf", "/t/dd00034"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
MROotmz8a-U | A female vocalist sings this enchanting song.the tempo is slow with this clip opening with the vocalist almost ending the sentence. The singer is accompanied by mesmerising Violin symphony and piano accompaniment . This song is a live performance as it is sung with an orchestra and there is the sound of people talking. The song is enchanting, ethereal, captivating, soothing and celestial. | ["female singer", "slow tempo", "violin harmony", "live performance", "concert", "orchestra", "celestial", "cello", "viola", "symphony", "orchestra", "celestial music", "ethereal", "soothing", "rich", "eloquent piano accompaniment", "ethereal", "compelling", "enigmatic", "mesmerising", "captivating", "interlude in song", "powerful vocals", "live performance", "people talking"] | ["Singing", "Music", "Tender music"] | 7 | 180 | 190 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/t/dd00034"] | |
NwUJe24OxC8 | The low quality recording features a live performance of a ballad song that consists of passionate male vocal singing over a mellow piano melody. It sounds soft, emotional, sad and heartfelt. | ["low quality", "live performance", "passionate", "male vocal", "mellow piano melody", "soft", "emotional", "heartfelt", "ballad", "sad"] | ["Singing", "Music", "Tender music"] | 4 | 160 | 170 | 0 | 1 | ["/m/015lz1", "/m/04rlf", "/t/dd00034"] |
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 );