musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "happy", musiccaps_names contains "Keyboard (musical)" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| The Evolution of Nintendo Music | The low quality recording features a groovy piano melody, played over, groovy bass guitar, punchy kick and snare hits, shimmering hi hats, shimmering crash cymbal and short electric guitar lick. It sounds energetic, fun, happy, joyful and like an in-game video game sound. | 2014-06-04T07:21:43Z | New Game Plus | Facebook: https://www.facebook.com/pages/New-Game-Plus/482456688541187 Twitter: https://twitter.com/NewGamePlusBand All of the compositions in this video belong to Nintendo/the companies who created the games, we claim no ownership of them whatsoever. This is The Evolution of Nintendo Music, which goes all the way up from the NES to the Wii (Note that for arrangement purposes, we decided to go by system rather than strictly chronologically). When we first saw "The Video Game Rock Medley" by FreddeGredde, we thought to ourselves "why isn't there MORE stuff like this out there?" So, right then and there, New Game Plus was born, and we started creating this medley. The final product turned out to be 22 songs packed into 9 minutes of phenomenal music! Enjoy. Song timestamps (spoilers ahead!): NES: 0:00 - Overworld Theme (Super Mario Bros 2) 0:07 - Dr. Wily's Castle (MegaMan 2) 0:26 - Fever (Dr. Mario) 0:53 - Vampire Killer (Castlevania) 1:19 - Excitebike Title Theme (Excitebike) SNES: 1:28- Jungle Japes (Donkey Kong Country) 2:02 - Gourmet Race (Kirby Super Star) 2:25 - Yearnings of the Wind (Chrono Trigger) N64: 2:51 - Facility (GoldenEye 007) 3:19 - Gerudo Valley (The Legend of Zelda: Ocarina of Time) 3:51 - Grunty's Furnace Fun (Banjo Kazooie) 4:23 - Majora's Theme (The Legend of Zelda: Majora's Mask) 4:58 - Diddy Kong Racing Title Theme (Diddy Kong Racing) Game Boy: 5:23 - Trainer Battle (Pokémon) 5:48 - Theme A (Tetris) GameCube: 6:04 - Gamecube startup (Gamecube) 6:12 - Metroid Prime Title Theme (Metroid Prime) 6:44 - Menu 1 (Super Smash Bros Melee) Wii: 7:15 - Wii Shopping Channel Theme (Wii System Music) 7:38 - Green Greens (Kirby's Epic Yarn) 8:04 - Hyrule Field Theme (The Legend of Zelda: Twilight Princess) 8:47 - Zelda's Lullaby (Various Legend of Zelda games) And of course shout outs to the spectacular composers that have come up with these various themes, without you video game music (and music in general for that matter) would not be the same today. Thanks for all of the inspiration. | ["Video game music", "Guitar", "Music", "Musical instrument", "Keyboard (musical)", "Piano"] | ["low quality", "punchy snare", "shimmering hi hats", "groovy bass guitar", "short electric guitar lick", "groovy piano melody", "shimmering crash cymbal", "energetic", "fun", "happy", "joyful", "in game sound"] | 4 | IjP5kKfgBiI | 1934 |
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;