musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing" and musiccaps_names contains "Steel guitar, slide guitar" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- easygoing · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- calm 1
- country music 1
- groovy piano chords 1
- instrumental 1
- low quality 1
- mellow tune 1
- no singer 1
- psychedelic 1
- relaxing 1
- shimmering hi hats 1
- smooth instrumental playback 1
- snappy rimshot 1
- soft bass guitar 1
- soft kick 1
- steel guitar 1
- steel guitar solo melody 1
- trippy 1
- wide acoustic rhythm guitar 1
musiccaps_names (array) 4 ✖
- Music 2
- Steel guitar, slide guitar · 2 ✖
- Bluegrass 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Look At Us | The low quality recording features a steel guitar solo melody playing over smooth instrumental on playback that consists of snappy rimshots, wide acoustic rhythm guitar, groovy piano chords, soft bass guitar, soft kick hits and shimmering hi hats. It sounds easygoing and chill - something you would hear in a restaurant or a coffee shop. | 2009-08-01T15:11:16Z | davepedalsteel | by David Hartley | ["Music", "Steel guitar, slide guitar"] | ["low quality", "steel guitar solo melody", "smooth instrumental playback", "snappy rimshot", "wide acoustic rhythm guitar", "soft bass guitar", "soft kick", "shimmering hi hats", "groovy piano chords", "easygoing"] | 4 | eyFBIA_HOmE | 3912 |
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;