musiccaps_details (view)
2 rows where musiccaps_aspects contains "drum rolls" and musiccaps_aspects contains "groovy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- drum rolls · 2 ✖
- groovy music · 2 ✖
- ambient crowd noise 1
- arcade game soundtrack 1
- building tension 1
- crowd noise 1
- crowds cheering 1
- cymbal crashes 1
- cymbals crashing 1
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- energetic 1
- excitement 1
- game play 1
- guitar strumming rhythm 1
- instrumental music 1
- intense battle 1
- keyboard accompaniment 1
- live audience 1
- live performance 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- metal music 1
- party night 1
- passionate 1
- people singing along 1
- percussive bass line 1
- poor audio quality 1
- pop song 1
- retro game tracks 1
- spirited 1
- strong rock drumming 1
- suoerfats drumming rhythm 1
- valour and pride 1
- very bad audio quality 1
- video games 1
- virtuoso guitar lead 1
- warriors fight 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Flaming Lips - Race For The Prize | A male singer sings this passionate melody accompanied by crowds who are singing along and cheering. The song is in medium tempo with a strong drumming rhythm, cymbals crashing, steady bass line and keyboard accompaniment. The song has extremely bad audio quality. | 2007-04-17T01:29:13Z | Rob Oldham | Gainesville, FL. FREE show on 4/15/2007 at Flavet Field on the UF campus. Stardeath and White Dwarfs and The Rapture were the openers. AWESOME show! If the first 8 minutes of a Flaming Lips show don't bring a sense of pure joy to your heart - then you've got a lump of coal living in there. It is one of the great moments in ROCK! | ["Music", "Independent music", "Rock music", "Bellow"] | ["male singer", "very bad audio quality", "cymbals crashing", "people singing along", "crowd noise", "medium tempo", "strong rock drumming", "guitar strumming rhythm", "drum rolls", "pop song", "live audience", "live performance", "party night", "excitement", "crowds cheering", "groovy music", "party night", "ambient crowd noise", "keyboard accompaniment"] | 1 | e4EwrAN6lvU | 3839 | |
bakugan dimensions game play | The song is an instrumental. The tempo is medium fast with a percussive bass line, super fast metal drumming with cymbal crashes and fast drum rolls and a distorted guitar playing a virtuoso lead. The song is energetic and animated. The song has poor audio quality. | 2010-07-12T05:45:38Z | bradjr10 | more game play of bakugan dimensions | ["Heavy metal", "Music", "Cacophony"] | ["instrumental music", "metal music", "poor audio quality", "energetic", "passionate", "building tension", "warriors fight", "dragon quest", "dangerous journey", "valour and pride", "groovy music", "intense battle", "medium fast tempo", "arcade game soundtrack", "suoerfats drumming rhythm", "distortion guitar playing lead", "percussive bass line", "virtuoso guitar lead", "spirited", "cymbal crashes", "drum rolls", "game play", "video games", "retro game tracks"] | 1 | nT_R3O0OK6U | 4541 |
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;