musiccaps
2 rows where aspect_list contains "instrumental music" and audioset_ids = "["/m/01xqw", "/m/02fsn", "/m/07y_7", "/m/0l14_3"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
fxznho_kNPY | The song is an instrumental. The song is medium tempo with a violin, viola, cello playing a string harmony accompanied by an acoustic guitar strumming chords. The song is a western classical music piece. | ["violin", "viola", "cello", "acoustic guitar strumming", "poor audio quality", "wedding music", "party music", "string quartet", "string trio", "string harmony", "instrumental music", "western classical music", "live performance", "studio performance", "medium tempo", "exciting", "cheerful", "dance music", "composer", "enthusiastic", "passionate", "exciting"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 1 | 90 | 100 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/07y_7", "/m/0l14_3"] | |
wBe5tW8iJew | The song is an instrumental. The song is slow tempo with a violin and cello playing a duet with no other instrumentation. The song is emotional and extremely heartfelt. The song is a western classical music hit. | ["violin solo", "cello solo", "string duet", "heartfelt", "duet", "orchestra", "opera hall", "concert hall", "live audience", "string section", "great composers", "great vibrato", "masterful string technique", "virtuosos in play", "conductor", "live performance", "heart strings", "instrumental music", "philharmonic orchestra", "western classical music", "emotional", "romantic", "passionate", "sentimental"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 1 | 0 | 10 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/07y_7", "/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 );