musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- groovy · 3 ✖
- low quality 2
- passionate 2
- accordion harmony 1
- accordion lessons 1
- accordion melody 1
- accordion player 1
- bad audio quality 1
- cheerful 1
- crowd chattering 1
- electric guitar melody 1
- emotional 1
- female laugh 1
- flat male vocal 1
- folk 1
- groovy accordion melody 1
- groovy bass 1
- high gain music 1
- home recording 1
- instrumental music 1
- lilting music 1
- live performance 1
- male laugh 1
- melancholic 1
- mono 1
- noisy 1
- punchy snare 1
- romantic 1
- screechy tones 1
- shimmering hi hats 1
- slow tempo 1
- soloist 1
- youtube music video 1
musiccaps_names (array) 8 ✖
- Accordion · 3 ✖
- Music 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Singing 1
- Speech 1
- Traditional music 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 | |
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 |
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;