musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy", musiccaps_author = 9 and musiccaps_names contains "Distortion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- groovy · 4 ✖
- jam 4
- easygoing 3
- electric guitar 3
- instrumental 3
- no singer 3
- guitar solo 2
- reverb 2
- single instrument 2
- acoustic drums 1
- bass guitar 1
- calm 1
- chill 1
- clean sounding 1
- concert 1
- effect pedal 1
- effects 1
- gear showcase 1
- jazz 1
- keyboard 1
- live performance 1
- overdriven electric guitar 1
- reggae 1
- relaxing 1
- saxophone 1
- simple tune 1
- simple tunes 1
- tropical 1
musiccaps_names (array) 10 ✖
- Distortion · 4 ✖
- Guitar 4
- Music 4
- Effects unit 3
- Musical instrument 3
- Plucked string instrument 3
- Reverberation 3
- Electric guitar 2
- Blues 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
David Byrd - HD Live! (Tropical Addiction Series 2012) Chicago Reggae Channel | This is the recording of a jazz reggae concert. There is a saxophone lead playing a solo. There is a keyboard and an electric guitar playing the main tune with the backing of a bass guitar. In the rhythmic background, there is an acoustic reggae drum beat. The atmosphere is groovy and chill. This piece could be playing in the background at a beach. It could also be included in the soundtrack of a summer/vacation/tropical themed movie. | 2012-08-16T15:30:54Z | Whitelion Promotio | http://chicagoreggaechannel.com presents: Tropical Addiction Series 2012 - Reggae At The Dock Produced by WhiteLion Promotion, Hosted by Madhatter Promotions August 1st, 2012 | ["Blues", "Effects unit", "Electric guitar", "Guitar", "Music", "Reggae", "Plucked string instrument", "Distortion"] | ["jazz", "reggae", "live performance", "concert", "saxophone", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "groovy", "relaxing", "calm", "chill", "tropical", "jam"] | 9 | ALVS3Q_jNaU | 1108 | |
1963 fiesta red sparkle stratocaster in 1966 deluxe reverb | This is an instrumental jam. The only instrument being played is a clean sounding electric guitar. The guitar solo has simple, groovy tunes played in an improvised manner. The atmosphere is easygoing. Parts of this recording could be sampled to be used in beat-making. | 2008-08-05T22:43:30Z | vineeth77 | an ultra rare 63 red sparkle cutsom color, all original vintage fender stratocaster, L series, a little bit fiesta red sparkle... originla frets and nut... cream tolex case, with stratp etc... lava cable van den hul and 66 deluxe reverb with 1960 P12N jensen | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["jam", "no singer", "instrumental", "single instrument", "electric guitar", "guitar solo", "easygoing", "groovy", "clean sounding", "simple tunes"] | 9 | Kd7aHdOwh0I | 2100 | |
Fender Deluxe Reverb II Andy Gardiner | This is the recording of a gear showcase jam. There is an overdriven electric guitar playing a groovy solo with the amplified reverb effect. There is a crunchy sound. The piece can be used as the jingle of an advertisement. It could also be used for lifting electric guitar samples to be used in a beat. | 2010-01-20T21:51:48Z | Andrew Gardiner | Fender Deluxe Reverb II. 1983. Single 12" original CTS speaker. 1989 PRS C24. Basic control settings. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Distortion"] | ["jam", "no singer", "instrumental", "single instrument", "overdriven electric guitar", "guitar solo", "effects", "reverb", "easygoing", "groovy", "simple tune"] | 9 | _KGUrOb1qgU | 3463 | |
Electro Harmonix CATHEDRAL stereo reverb guitar effects pedal demo w Les Paul & Blues Jr Amp | This is a gear showcase jam. The electric guitar is being played initially without and then with the effect of a reverb pedal. There is a groovy feel to the solo that is being played. This piece can be sampled to be used as an advertisement jingle or to be used in beat-making. | 2009-10-02T01:41:10Z | gearmanndude | http://www.ehx.com The Cathedral, by electro-harmonix. Super versatile reverb with some sweet presets. The reverse setting is my favorite. Yes, I still hate reverb, but have given in to the fact that I must demo them anyway. I had only 7 minutes left on my camera tape, so I did a quick run through of the presets to show what could be done with the box of echos. I used my 59 historic les paul and a lovely Fender blues junior amplifier. | ["Reverberation", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["gear showcase", "jam", "no singer", "instrumental", "electric guitar", "effect pedal", "reverb", "easygoing", "groovy"] | 9 | pTzINk_nVHg | 4713 |
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;