musiccaps_details (view)
3 rows where musiccaps_aspects contains "cheerful", musiccaps_author = 1 and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- cheerful · 3 ✖
- instrumental music 3
- accordion harmony 2
- bad audio quality 2
- emotional 2
- melancholic 2
- slow tempo 2
- accordion accompaniment 1
- accordion lessons 1
- accordion player 1
- accordion players 1
- accordion trio 1
- average sound quality 1
- casual 1
- dance rhythm 1
- energetic 1
- entertaining 1
- friends get together 1
- groovy 1
- groovy rhythm 1
- gypsy music 1
- gypsy music influences 1
- high gain music 1
- home music jam 1
- home music video 1
- home recording 1
- house party 1
- idyllic fun 1
- life is beautiful 1
- lilting melody 1
- lilting music 1
- medium tempo 1
- nostalgic 1
- parisian streets 1
- peaceful relaxing 1
- positive 1
- retro instrumental 1
- romantic 1
- screechy tones 1
- slow paced 1
- soloist 1
- the good life 1
- youtube music video 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PABLITO CERRANO Y ARIEL TORRES A PURO CHAMAME | The song is an instrumental. The song is medium tempo with two accordion players playing on harmony and no other instrumentation. The music is romantic and passionate. The song has gypsy music roots. | 2012-11-01T00:48:18Z | RAM TOR | POR CONTRATACIONES COMUNICARSE AL( 03844)(15)468108 | ["Accordion"] | ["accordion players", "accordion accompaniment", "gypsy music influences", "emotional", "dance rhythm", "retro instrumental", "nostalgic", "entertaining", "cheerful", "positive", "the good life", "idyllic fun", "instrumental music", "bad audio quality", "groovy rhythm", "medium tempo"] | 1 | Jsk3ZUGvP-o | 2042 | |
Vals till Marie | The song is an instrumental. The song is slow tempo with three accordions playing in harmony and in a relaxed manner. The song is beautiful and romantic. The audio quality is average and an amateur home recording. | 2013-02-09T15:57:01Z | Dragzpel | Vals till Marie, Komponerad av Kjell Nilsson i Lidhult.Här framförd av Kjell tillsammans med Siv & Ingvar Karlsson. ZOOM Handy Video Recorder | ["Accordion"] | ["accordion trio", "accordion harmony", "instrumental music", "home music video", "average sound quality", "home music jam", "friends get together", "house party", "slow tempo", "parisian streets", "gypsy music", "lilting melody", "casual", "peaceful relaxing", "energetic", "slow paced", "life is beautiful", "cheerful", "melancholic"] | 1 | NUTaOnEhvzE | 2340 | |
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;