musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "cover", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "smooth bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- cover · 3 ✖
- low quality 3
- noisy · 3 ✖
- smooth bass · 3 ✖
- passionate 2
- acoustic guitar melody 1
- acoustic rhythm guitar 1
- crackling 1
- electric guitar solo melody 1
- instrumental playback 1
- joyful 1
- mandolin solo melody 1
- mono 1
- muffled 1
- passionate girl vocal 1
- playback instrumental 1
- punchy kick 1
- punchy snare 1
- rock 1
- soft cymbals 1
musiccaps_names (array) 14 ✖
youtube_published (date) 3 ✖
- 2006-11-17 1
- 2009-06-23 1
- 2014-03-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
blues solo in A tokai les paul and marshall jcm900 dual reverb combo | The low quality recording features a cover of a rock song that consists of an electric guitar solo melody played over playback instrumental. The instrumental features a punchy kick and snare hits, soft cymbals and smooth bass. It sounds passionate, even though the recording is muffled and noisy, as it was probably recorded with a phone. | 2014-03-06T23:42:30Z | Dave Hardy | Dave does a blue in A from a tracker off youtube.The guitar is a modded tokai/gibbo love rock with seymor duncan sh5 and warman p90.The amp is a 1992 Marhall 100 watt dual reverb combo.The effects and pedals are named as he uses them. | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Heavy metal", "Music", "Distortion"] | ["low quality", "noisy", "cover", "rock", "electric guitar solo melody", "playback instrumental", "punchy snare", "punchy kick", "smooth bass", "soft cymbals", "passionate", "muffled"] | 4 | -OAyRsvFGgc | 41 | |
Angelica singing Cheetah Sisters - Cheetah Girls | The low quality recording features a cover of a song sung by passionate girl vocalists over acoustic guitar melody and smooth bass. The recording is very noisy and crackly. Judging by the quality of it, the vocalist is singing on a very cheap sounding microphone - which makes the sound quality even worse. | 2006-11-17T00:14:17Z | cchhaanneeyy | Angelica (age 7) singing Cheetah Girls - "Cheetah Sisters." | ["Music", "/t/dd00004", "Child singing", "Synthetic singing"] | ["cover", "low quality", "passionate girl vocal", "acoustic guitar melody", "smooth bass", "noisy", "crackling"] | 4 | 5XXAeSybGK0 | 665 | |
Cold Frosty Morning for the Mandolin Cafe | The low quality recording features a cover that consists of a mandolin solo melody playing over playback instrumental that has smooth bass and acoustic rhythm guitar. The recording is noisy, in mono and it sounds passionate and joyful. | 2009-06-23T11:30:38Z | Mandolin1944 | This is a very interesting tune. The tune has several versions and at least two of them are totally different tunes. The one played here is, I think, by far the most common in North America and is played in the key of Am. It is a tune of Scottish origin (perhaps derived from an air by the great Neil Gow? -- not sure about that). The tune in this form commemorates the battle of Culloden Moor, when, on cold spring morning in 1746 the English Army surprised and massacred a Scottish highlander army and thereby ended the Jacobite Rebellion. In years that followed thousands of apparently completely innocent Scotts were murdered by the English general the Duke of Cumberland (aka the Butcher) to punish them and to assure no more highlander rebellions would occur. But there is another version of "Cold Frosty Morning" which is an old tyme quadrille (6/8 time? or 3/4 time?) which was played in using an altered tuning and is in the key of D. The Fiddlers Companion attributes this tune to Stephen B. Tucker of Mississippi who started fiddling in late 1860's and was recorded for the Library of Congress in 1939. I plan to research this more. And of course the bluegrass folks have a ball with it. Im playing it here at 90 bpm in 2/4 time. Played on a 2002 Gibson F-5 Fern | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["low quality", "noisy", "mono", "cover", "mandolin solo melody", "acoustic rhythm guitar", "smooth bass", "instrumental playback", "passionate", "joyful"] | 4 | swIXVQtP_TI | 4988 |
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;