musiccaps_details (view)

2 rows where musiccaps_author = 8 and musiccaps_names contains "Keyboard (musical)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
The Master and Margarita Part 6 (3_5). (English subtitles). Male and female voice over with harpsichord in the background playing. The woman chuckles. 2011-06-14T16:20:18Z FATmanTokyo Master and Margarita (2005) is a Menippean film based on the eponymous book by Mikhail A. Bulgakov. Set in Moscow under Stalin and in Jerusalem under Pilate, it has several story-lines where history, religion and politics are intertwined. The sacrifices of Master (Galibin), a talented author of a manuscript about the biblical Pontius Pilate, and Master's muse - Margarita (Kovalchuk), are paralleled by the biblical story of Ieshua in Ierushalaim, and the deceit of the cowardly ambiguous Pilate (Lavrov), whose character alludes to a Soviet leader. The reality is distorted by Satan Woland (Basilashvili), and his lieutenants, who are manipulating public events and people's lives by pushing the buttons of human weaknesses and sins. Margarita taps into Woland's power, trying to save Master. The character of Master is autobiographical, burning of his manuscript alludes to what Bulgakov himself did under threats from the Soviet authorities. ["Harpsichord", "Keyboard (musical)"] ["male and female voice over", "harpsichord", "woman chuckles"] 8 7nrOZXbpXBo 883
Taquito Militar An instrumental jazz piano and vibraphone duo. Peppy and upbeat with a latin tinge. 2007-09-26T23:19:18Z Martin Ghersa Duo De Taquito http://martinghersa.bandcamp.com/ Mariano Mores en duo de piano y vibrafono. Ghersa Schwarcz ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Vibraphone"] ["jazz", "piano", "vibraphone", "duo", "peppy", "latin", "upbeat", "instrumental"] 8 R60qQ3ag8y8 2668

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;