musiccaps_details (view)
1 row where musiccaps_aspects contains "game song", musiccaps_aspects contains "no voice" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;