musiccaps
1 row where aspect_list contains "great technique" and aspect_list contains "western classical music"
This data as json, CSV (advanced)
aspect_list (array) 24 ✖
- cellist 1
- cello concerto 1
- concert hall 1
- conductor 1
- dvorak 1
- emotional 1
- great composers 1
- great technique · 1 ✖
- groovy music 1
- instrumental music 1
- live audience 1
- live performance 1
- medium tempo 1
- opera hall 1
- passionate 1
- philharmonic orchestra 1
- poor audio quality 1
- spirited 1
- string section 1
- timpani bangs loud 1
- violins playing harmony 1
- virtuously 1
- western classical music · 1 ✖
- wind sections 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
yrme-KRBvzk | The song is an instrumental. The tempo is medium with a cellist playing a virtuoso solo accompanied by a string section harmony, flutes in harmony and a loud banging timpani. The song is spirited and passionate with poor audio quality. The song is a western classical piece. | ["cellist", "string section", "philharmonic orchestra", "cello concerto", "dvorak", "virtuously", "timpani bangs loud", "medium tempo", "wind sections", "violins playing harmony", "groovy music", "western classical music", "great composers", "conductor", "opera hall", "live audience", "live performance", "instrumental music", "passionate", "spirited", "emotional", "great technique", "poor audio quality", "concert hall"] | ["Cello", "Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | 1 | 50 | 60 | 0 | 0 | ["/m/01xqw", "/m/04rlf", "/m/04szw", "/m/05pd6", "/m/07y_7", "/m/0ggq0m", "/m/0l14_3"] |
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 );