musiccaps_details (view)
2 rows where musiccaps_aspects contains "foreign language", musiccaps_aspects contains "male vocalist" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- foreign language · 2 ✖
- male vocalist · 2 ✖
- spirited · 2 ✖
- accordion harmony 1
- bright 1
- classic 1
- club music 1
- dance groove 1
- dance music 1
- dance pop 1
- digital drums 1
- emotional 1
- folk song 1
- funky 1
- german song 1
- groovy 1
- groovy bass line 1
- high spirited 1
- hip-hop pop 1
- lively 1
- lively piano 1
- medium fast 1
- medium tempo 1
- organ accomapniment 1
- passionate 1
- pop 1
- regional song 1
- synthesiser arrangements 1
- vibrant 1
- world music 1
- youthful 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 | |
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;