musiccaps_details (view)
2 rows where musiccaps_aspects contains "sloppy" and musiccaps_names contains "Flamenco" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- sloppy · 2 ✖
- amateur recording 1
- cover 1
- flamenco 1
- low quality 1
- mono 1
- noisy 1
- nylon string guitar 1
- repetitive acoustic rhythm guitars chord progressions 1
- rock 1
- technically challenging 1
- two acoustic guitars 1
musiccaps_names (array) 9 ✖
- Flamenco · 2 ✖
- Music 2
- Acoustic guitar 1
- Blues 1
- Guitar 1
- Independent music 1
- Musical instrument 1
- Plucked string instrument 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
John Catalano Music : Dean Patton Rumba Flamenco in the States Two Talented Young Guitarist | Amateur recording of two nylon string guitars playing in flamenco style. The playing is technically challenging yet sloppy. | 2007-02-18T02:35:10Z | John Catalano | facebook.com/jphncatalanomusic 717-623-7166 John Catalano Teacher Saturday Classes in Gypsy Rumba at Catalano Music . Flamenca Rumba is lively music and developing in the United States Of America as here shown by the young guitar players. Gypsy Rumba In the 1990s the French group Gypsy Kings of Spanish descent became a popular New Flamenco group by playing Rumba Flamenca (or rumba gitana, Catalan rumba) music. | ["Blues", "Flamenco", "Music", "Independent music", "Rhythm and blues"] | ["amateur recording", "two acoustic guitars", "flamenco", "nylon string guitar", "technically challenging", "sloppy"] | 8 | -_OzT7Xyvok | 64 | |
Best Acoustic Guitar Songs. 31 songs in 10mins | The low quality recording features a cover of a rock song that consists of repetitive acoustic rhythm guitars chord progressions. The progression is played a bit sloppy and the recording is noisy. | 2012-05-31T13:05:34Z | Camydallas | Dear Kind Viewer, First of all i'd like to say thank you for watching my video, it is greatly appreciated. I have been overwhelmed by the success of this video as well as the communication it has given me with my subscribers. I am aware the i haven't posted much recently and i like to fix that!! Please leave a comment or suggestion of what you'd like to see more of and i promise i'll take everyone's suggestions into account when making future videos! :) Thanks again, Cameron NEW VIDEOS!! My band Ukin good ( https://www.facebook.com/UkinGood ) are going to be posting a lot more videos in the near future please keep in touch with opinions and suggestions! They are always welcome! :) Here's a link to our latest cover HIDEAWAY by KIESZA - https://www.youtube.com/watch?v=J_wt2Q7nYqM&list=UU5wXhl1zs7xPFoGMvTKWraw FULL SONG LIST AND TIMES BELOW! Wow! 200,000+ views!! Thank you so much to everyone that's watched, commented and shared!! :) Sorry that I've not been able to reply to questions and requests but i had no idea what my password was! However, as of now I will be able to speak to you lovely people! :) Any comments, questions, suggestions and requests are welcome! And I promise more exciting news and videos soon!!! :D Many Thanks, Camy Dallas One Take! 31 covers of the best songs to play on acoustic guitar, with No Tab. Too Close - Alex Clare 00:00 Bonkerz - Dizzee Rascal 00:21 Lonely Boy - The Black Keys 00:37 Superstition - Stevie Wonder 00:49 5 Years Time - Noah and the Whale 01:10 Pumped up Kicks - Foster the People 01:35 Kids - MGMT 01:54 A-Punk - Vampire Weekend 02:13 Better Together - Jack Johnson 02:29 Twist and Shout - The Beatles 02:49 Under the Bridge - RHCP 03:08 Stray Cat - Kassidy 03:30 Don't Go - Josh Kumra 03:45 Party Rock Anthem - LMFAO 04:11 Don't Stop - Foster the People 04:28 The Wolves - Ben Howard 04:43 Starships - Nicki Minaj 05:10 Golden Skans - The Klaxons 05:28 Miracles - Hot Chocolate 05:46 Can't Stop - RHCP 06:07 Fire - Kasabian 06:31 R U Mine? - The Arctic M… | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "repetitive acoustic rhythm guitars chord progressions", "noisy", "mono", "rock", "cover", "sloppy"] | 4 | d0Uz_RnRV88 | 3755 |
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;