musiccaps_details (view)
3 rows where musiccaps_aspects contains "home music video", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- home music video · 3 ✖
- instrumental music 3
- passionate · 3 ✖
- spirited · 3 ✖
- guitar lead 2
- poor audio quality 2
- soloist 2
- steady rock drumming 2
- adventure of a lifetime 1
- adventurous 1
- backing track 1
- bad audio quality 1
- classic rock 1
- classic rock instrumental 1
- classic rock playlist 1
- distortion guitar accompaniment 1
- driving song 1
- emotional 1
- entertaining 1
- groovy bass line 1
- groovy rhythm 1
- guitar demo 1
- guitar solo 1
- high on adrenaline 1
- high spirits 1
- hissing noise 1
- medium fast tempo 1
- medium tempo 1
- memdium tempo 1
- never give up 1
- organ accompaniment 1
- percussionist 1
- positive 1
- practice room 1
- psychedelic 1
- rehearsal session 1
- relaxing 1
- retro rock music 1
- rhythm guitar 1
- song cover 1
- steady bass line 1
- string section playing 1
- tambourine percussions 1
- tambourine playing percussively 1
- varying volume levels 1
- vintage rock vibes 1
- western classical music 1
musiccaps_names (array) 8 ✖
- Music 3
- Blues 1
- Grunge 1
- Heavy metal 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My Grandfather's Clock with tabs | The song is an instrumental. The song is medium tempo with an electric guitar playing lead and distorted guitar rhythm, along with groovy bass line and rock drumming rhythm. The song is exciting and spirited. The song is a classic rock instrumental with poor quality audio. | 2007-08-16T21:36:56Z | Rockaholick1 | This video got mirrored when I recordet it! I do not play a left-handed guitar in this video!! Sponsored by Dean Markley inc.: http://www.deanmarkley.com/ If you like what you hear then SUBSCRIBE, as I probably will be releasing more material soon! For tabs and backing track, go here: http://kabudono01.s344.xrea.com/download_ookina/ A SPECIAL THANKS TO ALL WHO LEAVE A COMMENT AND RATING! A pure Rock N' Roll song for all the Rockaholics out there! Played with the amazing Gibson Custom EDS-1275! | ["Blues", "Heavy metal", "Music", "Punk rock", "Rock music", "Progressive rock"] | ["instrumental music", "guitar lead", "spirited", "song cover", "passionate", "home music video", "high spirits", "never give up", "adventurous", "classic rock playlist", "relaxing", "driving song", "distortion guitar accompaniment", "rhythm guitar", "classic rock instrumental", "memdium tempo", "groovy bass line", "steady rock drumming", "high on adrenaline", "poor audio quality"] | 1 | Lrhy2auO6hY | 2226 | |
Snap Crackle and how`s your Dad | The song is an instrumental. The song is medium tempo with a groovy bass line, rock drumming, tambourine percussion, guitar rhythm and guitar lead. The song is adventurous and emotional. The song is classic rock and has a poor audio quality. | 2010-06-19T06:13:50Z | BurnsErnst | Here is another special tune by The Shadows. Backing track is from the original vinyl record without the first lead. On some parts, where the lead was on both channels, I try to play as exactly along with Hank as I could. I hope it`s ok. | ["Music", "Grunge"] | ["instrumental music", "guitar lead", "soloist", "guitar solo", "vintage rock vibes", "emotional", "spirited", "passionate", "groovy rhythm", "psychedelic", "backing track", "classic rock", "tambourine percussions", "medium tempo", "steady rock drumming", "organ accompaniment", "poor audio quality", "home music video", "guitar demo", "retro rock music", "steady bass line", "adventure of a lifetime"] | 1 | g6f-LxiT9Eo | 4006 | |
Carnival Overture - Tambourine performed by Steve Myers | The song is an instrumental. The song is medium fast tempo with a western classic al piece featuring a string string section plays and a tambourine player practices along with background music. The song is spirited and passionate. The audio quality is very poor. | 2011-06-22T18:06:47Z | ybooby | Dvoraks Carnival Overture | ["Music", "Tambourine"] | ["tambourine playing percussively", "home music video", "entertaining", "soloist", "percussionist", "rehearsal session", "bad audio quality", "practice room", "instrumental music", "hissing noise", "varying volume levels", "string section playing", "positive", "spirited", "passionate", "western classical music", "medium fast tempo"] | 1 | xzgnLpKkvdg | 5375 |
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;