musiccaps_details (view)
3 rows where musiccaps_aspects contains "hand claps", musiccaps_aspects contains "programmed percussion" and musiccaps_aspects contains "synth sounds"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- hand claps · 3 ✖
- programmed percussion · 3 ✖
- synth sounds · 3 ✖
- moderate tempo 2
- bass 1
- booming bass 1
- dance music 1
- dubstep song 1
- female voice 1
- hip-hop song 1
- house music 1
- instrumental 1
- male voice 1
- no voice 1
- party music 1
- quirky sounds 1
- slow tempo 1
musiccaps_names (array) 10 ✖
- Music 3
- Disco 1
- Drum machine 1
- Dubstep 1
- Electronic music 1
- Electronica 1
- Hip hop music 1
- House music 1
- Musical instrument 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Best House Music In The World [Turn It Around] | This house music features a female voice singing the main melody. This is accompanied by programmed percussion playing a simple beat. The kick is played on every count. Hand claps are played at every alternate count. The bass plays the root notes of the chords. Synth chords are played in the background. This song can be played at a club. | 2009-07-22T20:45:27Z | ALBANIITY | The nEwW BeAtt Off BEst HoUsee MUSiiC iN ThE WOrLDD It iS FroOm A FaMouSs DJ --He LivvEEs in LA LetSSs ReAAddyy FooR HooUseee club hits my first megamix Best house music top house music top electro house best electro house top tribal house best tribal house new house music house music 4 ever hot house music new tribal house best latin house top latin house best prog house hot prog house i love house music megamix number 1 mixed by foOtBaLl7PlaYa | ["Disco", "House music", "Music"] | ["house music", "party music", "female voice", "hand claps", "programmed percussion", "synth sounds", "bass", "moderate tempo", "dance music"] | 0 | ICcASgMtIJ8 | 1879 | |
Checkout the Best Dubstep Music Software 2013! Sick DEMO! | This song starts with a descending phrase played on a synth. This is followed by an ascending phrase on another synth. This is accompanied by simple programmed percussion playing the hi-hat on the first two counts and the fourth count of each bar. The snare is played on the third count of each bar. After four bars, the percussion plays a roll and the bass plays one note two times. The synth sounds in the background get louder when the roll is played. There are no voices in this song. This song can be played in a night club. | 2013-06-30T05:56:18Z | theDRDRUM23 | DISCOUNTED LINK: http://tinyurl.com/DRDRUM23 Ever wanted to create beats but just found everything FAR too complicated and expensive? Maybe you have tried beat making software before only to be left scratching your head after 4 hours of playing with it and getting nowhere fast? http://tinyurl.com/DRDRUM23 Well that's why Dr Drum was created, it's the first software that's been designed for ease of use without compromising on quality or features. Unlike other software you will be banging out your first beats within minutes of downloading it and best of all it costs WAY less. http://tinyurl.com/DRDRUM23 Head over there now and check it out for yourself. software to make beats, make a beat software, software make beats, the best beat making software, make beats software, make beat software, software for making beats, making beats software, beats making software, make drum beat, dr drum beat, creating drum beats, dr drum software, dr drum beat making, the best beat maker software, making beats program, program for making beats, creating beats software, make beats program, software to create beats, dr beat software, create beats software, beats making program, making beats programs, beats creating software | ["Music", "Musical instrument", "Dubstep", "Drum machine", "Hip hop music", "Electronica"] | ["dubstep song", "synth sounds", "programmed percussion", "hand claps", "booming bass", "no voice", "instrumental", "slow tempo"] | 0 | OyRtTtTSXuM | 2486 | |
Da' Zoo- Boom Zoo Pow | This hip-hop song features a male voice singing the main melody. There are other quirky voices singing in the background. This is accompanied by programmed percussion playing deep kick and snare hits. Hand claps are played on alternate counts of the bar. This song can be played in a club. | 2009-10-05T04:46:11Z | cheiffortyseven | todo el crédito le pertenece a da zoo | ["Electronic music", "Music", "Zing"] | ["hip-hop song", "male voice", "quirky sounds", "hand claps", "programmed percussion", "synth sounds", "moderate tempo"] | 0 | sbOBTkrivXM | 4966 |
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;