musiccaps
2 rows where aspect_list contains "upright bass" and audioset_ids contains "/m/07y_7"
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 |
---|---|---|---|---|---|---|---|---|---|---|
VB82vMSTYK0 | This composition contains a small orchestra playing melodies on violas and violins in the higher mid range to the higher register. The celli and the upright bass being stroked with a bow are playing a rhythmic melody part that gives the foundation of the song. This song may be playing live as a classical concert. | ["classical", "orchestra", "upright bass", "celli", "violins/violas", "uptempo", "uplifting mood"] | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | 6 | 30 | 40 | 0 | 0 | ["/m/01xqw", "/m/02fsn", "/m/07y_7", "/m/0l14_3"] | |
j0UMI2DrnMA | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | 6 | 130 | 140 | 0 | 0 | ["/m/018j2", "/m/04rlf", "/m/04szw", "/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 );