musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_aspects contains "positive" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- cheerful · 3 ✖
- positive · 3 ✖
- emotional 2
- guitar strumming 2
- medium tempo 2
- african feeling 1
- amateur tourist video 1
- ambient street noise 1
- bad audio quality 1
- banjo 1
- child performers 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- crowds laughing 1
- dance rhythm 1
- fiddlers 1
- funny 1
- groovy rhythm 1
- guitar rhythm 1
- handicapped man 1
- happy 1
- inspiring 1
- instrumental music 1
- jovial 1
- live performance 1
- look ma no hands 1
- male singer 1
- man talking 1
- marimba 1
- motivational 1
- never give 1
- never give up 1
- no other instruments 1
- passionate 1
- poor audio quality 1
- powerful 1
- retro pop 1
- shaker 1
- song cover 1
- spirited 1
- strength 1
- the country life 1
- the wild west 1
- traditional music 1
- tropical feeling 1
- violinists 1
musiccaps_names (array) 14 ✖
- Musical instrument · 3 ✖
- Music 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Bass guitar 1
- Bowed string instrument 1
- Country 1
- Guitar 1
- Marimba, xylophone 1
- Percussion 1
- Speech 1
- Strum 1
- Vibraphone 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 | |
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
Linus and Lucy (Marimba Solo) | A Charlie Brown Christmas | by Matt Nickle | This is a fun, cheerful and positive song played on the marimba. Percussively, we heard a shaker and some hand tapping on a hard surface. The song creates a light mood and has an African vibe. | 2012-12-24T17:57:22Z | Matt Nickle | SUBSCRIBE http://www.youtube.com/subscription_center?add_user=mattnicklemusic FACEBOOK https://www.facebook.com/pages/Matt-Nickle-Music/238163932924752 Linus and Lucy is not the most traditional Christmas music to play, but I have always loved this song from "A Charlie Brown Christmas". Vince Guaraldi is an amazing composer and performer and I enjoy the jazz influence that he has used in Linus and Lucy. It adds a flavor that is not only fun to play, but is also fun for everyone to listen to. Merry Christmas! Enjoy! Subscribe! EQUIPMENT/SOFTWARE USED FOR THIS VIDEO (Affiliate Links) Recording Equipment Recording Software http://amzn.to/2suJnCP Pitch and Audio Software http://amzn.to/2tem25i M Audio Interface http://amzn.to/2sUW7Qt M-Audio USB Midisport Uno http://amzn.to/2rTrL2z Beyerdynamic Headphones http://amzn.to/2sVbEA1 AKG Headphones http://amzn.to/2ro9vuK Headphone Amp - 4 Channels http://amzn.to/2sVg0Hk Microphone http://amzn.to/2rjTnz5 Mic cord http://amzn.to/2teqOiV Pop Filter http://amzn.to/2teglnE Portable Recording Booth http://amzn.to/2ro6JWd Mic Stand http://amzn.to/2slul2z Video Equipment (Affiliate Links) Camera http://amzn.to/2rTPAHD 50mm Lens http://amzn.to/2ropjxo Camera Slider http://amzn.to/2sh4d8s Video Editing Software http://amzn.to/2sh2TSJ Instrument Equipment (Affiliate Links) Marimba http://amzn.to/2sgS3fP Graphics Card http://amzn.to/2sVjIAw Computer Monitors http://amzn.to/2rowdTd WD Passport External Hard Drive http://amzn.to/2ronSip M-Audio Speakers http://amzn.to/2rjAGvA | ["Musical instrument", "Marimba, xylophone", "Vibraphone", "Percussion"] | ["marimba", "shaker", "african feeling", "tropical feeling", "happy", "positive", "cheerful"] | 3 | RFNRR78dh-8 | 2684 |
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;