musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "noisy", musiccaps_names contains "Guitar" and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- low quality 5
- noisy · 5 ✖
- cover 3
- passionate 3
- arpeggiated acoustic guitar melody 2
- emotional 2
- mono 2
- rock 2
- acoustic guitar melody 1
- blues 1
- cars passing 1
- chorus pedal effect 1
- electric guitar solo melody 1
- fun 1
- happy 1
- passionate solo acoustic guitar melody 1
- playback 1
- ragtime 1
- roomy 1
- soft 1
- soft female vocal 1
- staccato strings melody 1
musiccaps_names (array) 13 ✖
- Guitar · 5 ✖
- Mandolin · 5 ✖
- Music 5
- Musical instrument 5
- Plucked string instrument 4
- Acoustic guitar 1
- Banjo 1
- Country 1
- Distortion 1
- Effects unit 1
- Singing 1
- Strum 1
- Ukulele 1
youtube_published (date) 5 ✖
- 2006-04-17 1
- 2008-12-17 1
- 2011-01-17 1
- 2013-02-21 1
- 2014-07-27 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"September" by Andy Timmons | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | 2006-04-17T07:15:29Z | aristocrap | A beautiful song by the tone king himself. | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | 4 | 36ToDxW_hns | 441 | |
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
CO600, CO 600 Behringer Chorus orchestra efekt gitarowy test review - RockDay Pietraszek | The low quality recording features a passionately played electric guitar solo melody with a chorus pedal effect on. The recording is in mono and it is noisy. | 2013-02-21T19:25:42Z | Rockdaypl | CO600, CO 600 Behringer Chorus orchestra efekt gitarowy test review - RockDay Pietraszek | ["Effects unit", "Guitar", "Music", "Mandolin", "Musical instrument", "Distortion"] | ["low quality", "noisy", "mono", "chorus pedal effect", "electric guitar solo melody", "passionate"] | 4 | _hYBs0xee9Y | 3484 | |
Salty Dog Blues: Piedmont Blues Fingerstyle | The low quality recording features an acoustic guitar blues melody. The recording is very noisy, roomy and you can hear cars passing by in the background. | 2008-12-17T22:33:33Z | bostonteabagger71739 | My version of the old blues song. A little sloppy I know haha | ["Country", "Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "blues", "acoustic guitar melody", "noisy", "roomy", "cars passing"] | 4 | g_bgmnJ1b_g | 4039 | |
The Entertainer (S.Joplin) Advanced Slide Guitar Version - Marc Athlan | The low quality recording features a cover of a ragtime song and it consists of arpeggiated acoustic guitar melody. The recording is noisy, but it sounds happy and fun regardless. | 2014-07-27T15:55:10Z | Marc Athlan | This is an attempt to adapt the famous Scott Joplin tune (whole version) on slide guitar. If it has been said that it's a challenge to play this song on guitar, it's even more challenging on slide guitar ! I tried to be as close as possible to the original version. Played on resonator guitar with Diamond Bottleneck (The BEST in the world !). Thanks to Nathalie Athlan, Ian McWee and others at Diamond Bottlenecks.com. Thanks to Keni Lee Burgess for having inspired me with his video (https://youtu.be/X0VL_js9sWs) to do my version of this tune. Thanks for watching ! | ["Banjo", "Guitar", "Music", "Mandolin", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "cover", "arpeggiated acoustic guitar melody", "noisy", "happy", "fun", "ragtime"] | 4 | iCIa_pmLDqs | 4168 |
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;