musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- energetic · 2 ✖
- low quality 2
- punchy kick · 2 ✖
- clapping 1
- dry flat male vocal 1
- exciting 1
- flat male vocal 1
- groovy bass guitar 1
- hip hop 1
- punchy snare 1
- punk 1
- shimmering cymbals 1
- shimmering open hat 1
- simple hi hats 1
- soft crash cymbal 1
- stuttering synth chords 1
- unnatural mix 1
- upbeat 1
- wide arpeggiated synth melody 1
- wide electric guitars 1
musiccaps_names (array) 9 ✖
- Happy music · 2 ✖
- Music 2
- Background music 1
- Dance music 1
- Funk 1
- Pop music 1
- Punk rock 1
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fortune Family - Young Hearts (Official Music Video) | The Low Quality Hip Hop song features a dry, flat male vocal rapping over punchy kick layered with shimmering open hats, punchy kick, simple hi hats, claps, syncopated snare hits, wide arpeggiated synth melody and stuttering synth chords. It sounds energetic and kind of unnatural, since the vocal is so detached from the instrumental due to the bad mixing of the song. | 2011-08-08T23:13:33Z | FortuneFam | Fortune Family is back with a new single "Young Hearts," directed by Ryan Do and presented by ThisSongIsSick.com. http://www.facebook.com/FF610 http://www.twitter.com/FortuneFamily Young Hearts samples Rod Stewart's "Young Turks." Download Link http://www.mediafire.com/?xem05efdcddgwqn For management and booking, contact Nick McCarthy at dpreppp@gmail.com | ["Funk", "Music", "Dance music", "Soul music", "Happy music"] | ["low quality", "dry flat male vocal", "punchy kick", "shimmering open hat", "simple hi hats", "soft crash cymbal", "stuttering synth chords", "wide arpeggiated synth melody", "clapping", "hip hop", "unnatural mix", "energetic"] | 4 | 2kcSUBkFbaQ | 404 | |
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 |
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;