musiccaps_details (view)
2 rows where musiccaps_aspects contains "no voice", musiccaps_author = 0 and musiccaps_names contains "Sonar"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Foreign Exchange - Daykeeper feat. Muhsinah | This clip features a synth playing a chord in the background. Another synth plays swells in short bursts. There are no voices in this song. There is no percussion in the song. The mood of this song is eerie. This song can be played in a suspenseful movie scene. | 2008-09-08T17:19:47Z | lpfan091989 | song from The Foreign Exchange's album Leave It All Behind. Support The Foreign Exchange by ordering the album at http://www.theforeignexchangemusic.com/store/the-foreign-exchange-leave-it-all-behind.html | ["Music", "Sonar"] | ["ambient music", "no voice", "no percussion", "synth swells", "synth backing", "eerie sound"] | 0 | T_d82v2g93w | 2846 | |
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;