musiccaps
2 rows where aspect_list contains "pop rock" and author_id = 4
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"] | |
WTVC7ZI9WtY | The low quality recording features a live performance of a pop rock song and it consists of flat male vocals counting down over addictive synth melody, energetic drums and groovy bass guitar. There are loud crowd screams in the background. It sounds distorted, loud and crushed, as it was probably recorded with a phone, but it is still energetic and exciting. | ["pop rock", "flat male vocal", "low quality", "live performance", "energetic", "exciting", "crowd screaming", "loud", "addictive synth melody", "energetic drums", "groovy bass guitar", "distorted", "crushed"] | ["Music", "Pop music", "Exciting music"] | 4 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/064t9", "/t/dd00035"] |
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 );