musiccaps_details (view)
6 rows where musiccaps_aspects contains "flute", musiccaps_aspects contains "piano" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- flute · 6 ✖
- piano · 6 ✖
- acoustic drums 3
- sentimental 3
- strings 3
- female vocal 2
- upright bass 2
- acoustic guitar 1
- ballad 1
- bass guitar 1
- big band 1
- car engine sound 1
- clarinet 1
- comedic 1
- complaining 1
- crying 1
- dramatic 1
- dreamy 1
- easygoing 1
- emotional 1
- female voice 1
- gentle singing 1
- heart-touching 1
- hindi film music 1
- instrumental 1
- jazz 1
- jazz music 1
- live performance 1
- lively 1
- male vocal 1
- mashup 1
- medium-to-high pitch singing 1
- movie music 1
- musical 1
- orchestra 1
- playful 1
- rock opera 1
- romantic 1
- saxophone 1
- scratching 1
- shouting 1
- sitar 1
- story-telling mood 1
- thai 1
- trumpet 1
- turntable 1
- upbeat 1
- valentines 1
- winds section 1
- youtube channel intro 1
musiccaps_names (array) 14 ✖
- Music 5
- Music of Asia 2
- Car 1
- Happy music 1
- Jazz 1
- Sad music 1
- Scratching (performance technique) 1
- Singing 1
- Song 1
- Soundtrack music 1
- Swing music 1
- Traditional music 1
- Vehicle 1
- Yodeling 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 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 | |
รวมลูกทุ่งเพลงรักต้อนรับวานเลนไทน์ | 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 | |
The Sound of Music Soundtrack - 4 - Maria | This is a musical piece. There is a story-telling mood in this piece. The female vocalist is singing about her troubles in a complaining manner. There are many instruments in the melodic background such as piano, strings, flute and upright bass. The atmosphere of the piece is easygoing and comedic. | 2011-03-15T01:45:42Z | xosoundtrackloverxo | ["Yodeling", "Music", "Soundtrack music"] | ["musical", "movie music", "female vocal", "story-telling mood", "piano", "strings", "flute", "upright bass", "complaining", "easygoing", "comedic"] | 9 | OKZF0oG1E14 | 2427 | ||
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 | |
Dil Tujhe Dia Tha... (Malhar) | This is a Hindi film music piece. Initially, there is a female voice crying. Afterwards, an orchestra made up of a flute, a string element, a sitar and a piano starts playing an emotional tune. The atmosphere of the piece is heart-touching. It could be used in the soundtracks of Bollywood movies during heartbreaking scenes. | 2008-07-10T00:15:10Z | IMIRZA777 | oldie. | ["Traditional music", "Music"] | ["hindi film music", "female voice", "crying", "flute", "strings", "sitar", "piano", "sentimental", "emotional", "heart-touching"] | 9 | nnc6m1pBJ4c | 4578 |
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;