musiccaps_details (view)
1 row where musiccaps_aspects contains "clarinet", musiccaps_aspects contains "comedy", musiccaps_aspects contains "strings" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ranma 1/2 Live Action Cast | This is an instrument comedy music piece. There is a clarinet playing a goofy tune. Then, the clarinet stops and the strings section starts playing a dramatic melody. This piece could be sampled to be used as instrumentals in an advertisement jingle. | 2011-10-21T00:40:13Z | Rumic World | The cast of the new Ranma 1/2 special in full costume. The special will air on December 9, 2011 at 7:00pm on NTV. Kento Kaku (male Ranma) Natsuna Wantanabe (female Ranma) Yui Aragaki (Akane) Kyoko Hasegawa (Kasumi) Shosuke Tanihara (Dr. Tofu) Maki Nishiyama (Nabiki) Kento Nagayama (Tatewaki Kuno) Yuta Kanai (Hikaru Gosunkugi) Arata Furuta (Genma) Katsuhisa Namase (Soun) Ryousei Tayama (Okamada) The song is "Lychee & Jasmine" from the Movie 1 OST. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["comedy", "instrumental", "clarinet", "goofy tune", "strings", "dramatic"] | 9 | fvTh5m9RHZw | 3988 |
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;