musiccaps_details (view)
2 rows where musiccaps_aspects contains "techno dance music", musiccaps_aspects contains "youthful" and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- exciting 2
- medium tempo 2
- techno dance music · 2 ✖
- youthful · 2 ✖
- arabic electronic music 1
- arabic pop 1
- bad audio quality 1
- dance club 1
- dance floor 1
- dance music 1
- dj 1
- electronic dance music 1
- enegetic 1
- enthusiastic 1
- fun cheerful 1
- groovy bas slime 1
- groovy bass line 1
- groovy dance rhythm 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- male backup singers 1
- male singer 1
- passionate 1
- people dancing 1
- percussion hits 1
- pulsating rhythm 1
- sonic effects 1
- steady drumming rhythm 1
- techno drumming rhythm 1
- trance dance music 1
- trance music 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Electronic music · 2 ✖
- Music 2
- Drum and bass 1
- Dubstep 1
- Electronic dance music 1
- House music 1
- Sampler 1
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 | |
Yalla Yalla Arabic House Music يَلا يَلا | A male singer sings Arabic vocals with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, percussive bass line, keyboard accompaniment and percussive hits. The song is an Arabic dance song. | 2009-07-14T19:44:28Z | Samuelinooo | Yalla Yalla .... With DJ Garphie feat KASRANI more from DJ Garphie http://www.traxsource.com/index.php?act=search&ss=dj+garphie&sc=artists&cf=all&gf=0 and http://soundcloud.com/djgarphie and http://www.facebook.com/pages/Dj-Garphie/70205312638 and http://www.facebook.com/pages/Think-House-Music-Deep-and-Soulful-house-music/178168948716 | ["Sampler", "Electronic music", "House music", "Music"] | ["techno dance music", "male singer", "male backup singers", "pulsating rhythm", "enegetic", "exciting", "youthful", "fun cheerful", "bad audio quality", "vocal harmony", "steady drumming rhythm", "groovy bass line", "steady drumming rhythm", "keyboard accompaniment", "dance music", "arabic electronic music", "arabic pop", "medium tempo"] | 1 | _8OIugVSFeE | 3446 |
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;