musiccaps_details (view)
1 row where musiccaps_aspects contains "shimmering hi hats", musiccaps_names contains "Music" and "youtube_published" is on date 2010-07-16
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;