musiccaps_details (view)
3 rows where musiccaps_aspects contains "classic rock" and musiccaps_aspects contains "instrumental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- classic rock · 3 ✖
- instrumental · 3 ✖
- rock 2
- ambient sounds 1
- amplified guitar 1
- amplified guitar riff 1
- background music 1
- bass 1
- burgeoning harmony 1
- captivating 1
- catchy 1
- electric guitar harmony 1
- engaging 1
- funky bass line 1
- groovy 1
- hammond organ 1
- happy mood 1
- heavy rock 1
- incoherent backup music 1
- intense 1
- keyboard accompaniment 1
- loud feedback 1
- metal 1
- minimal instruments 1
- moderate tempo 1
- no voice 1
- retro rock 1
- simple percussion 1
- slow tempo 1
- sonic power 1
- steady drumming 1
- stringed instrument 1
- subdued background music 1
- upbeat 1
- youthful 1
musiccaps_names (array) 17 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Bass drum 1
- Blues 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Steel guitar, slide guitar 1
- Tapping (guitar technique) 1
youtube_published (date) 3 ✖
- 2007-01-13 1
- 2011-09-27 1
- 2012-09-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Space Truckin' - Deep Purple | This classic rock song features a hammond organ playing the main melody. This is backed by the percussion playing a simple beat. The percussion plays the hi-hat at every count and ends with a roll at the end of every bar. The bass plays the same melody as the hammond. There are no voices in this song. This is an instrumental song. This song can be played in a bank robbery scene in a movie. | 2011-09-27T10:46:15Z | RetroTVCentral | Compilation of scenes from several scifi movies and television shows accompanied by the classic rock song Space Truckin'(1972) by Deep Purple. Movie and television scenes include: Star Wars Armageddon When Worlds Collide Lost in Space(1998) Queen of Outer Space Battlestar Galactica(1978) Total Recall Missle to the Moon The Fifth Element Planet of the Apes (1968) Mission to Mars Austin Powers: The Spy Who Shagged Me 2001: A Space Odyssey Close Encounters of the Third Kind 2001: A Space Travesty Return of the Jedi Superman 2 Space Truckers Star Trek 2: The Wrath of Khan Aliens Galaxy Quest Spaceballs Farscape This Island Earth Starship Troopers First Spaceship on Venus Forbidden Planet | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["classic rock", "simple percussion", "hammond organ", "bass", "minimal instruments", "no voice", "instrumental", "moderate tempo", "happy mood"] | 0 | 8zGJ9N7c6pE | 966 | |
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 | |
Marshall JTM-45 Bluesbreaker + Gibson SG + Slide | This music is an electric guitar instrumental. The tempo is slow with an electric guitar harmony and a subdued, incoherent background score. This music is classic Rock. | 2007-01-13T11:30:16Z | Claudio Crotti | JTM-45 Bluesbreaker and Gibson SG Slide | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar harmony", "classic rock", "incoherent backup music", "background music", "subdued background music", "ambient sounds", "loud feedback", "amplified guitar", "sonic power", "stringed instrument", "rock", "heavy rock", "metal"] | 7 | wLQiZ-0VW4c | 5258 |
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;