musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive" and musiccaps_aspects contains "alternative/indie" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- addictive · 2 ✖
- alternative/indie · 2 ✖
- groovy 2
- punchy kick 2
- punchy snare 2
- arpeggiated synth melody 1
- audio distortion 1
- drum break 1
- electric guitar chord progression 1
- energetic 1
- flat male vocal 1
- groovy bass 1
- groovy thin bass guitar 1
- harmonizing male vocals 1
- live performance 1
- low quality 1
- shimmering hi hats 1
- soft crash cymbal 1
- soft rimshots 1
- straight piano chords 1
- synth lead melody 1
musiccaps_names (array) 4 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Grizzly Bear "Yet Again" By Emily Kai Bock [Official Video] | The Alternative/indie song features harmonizing male vocals singing over groovy bass, punchy kick and snare hits, straight piano chords, synth lead melody and arpeggiated synth melody. It sounds groovy and addictive - like something you would hear in clubs during the 80s. | 2012-09-27T13:55:34Z | Creators | The new video for Yet Again taken from Grizzly Bear's album Shields, out now. You Should Subscribe to The Creators Project: http://bit.ly/YjRlED Executive produced by The Creators Project in partnership with Warp Records, the video was directed by Emily Kai Bock and shot in Toronto. http://grizzly-bear.net/music/albums/shields/ Artist: Grizzly Bear Track Title: "Yet Again" Director/Writer/Editor: Emily Kai Bock DP: Evan Prosofsky EP/Producer: Geoff McLean Underwater Camera Operator: Nabil Milne Line Producer: Anna Junger Prod Co: Vision Film Co / Logan & Sons 1st AC: Michael Bailey Gaffer: John Hall Key Grip: Nabil Milne SFX: Jeff Skochko PA: Jonathan Turner Lead Talent: Rebecca White Camper#1: Ted Reid Camper#2: James Turnbull Camper#3: Richard Harvey The Creators Project is a partnership between Intel and VICE: http://thecreatorsproject.com/ Grizzly Bear: http://grizzly-bear.net/ Subscribe to The Creators Project: http://bit.ly/Subscribe_to_TheCreatorsProject Check out our full video catalog: http://www.youtube.com/user/TheCreatorsProject/videos Buy Grizzly Bear - Shields: iTunes - http://glnk.it/1mo Amazon - http://glnk.it/1mq Best Buy - http://glnk.it/1mu Barnes & Noble - http://glnk.it/1mt Bleep - http://glnk.it/1ms | ["Independent music"] | ["alternative/indie", "harmonizing male vocals", "groovy bass", "punchy snare", "punchy kick", "synth lead melody", "straight piano chords", "arpeggiated synth melody", "groovy", "addictive"] | 4 | AuG9i5cwGW0 | 1181 | |
ill Scarlett - Babylon Song @ Sound of Music | The low quality recording features a live performance of an Alternative/Indie song and it consists flat male vocal singing over electric guitar chord progression, thin, but groovy bass guitar, punchy kick and snare hits, soft rimshots, soft crash cymbal, shimmering hi hats and a drum break. It sounds energetic, groovy and addictive, due to the cadence. | 2008-06-25T11:52:33Z | KyleCherops | ill Scarlett - "Babylon Song" live at Sound of Music Festival 2008 Burlington, ON | June 14, 2008 video 04 of 10 shot by Kyle Cheropita www.ishotyourset.net www.cherops.com | ["Music", "Rock and roll", "Exciting music"] | ["low quality", "live performance", "alternative/indie", "flat male vocal", "audio distortion", "electric guitar chord progression", "punchy kick", "shimmering hi hats", "punchy snare", "soft rimshots", "groovy thin bass guitar", "soft crash cymbal", "drum break", "addictive", "groovy", "energetic"] | 4 | 8akqVDDGsNQ | 931 |
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;