musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_names contains "Echo" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 13 ✖
- low quality · 2 ✖
- noisy 2
- clean 1
- echoing electric guitar melody 1
- groovy bass guitar 1
- intense 1
- mono 1
- passionate 1
- shimmering cymbals 1
- suspenseful 1
- synth bells melody 1
- weird 1
- wide arpeggiated electric guitar melody 1
musiccaps_names (array) 6 ✖
- Echo · 2 ✖
- Electric guitar · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Guitar 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 | |
Arpegios para guitarra elèctrica tècnica @adelqui7 #adelquirubio | The low quality recording features an echoing electric guitar melody played over shimmering cymbals, groovy bass guitar and synth bells melody. It sounds weird, suspenseful and intense. The recording is noisy and in mono. | 2006-06-22T19:27:25Z | Adelqui Rubio Official Adelqui7 | Arpegios para guitarra electrica Adelqui Rubio Adelqui7 @adelqui7 http://www.youtube.com/adelqui7 #adelquirubio #guitar #guitarlesson #guitarsolo | ["Echo", "Electric guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "echoing electric guitar melody", "shimmering cymbals", "synth bells melody", "groovy bass guitar", "weird", "suspenseful", "intense", "noisy", "mono"] | 4 | PmiH7RnCkhI | 2565 |
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;