musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "punchy kick", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Tender 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
The Cult - Painted On My Heart (Official Music Video) + Lyrics [HQ Sound + HD Video] | The Soft Rock song features a flat male vocal singing over arpeggiated electric guitar melody, punchy kick, groovy bass, shimmering hi hats and snappy rimshots. It sounds emotional and easygoing. | 2010-07-16T10:19:34Z | Music Guide | OFFICIAL / ORIGINAL MUSIC VIDEO FOR THIS SONG. Artist: The Cult Song: Painted On My Heart SoundTrack From The Movie: Gone in 60 Seconds NOTE: I Don't Own Any Content Of This Song. Lyrics: I thought you'd be out of my mind And I'd finally found a way to Learn to live without you I thought it was just a matter of time Till I had a hundred reasons Not to think about you But it's just not so And after all this time I still can't let go I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me I was trying everything that I can To get my heart to forget you But it just can't seem to I guess it's just no use In every part of me Is still a part of you I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me I've still got your face Painted on my heart Painted on my heart Painted on my heart Something in your eyes keeps haunting me I'm trying to escape you And I know there ain't no way to To chase you from my mind I've still got your face Painted on my heart Scrawled upon my soul Etched upon my memory baby I've got your kiss Still burning on my lips The touch of my fingertips Is love so deep inside of me, baby I've still got your face I've still got your face painted on my heart painted on my heart painted on my heart | ["Music", "Sad music", "Tender music"] | ["soft rock", "flat male vocal", "arpeggiated electric guitar melody", "punchy kick", "groovy bass guitar", "shimmering hi hats", "snappy rimshots", "emotional", "easygoing"] | 4 | bBGcQ2-W768 | 3609 | |
Mali Bang Mag Mahal by CRSP (official music video) | The low quality recording features a hip hop song that consists of a mellow arpeggiated piano melody played over sustained strings melody, chime bell and filtered male vocal in the first half of the loop. In the second half the beat drops and it consists of a punchy kick and snare hits, shimmering hi hats and passionate female vocals singing over. It sounds passionate, groovy and emotional. | 2013-07-04T05:19:16Z | MrRight VEVO | Directed by : Lilcoli Tugista Singer : Still One & Loraine Composed by : Right One Arranged by : Still One & Right One Released : July 2013 | ["Music", "Tender music"] | ["low quality", "hip hop", "mellow arpeggiated piano melody", "filtered male vocal", "sustained strings melody", "chimes bells", "punchy kick", "punchy snare", "shimmering hi hats", "passionate female vocal", "passionate", "emotional", "groovy"] | 4 | jD0nqkyuHPg | 4242 |
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;