musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "medium tempo" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 79 ✖
- female vocalist · 5 ✖
- medium tempo · 5 ✖
- mellow 4
- pleasant 2
- pop 2
- regional pop 2
- rhythmic acoustic guitar 2
- romantic 2
- slick drumming 2
- soft 2
- soothing 2
- acoustic guita 1
- acoustic guitar 1
- ambient 1
- asian music 1
- auto harp 1
- banjo 1
- birds chirping 1
- cello 1
- country pop 1
- country song 1
- dance groove 1
- disco pop 1
- dobro 1
- dulcet 1
- engaging 1
- enthusiastic drumming 1
- fiddle 1
- first love 1
- flute 1
- folk song 1
- foreign language 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- groovy electric guitar 1
- hopeful 1
- keyboard accompaniment 1
- latin music 1
- latin song 1
- love song 1
- mandolin 1
- melancholic 1
- mellifluous 1
- melodic 1
- melodic acoustic guitar 1
- melodic violin harmony 1
- melodious harmony 1
- multi genre soundscape 1
- mystic vibe 1
- no lyrics 1
- no percussions 1
- nostalgic 1
- pandeireta rhythm 1
- pensive 1
- perky 1
- piano accompaniment 1
- pop rap 1
- reggae 1
- regional music 1
- resonator 1
- romantic pop 1
- sentimental 1
- simple beat 1
- smooth 1
- soft pop 1
- soundtrack 1
- spanish guitar harmony 1
- spanish song 1
- steel pan 1
- story telling 1
- string harmony 1
- subtle bass line 1
- synthesiser arrangements 1
- vocal backup 1
- vocal emphasis 1
- vocalisation 1
- world music 1
- young love 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Las Chuches - Amor, amor, amor | A female vocalist sings this romantic song in a foreign language that sounds like Spanish. The tempo is medium with a melodious guitar accompaniment, slick drumming, piano accompaniment, steady bass line and pandeireta rhythm. The song is soft, mellow, catchy, emotional and soothing. This song is a Folk Pop/Regional Pop song. | 2008-07-21T00:44:11Z | Faico90 | Las chuches como siempre derroxando arte | ["Flamenco", "Music", "Music of Latin America"] | ["female vocalist", "medium tempo", "regional pop", "regional music", "folk song", "spanish song", "latin song", "spanish guitar harmony", "groovy bass lines", "slick drumming", "latin music", "piano accompaniment", "pandeireta rhythm", "romantic", "mellifluous", "soothing", "mellow", "world music", "regional music", "dance groove", "vocal backup", "mystic vibe"] | 7 | 7_q36NyJtQY | 863 | |
Kiss - Because I'm A Girl (Chinese Version) | A female vocalist sings this soft love song in a foreign language. The tempo is medium with a mellifluous violin harmony, keyboard accompaniment, subtle bass, steady drumming and rhythmic acoustic guitar. The song is sweet, youthful, simple, romantic, sentimental, melancholic and pensive. This song is Romantic Pop. | 2007-03-17T01:24:14Z | Joel Lee | Comments and Rating Plz.. | ["Music", "Tender music"] | ["female vocalist", "medium tempo", "foreign language", "romantic pop", "soft pop", "subtle bass line", "asian music", "soundtrack", "melodic violin harmony", "keyboard accompaniment", "flute", "romantic", "love song", "young love", "first love", "sentimental", "nostalgic", "pensive", "melancholic", "rhythmic acoustic guitar"] | 7 | FGoDfNZezh0 | 1632 | |
Front Country - "Sake of the Sound" // The Bluegrass Situation | A female vocalist sings this sweet melody. It is medium tempo with rhythmic accompaniment of acoustic guitar, mandolin, resonator, dobro, banjo, cello, fiddle and auto harp. The song is soft, soothing, pleasant, dulcet, sentimental, emotional and simple. This song is Country Pop. | 2014-09-16T20:55:03Z | The Bluegrass Situation [ BGS ] | Our friends at Mason Jar Music somehow convinced San Francisco's Front Country to pile into a van after sunset and play the title track off their new record in the middle of a secluded aspen grove. The Bluegrass Situation: http://www.thebluegrasssituation.com/ Mason Jar Music: http://www.masonjarmusic.com/ Front Country's new album 'Sake of the Sound' is available now: http://frontcountry.bandcamp.com/ Subscribe: http://www.youtube.com/subscription_center?add_user=TheBGSitch Discover more: https://www.facebook.com/TheBluegrassSituation https://twitter.com/TheBGSituation https://www.instagram.com/thebluegrasssituation/ http://www.thebluegrasssituation.com/ | ["Country", "Music"] | ["female vocalist", "medium tempo", "cello", "melodious harmony", "no percussions", "vocal emphasis", "banjo", "mellow", "string harmony", "dulcet", "soft", "pleasant", "story telling", "country pop", "country song", "regional pop", "resonator", "fiddle", "mandolin", "auto harp", "dobro", "acoustic guitar", "no percussions", "vocal emphasis", "dulcet"] | 7 | WSaCGNkM6_k | 3096 | |
Marla Brown - Better Days [Official Video 2015] | A female vocalist sings this pleasant pop song. The tempo is medium with a keyboard harmony, melodious acoustic guitar harmony, bright drumming , steel pan and the sound of birds chirping. The song is mellow, soft, pleasant, soothing, hopeful, sentimental, sweet and cheerful.this song is a Reggae Pop. | 2015-04-07T15:16:07Z | Reggaeville | ⏩ SUBSCRIBE http://bit.ly/yt-reggaeville 🔔 GET NOTIFIED about new videos! ✅ Log on https://www.REGGAEVILLE.com 🅵🅱 https://www.fb.com/reggaeville 🅸🅶 https://www.instagram.com/reggaeville 🆃🆃 https://www.tiktok.com/@reggaeville Marla Brown - Better Days [Royal Order Music] SINGLE OUT April 14th 2015 BUY @ https://itunes.apple.com/album/better-days-single/id978513329 Produced by: Royal Order Music and Green Stone Music Video Director and Editor: Dennis Brown/Visually Sound Media Production © #MarlaBrown #Reggaeville #Reggae | ["Bird vocalization, bird call, bird song", "Music", "Reggae", "Chirp, tweet", "Outside, rural or natural"] | ["female vocalist", "medium tempo", "birds chirping", "melodic acoustic guitar", "steel pan", "enthusiastic drumming", "synthesiser arrangements", "soft", "mellow", "pleasant", "hopeful", "pop", "pop rap", "disco pop", "reggae", "multi genre soundscape", "soothing"] | 7 | ZPK1hSPI540 | 3374 | |
Fatoumata Diawara - Mandela - Blackberrys Sharp Nights:Masters of World Music (New Delhi) | This song is a vocalisation by a female singer. The tempo is medium with an upbeat electronic guitar harmony, funky bass guitar, slick drumming and acoustic guitar accompaniment. The music is simple, engaging, pleasant, melodic, engaging and has a perky groove. | 2015-02-27T17:32:18Z | Blackberrys Menswear | Fatoumata Diawara paying tribute to the late great Nelson Mandela with her hit track 'Mandela', at Blackberrys Sharp Nights:Masters of World Music. #MOWM 'The Hendrix of The Sahara' Vieux Farka Toure; performing 'Ai Du' as part of the Blackberrys Sharp Nights: Masters of World Music tour. Live at Tote on The Turf, Mumbai. #MOWM For more, visit: http://facebook.com/BlackberrysMenswear http://twitter.com/BlackberrysMens | ["Electric guitar", "Music", "Song", "/t/dd00032"] | ["female vocalist", "vocalisation", "groovy", "perky", "no lyrics", "medium tempo", "groovy electric guitar", "funky bass line", "rhythmic acoustic guitar", "mellow", "melodic", "engaging", "slick drumming", "pop", "no lyrics", "simple beat", "ambient", "smooth", "acoustic guita"] | 7 | c9tRbWSk7c4 | 3685 |
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;