musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "hip hop" and musiccaps_aspects contains "punchy kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- groovy 5
- groovy bass · 5 ✖
- hip hop · 5 ✖
- low quality 5
- punchy kick · 5 ✖
- punchy snare 5
- shimmering hi hats 5
- flat male vocal 3
- brass melody 2
- energetic 2
- upbeat 2
- animated music video 1
- background male vocals 1
- blood spillage sound effects 1
- bouncy 1
- bright 1
- chill 1
- dj scratching sounds 1
- easygoing 1
- exciting 1
- fruity male vocal 1
- funky electric guitar 1
- groovy piano chords 1
- groovy synth keys melody 1
- grunting sound effects 1
- mellow piano chord progression 1
- reverberant 1
- reverberant female vocal melody 1
- sword slicing sound effect 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Breakin Part 1, Final Dance Battle | The low quality recording features a hip hop song that consists of a flat male vocal rapping over punchy kick and snare hits, shimmering hi hats, DJ scratching sound effects and groovy bass. It sounds energetic, upbeat and groovy. | 2009-12-10T11:29:51Z | babeygurl05 | Final dance battle at the club, Ozone, Turbo and Kelly win! | ["Scratching (performance technique)"] | ["low quality", "hip hop", "punchy snare", "dj scratching sounds", "punchy kick", "groovy bass", "flat male vocal", "shimmering hi hats", "upbeat", "groovy", "energetic"] | 4 | A5fPSkTvjmY | 1067 | |
Skibadee + Bashy MC FACEOFF 1XTRA | The low quality recording features a hip hop song where a fruity male vocal is rapping over punchy kick and snare hits, shimmering hi hats, groovy bass and brass melody. It sounds bouncy, groovy and upbeat. | 2007-04-17T08:17:05Z | danshish | Skibadee + Bashy MC FACEOFF on 1XTRA then some other mc's | ["Drum and bass", "Electronic music", "Music", "Rapping", "Hip hop music"] | ["low quality", "hip hop", "fruity male vocal", "brass melody", "punchy kick", "punchy snare", "shimmering hi hats", "groovy bass", "groovy", "bouncy", "upbeat"] | 4 | YZvv4hOlNqw | 3294 | |
Whimper | The low quality recording features a hip hop song that consists of groovy bass, groovy piano chords, shimmering hi-hats and punchy kick and snare hits over sword slicing, blood spillage and grunting sound effects. Overall the song is very groovy, bright and judging by the volume of the sounds, it could be an Animated Music Video. | 2012-12-02T16:12:34Z | SaladUK | Xperiment - Stayin' Steady http://www.facebook.com/saladuk http://www.twitter.com/saladuk http://vine.co/saladuk | ["Music", "Wail, moan"] | ["low quality", "hip hop", "groovy bass", "grunting sound effects", "blood spillage sound effects", "animated music video", "sword slicing sound effect", "groovy piano chords", "punchy kick", "punchy snare", "shimmering hi hats", "bright", "groovy"] | 4 | n3X8RGZsGg4 | 4516 | |
Destruct - Time's Up [Official Music Video] | The low quality recording features a hip hop song that consists of flat male vocals talking over reverberant female vocal melody, punchy snare and kick hits, shimmering hi hats, groovy bass and mellow piano chord progression. It has a lot of reverb on it and it sounds easygoing, chill and groovy - like something you would listen to on a car ride. | 2012-06-29T08:09:36Z | destructmc | Download the album "Leaving yet?" for free @ http://www.destructmusic.com/album/leaving-yet Add Me @ http://www.facebook.com/mcdestruct Follow Me @ https://twitter.com/mcdestruct Guest starring Marz Prod. by Michael Omar Perez Directed by Jacqueline Arevalo DP by Ace Fillmore Edited by Komprza Subscribe now to http://www.youtube.com/destructmc Cop That fresh gear @ http://www.facebook.com/Faktnclothing | ["Music", "Hip hop music", "Tender music"] | ["low quality", "hip hop", "flat male vocal", "reverberant female vocal melody", "punchy snare", "punchy kick", "shimmering hi hats", "groovy bass", "mellow piano chord progression", "easygoing", "chill", "groovy", "reverberant"] | 4 | nrcfdP6LrLo | 4583 | |
Fabolous, Jay Z, & Young Jeezy F A B O L O U S Vol 2 Block On Smash | The low quality recording features a hip hop song that consists of a flat male vocal, alongside some background male vocals, rapping over punchy kick and snare hits, shimmering hi hats, funky electric guitar, brass melody, groovy synth keys melody and groovy bass. It sounds energetic, groovy and exciting. | 2009-08-07T17:12:38Z | briellehursl21 | ["Music", "Rapping", "Hip hop music"] | ["hip hop", "punchy snare", "punchy kick", "funky electric guitar", "brass melody", "groovy synth keys melody", "groovy bass", "shimmering hi hats", "flat male vocal", "background male vocals", "energetic", "groovy", "exciting", "low quality"] | 4 | x6U1gX5a_4M | 5304 |
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;