musiccaps_details (view)
3 rows where musiccaps_aspects contains "powerful" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- powerful · 3 ✖
- emotional 2
- instrumental music 2
- medium tempo 2
- amateur tourist video 1
- ambient street noise 1
- average audio quality 1
- banjo band 1
- banjo players 1
- banjo playing demonstration 1
- cheerful 1
- cinematic experience 1
- classical music 1
- clean tones 1
- crowds laughing 1
- end credits 1
- epic beginnings 1
- epic ending 1
- folk music 1
- funny 1
- grand journey 1
- guitar rhythm 1
- guitar strumming 1
- handicapped man 1
- harmony 1
- home video recording 1
- inspiring 1
- instrumental duet 1
- jovial 1
- keyboard accompaniment 1
- look ma no hands 1
- male singer 1
- man talking 1
- motivational 1
- movie soundtrack 1
- music practice 1
- mysterious 1
- never give 1
- no other instrumentation 1
- no other instruments 1
- no percussion instruments 1
- poor audio quality 1
- positive 1
- retro pop 1
- slow tempo 1
- song cover 1
- strength 1
- strong tones 1
- synth horns 1
- synth string section harmony 1
- synthetic trumpet sounds 1
- trumpets plays 1
- wide open space 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 2
- Strum 2
- Acoustic guitar 1
- Banjo 1
- Bass guitar 1
- Brass instrument 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Speech 1
- Trumpet 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 | |
Dueling Banjos - Sleepy Man Banjo Boys - Revenge of the Guitar | Two banjo players trade solos in this instrumental song. The song is medium tempo with banjos playing in a call and response manner and no other instrumentation. The song is energetic and has a middle eastern classical music vibe. The audio quality is average and recorded at Jo e. | 2012-03-13T03:15:13Z | Sleepy Man | Become a fan! https://sleepyman.com/fanclub The boys practice a version of Eric Weissberg's "Dueling Banjos" in the Bedroom - Sleepy Man Banjo Boys - 9 Year old Jonny Mizzone (banjo) and his brothers Robbie Mizzone, 13 (fiddle), and Tommy Mizzone,14 (guitar). | ["Banjo", "Music", "Strum"] | ["banjo players", "instrumental duet", "average audio quality", "harmony", "home video recording", "banjo band", "youthful", "classical music", "clean tones", "mysterious", "folk music", "instrumental music", "medium tempo", "banjo playing demonstration", "no percussion instruments", "powerful", "strong tones", "music practice", "no other instrumentation"] | 1 | RFbWkL818XQ | 2685 | |
Pokemon Battle Revolution: Final Battle VS Mysterial (Pearl) + Ending [HD] | The song is an instrumental. The tempo is slow with a synth trumpet playing a lilting melody with supporting keyboard synth accompaniment and no percussion. The song is emotional and powerful. The song is a movie soundtrack. | 2011-04-16T15:55:39Z | KamosProduction | The final battle VS Mystérial ! (With Pokemon PEARL version). No legendairies and no Hack were used. My Pokemon are EV trained. Don't forget that "Renardo" and "Faucheur" are 1,5x quicker and water attacks are 50% more powerful, when it rains. :) Please enjoy, comment, and like ! :) [ WATCH IT IN HD] | ["Brass instrument", "Trumpet"] | ["trumpets plays", "powerful", "epic ending", "synthetic trumpet sounds", "synth string section harmony", "slow tempo", "keyboard accompaniment", "emotional", "wide open space", "epic beginnings", "grand journey", "end credits", "movie soundtrack", "instrumental music", "cinematic experience", "synth horns"] | 1 | iaonijK95qA | 4205 |
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;