musiccaps_details (view)
2 rows where musiccaps_names contains "Funk", musiccaps_names contains "Ska" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- 4 on the floor kick 1
- amplified piano 1
- boomy bass lines 1
- buoyant 1
- catchy 1
- energetic 1
- flat male vocal 1
- funky guitar chords 1
- groovy bass 1
- groovy piano melody 1
- low quality 1
- male singer 1
- medium fast tempo 1
- melodic background male vocals 1
- mono 1
- northern soul 1
- nostalgic 1
- perky 1
- pop rock 1
- punchy 1
- punchy drumming 1
- rock 1
- sentimental 1
- shakers 1
- shimmering open hats 1
- simple melody 1
- soft rock 1
- tambourine beats 1
- vintage 1
- warm 1
- youthfull 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dooley Silverspoon - Game Players : Northern Soul | The low quality recording features a northern soul song that consists of flat male vocals, alongside melodic male background vocals, singing over funky guitar chords, groovy piano chords, groovy bass, "4 on the floor" kick pattern and shimmering open hats. It is noisy and in mono and therefore vintage, but it also sounds warm, nostalgic and sentimental. | 2013-05-03T20:08:03Z | Mike Patterson | Dooley Silverspoon - Game Players : Northern Soul, with some Northern Soul Video Clips | ["Funk", "Music", "Ska", "Soul music"] | ["low quality", "vintage", "northern soul", "groovy bass", "groovy piano melody", "funky guitar chords", "shimmering open hats", "4 on the floor kick", "flat male vocal", "melodic background male vocals", "mono", "warm", "nostalgic", "sentimental"] | 4 | EUNTykrvpok | 1563 | |
WHITE STRIPES - My Doorbell | A male vocalist sings this perky pop song. His tempo is medium fast with punchy drumming; animated amplified piano accompaniment, tambourine beats and funky bass lines. The song is simple, peppy, engaging, energetic, story telling, and catchy. This song is Classic Pop/ Soft Rock. | 2013-05-04T13:12:45Z | Jurassic56 | "My Doorbell" by the American alternative rock band The White Stripes is the second single from their album Get Behind Me Satan (2005). The song garnered The White Stripes a 2006 Grammy nomination for Best Pop Performance by a Duo or Group with Vocals. The White Stripes were an American rock duo, formed in 1997 in Detroit, Michigan. The group consisted of drummer Meg White (drums and occasional vocals) and songwriter Jack White (vocals, guitar, and keyboards). Meg and Jack White were previously married to each other, but are now divorced. After releasing several singles and three albums within the Detroit music scene, the White Stripes rose to prominence in 2002, as part of the garage rock revival scene. Their successful and critically acclaimed albums White Blood Cells and Elephant drew them attention from a large variety of media outlets in the United States and the United Kingdom, with the single "Seven Nation Army" and its now-iconic guitar riff becoming a huge hit. The band recorded a further two albums, Get Behind Me Satan in 2005 and Icky Thump in 2007. The group was dissolved in 2011 after a lengthy hiatus from performing and recording. The White Stripes used a low-fidelity approach to writing and recording. Their music featured a melding of garage rock and blues influences and a raw simplicity of composition, arrangement, and performance. The duo was also noted for their fashion and design aesthetic which featured an exclusive use of a simple color scheme of red, white, and black, which was used on every album and single cover the band released- as well as the band's obsession with the number three. The band's discography consists of six studio albums, one live album, two extended plays (EP), one concert film, one tour documentary, twenty-six singles, and fourteen music videos. Their last three albums each won the Grammy Award for Best Alternative Music Album. LYRICS: I'm thinkin' about my doorbell When ya gonna ring it, when ya gonna ring it Yeah, I'm thinkin' about my doorbell When … | ["Swing music", "Funk", "Music", "Ska", "Song", "Soul music"] | ["male singer", "medium fast tempo", "amplified piano", "tambourine beats", "punchy drumming", "boomy bass lines", "buoyant", "punchy", "perky", "energetic", "youthfull", "shakers", "simple melody", "catchy", "rock", "pop rock", "soft rock"] | 7 | MzUgHy7SyS8 | 2314 |
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;