musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "passionate", musiccaps_aspects contains "passionate female vocal" and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- emotional 2
- passionate · 2 ✖
- passionate female vocal · 2 ✖
- arpeggiated electric guitar melody 1
- crowd noises 1
- groovy bass guitar 1
- indie 1
- intro 1
- live performance 1
- low quality 1
- noisy 1
- punchy snare 1
- sad 1
- shimmering hi hats 1
- shimmering shakers 1
- soft kick hits 1
- soft rock 1
- wide electric guitar melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Tender music · 2 ✖
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Miley Cyrus - I hope you find it official music video | The Soft Rock song features a passionate female vocalist singing over a wide electric guitar melody, punchy snare, soft kick hits, groovy bass guitar and shimmering hi-hats. It sounds sad, emotional and passionate - like something you would listen to on a day you are feeling down. | 2010-12-25T16:59:54Z | Misslill15 | Fanmade music video. | ["Music", "Tender music"] | ["soft rock", "passionate female vocal", "wide electric guitar melody", "punchy snare", "shimmering hi hats", "soft kick hits", "groovy bass guitar", "sad", "emotional", "passionate"] | 4 | -v5hgCh3M2w | 100 | |
Hindi Zahra no Brasil - Music.MP4 | The low quality recording features a live performance of an indie song and it contains passionate female vocal singing over arpeggiated electric guitar melody and shimmering shakers. It is a bit noisy, there are some crowd noises and it sounds passionate, emotional and like an intro section of the song. | 2011-10-18T09:46:24Z | Danilo de Oliveira Azevedo | Hindi Zahra canta "Music" no Show do SESC-Pinheiros, SP, em 14.10.11. A banda: Lucile Loison - vocais Hakim Hamadouche - mandoluth Thibault Frisoni - guitarra Silvano Matadin - baixo Didier Guazzo - bateria Music Hindi Zahra Music is coming now feel it dropping to the ground sounds like my heart beating fast and free now it's always running in my veins till I hear the drums and basses all night music is coming now see it everybody moves till we get thirsty and happy all we need this time for the real thing for the real high for the real love come together now and rock the ground give it all to the sound body soul and mind until you get down now I know what you're longing for what you're waiting for for the right time for the real thing 4x move until you feel it and move until you feel there's no limit no rules between you and that there's no lines no lights so keep it alive keep it high and make it yours and rock the ground one, two times rock the ground and give it all to the sound your body and your soul your mind and get free now for the real thing for the real high for the real love you better, better, better, better now rock the ground one two times, until you feel it rock the ground one two times until you feel it for the real thing for the real love for the real high 4x move until you feel it and move until you feel 5x freedom is one way road until you get there freedom is one way road | ["Music", "Vocal music", "Tender music"] | ["low quality", "crowd noises", "noisy", "indie", "live performance", "passionate female vocal", "shimmering shakers", "arpeggiated electric guitar melody", "emotional", "passionate", "intro"] | 4 | JOhK7oq9KtU | 1999 |
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;