musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "video game soundtrack" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- medium fast tempo 2
- passionate · 2 ✖
- video game soundtrack · 2 ✖
- arcade games 1
- bells ring 1
- building anticipation 1
- death metal music 1
- eerie 1
- energetic 1
- fake punching sounds 1
- fast drumming rhythm 1
- fast metal drumming 1
- fight club 1
- game soundtrack 1
- groovy bass line 1
- groovy music 1
- inorganic sounds 1
- inspiring 1
- instrumental musical retro game track 1
- keyboard harmony 1
- male singer 1
- midi music 1
- never give up 1
- scary 1
- spirited 1
- story telling 1
- string section hits 1
- techno music 1
- vintage game music 1
musiccaps_names (array) 4 ✖
- Music 2
- Angry music 1
- Slam 1
- Speech 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ArcheAge - Archer 50 lvl pvp, DollVasta (19.04.14) | A male singer sings these whispering vocals. The song is medium fast tempo with a fast metal drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is tense and full of suspense. The song is a game soundtrack. | 2014-04-19T14:38:05Z | b1shock | DollVasta(BIOSHOCK,BIOPWNZ) | ["Music", "Speech", "Angry music"] | ["death metal music", "male singer", "game soundtrack", "building anticipation", "fast drumming rhythm", "medium fast tempo", "video game soundtrack", "passionate", "energetic", "scary", "eerie", "fast metal drumming", "groovy bass line", "story telling", "inspiring", "keyboard harmony"] | 1 | LLDHkHHKYkI | 2179 | |
[TAS] SNES Saturday Night Slam Masters by Cooljay in 14:02.5 | The song is an instrumental. The song is medium fast tempo with a techno drumming rhythm, keyboard harmony and synth string pad tones. The song is inorganic and exciting. The audio quality is poor and vintage in quality. | 2014-12-14T15:05:05Z | TASVideosChannel | This is a tool-assisted speedrun. For more information, see http://tasvideos.org/2736M.html. TAS originally published on 2014-12-14. Saturday Night Slam Masters is a 2d wrestling game by Capcom that offers a repertoire of throws, special moves and finishers for all wrestlers. It also features the Mayor of Metro City Mike "Macho" Haggar from the Final Fight series as a guest character. In this 4 minutes improvement, Cooljay chose a better character and found a new trick. | ["Music", "Slam"] | ["bells ring", "fake punching sounds", "techno music", "arcade games", "vintage game music", "passionate", "spirited", "never give up", "fight club", "midi music", "instrumental musical retro game track", "groovy music", "string section hits", "inorganic sounds", "video game soundtrack", "medium fast tempo"] | 1 | B_tbkQYT9N0 | 1262 |
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;