musiccaps_details (view)
5 rows where musiccaps_aspects contains "dance", musiccaps_names contains "Exciting music" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Travis Porter - BANANAS Official Music Video (In New York City) | This is a hip-hop piece. There is a male vocal rapping at the forefront while other male vocals can be heard singing ad-libs. A repeated theme is being played by a keyboard. A synth bass with low-to-mid characteristics can be heard playing in the background. The rhythmic background consists of a hard-hitting electronic drum beat. The atmosphere is groovy. This piece could be played at nightclubs. It would also suit well with a sports venue setting. | 2010-03-02T02:24:39Z | Travis Porter | Official Travis Porter Bananas Music Video shot in NEW YORK CITY! | ["Music", "Exciting music"] | ["hip-hop", "male vocals", "rapping", "repeated theme", "keyboard", "synth bass", "electronic drums", "simple", "groovy", "dance", "loud"] | 9 | 0bRUkLsttto | 189 | |
120521 Kara - Mister [HD] @ MBC Korean Music Wave in Google | This audio contains a digital drum with a kick on every beat. An e-bass is playing a slightly funky groove. A synthesizer is playing a short fast melody. Another synth sound is playing a string/pad sound rising up into focus. A female voice is singing, then another female voice takes over singing. The crowd is cheering loudly. This song may be playing during a live show. | 2012-05-26T12:15:23Z | kpopcouchcrew | For more kpop concert updates follow~ http://twitter.com/couch_crew | ["Music", "Exciting music"] | ["amateur recording", "pop", "dance", "e-bass", "digital drums", "synth pluck", "strings", "female voice singing", "crowd cheering", "uptempo"] | 6 | 4Ua6i_VDYU4 | 575 | |
I'm Sexy and I Know It (Official Music Video).By:THECARSIBESIKTAS1903 | This is a house music piece. There is a synth with a crisp sound playing the melody while a lot of turntable scratches can be heard in the background. An electronic drum beat with lots of snare beat repeat sounds provide the rhythm. The atmosphere is energetic and upbeat. This piece could be played at nightclubs or dance clubs. | 2011-12-19T14:18:44Z | TheCarsiBesiktas1903 | The New Video from LMFAO | ["Music", "Dance music", "Exciting music"] | ["house", "disco music", "no singer", "electronic", "synth", "turntable", "electronic drums", "energetic", "dance", "upbeat", "club music"] | 9 | 9PMoI31ncIs | 1001 | |
London Music Submarine: Ben See - Moment.Sound.Blur. | This is a live recording of an instrumental electronic music beat. The rhythmic foundation of the beat consists of a simple medium tempo electronic drum beat. There are sounds coming from the background resembling a restaurant. It is a minimal-sounding groovy beat that is also danceable. With the removal of ambient sounds and a clean mix, this track could be used in the soundtrack of a TV show with an urban setting. | 2012-02-13T14:11:20Z | LondonMusicSubmarine | London musician/vocalist Ben See performs an intimate collection of songs for the LMS Showcase. A small crowd gathers in a warm room in North London. Here are some snippets from Moment.Sound.Blur. All rights owned by London Music Submarine & Ben See © 2012 | ["Music", "Exciting music"] | ["live performance", "instrumental", "electronic music", "electronic drum", "medium tempo", "groovy", "dance", "modern", "minimal", "ambient sounds"] | 9 | qwOLhVbuhpM | 4836 | |
Sound Of Music - Feel The Music (Axis Dub) | Techno or house music with a four on the floor kick pattern, off beat hi-hat pattern, synth chords with delay and a chopped vocal sample. It is mid-tempo and minimal for dancing. | 2009-12-06T03:13:34Z | RJJNY | 1992. http://www.discogs.com/release/115929 | ["Disco", "Music", "Soundtrack music", "Synthesizer", "Exciting music"] | ["techno", "house beat", "dance", "syncopated synth bass", "delay", "off beat hi-hat", "mid tempo", "chopped vocal sample", "synth chords", "four on the floor kick pattern"] | 8 | x6FbyqrK0g0 | 5303 |
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;