musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "Echo" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- passionate · 2 ✖
- amplifier knob flicks 1
- clean 1
- echo tones 1
- electric guitar lead 1
- emotional 1
- exciting 1
- guitar amplifier 1
- guitar licks 1
- guitar tone test demo 1
- home music video 1
- loud music 1
- low quality 1
- medium tempo 1
- noisy 1
- poor audio quality 1
- rock guitar lead 1
- rock solo 1
- tremolo tones 1
- wide arpeggiated electric guitar melody 1
musiccaps_names (array) 9 ✖
- Echo · 2 ✖
- Electric guitar · 2 ✖
- Music 2
- Blues 1
- Distortion 1
- Effects unit 1
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
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;