musiccaps_details (view)
8 rows where musiccaps_aspects contains "mandolin" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- mandolin · 8 ✖
- amateur recording 7
- uptempo 4
- acoustic guitar 3
- acoustic guitars 3
- upright bass 3
- acoustic drums 2
- e-bass 2
- male voice singing 2
- medium tempo 2
- uplifting energy 2
- banjo 1
- celtic folkmusic 1
- cheerful 1
- country/folk 1
- crowd cheering 1
- e-piano 1
- fast tempo 1
- flutes 1
- folk/country 1
- good mood 1
- happy 1
- higher key 1
- male and female voices singing 1
- medium to uptempo 1
- percussion 1
- pop 1
- pop/singer-songwriter 1
- violin 1
- whistling 1
musiccaps_names (array) 16 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Smokin' Guitar at the Super Srecret Bluegrass Jam | This song contains acoustic guitars being strummed fast, a mandolin playing the lead melody in a higher pitch and an upright bass providing an almost walking bassline. This song may be playing in the countryside while having a BBQ. | 2006-09-25T12:58:24Z | arenacom1 | We were playing so fast that my guitar started smoking at the end of the video. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["amateur recording", "acoustic guitars", "mandolin", "upright bass", "uptempo", "cheerful"] | 6 | 0S5zWt91Bwo | 169 | |
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 | |
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
Cherokee Shuffle & Sled Ride - Townsend Bluegrass Jam, 5 5 12 | This song contains people strumming chords on acoustic guitars while a banjo and a mandolin are taking turns playing a lead melody. In the background you can hear an upright bass playing a fitting bassline. This song may be playing live while having a BBQ with friends. | 2012-06-25T22:02:35Z | gingermc2 | I know the name of only two people in this jam session; McCoy Borg, the banjo player & Josh-mandolin.. I think the woman playing bass is from Ohio. Spring Festival @ Townsend, TN 5-5-12. | ["Country", "Music", "Bluegrass"] | ["amateur recording", "folk/country", "acoustic guitars", "mandolin", "banjo", "upright bass", "uptempo", "good mood"] | 6 | Ok-ia7ziJy0 | 2465 | |
Intense Celtic Mandolin | This audio contains someone picking and strumming a fast paced melody on the mandolin. This song may be playing live in a bar. | 2008-08-09T20:44:54Z | spartacusian08 | This is me playing an original song that I wrote on my mandolin. Thats about it... : ) Enjoy! | ["Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "celtic folkmusic", "mandolin", "uptempo", "uplifting energy"] | 6 | Q0VVfneN8MI | 2588 | |
Kjarkas - Yo no he nacido para sufrir HD | This song contains someone strumming a melody on a mandolin while more people are whistling along. Then a mandolin, an e-bass and an acoustic guitar are playing a short melody in a lower key before breaking into the next part along with flutes and percussions. This song may be played outside by musicians performing. | 2016-07-07T01:47:40Z | calacas555 | Tema que será parte de la nueva producción cdgráfica del grupo Kjarkas denominado la Leyenda Viva | ["Folk music", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "acoustic guitar", "e-bass", "mandolin", "flutes", "whistling", "percussion", "medium tempo"] | 6 | ZTVMsW1h3bI | 3379 | |
Lucy In The Sky With Diamonds Mandolin Cover | Someone is strumming a melody on the mandolin. The audio-quality is very poor and you can hear a high frequency ringing in the recording. This song may be playing while practicing at home. | 2007-08-26T23:16:35Z | songsbybands | "Lucy In The Sky With Diamonds" By The Beatles Played On An A-Style Mandolin. G - ----------------- D - -2---5--4--3----- A - --0----0-0--5-4-0 E - ---0--0---0------ If you wanna check out our original music, go to www.myspace.com/seanandaustin | ["Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["amateur recording", "mandolin", "fast tempo"] | 6 | hheF-AgCqIg | 4129 | |
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 |
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;