musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussion" and musiccaps_aspects contains "pop" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- percussion · 2 ✖
- pop · 2 ✖
- autotuned vocals 1
- cumbia beat 1
- dance 1
- disco 1
- electronic drums 1
- female vocals 1
- friendly 1
- groovy 1
- hard panned vocals 1
- heavy vocal processing 1
- keyboard 1
- light 1
- repeated theme 1
- syncopated bass 1
- synth bass 1
- synth melody 1
- tropical electronic 1
- youthful 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00032 1
- Afrobeat 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lipps Inc. - Funkytown (lyrics) | This is a famous disco piece. There are female vocals singing the lyrics joyfully. The main tune is played in major scale by a keyboard while it is supported by a syncopated synth bass in the background. The rhythm is kept by a repetitive electronic drum beat accompanied by percussion. The atmosphere is groovy and danceable. It is perfect for an 80s themed party setlist. It could also be playing in the background of an 80s themed bar. | 2008-06-28T05:10:53Z | Pippygal44 | Lipps Inc. - funkytown with lyrics. | ["Music", "/t/dd00032"] | ["pop", "disco", "female vocals", "electronic drums", "percussion", "keyboard", "synth bass", "dance", "groovy", "repeated theme"] | 9 | liuCTk2nPG8 | 4418 | |
POWPOW MOVEMENT AND HEAVY HAMMER SOUND | A tropical feeling electronic pop track with heavily processed autotuned vocals hard panned left right and center. The cumbia beat, lots of percussion, synthesizer melody and a syncopated bass give the music a light, friendly, and youthful vibe; | 2016-07-26T14:00:52Z | Mamanera Beach | Chi sabato non c'era non può capire l'energia che Pow Pow Movement ha scatenato sulla spiaggia del Mamanera! Un potente ruggito reggae dalla Germania che è tornato a scuotervi dopo 5 anni di assenza! Ci vediamo sabato prossimo con Jugglerz! Who wasn't there can't possibly understand the energy that Pow Pow Movement unleashed at Mamanera beach! A mighty reggae roar from Germany which came back to shake your bodies after 5 long years! See you next saturday with Jugglerz! #mamanera #mamanera2016 #heavyhammersound #mamanerareggaeboombeach #powpowmovement #mlcomadv | ["Afrobeat", "Music"] | ["autotuned vocals", "hard panned vocals", "heavy vocal processing", "tropical electronic", "pop", "syncopated bass", "cumbia beat", "light", "friendly", "youthful", "percussion", "synth melody"] | 8 | nbYdiazwUQo | 4561 |
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;