musiccaps_details (view)
5 rows where musiccaps_aspects contains "hip-hop", musiccaps_author = 9 and musiccaps_names contains "Rapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- electronic drums 5
- hip-hop · 5 ✖
- male vocal 4
- rapping 4
- hip 3
- urban 3
- energetic 2
- groovy 2
- playful 2
- ad-lib 1
- aggressive 1
- amusing 1
- bass 1
- brass sample 1
- child voice 1
- christmas music 1
- dance music 1
- danceable 1
- electric guitar 1
- female vocal 1
- female voice sample 1
- festive 1
- flamboyant singing 1
- groovy bass 1
- keyboard 1
- loud 1
- male vocals 1
- medium tempo 1
- modern sounding 1
- piano 1
- r&b 1
- rap music 1
- rap-like singing 1
- shuffle 1
- skating 1
- sleigh bells 1
- strong bass 1
- urban sounds 1
musiccaps_names (array) 6 ✖
- Hip hop music 5
- Music 5
- Rapping · 5 ✖
- Electronica 1
- Jingle, tinkle 1
- Skateboard 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SWEET TEE - LET THE JINGLE BELLS ROCK | This is a Christmas music piece in the style of hip-hop. There is a child voice announcing the arrival of Santa. The male vocalist is rapping. There is a groovy bass line in the beat. The rhythmic background is provided by an electronic drum beat that has sleigh bells in it. The atmosphere is festive and amusing at the same time. This piece could be used in the soundtrack of a comedic Christmas movie. | 2014-12-24T20:28:41Z | NandoGames RetroTech | ["Music", "Rapping", "Jingle, tinkle", "Hip hop music"] | ["hip-hop", "christmas music", "child voice", "male vocal", "rapping", "groovy bass", "electronic drums", "sleigh bells", "festive", "amusing", "urban"] | 9 | J_Raltj-6dk | 2021 | ||
Ariana Grande Rap rapping singing THE WAY ft. Mac Miller | This is an r&b/hip-hop music piece. There is a male vocal rapping and a female vocal singing in a rap-like manner. The beat consists of a piano playing the chords of the tune with an electronic drum backing. The atmosphere of the piece is playful and energetic. This piece could be used in the soundtrack of a high school drama movie/TV show. It could also be played at birthday parties or beach parties. | 2013-10-11T08:10:43Z | Only Best | Like and Subscribe if you like Ariana! | ["Music", "Rapping", "Hip hop music", "Electronica"] | ["r&b", "hip-hop", "male vocal", "rapping", "female vocal", "rap-like singing", "piano", "electronic drums", "energetic", "hip", "danceable", "playful", "modern sounding"] | 9 | UcabTrKowlI | 2929 | |
Hip Hop Academy Sid Shuffle | This is a hip-hop dance music piece. There is a male vocalist who is singing in a flamboyant manner. There is an electric guitar playing the melody joined by a strong bass sound. There is a groovy, urban atmosphere. This piece can be used as an accompaniment piece in modern dancing courses. | 2013-09-15T18:15:10Z | HipHopAcademy08 | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "dance music", "shuffle", "male vocal", "flamboyant singing", "electric guitar", "bass", "electronic drums", "playful", "groovy", "hip", "urban", "energetic"] | 9 | V9EFYFKlYbE | 2976 | ||
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 | |
Chamillionaire Paul Wall-N Luv Wit My Money | This is a hip-hop music piece. There is a male vocal rapping in the lead. The beat has a brass sample and a female voice sample. There is a strong bass sound. The rhythmic background is composed of a hip-hop electronic drum beat. There is an urban atmosphere. This piece could be playing in the soundtrack of a car street-racing video game. | 2007-08-07T18:05:41Z | Valentin Hristov | chamillionaire slideshow | ["Music", "Rapping", "Hip hop music"] | ["hip-hop", "male vocal", "rapping", "brass sample", "female voice sample", "strong bass", "electronic drums", "hip", "urban"] | 9 | x85BtdoxRek | 5306 |
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;