musiccaps_details (view)
1 row where musiccaps_aspects contains "sound effects", musiccaps_names contains "Eruption" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Mad Max 4: Fury Road | This is a piece from a movie theme. There is a cinematic synth being played to create a dramatic effect. There are a lot of sound effects such as explosions, thunderstorms, falling objects and engine sounds. The atmosphere is violent and filled with suspense. This piece could be used to lift samples from. These samples could be used to amplify movie scenes and video game sequences. | 2015-08-10T21:00:07Z | YouTube Movies | From director George Miller, originator of the post-apocalyptic genre and mastermind behind the legendary “Mad Max” franchise, comes “Mad Max: Fury Road,” a return to the world of the Road Warrior, Max Rockatansky. Haunted by his turbulent past, Mad Max (Tom Hardy) believes the best way to survive is to wander alone. Nevertheless, he becomes swept up with a group fleeing across the Wasteland in a War Rig driven by an elite Imperator, Furiosa (Charlize Theron). They are escaping a Citadel tyrannized by the Immortan Joe (Hugh Keays-Byrne), from whom something irreplaceable has been taken. Enraged, the Warlord marshals all his gangs and pursues the rebels ruthlessly in the high-octane Road War that follows. | ["Music", "Eruption", "Outside, rural or natural"] | ["movie soundtrack", "cinematic synth", "sound effects", "explosions", "thunderstorm", "lightning", "automobile engine", "dramatic", "suspense", "action", "violence"] | 9 | VRxFYwbik6A | 3001 |
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;