musiccaps_details (view)

1 row where musiccaps_aspects contains "folk song", musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "no voices" and musiccaps_aspects contains "sad melody"

✎ 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
Heart of Gold - Neil Young cover with harmonica This folk song features a harmonica playing the main melody. The harmonica plays three descending notes. This is followed by a double stop being played a total of nine times in groupings of two, three, three and one time. Then it plays a higher note going down a descending scale of two more notes. This is accompanied by an acoustic guitar strumming chords. The mood of this song is sad. This song can be played at a house party. 2007-06-22T22:38:17Z mynamesche **TUTORIAL IN RESPONSES** There are sixty million covers of heart of gold on youtube so I thought i'd add sixty million and one. Such a great, simple pop song from an amazing man who has pumped out so much amazing music over the years. Unfortunately no Linda Ronstadt and James Taylor on backing vocals but hey there's a wee bit o' harp in there at least. Please be careful if you're wearing headphones, i almost blew my ears up listening back to this and the harmonica came through like a sonic laser into my ear drum. ["Harmonica", "Wind instrument, woodwind instrument"] ["folk song", "acoustic song", "harmonica", "no voices", "no other instruments", "instrumental", "no percussion", "sad melody", "moderate tempo"] 0 XdBf_omYIO4 3203

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;