musiccaps_details (view)
5 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "youthful" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 88 ✖
- enthusiastic · 5 ✖
- youthful · 5 ✖
- energetic 3
- acoustic guitar accompaniment 2
- clapping 2
- entertaining 2
- fast tempo 2
- female singer 2
- funky bass line 2
- girl band 2
- hard rock 2
- live performance 2
- lively 2
- male vocalist 2
- medium tempo 2
- punchy 2
- spirited 2
- acoustic 1
- alternative rock 1
- amateur home recording 1
- amateur recording 1
- ambient sounds 1
- amplified 1
- auto tune 1
- bass drum 1
- boisterous 1
- boomy 1
- bouncy 1
- bright drumming 1
- cheerful 1
- club music 1
- concert 1
- country rock 1
- country song 1
- crowd cheering 1
- crowd hooting 1
- cymbals 1
- dixie chicks concert 1
- electronic music 1
- emphatic vocals 1
- fans cheering 1
- female vocalists 1
- feminist 1
- folk 1
- fresh 1
- fresh punchy 1
- funky 1
- funky keyboard harmony 1
- gig 1
- girl metal band 1
- groovy electric guitar accompaniment 1
- happy 1
- hard hitting 1
- hard hitting drums 1
- heavy metal 1
- hysteria 1
- incoherent sound 1
- intense 1
- intense electric guitar feedback 1
- joyful 1
- keyboard harmony 1
- live audience 1
- loud feedback 1
- lucid vocals 1
- male vocal backup 1
- medium fast tempo 1
- metal 1
- party song 1
- people talking 1
- perky vocals 1
- pop 1
- popular song 1
- powerful 1
- psychedelic 1
- rock 1
- singing along 1
- slick drumming 1
- sound of chatter 1
- spanish guitar 1
- spanish song 1
- strong 1
- synthesiser articulation 1
- turn table 1
- upbeat groove 1
- vigorous 1
- vocal backup 1
- vocalisation 1
- world music 1
musiccaps_names (array) 10 ✖
- Music 5
- Singing · 5 ✖
- Bang 1
- Clapping 1
- Electronic music 1
- Groan 1
- Musical instrument 1
- Ska 1
- Soul music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
RapScallions - The Garage Sessions - "What Do Ya Say?" | A male vocalist sings this enthusiastic song. The tempo is fast with infectious drumming, groovy bass lines, funky electric guitar harmony and an energetic keyboard accompaniment with vocal backup. The song is energetic, high-spirited, youthful, infectious, pulsating and vigorous. This song is a popular Alternative Rock. | 2013-04-02T04:59:36Z | OfficialRapScallions | BUY THE NEW ALBUM "IN MY HEAD" on iTunes https://itunes.apple.com/us/album/in-my-head-ep/id611204088 The Garage Sessions #2: "What Do Ya Say?" Vocals: Sergio Ochoa Guitar: Dario Forzato Bass: Chris Clemence Drums: James Forsberg Video Director: Alessandro Casati RapScallions would like to thank their sponsors: D'Addario Strings, Planet Waves, Evans, Pro Mark, Warwick and Truth Custom Drums. | ["Singing", "Music", "Ska"] | ["male vocalist", "fast tempo", "male vocal backup", "cymbals", "bass drum", "bright drumming", "funky keyboard harmony", "groovy electric guitar accompaniment", "funky bass line", "youthful", "spirited", "enthusiastic", "energetic", "lively", "vigorous", "rock", "hard rock", "alternative rock"] | 7 | 5xBfKiQcMZQ | 707 | |
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
Dixie Chicks Taking the Long Way Live | A girl band sings this lively song. The tempo is medium with vibrant music. The audio quality is inferior so the music and vocals are incoherent. This is a live performance with ambient sounds of fans cheering, clapping and singing along. This song is a hit Country Rock. | 2006-08-02T22:04:41Z | Susanne Goldstone Rosenhouse | Live from Madison Square Garden. Natalie's introduction to New York fans then Taking the Long Way Live. Oh, and a little bit of me singing along and cheering. Didn't know my camera would pick that up. :) Hope y'all enjoy! | ["Singing", "Electronic music", "Music", "Bang"] | ["female vocalists", "medium tempo", "live performance", "country rock", "folk", "world music", "acoustic", "country song", "youthful", "enthusiastic", "energetic", "entertaining", "folk", "concert", "incoherent sound", "amateur recording", "live audience", "girl band", "dixie chicks concert", "ambient sounds", "fans cheering", "clapping", "hysteria"] | 7 | aGMdcxeF6Ak | 3524 | |
BABYMETAL - いいね!- Iine! (OFFICIAL) | A female vocalist sings this powerful Hard rock song. The tempo is medium fast with a vigorous electric guitar feedback, synthesiser articulation and electronic arrangement. The song is youthful, powerful, intense, boisterous, compelling, psychedelic, boomy , punchy and impactful. This song is a Hard Rock/heavy Metal song. | 2012-11-08T08:29:27Z | BABYMETAL | BABYMETAL 1st full album "BABYMETAL" available now!! Available on iTunes Store worldwide & CD web store. Don't miss it!! [iTunes Store] https://itunes.apple.com/us/artist/babymetal/id477101776 [CD web store ASMART] ●BABYMETAL - Limited edition(CD+DVD) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006479&vid http://www.youtube.com/watch?v=U9oRytBGwYM ●BABYMETAL - Regular edition(CD only) http://www.asmart.jp/Form/Product/ProductDetail.aspx?shop=0&cat=100131&swrd&pid=10006480&vid [CD web store CDJAPAN] http://www.cdjapan.co.jp/search3.html?q=babymetal&media&r=any&step=20&order=score ★ Official Site : http://www.babymetal.jp/ ★ Facebook : http://www.facebook.com/BABYMETAL.jp ★ Twitter : https://twitter.com/BABYMETAL_JAPAN 【Profile】 BABYMETAL【SU-METAL (Vocal,Dance) / MOAMETAL (Scream,Dance) / YUIMETAL (Scream,Dance) 】 Formed in 2010. Their major debut single “ Ijme, dame, zettai" along with 2nd single “Megistune" both ranked in the Top 10 Oricon chart in Japan. In March 2014, they took to the stage of Nippon Budokan for a 2-Days gig making them the youngest female act to ever perform there. Their 1st studio album BAYBMETAL made it into the US Billboard chart. In summer of the same year, they embarked on their first World Tour, performing on the Main Stage at UK’s prodigious festival Sonisphere Festival 2014 in front of 65,000 festival goers, and supporting Lady Gaga on her “ArtRave: The Artpop Ball” 2014 Tour. In fall they were back for additional headline shows in Hammerstein Ballroom, New York City and O2 Academy Brixton, London. In January 2015, they headlined a show at the 20,000 capacities Saitama Super Arena, and in June 2015, they headlined a show at the 25,000 capacities Makuhari Messe. In summer of 2015, BABYMETAL received awards from prominent UK music magazines “Kerrang!” and “METAL HAMMER”. They then performed in front of a staggering 90,000 people at the prestigious Reading and Leeds Festival in August. This December, BABYMETAL are to take the stage again fo… | ["Singing", "Music", "Groan"] | ["female singer", "medium fast tempo", "vocal backup", "loud feedback", "amplified", "boomy", "boisterous", "punchy", "hard hitting", "psychedelic", "synthesiser articulation", "hard rock", "metal", "vocalisation", "auto tune", "turn table", "intense electric guitar feedback", "hard hitting drums", "girl band", "heavy metal", "girl metal band", "enthusiastic", "intense", "powerful", "feminist", "strong", "electronic music", "youthful"] | 7 | qVdBBOpSoN4 | 4790 |
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;