musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "no voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- bass · 3 ✖
- instrumental 3
- moderate tempo · 3 ✖
- no voice · 3 ✖
- distortion guitar 2
- classic rock 1
- guitar harmonics 1
- guitar lick 1
- guitar solo 1
- hammond organ 1
- happy mood 1
- hard rock 1
- minimal instruments 1
- power percussion 1
- rock drums 1
- rock song 1
- scratch harmonics 1
- simple percussion 1
- speed metal 1
- upbeat song 1
- whammy bar dive bomb 1
musiccaps_names (array) 13 ✖
- Music 2
- Bass drum 1
- Cacophony 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Percussion 1
- Punk rock 1
- Rimshot 1
- Rock music 1
- Snare drum 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 | |
Dio - Time to Burn | This rock song features a guitar solo played on a guitar with heavy distortion. The solo starts off with high pitch notes being played. This is followed by a dive bomb using the whammy bar. The guitar then plays a descending lick followed by scratch harmonics and another descending run. This is accompanied by percussion playing a powerful rock beat in common time. The bass plays the root notes of the chords. Another distortion guitar plays power chords to back the lead guitar. There are no voices in this song. This song can be used in a car chase sequence in a movie. | 2007-03-20T01:01:01Z | Pablo A. | Dio - Time To Burn Sacred Heart: The Video 86' | ["Music", "Cacophony"] | ["rock song", "guitar solo", "distortion guitar", "moderate tempo", "guitar harmonics", "scratch harmonics", "whammy bar dive bomb", "speed metal", "no voice", "instrumental", "power percussion", "bass"] | 0 | PQ7cX2Cnusg | 2533 | |
Led Zeppelin - Rock and Roll (Madison Square Garden 1973) | This hard rock song features a distortion guitar playing aggressive riffs. This is accompanied by a rock percussion playing a simple rock beat with a roll at the end. The bass guitar plays the root notes of the chord with a flourish to move to the subsequent note. There are no voices in this song. This is an instrumental song. | 2011-11-30T15:18:24Z | Led Zeppelin | Watch Led Zeppelin perform their song 'Rock And Roll' live at Madison Square Garden in New York City in July 1973 from The Song Remains the Same. The Song Remains the Same has been reissued with audio remastered by Jimmy Page! Order your copy here https://lnk.to/TSRTS More info about this show: http://www.ledzeppelin.com/show/july-... ► Listen to Mothership https://lnk.to/StreamMothership ♪ Watch all episodes of Led Zeppelin History https://lnk.to/LedZeppelinHistoryID 🕭 Subscribe to the Led Zeppelin channel https://lnk.to/YTLedZeppelinSubID Official Led Zeppelin Playlists: ☑ Led Zeppelin - Essentials https://lnk.to/YTLedZeppelinEssentialsID 📽 The Led Zeppelin Rare Film Series https://lnk.to/LedZeppelinRareFilmID 🎚 Led Zeppelin - Alternative Mixes & Deep Cuts https://lnk.to/LedZeppelinAltMixID Stay Connected with Led Zeppelin: ♪ Website http://www.ledzeppelin.com 🎛 Facebook http://www.facebook.com/ledzeppelin 🎙 Twitter http://www.twitter.com/ledzeppelin 🎞 Instagram https://www.instagram.com/ledzeppelin --------------------------------------------------------------------------------------------------------------------- The Led Zeppelin channel is the band’s official YouTube home, featuring a catalog of official live performances, official music videos, Led Zeppelin History, archival footage, and Zeppelin-approved playlists. 🕭 Subscribe to join the Led Zeppelin YouTube community and check back for new uploads, product announcements, and updates from the band Led Zeppelin formed in 1968 and went on to become one of the most influential, innovative, and successful groups in modern music, having sold more than 300 million albums worldwide. The band rose from the ashes of The Yardbirds, when Jimmy Page brought in John Bonham, John Paul Jones, and Robert Plant to tour as The New Yardbirds. In 1969, Led Zeppelin released its self-titled debut which was produced by Page, as were all the subsequent albums. It marked the beginning of a 12-year reign, during which the group was widely considered to be the … | ["Music", "Punk rock", "Rock music"] | ["hard rock", "distortion guitar", "guitar lick", "no voice", "instrumental", "rock drums", "bass", "moderate tempo", "upbeat song"] | 0 | XgXOW3lX25Y | 3212 |
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;