musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "parody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic drums · 2 ✖
- parody · 2 ✖
- amateur recording 1
- bass guitar 1
- comedic 1
- e-bass 1
- electric guitar 1
- gibberish 1
- kids voice streaming 1
- male vocal 1
- medium to uptempo 1
- out of tune 1
- percussion 1
- reggae 1
- trumpets 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
AGK Angry German Kid vs Stacey Hedger-Star Wars Trumpet Solo | This audio contains an acoustic drum playing a groove along with a simple bassline. Trumpets are playing a melody that sounds out of tune and all over the place while a kids voice is streaming and you can hear some aggressive clicking sounds. This song may be playing for a parody video. | 2007-11-11T13:53:01Z | nexiva | Angry German Kid takes on his most talentless opponent yet: Stacey Hedger, from the infamous "Star Wars Trumpet Solo" pageant video. This continues the tradition of the AGK videos where fake english subtitles are overlayed the original vision, and intercut with a cult internet video. | ["Brass instrument", "Trumpet"] | ["amateur recording", "kids voice streaming", "trumpets", "acoustic drums", "e-bass", "out of tune", "parody", "medium to uptempo"] | 6 | -mB_XLq6g1g | 84 | |
Guinney Pepper ft Chewbacca - Lick Di Chalice | This is a tongue-in-cheek version of a reggae song edited to make it sound like a movie character was featured in it. It has a male vocal that starts singing with a Jamaican accent that turns into gibberish. Clean electric guitar and bass guitar provide the melodic background while the acoustic drums and percussion play a basic reggae beat for the rhythmic background. | 2012-03-08T03:22:22Z | Baidawi | Star Wars 2015. The Force Awakens. Chewbacca. | ["Music", "/t/dd00032"] | ["reggae", "male vocal", "gibberish", "electric guitar", "bass guitar", "acoustic drums", "percussion", "comedic", "parody"] | 9 | 7ZXz3Xa7APs | 859 |
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;