musiccaps_details (view)
3 rows where musiccaps_aspects contains "country" and musiccaps_aspects contains "heartfelt"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- country · 3 ✖
- emotional 3
- heartfelt · 3 ✖
- passionate 2
- acoustic sitar guitar melody 1
- flat male vocal 1
- fruity male vocal 1
- hopeful 1
- keys chords 1
- low quality 1
- noisy 1
- percussive acoustic rhythm guitar 1
- repetitive arpeggiated acoustic guitar 1
- simple bass 1
- soft female vocal 1
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 | |
Possibility - Sierra Noble [OFFICIAL MUSIC VIDEO] (cc) | The Country song features a soft female vocal singing over repetitive arpeggiated acoustic guitar melody. It sounds heartfelt, emotional, passionate and hopeful, like something you would listen to when having a tough time. | 2009-04-29T06:57:28Z | sierranoblemusic | Official music video for Sierra Noble's "Possibility" - April 2009 www.sierranoble.ca Directed by: Jeth Weinrich www.redworldeditions.com www.myspace.com/jethweinrich Maple Music Recordings, Canada | ["Music", "Sad music"] | ["emotional", "soft female vocal", "country", "repetitive arpeggiated acoustic guitar", "passionate", "heartfelt", "hopeful"] | 4 | UIOnnpaqBy8 | 2904 | |
George Jones - Colour of the Blues - Country Music Experience | The Country song features a fruity male vocal singing over percussive acoustic rhythm guitar, simple bass and keys chords. It sounds emotional, passionate and heartfelt - like something you would hear in the old pubs and bars. | 2012-10-07T07:52:56Z | Country Music Experience | Country Music Experience : (Re)Discover the finestcountry Music Selection. Country Music experience is your channel for all the country music, where you can experience music, in high audio quality. Subscribe to stay connected to our channel and receive all of our video updates! -Country Music experience | ["Christmas music", "Music"] | ["country", "percussive acoustic rhythm guitar", "keys chords", "fruity male vocal", "emotional", "passionate", "heartfelt", "simple bass"] | 4 | tGic59TlrVg | 5022 |
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;