musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic rhythm guitar" and musiccaps_names contains "Flamenco" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 20 ✖
- acoustic rhythm guitar · 3 ✖
- low quality 3
- noisy 3
- camera beeping sounds 1
- camera shuttering sounds 1
- child talking 1
- country melody 1
- crowd chattering 1
- emotional 1
- fun 1
- happy 1
- indie 1
- laughing 1
- live performance 1
- mixed background vocals 1
- muffled 1
- passionate 1
- passionate male vocal 1
- sad 1
- soft double bass 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
niña bailando flamenco | The low quality recording features a mixed background vocals singing over acoustic rhythm guitar. There is also a child talking over the song. The recording is noisy and muffled, but it sounds fun and happy. | 2009-11-20T01:31:05Z | lamujerdelapaxe | esta niña aqui tenia 5 años bailando por alegrias en ponferrada se llama silvia moreno | ["Flamenco", "Music"] | ["low quality", "mixed background vocals", "acoustic rhythm guitar", "child talking", "muffled", "noisy", "fun", "happy"] | 4 | jqiD3VeM_hY | 4284 | |
Blind Pilot "Three Rounds and a Sound" (3 of 4) Indie Pop from Portland, OR | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | 2010-03-17T20:59:05Z | One Night Music | One Night Music recorded Blind Pilot at Muddy Waters Cafe in Santa Barbara, CA on August 1, 2009. Find all 4 videos and a story at: http://www.onenightmusic.com/blog/post/love-at-muddy-waters-rey-villalobos-and-blind-pilot/ Filmed and edited by Megan Sullivan Audio editing by Ryan Andersen Filmed with VADO HD, audio with Zoom H2. Follow us: http://www.twitter.com/onenightmusic http://www.facebook.com/onenightmusic http://www.onenightmusic.com One Night Music is a San Francisco based collective of volunteers creating high quality video and audio recordings of live performances by quality independent music artists. Learn how to record with us or how to volunteer with us at http://www.OneNightMusic.com/about | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | 4 | QtjMlA_7dds | 2647 | |
Abby Lee Master Dance Class | The low quality recording features a live performance of a country melody on an acoustic rhythm guitar. There are some camera shuttering and beeping sounds in the background. | 2013-03-05T06:37:01Z | F. Serratos | Maddie, Nia, Kendall, Makenzie, Gianna, and Miranda from Dance moms perform in Los Angeles | ["Flamenco", "Music"] | ["low quality", "camera shuttering sounds", "acoustic rhythm guitar", "noisy", "country melody", "camera beeping sounds"] | 4 | NxpnW_IdkSY | 2382 |
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;