musiccaps_details (view)

2 rows where musiccaps_aspects contains "wide electric guitar melody" and musiccaps_names contains "Independent music"

✎ View and edit SQL

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
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
Smashing Pumpkins - Whir (Whirl) The low quality recording features a rock song that consists of melancholic male vocal singing over a wide electric guitar melody, bouncy snare, groovy bass guitar and punchy kick. The recording is noisy, muddy and messy, since the frequencies are clashing with each other - drums cymbals are inaudible. Regardless, it sounds groovy, emotional and melancholic thanks to that vocal. 2012-04-26T21:13:42Z xthreenightsx Demo '92 ["Music", "Independent music", "Grunge"] ["low quality", "rock", "wide electric guitar melody", "melancholic male vocal", "bouncy snare", "groovy bass guitar", "noisy", "muddy", "messy", "punchy kick", "melancholic", "emotional", "groovy"] 4 aO0QzRPiEC4 3533

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;