musiccaps_details (view)
2 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "dance floor" and musiccaps_aspects contains "groovy bass line"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Spliff Boy (N.B.T. Sound System) -Still In Da Place- (Trust In Records 01) | The song is an instrumental. The song is medium tempo with a steady drumming rhythm, cymbal crashes, groovy bass line and various percussion hits. The song is youthful and energetic. The song has an average audio quality. | 2013-03-24T22:46:29Z | KireKet | track A1 taken from N.B.T. Sound System "Trust In Records 01" (2009)...enJOY!!! | ["Sampler", "Drum and bass", "Music", "Drum machine", "Electronica"] | ["instrumental music", "techno dance music", "underground music", "cheerful", "teenagers dancing", "retro dance", "cymbal crashes", "steady drumming rhythm", "instrumental music", "dj", "keyboard tones", "discotheque", "dance floor", "dance club", "dance all night", "party night", "groovy bass line", "keyboard accompaniment"] | 1 | 6cQjwXNY4sc | 772 | |
Despicable Me - Boogie Fever - The Sylvers | A male singer sings this cool melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, ethnic drumming rhythm, trumpets playing percussively and a keyboard harmony. The song is groovy and cheerful. The song is retro final pop song; | 2010-07-15T01:19:34Z | Duke Tran | I do not own the music or take any credit for this video. I am not claiming that it is mine nor taking any form of incentive. | ["Funk", "Music"] | ["male singers", "backup singers", "vocal harmony", "funk pop hits", "dance floor", "percussive hits", "medium tempo", "groovy bass line", "medium drumming rhythm", "trumpets playing percussively", "story telling", "love song", "brass band", "pop song", "female backup singers", "exciting", "cheerful", "enegetic", "retro pop hits", "dance music"] | 1 | SSO7F_Ex0s4 | 2767 |
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;