musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "country", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "low quality"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 23 ✖
- country · 4 ✖
- emotional · 4 ✖
- low quality · 4 ✖
- passionate 3
- acoustic rhythm guitar 2
- noisy 2
- acoustic rhythm guitar chords 1
- acoustic sitar guitar melody 1
- arpeggiated acoustic guitar melody 1
- electric guitar solo melody 1
- flat male vocal 1
- groovy bass 1
- harmonizing vocals 1
- heartfelt 1
- joyful 1
- mandoline melody 1
- mono 1
- raw male vocal 1
- shimmering hi hats 1
- smooth bass guitar 1
- snappy rimshot 1
- soft kick hits 1
- soulful 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1977 - Bat Out of Hell Cover | The low quality recording features a, what it seems like, cover of a country song and it consists of flat male vocals singing over acoustic sitar guitar melody. It sounds very noisy, but also heartfelt and emotional. | 2011-02-11T04:06:00Z | Nightfrailer | (Practice session... This is where the magic of the 1970's hits and the bumbling frailing and drop thumb starts coming together.) The greatest song ever written maybe? | ["Banjo", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "acoustic sitar guitar melody", "flat male vocal", "noisy", "heartfelt", "country", "emotional"] | 4 | 9A_OmOetiuw | 980 | |
hero of the day - in bluegrass style - iron horse | The low quality recording features a country song that consists of a passionate male vocal singing over arpeggiated acoustic guitar melody, acoustic rhythm guitar chords, mandoline guitar melody and groovy bass. It sounds passionate, joyful and emotional. | 2008-01-06T16:36:25Z | oddis123 | Fade to Bluegrass Tribute to Metallica is available at http://www.cmhrecords.com on iTunes and retailers nationwide. Kirk Hammett also likes this tribute! Check out the interview here: http://youtube.com/watch?v=jdh_0H77Dkc | ["Country", "Music", "Bluegrass"] | ["low quality", "country", "groovy bass", "arpeggiated acoustic guitar melody", "acoustic rhythm guitar chords", "mandoline melody", "passionate", "joyful", "emotional"] | 4 | dzPPmuFUicc | 3832 | |
The Best Old Country Music | The low quality recording features a country song being played on an acoustic rhythm guitar and raw male vocal singing over it. It sounds passionate and emotional, even though the recording is noisy and in mono. | 2006-10-08T02:28:23Z | papachya | Original, Real, Old Country Music from a Great Guy, my Father | ["Country", "Music", "Bluegrass"] | ["low quality", "noisy", "mono", "country", "acoustic rhythm guitar", "raw male vocal", "emotional", "passionate"] | 4 | fDMbNCdGXBc | 3931 | |
The Singing Cooke's--Family Circle | The low quality recording features a country song that contains harmonizing vocals singing over electric guitar solo melody, smooth bass guitar, acoustic rhythm guitar, snappy rimshots, shimmering hi hats and soft kick hits. It sounds soulful, emotional and passionate. | 2010-12-11T03:34:48Z | Nexar41834 | ["Gospel music", "Christian music", "Music", "Happy music"] | ["low quality", "country", "harmonizing vocals", "electric guitar solo melody", "smooth bass guitar", "snappy rimshot", "shimmering hi hats", "soft kick hits", "acoustic rhythm guitar", "soulful", "emotional", "passionate"] | 4 | mlpTCec4igo | 4490 |
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;