musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_names contains "Vocal music" and "youtube_published" is on date 2011-10-18
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;