musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass line" and musiccaps_names contains "Scratching (performance technique)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- groovy bass line · 2 ✖
- hip-hop 2
- chaotic 1
- confusing 1
- dj performance 1
- electronic drums 1
- energetic drumming 1
- fast tempo 1
- female backup 1
- hip 1
- inferior sound quality 1
- keyboard harmony 1
- male vocal sample 1
- male vocalist 1
- muffle audio 1
- rap 1
- rhythmic patter 1
- scratching 1
- scratching sound 1
- turntable 1
- unpleasant sound 1
- urban 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 MARCO-HOW TO SCRACH WITH VIRTUAL DJ | This is the recording of a DJ performance. The DJ is performing on a turntable using the scratching technique. The beat in the background has a repeating male vocal sample and a groovy bass sound. The rhythmic background consists of an electronic drum beat. The atmosphere is urban. This piece could be used in the soundtrack of a teenage drama TV series that takes place in the ghettos of a big city. | 2006-10-31T08:01:06Z | ANARCHYE | WWW.MYBAND.RO\DJ MARCO | ["Scratching (performance technique)", "Music"] | ["dj performance", "turntable", "scratching", "hip-hop", "male vocal sample", "groovy bass line", "electronic drums", "hip", "urban"] | 9 | hgJK2ZDgWtU | 4125 |
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;