musiccaps_details (view)
2 rows where musiccaps_aspects contains "scratching sound", musiccaps_author = 7 and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- fast tempo 2
- scratching sound · 2 ✖
- ambient techno 1
- boomy bass 1
- chaotic 1
- club music 1
- confusing 1
- dance music 1
- dj 1
- dj mixer 1
- dj routine 1
- drum machine 1
- edm 1
- edmdance music 1
- electronic music 1
- energetic drumming 1
- female backup 1
- groovy bass line 1
- high-spirited 1
- hip-hop 1
- hypnotic 1
- inferior sound quality 1
- instrumental 1
- keyboard harmony 1
- male vocalist 1
- muffle audio 1
- pro 1
- psychedelic 1
- rap 1
- rhythmic patter 1
- skillful 1
- synthesised sounds 1
- tech house 1
- techno music 1
- techno trance 1
- trance music 1
- trap 1
- turn table 1
- unpleasant sound 1
- vigorous 1
- vinyl record 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SKREW MSK AWR ARTIST WRITING | A male vocalist sings a lively hip hop. The tempo is fast with energetic drumming, groovy bass lines and keyboard accompaniment with female backup vocals. The song is incoherent and muffled with a loud scratching like sound dominating the audio. The audio is chaotic, confusing, incoherent and unpleasant to the ears. | 2008-11-26T23:03:40Z | Eddie Donaldson | GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/ | ["Scratching (performance technique)", "Music", "Scratch", "Writing"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "keyboard harmony", "unpleasant sound", "female backup", "groovy bass line", "energetic drumming", "rhythmic patter", "muffle audio", "inferior sound quality", "scratching sound", "chaotic", "confusing"] | 7 | IlUcHzBzZvg | 1936 | |
DJ Craze - DJ Routine [inthemix] | This music is an Electronic instrumental. The tempo is fast with vigorous electronic and heavily synthesised music using DL mixer, turn table and drum machines.The Ustica is youthful, futuristic, contemporary, vigorous, groovy, psychedelic, trance, hypnotic ,boomy and pulsating. This music is an Electronica/Tech House. | 2015-08-03T21:31:47Z | zebgagang | https://vk.com/trap_edm | ["Scratching (performance technique)", "Electronic music", "Music"] | ["instrumental", "fast tempo", "drum machine", "turn table", "edm", "synthesised sounds", "dance music", "ambient techno", "hypnotic", "psychedelic", "tech house", "dj mixer", "dj", "edmdance music", "electronic music", "trance music", "trap", "techno music", "scratching sound", "vinyl record", "boomy bass", "skillful", "vigorous", "pro", "dj routine", "club music", "youthful", "high-spirited", "techno trance"] | 7 | ue1sgGEvkwE | 5130 |
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;