musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "happy" and musiccaps_aspects contains "mandolin" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 73 ✖
- happy · 4 ✖
- mandolin · 4 ✖
- spirited 3
- acoustic guitar 2
- auto harp 2
- cheerful 2
- country music 2
- enthusiastic 2
- fast tempo 2
- folk music 2
- lively 2
- youthful 2
- 8 stringed instrument 1
- acoustic drums 1
- acoustic guitar accompaniment 1
- amateur recording 1
- ambient noises 1
- animated 1
- banjo 1
- bluegrass 1
- bright 1
- catchy 1
- celebratory 1
- cheering 1
- chirpy 1
- clapping 1
- concert 1
- country folk music 1
- country pop 1
- country side 1
- cowboys 1
- dance music 1
- e-bass 1
- e-piano 1
- enthusiastic drumming 1
- female singer 1
- festive 1
- fiddle 1
- gig 1
- girl singing 1
- high notes 1
- higher key 1
- inferior audio quality 1
- instrumental 1
- keyboard harmony 1
- live performance 1
- lute family 1
- male vocalists 1
- male voice singing 1
- mandolin harmony 1
- march like beat 1
- medium tempo 1
- people clapping 1
- people talking 1
- peppy 1
- plucking 1
- pop 1
- powerful vocals 1
- powerfully voice 1
- regional music 1
- resonator 1
- sentimental 1
- soprano string instrument 1
- story telling 1
- string harmony 1
- stringed instruments 1
- sunny 1
- tambourine beats 1
- vibrant 1
- vigorous banjo 1
- vivacious 1
- vocal emphasis 1
- young vocalist 1
musiccaps_names (array) 12 ✖
- Music 4
- Acoustic guitar 1
- Banjo 1
- Bluegrass 1
- Country 1
- Independent music 1
- Mandolin 1
- Musical instrument 1
- Plucked string instrument 1
- Rock and roll 1
- Song 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cutie girl singing (11 years old) | A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. | 2006-07-16T08:08:14Z | Trofimo | El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... | ["Yodeling", "Music", "Song"] | ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] | 7 | hdlnugbWjKA | 4122 | |
Jason Mraz - Sleep All Day | This song contains an acoustic drum and an e-bass playing along to someone strumming chords on an acoustic guitar. Panned to the right side of the speaker you can hear a mandolin playing a melody in a higher register. An e-piano is playing chords that are panned to the left side of the speakers. A male voice is singing at a higher pitch. This song may be playing when feeling happy. | 2008-07-28T11:41:46Z | Izabella Bella | (Lyrics) Jason Mraz - Sleep All Day His after moan though cries oh no He's building up a shine but he take it slow And he knows it's time to make a change here and time to get away And he knows it's time for all the wrong reasons and time to end the pain But he sleep all, sleep all day, sleep all, we sleep all day over Why don't we sleep all, sleep all day, sleep all, we sleep all day over She said what would your mother think and how would your father react Would he take it all back what they've done No way they said take it, take it and he said make it with your own two hands That was my old man and he said If all is grounded you should go make a mountain out of it Oh what a lovely day to have a slice of humble pie Oh Recalling of the while we used to drive and drive here and there Going nowhere but for us, nowhere but the two of us And we knew it was time to take a chance here And time to compromise our lives just a little while And it was time for all the wrong and lonely, lonesome reasons But time is often on my side but I give it to you tonight And we sleep all, sleep all day, sleep all, we sleep all day over Why don't we, sleep all, sleep all day, we sleep all day, we sleep all day over and over and over and over again And as time goes by we get a little bit tired waking and baked another Marlboro mile wide It's sending the boys on the run in the time in the hot summer sun To swim beneath or over outside till they're reading between the lines But they read none of the part in the hallmark card where they read about the dreams And reaching for the stars to hold on a little bit closer to Who said it was time, time to take, take love Time to take a chance here Time to compromise to occupy the lies And it was time for all the wrong reasons but time is often on my side but I give it to you, oh boy Sleep all, we sleep all day, sleep all, we sleep all day over so why don't we, sleep all, we sleep all day, sleep all, we sleep all day over and over She said what did … | ["Music", "Independent music"] | ["pop", "acoustic guitar", "mandolin", "e-piano", "acoustic drums", "e-bass", "male voice singing", "higher key", "medium tempo", "happy"] | 6 | 95ThRxhl-ug | 976 | |
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
The Muddy Hill Boys - Bluegrass To Rockin'The Country Jamboree | A group of male vocalists sing this happy, upbeat country /bluegrass song. The tempo is fast with vigorous and animated acoustic guitar, banjo, mandolin and auto harp lead and harmony. The song is a live performance with ambient sounds of clapping, cheering and people talking. This song is a cheerful Country Pop/Bluegrass song. | 2015-04-05T21:37:46Z | chrisdixie1 | https://www.facebook.com/themuddyhillboys?fref=ts Rockin' The Country Jamboree N°1 - à TOURS 37 FRANCE organisé par DiscOldies le 28/03/2015 | ["Banjo", "Country", "Music", "Rock and roll", "Bluegrass"] | ["male vocalists", "fast tempo", "cheerful", "happy", "acoustic guitar", "vigorous banjo", "auto harp", "mandolin", "ambient noises", "clapping", "cheering", "people talking", "live performance", "gig", "concert", "cheering", "country music", "country folk music", "bluegrass", "inferior audio quality", "amateur recording", "lively", "spirited", "enthusiastic", "vivacious", "youthful", "happy", "celebratory", "festive"] | 7 | 0XxinBtKouQ | 179 |
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;