musiccaps_details (view)
4 rows where musiccaps_aspects contains "rock music", musiccaps_author = 7 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- rock music · 4 ✖
- hard rock 2
- heavy metal 2
- intense 2
- male singer 2
- soft rock 2
- acoustic music 1
- alternative rock 1
- amplified guitar harmony 1
- boisterous 1
- buoyant 1
- classic rock 1
- compelling 1
- dense bass lines 1
- distorted guitars 1
- electric bass guitar 1
- electric guitar lead 1
- electric guitar lead and harmony 1
- electric guitar melody 1
- electronic guitar lead 1
- emphatic 1
- emphatic rhythm 1
- energetic 1
- energetic drumming 1
- enthusiastic 1
- enthusiastic vocal backup 1
- folk rock 1
- geek rock 1
- grim 1
- groovy 1
- groovy bass line 1
- hard hitting drums 1
- instrumental 1
- intense keyboard 1
- introspective 1
- keyboard accompaniment 1
- keyboard harmony 1
- loud electric guitar feedback 1
- love song 1
- male vocalist 1
- melancholic 1
- mellow 1
- melodic 1
- metal 1
- passionate 1
- piano accompaniment 1
- poignant 1
- pop rock 1
- powerful 1
- punchy beats 1
- retro feel 1
- rock and roll 1
- romantic 1
- simple harmony 1
- simple melody 1
- slow tempo 1
- steady bass lines 1
- steady drumming 1
- straightforward drumming 1
- syncopated harmony 1
- synthesiser arrangement 1
- vibrant 1
- voracious 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music · 4 ✖
- /t/dd00032 1
- Exciting music 1
- Grunge 1
- Progressive rock 1
- Punk rock 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Truth Be Told "Let It Go" Official Music Video | A male vocalist sings this vigorous Rock song. The tempo is fast with enthusiastic electric guitar lead and harmonies, electric bass guitar and hard hitting drumming with cymbal rides. The song is passionate, youthful, enthusiastic, intense, compelling, boisterous and vigorous. This song is a Hard Rock/Heavy Metal song. | 2012-10-04T18:11:26Z | TruthBeToldProject | Produced by: FlareSoul Entertainment Group Directed by Norberto Peña (http://www.npenaphoto.com) Truth Be Told www.Facebook.com/TruthBeToldProject Twitter: @TruthBeToldProj Official Release on iTunes, Spotify, AmazonMp3 on 10/25/12 Lyrics: A total change of mind A total change of life Its necessary to achieve these goals to reach, the desires of our heart. So much sacrifice Wasting money and time Left so many things behind Hope this is, Hope this is worth our while NO! We won't lose our faith, no we won't! So we let it go, let it go Fearless and committed Cause we gotta, go gotta go Find that place where we belong Losing all, winning all Find the purpose, of our, lives Hope this is worth our while Maybe loosing some friends so far from our loved ones Working hard Can't be left behind Using all, using all our might Giving what we are We put together all our strength Hope this is, Hope this is worth our while Be strong and courageous. Do not be frightened; do not be dismayed, for the Lord your God will be with you wherever you go So we let it go, let it go Cause we gotta, go gotta go Losing all, winning all Losing all, winning all All Rights Reserved by Truth Be Told --------------------------------------------------------------------- Additional Tags: Victory Records, Facedown Records, Tooth And Nail, Come & Live, Universal, Lyrics, Metal Blade, Road Runners, Indie, Post Punk, Post Hardcore | ["Music", "Punk rock", "Progressive rock", "/t/dd00032"] | ["male vocalist", "energetic drumming", "loud electric guitar feedback", "electric guitar lead and harmony", "enthusiastic vocal backup", "youthful", "enthusiastic", "energetic", "vibrant", "boisterous", "voracious", "intense", "passionate", "metal", "hard rock", "rock music", "heavy metal", "electric bass guitar"] | 7 | 3nbB3F-OdSM | 501 | |
Barenaked Ladies - Sound of Your Voice [Official Music Video] | A male vocalist sings this simple pop. The tempo is medium with an electric guitar melody, keyboard accompaniment, steady drumming, steady bass lines and acoustic guitar rhythm. The song is a simple, melodic, earnest, engaging Soft Rock; | 2007-02-06T16:45:04Z | Barenaked Ladies (official) | "Sound of Your Voice" by Barenaked Ladies from Barenaked Ladies Are Men, available now. Download on iTunes: http://smarturl.it/kk3vd8 Links: http://www.facebook.com/barenakedladies http://twitter.com/barenakedladies "Sound Of Your Voice" Lyrics: The moon is full but there is an incompleteness The days are beautiful but I feel a bitter sweetness If I had a wish, or even a choice I'd wake up to the sound of your voice How I miss waking up to the sound of your voice I let you down and fell right off of your good list I hope each day you'll find peace and forgiveness The alarm clock rings, What a lonely noise And I long for the sound of your voice Oh, how I miss waking up to the sound of your voice Take it from me: there's not much to see In this void The saying goes there will be other dances (don't give up) This little song is about second chances Just say the word and I will rejoice And wake up to the sound of your voice Oh, how I miss waking up to the sound To the sound (sound) To the sound (to the sound) To the sound Waking up to the sound of your voice Take it from me: there's not much to see In this void Subscribe to Nettwerk's YouTube channel: http://smarturl.it/nettwerkyoutube | ["Music", "Exciting music"] | ["male singer", "electric guitar melody", "folk rock", "pop rock", "rock music", "acoustic music", "alternative rock", "introspective", "melancholic", "poignant", "geek rock", "simple harmony", "classic rock", "straightforward drumming", "keyboard accompaniment", "simple melody", "soft rock", "pop rock", "mellow", "melodic", "romantic", "love song", "steady bass lines"] | 7 | FoFMRXlNJ6Y | 1666 | |
Ray Manzarek - 02 Solar Boat | A male vocalist sings this Soft Rock. The tempo is slow with electronic arrangements,steady drumming, groovy bass line , and syncopated keyboard harmony. The background instruments play a dissonant melody. This song is a mellow, youthful, punchy, buoyant, Soft Rock. | 2009-11-04T21:57:51Z | Simagga | Ray Manzarek - The Golden Scarab | ["Music", "Soul music"] | ["male singer", "slow tempo", "rock music", "soft rock", "keyboard harmony", "groovy bass line", "syncopated harmony", "piano accompaniment", "steady drumming", "electric guitar lead", "synthesiser arrangement", "rock and roll", "retro feel", "groovy", "soft rock", "buoyant", "punchy beats"] | 7 | n4PBoAedWVA | 4517 | |
Tocotronic Rock Pop in Concert english | This instrumental is a Heavy Metal instrumental. The tempo is fast with hard hitting drumming, furious and vigorous amplified keyboard playing a harmony, electric bass guitar and electric guitar accompaniment. The music is intense, grim, compelling, passionate, powerful and harmonious. The vibe of the music is serious, sinister, grim and steely. This is used in Hard Rock/Heavy Metal. | 2008-12-05T22:28:11Z | petapanda | from KOOK english album, singing at 1:30 | ["Music", "Grunge"] | ["instrumental", "hard rock", "heavy metal", "intense keyboard", "electronic guitar lead", "amplified guitar harmony", "grim", "intense", "rock music", "distorted guitars", "emphatic rhythm", "dense bass lines", "powerful", "emphatic", "compelling", "hard hitting drums"] | 7 | u_TfWvyYY0Y | 5126 |
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;