musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate" and musiccaps_names contains "Echo" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- passionate · 3 ✖
- low quality 2
- noisy 2
- amplifier knob flicks 1
- arpeggiated electric guitar melody 1
- clean 1
- echo tones 1
- electric guitar lead 1
- electric guitar melody solo 1
- emotional 1
- exciting 1
- guitar amplifier 1
- guitar licks 1
- guitar tone test demo 1
- home music video 1
- loud music 1
- medium tempo 1
- poor audio quality 1
- rock guitar lead 1
- rock solo 1
- tremolo tones 1
- weird 1
- wide 1
- wide arpeggiated electric guitar melody 1
musiccaps_names (array) 11 ✖
- Echo · 3 ✖
- Music 3
- Electric guitar 2
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Bass guitar 1
- Blues 1
- Distortion 1
- Effects unit 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
G3 Modeling Sounds vs. Real Guitar Amps - Acoustic Simulator | The low quality recording features widely spread electric guitar melodies. One of the melodies is solo and it is panned to the right channel, while the other one is an arpeggiated electric guitar melody, and it is panned to the left channel of the stereo image. The recording is a bit noisy and weird, since it is a bit too wide, but it also sounds passionate. | 2011-11-18T16:30:02Z | ZoomcorpUK | Demonstration video clips of the G3 by Koichi Korenaga, guitarist/producer. You can listen to line-recorded modeling sounds of the G3 versus sounds of real guitar amps recorded with mics. Follow Zoom UK on Twitter: www.twitter.com/zoomuk | ["Bass guitar", "Echo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "wide", "electric guitar melody solo", "arpeggiated electric guitar melody", "passionate", "weird"] | 4 | 7xD_Ib3VS_w | 891 | |
Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 | The low quality recording features a wide arpeggiated electric guitar melody. It sounds clean, passionate and the recording is a bit noisy. | 2009-07-30T18:48:06Z | BenRandallGuitar | Mayones Guitar Demo 2 by Ben Randall - Mayones Regius PRO 6 Regius PRO 6 with Schaller Floyd Rose PRO for dive-bombing, fluttering, vibratoing and whatever else you like with the reliability of 11-pieces neck-thru construction. Standard 25,4" scale only. Ergonomic contoured body perfectly shaped for easy access to the upper frets. Swamp Ash body for modern sound with quick attack or Mahogany for more warm and round tones. Artist-grade Flamed Maple 'radiused' top. Strings-thru-body fixed bridge for the wood vibration enhancement. Equipped with Sperzel locking tuners and Seymour Duncan, EMG or DiMarzio pickups. Several colour options and hardcase included. http://www.mayones.com http://www.blackhawkmusic.co.uk http://www.myspace.com/benrandallguitar For more information, contact Ben Hawker: Call +44 (0)7990 828779 or Email ben@blackhawkmusic.co.uk | ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "wide arpeggiated electric guitar melody", "clean", "passionate"] | 4 | IIK0EuHyb6w | 1890 | |
Owen Barry , Vertex Effects Landau stereo chorus, Victoria | The song is an instrumental. The song is medium tempo with an amplified guitar solo lead, complete with knob flicking tones. The song is loud and energetic. The audio quality is poor and recorded live at home. | 2014-06-11T21:10:50Z | owen barry | ["Blues", "Echo", "Effects unit", "Electric guitar", "Music", "Distortion"] | ["electric guitar lead", "poor audio quality", "rock solo", "guitar amplifier", "home music video", "guitar tone test demo", "medium tempo", "rock guitar lead", "tremolo tones", "echo tones", "amplifier knob flicks", "loud music", "emotional", "passionate", "exciting", "medium tempo", "guitar licks"] | 1 | R4b_-IT43P4 | 2663 |
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;