musiccaps_details (view)

1 row where musiccaps_aspects contains "male vocal", musiccaps_aspects contains "minor key", musiccaps_aspects contains "urban" and musiccaps_names contains "Steelpan"

✎ 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
Majid vs Mels { Show Yaa Best of the Best } Final Vol 1 This is a neo-soul music piece playing under the background of a dance contest. There is a male vocalist singing melodically in the lead. There is a repeating acoustic guitar sample in the beat. A strong bass sound can be heard. The rhythm consists of an electronic drum beat. There are voices shouting over the music in the video. The atmosphere is groovy and urban. 2014-06-29T08:39:46Z Showyaa Bestofthebest Majid Vs Mels Show Yaa Best Of The Best Final Best of the Best Battles Winner : Majid old future ["Music", "Music of Latin America", "Hip hop music", "Steelpan"] ["neo-soul", "male vocal", "melodic singing", "acoustic guitar sample", "strong bass", "electronic drums", "voices shouting", "groovy", "urban", "minor key"] 9 apA0IY_5-2g 3575

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;