musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "synthesiser arrangements" and musiccaps_aspects contains "techno music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- buoyant 2
- club music 2
- dance pop 2
- electronic music · 2 ✖
- fast tempo 2
- synthesiser arrangements · 2 ✖
- techno music · 2 ✖
- youthful 2
- dance groove 1
- dance music 1
- deep house 1
- digital drumming 1
- digital drums 1
- digital music 1
- dj 1
- duet 1
- edm 1
- electronica 1
- fast beats 1
- female singer 1
- lively 1
- lively singing 1
- male vocalists 1
- pulsating 1
- punchy 1
- shakers 1
- slick drumming 1
- spirited 1
musiccaps_names (array) 4 ✖
- Music 2
- Electronic music 1
- Electronica 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | This song is a lively duet by two male voices. The tempo is fast with amplified piano, infectious drumming; tambourine beats and synthesiser arrangements. The song is youthful,fun, happy, groovy, energetic, buoyant, and high spirited. This song is called Deep House. | 2012-12-31T17:35:29Z | Theboxen21 | Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | ["Music", "Ska"] | ["male vocalists", "duet", "fast tempo", "electronic music", "spirited", "buoyant", "club music", "dance music", "dance pop", "techno music", "digital music", "synthesiser arrangements", "deep house", "lively", "youthful", "shakers", "digital drums", "lively singing"] | 7 | 6-MdbipzKS0 | 712 | |
¿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;