musiccaps_details (view)
5 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "groovy bass line" and musiccaps_aspects contains "keyboard harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 87 ✖
- enthusiastic · 5 ✖
- groovy bass line · 5 ✖
- keyboard harmony · 5 ✖
- energetic 3
- fast tempo 3
- instrumental 3
- live performance 3
- people talking 3
- buoyant 2
- clapping 2
- people cheering 2
- punchy drumming 2
- rhythmic acoustic guitar 2
- rock and roll 2
- upbeat 2
- ambient background sounds 1
- brass band 1
- bright 1
- bright drumming 1
- bright trumpeting 1
- cheerful 1
- cheering 1
- crowd cheering 1
- crowd hooting 1
- dance groove 1
- dance hit 1
- dance music 1
- digital drum 1
- documentary 1
- emotional 1
- enthusiastic amplified guitar 1
- enthusiastic electric guitar harmony 1
- enthusiastic electronic guitar melody 1
- exciting 1
- female backup singers 1
- female singers 1
- gig 1
- groovy 1
- happy 1
- hard hitting drumming 1
- hard rock 1
- high spirited 1
- inferior audio quality 1
- intense 1
- intense electric guitar 1
- interview 1
- j-pop 1
- jarring 1
- jive 1
- k-pop 1
- keyboard accompaniment 1
- loud 1
- loud electric guitar feedback 1
- male vocalist 1
- male voices interaction 1
- men talking 1
- muddled audio 1
- muffled music 1
- party all night 1
- party song 1
- passionate 1
- poor audio quality 1
- pop 1
- pop dance hits 1
- pop divas 1
- pop hits 1
- pop love hits 1
- pop rock 1
- positive 1
- promotion 1
- pulsating 1
- retro rock 1
- review 1
- rock 1
- spirited 1
- steady drumming rhythm 1
- superimposed vocals 1
- synthesiser 1
- synthesiser arrangements 1
- upbeat music 1
- vibrant 1
- vigorous vivacious 1
- vocal backup 1
- vocal harmony 1
- whistling tones 1
- wind instruments 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 5
- Roll 2
- Field recording 1
- Inside, large room or hall 1
- Jazz 1
- Music of Asia 1
- Musical instrument 1
- Rock and roll 1
- Rock music 1
- Singing 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
2NE1_0721_SBS Inkigayo_FALLING IN LOVE_No.1 of the Week | A female singer sings this cool pop melody with backup singers in vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, and keyboard accompaniment . The song is exciting and youthful. The audio quality with a lot of ambient crowd noises. | 2013-07-21T08:52:26Z | 2NE1 | Copyrightⓒ2013 SBS Contents Hub Co.,Ltd. & YG Entertainment Inc. All rights reserved. 2NE1 NEW SINGLE [FALLING IN LOVE] ▶ iTunes: http://smarturl.it/2NE1FallingInLove ▶ eBay: http://stores.ebay.com/YG-Entertainment ▶ YG-eshop: http://www.ygeshop.com ▶ YG-eshop (China): http://cn.ygeshop.com "Double Park TV" : http://smarturl.it/DoubleParkTV For More Information @ http://www.facebook.com/2ne1 http://twitter.com/ygent_official http://twitter.com/globalblackjack http://me2day.net/ygonair http://www.yg-2ne1.com App Store: http://goo.gl/l9TU6 Google Play: http://goo.gl/UiEn1 | ["Music of Asia", "Music"] | ["k-pop", "j-pop", "female singers", "female backup singers", "pop love hits", "pop dance hits", "whistling tones", "live performance", "vocal harmony", "groovy bass line", "steady drumming rhythm", "keyboard harmony", "emotional", "exciting", "enthusiastic", "passionate", "party song", "dance hit", "pop hits", "pop divas", "party all night", "people cheering", "groovy"] | 1 | 1xhwyUVSRQk | 318 | |
The Sounds - Diana | This song is a hard rock instrumental. The tempo is fast with bright electric guitars playing lead, steady bass line, punchy drumming and upbeat keyboard harmony The music is energetic, upbeat, youthful, engaging, buoyant, peppy, and groovy.it is a crowd pleaser ,as clapping, cheering , chatter and hooting can be heard in the background. | 2011-01-24T20:11:57Z | katrin3417 | The Sounds am 21. Januar 2011 bei der Snowhite Music Night im Postbahnhof in Berlin | ["Music", "Field recording"] | ["loud electric guitar feedback", "punchy drumming", "keyboard accompaniment", "keyboard harmony", "groovy bass line", "instrumental", "hard rock", "enthusiastic amplified guitar", "muddled audio", "crowd cheering", "crowd hooting", "people talking", "clapping", "live performance", "gig", "synthesiser", "enthusiastic", "spirited", "energetic", "youthful", "buoyant", "intense"] | 7 | 3dUo62RsD00 | 489 | |
Puerto Vallarta Jazz Music Restaurant | This music is instrumental. The tempo is fast with an upbeat keyboard harmony, bright drumming, energetic electric guitar and synthesiser and digital drum arrangements. There is an interaction between two men superimposed over the music. The music is lively, cheerful, happy, positive, upbeat, warm and heartening. This is the background score for an Interview or documentary. | 2013-11-01T04:27:06Z | Puerto Vallarta Mexico | https://toursinvallarta.com/ Puerto Vallarta Jazz Music Restaurant. The Smooth Jazz Cruise: The Greatest Party at Sea Puerto Vallarta. As the perennially sold-out sailings of The Smooth Jazz Cruise: The Greatest Party at Sea prepares to launch its 10th anniversary excursions in January 2013, parent company Entertainment Cruise Productions is determined to keep the party going strong by creating a West Coast outing from San Diego to exotic Mexican ports in the fall of 2013 with music hosts Brian Culbertson and Boney James. Grammy winners David Sanborn and Marcus Miller will perform on the new program and continue to serve as the music hosts of the traditional January sailing of The Smooth Jazz Cruise in 2014 that will embark from Fort Lauderdale to Caribbean paradise as it has done for a decade. Both 7-day cruises will be held aboard a luxurious Holland America ship and feature performances by legends, hitmakers and fan favorites. "As we enter the second decade of The Smooth Jazz Cruise, we want to keep things fresh for our loyal family of cruisers that comes back year after year. Thanks in part to their suggestions, we decided to spread the love by creating a sensational West Coast cruise. With a cruise on both coasts, we feel that the hosts should reflect the different personalities of each coast. I cannot imagine a more exciting cruise menu than Brian Culbertson and Boney James hosting a West Coast cruise and David Sanborn and Marcus Miller topping an East Coast cruise. Brian, Boney, David and Marcus will perform on both cruises as will Jonathan Butler and Candy Dulfer. We're going to showcase 22 incredible headliners between the two cruises," said Michael Lazaroff, Executive Director of St. Louis-based Entertainment Cruise Productions. The first-ever left coast departure for The Smooth Jazz Cruise, the West Coast expedition will make its maiden voyage on the m/s Westerdam October 12-19, 2013 from San Diego and visit Cabo San Lucas, Puerto Vallarta and Baja Coast. Joining Culbertson, James, Sanborn, Miller,… | ["Jazz", "Music", "Speech"] | ["instrumental", "fast tempo", "upbeat music", "review", "men talking", "interview", "documentary", "promotion", "keyboard harmony", "bright drumming", "enthusiastic electric guitar harmony", "groovy bass line", "digital drum", "synthesiser arrangements", "male voices interaction", "superimposed vocals", "upbeat", "enthusiastic", "cheerful", "positive", "vibrant", "happy"] | 7 | 3ujGrObyefA | 518 | |
Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 |
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;