musiccaps_details (view)
3 rows where musiccaps_aspects contains "flat male vocal", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Punk rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- energetic 3
- flat male vocal · 3 ✖
- punchy kick · 3 ✖
- groovy bass guitar 2
- low quality 2
- punchy snare 2
- rock 2
- shimmering hi hats 2
- background male vocal 1
- electric guitars melodies 1
- emotional 1
- energetic crash cymbals 1
- exciting 1
- groovy bass 1
- groovy piano melody 1
- punk 1
- shimmering cymbals 1
- tom roll 1
- upbeat 1
- wide electric guitar melody 1
- wide electric guitars 1
musiccaps_names (array) 11 ✖
- Music 3
- Punk rock · 3 ✖
- Background music 1
- Drum kit 1
- Guitar 1
- Happy music 1
- Independent music 1
- Musical instrument 1
- Pop music 1
- Rock music 1
- Ska 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 | |
Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 | |
Alkaline Trio - All On Black (Live On Letterman) | The low quality recording features a rock song that consists of a flat male vocal, alongside background male vocals, singing over shimmering hi hats, groovy bass, punchy kick and snare hits and electric guitar melodies. It sounds energetic and emotional. | 2007-06-24T14:06:26Z | AllHopeDeleted | All On Black Performed Live on Letterman from the album 'Good Mourning' http://www.youtube.com/jazzbandrock | ["Drum kit", "Guitar", "Music", "Musical instrument", "Punk rock", "Rock music"] | ["low quality", "rock", "background male vocal", "flat male vocal", "shimmering hi hats", "electric guitars melodies", "groovy bass", "punchy kick", "punchy snare", "emotional", "energetic"] | 4 | yQN9gj7Vk0w | 5408 |
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;