musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "funny" and musiccaps_author = 1 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- cheerful 2
- funny · 2 ✖
- amateur tourist video 1
- ambient street noise 1
- animated male vocals 1
- animated yodelling 1
- bad quality audio 1
- brass band 1
- children dancing 1
- children’s song 1
- comical 1
- crowds laughing 1
- dance music 1
- deteriorated music 1
- emotional 1
- excited 1
- groovy bas slime 1
- guitar rhythm 1
- guitar strumming 1
- guitars strumming rhythm 1
- handicapped man 1
- inspiring 1
- jovial 1
- look ma no hands 1
- male singer 1
- man talking 1
- medium fast tempo 1
- medium tempo 1
- motivational 1
- never give 1
- no other instruments 1
- poor audio quality 1
- poor audio recording 1
- positive 1
- powerful 1
- retro pop 1
- song cover 1
- steady marching drum rhythm 1
- story telling 1
- strength 1
- trumpets play percussively 1
- yodelling song 1
musiccaps_names (array) 9 ✖
- Music 2
- Acoustic guitar 1
- Bass guitar 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Speech 1
- Strum 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Yodeling Veterinarian of the Alps (Silly Songs with Larry) | A male singer sings in an animated manner. The song is medium fast tempo with a steady drumming rhythm, brass band accompaniment, groovy bass line and guitar strumming rhythm. The song is exciting and cheerful. The song is an animated children’s show tune, but a poor recording of the actual show. | 2010-07-09T06:04:42Z | wez adora | Awesome and Funny :D HHAAHAHAHA | ["Yodeling", "Music"] | ["animated male vocals", "yodelling song", "comical", "poor audio recording", "bad quality audio", "deteriorated music", "children’s song", "excited", "trumpets play percussively", "brass band", "steady marching drum rhythm", "groovy bas slime", "guitars strumming rhythm", "story telling", "dance music", "animated yodelling", "funny", "excited", "children dancing", "cheerful", "medium fast tempo"] | 1 | mOn13E68Td0 | 4467 | |
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 |
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;