musiccaps_details (view)
3 rows where musiccaps_aspects contains "cinematic" and musiccaps_aspects contains "dramatic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- cinematic · 3 ✖
- dramatic · 3 ✖
- orchestral 2
- slow tempo 2
- background wind noise 1
- background-noises 1
- brass composition 1
- dangerous 1
- dark 1
- marching drums 1
- nature 1
- percussion's 1
- sad 1
- string section 1
- synth pad sounds 1
- tribal 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fullmetal Alchemist Brotherhood OST 3 - 20. Violoncello's Lament | This audio contains a string section playing a sad/melancholic piece. A violin/viola is playing the lead melody while celli and upright basses being played with a bow are supporting the melody with chords. The lead melody is panned to the right side of the speakers. This song may be playing in a sad and dramatic movie scene. | 2011-06-23T16:15:06Z | ShinyKyuukon | Disclaimer: I do not own any clips or music of this video. All clips and music belong to their respectful owner(s). This video is for enjoyment purposes only. Artist: Senju Akira. | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["cinematic", "orchestral", "sad", "dramatic", "dark", "string section", "slow tempo"] | 6 | 8MF6nFj02sM | 915 | |
Kristall Nano Liquid Screen Protector | Synthesizers are playing soft meditative pad sounds along with strong percussive drum hits, hi-hats and other sound effects that are highly reverbed . In the background you can hear birds singing; glass shattering; water tripping and other sounds that do not belong to the musical composition. This song may be playing for an advertisement. | 2013-06-17T03:37:16Z | Elton Tham | Kristall - Suitable for all smartphone and tablet glass screen and give you a perfect picture quality ..... | ["Glass", "Liquid", "Music"] | ["cinematic", "background-noises", "percussion's", "synth pad sounds", "tribal", "nature", "dramatic"] | 6 | CRIFRYhiKUA | 1366 | |
Space Above and Beyond Trailer for Season 2 | This audio contains marching drums with a kick and snare rolls. A brass section starts to play a melody in the low to mid range up to the higher register. In the background you can hear a strong wind that seems not to be part of the song. This song may be playing in a pirate movie-scene. | 2007-02-07T02:35:50Z | sjc2006 | Trailer for possible continuation for a show that was cancelled way too soon. Maybe Morgan and Wong will get to see this and be inspired by knowing that the fanbase still holds out hope. We believe in you. Semper fi!!!!! | ["Brass instrument", "Trumpet"] | ["cinematic", "orchestral", "brass composition", "background wind noise", "marching drums", "dangerous", "dramatic", "slow tempo"] | 6 | F9LJIyqQFe8 | 1619 |
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;