musiccaps_details (view)
2 rows where musiccaps_aspects contains "enthusiastic" and musiccaps_aspects contains "people dancing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- enthusiastic · 2 ✖
- medium tempo 2
- passionate 2
- people dancing · 2 ✖
- bachata 1
- bad quality audio 1
- dance club 1
- dance floor 1
- deteriorating audio quality 1
- dj 1
- electronic dance music 1
- emotional 1
- exciting 1
- groovy bas slime 1
- groovy bass line 1
- groovy dance hits 1
- groovy dance rhythm 1
- guitar lead 1
- keybiard accompaniment 1
- keyboard tones 1
- latin dance band 1
- latin dance hits 1
- latin dance music 1
- latin love hits 1
- latin percussions 1
- latin pop hits 1
- male latin singer 1
- percussion hits 1
- retro latin hits 1
- romantic 1
- sonic effects 1
- techno dance music 1
- techno drumming rhythm 1
- trance dance music 1
- trance music 1
- vocal echoes 1
- wedding music 1
- youthful 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mt Eden - Gambler | The song is an instrumental. The tempo is medium with a groovy drumming rhythm, percussive bass line, keyboard accompaniment and various percussive and sonic effects. The song is youthful and exciting with a trance element. The song is a modern tench pop dance tune. | 2010-12-02T12:18:30Z | Mt Eden Official | VIP version coming very soon FREE DOWNLOAD: Track 3 off our debut EP - "MEDS" Sample: (New Zealand) P-Money - Gamble. From the album "Big Things". Cover art by Craig Plant: craigplantartworks@hotmail.co.nz http://www.facebook.com/pages/Craig-Plant-Artworks/116296581769040?v=wall Support us!! Download and rate these tracks on itunes!! http://itunes.apple.com/nz/album/meds-ep-1/id409192438 OR Download the full EP for FREE here: http://www.mediafire.com/?itcp3vi40p7pmmw | ["Drum and bass", "Electronic music", "Music", "Dubstep", "Electronic dance music"] | ["techno dance music", "electronic dance music", "trance dance music", "medium tempo", "groovy bas slime", "techno drumming rhythm", "keybiard accompaniment", "percussion hits", "sonic effects", "dj", "dance floor", "dance club", "people dancing", "groovy dance rhythm", "trance music", "enthusiastic", "passionate", "youthful", "exciting"] | 1 | 66B46E_hrrk | 725 | |
BACHATA MIX AVENTURA | A male Latin singer sings this passionate melody. The song is medium tempo with various Latin percussions, groovy bass line, keyboard harmony and a guitar playing lead. The song is romantic and a classic Latin dance groove. The song is a Latin dance hit with a deteriorating audio quality. | 2009-01-05T07:54:32Z | R G COCINA | BACHATA | ["Music", "Salsa music"] | ["male latin singer", "bad quality audio", "latin dance band", "deteriorating audio quality", "groovy dance hits", "retro latin hits", "medium tempo", "bachata", "vocal echoes", "latin percussions", "guitar lead", "keyboard tones", "enthusiastic", "emotional", "passionate", "romantic", "retro latin hits", "latin pop hits", "people dancing", "passionate", "romantic", "groovy bass line", "latin love hits", "wedding music", "people dancing", "latin dance hits", "latin dance music"] | 1 | qsRPTMXFGsA | 4830 |
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;