musiccaps_details (view)
2 rows where musiccaps_aspects contains "accordions" and musiccaps_author = 3
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 16 VELHA TAPERA CAIDA HONEYDE BERTUSSI | This is a live recording of an italian song that is primarily played on the accordions. We have a male vocalist with a mature voice, who sings in a tone that feels a little bit sombre. The music itself has a romantic feeling to it. | 2014-10-01T20:27:49Z | LFV1113 | ["Accordion"] | ["live performance", "accordions", "italian singing", "low quality audio", "romantic", "sombre"] | 3 | hbqdthlv6CU | 4121 | ||
| Cool Accordion Girls - accordeon music mix acordeon crazy power players Akkordeon fisarmonica | Here we have a compilation of songs led by accordions. The first clip is more of a folk ballad with a cheery and uplifting tone to it, the second clip is an emotional ballad. | 2014-03-27T14:23:04Z | Accordeon Accordion Jo Brunenberg | WARNING! Do not take this compilation too seriously :-) It is a compilation with a wink and a smile..... For really serious accordion compilations (10 minutes each) see: CLASSICAL ACCORDION https://youtu.be/2qDCQ3S2Ajo and: MODERN ACCORDION https://youtu.be/_s9dgvFt7Rc JAZZ ACCORDION https://youtu.be/SmiwE7mjtfM Accordion players from amateur to punk. From amateur, to just funny or very professional players. Extremely different accordion styles - Accordion fun. Cool Girls and Ladies playing Accordion. Real Power Players - Chica acordeón. Amazing funny accordion power players, just for fun. Akordeon Muzyka. This video has been included in "Best Accordion Videos": http://accordionvideos.info Featuring amongst many others: "Gipsy girl" Maria Selezneva, Pamela Souriau, Isabelle Lépinay, Accordion Babes, Laurie Black, Kanako Kato, Queen Joan, Christine Schmid, Die Twinnies - Bayernmädels, Ksenija Sidorova, Zoe Tiganouria, あんざいのりえ , accordion girl Melissa Elledge, Miss Natasha Enquist, Ingrid Gatin, Kimberley Pritchard, Sophie's Smokin' Squeezebox, Mllelauriem, Phoebe Legere, Treol, Группа Невесты, Valentina Bajkova, Svetlana Podshivalova, Renee De La Prade, Monsters of Accordion, Ansambel Cebelce - Cebelca , Elena Volodya.... LINKS TO THE ORIGINAL VIDEOS: 0.00 0.08 https://youtu.be/vWOEfwffKxM 0.16 https://youtu.be/BvWLQp7pOp8 0.23 https://youtu.be/aspe3-Wr3dw 0.29 https://youtu.be/YtoXQ8nOuKk 0.36 https://youtu.be/zFlVn0upPo0 0.43 https://youtu.be/6MBfsh1iy_E 0.51 https://youtu.be/g74LyeBT--E 1.00 https://youtu.be/AeyBpqI5LRE 1.05 https://youtu.be/7-Q5uDwhBL0 1.10 https://youtu.be/igoeqWxRg98 1.19 https://youtu.be/G1gNNbqENug 1.23 1.29 https://youtu.be/1QN4NyD6l8A 1.38 https://youtu.be/7LT2TCu31MM 1.47 https://youtu.be/-_es5g6KCVI 1.57 https://youtu.be/XKqcBx5Rp8Q 2.08 https://youtu.be/3nsAdkchlOk0.00 2.16 https://youtu.be/YZNZZTvmm4c 2.24 https://youtu.be/tBUishjdqrg 2.33 https://youtu.be/mdKH5OoKaOg 2.36 https://youtu.be/xDaX5Bs_oqo 2.43 https://yo… | ["Country", "Music"] | ["accordions", "folk music", "emotional accordion ballad", "piano", "live performances"] | 3 | vo-o3dG8Oq0 | 5205 |
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;