musiccaps_details (view)
2 rows where musiccaps_aspects contains "male vocal" and musiccaps_aspects contains "video game theme" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- male vocal · 2 ✖
- video game theme · 2 ✖
- acoustic jazz drums 1
- automation-like singing 1
- bizarre 1
- cheerful 1
- comedic 1
- complex 1
- dreamy 1
- electronic drums 1
- female vocal 1
- funny 1
- gibberish singing 1
- jazz 1
- mashup 1
- piano 1
- sarcastic 1
- sound effects 1
- synth 1
- upright bass 1
- vibraphone 1
musiccaps_names (array) 5 ✖
- Music 2
- Rhythm and blues 1
- Roll 1
- Soul 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 |
---|---|---|---|---|---|---|---|---|---|---|
Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 | |
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 |
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;