musiccaps
1 row where aspect_list contains "hopeful" and aspect_list contains "pop rock"
This data as json, CSV (advanced)
aspect_list (array) 6 ✖
- angelically harmonized mixed vocals 1
- cover 1
- emotional 1
- hopeful · 1 ✖
- pop rock · 1 ✖
- soft acoustic rhythm guitar 1
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 );