musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "low quality", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "sustained strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- low quality · 2 ✖
- punchy kick · 2 ✖
- sustained strings melody · 2 ✖
- background music 1
- cinematic 1
- echoing synth bell melody 1
- electric guitar melody 1
- emotional 1
- energetic 1
- energetic cymbals 1
- epic 1
- female choir melody 1
- groovy bass 1
- mellow piano melody 1
- passionate 1
- passionate female vocal 1
- pop 1
- powerful 1
- pulsating synth melody 1
- punchy snare 1
- rock 1
- shimmering hi hats 1
- smooth bass guitar 1
- video game trailers 1
- wide electric guitar chords 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lee Min Ho - Faith Korean Drama 2012 | The low quality recording features a pop song that consists of an electric guitar melody, shimmering hi hats, groovy bass, sustained strings melody, pulsating synth melody, punchy kick and echoing synth bell melody. It sounds emotional, passionate and cinematic, as it also sounds like something that would go well as a background music for movies. | 2012-11-02T12:16:52Z | MsDallia91 | Faith also called the great doctor is a Korean historical drama made in 2012 with Lee Min Ho and Kim Hee Sun. | ["Music", "Tender music"] | ["pop", "low quality", "electric guitar melody", "shimmering hi hats", "groovy bass", "sustained strings melody", "pulsating synth melody", "punchy kick", "echoing synth bell melody", "emotional", "passionate", "cinematic", "background music"] | 4 | 8FZb_R2UANY | 906 | |
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 |
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;