musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "country music" and musiccaps_aspects contains "steel guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- country music · 3 ✖
- steel guitar · 3 ✖
- acoustic drums 2
- calm 2
- psychedelic 2
- trippy 2
- acoustic guitar 1
- arpeggio 1
- bass guitar 1
- country ballad 1
- country western 1
- cozy 1
- easygoing 1
- instrumental 1
- intricate steel guitar playing 1
- live recording 1
- mellow tune 1
- no singer 1
- relaxing 1
- rock 1
- slow country music 1
- slow tempo 1
- vintage country 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This is a country music piece. A steel guitar is playing the main melody. There is a bass guitar in the background playing a mellow bass line. A slow tempo, mild-volume acoustic drum track is in the rhythmic background. The general atmosphere is relaxing. This piece could be used in the soundtrack of movies that take place in rural USA. It could also be played in western-themed bars. | ["Music", "Steel guitar, slide guitar"] | ["country music", "rock", "steel guitar", "acoustic drums", "bass guitar", "calm", "cozy", "trippy", "psychedelic", "slow tempo"] | 9 | 1208 | |||||
She Thinks I Still Care | The song is a slow country song - a country ballad played on a steel guitar. This is the type of song that would be suitable for an old country western movie where a hero character walks into a diner. This is a live recording and the song has a slow tempo. | 2010-08-27T01:59:11Z | Terry Wisdom | My dog is my most loyal audience, She never cares when I make a mistake. She just loves steel guitar. | ["Country", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["steel guitar", "country music", "live recording", "slow country music", "country ballad", "arpeggio", "intricate steel guitar playing", "country western", "vintage country"] | 3 | DHo1z0_ZUNA | 1461 | |
How to play steel guitar lesson 19 | This is a country music piece that is played in an instrument lesson recording. The steel guitar is playing a mellow tune while at the forefront while there is a backing composed of the acoustic guitar and the acoustic drums. There is a relaxing and psychedelic feel to the piece. This music could suit well in the soundtrack of a feelgood/comedy movie. It could also be playing in the background at a shopping mall. | 2008-07-24T15:02:22Z | bobbeseymour | Bobbe Seymour shows more stuff at Steel Guitar Nashville | ["Music", "Musical instrument", "Steel guitar, slide guitar", "Bluegrass"] | ["country music", "no singer", "instrumental", "steel guitar", "mellow tune", "acoustic guitar", "acoustic drums", "easygoing", "calm", "relaxing", "psychedelic", "trippy"] | 9 | SvsCM0fLM5g | 2795 |
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;