musiccaps_details (view)
8 rows where musiccaps_aspects contains "acoustic guitar strumming" and musiccaps_author = 8
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| ΠΑΡΕ ΜΕ ΑΠΟΨΕ ΑΓΚΑΛΙΑ | Mellow rock with a slow drum beat, acoustic strumming guitar, male and female vocalists singing in octaves. | 2009-01-19T13:00:52Z | kreta1giouli1cagapaw | Gia pragmatika erwteumenous pou 3anazoun to oneiro ap thn arxh.. | ["Christian music", "Music"] | ["acoustic guitar strumming", "slow rock", "male and female singing in octaves", "mellow"] | 8 | 5rsQHo-6DI4 | 700 | |
| Magasin - Eraserheads (Paolo Santos Cover) | instrumental rock music with a drum kit, lots of cymbal crashes, acoustic guitar strumming, harmonized lead guitars and an active bass guitar. | 2008-02-07T23:57:50Z | joaq25 | Song:Magasin Artist:Eraserheads(This version sang by Paolo Santos) | ["Music", "Rock music", "Progressive rock"] | ["rock", "four chord jam", "drum kit", "cymbal crashes", "acoustic guitar strumming", "harmonized lead guitars", "active bass guitar", "instrumental"] | 8 | 9kt7rsziUVQ | 1038 | |
| diane cluck - focus on their eyes | Intentionally lo-fi bedroom recording of acoustic guitar strumming, knocking and fingerstyle playing. Finger snaps can also be heard. There is a slightly muffled room reverb over everything. Has an indie folk DIY aesthetic. | 2010-05-20T23:30:43Z | frinkianz | focus on their eyes | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["diy", "solo guitar", "acoustic guitar strumming", "room reverb", "lo-fi", "knocking on guitar", "fingerstyle", "finger snapping", "bedroom recording", "indie", "slightly", "hazy muffled", "folk"] | 8 | BI8YQ3ueD24 | 1226 | |
| Dr. Zwig - Sunshine Waves (Official Live Music Video) | A mid-tempo two chord vamp on a roots rock song. The music is instrumental, featuring a strummed acoustic guitar, drum set, electric guitar, and pedal steel. The feeling is melancholic. | 2014-06-25T00:13:04Z | Dr. Zwig | "Sunshine Waves" official live music video by Dr. Zwig. From the EP, 'Stones, Bones, And Skin' https://goo.gl/3cjzQz Stream / Buy: Apple Music / iTunes: https://goo.gl/DwQwp5 Spotify: https://goo.gl/8BDQuF Google Play: https://goo.gl/bXd58N Amazon: https://goo.gl/LchWW5 CD: https://goo.gl/wV1gxP Vinyl: https://goo.gl/pVdxCE CONNECT: http://DrZwig.com http://facebook.com/DrZwig http://twitter.com/Dr_Zwig http://instagram.com/DrZwig http://consciousrecords.com Copyright Adam Zwig 2014 Combustible Music / BMI Conscious Records LLC Album: Stones, Bones, And Skin Director/Producer: Randy Edwards Director/DP: Christian Meyers | ["Music", "Pop music", "Ska"] | ["roots rock", "acoustic guitar strumming", "drum set", "pedal steel", "electric guitar", "mid-tempo", "vamp", "melancholic", "two chords"] | 8 | KE-TVQhdCbs | 2069 | |
| Mary Stayed out all Night ep11 JGS humming to Hello Hello | Soft singer songwriter folk rock with a gentle male vocal and acoustic guitar strumming. The vocal production is quite loud. Music for an international artsy cafe. | 2010-12-16T14:57:24Z | Yu Xuan | http://www.mediafire.com/?pgt748y3pe8yptb | ["Humming", "Music", "Song"] | ["loud vocal production", "singer songwriter", "gentle male vocals", "acoustic guitar strumming", "open chords", "soft feel", "folk rock", "cafe", "international"] | 8 | Rdwtr2IX8ek | 2717 | |
| How to play - You don't know - Milow - on guitar - guitar lesson - gratismuziekschool.nl | Amateur recording of solo acoustic guitar strumming. Tape hiss, room reverb and unintentional mic clipping is audible throughout. | 2010-01-19T19:13:20Z | Fast Track Music Lessons | Click here for more free Guitarlessons http://www.gratismuziekschool.nl/gitaarles.html | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["acoustic guitar strumming", "room reverb", "tape hiss", "amateur recording", "unintentional mic clipping"] | 8 | Wh5JSj89tW8 | 3124 | |
| Two Ton Strap - "Sink" | Punk rock with a country twang, featuring an acoustic guitar strumming, an overdriven electric guitar playing lead, multiple male vocalists, male background vocals and a simple chord progression. The drums play an uptempo country beat, or "train beat" more specifically. The kind of band you might hear at a pub in a semi-rural suburb. | 2010-06-30T20:05:16Z | mynameistrue | This was done in one shot, one take and no practice. Two Ton Strap is Koko, Motown, Dan and Kan "Sink" recorded by Max Moulton for Milton Records (on the old banjo -- sorry Brooks!) Directed by Kevyn Gilbert Dan sock-puppet / Kan sock-puppet: T-Bone Koko sock-puppet / Curtains: Peter Nelson White Bread Motown / Architecture: Dirty Uncle Wil (of The Darkness of Country http://www.youtube.com/user/darknessofcountry) A.V. Engineer / Curtains: Dirty Cousin Carl (of the Sub-Fobias http://www.myspace.com/thesubfobias) Special thanks to Xahra, Grace and Harlo for letting us borrow stuff. Look for the upcoming album "Bare Country" Remember kids, for every puppet you see on stage there is a grown man drunk and lying on the floor. | ["Music", "Independent music", "Psychedelic rock", "Progressive rock"] | ["punk rock", "twang", "cow punk", "acoustic guitar strumming", "overdriven electric guitar lead", "multiple male vocalists", "male background vocals", "uptempo country beat", "train beat", "simple chord progression", "pub"] | 8 | e1KHGfMekek | 3835 | |
| Alan Parsons Project - Time | A sweet, melancholy sounding soft rock song with a male singer accompanied by acoustic guitar strumming, a cello counter melody, piano, simple electric bass, and a slow rock drum beat. | 2009-09-09T07:18:53Z | BachChannel | No description. | ["Singing", "Music", "Tender music"] | ["soft rock", "cello counter melody", "male singer", "melancholy", "acoustic guitar strumming", "piano accompaniment", "sweet", "slow rock drum beat", "simple bass", "electric bass guitar"] | 8 | too9MtXBwts | 5068 |
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;