musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "harmonizing vocals", musiccaps_aspects contains "low quality" and musiccaps_author = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
Myanmar Funny Gay dancing music video | The low quality recording features a pop song that consists of groovy piano chords, harmonizing background vocals, punchy kick and snare hits, shimmering shakers, groovy bass and muffled female vocals singing over it. It sounds energetic, happy, fun and addictive - like something you would hear on a radio. | 2011-12-30T17:53:01Z | Moe Hein Lay | Myanmar Funny Gay dancing music video | ["Music of Asia", "Music", "/t/dd00032"] | ["low quality", "pop", "muffled female vocal", "punchy snare", "punchy kick", "shimmering shakers", "groovy piano chords", "groovy bass", "harmonizing vocals", "energetic", "addictive", "happy fun"] | 4 | JvqCsVj0I4k | 2045 | |
LAUGHTER DA MASTER SEASON 2 SEMIFINAL EPISODE 18 PART 1 OF 8 | The low quality recording features a jingle that consists of harmonizing vocals talking over snare roll, toms roll, brass melody and groovy bass, after which there is a folk song that starts playing. The folk song contains strings melody, bouncy snare, shimmering hi hats and synth keys chords. It sounds energetic and exciting, and like something you would hear on some TV show. | 2013-01-08T17:16:36Z | LaughterDaMaster2 | ["Folk music", "Music", "Snicker"] | ["harmonizing vocals", "snare roll", "jingle", "tom roll", "brass melody", "groovy bass", "low quality", "mono", "folk", "bouncy snare", "strings melody", "synth keys chords", "energetic", "exciting"] | 4 | bzOeufhFITk | 3670 | ||
Far East Movement - She's On The Move HQ | The low quality recording features a pop song that consists of harmonizing vocals singing over punchy snare and kick hits and shimmering cymbals. It sounds energetic and exciting. | 2010-03-19T22:20:52Z | Paweł Szymański | Far East Movement - She's On The Move from Gossip Girl S03E14 'The Lady Vanished' I do not own any right to this video! | ["Music", "Exciting music"] | ["low quality", "pop", "harmonizing vocals", "punchy snare", "shimmering cymbals", "punchy kick", "energetic", "exciting"] | 4 | dT7uHHQEYHQ | 3789 | |
Ruben Sasunci ft. Gohar Hovhannisyan - Ari Zoravar // Armenian Folk // HF New // HD | The low quality recording features a pop song that consists of harmonizing vocals singing over pulsating synth lead melody, groovy bass, "4 on the floor" kick pattern, punchy snare, shimmering hi hats and some wooden percussive elements. It sounds energetic and addictive. | 2015-09-07T18:32:51Z | HayFanat | http://hayfanat.com Here is "Ari Zoravar" by Ruben Sasunci and Gohar Hovhannisyan. Music & Lyrics by Gusan Haykazun Follow HayFanat also on Facebook http://www.facebook.com/hayfanat Google+ http://www.google.com/+HayFanat Instagram https://instagram.com/hayfanatofficial Twitter https://twitter.com/hayfanat HayFanat.com © 2015. All Rights Reserved. | ["Folk music", "Music"] | ["low quality", "pop", "harmonizing vocals", "pulsating synth lead melody", "groovy bass", "\"4 on the floor\" kick pattern", "punchy snare", "shimmering hi hats", "wooden percussive elements", "energetic", "addictive"] | 4 | qjJ41iwU9LY | 4811 |
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;