musiccaps_details (view)

1 row where musiccaps_aspects contains "no percussion", musiccaps_aspects contains "relaxing melody", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Brass instrument"

✎ 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
Wedding 風笛～ハナミズキ～Happiness（アンコール） This song is played by an ensemble. The lead melody is played on a clarinet. A flute plays backing notes. A French horn plays the lower registers. Another clarinet plays a melody in harmony. This is an instrumental song. There are no voices in this song. There is no percussion in this song. This song is relaxing. This song can be played in a black tie dinner event. 2010-12-05T11:30:17Z Kazuto K's ensembre team「もくごっち」 オファー内容 「12月4日結婚式披露宴での演奏」 2010年12月4日GRAND PACIFIC LE DAIBAで行われた結婚式披露宴での演奏模様です 「風笛～あすかのテーマ」 「ハナミズキ」 「Happiness」 演奏はK's アンサンブルチーム『もくごっち』 K's ensemble 2009 Mokugocchi K's PLACE HP http://music.geocities.jp/ksplace20080528/ksplace001.html ["Brass instrument", "Clarinet", "Wind instrument, woodwind instrument", "Flute"] ["ensemble", "symphonic song", "flute", "clarinets", "no voices", "instrumental", "no percussion", "french horn", "slow tempo", "relaxing melody"] 0 UY2_Q830lqo 2924

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;