musiccaps_details (view)
2 rows where musiccaps_aspects contains "punchy kick", musiccaps_aspects contains "simple hi hats" and musiccaps_names contains "Funk"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- punchy kick · 2 ✖
- simple hi hats · 2 ✖
- clapping 1
- claps 1
- disco 1
- dry flat male vocal 1
- energetic 1
- flat male vocal 1
- funky 1
- funky synth lead melody 1
- groovy 1
- groovy bass 1
- hip hop 1
- low quality 1
- passionate 1
- punchy snare 1
- shimmering open hat 1
- soft crash cymbal 1
- stuttering synth chords 1
- synth keys chords 1
- unnatural mix 1
- wide arpeggiated synth melody 1
- wide funky electric guitar melody 1
musiccaps_names (array) 5 ✖
- Funk · 2 ✖
- Music 2
- Dance music 1
- Happy music 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 | |
*Classy Freak* | The Disco song features a flat male vocal singing over a wide funky electric guitar melody, groovy bass, synth keys chords, funky synth lead melody, punchy kick, punchy snare layered with some claps and simple hi hats. It sounds passionate, funky and groovy. | 2008-06-22T21:32:10Z | IwYlAj | PLAIR 1984 Label: P.A.R. | ["Funk", "Music"] | ["disco", "wide funky electric guitar melody", "synth keys chords", "funky synth lead melody", "groovy bass", "punchy kick", "punchy snare", "simple hi hats", "claps", "flat male vocal", "passionate", "funky", "groovy"] | 4 | p8xxC2um9xQ | 4688 |
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;