musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- dj 2
- electronic music · 2 ✖
- steady drumming rhythm · 2 ✖
- dance club 1
- dance rhythm 1
- discotheque 1
- distorted tones 1
- dubstep music 1
- electronic dance music 1
- electronic harmony tones 1
- emotional 1
- energetic 1
- experimental 1
- female singer 1
- groovy mood bass line 1
- grunge keyboard tones 1
- instrumentals music 1
- medium tempo 1
- moog bass 1
- music production 1
- overdriven keyboard harmony 1
- passionate 1
- people dancing 1
- poor audio quality 1
- quirky 1
- radio buzzing tones 1
- retro pop music 1
- romantic 1
- rubbing tones 1
- synth string pad section 1
- techno dance music 1
- techno drumming rhythm 1
- various frequency tones 1
- vocal monologue 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 2
- Buzz 1
- Drum and bass 1
- Drum machine 1
- Dubstep 1
- Electronic music 1
- Electronica 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 |
---|---|---|---|---|---|---|---|---|---|---|
Baile de Dubstep | The song is an instrumental. The song is medium tempo with a slick drumming rhythm, grunge keyboard tones, overdriven synth tones and string pad section. The song is groovy and exciting. The audio quality is poor in general. | 2013-03-08T02:22:05Z | Rafael Chávez | Mira mi nuevo video y aprende 3 pasos sencillos https://www.youtube.com/watch?v=nhlQRS4vDYo | ["Electronic music", "Music", "Dubstep"] | ["instrumentals music", "dubstep music", "overdriven keyboard harmony", "poor audio quality", "dj", "electronic music", "grunge keyboard tones", "steady drumming rhythm", "distorted tones", "synth string pad section", "electronic dance music", "techno drumming rhythm", "techno dance music", "rubbing tones"] | 1 | MP7KPlqoQW0 | 2262 | |
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;