musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "gear showcase" and musiccaps_aspects contains "simple tune"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- easygoing · 2 ✖
- electric guitar 2
- gear showcase · 2 ✖
- jam 2
- simple tune · 2 ✖
- amp 1
- instructive speaking 1
- instrumental 1
- male voice 1
- no singer 1
- single instrument 1
- tailpiece 1
- vibrato 1
musiccaps_names (array) 8 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Bass guitar 1
- Chorus effect 1
- Echo 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bigsby Vibrato Tone Demonstration | This is a gear showcase jam. There is an electric guitar playing simple tunes first without and then with a vibrato tailpiece to show the difference between two setups. The atmosphere is easygoing. Although the recording is a bit dated, the electric guitar could be sampled for use in beat-making. | 2007-05-16T20:55:07Z | Bigsby | Video demonstrates the difference in tone with a Bigsby Vibrato before and after installation. Bigsby afficionado, Adam Seutter, walks the viewer step by step through the installation process of various Bigsby Vibrato kits on different model guitars in these detailed videos. Adam demonstrates the difference in tone before and after the Bigsby installation. Videos include details of the tools required for installation including proper drill bit sizes and positioning of the Bigsby vibrato prior to mounting. | ["Echo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["gear showcase", "jam", "no singer", "instrumental", "electric guitar", "vibrato", "tailpiece", "easygoing", "simple tune"] | 9 | PUy3cnNk4ys | 2542 | |
Rivera Ktre 55watt with reverb combo demo | This is a gear showcase video demonstrating the sound difference when an electric guitar is connected to an amp. The electric guitar is playing simple tunes. A male voice is describing the applied effect. Sounds from this piece can be sampled for use in beat-making. | 2007-09-11T14:56:24Z | Rivera Amplification | Paul Rivera Jr of Rivera Amplification shows the Knucklehead Tre 55watt with Reverb combo while Luis Maldonado Plays it | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Speech", "Plucked string instrument"] | ["jam", "gear showcase", "single instrument", "electric guitar", "amp", "male voice", "instructive speaking", "easygoing", "simple tune"] | 9 | n1PTn_NH_K0 | 4512 |
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;