musiccaps_details (view)
3 rows where musiccaps_aspects contains "bossa nova" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- bossa nova · 3 ✖
- acoustic drums 1
- bass guitar 1
- brazilian 1
- electric guitar 1
- fiesta 1
- fingerstyle 1
- giro 1
- guitar solo 1
- instrumental 1
- instrumental music 1
- jam 1
- jazz 1
- keyboard styles 1
- latin dance groove 1
- latin dancers 1
- latin jazz music 1
- latin percussion instruments 1
- madly in love 1
- medium tempo 1
- memdium tenpo 1
- music keyboard demo 1
- no singer 1
- nylon string acoustic 1
- old school romance 1
- party time 1
- passioante affair 1
- passionate 1
- passionate affair 1
- rhodes organ 1
- romantic 1
- sensual 1
- soft 1
- solo guitar 1
- spirited 1
- tranquil 1
- various percussion hits 1
musiccaps_names (array) 12 ✖
- Music 3
- Musical instrument · 3 ✖
- Acoustic guitar 2
- Guitar 2
- Plucked string instrument 2
- Chorus effect 1
- Effects unit 1
- Jazz 1
- Keyboard (musical) 1
- Piano 1
- Strum 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue Bossa - Achim Kohl - Jazz Guitar Improvisation with Tabs | This is an instrumental jazz improvisation piece with heavy bossa nova influences. There is an over-arching bossa nova syncopation not only being played by the acoustic drums in the backing track but also followed by the electric rhythm guitar and the bass guitar. The lead is a guitar solo being played by a gentle sounding electric guitar. Although there are complex chords and riffs, the general atmosphere is tranquil. This piece could be playing in the background of a restaurant. It could also be included in the soundtrack of a movie during serene scenery. | 2013-03-11T13:08:58Z | Achim Kohl | played with my Gibson ES 137 Custom, If you want to play a transcription of this solo, go to https://www.klangfarbe-noten-shop.de/en/blue-bossa-solo.html | ["Guitar", "Jazz", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["jam", "jazz", "bossa nova", "no singer", "instrumental", "electric guitar", "guitar solo", "bass guitar", "acoustic drums", "soft", "sensual", "tranquil"] | 9 | AgtY6m-b3Gk | 1155 | |
Korg PA900 vs Roland BK9 Keyboard | The song is an instrumental. The song is medium tempo with various Latin percussion playing groovily to the sounds of a Rhodes organ melody. The song is romantic and passionate. The soundtrack is a demonstration for a keyboard model. | 2013-10-16T18:45:43Z | A&C Hamilton Musical Instruments | http://www.achamilton.co.uk/Korg/PA900/index.htm We thought we should do a quick video comparison of the Korg PA900 and Roland BK-9. This is just a small example of similar styles and sounds in the instruments. Which would you prefer? | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["latin dance groove", "bossa nova", "giro", "madly in love", "passioante affair", "old school romance", "passionate affair", "medium tempo", "latin percussion instruments", "memdium tenpo", "rhodes organ", "various percussion hits", "latin jazz music", "latin dancers", "romantic", "party time", "fiesta", "romantic", "spirited", "passionate", "keyboard styles", "instrumental music", "music keyboard demo"] | 1 | LKVSEQCLCLo | 2177 | |
AC-33 Acoustic Chorus Guitar Amplifier featuring Alex Hutchings | solo acoustic nylon string guitar playing in a fingerstyle Brazilian bossa nova style. | 2010-02-25T05:59:50Z | RolandChannel | http://www.roland.com/products/en/AC-33/ Worlds First AA Battery-Powered Acoustic Guitar Amp! Rich, deep, stereo sound to go — introducing the AC-33, the worlds first AA battery-powered amp made specifically for acoustic guitar. Portable yet powerful, the AC-33 provides true stereo sound, Guitar and Mic/Line channels, custom-tailored effects, anti-feedback, and a Phrase Looper. But this amp was made to go places no amp has gone before. Thanks to its battery-power capability, the AC-33 lets you take your act anywhere — into the backwoods, onto the streets, or wherever your imagination leads you. | ["Effects unit", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic", "fingerstyle", "bossa nova", "brazilian"] | 8 | ZVvX2-ldhvY | 3387 |
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;