musiccaps
2 rows where aspect_list contains "romantic" 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 |
---|---|---|---|---|---|---|---|---|---|---|
fvpDYGzdRmo | The song is an instrumental. The tempo is medium with a recorder being played with a lot of heart, accompanied by string section harmony. The song is emotional and has a lot of spirit. The song is a western classical music masterpiece. | ["recorder", "recorder player", "alto recorder", "fingering technique", "wind player", "bass recorder", "instrumental music", "string section harmony", "philharmonic orchestra", "western classical music", "music legends", "composers", "conductor", "opera hall", "emotional", "lilting melody", "romantic", "inspiring", "medium tempo", "concerto"] | ["Music", "Musical instrument", "Opera", "Orchestra", "Wind instrument, woodwind instrument", "Flute"] | 1 | 120 | 130 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/05lls", "/m/05pd6", "/m/085jw", "/m/0l14j_"] | |
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"] |
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 );