musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "strumming" and musiccaps_author = 8 sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- strumming · 3 ✖
- acoustic guitar 2
- low fidelity 2
- bird chirping 1
- electric guitar 1
- folk 1
- happy 1
- heartfelt 1
- live recording 1
- open chords 1
- overdrive 1
- passionate male singer 1
- quiet male vocals 1
- rock 1
- singer-songwriter 1
- singing 1
- warm 1
musiccaps_names (array) 10 ✖
- Music 3
- /t/dd00003 1
- Acoustic guitar 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Flamenco 1
- Harmonic 1
- Outside, urban or manmade 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Little Apple - 2014 Hot Song in China | A male singer-songwriter accompanied by a strummed acoustic guitar and singing passionately a heartfelt folk song. The recording is somewhat low fidelity and live. | 2014-07-31T04:21:01Z | 2014 Boyz | Hottest Holy Song for Square Dancing | ["Music", "/t/dd00003", "Outside, urban or manmade"] | ["low fidelity", "live recording", "acoustic guitar", "passionate male singer", "singer-songwriter", "strumming", "heartfelt", "folk"] | 8 | 3tK7PpCo0PQ | 512 | |
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 | ||
Greer Amps Southland Harmonic Overdrive - Top Boost Gear | Solo performance of an electric guitar player strumming chords. The tone is overdriven and warm. The genre is rock. | 2014-10-17T13:45:51Z | Top Boost Gear | Available at WWW.TOPBOOSTGEAR.COM! The Southland Harmonic Overdrive is built on the Lightspeed Organic Overdrive platform, we have developed what we believe to be the best overdrive on the market. The Lightspeed was built with the specific purpose of being a light to mild overdrive. The Southland is the next logical step for the Lightspeed platform—more gain, with two stages of clipping (utilizing different diode types for each stage of clipping), a focused midrange (not that annoying “hump”), and a bit of presence on top of the signal, to help cut through the mix. The Southland Harmonic Overdrive, like the Lightspeed, is touch sensitive, responds to pick attack, and has dynamics that just won’t stop. On top of that, we’ve selected a chip to drive the Southland that takes it to the next level. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "overdrive", "strumming", "rock", "warm"] | 8 | NzvkMWY4EjA | 2387 |
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;