musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_names contains "Song"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 5 ✖
- passionate · 5 ✖
- low quality 3
- live performance 2
- punchy kick 2
- acoustic rhythm guitar 1
- arpeggiated electric guitar solo melody 1
- average audio quality 1
- bright electric guitar 1
- buoyant 1
- claps 1
- compilation 1
- echoing female vocal 1
- electric guitar melody 1
- energetic drumming 1
- enthusiastic vocals 1
- fast guitar strumming 1
- fast tempo 1
- flamenco guitar 1
- flat female vocal 1
- folk music 1
- folk singer 1
- groovy bass guitar 1
- groovy music 1
- groovy tempo 1
- guitar accompaniment 1
- indie folk 1
- keyboard accompaniment 1
- latin singer 1
- lead female vocal 1
- …
musiccaps_names (array) 14 ✖
- Music 5
- Song · 5 ✖
- Independent music 2
- Singing 2
- Acoustic guitar 1
- Christmas music 1
- Flamenco 1
- Folk music 1
- Gospel music 1
- Plucked string instrument 1
- Punk rock 1
- Strum 1
- Vocal music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Flamenco en la calle. Cáceres | A male singer sings this spirited Latin vocal. The song is fast tempo with slick guitar strumming and percussive guitar accompaniment. The song is romantic and steeped in rich Latin classical music traditions. The song is about a Latin street musician playing folk music. The recording is of average quality. | 2016-01-22T12:08:16Z | Antonio Lara Arco | En pleno casco antiguo de la ciudad... | ["Singing", "Flamenco", "Music", "Song", "Vocal music"] | ["male singer", "latin singer", "average audio quality", "fast tempo", "groovy tempo", "fast guitar strumming", "guitar accompaniment", "groovy music", "romantic", "emotional", "passionate", "spirited", "passionate singing", "spirited singing", "flamenco guitar", "live performance", "street musician", "passionate music", "traditional latin music", "folk singer", "folk music"] | 1 | Bx726MYz6Uo | 1306 | |
Demi lovato head voice and whistle register | The low quality recording features a compilation of pop songs. The first song features an echoing female vocal sining, alongside wide harmonizing female vocals, over arpeggiated solo electric guitar melody, sustained strings progression, smooth bass, soft kick hits, punchy snare, simple hi hats and shimmering open hat. At the very end of the loop, there is a short snippet of the second song that consists of flat female vocals singing over claps, synth keys melody and punchy kick. It sounds emotional and passionate, even though the mix is bad. | 2014-03-08T13:11:42Z | Richard Cross | Demi lovato head voice whistle register and exclamations. The last one is an F7 not an F8. Follow me on Twitter @Richardtcross | ["Singing", "Music", "Song", "Zing"] | ["low quality", "pop", "echoing female vocal", "punchy snare", "shimmering open hat", "simple hi hats", "wide harmonizing female vocals", "smooth bass", "arpeggiated electric guitar solo melody", "sustained strings progression", "soft kick", "compilation", "claps", "punchy kick", "flat female vocal", "synth keys melody", "emotional", "passionate", "uplifting"] | 4 | GHQlBD-6rkA | 1707 | |
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 | |
Chiquilla. Interpretacion GRUPO FREE SOUNDS de Ensenada, BC | The low quality recording features a live performance of a regional Mexican song and it consists of passionate male vocal singing over groovy bass guitar, mellow synth keys melody and electric guitar melody, followed by shimmering tambourine, hi hats and punchy kick. It sounds passionate, emotional and soulful - like something you would hear at family gathering events. | 2012-04-20T18:44:22Z | victor lopez | PRESENTACION EN EL PROGRAMA LA VELADA DE SINTESIS TELEVISION TIJUANA (DERECHOS RESERVADOS) DEL GRUPO MUSICAL FREE SOUNDS DE ENSENADA, BC | ["Christmas music", "Gospel music", "Music", "Song"] | ["low quality", "live performance", "regional mexican", "passionate male vocal", "groovy bass guitar", "soft synth keys melody", "shimmering tambourine", "punchy kick", "electric guitar melody", "noisy", "passionate", "emotional", "soulful", "shimmering hi hats"] | 4 | RNwiEsjrhiQ | 2694 | |
Top 30 Indie Folk and Acoustic (Playlist #5) | The low quality recording features an indie folk song that consists of wide harmonizing male vocals and acoustic rhythm guitar. In the second half of the loop, the lead female vocal appears, creating a perfect harmony with the previously mentioned male vocals. It sounds passionate, emotional and sad. | 2014-02-28T23:48:23Z | Indie & Folky Me | Indie Folk Playlist of march 2014 by the Indie and Folky Me Team Website: http://IndieFolkyMe.tk Follow us on twitter : @IndieFolkyMe Join us on facebook : https://www.facebook.com/IndieFolkyMe Photo by Antsa Rvl (Fickr) : http://www.flickr.com/people/10663187... Go here to watch the EXCLUSIVE Top 20 Indie Pop Charts : http://t.co/Isqtvo2FQ5 TRACKLIST Fall At Your Feet - Boy & Bear Just For Now - Cloud Control Where We Gonna Go From Here - Mat Kearney More Than Life - Whitley Message - Xavier Rudd Big Black Car - Gregory Alan Isakov Wolves - The Accidental Something Better - Ecclectic Approach Horses - The Be Good Tanyas Follow Fires - Matthew & The Atlas Move mountains - Roo Panes Without You - Keith Urban Night Bus - Lucy Rose David - Noah Gundersen The Romance Of Wolves - Roma Di Luna Send Me On My Way - Rusted Root Stereo Heart - Collin Mcloughlin Willow Tree March - THe Paper Kites Where Is My Mind - Tramped By Turtles Girl - Lovedrug Riverbanks - Charlie Simpson Sunday best - Augustana The Story I Heard - Blind Pilot Karen O - The Moon Song People - Sharon Nutzati Hidden Edelweiss - Spark Alaska Always Remember Me - Ry Cuming ft Sara Bareilles Worry - Rhodes Rosemary - Ghost & Gale Sons & Daughters - Allman Brown ft Liz Lawrence Bonus: I Lived - One Republic * Copyright Disclaimer * Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Folk music", "Acoustic guitar", "Music", "Independent music", "Song", "Strum", "Plucked string instrument"] | ["low quality", "wide harmonizing male vocals", "indie folk", "acoustic rhythm guitar", "lead female vocal", "passionate", "emotional", "sad"] | 4 | hTlIqICkbW8 | 4110 |
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;