musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_author = 1 and musiccaps_names contains "Drum machine"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- dj 2
- electronic music · 2 ✖
- ambient room noise 1
- dance club 1
- dance rhythm 1
- different drumming styles 1
- discotheque 1
- drum machine 1
- electric guitar lead 1
- electronic harmony tones 1
- emotional 1
- energetic 1
- experimental 1
- female singer 1
- groovy mood bass line 1
- groovy rhythm 1
- hissing tones 1
- instrumental music 1
- medium tempo 1
- moog bass 1
- music production 1
- passionate 1
- people dancing 1
- practice session 1
- quirky 1
- radio buzzing tones 1
- rehearsal 1
- retro pop music 1
- romantic 1
- slick drumming tones 1
- steady drumming rhythm 1
- synth module demo 1
- techno drumming 1
- variables tempos 1
- various frequency tones 1
- various tempos 1
- vocal monologue 1
- youthful 1
- youtube demo video 1
musiccaps_names (array) 9 ✖
- Drum machine · 2 ✖
- Music 2
- Buzz 1
- Drum and bass 1
- Electronica 1
- Guitar 1
- Musical instrument 1
- Sampler 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Electro Harmonix DRM16 Demo vintage drum machine with Tube Amp | The tune is instrumental. The tempo is variable with a drum machine playing different styles and tempos. The song is a demonstration of a synth drum module with a guitar lead playing in the background. The audio quality is poor with hissing tones. | 2013-09-16T04:44:14Z | DakotaPlaysGuitar | Cool! | ["Guitar", "Music", "Musical instrument", "Drum machine"] | ["drum machine", "electronic music", "techno drumming", "dj", "rehearsal", "practice session", "hissing tones", "groovy rhythm", "youtube demo video", "various tempos", "different drumming styles", "electric guitar lead", "ambient room noise", "synth module demo", "instrumental music", "variables tempos", "slick drumming tones"] | 1 | OHrrS6AKW_c | 2423 | |
KING Q4 Love Buzz | A female singer sings this vocal monologue. The song is medium tempo with a groovy moog bass line, electro mix keyboard harmony tones, steady drumming rhythm and very quirky electronic tones. The song is groovy and retro dance music. | 2011-07-16T11:15:03Z | KINGQ44 | http://kingq4.bandcamp.com/ http://itunes.apple.com/fr/album/love-buzz-ep/id357022549 King Q4 Love Buzz Help me records 2010 composed by Shocking Blue arranged by King Q4 mixed by Raphael Seguin | ["Sampler", "Drum and bass", "Music", "Techno", "Buzz", "Drum machine", "Electronica"] | ["female singer", "retro pop music", "moog bass", "medium tempo", "energetic", "experimental", "quirky", "romantic", "youthful", "passionate", "people dancing", "dance club", "dance rhythm", "discotheque", "music production", "electronic music", "steady drumming rhythm", "dj", "radio buzzing tones", "various frequency tones", "groovy mood bass line", "dance rhythm", "emotional", "vocal monologue", "electronic harmony tones"] | 1 | dAAwzwexvUQ | 3767 |
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;