musiccaps_details (view)
5 rows where musiccaps_aspects contains "poor audio quality", musiccaps_aspects contains "positive" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 86 ✖
- poor audio quality · 5 ✖
- positive · 5 ✖
- male singer 3
- medium tempo 3
- emotional 2
- funny 2
- groovy bass line 2
- guitar rhythm 2
- people screaming 2
- adrenaline rush 1
- adventurous 1
- amateur musician 1
- amateur tourist video 1
- ambient room noises 1
- ambient room notes 1
- ambient street noise 1
- aural development 1
- bell tones 1
- cheerful 1
- child development 1
- cool 1
- crowds cheering 1
- crowds laughing 1
- distorted guitar lead 1
- documentary soundtrack 1
- drilling noises 1
- entertaining 1
- exciting 1
- fast tempo 1
- fats tempo 1
- funny video 1
- groovy bas slime 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar strumming 1
- handicapped man 1
- happy 1
- head bangers 1
- hip hop drumming rhythm 1
- inspiring 1
- instrumental music 1
- jovial 1
- joyful cheerful 1
- keyboard accompaniment 1
- keyboard percussive tones 1
- kindergarten songs 1
- live performance 1
- look ma no hands 1
- male rap singer 1
- man talking 1
- memdium tempo 1
- modern 1
- motivational 1
- motor engine sound 1
- motor skills 1
- music box harmony 1
- never give 1
- no other instruments 1
- nursery rhyme 1
- percussion instruments 1
- powerful 1
- retro classic rock 1
- retro pop 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- screaming vocals 1
- show tune 1
- slow tempo 1
- soft music background track 1
- song cover 1
- story telling 1
- strength 1
- strong bass drops 1
- strong drumming rhythm 1
- syncopated rhythm 1
- tambourine man 1
- tambourine percussions 1
- toddler tunes 1
- toddler’s attention 1
- visual stimulation 1
- vocal male monologue 1
- youthful 1
- youtube tutorial 1
musiccaps_names (array) 18 ✖
- Music · 5 ✖
- Guitar 2
- Acoustic guitar 1
- Bass guitar 1
- Bell 1
- Christian music 1
- Dental drill, dentist's drill 1
- Grunge 1
- Heavy metal 1
- Musical instrument 1
- Plucked string instrument 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Song 1
- Speech 1
- Strum 1
- Tambourine 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 | |
01.10.11 Phase I - Ripping up track, removing scenery and Backdrop on the Socal Desert HO Layout | A male artist talks and makes drilling noises. The song is a modern hip hop song with male rap vocals, hip hop drumming rhythm, heavy bass drops and keyboard harmony. The track has ambient room noises and the music track is very faint. The audio quality is very average. | 2011-01-11T02:20:52Z | MonsterRailroad | Well here is Part 1 of a three part series to complete this "re-tracking" | ["Music", "Dental drill, dentist's drill"] | ["vocal male monologue", "drilling noises", "youtube tutorial", "medium tempo", "documentary soundtrack", "modern", "cool", "positive", "groovy bass line", "ambient room notes", "male rap singer", "memdium tempo", "groovy bas slime", "hip hop drumming rhythm", "syncopated rhythm", "groovy rhythm", "soft music background track", "documentary soundtrack", "poor audio quality", "strong bass drops", "keyboard percussive tones"] | 1 | 4HfU5OQUqq0 | 553 | |
Wii Music: Twinkle Twinkle Little Star, the Bell Chorus | The song is an instrumental. The tempo is slow with percussive instruments playing, bells percussions and a music box melody. The song is educational and designed for toddlers. The audio quality is pretty average. | 2008-10-30T23:53:45Z | Beastly Drohan | One of the best things about Wii Music is that you can arrange a song using the same instrument, creating some awesome choruses. With "Twinkle Twinkle Little Star" I created a bell chorus version. I honestly don't like the setting I chose, though. Anyways, forgive the video quality and enjoy! | ["Bell", "Music"] | ["nursery rhyme", "motor engine sound", "toddler’s attention", "aural development", "child development", "emotional", "happy", "positive", "visual stimulation", "motor skills", "percussion instruments", "bell tones", "music box harmony", "slow tempo", "instrumental music", "poor audio quality", "kindergarten songs", "toddler tunes"] | 1 | XykUpCigu4w | 3242 | |
Tambourine Master Transforms Into Super Gonzo! | Asia’s Got Talent Semis 1 | The song is an instrumental track for a live performance act. The song is medium tempo with a male singer singing to a strong drumming rhythm, groovy bass line, keyboard accompaniment along with an amateur playing tambourine percussion. The song has poor audio quality. | 2015-04-16T13:52:34Z | Asia's Got Talent | It’s a bird, it’s a plane….no, no, it’s: SUPER GONZO! Watch the tambourine master transform and shake his tambourine for world peace! | ["Music", "Tambourine"] | ["live performance", "tambourine man", "fast tempo", "poor audio quality", "funny video", "crowds cheering", "ambient room noises", "people screaming", "amateur musician", "joyful cheerful", "positive", "funny", "entertaining", "adrenaline rush", "male singer", "fats tempo", "strong drumming rhythm", "guitar accompaniment", "keyboard accompaniment", "show tune", "tambourine percussions"] | 1 | fer_4HvG3aY | 3967 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;