musiccaps_details (view)
3 rows where musiccaps_aspects contains "pop", musiccaps_author = 4 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- pop · 3 ✖
- low quality 2
- punchy kick 2
- shimmering hi hats 2
- "4 on the floor" kick pattern 1
- addictive 1
- addictive synth bass melody 1
- brass melody 1
- commercial music 1
- crowd cheering 1
- echoing brass melody 1
- echoing synth keys melody 1
- electro song 1
- emotional 1
- energetic 1
- funny processed male vocal 1
- harmonizing female vocal 1
- haze machine sounds 1
- live performance 1
- noisy 1
- passionate 1
- passionate female vocal 1
- punchy snare 1
- synth bells melody 1
- wooden percussions 1
musiccaps_names (array) 8 ✖
- Music 3
- Speech · 3 ✖
- Inside, public space 1
- Middle Eastern music 1
- Pop music 1
- Song 1
- Soul music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nivine Nasr - Yo2bosh - Video Clip | The low quality recording features a commercial music that consists of a funny processed male vocal, after which there is a harmonizing female vocal singing over punchy kick, brass melody, wooden percussion and echoing brass melody. It sounds addictive - like every commercial music should sound. | 2010-04-20T13:18:50Z | ArmVisions | Nivine Nasr Yo2bosh نيفين نصر يؤبش | ["Music", "Middle Eastern music", "Speech"] | ["low quality", "pop", "funny processed male vocal", "brass melody", "punchy kick", "wooden percussions", "echoing brass melody", "harmonizing female vocal", "addictive", "commercial music"] | 4 | 3QqVP0odOw4 | 467 | |
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 | |
Burn It Up - Yassi Pressman | The low quality recording features a live performance with an electro song playing in the background and crowd cheering sounds. The song consists of a "4 on the floor" kick pattern, addictive synth bass melody, punchy snare and shimmering hi-hats. It sounds energetic and the recording is noisy as it was probably recorded with a phone. | 2016-04-04T05:54:17Z | dealwithjames | Happy Truck #Happinas Mid Prod Yassi Pressman - Burn It Up | ["Music", "Pop music", "Yell", "Speech", "Inside, public space"] | ["crowd cheering", "electro song", "haze machine sounds", "live performance", "\"4 on the floor\" kick pattern", "pop", "punchy snare", "addictive synth bass melody", "shimmering hi hats", "energetic", "low quality", "noisy"] | 4 | ykkVTInYctY | 5434 |
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;