musiccaps_details (view)
5 rows where musiccaps_aspects contains "mono" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- low quality 5
- mono · 5 ✖
- noisy 5
- accordion melody 3
- flat male vocal 3
- passionate 3
- happy 2
- joyful 2
- accordion chords 1
- acoustic rhythm guitar 1
- emotiona 1
- female laugh 1
- folk 1
- groovy 1
- groovy accordion melody 1
- groovy bass 1
- live performance 1
- male laugh 1
- passionate accordion melody 1
- playback 1
- regional mexican 1
- saxophone solo melody 1
- shimmering tambourine 1
- soulful 1
musiccaps_names (array) 6 ✖
- Accordion · 5 ✖
- Bowed string instrument 1
- Harmonica 1
- Music 1
- Musical instrument 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Кулунду Лейлек и Омурбек 1 | The low quality recording features a flat male vocal talking and playing a groovy accordion melody, before which a male and a female laugh. It sounds passionate and groovy. | 2014-10-26T17:36:15Z | Baktygul Aitemirova | Кулунду Лейлек и Омурбек | ["Accordion"] | ["low quality", "groovy accordion melody", "flat male vocal", "male laugh", "female laugh", "noisy", "mono", "passionate", "groovy"] | 4 | 0u1sk49gAU0 | 219 | |
Julio Chaidez Hombre de Negocios | The low quality recording features an accordion melody played over regional Mexican playback that consists of accordion chords, groovy bass and flat male vocal singing over it. The recording is in mono, noisy and it sounds emotional and passionate. | 2009-05-27T05:57:03Z | jgg171990 | Tono de Sib | ["Accordion"] | ["regional mexican", "low quality", "mono", "noisy", "playback", "groovy bass", "accordion chords", "flat male vocal", "accordion melody", "passionate", "emotiona"] | 4 | FLJPxFCPeDY | 1638 | |
Harp Octave demo | The low quality recording features a flat male vocal talking, after which an accordion melody starts playing. It sounds joyful and happy, even though the recording is noisy. | 2009-04-28T12:04:48Z | Mats Rosén | Awesome pedal from Lone Wolf Company. http://www.lwharpamps.com/ | ["Harmonica", "Bowed string instrument", "Accordion"] | ["low quality", "noisy", "mono", "flat male vocal", "accordion melody", "joyful", "happy"] | 4 | s72505MIhz8 | 4926 | |
Mircea Gutanu & Romica Raiu | The low quality recording features a live performance of a folk song that consists of a saxophone solo melody, accordion melody and acoustic rhythm guitar. It sounds passionate and soulful. The recording is mono and noisy. | 2013-02-27T22:35:33Z | 5555kinder | ["Accordion"] | ["low quality", "live performance", "folk", "noisy", "mono", "saxophone solo melody", "accordion melody", "acoustic rhythm guitar", "passionate", "soulful"] | 4 | vpcEBryyej4 | 5209 | ||
Tarantella calabrese - Organetto e tamburello (accordion and tambourine) | The low quality recording features a passionate accordion melody playing over a shimmering tambourine. It sounds joyful, happy and the recording is noisy and in mono. | 2011-01-16T09:00:36Z | Francesco Iacopino | Una tarantella calabrese suonata all'organetto e tamburello. Artisti: Giuseppe (organetto) e suo padre Leo (tamburello) A calabrian tarantella performed with accordion and tambourine. Artists: Giuseppe (accordion) and his father Leo (tambourine) | ["Music", "Musical instrument", "Tambourine", "Accordion"] | ["low quality", "shimmering tambourine", "passionate accordion melody", "joyful", "happy", "noisy", "mono"] | 4 | xxNroISqkt4 | 5368 |
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;