musiccaps_details (view)
7 rows where musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "positive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 114 ✖
- poor audio quality · 7 ✖
- positive · 7 ✖
- medium tempo 5
- cheerful 3
- emotional 3
- groovy bass line 3
- instrumental music 3
- male singer 3
- exciting 2
- funny 2
- groovy rhythm 2
- guitar rhythm 2
- people screaming 2
- romantic 2
- adrenaline rush 1
- adventurous 1
- advertisement jingle 1
- amateur musician 1
- amateur tourist video 1
- ambient crowd noises 1
- ambient room noises 1
- ambient room notes 1
- ambient street noise 1
- aural development 1
- bass drum hits 1
- bell tones 1
- bouncy rhythm 1
- child development 1
- cool 1
- cool bass solo 1
- cool drum roll 1
- couples dan 1
- crowds cheering 1
- crowds laughing 1
- dance music 1
- distorted guitar lead 1
- documentary video soundtrack 1
- documentary soundtrack 1
- drilling noises 1
- drum sticks 1
- entertaining 1
- family gatherings 1
- fast tempo 1
- fats tempo 1
- festive spirit 1
- folk dance music 1
- funk pop music 1
- funky groove 1
- funny video 1
- groovy bas slime 1
- guitar accompaniment 1
- guitar strumming 1
- hand saw 1
- handicapped man 1
- happy 1
- harpist 1
- head bangers 1
- hip hop drumming rhythm 1
- inspiring 1
- instrumental duo 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
- people talking 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
- sawing noise 1
- screaming vocals 1
- sentimental 1
- show tune 1
- slow tempo 1
- soft music background track 1
- song cover 1
- south american folk music 1
- steady drumming rhythm 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
- togetherness 1
- tom sounds 1
- traditional custom dance 1
- video soundtrack’ toms sounds 1
- violinist 1
- visual stimulation 1
- vocal male monologue 1
- youthful 1
- youtube tutorial 1
musiccaps_names (array) 34 ✖
- Music 5
- Guitar 2
- Acoustic guitar 1
- Bass drum 1
- Bass guitar 1
- Bell 1
- Bowed string instrument 1
- Christian music 1
- Cymbal 1
- Dental drill, dentist's drill 1
- Drum 1
- Drum kit 1
- Grunge 1
- Harp 1
- Heavy metal 1
- Hi-hat 1
- Musical instrument 1
- Percussion 1
- Pizzicato 1
- Plucked string instrument 1
- Progressive rock 1
- Psychedelic rock 1
- Rimshot 1
- Rock music 1
- Rub 1
- Sawing 1
- Snare drum 1
- Song 1
- Speech 1
- Strum 1
- Tambourine 1
- Tools 1
- Violin, fiddle 1
- Wood 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 | |
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
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 | |
JS-7 Japanese Hand Saw | The song is an instrumental. The tempo is medium with ambient sounds like a sawing tool sounds, guitar rhythm, bass guitar solo and a steady drumming with various percussion hits. The song is an advertisement jingle for a tool works company. The sound quality is average with ambient room sounds. | 2009-03-24T01:04:51Z | Bridge City Tool Works | A look at Bridge City Tool Works Adjustable Back Rip and Crosscut Japanese Saw. | ["Sawing", "Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Tools", "Rub", "Wood", "Bass drum", "Percussion"] | ["hand saw", "instrumental music", "documentary video soundtrack", "advertisement jingle", "poor audio quality", "bouncy rhythm", "tom sounds", "sawing noise", "medium tempo", "cool bass solo", "steady drumming rhythm", "groovy rhythm", "video soundtrack’ toms sounds", "drum sticks", "cool drum roll", "bass drum hits", "exciting", "positive", "cheerful", "funky groove", "funk pop music"] | 1 | ZCR7qJ2IgGI | 3347 | |
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;