musiccaps_details (view)
1 row where musiccaps_aspects contains "crumbling sounds" and musiccaps_author = 2 sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 4 ✖
- bass drum 1
- crumbling sounds · 1 ✖
- downward sliding strings 1
- wind sounds 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Firefighter Simulator 3D | The excerpt starts off with 3 bass drum beats after which an explosion and a crumbling sound can be heard. After this, downward sliding strings or a similar instrument in timbre can be heard creating a sort of scary effect. In the background wind sounds can be heard throughout. | 2014-02-12T08:37:16Z | Ovilex Soft | Download iOS: https://itunes.apple.com/us/app/firefighter-simulator-3d/id820847297 Download Android: https://play.google.com/store/apps/details?id=com.ovilex.firefightersim3d Play it with MOGA pocket controller - http://www.ovilex.com/moga-controller/ Have you ever had the dream to become a Fireman? Now you can! Play Firefighter Simulator 3D and save citizens from dangerous fires! Make your way to the fire point by driving different fire trucks! Use your siren to aware everyone about the disaster! Pilot the Fire Department Helicopter to put out bigger fires! Increasing your XP Points will give you acces to newer trucks! Features: - 6 Fire Trucks - Fire Department Helicopter - Interior Camera - Realistic damage - Cool Locations: city, countryside, mountain, desert and snow - Lots of Exciting missions - Tilinting, buttons and steering wheel controls - Fireman third person control - Online Achievements and Leaderboards | ["Music", "Boom"] | ["bass drum", "crumbling sounds", "downward sliding strings", "wind sounds"] | 2 | JSLqi_TsMzs | 2007 |
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;