musiccaps_details (view)
2 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "harmonizing male vocals" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- addictive · 2 ✖
- groovy bass 2
- harmonizing male vocals · 2 ✖
- punchy kick · 2 ✖
- punchy snare 2
- alternative/indie 1
- arpeggiated synth melody 1
- energetic 1
- groovy 1
- passionate male vocal 1
- rock 1
- shimmering cymbals 1
- straight piano chords 1
- synth lead melody 1
- wide electric guitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
Billy Talent - Fallen Leaves Music Video (HQ) | The Rock song features a passionate male vocal, alongside harmonizing male vocals, singing over wide electric guitar melody, groovy bass guitar, punchy kick and snare hits and some shimmering cymbals. It sounds energetic and kind of addictive thanks to those harmonizing vocals - like something you would hear on a radio during the 00s. | 2010-04-27T14:20:24Z | Jimmy Karlsson | The official music video of the song with the same name enjoy... Update 2012-12-01 Thanks for 100 000 views | ["Music", "Rhythm and blues", "Exciting music"] | ["rock", "passionate male vocal", "harmonizing male vocals", "wide electric guitar melody", "groovy bass", "punchy kick", "punchy snare", "shimmering cymbals", "energetic", "addictive"] | 4 | 0LE6Ll1rVlg | 150 | |
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 |
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;