musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "manic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- groovy bass · 4 ✖
- low quality 4
- manic · 4 ✖
- aggressive 2
- energetic cymbals 2
- punchy kick 2
- punchy snare 2
- brass melody 1
- chaotic 1
- distorted static sound 1
- distorted wide electric guitars 1
- dj scratching sound effect 1
- energetic 1
- energetic crash cymbals 1
- energetic muffled drums 1
- filtered echoing flat male vocal 1
- groovy piano 1
- jungle 1
- metal 1
- mono 1
- muffled 1
- noisy 1
- repetitive piano melody 1
- rock 1
- screaming female vocal 1
- shimmering cymbals 1
- snare rolls 1
- soft kick 1
- soft snare 1
- strings melody 1
- thin 1
- uptempo electric guitar melody 1
- woodwinds melody 1
musiccaps_names (array) 10 ✖
- Music 3
- Angry music 1
- Brass instrument 1
- Clarinet 1
- Drum machine 1
- Roll 1
- Saxophone 1
- Scratch 1
- Scratching (performance technique) 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nightcore Fight Inside | The low quality recording features a metal song that consists of a screaming female vocal singing over punchy kick and snare hits, energetic cymbals, groovy bass guitar, wide distorted electric guitars, strings melody and repetitive piano melody. At the very end of the loop, there is a short distorted static sound. It sounds energetic, aggressive and manic. | 2012-08-10T08:11:02Z | Tobias Fritz Holm | Like and Subscribe. picture: http://i1.ytimg.com/vi/BscoQHJrNm8/maxresdefault.jpg | ["Music", "Angry music"] | ["low quality", "metal", "screaming female vocal", "punchy snare", "energetic cymbals", "punchy kick", "repetitive piano melody", "distorted wide electric guitars", "groovy bass", "strings melody", "energetic", "aggressive", "manic", "distorted static sound"] | 4 | BscoQHJrNm8 | 1300 | |
Partitura Brasileirinho samba jazz solo e improviso, flauta e trombone. | The low quality recording features shimmering cymbals, brass melody, woodwinds melody, groovy piano, groovy bass and soft kick and snare hits played altogether. It sounds chaotic and manic. | 2014-02-04T21:14:11Z | jeferson ramos | ["Brass instrument", "Clarinet", "Saxophone", "Trombone"] | ["low quality", "shimmering cymbals", "brass melody", "woodwinds melody", "groovy piano", "groovy bass", "soft kick", "soft snare", "manic", "chaotic"] | 4 | KLFoZA8btu4 | 2075 | ||
The Toy Dolls - PC Stoker | The low quality recording features a rock song that consists of filtered echoing flat male vocals, energetic muffled drums, energetic cymbals, snare rolls, uptempo electric guitar melody and groovy bass. It sounds manic and muffled, like it lacks the bass and overall frequency balance. | 2007-11-01T06:29:55Z | MBSS20 | Check out some punk gear: https://www.occultpunkshirts.com/one-offs.html The Toy Dolls Video of PC Stoker 1986 Promo. | ["Music", "Roll"] | ["low quality", "rock", "filtered echoing flat male vocal", "energetic muffled drums", "energetic cymbals", "snare rolls", "manic", "uptempo electric guitar melody", "groovy bass", "muffled"] | 4 | bpwO0lbJPF4 | 3655 | |
traktor scratch pro 2 ...practice session dubstep | The low quality recording features a DJ scratching a vinyl of a jungle song that consists of punchy kick and snare hits layered with energetic crash cymbal and groovy bass. The song sounds thin as it is probably playing on a speaker. The recording itself is noisy and in mono. It sounds energetic and aggressive overall. | 2010-05-12T19:13:21Z | djTech-ROCKETfaders | traktor scratch pro 2 ...practice session dubstep | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["dj scratching sound effect", "manic", "aggressive", "mono", "jungle", "punchy kick", "punchy snare", "energetic crash cymbals", "groovy bass", "thin", "noisy", "low quality"] | 4 | cWOohqFud6g | 3712 |
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;