musiccaps
2 rows where aspect_list contains "hopeful" and audioset_ids contains "/m/02fxyj"
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"] | |
z2kTJ6pQ4Uo | This is a movie music piece. There is a female vocalist singing melodically at the forefront. There is an acoustic guitar playing the main tune with a bass guitar holding the root notes in the background. The rhythmic structure is composed of acoustic sounding drums and percussion playing a syncopated beat. There is a feeling of hope in this piece. This piece could be used in the soundtrack of an inspiring movie/TV show. It could also be played at sports venues. | ["movie music", "female vocal", "melodic singing", "acoustic guitar", "bass guitar", "drums", "percussion", "relaxing", "hopeful", "indian"] | ["Humming", "Music", "Inside, small room"] | 9 | 110 | 120 | 1 | 1 | ["/m/02fxyj", "/m/04rlf", "/t/dd00125"] |
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 );