musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "home video", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Electric guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- home video · 4 ✖
- medium tempo · 4 ✖
- emotional 3
- guitar amplifier 2
- guitar solo 2
- guitar technique 2
- instrumental music 2
- no other instrumentation 2
- passionate 2
- poor audio quality 2
- soloist 2
- spirited 2
- abrupt end 1
- acoustic guitar 1
- adventure music 1
- adventurous 1
- amateur 1
- amateur recording 1
- ambient echoes 1
- amplified guitar 1
- bad audio recording 1
- blues influences 1
- blues lick 1
- boomy 1
- chord progression 1
- chords 1
- deep 1
- echo tone 1
- electric guitar 1
- electric guitar lead 1
- …
musiccaps_names (array) 12 ✖
- Electric guitar · 4 ✖
- Music 4
- Guitar 3
- Musical instrument 3
- Distortion 2
- Plucked string instrument 2
- Reverberation 2
- Tapping (guitar technique) 2
- Acoustic guitar 1
- Chorus effect 1
- Effects unit 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender FSR Limited Edition Deluxe Reverb RI | A male guitarist plays a cool guitar like on an electric guitar. The song is medium tempo with a guitar solo with heavy a[echoes played though a guitar amplifier and no other instrumentation. The song is bluesy and passionate. The song is a casual blue slick played on a guitar. | 2012-05-09T06:39:38Z | Thomas Fargo | Testing the amp with Lollar P-90s | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["home video", "poor audio quality", "sound check", "deep", "emotional", "passionate", "blues influences", "instrumental music", "guitar solo", "tremolo effect", "guitar amplifier", "guitar lead", "echo tone", "solo guitar", "bad audio recording", "no other instrumentation", "guitar technique", "moody blues", "spirited", "passionate", "medium tempo", "blues lick"] | 1 | 6_zzu2KON6c | 768 | |
ギター レスポールを弾いてみた | The song is an instrumental guitar solo. The song tempo is medium with a racy electric guitar solo with a show of technique of note bending, tremolo and playing rhythmically. The song is home video and an average quality recording. | 2013-05-08T08:11:45Z | RDRGuitarBass | エレキギター RDRを弾いてみた | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Distortion"] | ["electric guitar lead", "note bending", "playing rhythm guitar", "solo guitarist", "soloist", "no other instrumentation", "no percussions", "home video", "poor quality video", "guitar technique", "guitar a", "plification", "medium tempo", "spirited", "emotional", "youthful", "groovy", "energetic"] | 1 | 7V0G65FK2VQ | 850 | |
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 |
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;