musiccaps
3 rows where aspect_list contains "live recording" and audioset_ids contains "/m/04wptg"
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 |
---|---|---|---|---|---|---|---|---|---|---|
2YAyM0aHFRU | This song has a traditional African Arabic feel to it. There is an accordion, an upbeat vibe, and an ethnic vocal performance by the male vocalist. It is a live recording and the audio quality is not professional. | ["live recording", "male ethnic vocals", "low quality audio", "traditional african arabic music", "somali music", "upbeat", "fun", "dance", "celebration", "accordion"] | ["Music", "Wedding music", "Music of Latin America"] | 3 | 150 | 160 | 0 | 1 | ["/m/04rlf", "/m/04wptg", "/m/0g293"] | |
4cg3MsrvJqw | This is a traditional Chinese folk band playing a variety of traditional chinese instruments. The erhu, which sounds much like a violin, is being played in harmony with the guqin to create a melody which the performers also sing. The percussion is done on a bongo-sounding drum. This is a live performance, and we hear people speaking in the background. | ["gehu chinese instrument", "guqin chinese instrument", "live recording", "erhu chinese instrument", "hand cymbal", "bongo like percussion", "traditional chinese folk music", "group singing", "background talking"] | ["Music", "Musical instrument", "Wedding music", "Bowed string instrument"] | 3 | 210 | 220 | 0 | 0 | ["/m/04rlf", "/m/04szw", "/m/04wptg", "/m/0l14_3"] | |
GPSqrciDLog | This live recording features an instrumental song. This Regional Mexican song features an accordion playing the main melody. This is accompanied by an acoustic guitar strumming chords. A double bass plays the bass notes. A tambourine acts as the percussion. This song is in an upbeat mood. The song can be played at the entrance of a carnival. | ["low quality recording", "live recording", "accordion song", "acoustic guitar", "double bass", "tambourine", "no voice", "instrumental", "fast tempo"] | ["Music", "Wedding music"] | 0 | 30 | 40 | 1 | 1 | ["/m/04rlf", "/m/04wptg"] |
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 );