musiccaps_details (view)
3 rows where musiccaps_aspects contains "funny" and musiccaps_aspects contains "male vocal"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- funny · 3 ✖
- male vocal · 3 ✖
- electronic drums 2
- amusing 1
- automation-like singing 1
- bass guitar 1
- bizarre 1
- brass 1
- comedic 1
- comedy 1
- electric guitar 1
- female vocal 1
- folk dance 1
- hip 1
- hip-hop 1
- mashup 1
- mexican folk music 1
- piano 1
- playful 1
- rapping 1
- sarcastic 1
- shout-like singing 1
- sound effects 1
- synth 1
- video game theme 1
musiccaps_names (array) 6 ✖
- Music 3
- /t/dd00032 1
- Happy music 1
- Rhythm and blues 1
- Soundtrack music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
D-Tent Boys - Dig It (OST The Holes) [Official Music Video] [Exclusive!] | This is a comedic hip-hop music piece. There is a male vocal rapping in the lead. The melody in the beat is being played by the piano and the electric guitar while a bass guitar plays in the background. The rhythm is provided by an electronic drum beat. The piece has an amusing aura to it. It could be used in the background of funny social media content. | 2011-03-10T08:32:03Z | KhleoTeeFanPaqe | follow mee aht www.twitter.com/@khleo_t .... YouuTube Haters Lehs Goo ! | ["Music", "Soundtrack music", "Happy music"] | ["comedy", "hip-hop", "male vocal", "rapping", "piano", "electric guitar", "bass guitar", "electronic drums", "funny", "amusing", "hip"] | 9 | -jpbCWcz2pk | 78 | |
Flappy Bird Song // 10 Minuten | This is the comedic mashup used as a video game theme. There is a synth and an electronic drum beat playing the theme of "I'm a Barbie Girl". There is a male vocal and a female vocal singing in an automated fashion in the English language but with a German accent. They are singing the same tune as "I'm a Barbie Girl" but with different lyrics. There is an 8-bit sound effect related to the game. There is a sarcastic atmosphere in the piece, but it is also a bit bizarre in nature. | 2014-02-12T21:23:11Z | kevin21383 | I,m a Flappy Bird in a Super Mario World but now i,m dead and will never come back. | ["Music", "Rhythm and blues", "Zing"] | ["video game theme", "mashup", "male vocal", "female vocal", "automation-like singing", "synth", "electronic drums", "sound effects", "funny", "comedic", "sarcastic", "bizarre"] | 9 | P8nK4i8XscM | 2509 | |
Los Pajaritos de Tacupa Michoacan-Flor De Limon | This is a Mexican folk music piece. There is a male vocal singing at a very elevated volume that resembles shouting. There is a brass melody playing alongside the vocal. The atmosphere of the piece is playful. The best use for this piece could be as an accompaniment for a folk dance. It could also be used in the soundtrack of a comedy movie or a TV show that takes place in Mexico. | 2009-03-06T01:36:01Z | Esekocho561 | ["Music", "/t/dd00032"] | ["mexican folk music", "male vocal", "shout-like singing", "brass", "playful", "funny", "folk dance"] | 9 | vKjC5HTH22o | 5173 |
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;