musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate", musiccaps_aspects contains "steady drumming" 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 |
---|---|---|---|---|---|---|---|---|---|---|
R.A The Rugged Man - Midnight Thud | A male vocalist sings this passionate Rap. The tempo is medium with steady drumming, keyboard harmony, amplified piano accompaniment, and groovy bass lines . The song is emotional, intense, persuasive, intense and has a catchy groove. This song is contemporary Rap/Hip-Hop. | 2008-09-10T09:04:15Z | Markus Priebe Jakobsson | The song Midnight Thud by the rugged man, with lyrics. | ["Music", "Rapping", "Hip hop music"] | ["male vocalist", "medium tempo", "hip-hop", "rap", "rhythmic patter", "rhythmic speech", "slang", "objectionable lyrics", "passionate", "emotional", "intense", "emphatic", "persuasive", "catchy", "youthful", "steady drumming", "melody keyboard", "amplified piano", "groovy bass lines"] | 7 | CrbZHPkHeV4 | 1407 | |
{Hetalia} Hetaoni: Never enter the mansion. | A female vocalist sings this melodic Soft Rock. The tempo is medium with intense electric guitar harmony, keyboard accompaniment, synthesiser arrangements, steady drumming and subtle bass. The vocals are soft and melodic . The song is passionate, emotional, euphonious, simple, fresh and pleasant. This song is contemporary soft rock. | 2011-12-11T14:23:00Z | kaida55 | ♥Hetalia MEP video♥ ♥Watch in HD ♥ ---------------------- 100+ fav in less than a week? Thanks from everyone who made a part in this video. And again people, thank you so much! Thanks for the 600+ fav in less than a half year time :D Thanks for 1500+ fav! -------------------------------- Parts: 0:00 -- 0:20 hetaliafan41 0:20 -- 0:40 EndlessxRequiem 0:40 -- 1:00 sxrlove06 1:00 -- 1:20 001Dragonheart 1:20 -- 1:40 Irosama0410 1:40 -- 2:00 rose103097 2:00 -- 2:20 XxSilverCharmxX2 2:20 -- 2:40 TimefulAngel 2:40 -- 3:00 Goldenstar7z 3:00 -- 3:20 kaida55 3:20 -- 3:40 melancholywish 3:40 -- 3:56 animerockz290 HetaOni images, and the latest uploads: http://hetaoni.tumblr.com/ | ["Independent music"] | ["female singer", "medium tempo", "intense electric guitar", "keyboard harmony", "steady drumming", "keyboard harmony", "synthesiser arrangements", "electronic music", "electro pop", "synth pop", "melodic", "youthful", "passionate", "emotional", "pleasant", "pop rock", "soft rock"] | 7 | EHm7vLZewS0 | 1542 | |
Hurricane Chris "FREESTYLE" *51/50 RATCHET IN STORES NOW* | A male vocalist sings this passionate rap. The tempo is medium with keyboard harmony, slick drumming, funky bass lines , sound of chimes and synthesiser arrangements. The song is emotional, passionate, emphatic, persuasive, youthful, impactful and rhythmic chanting. The song is a contemporary Hip-Hop/RAo. | 2007-11-01T00:16:48Z | Hurricane Chris | CHECK OUT HURRICANE CHRIS KILL THE "WHITE GIRL" TRACK!!! MAKE SURE YOU POST THIS ON YOUR PAGE AND SEND IT TO FRIENDS!! 51/50 RATCHET IN STORES NOW!! | ["Music", "Rapping", "Hip hop music"] | ["male singer", "medium tempo", "synthesiser arrangements", "rhythmic chanting", "disco rap", "pop rap", "hip-hop", "rap", "punk rap", "gangsta rap", "electronic instruments", "steady drumming", "punchy bass", "intense", "amplified organ", "intense organ music", "sound of picture being clicked", "chimes", "digital drum rhythm", "persuasive", "emotional", "passionate", "story telling", "rhythmic patter"] | 7 | IEVVHo9nr7g | 1883 | |
Viggo Mortensen - Breathe A Sigh | A male vocalist sings this dulcet melody. The tempo is soft with acoustic guitar, resonator, fiddle, mandolin, banjo, dobro and auto harp accompaniment, steady drumming, tambourine beats , fingers snapping and funky bass lines. The song is soft, mellow, dulcet, emotional, sentimental, soothing , pleasant and simple. The song is Country Pop. | 2007-07-08T11:59:56Z | athelas51 | Again with my favorite Def Leppard's song. | ["Music", "Soul music"] | ["male singer", "slow tempo", "groovy bass line", "dulcet", "fingers snapping", "tambourine", "simple melody", "auto harp", "fiddle", "resonator", "dobro", "mandolin", "steady drumming", "soft", "mellow", "love song", "romantic", "passionate", "sentimental", "emotional", "country song", "country pop", "regional pop", "mellow", "pleasant melody"] | 7 | mJuJfKbcJcw | 4459 | |
ضياء الصغير - موال + يابن الناس | 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;