musiccaps
2 rows where aspect_list contains "harpsichord" and audioset_ids contains "/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 |
---|---|---|---|---|---|---|---|---|---|---|
ECP7EJka6N8 | This is a classical music piece played on the viola da gamba and the harpsichord. The performance is live, and the song has a refreshing, light and fun "Spring" feel to it. | ["live performance", "classical music", "live recording", "viola da gamba", "harpsichord", "soothing", "whimsical", "magical", "light", "fresh"] | ["Cello", "Harpsichord", "Music", "Musical instrument", "Piano", "Classical music", "Bowed string instrument"] | 3 | 590 | 600 | 0 | 1 | ["/m/01xqw", "/m/03q5t", "/m/04rlf", "/m/04szw", "/m/05r5c", "/m/0ggq0m", "/m/0l14_3"] | |
tW7478HnmCs | This symphonic song features a melody played on cellos and violins in the beginning. A similar melody is played on the harpsichord soon after. The harpsichord plays the melody as well as the bass notes. There is no percussion in this song. This song has no voices. This is an instrumental song which can be played at a black tie event. | ["symphonic song", "cello", "harpsichord", "instrumental", "no voices", "string section", "moderate tempo", "no percussion"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 0 | 150 | 160 | 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 );