musiccaps_details (view)
2 rows where musiccaps_aspects contains "cello", musiccaps_aspects contains "mellifluous", musiccaps_aspects contains "viola" and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Pumped up Kicks Jazz Style | A male vocalist sings this mellow country song. The tempo is medium with fiddle, cello and viola harmony with acoustic guitar rhythm.The song is mellow, soft, dulcet,emotional , melancholic and nostalgic . This song is Country Pop. | 2013-07-10T00:12:19Z | Red Soda Band | A jazz style cover of Pumped up Kicks by Foster the People. This is quite a controversial tune but has been very popular for a long time which is why we recorded a cover version of it. Pumped Up Kicks Lyrics (Foster the People) Robert's got a quick hand. He'll look around the room, he won't tell you his plan. He's got a rolled cigarette hanging out his mouth, he's a cowboy kid. Yeah, he found a six shooter gun in his dad's closet hidden with a box of fun things. And I don't even know what but he's coming for you, yeah, he's coming for you. [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Dad -- he works a long day. He'll be coming home late, he's coming home late. And he's bringing me a dark surprise. 'Cause dinner's in the kitchen and it's packed in ice. I've waited for a long time. Yeah, the sleight of my hand is now a quick-pull trigger. I reason with my cigarette And say, "Your hair's on fire, you must have lost your wits, yeah." [Chorus 2x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Ru-ru-run, run, run, run [4x] [Whistling] [Chorus 4x:] All the other kids with the pumped up kicks you better run, better run, outrun my gun. All the other kids with the pumped up kicks you better run, better run faster than my bullet. Live Wedding Band: https://redsoda.com Wedding Entertainment: https://www.facebook.com/RedSodaBand/ Wedding Singers: https://www.instagram.com/redsodaband/ Sydney Wedding Band: https://www.google.com/maps/place/Red+Soda+Band+Sydney/@-33.9118834,151.1329694,15z/data=!4m2!3m1!1s0x0:0xb2508b5ae82a53cf?sa=X&ved=2ahUKEwjuvcT3pbbwAhXpwjgGHVUtCfMQ_BIwGHoECCMQBQ Phone: 02 8006 2234 | ["Music", "Wedding music"] | ["male singer", "medium tempo", "violin", "country music", "sentimental", "melancholic", "string orchestra", "string harmony", "country folk song", "country hits", "country pop", "regional pop", "fiddle", "cello", "viola", "acoustic guitar", "dulcet", "mellifluous", "mellow", "emotional", "romantic", "dreamy", "sentimental nostalgic", "story telling", "performance"] | 7 | 40xkia7fwEM | 534 | |
| Lord of the Rings - In Dreams (Soundtrack) | A female opera singer sings this soprano melody. The tempo is slow with an ethereal violin symphony accompaniment. The song is mellifluous , soft, enchanting, enigmatic, mystical, ethereal,celestial and dreamy. This is a Classic Opera. | 2011-04-11T07:29:38Z | Z7TomC7Z | (In Dreams) Main Theme of The Lord of the Rings - In Dreams (Soundtrack) Fellowship of the Ring (Theme song) (Choir) By Howard Shore Lyrics When the cold of Winter comes Starless night will cover day In the veiling of the sun We will walk in bitter rain But in dreams I can hear your name And in dreams We will meet again When the seas and mountains fall And we come to end of days In the dark I hear a call Calling me there I will go there And back again Lord of the Rings - In Dreams (Soundtrack) Chior Theme Lord of the Rings - In Dreams (Soundtrack) Chior Theme Disclaimer to rights of video. I did not take the pictures or create/write the music in this video. | ["Music", "Opera"] | ["female singer", "slow tempo", "soprano", "falsetto", "descant", "high notes", "melodic violin", "violin symphony", "cello", "viola", "orchestra", "philharmonic", "symphony orchestra", "classical music", "ethereal", "angelic", "celestial", "enthralling", "captivating", "mesmerising", "pleasant", "dreamy", "mellifluous", "enchanting", "descan", "opera singer"] | 7 | Ha-FS_CHmGw | 1818 |
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;