musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "mono" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- acoustic rhythm guitar · 7 ✖
- low quality 7
- mono · 7 ✖
- noisy 7
- passionate · 7 ✖
- accordion melody 2
- country 2
- cover 2
- emotional 2
- joyful 2
- passionate male vocal 2
- asphalt sounds 1
- breathy flute melody 1
- crowd chattering 1
- easygoing 1
- flat male vocal 1
- folk 1
- groovy bass 1
- harmonizing mixed vocals 1
- instrumental playback 1
- live performance 1
- mandolin solo melody 1
- raw male vocal 1
- regional mexican 1
- saxophone solo melody 1
- smooth bass 1
- soulful 1
musiccaps_names (array) 14 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DAVID ALLAN COE interview - part 1 | The low quality recording features a flat male vocal singing over acoustic rhythm guitar chords, after which that same vocal is talking. The song sounds passionate, while the recording, overall, is noisy and in mono. | 2008-07-26T19:53:24Z | BubbaTheLawnJockey | DAVID ALLAN COE interview - part 1 | ["Singing", "Country", "Music", "Strum"] | ["low quality", "noisy", "mono", "acoustic rhythm guitar", "flat male vocal", "passionate", "country"] | 4 | -UuEBhule84 | 52 | |
Zelda Wind Waker: Dragon Roost Island, self duet guitar+flute (recorder) | The low quality recording features a breathy flute melody playing over acoustic rhythm guitar. The recording is noisy, in mono and it sounds passionate and easygoing. | 2008-04-22T19:52:10Z | JumpmanFR | Music by Kenta Nagata Arrangement by JumpmanFR Finally this version sounds like what I expected. Which one do you like better? Recorder (flûte) or ocarina? For other vids, tabs and cool stuff, visit my website: http://www.jumpman.fr | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "acoustic rhythm guitar", "breathy flute melody", "noisy", "mono", "passionate", "easygoing"] | 4 | KsFCPOKAH60 | 2128 | |
loretta lynn "when the roll is called" | The low quality recording features a passionate male vocal, alongside harmonizing mixed vocals, singing over acoustic rhythm guitar, accordion melody and groovy bass. It sounds passionate and joyful. The recording is noisy and in mono - the sound is coming from the right channel only. | 2007-07-17T06:19:50Z | lorettafan1 | with teddy and doyle and the willis brothers | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "noisy", "mono", "harmonizing mixed vocals", "passionate male vocal", "accordion melody", "acoustic rhythm guitar", "groovy bass", "passionate", "joyful"] | 4 | _2P_EJsnBls | 3437 | |
The Best Old Country Music | The low quality recording features a country song being played on an acoustic rhythm guitar and raw male vocal singing over it. It sounds passionate and emotional, even though the recording is noisy and in mono. | 2006-10-08T02:28:23Z | papachya | Original, Real, Old Country Music from a Great Guy, my Father | ["Country", "Music", "Bluegrass"] | ["low quality", "noisy", "mono", "country", "acoustic rhythm guitar", "raw male vocal", "emotional", "passionate"] | 4 | fDMbNCdGXBc | 3931 | |
vicente de montpellier | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | 2009-11-09T14:59:52Z | bentana100 | aqui el vicente de montpelier cantando en su barrio monteberou | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | 4 | lI8aGjIb8Jg | 4389 | |
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 | |
Mircea Gutanu & Romica Raiu | The low quality recording features a live performance of a folk song that consists of a saxophone solo melody, accordion melody and acoustic rhythm guitar. It sounds passionate and soulful. The recording is mono and noisy. | 2013-02-27T22:35:33Z | 5555kinder | ["Accordion"] | ["low quality", "live performance", "folk", "noisy", "mono", "saxophone solo melody", "accordion melody", "acoustic rhythm guitar", "passionate", "soulful"] | 4 | vpcEBryyej4 | 5209 |
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;