musiccaps_details (view)
5 rows where musiccaps_aspects contains "foreign language", musiccaps_aspects contains "passionate" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 75 ✖
- emotional 5
- foreign language · 5 ✖
- passionate · 5 ✖
- medium tempo 3
- intense 2
- keyboard harmony 2
- male singer 2
- male vocalist 2
- accordion harmony 1
- acousitc guitar 1
- anthem 1
- baritone 1
- bass 1
- bass guitar 1
- bongos 1
- bright 1
- burgeoning music 1
- choral harmony 1
- church organ 1
- classic 1
- congas 1
- crowd chatter 1
- dance groove 1
- dance music 1
- devotion 1
- eloquent vocals 1
- emphatic 1
- enthusiastic 1
- fast tempo 1
- female backup 1
- folk song 1
- german song 1
- greek song 1
- hand drums 1
- hand percussion 1
- inferior sound quality 1
- intense drumming 1
- lilting melody 1
- lively 1
- love 1
- love song 1
- loyalty 1
- male harmony 1
- male vocal backup 1
- mellow 1
- middle eastern music 1
- minimalist 1
- muddled audio 1
- muffled audio 1
- muffled sounds 1
- muffled vocals 1
- organ accomapniment 1
- oud 1
- passioante 1
- patriotic 1
- patriotism 1
- persuasive 1
- regional pop 1
- regional song 1
- romantic 1
- sad vibe 1
- salsa music 1
- sentimental 1
- shofar like instrument 1
- slow tempo 1
- soft 1
- soft pop 1
- spirited 1
- steady drumming 1
- sticks 1
- tambourine 1
- tenor 1
- unity 1
- vibrant 1
- world music 1
musiccaps_names (array) 9 ✖
- Music 5
- Mantra 2
- Chant 1
- Christmas music 1
- Folk music 1
- Middle Eastern music 1
- Singing 1
- Vocal music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Η γη των μακεδόνων. Τhe Land of the Macedonians. TRADITIONAL Folklore Music | A male chorus sings this passionate song in a foreign language which sounds like Greek. The song is medium tempo with hand percussion like drums, small hand drum, tambourine and a beat with sticks. The vocals are emphatic and sung in lively parts. The song is passionate, emotional, sentimental, and sounds like an anthem or a love song for the Country or a Leader. | 2010-03-08T11:03:55Z | Florinamak | http://florinamak.blogspot.com/2010/03/blog-post.html H ΓΗ ΤΟΥ ΜΕΓΑΛΕΞΑΝΔΡΟΥ Η γη του Μεγαλέξανδρου η γη των Μακεδόνων Η γη του Μεγαλέξανδρου η γη των Μακεδόνων ήταν και θα ναι ελληνική το καμάρι των αιώνων ήταν και θα ναι ελληνική το καμάρι των αιώνων Απ το βορά ως το νοτιά Ανατολή και Δύση Απ τον βορά ως το νοτιά Ανατολή και Δύση Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Ένα τραγούδι αντηχεί Ποιος θα το σταματήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Μπάτε κορίστα στο χορό Αγόρια στο μεθύσι Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσει Τούτο τον τόπο δεν μπορεί Κανείς να τον πατήσειιιι ΤΑ ΤΡΑΓΟΥΔΙΑ ΤΗΣ ΜΑΚΕΔΟΝΙΑΣ ΤΕΡΖΗΣ ΜΠΑΓΙΩΚΗΣ | ["Mantra", "Chant", "Folk music", "Music", "Vocal music"] | ["male harmony", "medium tempo", "foreign language", "greek song", "anthem", "hand percussion", "tambourine", "hand drums", "sticks", "choral harmony", "unity", "patriotic", "anthem", "patriotism", "passionate", "emotional", "sentimental", "love", "devotion", "loyalty", "intense", "tenor", "baritone", "bass"] | 7 | 2JnlmS1zzls | 352 | |
SRPSKE RASE PASA-Serbian Dog Breeds | A male vocalist sings this intense melody in a foreign language.The tempo is slow with a keyboard and organ accompaniment that is burgeoning as the song progresses. The vocals are eloquent, emphatic, persuasive and lilting and the vibe of the song is mellow, persuasive, passionate, emotional and appealing. | 2014-06-08T08:25:31Z | Miroslav Visnjic | http://www.srpskipas.com/ | ["Mantra", "Music"] | ["male singer", "slow tempo", "foreign language", "passionate", "burgeoning music", "eloquent vocals", "emphatic", "persuasive", "sad vibe", "keyboard harmony", "church organ", "minimalist", "lilting melody", "soft", "mellow", "emotional", "passioante", "intense"] | 7 | 2dyxjGTXSpA | 393 | |
Dan Nguyen va Cat Tien hat Loi To Tinh De Thuong | A male vocalist sings this pop song. The tempo is medium with keyboard accompaniment ,steady drumming, groovy bass, congas and bongos percussion and acoustic guitar accompaniment with vocal backup. The sound quality of the audio is inferior and there is the sound of chatter in the background .The song is fresh, simple, breezy, romantic, passionate, sentimental and youthful with a dance groove. This song is Regional Pop. | 2015-07-28T01:31:19Z | Oanh Nguyen | ["Singing", "Music", "Wedding music"] | ["male vocalist", "medium tempo", "female backup", "soft pop", "dance groove", "dance music", "muffled sounds", "crowd chatter", "salsa music", "keyboard harmony", "congas", "bongos", "bass guitar", "intense drumming", "acousitc guitar", "muffled vocals", "inferior sound quality", "foreign language", "regional pop", "passionate", "emotional", "romantic", "enthusiastic"] | 7 | JWNWCKdfpzM | 2015 | ||
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 | |
ضياء الصغير - موال + يابن الناس | A male vocalist sings this song in a foreign language. The tempo is fast with rhythmic oud , steady drumming, shofar and strong vocal backup. The audio is muffled and incoherent making it difficult to hear the other instruments used. This song is a Middle Eastern Pop song. | 2010-03-30T15:21:02Z | agany2009 | كلمات غسان جوده - الحان طالب السوداني - ضياء الصغير 2003 تشاهدون ايضا في قنتاتي كوكبة من مغنيين ومطربين العراق واغاني قديمه وحديثه علي العيساوي - حاتم العراقي - اوراس ستار - ضياء حسين - ضياء الصغير - سعدي الحلي - سعدي البغدادي - سعدي البياتي - كاظم الساهر - محمود انور - علي محمود السامر - فرج وهاب - محمد الغزي - سعدون جابر - كاظم مدلل - ضياء الراشد - رعد العربي - رياض كريم - فارس العراقي - احمد عباس - علي الصغير - عادل الموسى - عادل عكله - جلال خورشيد - صباح محمود - صباح اللامي - صلاح عبد الغفور - ياس خضر - حميد منصور - عبد الله البدر - هيثم يوسف - مهند محسن - عبد فلك - علاء سعد - مي ووحيد - وحيد سعد - ناظم سعد - مضر محمد - جلال الحنين - حنين بغدادي - وحيد علي - محمد وسام كتعان وصفي - فلفل الكرخي - ضياء الراشد - سعد كمر - جمال الصغير - محمود مشكور | ["Music", "Middle Eastern music"] | ["fast tempo", "male singer", "foreign language", "muffled audio", "oud", "steady drumming", "shofar like instrument", "middle eastern music", "love song", "passionate", "emotional", "male vocal backup", "passionate", "muddled audio"] | 7 | vVNWjq9byoQ | 5186 |
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;