musiccaps
2 rows where aspect_list contains "philharmonic orchestra" and audioset_ids contains "/m/0ggq0m"
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 |
---|---|---|---|---|---|---|---|---|---|---|
X2gHQb5ubco | A female opera singer sings this climatic high pitched finish. The song is medium tempo with a string section accompaniment and a rhythm Section. The song is dramatic and high on adrenaline. The audio quality is very poor. | ["female singer", "opera singer", "opera hall", "rhythm section", "philharmonic orchestra", "poor audio quality", "composer", "conductor", "operatic theme", "high pitched vocals", "bad audio quality", "song ending", "dramatic finish", "building tension", "climactic", "string section crescendo", "movie soundtrack", "medium tempo"] | ["Music", "Opera", "Classical music"] | 1 | 280 | 290 | 0 | 0 | ["/m/04rlf", "/m/05lls", "/m/0ggq0m"] | |
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 );