musiccaps_details (view)
4 rows where musiccaps_aspects contains "ambient street noise" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 69 ✖
- ambient street noise · 4 ✖
- poor audio quality · 4 ✖
- medium tempo 3
- instrumental music 2
- male singer 2
- amateur tourist video 1
- arabic folk singer 1
- army band 1
- band arrangement 1
- bell vibrations 1
- birds chirping 1
- calm 1
- cheerful 1
- church 1
- crowd noise 1
- crowds laughing 1
- devotional 1
- different tones 1
- drum beats 1
- emotional 1
- excited vocals 1
- faith music 1
- flutes playing in unison 1
- folk singer 1
- funny 1
- gong sounds 1
- groovy bass line 1
- guitar rhythm 1
- guitar strumming 1
- handicapped man 1
- healing 1
- home video 1
- inspiring 1
- jovial 1
- live audience 1
- live band 1
- live march 1
- live performance 1
- look ma no hands 1
- man talking 1
- marching band 1
- marching rhythm 1
- meditational 1
- motivational 1
- nature sounds 1
- never give 1
- no other instruments 1
- overtones 1
- people marching 1
- people talking 1
- percussions sounds 1
- positive 1
- powerful 1
- prayers 1
- religious 1
- retro pop 1
- school band 1
- screaming 1
- serene 1
- social activism 1
- song cover 1
- spiritual 1
- steady drumming rhythm 1
- steady rhythm 1
- strength 1
- temple 1
- temple bells 1
- violin playing solo 1
- wedding music 1
musiccaps_names (array) 13 ✖
- Music 2
- Speech 2
- Acoustic guitar 1
- Bagpipes 1
- Bass guitar 1
- Bell 1
- Guitar 1
- Jazz 1
- Musical instrument 1
- Orchestra 1
- Plucked string instrument 1
- Strum 1
- Wind instrument, woodwind instrument 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 | |
Vercelli - Campana della vita - | The song track is instrumental. The tempo is medium with temple bells being played to create two distinct tones with long vibrations creating clear overtones. The soundtrack is calming and deeply religious. The audio track quality is poor with ambient environment noises. | 2007-06-25T19:40:04Z | Giovanni Ottone | Questa campana si trova in un giardino della Parrocchia di S.Pietro Apostolo a Vercelli... Fusa nel 2000 (Trebino) pesa 3600kg Nota nominale LA2 | ["Bell"] | ["temple bells", "different tones", "gong sounds", "prayers", "temple", "church", "faith music", "overtones", "ambient street noise", "birds chirping", "instrumental music", "medium tempo", "poor audio quality", "nature sounds", "calm", "serene", "bell vibrations", "healing", "spiritual", "religious", "meditational", "devotional", "home video"] | 1 | _Slo8QXYOp8 | 3472 | |
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
Ross Kemp joins Orange Order Feeder Parade. 12 July 2013....5 | The music track is that of a band marching in the streets. The tempo is medium with a Band march, playing percussion in a steady rhythm accompanied by flutes playing in unison. The song has bad audio quality with ambient noises of people talking and other street noises. | 2013-07-12T12:43:57Z | william belfast | Orange Order Feeder Parade www.newsflare.com | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["live march", "marching band", "instrumental music", "flutes playing in unison", "steady rhythm", "drum beats", "marching rhythm", "percussions sounds", "people marching", "social activism", "army band", "school band", "band arrangement", "poor audio quality", "ambient street noise", "people talking"] | 1 | v9TTtjEngjY | 5159 |
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;