musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "instructive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- electric guitar · 2 ✖
- instructive · 2 ✖
- effect pedal 1
- guitar solo 1
- instrumental 1
- jam 1
- male voice 1
- no singer 1
- repeated notes 1
- reverb 1
- simple tunes 1
- single instrument 1
- tuning 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
D# (Eb) Standard Guitar Tuner (D# G# C# F# A# D# Tuning) | This is the recording of a tuning video in the key of D sharp. There is an electric guitar playing the note on each string repeatedly. This piece could be used to lift samples to be used in a beat or in the making of a virtual guitar plug-in. | 2012-10-28T18:23:31Z | Mykola MrHardGuitar - Guitar Reviews And Lessons | Free Online Chromatic Guitar Tuner using Microphone - http://hard-guitar.com/free-online-chromatic-guitar-tuner-using-microphone-how-to-tune-a-guitar/ This is Online Guitar Tuner D# (Eb) Standard Tuning (D# G# C# F# A# D#). D Sharp Tuning or E Flat Tuning | ["Music", "Electronic tuner"] | ["tuning", "instructive", "no singer", "electric guitar", "repeated notes"] | 9 | PvHKu1XRSJ0 | 2579 | |
Behringer RSM guitar FX pedals review - DW400 Dynamic Wah / Human Voice | This is a gear showcase jam. There is a male voice talking in between the sounds giving information about a reverb pedal. There is an electric guitar playing random tunes with the reverb effect. The tunes in the recording are simple. Sounds from this recording could be sampled for use in beat-making. | 2010-01-27T15:36:51Z | dancetech | Behringer RSM guitar FX pedals review - DW400 Dynamic Wah / Human Voice | ["Echo", "Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Distortion"] | ["jam", "instrumental", "single instrument", "male voice", "instructive", "electric guitar", "guitar solo", "effect pedal", "reverb", "simple tunes"] | 9 | n179cK8EubU | 4510 |
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;