musiccaps_details (view)
4 rows where musiccaps_author = 8 and musiccaps_names contains "Strum"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| Mia Rose - Just Us | Low-fidelity recording of a female singer displaying vocal virtuosity and melisma, accompaniment by strummed steel string acoustic guitar. | 2008-06-29T15:38:01Z | Mia Rose | Official site: http://www.Officialmiarose.com Official Twitter: http://www.twitter.com/officialmiarose Official Facebook: http://www.facebook.com/Miaroseworld Professional/Media Contact: info@officialmiarose.com Hey, Here's an original song of mine! I wrote it a couple of days ago! Hope you enjoy =) Mia Lyrics Sometimes in the dark of the night brings confusion you cant find the right from wrong you live for With everything changing, your feelings inside you wanna find comfort in somebody's eyes travelled through passed pain and finally what I found is That with you everything just melts away and its just us... Just us.... Sometimes when feel yourself slipping away You cant find the truth from the lie you live for With everything moving, your fears come alive you wanna find true love, in somebody's eyes wandered through hurricanes and finally what I found is That with you everything just melts away and its just us... Just us.... That with you my true love will always remain Just us Just us... | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["female singer", "melisma", "vocal virtuosity", "strummed acoustic guitar", "steel string guitar", "low-fidelity recording"] | 8 | KyRJP_fDrbk | 2136 | |
| BELAJAR GITAR SHAGGY DOG DI SAYIDAN | happy music featuring a solo acoustic strummed guitar playing open chords, quiet male singing, and a bird chirping in the background. | 2015-09-11T05:14:36Z | FERDI Alfarizi | ["Flamenco", "Acoustic guitar", "Music", "Strum"] | ["acoustic guitar", "strumming", "open chords", "bird chirping", "quiet male vocals", "singing", "low fidelity", "happy"] | 8 | MPe6ztPtF0Y | 2263 | ||
| Flamenco guitar - Livio Gianola - Sicomoro | Solo nylon string acoustic guitar played fingerstyle in a flamenco tradition. The guitar has lower bass notes than a regular 6 string guitar. | 2010-02-17T13:39:12Z | Veojam | Livio Ganola plays his tarantas "Sicomoro" on eight strings flamenco guitar. Check https://www.veojam.com/spanish_flamenco for more flamenco guitar videos | ["Flamenco", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["solo guitar", "nylon string acoustic guitar", "fingerstyle", "flamenco", "low bass notes", "extended range guitar", "free time"] | 8 | n3EeS2mVU5w | 4514 |
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;