musiccaps_details (view)
1 row where musiccaps_aspects contains "male and female voice over", musiccaps_author = 8 and "youtube_published" is on date 2011-06-14
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;