musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic rhythm guitar chord progression" and musiccaps_author = 4 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- acoustic rhythm guitar chord progression · 2 ✖
- low quality 2
- acoustic 1
- blues 1
- crowd talking 1
- dull 1
- groovy 1
- haunting female vocal 1
- live performance 1
- nasal male vocal 1
- noisy 1
- smooth double bass 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Love me tender" by matrioshka shaped theremin "Matryomin" | The low quality recording features a haunting female vocal singing over mellow rhythm guitar chord progression. The recording is extremely noisy, as it was probably recorded with an old phone. | 2007-02-03T23:04:02Z | Masami1920 | http://www.mandarinelectron.com/ https://www.facebook.com/mandarinelectron Performance of matryomin(matrioshka shaped theremin). https://twitter.com/masaming10 | ["Music", "Theremin"] | ["low quality", "acoustic rhythm guitar chord progression", "haunting female vocal", "noisy"] | 4 | zgI-Lr6Pbcs | 5503 | |
Lonesome Blues - Acoustic Guitar & Double Bass | The low quality recording features a live performance of a blues song that consists of nasal male vocal singing over acoustic rhythm guitar chord progression and smooth double bass. There are also some crowd talking noises. It sounds groovy and kind of dull, since it is probably recorded with a phone. | 2012-06-03T10:13:40Z | wehappyfewmusic | This is one of our new tunes called The Lonesome Blues played at a charity fund raising gig at Teddington School. | ["Blues", "Country", "Flamenco", "Music"] | ["low quality", "acoustic", "live performance", "blues", "acoustic rhythm guitar chord progression", "smooth double bass", "crowd talking", "nasal male vocal", "groovy", "dull"] | 4 | ZLDQ8-8AyI4 | 3364 |
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;