musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "groovy", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "punchy kick"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Devil in Disguise | The low quality features a rock song that consists of a muffled passionate male vocal singing over wide acoustic rhythm guitars chords, shimmering cymbals, punchy kick and groovy bass. It sounds addictive, passionate and groovy - like something you would hear in pubs and bars during the 50s. | 2009-07-27T16:11:01Z | autopeerke | ["Music", "Rhythm and blues", "Ska"] | ["low quality", "rock", "muffled passionate male vocal", "wide acoustic rhythm guitars", "shimmering cymbals", "punchy kick", "groovy bass", "passionate", "addictive", "groovy"] | 4 | 9UOPRQhNzQ8 | 1014 | ||
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 | |
Aerosmith - Jaded | The rock song features a passionate male vocal, alongside harmonizing background vocal, singing over tremolo electric guitar located in the left channel, arpeggiated electric guitar melody in the right channel of the stereo image, shimmering tambourine, groovy bass guitar, punchy kick and snare hits, reverberant percussive hit and energetic crash cymbal. It sounds groovy, energetic and kind of addictive thanks to that cadence. | 2013-07-13T20:48:09Z | AerosmithVEVO | "Jaded" by Aerosmith Listen to Aerosmith: https://Aerosmith.lnk.to/listenYD Watch more Aerosmith videos: https://Aerosmith.lnk.to/listenYD/youtube Subscribe to the official Aerosmith YouTube channel: https://Aerosmith.lnk.to/subscribeYD Follow Aerosmith: Facebook: https://Aerosmith.lnk.to/followFI Instagram: https://Aerosmith.lnk.to/followII Twitter: https://Aerosmith.lnk.to/followTI Website: https://Aerosmith.lnk.to/followWI Spotify: https://Aerosmith.lnk.to/followSI Lyrics: My, my baby blue Yeah, I been thinking about you My, my baby blue Yeah, you're so jaded And I'm the one that jaded you #Aerosmith #Jaded #OfficialVideo #HD #Remastered | ["Singing", "Music", "Grunge"] | ["tremolo electric guitar chord", "harmonizing background vocal", "arpeggiated electric guitar melody", "punchy snare", "punchy kick", "groovy bass", "shimmering tambourine", "passonate male vocal", "reverberant percussion hit", "energetic crash cymbal", "groovy", "rock", "addictive", "energetic"] | 4 | qbexOeoH5hg | 4801 |
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;