musiccaps_details (view)
4 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- digital drums · 4 ✖
- male voice singing · 4 ✖
- uptempo · 4 ✖
- higher register 2
- techno 2
- amateur recording 1
- bass 1
- deeper voice 1
- digital strings 1
- e-guitar 1
- electro/techo 1
- higher pitch 1
- keyboard melodies 1
- pop 1
- positive atmosphere 1
- synth arpeggios 1
- synth bass 1
- synth pluck 1
musiccaps_names (array) 6 ✖
- Music 4
- Electronic music 2
- Disco 1
- Techno 1
- Wedding music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DANIJEL BOTO - URNEBES (OFFICIAL MUSIC VIDEO) | Digital drums are playing a four on the floor rhythm with a kick on every beat along with a bassline and a keyboard sound playing short rhythmic chords and a e-guitar playing a simple melody along. A male voice is singing in a higher key. This song may be playing at a folkfest. | 2012-10-31T00:15:59Z | CinematixStudios | Danijel Boto - Urnebes 1.dio Ima jeda smeđa mala oduvijek je plesat znala Kad zanjiše kukovima pomuti nam pamet svima... A,i ona mala plava kako pleše boli glava nezna čovjek šta bi reko ovaj stol je samo na njih čeko... REFREN: Hajmo svi na stol to je ovi fol hajmo svi a ples bit će URNEBES 2.dio Konobaru toči piće atmosfera luda biće donesi am piće svima mi smo već na stolovima Šta je ovo moji ljudi ova pjesma sve nas budi sve je ludo gori sve plešemo uz dobre ritmove... REFREN: Hajmo svi na stol 2x | ["Music", "Wedding music"] | ["pop", "digital drums", "e-guitar", "keyboard melodies", "male voice singing", "higher register", "bass", "uptempo", "positive atmosphere"] | 6 | -bgHkxwoliw | 65 | |
Bandidos Ballerup Techno Remix' Psy 2012. | This song contains digital drums playing a kick on every beat together with a digital synth bass playing a simple almost monotone bassline. A male voice is singing in a deeper key. This song is running through some filters opening up and with a lot of reverb. This song may be playing while having a car ride. | 2012-06-13T13:30:09Z | forest dock | FREE DOWNLOAD http://www.mediafire.com/?2g22jdky58ddh58 | ["Electronic music", "Music", "Techno"] | ["techno", "digital drums", "synth bass", "male voice singing", "deeper voice", "uptempo"] | 6 | 4GlH0-KhInI | 550 | |
Michael Jackson (Ease On Down The Road) | This song contains digital drums playing a four on the floor rhythm with a strong kick on every beat. A male voice is singing at a higher pitch. This song may be playing in a techno club. | 2007-12-05T07:08:08Z | Mredwards12 | A Tribute To Michael Jackson (You Will Be Missed) | ["Disco", "Music"] | ["techno", "digital drums", "male voice singing", "higher pitch", "uptempo"] | 6 | Obtx-A9Lt5c | 2450 | |
grind wiv me 4x4 mix | This song contains digital drums playing a four on the floor groove with a kick on every beat. A low synth arpeggio is serving as bassline rather than pitching up one octave while synth pluck instruments are playing a fast and repeating melody. A male voice is singing a melody in a higher key. The voice is panned to the right side of the speakers and is not the loudest element in the mix. You can hear a high pitch string drone. This song may be playing at a private houseparty. | 2007-05-14T10:48:21Z | boybetterknow06 | jus listen | ["Electronic music", "Music", "Zing"] | ["electro/techo", "digital drums", "male voice singing", "higher register", "digital strings", "synth arpeggios", "synth pluck", "uptempo", "amateur recording"] | 6 | TzPuAqjoL80 | 2879 |
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;