musiccaps_details (view)
2 rows where musiccaps_aspects contains "dreamy" and musiccaps_aspects contains "rock"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- dreamy · 2 ✖
- rock · 2 ✖
- acapella 1
- acoustic drum loop 1
- e-bass 1
- e-guitar 1
- harmony singing 1
- major key 1
- male vocals 1
- uptempo 1
- vibrant 1
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 | |
Death By Audio Echo Dream 2 Advanced Echo Modulation | Someone is playing a clean e-guitar with a lot of reverb and delay. Fingerpicking and creating dreamy rhythm and melodic patterns. In the background you can hear a drumloop and an e-bass. This song may be playing during a little live concert. | 2013-02-02T04:46:42Z | Prymaxe | $270.00 https://www.prymaxe.com/products/death-by-audio-echo-dream-2-advanced-echo-modulation Death By Audio Echo Dream 2 Advanced Echo Modulation This is it. The most beautiful blissed out delay ever heard. You have entered the candy coated dream world of the Echo Dream 2. The Echo Dream 2 is a lofi modulating delay pedal that can drive into fuzzed out insanity. The modulation can be set to give spacey chorus sounds or warbling bounces to robo- groove arpegiations in squarewave mode. The fuzz can range from subtle overdrive to ballsy fuzzstain and bring upon satans spawns to do the mopping up. This is a new take on the Echo Dream circuit with additional knobs for Fuzz and Master Volume and reengineered with a cheaper price tag so all can bask in it's glory. Buy one today. Death By Audio Echo Dream 2 Advanced Echo Modulation Features Sine or Square wave modulation 40ma draw on a 9-volt battery Can also use postive ring, negative tip 9-18 volt power supply (not included) Fuzz control to add additional sound possibilities to your tone | ["Echo", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["rock", "dreamy", "e-guitar", "acoustic drum loop", "e-bass", "uptempo"] | 6 | XnHAH2aPHk0 | 3224 |
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;