musiccaps_details (view)

1 row where musiccaps_aspects contains "male voice singing", musiccaps_aspects contains "reggae" and musiccaps_names contains "Singing"

✎ 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
[Richie Spice] === Crying Out This song contains a male voice singing sounding sad. Drum and percussion are playing a reggae rhythm along with two e-guitars playing. One a melody panned to the right side of the speakers and another short rhythmic strokes as a rhythmic element. The bass is playing its own melody. This song may be playing at a live concert. 2007-04-27T19:38:43Z frazer96 i hear dey cryin out mama i hear dem cryin outlove dey need a rightful place dada dey need to shelter from da storm (chorus) children are cryin out for love cryin out love children r cryin out for love cryin out love i c some round da streets dada street side becomes dere daily school they need some proper education they need to learn da golden rule (chorus x2) some need a guiding star dada some need to cuddle in your arms some need your time of day mama cant face this gideon on there own (chorus x2) i c da suffer out dere i see da battered out dere street side become some home oh jah dere mind is not at ease (chorus x2) gift for every kids love for every kids bread for every kids dats when da world wud be change take it from root teach da youths da truth teach da youth da roots yeah (chorus) i hear dey cryin out mama i hear dem cryin outlove dey need a rightful place dada dey need to shelter from da storm ["Singing", "Music", "Reggae"] ["reggae", "sad atmosphere", "e-bass", "drums", "e-guitars", "male voice singing", "backing vocals"] 6 6o6DsSnbpxE 788

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;