musiccaps_details (view)
3 rows where musiccaps_aspects contains "vigorous", musiccaps_author = 7 and musiccaps_names = "["Music", "Angry music"]"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| I'm Sorry - BrokeNCYDE (2009) Lyrics In Video "I'm Not A Fan..But The Kids Like It!" | A male vocalist sings this passionate metal song. The tempo is medium fast with keyboard accompaniment, steady drumming and bass lines, electric guitar , sound of siren and vocal backup. The lead vocals are loud, passionate , volatile, hysterical ,disturbed,emphatic,sad, emotional, painful, disappointed and hurt. This song is Heavy/Goth Metal. | 2009-06-20T18:12:26Z | Feorry | This is their remake of the song "I'm sorry, I am" Took me long enough to do this.. Enjoy! Can't get you out of my head I just want to say I'm sorry So i wrote this letter for you.. FUCKING BITCH Your eyes They flow From all the pain I caused I lost my cause I only broke your heart Alone I cry I tried so hard to break you I love you I hate you Why wont you let me go? I, I feel the raindrops fall These tears wont take you away, I'm sorry I, I hear the thunder scream It's screaming out for me, I'm sorry The rain drips, the rain drops drip (x4) The rain drips, the rain drops drip(down) (x4) The rain drops drip Your eyes They flow From all the pain I caused I lost my cause I only broke your heart Alone I cry I tried so hard to break you I love you I hate you Why wont you let me go? The rain will follow me, I feel like I can't breath, I'm sorry I fell asleep again, when will this tempest end, I'm sorry The rain drips, the rain drops drip (x4) The rain drips, the rain drops drip(down) (x4) The rain drops drip Your eyes They flow From all the pain I caused I lost my cause I only broke your heart Alone I cry I tried so hard to break you I love you I hate you Why wont you let me go? I, I dreamt that you were here, lying next to me, I'm sorry I, I finally realised that I fucked up your life, So I'm sorry The rain drips, the rain drops drip (x4) The rain drips, the rain drops drip(down) (x4) The rain drops drip Your eyes They flow From all the pain I caused I lost my cause I only broke your heart Alone I cry I tried so hard to break you I love you I hate you Why wont you let me go? I'd die tonight If only you were here I'd tell you I'm sorry I'd fucking disapear Betrayed, You hate me You look so pretty now Without me Alone My tears come crashing down. My tears come crashing down | ["Music", "Angry music"] | ["male vocalist", "medium fast tempo", "loud", "disturbing", "crazy", "screaming", "metal", "heavy metal", "goth rock", "ambulance siren", "police van siren", "vocal backup", "keyboard accompaniment", "steady drumming", "intense", "passionate", "aggressive", "volatile", "vigorous", "steady bass line", "pain", "hurt", "mania", "psychopath", "hysteria"] | 7 | Rhn6K9HCbC8 | 2719 | |
| Full Torva + Divine PKing - HIGH RISK! 2b+ | This song is an animated instrumental. The tempo is fast with synthesiser arrangements, intense drumming, groovy bass lines and digital sound effects. The music is upbeat, catchy, compelling, youthful, psychedelic, trance like and intense with an upbeat dance groove. This song is contemporary Synth Pop. | 2011-03-02T22:56:59Z | Pixel Bones | Make sure you thumbs up :)! CRAZY RISK! | ["Music", "Angry music"] | ["instrumental", "fast tempo", "synth rock", "animated", "video game music", "psychedelic", "digital sound effects", "vigorous", "intense", "trap", "trance trippy", "psychedelic", "dance music", "dance hits", "club music", "youthful", "spirited", "groovy bass line", "intense drumming", "synthesiser arrangements", "electronic instruments", "digital drums", "digital soundeffect"] | 7 | pn6toTLXAck | 4734 | |
| Downstroy | A male vocalist sings this violent Rock. The tempo is fast and rigorous with hard hitting drums, intense bass line and aggressive electric guitar lead with synthesiser arrangements. The song is loud, violent, thunderous,passionate, boisterous and aggressive. This song is Death Metal. | 2009-09-24T15:49:52Z | MelissaMusic72 | Downstroy by Soulfly. | ["Music", "Angry music"] | ["male vocalist", "fast tempo", "thunderous percussion", "aggressive electric guitar", "hard hitting drums", "vigorous bass line", "vigorous", "goth metal", "death metal", "extreme", "violent", "thunderous", "accelerated tempo", "guttural vocals", "gruesome", "angry", "passionate", "deep growling", "screaming", "loud", "low tuned guitar", "aggressive", "angry", "passionate", "intense"] | 7 | t5RqDGLiDvo | 5003 |
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;