musiccaps_details (view)

2 rows where musiccaps_aspects contains "soothing ballad"

✎ View and edit SQL

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
Daisy (Hey) Music Video (Eng sub) This is an emotional Japanese pop ballad. The singer has a light, airy and gentle voice that she uses to sing over the deep and full piano arpeggios. The song has a calming and emotional effect. 2012-12-17T13:51:26Z pachamadresita ✿⊱╮For those we lose and love.. ["Music", "Sad music"] ["piano arpeggio", "gentle ballad", "soothing ballad", "calm", "beautiful", "emotional", "love song", "airy soothing female voice", "gentle female vocal", "japanese pop"] 3 2M-CFCo-rkY 357
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

CSV options: 

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;