musiccaps_details (view)
2 rows where musiccaps_aspects contains "perky" and musiccaps_aspects contains "pop rock" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- buoyant 2
- perky · 2 ✖
- pop rock · 2 ✖
- punchy 2
- amplified piano 1
- animated 1
- backup vocals 1
- boomy bass lines 1
- bright bass lines 1
- bright vocals 1
- catchy 1
- classic rock 1
- club music 1
- dance music 1
- energetic 1
- energetic electric guitar harmony 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- foreign language introduction 1
- keyboard accompaniment 1
- male singer 1
- medium fast tempo 1
- punchy drumming 1
- rock 1
- shakers 1
- simple melody 1
- soft rock 1
- tambourine beats 1
- teen pop 1
- vibrant 1
- vigorous drumming 1
- vivacious 1
- youthful 1
- youthfull 1
musiccaps_names (array) 7 ✖
- Music 2
- Angry music 1
- Funk 1
- Ska 1
- Song 1
- Soul music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 | |
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;