musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "female vocalist" and musiccaps_aspects contains "pleasant" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 44 ✖
- female vocalist · 3 ✖
- mellow 3
- pleasant · 3 ✖
- soft 3
- dulcet 2
- medium tempo 2
- soothing 2
- accordion harmony 1
- acoustic guitar 1
- alto backup vocals 1
- auto harp 1
- banjo 1
- birds chirping 1
- cello 1
- country pop 1
- country song 1
- disco pop 1
- dobro 1
- enthusiastic drumming 1
- fiddle 1
- german folk song 1
- german song 1
- hopeful 1
- mandolin 1
- mellow acoustic guitar 1
- melodic acoustic guitar 1
- melodious 1
- melodious harmony 1
- multi genre soundscape 1
- no percussions 1
- peaceful 1
- pop 1
- pop rap 1
- reggae 1
- regional pop 1
- resonator 1
- soft elbow 1
- steel pan 1
- story telling 1
- string harmony 1
- swiss folk song 1
- synthesiser arrangements 1
- vocal backup 1
- vocal emphasis 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oesch's die Dritten - Ein Jodler für's Christkind 2012 | A female vocalist sings this soft melody. The song is slow tempo with accordion harmony and acoustic guitar accompaniment and alto vocal harmony. The song is mellow, soft, pleasant, dulcet, emotional, romantic and nostalgic. This song is a Swiss/German folk song. | 2012-12-25T03:35:04Z | fritz5109 | Oesch's die Dritten - Ein Jodler für's Christkind 2012 Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) Hundert Tage ist es Winter und es fällt der weisse Schnee leise höre ich die Glocken von der Kirche in der Näh'. Aller Trubel ist vergessen, endlich ist es nun soweit Frohe, frohe Weihnachtszeit. Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) | ["Christmas music", "Music"] | ["female vocalist", "vocal backup", "accordion harmony", "german folk song", "soft", "mellow", "melodious", "alto backup vocals", "swiss folk song", "german song", "soft elbow", "dulcet", "pleasant", "soothing", "peaceful", "mellow acoustic guitar"] | 7 | BXUS7pTYDzI | 1252 | |
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 |
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;