musiccaps
2 rows where aspect_list contains "great composers" and audioset_ids contains "/m/05pd6"
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 |
---|---|---|---|---|---|---|---|---|---|---|
q6GBCmLxNIk | The song is an instrumental. The tempo is medium with a string section accompanying the first violin playing a melancholic melody. The song is emotional and melancholic. The song is a classic western classical music piece. | ["first violin solo", "string section", "opera hall", "great composers", "beautiful music", "legendary violinists", "tense", "eerie", "philharmonic orchestra", "conductor", "cellos", "violas", "violins", "lead melody", "instrumental music", "string orchestra", "western classical music", "vibrato", "violin virtuoso", "greta composers", "melancholic music", "romantic", "emotional", "heartfelt", "the good life", "passionate"] | ["String section", "Orchestra"] | 1 | 30 | 40 | 0 | 0 | ["/m/02qmj0d", "/m/05pd6"] | |
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 );