musiccaps_details (view)

1 row where musiccaps_aspects contains "crowd noises", musiccaps_aspects contains "shimmering shakers", musiccaps_names contains "Music" and musiccaps_names contains "Vocal music"

✎ View and edit SQL

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

CSV options: 

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;