musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Flamenco" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 8 ✖
- uptempo · 2 ✖
- acoustic guitar 1
- amateur recording 1
- flat male vocal 1
- low quality 1
- muffled acoustic rhythm guitar 1
- noisy 1
- tremolo 1
musiccaps_names (array) 6 ✖
- Flamenco · 2 ✖
- Music 2
- Acoustic guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nadia (ja re ja moo dho ke aa) :P by Mohib ur Rahman | The low quality recording features a flat male vocal singing over muffled acoustic rhythm guitar. The recording is very noisy, it sounds uptempo and like it is recorded via phone. | 2010-06-16T12:24:34Z | Mohib ur rahman | lyrics: baal hain ye.... ya gaai ki dum... gandey tery daant.... uss pe ganda ye moo.... kholey jo tu moo ..... tou aaey badboo.... Nadia nadia o rey nadia nadia nadia o rey nadia... ja rey ja..... moo dho key aa.. ja rey ja..... moo dho key aa... dekhey jo tujhey...... dar jaaey woh.. choo le tu jisse ..... Allah bachaaey uss ko.. Nadia nadia o rey nadia.. Nadia nadia o rey nadia ja rey ja... moo dho key aa.. ja rey ja..... moo dho key aa... Jo baney tera yaar.... us ka jeena dushwaar jisey ho gaya tujh se pyaar....... nahi us se bara koi khuaar... nadia nadia o rey nadia... nadia nadia o rey nadia... ja rey ja.... moo dho ke aa... ja rey ja.... moo dho key aa.. | ["Flamenco", "Music"] | ["low quality", "noisy", "flat male vocal", "muffled acoustic rhythm guitar", "uptempo"] | 4 | EJMUwh1vY2s | 1544 | |
How to Play the Guitar Tremolo Classical & Flamenco Style | An acoustic guitar being played walking down the fretboard using a tremolo finger picking technique. This song may be playing at home practicing guitar. This is an amateur recording. | 2012-11-02T22:27:52Z | Play & Sing With Alexandros | Hey guys! :} Well here ~it~ is! :D The Video that hundreds of you have requested from me. ;) Tremolo Guitar and how to Practice, Play ~it~ AND Develop ~it~ with some extra Exercises to further develop your Technique! Stay 'tuned' for MORE & MORE Guitar Videos by Subscribing to my Channel: http://www.youtube.com/giveorlooseit Thank you for watching my Guitar Friend! See ~you~ on the next Video! God Bless~ ----------------------------------------------------------------- If you like to help & Support me Please consider Donating ANY amount to Paypal here: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=YHKP93QNB87LN&source=url ~~Thank YOU MY GUITAR FRIEND~~ * PS: Want to learn this AND many more Picking Styles & Sing HUNDREDS of Songs??? Have NO fear! My E-Book is here: 25 Fingerstyle Techniques & Over 10 Styles of Music + 50 MP3's: http://store.payloadz.com/go?id=766057 (Paypal SAFE & 40% OFF!!) * Life is Music & Music is Life.. Without Music there can be no Life! God Bless~ * #GiveOrLooseIt #Guitar_Tremolo_Lesson #Classical_Guitar_Techniques | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["acoustic guitar", "tremolo", "amateur recording", "uptempo"] | 6 | X_nfMNpw9SA | 3197 |
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;