musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional" and "youtube_published" is on date 2011-05-05
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- emotional · 2 ✖
- accordion harmony 1
- ballad 1
- bright 1
- classic 1
- folk song 1
- foreign language 1
- german song 1
- groovy hi hats 1
- heartfelt 1
- lively 1
- male vocalist 1
- medium tempo 1
- mellow female vocal 1
- mellow organ keys melody 1
- organ accomapniment 1
- passionate 1
- regional song 1
- romantic 1
- smooth bass 1
- soft kick hits 1
- soft snare hits 1
- spirited 1
- vibrant 1
- world music 1
musiccaps_names (array) 7 ✖
- Music 2
- Christmas music 1
- Classical music 1
- Music of Asia 1
- Singing 1
- Song 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ruedi Rymann-Dr Schacher Seppli | A male vocalist sings this animated melody. The song is minimal instrumentation with a bright accordion harmony and organ accompaniment. It is perky, animated, bright, energetic, enthusiastic, and vibrant. This song is a classic German folk song. | 2011-05-05T23:11:36Z | MultiAymen | Rudolf «Ruedi» Rymann (* 31. Januar 1933 in Sarnen; † 10. September 2008 in Giswil) war ein Jodler, Sänger und Komponist aus Giswil im Kanton Obwalden. Als einer der bekanntesten Schweizer Jodler ist er auch in den USA, in Japan, Südkorea und Brasilien aufgetreten. Leider ist er im September 2008 gestorben. Ich höre gerne seine Lieder, insbesondern dieses Lied weil es ein schweizerisches traditionelles Lied ist. | ["Christmas music", "Music"] | ["male vocalist", "medium tempo", "accordion harmony", "folk song", "regional song", "world music", "german song", "organ accomapniment", "spirited", "lively", "vibrant", "passionate", "emotional", "bright", "classic", "foreign language"] | 7 | UOKWQ2EHJQI | 2913 | |
Famous paintings of wedding and marriage (Music: I dream of you/Sha la la love song) | The ballad song features a mellow female vocal singing over a mellow organ keys melody, groovy hi hats, soft snare and kick hits and smooth bass. It sounds emotional, heartfelt and romantic - like something you would hear at a wedding. | 2011-05-05T16:33:05Z | isisip | Famous paintings of wedding and marriage in the history of art. Artists include: John Henry Frederick Bacon, Tuxen Laurits, Pierre-Auguste Renoir, Firs Sergeevich Zhuravlev, Edmund Blair Leighton, Harrison Fisher. If you are interested in knowing the titles of the paintings, please visit http://weddingdressmarriage.blogspot.com/ Song: I dream of you Words and Music by: Isisip Performed by :Isisip (C) 2008-2011 Isisip MP3 available at http://www.pianomusicdownload.blogspot.com See also: Sad beauty piano solo in 3 keys https://www.youtube.com/watch?v=IE95p3edfIg Top 10 piano songs https://www.youtube.com/watch?v=fKxmSe5s9_s Piano music playlist https://www.youtube.com/watch?v=K0mXJ-QYIRw The unfinished story piano performance https://www.youtube.com/watch?v=N06aA_vjZPA Moonlight piano performance https://www.youtube.com/watch?v=NFcPR5WgeQA Sad beauty piano performance https://www.youtube.com/watch?v=DgbdWyTtWco Ask the sky without words piano performance https://www.youtube.com/watch?v=EnJSIOaPxp0 Please buy the music or make a donation: http://pianodiscography.blogspot.com Sheet music: http://isisippianosheetmusic.blogspot.com | ["Singing", "Music of Asia", "Music", "Wedding music", "Song", "Classical music"] | ["ballad", "mellow organ keys melody", "groovy hi hats", "soft kick hits", "soft snare hits", "smooth bass", "mellow female vocal", "emotional", "heartfelt", "romantic"] | 4 | g0scnRzoo9M | 4003 |
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;