musiccaps_details (view)
1 row where musiccaps_aspects contains "digital drumming", musiccaps_aspects contains "fast beats", musiccaps_aspects contains "slick drumming" and musiccaps_names contains "Electronica"
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 |
---|---|---|---|---|---|---|---|---|---|---|
¿CUAL DE ESTAS CANCIONES TE INICIO EN LA MÚSICA ELECTRÓNICA? | A female vocalist sings this upbeat electronic pop song. The tempo is fast with enthusiastic synthesiser arrangements, groovy drumming. The music is electronically arranged and has a youthful, vivacious, enthusiastic, buoyant dance groove. This music is upbeat Electronic Dance music. | 2016-11-15T22:53:12Z | Most Viewed | ----------------------------------------------------------------------------------------------------- ACÉPTALO UNA DE ESTAS CANCIONES TE INICIO EN LA MÚSICA ELECTRÓNICA. COMENTA QUE CANCIÓN NO OLVIDES DAR LIKE Y SI ERES NUEVO SUSCRIBETE SALUDOS!! ----------------------------------------------------------------------------------------------- TEMAS: 0:12 Mauro Picotto - Komodo 0:26 Darude - Sandstorm 0:40 call on me -eric prydz 0:52 Benny Benassi - Satisfaction 1:06 Alice Deejay - Better Off Alone 1:21 Lasgo - Something 1:34 Safri Duo - Played-A-Live 1:46 Gigi D'Agostino - L'Amour Toujours 1:58 Bellini - Samba De Janeiro 2:10 Paul van Dyk - For An Angel 2009 2:24 DJ Tiesto - Adagio For Strings 2:38 Tiesto - Traffic 2:53 ATB - 9PM (Till I Come) 3:09 Modjo - Lady (Hear Me Tonight) 3:22 DJ Visage Formula 1 3:36 Supermode - Tell Me Why 3:49 ATC - All Around The World (la la la la la la la la) 4:02 Benny Benassi - Illusion 4:18 Guru Josh Project - Infinity 4:31 Airplay - The Music is Moving 4:45 Eiffel 65 - Blue (Da Ba Dee) 5:00 Barthezz - On The Move 5:13 Mauro Picotto - Proximus 5:27 DJ Encore feat Engelina - I See Right Through To You 5:40 BBE - 7 days and one week 5:55 4 Strings - Take Me Away 6:08 Motorcycle - As The Rush Comes The Machinist 6:21 Miss Jane - Its a fine day ATB INTRO: 50 Cent - In Da Club (Naxsy & Rolf Dyman Remix) CANCION FINAL: Sak Noel & Salvi ft. Sean Paul - Trumpets SALUDOS SUSCRIPTORES!! ---------------------------------------------------------------------------------------- | ["Electronic music", "Music", "Electronica"] | ["female singer", "fast tempo", "electronic music", "punchy", "buoyant", "youthful", "dance groove", "pulsating", "edm", "techno music", "synthesiser arrangements", "slick drumming", "digital drumming", "fast beats", "punchy", "dance groove", "club music", "dj", "dance pop", "electronica"] | 7 | oTzTZqDOIt0 | 4635 |
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;