musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop song", musiccaps_author = 0 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- pop song · 2 ✖
- accordion 1
- acoustic guitar 1
- double bass 1
- fingerstyle guitar 1
- foreign language 1
- instrumental 1
- low quality recording 1
- male voice 1
- no other instruments 1
- no voices 1
- percussive strumming 1
- slow tempo 1
- violin 1
musiccaps_names (array) 8 ✖
- Music 2
- Musical instrument · 2 ✖
- Accordion 1
- Acoustic guitar 1
- Electronic tuner 1
- Guitar 1
- Plucked string instrument 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marin Doru- Ramane masa saraca | This low quality recording features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a simple beat with a Latin feel. The bass is played on a double bass. The double bass plays a groovy bassline. Flute fills are played in the background. An accordion plays melodies in harmony with the voice. This song has romantic overtones. This song can be played at the end credits of a mafia romance movie. | 2011-04-20T14:52:21Z | Beto stylle | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["low quality recording", "pop song", "male voice", "foreign language", "accordion", "double bass", "violin"] | 0 | 2bCuw7U_Rac | 387 | ||
The Girl From Ipanema - Solo Acoustic Guitar - Adam Rafferty | This fingerstyle guitar song features a guitar playing at a slow tempo. The bass notes are also played by the same guitar. The picking pattern involves a percussive style of guitar playing. There are no other instruments in this song. This is an instrumental song. There are no voices in this song. This song has a romantic feel. This song can be played in a luxury hotel lobby. | 2013-01-13T10:18:08Z | Adam Rafferty | ► Start learning my solo arrangements and get personal guitar coaching - FREE 14 day trial: http://studywithadam.com ► Get more cool FREE lessons here: http://adamrafferty.com/lessons Hey Gang! I've had so many requests for this song, it was time to arrange this gorgeous tune for solo guitar - "The Girl From Ipanema" by Antonio Carlos Jobim. My apologies for the painful "guitar faces" - I was digging VERY hard for a deep slow, sexy groove - that took internal work & concentration - big time! If you have never heard the famous version with Astrud Gilberto, João Gilberto and Stan Getz - go listen to it. It's one of my fave recordings of all time! I know it's not a traditional boss the way I play it, it's a NY Adam type groove - I still need to learn the real Brazilian way to groove! Love Adam ------- Follow me! ► Facebook: https://www.facebook.com/adamraffertyguitar ► Instagram: https://www.instagram.com/rafferty.adam/ ► Fingerstyle Guitar HANGOUT - iTunes Podcast: https://apple.co/2GVDWoR ► Twitter: https://twitter.com/adamrafferty ► NEW - Join the "Fingerstyle Guitar Hangout Community" on Facebook ► Post your videos, chat and hang out with me and other guitar players here: ► https://www.facebook.com/groups/fingerstyleguitarhangout ► NEW book "The Inner Game of Fingerstyle Guitar" available on Amazon ► https://www.adamrafferty.com/book/ =============== | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["acoustic guitar", "pop song", "fingerstyle guitar", "percussive strumming", "instrumental", "no voices", "no other instruments", "slow tempo"] | 0 | yw6uqQQF5Ig | 5447 |
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;