musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar", musiccaps_author = 0 and musiccaps_names contains "Inside, small room"
This data as json, CSV (advanced)
musiccaps_names (array) 9 ✖
- Guitar 2
- Inside, small room · 2 ✖
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Electronic tuner 1
musiccaps_aspects (array) 7 ✖
- electric guitar · 2 ✖
- instrumental 2
- no other instruments 2
- no voices 2
- blues vibe 1
- flanger effect 1
- pentatonic scale 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vox Valvetronix VT20+ Demo | This is a clip featuring an electric guitar being played through an amp. First a chord is played. This is followed by a descending pentatonic lick being played. This lick has a blues feel. This is an instrumental song. There are no voices in this song. There are no other instruments in this song. | 2011-02-28T21:58:24Z | lucidspoon | A quick demo of a few of the Vox Valvetronix VT20+ amp models. | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["electric guitar", "pentatonic scale", "no other instruments", "no voices", "instrumental", "blues vibe"] | 0 | QZNrK337wow | 2627 | |
MXR Micro Flanger | This song features an electric guitar playing arpeggiated chords. The guitar is playing with a flanger effect added to change the tone. There are no other instruments in this song. There are no voices in this song. This is an instrumental song. This song can be used in an instructional video on an effects processor. | 2008-12-27T17:59:29Z | blondegraemey | Vintage MXR Micro Flanger with crumbling foam problem! Description and demonstration. | ["Effects unit", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion", "Inside, small room"] | ["electric guitar", "flanger effect", "no other instruments", "no voices", "instrumental"] | 0 | wYtd_Sq2-Tw | 5274 |
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;