musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "minimalist", musiccaps_names contains "Chorus effect" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- instrumental 2
- minimalist · 2 ✖
- amplified 1
- amplified guitar 1
- electric guitar 1
- electric guitar lead 1
- electric guitar lead and harmony 1
- external amplification 1
- funk 1
- groovy 1
- heavy metal 1
- jazz 1
- nostalgic 1
- pleasant 1
- popular song 1
- powerful music 1
- reggae 1
- rock 1
- slow tempo 1
- soft 1
- sonic power 1
- string instrument 1
- stringed instrument 1
- vibration 1
musiccaps_names (array) 7 ✖
- Chorus effect · 2 ✖
- Guitar 2
- Music 2
- Musical instrument · 2 ✖
- Plucked string instrument 2
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Mooer Audio Pure Octave | This music is an electronic instrumental; the tempo is medium with a solo electric guitar lead and no accompanying instruments. The music is melodic, rhythmic, and groovy. | 2014-03-18T01:57:32Z | Prymaxe | $98.00 https://www.prymaxe.com/products/mooer-audio-pure-octave-octave-pedal Mooer Audio Pure Octave Octave Pedal The Mooer Audio Pure Octave Octave pedal featurs precise polyphonic octave effects with no distortion. The Pure Octave has eleven different modes, rugged construction, 9v DC operation, and is true bypass. Like all Mooer pedals the Pure Octave is built like a small tank and will fit on nearly any pedal board. Mooer Audio Pure Octave Octave Pedal Features: Precise polyphonic octave effect with no distortion 11 different modes True bypass Rugged construction 9v operation | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitar", "amplified", "vibration", "string instrument", "electric guitar lead", "minimalist", "groovy", "external amplification", "heavy metal", "rock", "reggae", "jazz", "funk"] | 7 | kVYXcbvw9u4 | 4323 | |
Hotel California - the Eagles Full Guitar with backing track www.Farhatguitar.com | This music is an electric guitar instrumental. The tempo is slow with an electric guitar lead and harmony of a popular song. No other instrument is used. It is mellow, pleasant, nostalgic, soft , mellifluous and soothing. | 2011-01-11T16:31:38Z | Farhat Guitar | TAB http://farhatguitar.com/lessons/the-eagles-hotel-california/ My Music http://elgranojorojo.com/Siento_Y_Presiento_EGOR_2015.zip FB: http://www.facebook.com/FarhatGuitarOfficial Twitter:http://twitter.com/FarHatGuitar FB my Band: https://www.facebook.com/ElGranOjoRojo Spotify : https://open.spotify.com/artist/3nc5PxwNs1zAYVnxahfjoX Old Music: http://goo.gl/2T3YfX See you Marcos Farhat | ["Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar lead and harmony", "popular song", "minimalist", "pleasant", "nostalgic", "amplified guitar", "powerful music", "sonic power", "stringed instrument", "soft", "pleasant"] | 7 | uQTCfT5XDzQ | 5112 |
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;