musiccaps_details (view)
1 row where musiccaps_aspects contains "cover", musiccaps_aspects contains "repetitive acoustic rhythm guitars chord progressions" and musiccaps_names contains "Guitar"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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;