musiccaps_details (view)
2 rows where musiccaps_aspects contains "heavy metal" and musiccaps_aspects contains "video game theme"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Red Alert 3: Soviet March + Hell march 3 | This is a heavy metal music piece from a video game soundtrack. The piece is being performed in the style of a military march. There are speech sounds that resemble the speech of a fascist dictator. The main theme is being played by the distorted electric guitar with the bass guitar playing in the background. The rhythmic background is provided by the acoustic drums. There is an aggressive and militaristic atmosphere. This piece could be playing in the soundtrack of a video game or a movie that has a war setting. | 2011-12-14T04:19:18Z | Dreams of Nostalgia | flawless audio and extended video the second remake of the video "red alert 3 : soviet march full mix" including hell march 3 audio download: http://www.mediafire.com/?rxh7aygof8w5txh | ["Music", "Angry music"] | ["video game theme", "heavy metal", "speech sounds", "marching sounds", "distorted electric guitar", "bass guitar", "acoustic drums", "aggressive", "militaristic", "epic"] | 9 | 5DNl3DX4rr0 | 645 | |
♫ Undertale - Spider Dance (French vocals & lyrics) | This is a heavy metal piece from a video game soundtrack. There is a female vocalist singing melodically in the French language. The melodic background consists of the electric guitar, the keyboard and the bass guitar. In the rhythmic background there is an upbeat electronic drum sound. There is a gothic feel to the piece. This piece could work well in the soundtrack of a historical horror movie that takes place in France. | 2016-02-23T19:38:52Z | Voyage au Centre de la Toile | ■ Undertale - Spider Dance (French Cover) ■ Me soutenir financièrement ❤️ https://www.buymeacoffee.com/ozdust ⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹ ⊹ DESCRIPTION ⊹ Voici une petite vidéo surprise pour vous remercier d’être plus de 600 à me suivre sur ma chaîne. Votre soutien me touche beaucoup, et je tenais à ce que vous le sachiez. ^^ J’ai choisi d’écrire des paroles sur Undertale car c’est un jeu que j’aime énormément. « Spider dance » est une de mes musiques préférées et comme vous le savez, j’adore jouer des rôles de psychopathes. x) En tout cas, j’espère que cette petite chanson vous plaira ! :) Note : Je ne suis pas chanteuse, je fais ça uniquement pour le plaisir :). La qualité du son n’est pas top, c’est pourquoi je vous conseille de mettre des écouteurs pour améliorer le rendu. ⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹ ⊹ CREDITS ⊹ ⊹ Instrumental : https://www.youtube.com/watch?v=pPd1TwL8YV8 ⊹ Animation : https://www.youtube.com/watch?v=gi2FOXsCIpY ⊹ Art : http://palidoozy-art.tumblr.com/post/131142517826/its-breakfast-time-isnt-it-have-fun-you-two ⊹ Thumbnail : http://rotodisk.tumblr.com/tagged/rotodisk ⊹ Paroles : Ozdust ⊹ Voix : Ozdust ⊹ Subtitles by Cubi : https://www.youtube.com/user/Cubiccl41 ⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹═⊹ ⊹ PAROLES ⊹ Dans ce traquenard Se cache ton pire cauchemar Tu peux lutter mais il est déjà trop tard Tu peux me croire (1,2,3,4) Il n'y a pas d'échappatoire C'est terminé A quoi bon résister Avant la fin prends cette tasse d’araignées Les jeux sont faits (5,6,7,8) Alors tente d'en profiter Tu peux crier Qui viendra te sauver ? Tu es piégé(e) et nos deux rôles inversés Écoute, humain (9,10,11,12) Le décompte a commencé ! Compte les temps de mon arachnodanse (x3) Car ta mort approche à la même cadence (x3) Coincé dans ma toile ton corps se balance (x3) Alors dis-moi, cher plat de résistance, peux-tu donc écraser l'arachnodanse ? Quand le temps file, tu te défiles Mes fils te retiennent Ton coeur s’effile, tes craintes défilent Ta vie sera bientôt mienne Plus le temps file, plus je jubile Mes fils te retien… | ["Music of Asia", "Music", "Vocal music"] | ["video game theme", "heavy metal", "female vocal", "melodic singing", "french language", "electric guitar", "keyboard", "bass guitar", "electronic drums", "loud", "aggressive", "gothic"] | 9 | VsMy72BoIbU | 3037 |
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;