musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "mellow piano melody" and musiccaps_aspects contains "punchy snare" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- mellow piano melody · 2 ✖
- punchy snare · 2 ✖
- electric guitar chords 1
- emotional 1
- energetic 1
- energetic cymbals 1
- epic 1
- female choir melody 1
- groovy bass 1
- heartfelt 1
- low quality 1
- melancholic female vocal 1
- organ keys chords 1
- passionate 1
- passionate female vocal 1
- powerful 1
- punchy kick 1
- r&b 1
- rock 1
- shimmering hi hats 1
- smooth bass guitar 1
- soft kick hits 1
- sustained strings melody 1
- synth lead melody 1
- video game trailers 1
- wide electric guitar chords 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nightcore - Angels [HD] | The low quality recording features a rock song that consists of mellow piano melody, energetic cymbals, punchy kick, punchy snare, female choir, wide electric guitar chords, sustained strings melody, smooth bass guitar and passionate female vocal singing over it. It sounds epic, powerful and energetic, like something you would hear in video games trailers. | 2012-02-02T12:13:47Z | Le Forkkie | Song: Angels Artist: Within Temptation Picture: http://images2.layoutsparks.com/1/30388/fallen-angel-anime-wolf-31000.jpg Lyrics: Sparkling angel I believe You are my savior In my time of need Blinded by faith I couldn't hear All the whispers The warning's so clear I see the angels I'll lead them to your door There is no escape now No mercy no more No remorse 'cause I still remember The smile when you tore me apart [Chorus:] You took my heart Deceived me right from the start You showed me dreams I wished they'd turn to real You broke the promise And made me realize It was all just a lie Sparkling angel Couldn't see Your dark intentions Your feelings for me Fallen angel Tell me why? What is the reason? The thorn in your eye I see the angels I'll lead them to your door There is no escape now No mercy no more No remorse 'cause I still remember The smile when you tore me apart [Chorus] Could have been forever Now we have reached the end This world may have failed you It doesn't give the reason why You could have chosen A different path of life The smile when you tore me apart [Chorus:] You took my heart Deceived me right from the start You showed me dreams I wished they'd turn in to real You broke a promise And made me realize It was all just a lie Could have been forever Now we have reached the end -- Disclaimer: I own nothing, all original content belongs to their respected artist. This is purely fan-made. Please don't eat me. | ["Music", "Angry music"] | ["low quality", "passionate female vocal", "mellow piano melody", "energetic cymbals", "punchy kick", "punchy snare", "rock", "female choir melody", "wide electric guitar chords", "sustained strings melody", "smooth bass guitar", "energetic", "epic", "powerful", "video game trailers"] | 4 | UsHtZ7Bzi0s | 2949 | |
Lana del Rey - Kill Kill | The R&B song features a melancholic female vocal singing over mellow piano melody, electric guitar chords, synth lead melody, groovy bass, organ keys chords, shimmering hi hats, punchy snare and soft kick hits. It sounds emotional, passionate and heartfelt. | 2011-11-03T15:59:06Z | zentalau | Lana del Rey - Kill Kill ound up the stairs I'm in the shower Do you know I am going to leave you? Do you know I am going To leave you? I'm in love with a dying man I'm in love with a dying man All our love's flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Tell me about Brian and his girl Do I know, Brian is going to meet you? Love you, I do Stay here, I won't As stars fade from your eyes I'm in love with a dying man I'm in love with a dying man All our love flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Want to Make it fun Don't trust Anyone I'm in love with a dying man I'm in love with a dying man I have done everything I can I'm in love with a dying man I'm in love with a dying man I have done everything I can... | ["Electronic organ", "Music", "Independent music"] | ["r&b", "synth lead melody", "melancholic female vocal", "mellow piano melody", "electric guitar chords", "groovy bass", "organ keys chords", "shimmering hi hats", "punchy snare", "soft kick hits", "emotional", "passionate", "heartfelt"] | 4 | hHS5C0RKa8A | 4091 |
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;