musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "flute" and musiccaps_aspects contains "piano" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drums 2
- flute · 2 ✖
- piano · 2 ✖
- acoustic guitar 1
- ballad 1
- bass guitar 1
- car engine sound 1
- gentle singing 1
- jazz music 1
- male vocal 1
- mashup 1
- romantic 1
- scratching 1
- sentimental 1
- shouting 1
- thai 1
- turntable 1
- valentines 1
- youtube channel intro 1
musiccaps_names (array) 7 ✖
- Car 1
- Happy music 1
- Music 1
- Music of Asia 1
- Scratching (performance technique) 1
- Song 1
- Vehicle 1
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 | |
รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music | This is a Valentine's ballad. The male vocalist is singing gently in the Thai language. There is an acoustic guitar, a piano and a flute playing the melody interchangeably. There is a simple acoustic drum beat in the rhythmic background. The atmosphere of this piece is romantic. It could be used in romantic social media content in Thailand. It could also be used in romantic movies and TV shows that take place in Thailand. | 2016-02-05T05:56:27Z | ป.ฉลาดใหญ่ | รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | Happy Valentines Love Music ฝากกดติดตามช่อง ป.ฉลาดใหญ่ บันเทิงศิลป์ ด้วยนะครับ คลิกที่ลิ้งค์เลย https://www.youtube.com/channel/UC98T... แสลงใจ อ้ายมีเขา แต่เจ้ามีอ้าย กลิ่นไฟเก่า บ่ฮักกะส่าง อยู่กับอ้ายน้อยใจบ่ ผัวสำรอง เมียสำรอง ฮัก คารม ซ่อยข่อยแหน่ | ["Music of Asia", "Music", "Song", "Happy music"] | ["ballad", "male vocal", "gentle singing", "acoustic guitar", "piano", "flute", "acoustic drums", "sentimental", "romantic", "valentines", "thai"] | 9 | L0oun9F67tg | 2142 |
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;