musiccaps_details (view)
1 row where musiccaps_aspects contains "clarinets", musiccaps_aspects contains "no voices" and musiccaps_names contains "Wind instrument, woodwind instrument"
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
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;