musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy piano melody", musiccaps_aspects contains "rock" and musiccaps_aspects contains "shimmering hi hats"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- groovy piano melody · 2 ✖
- rock · 2 ✖
- shimmering hi hats · 2 ✖
- addictive 1
- electric guitar melody 1
- energetic 1
- energetic crash cymbals 1
- flat male vocal 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- harmonizing male vocals 1
- low quality 1
- punchy kick 1
- punchy snare 1
- snare roll 1
- soft kick hits 1
- tom roll 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Felix Hagan & The Family - Sing Your Last Lullaby | The Rock song features a flat male vocal singing over a wide electric guitar melody, shimmering hi hats, energetic crash cymbals, punchy snare and kick hits, groovy bass guitar and piano chord progression. At the end of the loop, there is a short tom roll, representing a transition to the next section. It sounds energetic - like something you would hear on a radio. | 2013-08-13T22:24:25Z | Felix Hagan | This is the second video from our EP, String Up The Entertainer, which will be released in September. It is quite possibly the silliest thing we have ever done. We hope you enjoy it. For gigs, news, photos and everything else visit: http://www.facebook.com/felixhaganmusic The EP, along with our last album, will be available to download at: http://felixhagan.bandcamp.com/ Twitter also exists: @FelixHagan Feel free to check out our other videos on here and if you like them, come down to a show! We'd love to meet you. Crew: Director: Joe Mannion - sleepingstate.com DOP: Guy Gotto Camera Assistant: Rob Abercrombie Hair and Make Up: Rebecca Doney Cast: Jesus: Felix Hagan Judas: Ellie Cowan Peter: Will Stanley Disciples: Tash Hodgson, Stuart Mann, Tom Webber, Effie Stoodley, Gareth Williams, Rebecca Doney, Jess O'Neill, Amy Schofield, David Wilson and Rob Abercrombie. We would especially like to thank Clare College, Cambridge and Effie Stoodley for being simply beautiful and providing us with the perfect location in which to hurl custard about. We would also like to thank Dunn's Bakery, Crouch End for arming us with such delicious ammo. Go there and eat everything. That's an order. | ["Music", "Punk rock", "Independent music"] | ["rock", "flat male vocal", "wide electric guitar melody", "groovy piano melody", "shimmering hi hats", "energetic crash cymbals", "punchy kick", "groovy bass guitar", "energetic", "tom roll"] | 4 | CIoEXRnAr-Y | 1349 | |
Kansas - Point of Know Return (Official Video) | The low quality recording features a rock song that consists of harmonizing male vocals singing over groovy piano melody, groovy bass guitar, electric guitar melody, punchy snare, soft kick hits and shimmering hi-hats. There is a short snare roll that serves as a transition into a new section. It sounds groovy and addictive. | 2013-01-17T11:25:12Z | kansasVEVO | Official music video for “Point of Know Return” by Kansas Listen to Kansas: https://Kansas.lnk.to/listenYD Watch more videos by Kansas: https://Kansas.lnk.to/listenYD/youtube Subscribe to the official Kansas YouTube channel: https://Kansas.lnk.to/subscribeYD Follow Kansas Facebook: https://Kansas.lnk.to/followYD/facebook Instagram: https://Kansas.lnk.to/followYD/instagram Twitter: https://Kansas.lnk.to/followYD/twitter Website: https://Kansas.lnk.to/followYD/websitegeneral Spotify: https://Kansas.lnk.to/followYD/spotify Lyrics: Your father, he said he needs you Your mother, she says she loves you Your brothers, they echo your words: "How far to the point of know return?" "Well, how long?" #Kansas #PointofKnowReturn #Rock | ["Singing", "Country"] | ["low quality", "rock", "harmonizing male vocals", "groovy piano melody", "groovy bass", "electric guitar melody", "punchy snare", "snare roll", "soft kick hits", "shimmering hi hats", "groovy", "addictive"] | 4 | iFWtsT5zRKo | 4174 |
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;