musiccaps_details (view)
2 rows where musiccaps_aspects contains "country blues" and musiccaps_names contains "Bluegrass" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- country blues · 2 ✖
- accordion melody 1
- acoustic guitar harmony 1
- acoustic guitar melody 1
- blues 1
- country music 1
- country song 1
- empahtic electric guitar feedback 1
- empahtic melody 1
- fiddle 1
- flat male vocal 1
- instrumental 1
- intense 1
- low quality 1
- melancholy 1
- mono 1
- noisy 1
- nostalgic 1
- powerful 1
- regional music 1
- rugged 1
- sentimental 1
- slow tempo 1
- sustained brass section 1
- vintage 1
- vivid 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Country blues music | This music is instrumental. The tempo is slow with an acoustic guitar harmony, loud electric guitar feedback and fiddle. The music is intense, rugged, vivid, melancholic, pensive, raw, powerful, emphatic and strong. This music is classic Blues Country Music. | 2012-07-29T11:41:29Z | PROMETHEUS | Country, blues song :D | ["Blues", "Country", "Music", "Bluegrass"] | ["instrumental", "slow tempo", "melancholy", "vivid", "empahtic melody", "rugged", "powerful", "country blues", "blues", "country music", "country song", "regional music", "empahtic electric guitar feedback", "acoustic guitar harmony", "country music", "intense", "rugged", "fiddle"] | 7 | cGorUmWMrwo | 3693 | |
Walter Rhodes - The Crowing Rooster (1927) | The Country Blues song features a flat male vocal singing over acoustic guitar melody, accordion and a sustained brass section melody. It sounds very noisy, vintage and therefore nostalgic and sentimental - like something you would hear in an old movie. | 2012-02-16T00:09:11Z | RadioWeevil | The Crowing Rooster Walter Rhodes, voice and accordion Pet and Can (Maylon and Richard Harney), guitars Columbia 14289-D (W 145358-2) Memphis, 10 December 1927 | ["Music", "Mandolin", "Bluegrass"] | ["country blues", "noisy", "vintage", "low quality", "nostalgic", "mono", "flat male vocal", "acoustic guitar melody", "accordion melody", "sustained brass section", "nostalgic", "sentimental"] | 4 | V5xL8hLFY58 | 2974 |
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;