musiccaps_details (view)
3 rows where musiccaps_aspects contains "drum kit" and musiccaps_author = 8
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Magasin - Eraserheads (Paolo Santos Cover) | instrumental rock music with a drum kit, lots of cymbal crashes, acoustic guitar strumming, harmonized lead guitars and an active bass guitar. | 2008-02-07T23:57:50Z | joaq25 | Song:Magasin Artist:Eraserheads(This version sang by Paolo Santos) | ["Music", "Rock music", "Progressive rock"] | ["rock", "four chord jam", "drum kit", "cymbal crashes", "acoustic guitar strumming", "harmonized lead guitars", "active bass guitar", "instrumental"] | 8 | 9kt7rsziUVQ | 1038 | |
| Karla Urias singing Amazing Grace w/Gospel Choir | A live recording of an instrumental piano trio. The recording is boomy and low fidelity. The drumming is active and the piano playing is pretty. The drum kit features a sidestick. Electric bass is also present. Crowd noise can be heard. Sounds like gospel music that might be heard at a church service. | 2007-07-31T04:49:03Z | Karla Urias | This was the Gospel Choir + Me singing Amazing Grace 7-29-2007 @ the Fairbanks Summer Arts Festival | ["Gospel music", "Music"] | ["live recording", "boomy", "low fidelity", "piano trio", "instrumental", "drum kit", "sidestick", "piano", "electric bass", "active drums", "pretty piano", "crowd noise"] | 8 | gAURHUoIK0M | 4011 | |
| Brooklyn Elbert & Kassidy King sing "How Does She Yodel" 2011 Christmas | A quiet recording of two female singers participating in a yodeling call and response section, accompanied by accordion, drum kit, bass and guitar playing a steady oompah beat. The chord progression is simple and the mood is fun and silly. | 2012-01-28T00:04:23Z | LilCutieBittys | 10 year olds- Brooklyn Elbert and Kassidy King of Avery and The Calico Hearts perform a duet to "How Does She Yodel" in which they both show off their country twang, natural break abilities, and harmonizing yodeling skills. Brought the house down (second year in a row). Trivia fact: This is Kassidy's 4th year to sing this song at a Cactus Christmas show. Great way to see both of these girls, who usually sing back up to Avery (Winter), featured prominently. The girls are students of Terri Caldwell Music under the direction of Cami Caldwell. Intro by Terri Caldwell. Video by Johnny Busby. Taken at the Cactus Kids Christmas show December 2011 at the Cactus Theater in Lubbock, Texas. | ["Singing", "Yodeling", "Music", "Music of Latin America"] | ["quiet recording", "yodeling duet", "call and response", "two female vocalists", "oompah", "accordion", "simple chord progression", "drum kit", "guitar", "fun", "silly"] | 8 | qaQjG9SwORU | 4799 |
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;