musiccaps_details (view)
3 rows where musiccaps_aspects contains "slow tempo", musiccaps_author = 0 and musiccaps_names = "["Music", "Scary 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 |
---|---|---|---|---|---|---|---|---|---|---|
World of Warcraft Enchanted Forest Music | This song features a female voice singing in opera style using only vocables and no words. This is accompanied by violins playing eighth note patterns that change according to the chords being played. The bass follows the root notes of the chords. A muted guitar or string instrument plays arpeggiated chords. This song can be played in a fantasy game. | 2008-12-21T17:53:08Z | WoWMusicGuru | All credit goes to Blizzard for the making of this music. | ["Music", "Scary music"] | ["opera song", "symphonic", "female voice", "string section", "bass", "muted guitar", "fantasy song", "slow tempo"] | 0 | -r7iz-9v9bA | 91 | |
Star Trek TnG.mov | This amateur recording features a synth string swell at the beginning of the audio. Alien sounds are played in the background. This is followed by a crash cymbal struck once. Other instruments are not audible due to the low quality of audio. There are no voices in this song. This is an instrumental song. | 2010-05-22T18:25:49Z | qcotms | This is Star Trek TnG season 3 themesong with lyrics written by myself | ["Music", "Scary music"] | ["amateur recording", "low quality audio", "synth strings swell", "crash cymbal", "alien sounds", "no voice", "instrumental", "slow tempo"] | 0 | YB28WMv7wUE | 3262 | |
The Throne Is Mine - Game Of Thrones | This orchestral music features violins playing the main melody using staccato notes. The volume of the violins increases over time in the song. The bass plays a booming note on the alternate count of every bar. The bass resonates like a heartbeat. A single percussion beat is played on the second count of the second bar. There is the sound of a victory chant in the background. This song is at a slow tempo. This song can be used in the trailer of an epic movie. | 2012-08-05T19:45:02Z | alejandroPORCHE | Game of Thrones | ["Music", "Scary music"] | ["orchestral music", "epic melody", "staccato violins", "victory chant", "booming bass", "slow tempo", "trailer song"] | 0 | lh6ACdwNlyk | 4415 |
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;