musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- amateur recording · 3 ✖
- percussions · 3 ✖
- tambourine 2
- asian/traditional 1
- bongos 1
- cowbell 1
- female voice shouting 1
- female voice singing 1
- flute 1
- higher pitch 1
- kickdrum 1
- slower to mid-tempo 1
- toms 1
- uptempo 1
- very high key 1
- violin 1
musiccaps_names (array) 14 ✖
- Music 2
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Harp 1
- Musical instrument 1
- Percussion 1
- Singing 1
- Snare drum 1
- Tambourine 1
- Traditional music 1
- Violin, fiddle 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cumpleaños con arpa y violin en san jenaro chorrillos 2015 | This audio contains someone playing a melody on a violin. A female voice is singing along in a high pitch. The background is filled with percussive instruments and a tambourine. This song may be playing during the celebration. | 2015-07-27T16:12:39Z | Roberto Vargas.t | cumpleaños de la sra. EPIFANIA GONZALES canta estrellita de san cristobal puquio 18/07/2015 | ["Singing", "Harp", "Music", "Musical instrument", "Tambourine", "Violin, fiddle"] | ["amateur recording", "violin", "female voice singing", "higher pitch", "percussions", "tambourine", "slower to mid-tempo"] | 6 | LGW99kSaf6M | 2169 | |
Cold Pressed (David Hollinden) - Jan Nguyen, percussion - May 2013 | Someone is playing an evolving rhythm on various percussion instruments. This seems to be a professional piece with a lot of dynamics. This song may be playing as a part of an orchestra performance. | 2013-07-06T22:12:28Z | Arts Laureate | Jan Nguyen, percussion, performs in the Gildenhorn Recital Hall at the University of Maryland, College Park, MD on May 7, 2013. | ["Wood block", "Drum", "Drum kit", "Drum roll", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "percussions", "tambourine", "kickdrum", "bongos", "toms", "cowbell"] | 6 | Zo9xROGuV3k | 3415 | |
OTONE traditional japanese music | This song contains someone playing a bass drum instrument along with someone playing a triangle. A female voice is shouting while a flute is playing the main melody in a very high key. This song may be playing at a theater performance in an Asian country. | 2009-07-11T21:38:30Z | TheJapanClassic | Otone Ensemble live in concert - Berlin (Germany), June 2009. Dance with mask. | ["Traditional music", "Music"] | ["asian/traditional", "percussions", "female voice shouting", "flute", "very high key", "amateur recording", "uptempo"] | 6 | xKEJ6fVhb8w | 5317 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;