musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "retro pop" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 63 ✖
- retro pop · 3 ✖
- groovy bass lines 2
- acoustic guitar accompaniment 1
- acoustic guitar rhythm 1
- amateur tourist video 1
- ambient 1
- ambient street noise 1
- animated trumpets 1
- brass band 1
- cheerful 1
- choral harmony 1
- crowds laughing 1
- dulcet 1
- emotional 1
- emphatic lead 1
- fast tempo 1
- fluid 1
- funk 1
- funny 1
- guitar rhythm 1
- guitar strumming 1
- handicapped man 1
- hard hitting drumming 1
- inferior audio quality 1
- inspiring 1
- instrumental 1
- jovial 1
- keyboard harmony 1
- look ma no hands 1
- male singer 1
- male vocalist 1
- man talking 1
- medium tempo 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mood 1
- motivational 1
- muffled audio 1
- never give 1
- no other instruments 1
- nostalgic 1
- pleasant 1
- poor audio quality 1
- pop 1
- positive 1
- powerful 1
- r&b 1
- retro 1
- rock and roll 1
- romantic 1
- simple melody 1
- slow tempo 1
- soft 1
- song cover 1
- soul 1
- steady drumming 1
- strength 1
- trombone 1
- vigorous 1
- vigorous instrumentation 1
- vital 1
- vivacious 1
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- Acoustic guitar 1
- Bass guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Roll 1
- Speech 1
- Strum 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Man with no arms playing freebird on guitar | A handicapped musician plays the guitar with his feet and sings and jokes about. The song is medium tempo and retro pop with just a guitar strumming and no other instrumentation. The song is inspiring and relaxing. The song audio quality is very poor. | 2008-03-18T04:45:05Z | elfchild42 | Man with no arms playing freebird on guitar with his feet! This dude was cool. Freebird was played by request from the crowd. He said he hadn't played it in years. He rocks it out in Balboa Park in San Diego, CA on the weekends. Proof that the only handicaps people have are the ones they give to themselves. BTW his name is Mark Goffeney | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Speech", "Plucked string instrument"] | ["emotional", "powerful", "strength", "never give", "inspiring", "motivational", "retro pop", "handicapped man", "guitar rhythm", "guitar strumming", "male singer", "man talking", "medium tempo", "crowds laughing", "ambient street noise", "no other instruments", "funny", "jovial", "cheerful", "positive", "song cover", "poor audio quality", "amateur tourist video", "look ma no hands"] | 1 | 33LJ36nAozM | 438 | |
Looking Out My Window - Tom Jones | A male vocalist sings this energetic funk pop. The audio quality is inferior and the song is not clear.The tempo is. Fast with animated trumpets, with a boomy trombone, infectious drumming, keyboard harmony, groovy bass lines, rhythmic electric and acoustic guitar and melodious choral backup. The song is melodic, enthusiastic, energetic, animated and captivating Retro Funk/Pop. | 2008-12-16T18:46:37Z | bomtraumusic | Looking Out My Window Tom Jones | ["Music", "Roll"] | ["male vocalist", "fast tempo", "pop", "retro", "retro pop", "muffled audio", "inferior audio quality", "vivacious", "vigorous", "vital", "funk", "r&b", "soul", "vigorous instrumentation", "brass band", "animated trumpets", "trombone", "hard hitting drumming", "keyboard harmony", "choral harmony", "groovy bass lines", "acoustic guitar rhythm", "brass band"] | 7 | DE6bdmnmPtg | 1454 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 |
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;