musiccaps_details (view)
3 rows where musiccaps_author = 9 and musiccaps_names = "["Music", "Rapping", "Hip hop music"]"
This data as json, CSV (advanced)
Suggested facets: youtube_description, youtube_published (date)
musiccaps_aspects (array) 23 ✖
- electronic drums 3
- hip 2
- hip-hop 2
- male vocal 2
- urban 2
- aggressive 1
- bass 1
- brass sample 1
- czech 1
- dance music 1
- electric guitar 1
- energetic 1
- female voice sample 1
- flamboyant singing 1
- groovy 1
- loud 1
- male vocals 1
- playful 1
- rap 1
- rapping 1
- shuffle 1
- strong bass 1
- synth 1
musiccaps_names (array) 3 ✖
- Hip hop music 3
- Music 3
- Rapping 3
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
Smack Igor Ty nevíš co sem dělal dřív | This is a Czech rap music piece. There is a male voice rapping in the Czech language. There is a medium-pitch synth playing the melody. The medium tempo electronic drum beat carries the rhythmic background. The atmosphere of the piece is loud and aggressive. This piece could be used in the soundtrack of a crime movie taking place in Central Europe. | 2012-11-19T13:02:12Z | Radek Betyár | ["Music", "Rapping", "Hip hop music"] | ["rap", "czech", "male vocals", "synth", "electronic drums", "aggressive", "loud"] | 9 | tQ1Nl4Dy2aI | 5035 | ||
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;