musiccaps_details (view)
3 rows where musiccaps_aspects contains "disco" and musiccaps_aspects contains "keyboard"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- disco · 3 ✖
- keyboard · 3 ✖
- acoustic drums 2
- danceable 2
- funk 2
- groovy 2
- melodic singing 2
- repeated theme 2
- synth bass 2
- bass guitar 1
- dance 1
- easygoing 1
- electric guitar 1
- electronic 1
- electronic drums 1
- female vocals 1
- female voice 1
- male vocal 1
- percussion 1
- pop 1
- sensual 1
- squeaking sound effects 1
musiccaps_names (array) 4 ✖
- Music 3
- /t/dd00032 1
- Funk 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
carmen - time to move | This is an electronic funk/disco music piece from the 80s. There is a female vocalist singing melodically. The repeated main theme is being played by the keyboard. There is a synth bass playing a groovy bass line. There is an acoustic drum beat in the rhythmic background. The atmosphere is sensual. This piece can be used in the soundtrack of a retro-themed movie. | 2007-06-24T11:49:19Z | REKEKEKE | Juste pour avoir la chanson ! | ["Funk", "Music"] | ["electronic", "funk", "disco", "female voice", "melodic singing", "keyboard", "repeated theme", "synth bass", "acoustic drums", "squeaking sound effects", "sensual", "danceable"] | 9 | 3rvqiSZB4pA | 509 | |
Michael Jackson - Off The Wall - Girlfriend | This is a funk/disco music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the keyboard with the backing of the electric guitar and the bass guitar. The rhythm is being played by the acoustic drums. The atmosphere is groovy. This piece could be played at a retro-themed party at a dance club. | 2008-12-20T19:44:15Z | Sccuderia | Sorry for the HUGE delay but youtube wouldn't let me log in...anyway...Enjoy! Lyrics: [1st Verse] Girlfriend I'm Gonna Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What You Do To Me Late At Night When The Wind Is Free [2nd Verse] Girlfriend I'm Gonna Show Your Boyfriend (Yeah) Show Him (Woo Hoo) The Letters I've Been Savin' (Yeah) Show Him How You Feel Inside An' How Love Could Not Be Denied (Oh No) [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine [3rd Verse] Girlfriend You Better Tell Your Boyfriend (Yeah) Tell Him (Woo Hoo) Exactly What We're Doin' (Yeah) Tell Him What He Needs To Know Or He May Never Let You Go [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do, [Etc.] [Chorus] We're Gonna Have To Tell Him You'll Only Be A Girlfriend Of Mine Do-Doot-Do.. [Ad-Lib To Fade] | ["Music", "Soul music"] | ["funk", "disco", "male vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "easygoing", "danceable"] | 9 | l6LUPlmua6I | 4375 | |
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 |
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;