musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- bass · 3 ✖
- electronic drums · 3 ✖
- danceable 2
- 80s 1
- clubmusic 1
- disco 1
- electronic 1
- european 1
- female vocal 1
- finnish techno pop 1
- groovy 1
- hardstyle/trance 1
- high energy 1
- keyboard 1
- keyboards 1
- live performance 1
- male vocal 1
- medium tempo 1
- old-fashioned 1
- playful 1
- polka 1
- pulsating pad sounds 1
- retro 1
- synthesizer plucks 1
- uptempo 1
- vibrant 1
- yodel-like singing 1
musiccaps_names (array) 9 ✖
- Music 3
- Techno · 3 ✖
- Trance music 2
- Dance music 1
- Drum and bass 1
- Dubstep 1
- Electronic music 1
- Electronica 1
- House music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Loituma - Ievan's Polkka (live, techno original version) | This is a finnish techno pop piece with polka influences. There is a female vocalist in the lead singing rapidly in a manner that resembles yodeling. A male vocalist occasionally joins her at a lower pitch while singing the melody. The melodic background consists of a keyboard tune and a simple bass line. The rhythmic background is provided by an electronic disco drum beat. The atmosphere is playful and danceable. This piece could be used in the background of a comedic social media content. It could also be played at children's events. | 2010-10-21T08:13:23Z | nestorrente | Loituma performs their song Ievan's Polkka in a rare techno version. | ["Electronic music", "Music", "Techno"] | ["finnish techno pop", "polka", "live performance", "male vocal", "female vocal", "yodel-like singing", "keyboard", "bass", "electronic drums", "european", "playful", "vibrant", "danceable", "medium tempo"] | 9 | 0i8VM_EooCs | 201 | |
Jarrad - HARD TRANCE SHUFFLING 2012 #2 - Rage | The drums are playing a four on the floor techno rhythm with hihats and a strong kick. A synthetic bass follows the kick with almost just a single note playing. Panned to the left and right side of the speakers you can hear a monotone, repeating synth melody. This song may be playing in a technoclub. | 2012-04-25T20:48:13Z | 1am Films | WEEK #2 This is my Second Video for hardstyle/hard trance rocking, going to put together a new quick video every week :) TAGS : shuffling hardstyle reverse bass len we dance hard NR newcalste rockers LMFAO running man 2011 HD how to best dancing moves hat boy jarrad alalmbie sydney music qdance defqon cars loud new amazing magic slide DC break techno shuffle rocking melbourne old school how to running man new HD best compilation len wedancehard newcastle rockers brenton hiltzy pae sarah LMFAO party rock anthem every day im shuffling facebook twitter qdance scantraxx bass controll powerhouse jarrad peters hardstylestudio dance music australia NR GR german justin | ["Drum and bass", "Music", "Techno", "Trance music", "Dubstep"] | ["hardstyle/trance", "electronic drums", "bass", "synthesizer plucks", "pulsating pad sounds", "clubmusic", "uptempo"] | 6 | D7pjR9cQChM | 1440 | |
Best 80's Music Dance Hits Part 10 | This is an electronic music piece with 80s disco characteristics. There is a slightly fast tempo electronic drums in the rhythmic background. The keyboard is holding the notes of the melody while a synth bass follows it with a repeated rhythmic pattern. Although it is a bit old-fashioned, it is a danceable piece. This music could work well with retro-themed parties at nightclubs. It could also fit nicely with action-filled social media content or the soundtrack of a car racing game. | 2009-09-15T16:57:27Z | Danielmelie | Best 80's Music Dance Hits Part 10...Hope you enjoy!!! Divine - Native Love Amii Stewart - Knock on wood | ["House music", "Music", "Techno", "Trance music", "Dance music", "Electronica"] | ["electronic", "disco", "electronic drums", "keyboards", "bass", "80s", "danceable", "groovy", "high energy", "retro", "old-fashioned"] | 9 | O66lIRbF4Gw | 2398 |
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;