musiccaps_details (view)
1 row where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "story-telling mood", musiccaps_aspects contains "suspense" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Lions on the Hunt | This is a documentary music piece. There is a strings section that is holding a single chord. The bass guitar is repeating an ominous bass line. There is a simple percussion beat in the rhythmic background. The atmosphere has a dramatic feel to it. It feels like a story is about to unfold. The piece suits perfectly as a documentary music piece. It could also fit well in the soundtrack of a mystery movie. | 2008-05-16T20:55:30Z | Exploration Films | No film has ever captured the true nature of the king of beasts like LIONS: Kings of Africa. Wildlife cinematographers spent an entire year living among a lion pride in the Ngorongoro Crater in Northern Tanzania where three generations - cubs, adolescents, and leaders - revealed their fascinating royal lives. Find "Explore The Wildlife Kingdom: Lions - Kings of Africa" on DVD, at http://www.explorationfilms.com/exploration-films-scientific-discoveries.html | ["Music", "Ambient music"] | ["documentary music", "movie music", "strings section", "bass guitar", "percussion", "dramatic", "suspense", "tension", "story-telling mood"] | 9 | D7Cvisf3jf8 | 1439 |
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;