musiccaps_details (view)
3 rows where musiccaps_aspects contains "spirited" and musiccaps_aspects contains "techno music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- spirited · 3 ✖
- techno music · 3 ✖
- electronic music 2
- animated 1
- arcade games 1
- bells ring 1
- buoyant 1
- club music 1
- dance music 1
- dance pop 1
- deep house 1
- digital drums 1
- digital music 1
- duet 1
- enthusiastic 1
- fake punching sounds 1
- fast tempo 1
- fight club 1
- futuristic 1
- groovy music 1
- hard rock 1
- informative 1
- inorganic sounds 1
- instrumental music 1
- instrumental musical retro game track 1
- intense 1
- intense drumming 1
- last tempo heavy metal 1
- lively 1
- lively singing 1
- male vocalists 1
- male voice speaking 1
- medium fast tempo 1
- midi music 1
- never give up 1
- passionate 1
- review 1
- shakers 1
- string section hits 1
- synthesiser arrangements 1
- video game music 1
- video game soundtrack 1
- vigorous 1
- vintage game music 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | This song is a lively duet by two male voices. The tempo is fast with amplified piano, infectious drumming; tambourine beats and synthesiser arrangements. The song is youthful,fun, happy, groovy, energetic, buoyant, and high spirited. This song is called Deep House. | 2012-12-31T17:35:29Z | Theboxen21 | Per Andersson ''Pump up the Jam'' (Så ska det låta 2012) | ["Music", "Ska"] | ["male vocalists", "duet", "fast tempo", "electronic music", "spirited", "buoyant", "club music", "dance music", "dance pop", "techno music", "digital music", "synthesiser arrangements", "deep house", "lively", "youthful", "shakers", "digital drums", "lively singing"] | 7 | 6-MdbipzKS0 | 712 | |
[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 | |
Top 10 Robots | This music is an electronic instrumental. The tempo is fast with heavily synthesised arrangements and intense drumming with a male voice speaking over the music. The music is intense, vigorous,animated, futuristic and vital. It sounds like video game music and the male voice seems to be reviewing Video Games. | 2015-05-16T05:12:56Z | GameTrailers | Sometimes, when you need a friend, you have to build one. We assemble all the greatest creations in video games and determine who is the most loyal and effective. | ["Music", "Speech", "Angry music"] | ["instrumental music", "vigorous", "animated", "spirited", "enthusiastic", "intense drumming", "last tempo heavy metal", "hard rock", "electronic music", "video game music", "male voice speaking", "intense", "electronic music", "techno music", "futuristic", "review", "informative"] | 7 | Xn0wIqnt_44 | 3223 |
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;