musiccaps_details (view)
2 rows where musiccaps_aspects contains "peaceful" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 7 ✖
- Music 2
- Plucked string instrument · 2 ✖
- Chorus effect 1
- Electronic tuner 1
- Guitar 1
- Musical instrument 1
- Tapping (guitar technique) 1
youtube_published (date) 2 ✖
- 2007-05-02 1
- 2008-12-28 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Demo of Danelectro Cool Cat Chorus | This is the live performance of an electric guitarist. The chords are arpeggiated and the guitar has effects applied to it to produce a warm and rich tone. The song is calm and peaceful, and would be suitable for a tranquil afternoon walk at the park. | 2007-05-02T17:24:01Z | gitaarheld | Just a little demo of my Danelectro Cool Cat Chorus pedal. First you hear the clean sound without chorus, then the clean sound with chorus. Same for the lead. Don't blame me for the crappy playing, I haven't played this song for years and can't play without faults when the camera is running. I hope you like the sound. Btw the song (a small part of it) is Always With Me, Always With You by Joe Satriani. Comments are always welcome. | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "live performance", "chord arpeggios", "warm sounding guitar tone", "poor audio quality", "soothing and gentle music", "peaceful"] | 3 | ZOGMpGQQ3FI | 3371 | |
Khorakhané (A forza di essere vento) - KHORAKHANE' | This is a soothing Italian ballad. The leading instruments are a harmonica and acoustic guitar on which arpeggios are played. The singer has a silky baritone voice, and captures the reflective and tranquil nature of the song with his performance. | 2008-12-28T14:25:17Z | Emanuele Ricciardi | Like the Jews, Gypsies were singled out by the Nazis for racial persecution and annihilation. They were 'nonpersons,' of 'foreign blood,' 'labor-shy,' and as such were termed asocials. To a degree, they shared the fate of the Jews in their ghettos, in the extermination camps, before firing squads, as medical guinea pigs, and being injected with lethal substances. KHORAKHANE' The hearbeats slow down, the head walks on in that poddle of piss and concrete in that field blown by the wind by dint of being the wind I bear the name of all baptisms each name the seal of a pass for a ford, a country, a cloud, a song a diamond hidden in bread but for one humour in blood so sweet for the same reason to travel, travelling The heartbeats slow down, the head walks on in the dark of forlorn swings some gypsies stopped and became Italian like copper hung to get brown on a wall Being able to read the book of the world with everchanging words and no writing on the narrow paths in the palm of a hand those frightening secrets until a man meets you and won't know himself anymore and every country lights up and peace surrenders Sons would fall from the calendar Yugoslavia, Poland, Hungary soldiers would take them all and all they threw away And then Mirka at St. Georges in May * between the flowers flames, with laughs and drinks a relief in tears flooding the eyes and from the eyes falling down Now rise you childbrides the time has come to go blue veins on your wrists another day for begging And if this means stealing a scanty bread out of poverty and misfortunes on the mirror of this kampina ** to my eyes, clear as a farewell that can only tell who's got in his mouth God's point of view Čvava sero po tute i kerava jek sano ot mori i taha jek jak kon kašta vašu ti baro nebo avi ker. kon ovla so mutavla kon ovla ovla kon aščovi me ğava palan ladi me ğava palan bura ot croiuti. * Gypsies' holiday, on the 6th of May ** kampina: mobile tent -The final verse in "r… | ["Music", "Electronic tuner", "Plucked string instrument"] | ["soothing ballad", "italian singing", "harmonica", "silky male baritone vocal", "acoustic guitar arpeggios", "reflective", "soothing", "peaceful"] | 3 | khVk4pTS0bE | 4347 |
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;