musiccaps
2 rows where aspect_list contains "upright bass" and audioset_ids contains "/m/0395lw"
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 |
---|---|---|---|---|---|---|---|---|---|---|
CpHRQ-f4UtA | This song contains a timpani hit going along with single notes of an upright bass. A string section is playing a simple melody in a higher key while an oboe/flute is playing the lead melody. In the background you can hear a brass section playing along with the strings rising and falling in volume. This song may be playing in a sad and mystic movie scene. | ["cinematic/orchestral", "oboe", "strings", "upright bass", "timpani", "brass", "marimba/xylophone", "mystic", "sad atmosphere"] | ["Organ", "Bell", "Music"] | 6 | 140 | 150 | 0 | 0 | ["/m/013y1f", "/m/0395lw", "/m/04rlf"] | |
aNjtfIoVzas | This song contains a plucked string instrument playing a melody in the higher register along with an acoustic guitar strumming chords on the backbeat and an upright bass playing a simple melody along to the lead melody. This song may be playing in a video-presentation. | ["country/folk", "acoustic guitar", "upright bass", "plucked string instrument", "medium to uptempo"] | ["Bell", "Music"] | 6 | 0 | 10 | 0 | 0 | ["/m/0395lw", "/m/04rlf"] |
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 );