musiccaps_details (view)
1 row where musiccaps_names contains "Speech" and musiccaps_names contains "Trumpet" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_names (array) 6 ✖
- Brass instrument 1
- Finger snapping 1
- Music 1
- Musical instrument 1
- Speech · 1 ✖
- Trumpet · 1 ✖
musiccaps_aspects (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Brio使い方のポイント⑤ | This is the recording of a trombone lesson. The male instructor is playing a note on the trombone and then speaking in an instructive manner in the Japanese language. The click of the metronome can be heard in the background. This recording can be sampled for use in beat-making. | 2011-11-03T01:40:01Z | briobrass | Brio de Brass! Ver.1の一部です。 低音を吹くときアンブシュアを緩めたり、タンギングだけで音を出さないよう気をつけましょう。 Brioを使用するときと同じフォームで吹けるようにしましょう。 | ["Brass instrument", "Finger snapping", "Music", "Musical instrument", "Trumpet", "Speech"] | ["trombone lesson", "male voice", "japanese language", "instructive speaking", "metronome click"] | 9 | II1oyaWPiD0 | 1889 |
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;