musiccaps_details (view)
1 row where musiccaps_aspects contains "adrenaline rush", musiccaps_aspects contains "building anticipation" and musiccaps_aspects contains "spirited"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Tombstone (1993) - Main movie teme | The song is an instrumental. The song is medium tempo with drums playing in march style and a brass section plays this triumphant harmony. The song is spirited and gives an adrenaline rush. The song is a western movie soundtrack with an average sound quality. | 2011-09-17T14:27:00Z | LittleDrinkerRu | Music by Bruce Broughton | ["Timpani", "Music"] | ["movie soundtrack", "western movie", "male bravado", "adrenaline rush", "cowboys", "sheriff", "lawmen", "drums playing loud in march style", "trumpet section plays triumphantly", "emotional", "spirited", "instrumental music", "ominous", "suspense", "building anticipation", "hero’s march", "tulna is playing loud"] | 1 | 6Yh7Cdm2GgY | 767 |
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;