musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "guitar demo" and musiccaps_names contains "Reverberation" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 31 ✖
- guitar demo · 2 ✖
- instrumental music 2
- medium tempo 2
- poor audio quality 2
- tone generator 2
- adventure music 1
- adventurous 1
- ambient echoes 1
- ambient room noise 1
- casual playing 1
- delay pedal 1
- echo tones 1
- echoes 1
- emotional 1
- energetic 1
- exciting 1
- guitar amplifier 1
- guitar effects pedal 1
- guitar played accompaniment style 1
- guitar solo 1
- guitar strumming 1
- hissing sounds 1
- home video 1
- passionate 1
- rehearsals session 1
- reverb peas 1
- soloist 1
- subtle bass line 1
- testing effects 1
- turning knobs 1
- youtube music video 1
musiccaps_names (array) 10 ✖
- Guitar 2
- Music 2
- Reverberation · 2 ✖
- Tapping (guitar technique) 2
- Distortion 1
- Echo 1
- Effects unit 1
- Electric guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
Raygun Fx - Aurora Lofi Delay Reverb (Mini Version) Guitar Fx Pedal Hand made UK | The song is an instrumental. The tempo is medium with a guitar strumming to different settings of an effects delay pedal with echoes and effects being heard. The song is an effects pedal demonstration. The audio quality is poor with hissing sounds. | 2015-01-22T22:59:06Z | RaygunFX | Raygun FX - Aurora LoFi Delay-verb mini All the same features and classic lofi delay tones of the standard Aurora delay From a short Reverb, to Slap back Delay, to a long spaced out delays and a bunch of lofi noises in between! For delay lovers, this freaky delay is an unusual beast, with some warm, but lofi tones. Controls: Blend, Repeat and Speed 9v DC Powered True bypass Green LED Rubber grip feet Quality clicking Jack input/output Medium Enclosure: 111mm x 55mm x 35mm http://fuzzboxes.co.uk/product/aurora-lofi-delay-verb-mini | ["Reverberation", "Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Distortion"] | ["instrumental music", "turning knobs", "delay pedal", "poor audio quality", "hissing sounds", "rehearsals session", "ambient room noise", "guitar effects pedal", "tone generator", "poor audio quality", "guitar strumming", "echo tones", "testing effects", "guitar demo", "energetic", "casual playing", "reverb peas", "echoes", "medium tempo"] | 1 | RczzNAr1T_Q | 2715 |
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;