musiccaps_details (view)
2 rows where musiccaps_aspects contains "orchestral music", musiccaps_aspects contains "slow tempo" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- orchestral music · 2 ✖
- slow tempo · 2 ✖
- booming bass 1
- build up to climax 1
- electronic music 1
- epic melody 1
- game song 1
- no voice 1
- staccato violins 1
- trailer song 1
- victory chant 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Scary music 1
- Sonar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ratchet and clank (Soundtrack): Veldin In Peril | This game music starts off with the sound of something that sounds like the fading sound of a giant's footsteps. An orchestral sound plays as well and the sounds take a pause while electronic percussion is played. This song can be played in a game lobby. | 2008-10-16T20:49:30Z | flamekeepr | I don't own this music. The rights to the game and its music all belong to the its makers. Yep this is the last one i'm doing for the first game. If you can't find a specific song while looking throguh my videos.... chances are i couldn't make one for that song. It is unavailable to me and you'll have to find it elsewhere. Now time for me to move onto music from the second game! | ["Music", "Sonar"] | ["game song", "electronic music", "no voice", "slow tempo", "build up to climax", "orchestral music"] | 0 | oZrMoZeJ8Ng | 4644 |
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;