musiccaps_details (view)
2 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "passionate female vocal" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- live performance · 2 ✖
- low quality 2
- passionate female vocal · 2 ✖
- shimmering shakers · 2 ✖
- addictive 1
- arpeggiated electric guitar melody 1
- breathy flute melody 1
- crowd noises 1
- emotional 1
- indie 1
- intro 1
- noisy 1
- passionate 1
- wooden percussions 1
musiccaps_names (array) 4 ✖
- Music 2
- Tambourine 1
- Tender music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Bollywood Dance - Ringa Ringa - Slumdog Millionaire - http://www.bollywooddance.org.uk | The low quality recording features a live performance that consists of shimmering shakers, wooden percussion, breathy flute melody and passionate female vocals singing over it. It sounds very addictive, due to the lead vocal cadence. It is a bit reverberant, as it was recorded in a larger room, with a low quality microphone. | 2010-07-03T13:35:27Z | Mahadev Semwal | Students of Bollywood Dance Worldwide at Reading Berkshire learning Ringa Ringa from Slumdog Millionaire. More workshop related information at http://www.bollywooddance.org.uk/workshops More performance related information at http://www.bollywooddance.org.uk/videos More hen night related information at http://www.bollywooddance.org.uk/hennights | ["Music", "Tambourine"] | ["low quality", "shimmering shakers", "wooden percussions", "passionate female vocal", "live performance", "addictive", "breathy flute melody"] | 4 | uF1KTW5rT-s | 5102 |
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;