musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_names contains "Effects unit", musiccaps_names contains "Guitar" and musiccaps_names contains "Steel guitar, slide guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- acoustic guitar accompaniment 1
- auto harp 1
- auto harp instrumental 1
- calming 1
- complex electric guitar playing 1
- country hits 1
- country instrumental 1
- country love song 1
- country song 1
- dulcet 1
- electric guitar solo 1
- emphatic 1
- enthralling 1
- instrumental 1
- intricate walking bassline 1
- jazzy 1
- mellifluous 1
- mellow 1
- nostalgic 1
- pleasant 1
- reverb effect 1
- simple jazzy drumming 1
- slow tempo 1
- soft 1
- soothing 1
- steel guitar 1
musiccaps_names (array) 8 ✖
- Effects unit · 2 ✖
- Guitar · 2 ✖
- Music 2
- Steel guitar, slide guitar · 2 ✖
- Distortion 1
- Musical instrument 1
- Plucked string instrument 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FRV-1 Fender® Reveb [BOSS Sound Check] | Here we have an electric guitarist intricately playing a guitar solo with a reverb effect applied to his guitar. The music is a jazzy type of backing track with a sophisticated walking bassline. The guitarist is highly skilled. | 2010-08-03T02:11:30Z | BOSSchannel | http://www.boss.info/global/gear/255/1021 A Classic Reborn — the legendary sound of the 1963 Fender® Spring Reverb returns as a modern stompbox. BOSS and Fender® USA have collaborated to create the FRV-1, a stunning recreation of the legendary '63 Fender® Reverb via COSM technology. The FRV-1 puts that timeless tube-driven reverb sound under your foot in a tough, reliable compact pedal. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument", "Distortion"] | ["jazzy", "electric guitar solo", "simple jazzy drumming", "intricate walking bassline", "reverb effect", "complex electric guitar playing"] | 3 | NVo-stvk_QE | 2341 | |
Bob Tuttle Steel Guitar- Farewell Party | The music is a country song instrumental. The tempo is slow with an auto harp harmony and lively acoustic guitar accompaniment. The music is soft, mellow, mellifluous,dulcet, sentimental, simple and nostalgic. | 2015-07-03T22:43:41Z | Bob Tuttle Steel Guitar | If you liked this video then I would be honored if you would give me a thumbs up. There will be more videos to come, so if you want to be notified when I post something new, then please feel free to subscribe to my channel. Want to learn more about me and my music career, then check out my website at http://bobtuttlesteelguitar.com | ["Effects unit", "Guitar", "Music", "Steel guitar, slide guitar"] | ["instrumental", "slow tempo", "acoustic guitar accompaniment", "mellow", "soft", "dulcet", "country love song", "steel guitar", "auto harp", "country song", "country hits", "country instrumental", "auto harp instrumental", "mellifluous", "enthralling", "pleasant", "nostalgic", "calming", "soothing", "emphatic"] | 7 | jrwhxVnvMdk | 4285 |
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;