musiccaps_details (view)
1 row where musiccaps_aspects contains "acapella" and "youtube_published" is on date 2010-03-09
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Boxer | This is an acapella version of a rock music piece. There are male vocals performing the piece using the harmony singing technique. They are singing in the major key. The atmosphere is dreamy and vibrant. This piece could be used in the soundtrack of a drama movie that takes place in the United Kingdom. | 2010-03-09T15:42:06Z | Casper Lai | Words by lPaul Simon Music by Art Garfunke Performed by The King's Singers I am just a poor boy, though my story's seldom told. I have squandered my resistance, For a pocketful of mumbles, such are promises. All lies and jest. Still a man hears what he wants to hear and disregards the rest. When I left my home and my family I was no more than a boy, In the company of strangers, In the quiet of the railway station, runnin' scared. Laying low, seeking out the poorer quarters, Where the ragged people go. Lookin' for the places, only they would know. Lie-la-lie ... Asking only workman's wages I come lookin' for a job, But I get no offers, Just a come-on from the whores on Seventh Avenue. I do declare there were times when I was so lonesome, I took some comfort there. La, la, la, la, la, la, la. (Instrumental break) Li la li ... And Im laying out my winter clothes, and wishing I was gone, goin home Where the new york city winters arent bleedin me, leadin me goin' home. In the clearing stands a boxer and a fighter by his trade, And he carries the reminders of every glove that laid him down, Or cut him 'til he cried out in his anger and his shame, "I am leaving, I am leaving." But the fighter still remains. Lie-la-lie ... | ["Choir"] | ["acapella", "rock", "male vocals", "harmony singing", "major key", "vibrant", "dreamy"] | 9 | SHYGoXwgKtk | 2756 |
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;