musiccaps_details (view)
2 rows where musiccaps_aspects contains "german song" and musiccaps_author = 7 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- accordion harmony 2
- german song · 2 ✖
- alto backup vocals 1
- bright 1
- classic 1
- dulcet 1
- emotional 1
- female vocalist 1
- folk song 1
- foreign language 1
- german folk song 1
- lively 1
- male vocalist 1
- medium tempo 1
- mellow 1
- mellow acoustic guitar 1
- melodious 1
- organ accomapniment 1
- passionate 1
- peaceful 1
- pleasant 1
- regional song 1
- soft 1
- soft elbow 1
- soothing 1
- spirited 1
- swiss folk song 1
- vibrant 1
- vocal backup 1
- world music 1
musiccaps_names (array) 2 ✖
- Christmas music 2
- Music 2
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oesch's die Dritten - Ein Jodler für's Christkind 2012 | A female vocalist sings this soft melody. The song is slow tempo with accordion harmony and acoustic guitar accompaniment and alto vocal harmony. The song is mellow, soft, pleasant, dulcet, emotional, romantic and nostalgic. This song is a Swiss/German folk song. | 2012-12-25T03:35:04Z | fritz5109 | Oesch's die Dritten - Ein Jodler für's Christkind 2012 Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) Hundert Tage ist es Winter und es fällt der weisse Schnee leise höre ich die Glocken von der Kirche in der Näh'. Aller Trubel ist vergessen, endlich ist es nun soweit Frohe, frohe Weihnachtszeit. Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) | ["Christmas music", "Music"] | ["female vocalist", "vocal backup", "accordion harmony", "german folk song", "soft", "mellow", "melodious", "alto backup vocals", "swiss folk song", "german song", "soft elbow", "dulcet", "pleasant", "soothing", "peaceful", "mellow acoustic guitar"] | 7 | BXUS7pTYDzI | 1252 | |
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 |
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;