musiccaps_details (view)
3 rows where musiccaps_aspects contains "pop song" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- pop song · 3 ✖
- accordion 1
- acoustic guitar 1
- amateur singer 1
- bad audio quality 1
- band audio quality 1
- double bass 1
- emotional 1
- fingerstyle guitar 1
- foreign language 1
- friendship 1
- heartfelt 1
- home music video 1
- inspiring 1
- instrumental 1
- love song 1
- low quality recording 1
- male singer 1
- male voice 1
- memdium tempo 1
- modern pop hits 1
- no other instruments 1
- no voices 1
- percussive strumming 1
- pop song cover 1
- romantic 1
- slow tempo 1
- song cover 1
- touching 1
- ukulele accompaniment 1
- ukulele playing rhythm 1
- violin 1
- youtube music video 1
musiccaps_names (array) 9 ✖
- Music 3
- Musical instrument · 3 ✖
- Plucked string instrument 2
- Accordion 1
- Acoustic guitar 1
- Electronic tuner 1
- Guitar 1
- Traditional music 1
- Ukulele 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 | ||
Ukulele Tutorial #54 (Count On Me, Bruno Mars) | A male singer sings this popular song. The tempo is medium with an ukulele playing rhythm accompanying the male vocals with no other instrumentation. The song is emotional and inspiring. The audio quality is bad. | 2010-07-06T19:06:01Z | Krankthat22 | NEW WEBSITE is up and running! Check it out and let me know what you think!! Feedback is much appreciated! Thank me later. Click here now! http://tinyurl.com/Krankthat22 Em - 0432 C - 0003 Am - 2000 F - 2010 Dm - 2210 G - 0121 verse/chorus C Em Am G F bridge #1 Dm Em F G Bridge #2 ("a shoulder to cry on" part of lyrics) Dm G C G | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["male singer", "ukulele accompaniment", "bad audio quality", "inspiring", "amateur singer", "ukulele playing rhythm", "memdium tempo", "song cover", "emotional", "love song", "romantic", "touching", "youtube music video", "friendship", "touching", "heartfelt", "pop song", "pop song cover", "modern pop hits", "band audio quality", "home music video"] | 1 | MpjN21Z93JY | 2302 | |
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;