musiccaps_details (view)
1 row where musiccaps_aspects contains "drum machine sounds", musiccaps_aspects contains "no voices" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
9 Drum Machines: Roland, MFB, Nord, BKE, Elektron, Korg, TipTop Audio | This audio features a drum machine playing different beats. It starts off with a phrase using seven strokes on the kick and one hand clap. This is followed by another sequence of seven strokes on another percussive instrument and one stroke on a different part of the instrument. This is followed by a hip-hop beat using booming kick sounds. This is a demonstration of a drum machine. | 2014-04-10T20:17:27Z | Soundria eurorack modular | We live wonderful times: so many drum synthesizers available, each with their own character. We played each a little, and made a movie so you can see each other next to the other. Captions are available in English and Hungarian. Video is recorded at our pro audio / musical instrument store in Budapest. 00:07: Roland AIRA TR-8 01:58: Korg Volca Beats 03:29: MFB Tanzbar 05:11: MFB 522 06:22: Vermona DRM1 mkIII 08:18: Nord Drum 2 and Nord Beat 09:40: Elektron Machinedrum 12:31: TipTop Audio BD808,BD909,SD808,,Hats808,Hats909,909CP 14:02: BKE Beat Thang You may follow us by subsrcibing to our channel or to our Facebook page. You are welcome to visit us at www.soundria.com (English), www.soundria.ro (Romania), www.soundria.sk (Slovakia) or www.hitspace.hu (Magyarország) | ["Electronic music", "Music", "Musical instrument", "Drum machine", "Synthesizer"] | ["drum machine sounds", "no other instruments", "no voices", "different beats", "hand claps", "demonstration"] | 0 | NP5iO_HB-f0 | 2334 |
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;