musiccaps_details (view)
4 rows where musiccaps_aspects contains "rock", musiccaps_aspects contains "upbeat" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 60 ✖
- rock · 4 ✖
- upbeat · 4 ✖
- youthful · 4 ✖
- fast tempo 3
- catchy 2
- dance groove 2
- energetic 2
- instrumental 2
- intense drumming 2
- keyboard harmony 2
- pop rock 2
- amplified guitar riff 1
- amplified instruments 1
- animated 1
- boisterous 1
- boomy bass line 1
- buoyant 1
- burgeoning harmony 1
- captivating 1
- classic rock 1
- club music 1
- cymbals 1
- dance hits 1
- dance music 1
- dj 1
- electric guitar feedback 1
- electric guitar melody 1
- electrifying 1
- electronic music 1
- engaging 1
- enthusiastic 1
- excessive reverb 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- hard rock 1
- heavy metal 1
- inferior audio quality 1
- intense 1
- intense electric guitar lead 1
- keyboard accompaniment 1
- loud 1
- male singer 1
- metal 1
- muddled song 1
- muddled vocals 1
- peppy 1
- pulsating 1
- punchy 1
- punk rock 1
- retro rock 1
- sonic power 1
- steady drumming 1
- synth rock 1
- synthesiser arrangement 1
- synthesiser articulation 1
- upbeat vivacious 1
- vibrant 1
- vigorous drumming 1
- vivacious 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[100105 HQ]Rainbow レインボー ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | This is a fast tempo song. The audio quality is inferior so the vocals are muddled making it difficult to comprehend if the vocalist is a male or female. The music is incoherent too but it is possible to identify synth arrangements, intense drumming, boomy bass lines,and keyboard harmony with spirited vocals. The song is upbeat and has a dance groove. It is a pop rock/ synth rock. | 2010-01-05T12:43:13Z | KoreanRainbow | [100105 HQ]Rainbow ''Gossip Girl'' Dance Practice for Kim Jung Eun's Chocolate | ["Music", "Tambourine"] | ["fast tempo", "energetic", "buoyant", "peppy", "punchy", "dance hits", "club music", "dance groove", "dj", "upbeat", "synthesiser arrangement", "electronic music", "boomy bass line", "intense drumming", "inferior audio quality", "excessive reverb", "youthful", "rock", "pop rock", "dance music", "muddled vocals", "muddled song"] | 7 | 5DDg2CzAmgE | 644 | |
Forgotten Suns - Walk On | A male vocalist sings this enthusiastic Rock. The tempo is fast and upbeat with a vigorous electric guitar lead and harmony, hard hitting drums and amplified keyboard. The music is an energetic, boisterous, youthful, enthusiastic, engaging, pulsating and electrifying Hard Rock. | 2006-12-13T08:02:40Z | tyepennington | Footage taken from a gig at The Mandarin Club on 5th August 2006. | ["Music", "Rock music", "Progressive rock", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "sonic power", "cymbals", "youthful", "pulsating", "electrifying", "enthusiastic", "amplified instruments", "vigorous drumming", "intense electric guitar lead", "keyboard harmony", "upbeat", "energetic", "loud", "boisterous", "enthusiastic", "metal", "heavy metal", "pop rock", "dance groove"] | 7 | J9ZlahUawkg | 1975 | |
Duquesne Whistle Copyright blocked Audio Joh Pink Rig.Steam Trains, Art, Bob Dylan etc | This song is an instrumental. The tempo is medium with an interesting electric guitar riff and subtle keyboard followed by energetic drumming, Funky bass lines and keyboard arrangement. The song gradually builds up and is catchy, youthful, upbeat, melodious, captivating and groovy. This song is Soft Rock. | 2012-09-25T05:45:20Z | conncork | Copyright Duquesne Whistle blocked replaced by music van google. Audio-informatie voor deze video Artiest: Joh Nummer: Pink Rig Duur: 06:20 Genre: RockSteam Trains America Europe Art Bob Dylan etc. Music Joh Pink Rig van Google. Bob Dylan Duquesne Whistle Tempest Bob Dylan steam trains Duluth, Minnesota America people Lizard Paintings | ["Blues", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "amplified guitar riff", "intense", "captivating", "groovy", "burgeoning harmony", "youthful", "catchy", "upbeat", "engaging", "captivating", "steady drumming", "funky bass line", "keyboard accompaniment", "rock", "classic rock", "retro rock"] | 7 | R-aMYx9f0Ho | 2658 | |
Super Smash Bros 64 move swap | This song is an instrumental. The tempo is fast with an animated keyboard harmony, funky bass lines; groovy electric guitar melody, slick drumming and synthesiser arrangements. The instrumental is upbeat, catchy, vibrant, animated, youthful and vivacious. This song is an Electro Rock/ Synth Rock. | 2009-04-18T22:29:08Z | YoYoSpln | Super Smash Bros 64 move swap HEX | ["Music", "Ambient music"] | ["instrumental", "fast tempo", "synthesiser articulation", "electric guitar melody", "keyboard harmony", "upbeat", "vivacious", "youthful", "electric guitar feedback", "groovy bass lines", "intense drumming", "animated", "vibrant", "catchy", "youthful", "upbeat vivacious", "rock", "synth rock", "punk rock"] | 7 | VNjYW4OXqTs | 2996 |
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;