musiccaps_details (view)
2 rows where musiccaps_aspects contains "steady drumming" and musiccaps_names contains "Scratch"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- steady drumming · 2 ✖
- accelerated rhythm 1
- amateur sound recording 1
- calm background music 1
- catchy beat 1
- chaotic 1
- dissonant music 1
- distorted sound 1
- dj mixer 1
- electric guitar melody 1
- electronic pop 1
- fast forwarding sound 1
- fast tempo 1
- groovy beat 1
- incoherent sounds 1
- inferior sound quality 1
- instrumental 1
- keyboard harmony 1
- loud 1
- mellow background music 1
- metal scratching 1
- muffled electronic sounds 1
- muffled music 1
- noisy 1
- psychedelic 1
- reverb 1
- table turner 1
- trance 1
- trap 1
- turntable 1
- unpleasant 1
- vocal riff 1
musiccaps_names (array) 5 ✖
- Music 2
- Scratch · 2 ✖
- Beatboxing 1
- Drum machine 1
- Scratching (performance technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
keumart Mouth scratch freestyle | This song is an electronic instrumental. It is medium tempo with a recurring vocal riff, steady drumming, table turner arrangement and distorted sounds like metal scratching. The audio is muffled, making it difficult to hear the finer elements of the song.The repetitive beats and rhythm give it a trippy, psychedelic and trance vibe. | 2011-10-31T23:04:06Z | keumart | Keumart Da Green Sayaman Double Swiss Beatbox Champion from "Shaolin Beat Masterz" | ["Beatboxing", "Music", "Scratch", "Drum machine"] | ["distorted sound", "vocal riff", "groovy beat", "table turner", "muffled music", "steady drumming", "catchy beat", "electronic pop", "trap", "psychedelic", "trance", "incoherent sounds", "metal scratching", "loud", "unpleasant", "amateur sound recording", "reverb"] | 7 | KWpsFxRTGkI | 2090 | |
DJ KANZER SCRATCH FRESHHHHHHH | This song is an instrumental. The tempo of the background music is slow , with electric guitar harmony and rhythmic drum with loud chaotic, dissonant sounds. The music is out of sync as the unidentifiable sounds are accelerated. | 2009-02-17T05:38:13Z | djkanzertv | ["Scratching (performance technique)", "Music", "Scratch"] | ["instrumental", "mellow background music", "steady drumming", "keyboard harmony", "electric guitar melody", "fast tempo", "calm background music", "accelerated rhythm", "chaotic", "noisy", "turntable", "dj mixer", "muffled electronic sounds", "fast forwarding sound", "dissonant music", "inferior sound quality"] | 7 | bl-eQ8XD5CY | 3648 |
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;