musiccaps_details (view)
3 rows where musiccaps_aspects contains "soft rock" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- soft rock · 3 ✖
- buoyant 2
- rock 2
- alternative rock 1
- amplified piano 1
- boomy bass lines 1
- bright electric guitar 1
- catchy 1
- classic rock 1
- emotional 1
- energetic 1
- energetic drumming 1
- engaging 1
- enthusiastic vocals 1
- fast tempo 1
- female vocalist 1
- groovy bass lines 1
- keyboard accompaniment 1
- love song 1
- male singer 1
- male vocalist 1
- medium fast tempo 1
- melodious acoustic guitar rhythm 1
- passionate 1
- perky 1
- pleasant 1
- pop hit 1
- pop rock 1
- powerful 1
- progressive rock 1
- punchy 1
- punchy drumming 1
- shakers 1
- simple melody 1
- slick drumming 1
- symphonic rock 1
- synthesiser articulation 1
- tambourine beats 1
- teen pop 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
- youthful 1
- youthfull 1
- youtube video 1
musiccaps_names (array) 13 ✖
- Music 3
- Song · 3 ✖
- Independent music 2
- Funk 1
- Heavy metal 1
- Pop music 1
- Progressive rock 1
- Punk rock 1
- Rock music 1
- Singing 1
- Ska 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Pig Rock - อ่าง (SD Version) | A male singer sings this melodic pop song. The tempo is fast with an acoustic guitar accompaniment, keyboard harmony, enthusiastic electric guitar melody and intense drumming. The vocals are emphatic and the song is pleasant, catchy, melodious, youthful, buoyant and fresh. This song is Soft Rock/ Pop. | 2010-02-07T21:32:43Z | PigRockBand | PIG ROCK - Arng : The first official music video of new Thais rock band named PIG ROCK. Their first album will be launched in March, 2010. For more info please visit www.sabarnrecords.com Music Video Director / Cinematographer : Sornpat Prakaranunt | ["Music", "Punk rock", "Independent music", "Song"] | ["male vocalist", "bright electric guitar", "buoyant", "soft rock", "teen pop", "pop hit", "youtube video", "melodious acoustic guitar rhythm", "keyboard accompaniment", "pleasant", "teen pop", "love song", "passionate", "emotional", "enthusiastic vocals", "energetic drumming"] | 7 | QutCXtWmzIs | 2649 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;