musiccaps_details (view)
1 row where musiccaps_aspects contains "pop", musiccaps_author = 6 and youtube_description = "(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 you think your mother would do this and how would your father react oh lord Would he take it all back what they've done No way they said take it, take it and don't break it with your own two hands See that was my old man and he said If all is grounded you should go make a mountain out of it"
This data as json, CSV (advanced)
Suggested facets: musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;