musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "no singer" and musiccaps_aspects contains "upright bass"
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 |
---|---|---|---|---|---|---|---|---|---|---|
"Milestones" (Miles Davis) | This is the live performance of a jazz music piece. There is a trumpet solo at the forefront. The background consists of the piano, the upright bass and a jazz acoustic drum beat. The atmosphere is restless. This piece could be playing in the background at a jazz bar. | 2006-08-18T02:23:52Z | Bobbelden | BOB BELDEN BIG BAND "Birdland" May 26, 2004 Jeremy Pelt-trumpet soloist, Joe Lovano-tenor sax soloist Seneca Black, Tony Kadleck, Ray Vega, Lew Glucken-trumpets Dave Gibson, Andre Hayward-trombones John Clark-french horn Howard Johnson-tuba Tim Ries, Charles Pillow, Mike Migliore, Ronnie Cuber, Gary Smulyan(winds) Kevin Hays-piano Derek Neyvergeld-bass Tommy Crane-drums Camera: Mantis Evar | ["Brass instrument", "Trumpet"] | ["jazz", "jazz fusion", "live performance", "no singer", "instrumental", "trumpet solo", "piano", "upright bass", "acoustic jazz drums", "improvisation", "complex", "restless"] | 9 | R6k2BkwZt1Y | 2670 | |
Professional Charleston - Strictly Come Dancing 2011 | This is a big band jazz music piece. It is an accompaniment piece to the Charleston dance. The band consists of a wide range of brass sections, an upright bass, a jazz acoustic drum beat and a vibraphone. Sounds from the cheering crowd can be heard. The atmosphere is lively. The piece is upbeat. | 2011-12-05T22:33:48Z | LunaleeTreasureBox | 2011 Professional Dancers: Pasha Kovalev Katya Virshilas Artem Chigvintsev Kristina Rihanoff Brendan Cole Erin Boag Anton du Beke Ola Jordan Robin Windsor Natalie Lowe Vincent Simone Aliona Vilani James Jordan Flavia Cacace 2011 Couples: Alex Jones & James Jordan Anita Dobson & Robin Windsor Audley Harrison & Natalie Lowe Chelsee Healey & Pasha Kovalev Dan Lobb & Katya Virshilas Edwina Currie & Vincent Simone Harry Judd & Aliona Vilani Holly Valance & Artem Chigvintsev Jason Donovan & Kristina Rihanoff Lulu & Brendan Cole Nancy Dell'Olio & Anton du Beke Robbie Savage & Ola Jordan Rory Bremner & Erin Boag Russell Grant & Flavia Cacace | ["Swing music", "Ska"] | ["jazz", "big band", "charleston dance", "no singer", "instrumental", "brass section", "upright bass", "acoustic drums", "vibraphone", "lively", "upbeat"] | 9 | WmyhSRhWh3k | 3135 |
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;