musiccaps
1 row where aspect_list contains "angelically harmonized mixed vocals" and aspect_list contains "pop rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
O9Ag-dE-yfQ | The Recording features a cover of a pop rock song and it consists of soft acoustic rhythm guitar located in the left channel and angelically harmonized mixed vocals singing on top of it. It sounds hopeful and emotional. | ["soft acoustic rhythm guitar", "angelically harmonized mixed vocals", "pop rock", "cover", "hopeful", "emotional"] | ["Humming", "Music"] | 4 | 0 | 10 | 0 | 1 | ["/m/02fxyj", "/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 );