musiccaps_details (view)
1 row where musiccaps_aspects contains "pop", musiccaps_aspects contains "synth bells melody" and musiccaps_names contains "Speech"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Céline Dion - Where Does My Heart Beat Now (Official Video) | The Pop song features an echoing synth keys melody that consists of a passionate female vocal singing over punchy kick, synth bells melody, echoing synth keys melody and shimmering hi hats. It sounds emotional and passionate. | 2013-02-09T22:35:05Z | CelineDionVEVO | Celine Dion - Where Does My Heart Beat Now (Official Video) Listen on Spotify: http://smarturl.it/Celine_Spotify_EN Listen on Apple Music: http://smarturl.it/Celine_AM_EN Amazon: http://smarturl.it/Celine_Amazon_EN Listen on Deezer: http://smarturl.it/Celine_Deezer Listen on YouTube Music: http://smarturl.it/Celine_YTM Facebook: https://www.facebook.com/celinedion Twitter: https://twitter.com/celinedion Instagram: https://www.instagram.com/celinedion TikTok: https://smarturl.it/CelineDionOnTikTok Lyrics: So much to believe in, we were lost in time Everything I needed I feel in your eyes Always thought of keeping Your heart next to mine But now that seems so far away Don't know how love could leave Without a trace Where do silent hearts go Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? Candle in the water, drifting helplessly Hiding from the thunder Come and rescue me Driven by hunger Of the endless dream I'm searching for the hand that I can hold I'm reaching for the arms that let me know Where do silent hearts go Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? Then one touch overcomes the silence Love still survives Two hearts needing one another Give me wings to fly Where does my heart beat now? Where is the sound That only echoes through the night? Where does my heart beat now? I can't live without Without feeling it inside Where do all the lonely hearts go? I've got someone to give my heart to Feel it getting stronger and stronger And stronger And I feel inside Hearts are made to last Until the end of time | ["Music", "Song", "Speech", "Soul music"] | ["pop", "echoing synth keys melody", "shimmering hi hats", "passionate female vocal", "punchy kick", "synth bells melody", "emotional", "passionate"] | 4 | Hij_QxDkIJI | 1829 |
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;