musiccaps_details (view)
2 rows where musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "story telling" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- nostalgic · 2 ✖
- slow tempo 2
- story telling · 2 ✖
- acoustic bass 1
- acoustic guitar 1
- ambient room noise 1
- american country music 1
- average audio quality 1
- banjo 1
- bluegrass 1
- country folk musical folk singer 1
- country folk songs 1
- country hits 1
- country music 1
- country music band 1
- country music hits 1
- double bass 1
- emotional 1
- folk lyrics 1
- gentle music 1
- guitar band 1
- guitars rhyme 1
- hillbilly music 1
- lilting melody 1
- live performance 1
- male singer 1
- male vocalist 1
- mandolin 1
- melancholy 1
- mellow 1
- old-time country rock 1
- pensive 1
- regional music 1
- romantic 1
- sentimental 1
- simple melody 1
- soft 1
- ukulele accompaniment 1
musiccaps_names (array) 3 ✖
- Music 2
- Folk music 1
- Mandolin 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Country Poor and Country Proud - Bluegrass Brothers | A male singer sings this gentle country music melody. The song is slow tempo with banjo, mandolin and guitar accompaniment and a double bass playing the lower register harmony. The song is emotional and nostalgic. The song is a country music hit with an average audio quality. | 2009-03-07T02:47:45Z | BGRTV | This is an older clip of the Bluegrass Brothers during a show at Hoofer's Gospel Barn in LaGrange GA. The Bluegrass Brothers are a lot of fun to watch... | ["Music", "Mandolin"] | ["male singer", "country music band", "double bass", "mandolin", "american country music", "nostalgic", "story telling", "average audio quality", "live performance", "ambient room noise", "ukulele accompaniment", "guitars rhyme", "guitar band", "country folk musical folk singer", "slow tempo", "gentle music", "country music hits", "romantic", "emotional", "lilting melody"] | 1 | O0sDg-yLvlE | 2388 | |
Sam Stone - John Prine | A male vocalist sings this melancholic country song. The tempo is slow with acoustic guitar lead and harmony with another string instrument accompanying. The song is soft, mellow, sad, pensive, melancholic and poignant with a sweet , pleasant melody. This song is a Classic Country song. | 2009-12-03T02:53:38Z | HouseOBVIOUSLY | Classic John Prine right here. | ["Folk music", "Music"] | ["male vocalist", "slow tempo", "acoustic guitar", "simple melody", "hillbilly music", "banjo", "old-time country rock", "folk lyrics", "country music", "bluegrass", "country hits", "regional music", "country folk songs", "acoustic bass", "mellow", "soft", "sentimental", "nostalgic", "pensive", "melancholy", "story telling"] | 7 | Sl9ZkYViEIs | 2787 |
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;