musiccaps_details (view)
2 rows where "youtube_published" is on date 2015-02-05
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
zZounds Exclusive Track through the Roland GR-55 Guitar Synthesizer | The track would fit the funk fusion music genre. The main melodic element is a synth electric guitar that plays a solo with a lot of energy and presence. In the background a drum loop that sounds very electronic is played. The music is upbeat and simple. This song would fit a car racing video game. | 2015-02-05T21:58:48Z | zZounds | Check out this zZounds Exclusive Track through the Roland GR-55 Guitar Synthesizer For more detailed product information, please visit: http://bit.ly/1DKlJhH To view our complete line of Roland products please visit: http://bit.ly/1Djw32f About zZounds.com: zZounds.com was founded in 1996 to provide musicians with the best online buying experience for guitars, basses, recording, microphones, keyboards, DJ, and other musical instruments. The site offers a wide variety of popular brands and service from an expert staff of musicians. http://www.zzounds.com/a--3082258 | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Synthesizer"] | ["synth electric guitar solo", "upbeat", "funk", "fusion", "upbeat electronic drums", "simple", "no vocals", "fast tempo", "drum machine"] | 5 | aCUZuMblJPg | 3521 | |
Warhammer: End Times - Vermintide | Announcement Teaser | This audio clip features the sound of water dropping. This is followed by the sound of a wild creature. The sound is creaking. Toward the end, the sound of a rat squealing is heard. This sound is from a video game. | 2015-02-05T13:01:47Z | Fatshark | Website: http://www.vermintide.com/ Steam Page: http://store.steampowered.com/app/235540 Forum: http://forums.fatsharkgames.com/categories/vermintide Facebook: http://www.facebook.com/vermintide | Twitter : http://www.twitter.com/vermintidegame -- Other Trailers -- Gameplay Sneak Peek: https://www.youtube.com/watch?v=vn-9ONpZQqU The time of mortals is ending, and the reign of Chaos draws ever closer. The Dark Gods are at last united in a singular purpose, loosing their madness across the world as never before. In the Empire of Sigmar, Karl Franz's gaze is focused on the incursion of the savage northmen, but it is not the only threat. As the Chaos moon Morrslieb waxes full, shrill voices echo through tunnels gnawed far beneath the Empire's cities, and a Skaven host swarms towards the surface. It emerges first in the city of Ubersreik, a screeching mass that consumes all before it. Soon Ubersreik is a charnel-town, drowning beneath the malevolent shadow of the Horned Rat. Yet even in the darkest times, there are always champions to light the way. As Ubersreik cowers, five heroes, united by capricious fate, carry the fight to the rat-men. It remains to be seen whether they have the strength to survive, let alone work together long enough to thwart the invaders. One truth, however, is beyond all doubt: should these five fall, then Ubersreik will fall with them. | ["Music", "Rumble"] | ["sound of water drops", "animal sounds", "rat squealing sound", "videogame sound"] | 0 | aiJj3Z6pu9s | 3570 |
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;