musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance groove", musiccaps_aspects contains "energetic", musiccaps_aspects contains "passionate" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
Kai - Grind Low | A male rapper sings this exciting melody. The tempo is fast with a groovy bass line, grunge keyboard tones, strong drumming rhythm, various percussion hits and beeping tones. The song is pulsating and energetic. The audio quality is very poor. | 2008-03-06T13:46:34Z | kilickai | ["Music", "Rapping"] | ["male rapper", "poor audio quality", "beeping tones", "fast tempo", "people dancing", "retro rap hits", "tambourine percussions", "strong drumming rhythm", "percussive bass line", "story telling", "adrenaline rush", "passionate", "energetic", "excitement", "dance rhythm", "dance groove", "fats tempo", "poor audio quality", "rap hits", "grunge keyboard tones"] | 1 | 9STauy5DsC8 | 1009 | ||
spray paint can | The song is an instrumental. The song is medium tempo with a groovy bass line, techno drumming rhythm, keyboard synth string accompaniment and other percussive hits. The song is energetic and passionate. The song is a techno dance tune and has poor audio quality, | 2010-07-27T10:08:45Z | newfantachrome | http://www.newfantachrome.com Chrome Spray !!! Dear Customers, We never stop developing new ideas ! See our new Spray Chrome SOLUTION !!! VIDEO DEMONSTRATION (CLICK HERE) Call us for more info about this AMAZING application ! | ["Music", "Spray"] | ["techno dance music", "poor audio quality", "medium tempo", "poor audio quality", "groovy rhythm", "ad jingle", "hissing tones", "instrumental music", "keyboard synth harmony", "strong bass line", "techno drum rhythm", "hissing tones", "energetic", "emotional", "passionate", "dance groove", "tv advertisement sound track"] | 1 | AU1l1i0H0j0 | 1119 | |
Makossa & Megablast feat. Hubert Tubbs - Coming Home (Skwerl's Throbbing Jet Lag Mix) | The song is an instrumental. The tempo is medium with a strong bass line, steady drumming rhythm, triangle percussion, keyboard accompaniment and a male vocalist making guttural noises. The song is a modern techno pop dance tune. | 2014-04-24T20:48:17Z | Tajak | Artist: Makossa & Megablast feat. Hubert Tubbs (Skwerl remix) Single: Coming Home (2010) Label: G-Stone Recordings http://www.beatport.com/release/coming-home/285482 | ["Music of Africa", "Drum and bass", "House music", "Music", "Electronic dance music"] | ["techno dance music", "gasping vocals sounds", "trance music", "dance hits", "triangle percussions", "instrumental music", "dj", "live session", "thumping bas slime", "keyboard accompaniment", "youthful", "energetic", "exciting", "party all night", "dance groove", "madly in love sexy", "romantic", "passionate", "steady drumming rhythm"] | 1 | IMnh-TIyFuE | 1898 |
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;