musiccaps_details (view)
3 rows where musiccaps_aspects contains "aggressive" and musiccaps_aspects contains "hip-hop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- aggressive · 3 ✖
- hip-hop · 3 ✖
- electronic drums 2
- strong bass 2
- ad-lib 1
- crisp synth 1
- electronic 1
- energetic 1
- groovy 1
- high-pitch synth 1
- keyboard 1
- loud 1
- loud electronic drums 1
- male vocal 1
- male vocals 1
- medium tempo 1
- melodic pad 1
- modern sounding 1
- piano sample 1
- rap 1
- rap music 1
- rapping 1
- skating 1
- trap 1
- urban sounds 1
- violent 1
- vocal sample 1
musiccaps_names (array) 8 ✖
- Music 2
- Electric piano 1
- Hip hop music 1
- Keyboard (musical) 1
- Piano 1
- Rapping 1
- Skateboard 1
- Whoop 1
youtube_published (date) 3 ✖
- 2012-10-09 1
- 2014-08-23 1
- 2015-07-30 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lil Debbie - "420" ft. Wiz Khalifa - OFFICIAL VERSION | This is a hip-hop music piece. There is a crisp synth sound playing the melody. The piece has a strong bass sound. There is a melodic pad with beat repeat effect that uses a piano sample. The rhythmic background is provided by a loud electronic drum beat. The piece is energetic and modern sounding. It could be used in the soundtrack of a sci-fi movie where there is a lot of action going on. | 2015-07-30T19:15:09Z | LiLDebbieTV | ["Electric piano", "Keyboard (musical)", "Piano"] | ["hip-hop", "electronic", "crisp synth", "melodic pad", "piano sample", "strong bass", "loud electronic drums", "modern sounding", "aggressive", "energetic"] | 9 | -YATTKBtmRA | 60 | ||
Fa$ Money- There It Go "Whoop" | This is a trap piece. There is a male vocal rapping at the forefront accompanied by a repeating hollering vocal sample. A high-pitch synth is playing an ominous melody. There is a strong bass and an electronic drum beat with cicada hiatus at the rhythmic background. The atmosphere of the song is aggressive. The piece can be used in the soundtracks of crime movies/TV series that take place in the big city. | 2012-10-09T05:33:46Z | Fast Money | Mix Tape Coming Soon!!!!! Artist: Fa$ Money Track:There It Go "Whoop" Mix Tape: Like It Love It or Just Love About It | ["Music", "Whoop"] | ["trap", "hip-hop", "male vocal", "rap", "vocal sample", "electronic drums", "high-pitch synth", "strong bass", "aggressive", "violent"] | 9 | R6lRMU-zBLA | 2671 | |
Fredrik Andersson | Razors AM | This is a rap music piece played behind a rollerskating video. The sound of the skaters can be heard faintly throughout the recording. There is a male voice rapping at the forefront while other voices can be heard singing melodically in the background and ad-libbing occasionally. There is a mild keyboard playing the tune while a loud electronic drum beat is playing the rhythm. The atmosphere of this piece is groovy and urban. | 2014-08-23T21:55:37Z | Razors Skate Co. | Presenting Razors AM, Fredrik Andersson. The world traveler comes through with this banger filmed throughout the year in Texas (USA), Amsterdam (Netherlands), Calgary (Canada), and Malaga (Spain). Edit: Anthony Medina Film: Anthony Medina, Josh Glowicki, Nils Jansons & Richie Eisler | ["Music", "Skateboard", "Rapping", "Hip hop music"] | ["rap music", "hip-hop", "male vocals", "rapping", "ad-lib", "keyboard", "electronic drums", "aggressive", "loud", "groovy", "urban sounds", "skating", "medium tempo"] | 9 | _43OOP6UEw0 | 3441 |
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;