musiccaps_details (view)
5 rows where musiccaps_aspects contains "accordion melody", musiccaps_names = "["Accordion"]" and musiccaps_names contains "Accordion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Denis Novato | The low quality recording features an accordion melody, electric guitar melody and trombone melody, after which there is a crowd clapping, laughing and chattering sounds. There are also tinny glass impacts in the background. It gives off fun and happy vibes. | 2008-07-13T14:34:40Z | buttonbox | Denis plays at Slovenefest XXVII | ["Accordion"] | ["low quality", "accordion melody", "electric guitar melody", "trombone melody", "crowd clapping", "laughing", "crowd chattering", "fun", "happy", "tinny glass impacts"] | 4 | TWnrcjA6VTk | 2842 | |
online 2 battle il-2 video | This music is a simple and pleasing instrumental. The tempo is medium fast with a cheerful accordion harmony. The music is minimalist,simple, cheerful, happy, fun, carefree, jolly and lighthearted. | 2009-07-12T04:42:37Z | Technonoob | short vid of ingame footage | ["Accordion"] | ["instrumental", "medium fast tempo", "lighthearted", "accordion melody", "accordion solo", "lively", "simple", "fun", "breezy", "cheerful", "chirpy", "enthusiastic", "carefree"] | 7 | tDVOUsG52Jw | 5015 | |
The Kesh Jig | The low quality recording features a steel guitar melody, followed by accordion melody. There are some popping sounds and it sounds passionate, happy and joyful. | 2008-06-02T17:08:05Z | busketeer | Allround good session tune | ["Accordion"] | ["low quality", "noisy", "steel guitar melody", "accordion melody", "popping sounds", "passionate", "happy", "joyful"] | 4 | tsdNl72WVs4 | 5072 | |
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 |
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;