musiccaps_details (view)
3 rows where musiccaps_aspects contains "percussions" and musiccaps_aspects contains "tambourine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- percussions · 3 ✖
- tambourine · 3 ✖
- amateur recording 2
- acoustic drums 1
- bass drum 1
- bongos 1
- brass band 1
- brass instruments 1
- burgeoning 1
- cello 1
- cowbell 1
- female voice singing 1
- higher pitch 1
- intense 1
- kickdrum 1
- lively piano 1
- orchestra 1
- orchestral music 1
- slower to mid-tempo 1
- snare drums 1
- symphony 1
- synced harmonies 1
- toms 1
- triumphant 1
- trumpets 1
- viola 1
- violin 1
- violins 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
- Timpani 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 | |
Mark Mothersbaugh - Ping Island / Lightning Strike Rescue Op | This song is an instrumental. The tempo is medium with lively trumpets, trombone ,enthusiastic percussion like the snare, cymbals and bass drum, tambourine , an intense and bright string harmony of violins, viola and cello. The music is intense, serious and is gradually building up. This is an Orchestral piece. | 2007-12-02T16:36:53Z | Evil Chicken MEDIA | The Life Aquatic with Steve Zissou-theme. On of the greatest movies ever made. If you havn't seen it; Go play with Barbie-dolls. | ["Timpani", "Music"] | ["snare drums", "trumpets", "violins", "triumphant", "acoustic drums", "tambourine", "orchestral music", "intense", "burgeoning", "synced harmonies", "bass drum", "viola", "cello", "brass band", "orchestra", "symphony", "brass instruments", "percussions", "lively piano"] | 7 | vOAXAoHtl7o | 5178 |
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;