musiccaps_details (view)
1 row where musiccaps_aspects contains "accordion harmony", musiccaps_aspects contains "alto backup vocals", musiccaps_aspects contains "melodious" and musiccaps_author = 7
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;