musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "piano" and musiccaps_names contains "Car"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Classic Game Room HD - BURNOUT PARADISE review Part 2 | This is an intro to a YouTube video. Initially, there is a turntable scratching sound with a shouting sample. Then an upbeat jazz music piece starts playing. There is a piano and a flute playing the melody while a bass guitar plays in the background. The jazz acoustic drum beat provides the rhythm. There is a car engine sound coming from a video gameplay. It is a whole mashup of different sounds. | 2008-12-10T19:19:15Z | CGR Publishing | Part 2. WATCH IN HIGH DEFINITION. Classic Game Room reviews BURNOUT PARADISE for the Xbox 360, also available for the PS3. This review shows Burnout Paradise gameplay and footage of the massive crashes in Burnout. This game is a blast to play and should appeal to a wide range of gamers. It has cars that drive like cars (not sleds on ice), insane crashes, lots of roads and courses, challenges and jumps... basically it has something for everyone. Burnout Paradise is sold at a bargain price and packs full price value and fun! CGR loves this game and finds the challenges, driving and car collecting addictive and entertaining. It looks amazing in 1080i HD cruising around Paradise City which is a blend of New York City, Chicago, London and a number of other cities. Find hidden jumps, gates to crash through and shortcuts. Can't find all the shortcuts? Well, keep driving and trying to wreck other cars. You'll locate them all on the map eventually. The cars are modeled after real cars... loosely. You'll find cars the resemble the Toyota Supra, Jaguar coupe, Ford GT40, Nissan Skyline, Cadillac and more. Published by EA, Burnout Paradise has a download for bikes. It is playable on XBLA and can also be downlaoded for PS3 and played there. Classic Game Room reviews Burnout Paradise in this, the self proclaimed best Burnout Paradise review on YouTube. Why is it the best? Why are hot dogs good? They just are. You can win achievement points and there is a list of all of them available in the game, CGR wins a number of gamerpoints during the review as we worked our way up to the A Level license. Classic Game Room. | ["Scratching (performance technique)", "Vehicle", "Car"] | ["youtube channel intro", "turntable", "scratching", "shouting", "jazz music", "piano", "bass guitar", "flute", "acoustic drums", "car engine sound", "mashup"] | 9 | 59Mt7J_0KT4 | 638 |
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;