musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "advertising" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- acoustic guitar · 1 ✖
- advertising · 1 ✖
- bass guitar 1
- electronic drum beat 1
- gear 1
- jam 1
- male voice · 1 ✖
- rhythm machine 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
KR Mini: Energize your practices and performances with diverse rhythm patterns! | This is an advertisement video for a rhythm machine. Firstly, it is shown playing behind a bass guitar jam. Then, it is shown playing behind an acoustic guitar jam. A male voice is describing the benefits and functions of the rhythm machine. The parts where the instruments can be heard without the interruption of the voice can be sampled for use in beat-making. | 2013-09-05T01:01:42Z | Korg | Designed for guitarists, bassists, pianists or any musician looking for easy rhythm accompaniment, the KR mini features nostalgic looks and a simple design focused on easy, push-button control. The KR mini is also lightweight, can run on batteries and has a built-in speaker, allowing it to provide a backing rhythm pattern anywhere at any time. With a total of 60 diverse rhythm patterns across the genres, the compact KR Mini is ready to accompany any performance. For more information on the KR Mini Rhythm Machine, head over to http://www.Korg.com/KRmini. "Like" us -- https://www.facebook.com/KORGusa "Follow" us -- https://www.twitter.com/KorgUSA | ["Guitar", "Musical instrument", "Drum machine", "Plucked string instrument"] | ["jam", "gear", "rhythm machine", "electronic drum beat", "bass guitar", "acoustic guitar", "male voice", "advertising"] | 9 | rS8oECcQBCk | 4877 |
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;