musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "minimal instruments" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- instrumental · 2 ✖
- minimal instruments · 2 ✖
- moderate tempo · 2 ✖
- no voice 2
- bass 1
- classic rock 1
- hammond organ 1
- happy mood 1
- jazz song 1
- no percussion 1
- piano 1
- repetitive melody 1
- simple percussion 1
- trombone 1
- uplifting mood 1
musiccaps_names (array) 11 ✖
- Bass drum 1
- Brass instrument 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Hi-hat 1
- Percussion 1
- Rimshot 1
- Snare drum 1
- Trombone 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 | |
WMB-14-002 ルパン三世のテーマ'78(トロンボーン・ソロ) | This jazz song is an instrumental song featuring a trombone playing the main melody. The trombone is accompanied by a piano playing chords using jazz rhythms. The tone changes at the end to an uplifting mood. There is no percussion in this song. This song can be used in a highway driving scene in a movie. | 2014-02-28T03:40:24Z | めちゃモテ・シリーズ | ★管楽器プレイヤーのための新しいソロ楽譜"めちゃモテ"シリーズ ~トロンボーン~ 演奏:前田大輔 編曲:前田大輔、小林真人 大野雄二によって作曲された、モンキー・パンチ原作のテレビアニメ「ルパン三世」の主題歌。数多くのテーマがある中で最も親しまれている「ルパン三世TV第2シリーズ」で使用されたヴァージョンとなっています。 原曲の雰囲気を生かしたアレンジになっており、誰でもカッコ良く演奏できる一曲です。 演奏に使われている楽譜の購入はコチラから ↓伴奏CD付楽譜 http://brass.winds-score.com/?pid=71753227 | ["Brass instrument", "Trombone"] | ["jazz song", "trombone", "piano", "no percussion", "no voice", "instrumental", "minimal instruments", "moderate tempo", "repetitive melody", "uplifting mood"] | 0 | AlVr7-ntuqw | 1166 |
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;