musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "restless" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- instrumental · 2 ✖
- restless · 2 ✖
- acoustic jazz drums 1
- amplified violin 1
- anxious 1
- baroque 1
- cello 1
- chaotic 1
- classical 1
- compelling 1
- complex 1
- complex notes 1
- contrasting harmonies 1
- delicate 1
- elegant 1
- engaging 1
- enthralling 1
- exquisite 1
- fast tempo 1
- flute 1
- harpsichord 1
- improvisation 1
- italian composition 1
- jazz 1
- jazz fusion 1
- live performance 1
- loosely structured music 1
- melancholic 1
- no singer 1
- piano 1
- piano accompaniment 1
- syncopated harmony 1
- trumpet solo 1
- upright bass 1
- viola 1
- western classical 1
musiccaps_names (array) 4 ✖
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 | |
Caprice - The Court of Faerie | This music is instrumental. The tempo is fast with a spirited harpsichord, contrasting melancholic violin harmony, flute, cello , viola and piano accompaniment. The music is complex, syncopated , melancholic, wistful, anxious and restless. This music is a Western Classical Piece. | 2009-09-27T14:21:26Z | 2ndhead1 | The Court of Faerie | ["Harpsichord", "Keyboard (musical)"] | ["instrumental", "fast tempo", "amplified violin", "restless", "contrasting harmonies", "viola", "anxious", "harpsichord", "flute", "piano accompaniment", "cello", "loosely structured music", "italian composition", "classical", "western classical", "baroque", "elegant", "exquisite", "delicate", "syncopated harmony", "complex notes", "engaging", "enthralling", "compelling", "melancholic", "chaotic", "restless"] | 7 | xtllXrdFAFQ | 5361 |
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;