musiccaps_details (view)
4 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "perky" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 73 ✖
- male singer · 4 ✖
- perky · 4 ✖
- buoyant 3
- punchy 3
- catchy 2
- fast tempo 2
- peppy 2
- tambourine beats 2
- alternative hip-hop 1
- amplified piano 1
- animated piano 1
- bells 1
- boomy bass lines 1
- bouncy 1
- brass band 1
- catchy tune 1
- celebration 1
- children’s favourite christmas song 1
- children’s song 1
- choral harmony 1
- christmas carols 1
- christmas songs 1
- christmas tree 1
- club music 1
- congas 1
- dance groove 1
- dance music 1
- dance pop 1
- dj 1
- dj mixer 1
- energetic 1
- festivities 1
- fun 1
- funky 1
- funky bass lines 1
- funky keyboard harmony 1
- groovy 1
- hip-hop 1
- hip-hop hits 1
- infectious drumming 1
- interactive 1
- keyboard harmony 1
- lively backup vocals 1
- medium fast tempo 1
- medium fast tempo 1
- merry 1
- minimalist instrumentation 1
- nostalgia 1
- piano accompaniment 1
- pop rock 1
- presents 1
- punchy drumming 1
- r&b’simple melody 1
- rap 1
- reggae fusion 1
- reindeer 1
- rhythmic acoustic guitar 1
- rock 1
- santa claus 1
- shakers 1
- simple melody 1
- slick drumming 1
- snow 1
- soft rock 1
- soul 1
- steady bass line 1
- steady drumming 1
- tambourine 1
- upbeat 1
- vibrant trumpet harmony 1
- vocal backup 1
- vocalisation 1
- youthfull 1
musiccaps_names (array) 13 ✖
- Music 4
- Song 2
- Afrobeat 1
- Christian music 1
- Christmas music 1
- Exciting music 1
- Funk 1
- Music of Africa 1
- Rapping 1
- Reggae 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 | |
K'Naan ABC's | Male vocalist sings this upbeat Hip-Hop song. The tempo is fast with minimal instrumentation of a lively infectious, punchy drumming and enthusiastic vocal backup and incessant, vigorous vocalisation. The song is buoyant, catchy, punchy, funky, youthful,groovy, engaging, vibrant and vivacious. This song is contemporary Hip-Hop/Rap. | 2009-01-23T20:28:16Z | K'naan Warsame | The new video for "ABC's" from K'NAAN's upcoming release "Troubador"; featuring Chubb Rock | ["Afrobeat", "Music of Africa", "Music", "Exciting music"] | ["male singer", "lively backup vocals", "alternative hip-hop", "reggae fusion", "interactive", "vocalisation", "fast tempo", "infectious drumming", "keyboard harmony", "hip-hop", "rap", "hip-hop hits", "minimalist instrumentation", "upbeat", "catchy", "buoyant", "punchy", "peppy", "perky", "dj", "dj mixer", "dance pop", "dance music", "dance groove", "club music", "groovy", "funky"] | 7 | Ovk5EfFj7Ws | 2482 | |
Jingle Bell Rock - Hall & Oates | A vocalist sings this cheerful Christmas carol. The tempo is medium with an animated piano accompaniment, steady drumming, cymbals, tambourine beats, steady bass line and rhythmic acoustic guitar and melodic backup vocals;. The song is happy, fun, festive, celebratory, wishful, peppy and nostalgic. This song is a Christmas Carol. | 2010-11-26T02:57:05Z | R2197 | "Jingle Bell Rock" cover by Daryl Hall and John Oates. I do not own this music. No copyright infringement intended. For entertainment purposes only. Courtesy of Daryl Hall and John Oates. From the updated 2006 album "Home for Christmas". Enjoy. Lyrics: Jingle bell, jingle bell, jingle bell rock Jingle bells swing and jingle bells ring Snowin' and blowin' up bushels of fun Now the jingle hop has begun Jingle bell, jingle bell, jingle bell rock Jingle bells chime in jingle bell time Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell rock Jingle bell, jingle bell, jingle bell rock (repeat verse1's Jingle bells chime in jingle bell time last 4 lines) Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell That's the jingle bell That's the jingle bell rock! | ["Christmas music", "Christian music", "Music", "Song"] | ["male singer", "medium fast tempo", "animated piano", "vocal backup", "bells", "tambourine beats", "steady drumming", "steady bass line", "choral harmony", "rhythmic acoustic guitar", "christmas songs", "christmas carols", "children’s song", "children’s favourite christmas song", "santa claus", "christmas tree", "presents", "snow", "reindeer", "fun", "celebration", "festivities", "merry", "perky", "peppy", "nostalgia"] | 7 | ZUcHBeueBww | 3382 | |
Auto Transport Vehicle Transport Car Transport Truck Motorcycle Transport Boat Transport Auto Transport Company Auto Haulers Auto Hauling Movers Moving Shipping Shipper Ship International National USA | A male vocalist sings this spirited song. The tempo is medium fast with enthusiastic trumpet, funky keyboard harmony, groovy bass lines, slick drumming and piano accompaniment. The song is simple,spirited, enthusiastic, energetic and buoyant. This song is an R&B/Soul. | 2009-01-19T09:30:27Z | carefreautotransport | Auto Transport Vehicle Transport Car Transport Truck Motorcycle Transport Boat Transport Auto Transport Company Auto Haulers Auto Hauling Movers Moving Shipping Shipper Ship International National USA Alabama AL Alaska AK American Samoa AS Arizona AZ Arkansas AR Armed Forces Africa AF Armed Forces Americas AA Armed Forces Canada AC Armed Forces Europe AE Armed Forces Middle East AM Armed Forces Pacific AP California CA Colorado CO Connecticut CT Delaware DE District of Columbia DC Federated States Of Micronesia FM Florida FL Georgia GA Guam GU Hawaii HI Idaho ID Illinois IL Indiana IN Iowa IA Kansas KS Kentucky KY Louisiana LA Maine ME Marshall Islands MH Maryland MD Massachusetts MA Michigan MI Minnesota MN Mississippi MS Missouri MO Montana MT Nebraska NE Nevada NV New Hampshire NH New Jersey NJ New Mexico NM New York NY North Carolina NC North Dakota ND Northern Mariana Islands MP Ohio OH Oklahoma OK Oregon OR Pennsylvania PA Puerto Rico PR Rhode Island RI South Carolina SC South Dakota SD Tennessee TN Texas TX Utah UT Vermont VT Virgin Islands VI Virginia VA Washington WA West Virginia WV Wisconsin WI Wyoming WY VEHICLE CATEGORIES Cars · Pick-Up Trucks · Oversized Vehicles Convertibles · Vans · Mini-Vans Classic Cars and Hot Rods · Motorcycles Non-Operating Vehicles and Salvage Cars Expedited Service Auto Transport Quality AUTO Transport Service Fully Insured Licensed and Bonded Nationwide Service Door-to-Door Service Affordable Rates Open and Enclosed Car Carriers Acura Audi BMW Buick Cadillac Chevrolet Chrysler Dodge Ford GMC Honda Hummer Infiniti Jeep Land Rover Lexus Lincoln Mazda Mitsubishi Mercedes-Benz Mercury Nissan Pontiac Porsche Toyota VW Volkswagen Transport Shipping Moving Delivery http://www.carefreeautotransport.com | ["Music", "Rapping", "Reggae"] | ["male singer", "fast tempo", "brass band", "funky keyboard harmony", "piano accompaniment", "vibrant trumpet harmony", "slick drumming", "funky bass lines", "tambourine", "congas", "punchy", "bouncy", "buoyant", "perky", "soul", "r&b’simple melody", "catchy tune"] | 7 | ltysCJWnvsI | 4429 |
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;