musiccaps_details (view)
2 rows where musiccaps_aspects contains "bright" and musiccaps_aspects contains "emotional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bright · 2 ✖
- emotional · 2 ✖
- accordion harmony 1
- ballad 1
- classic 1
- folk song 1
- foreign language 1
- german song 1
- heartfelt female vocals 1
- inspirational string section 1
- inspiring piano melody 1
- lively 1
- low tempo 1
- male vocalist 1
- medium tempo 1
- organ accomapniment 1
- passionate 1
- r&b 1
- regional song 1
- romantic 1
- slow tempo 1
- soft drum kit 1
- soul 1
- spirited 1
- vibrant 1
- world music 1
musiccaps_names (array) 3 ✖
- Music 2
- Christmas music 1
- Tender music 1
youtube_published (date) 2 ✖
- 2007-04-15 1
- 2011-05-05 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 | |
Cinderella III: A Twist in Time - Please Remember | The track is an emotional love ballad that features heartfelt female vocals. Piano chords play in the background as a string section that sounds inspiring sustains chords. A drum kit plays a slow beat that adds to the romantic mood of the song. | 2007-04-15T07:04:50Z | disneyscarlos | So, I finally gathered up my courage to add a new and improved version of my classic fan video of Cinderella III: A Twist in Time *amazing sequel* with the song "Please Remember" from Cayote Ugly! Comment and rate! | ["Music", "Tender music"] | ["emotional", "bright", "heartfelt female vocals", "low tempo", "inspiring piano melody", "ballad", "soul", "r&b", "romantic", "slow tempo", "soft drum kit", "inspirational string section"] | 5 | W7U-glgu4GM | 3067 |
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;