musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional" and musiccaps_aspects contains "no other instrumentation"
This data as json, CSV (advanced)
musiccaps_aspects (array) 72 ✖
- emotional · 5 ✖
- no other instrumentation · 5 ✖
- medium tempo 4
- home video 3
- instrumental music 3
- passionate 3
- poor audio quality 3
- spirited 3
- groovy 2
- guitar technique 2
- no percussions 2
- youtube music video 2
- aboriginal music 1
- amateur play 1
- amateur quality recording 1
- ancient art form 1
- bad audio quality 1
- bad audio recording 1
- blues influences 1
- blues lick 1
- casual 1
- classical music 1
- deep 1
- didgeridoo 1
- double tonguing 1
- echo tone 1
- electric guitar lead 1
- energetic 1
- entertaining 1
- ethnic instruments 1
- fast tempo 1
- guitar a 1
- guitar amplifier 1
- guitar lead 1
- guitar solo 1
- heavy breathing sounds 1
- learner 1
- legato playing 1
- live demo 1
- live performance 1
- lovely 1
- male music video 1
- melancholic 1
- moody blues 1
- note bending 1
- percussive rhythm 1
- percussive tones 1
- playing rhythm guitar 1
- plification 1
- poignant music 1
- poor quality video 1
- recital 1
- relaxing 1
- romantic 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- solo guitar 1
- solo guitarist 1
- solo instrumentalist 1
- soloist 1
- sound check 1
- technique and expertise 1
- tenor sax 1
- tremolo effect 1
- ukulele online lessons 1
- ukulele player 1
- ukulele strummed fast 1
- vibrato style 1
- wind instrument 1
- youthful 1
- youtube cover 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender FSR Limited Edition Deluxe Reverb RI | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | 2012-05-09T06:39:38Z | Thomas Fargo | Testing the amp with Lollar P-90s | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | 1 | 6_zzu2KON6c | 768 | |
ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 | |
中村たかし 情熱大陸 「誰かに聴かせたくなるウクレレ・ソロ」 | The song is an instrumental. The song is medium tempo with a ukulele played with a fast strumming technique. The song is groovy and melancholic. The song audio quality is poor but is very relaxing to listen to. | 2011-05-15T09:24:54Z | ttcafelele | 中村たかし 情熱大陸(サンプル動画) 「誰かに聴かせたくなるウクレレ・ソロ」 タブ譜付きスコア 「誰かに聴かせたくなるウクレレ・ソロ」ドレミ楽譜出版社 映画・TV・CM主題歌集〜模範演奏CD付き 中村たかし編 2625円(税込み) | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["live performance", "ukulele player", "instrumental music", "relaxing", "casual", "fast tempo", "technique and expertise", "ukulele online lessons", "poor audio quality", "ukulele strummed fast", "lovely", "entertaining", "passionate", "groovy", "no other instrumentation", "youtube music video", "live demo", "youtube cover", "melancholic", "emotional"] | 1 | PaQGXIh94uc | 2546 | |
EXPERIMENTAL BEATBOX: ethnic instruments. Didgeridoo. | The song is an instrumental. The song is medium tempo with a didgeridoo playing percussively with double tonguing motion and no other instrumentation. The song is emotional and meditative. The song is an aboriginal instrument played in a home studio. | 2012-09-24T17:51:19Z | Vladislav Ramanovsky | Vladislav Ramanovsky "Offbeat" http://vk.com/ramasails. More interesting videos here - http://www.youtube.com/Offbeatboxing - Experimental beatboxing SUBSCRIBE!!! https://plus.google.com/u/1/114037025738537505056/posts | ["Didgeridoo", "Music"] | ["didgeridoo", "solo instrumentalist", "percussive tones", "amateur quality recording", "ethnic instruments", "wind instrument", "double tonguing", "aboriginal music", "medium tempo", "emotional", "poignant music", "no other instrumentation", "percussive rhythm", "ancient art form", "male music video", "heavy breathing sounds"] | 1 | R4jlQEweREY | 2664 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 |
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;