musiccaps_details (view)
3 rows where musiccaps_aspects contains "saxophone solo" and musiccaps_names contains "Saxophone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- instrumental 3
- saxophone solo · 3 ✖
- live performance 2
- no singer 2
- acoustic drums 1
- bass guitar 1
- brass section 1
- classical 1
- classical music 1
- complex 1
- dramatic 1
- emotional 1
- improvisation 1
- jazz 1
- movie music 1
- movie soundtrack 1
- organ 1
- piano 1
- poor quality 1
- rising pattern 1
- romantic 1
- saxophone 1
- tension 1
- timpani 1
- tranquil 1
- trumpet solo 1
- varying pitch 1
musiccaps_names (array) 5 ✖
- Saxophone · 3 ✖
- Brass instrument 2
- Clarinet 1
- Music 1
- Wedding music 1
youtube_published (date) 3 ✖
- 2008-04-27 1
- 2009-09-21 1
- 2011-02-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joey DeFrancesco & George Coleman - Ceora | This is the live performance of a jazz music piece. There is an organ playing the chords in the background. There is a complex and improvised saxophone solo in the lead. The acoustic drums are playing a mellow jazz beat. The atmosphere is rather tranquil. This piece could be playing in the background at a coffee shop or a classy restaurant. | 2011-02-05T19:16:50Z | Peter W. Bosse | Joey DeFrancesco (Hammond B-3 organ) George Coleman (saxophone) Jake Langley (guitar) Byron Landham (drums). rec. 2006 | ["Brass instrument", "Saxophone"] | ["jazz", "live performance", "no singer", "instrumental", "organ", "saxophone solo", "bass guitar", "acoustic drums", "tranquil", "complex", "improvisation"] | 9 | CYuYfvQv4eo | 1376 | |
The Thomas Crown Affair OST (1968) Moments of Love | This is a classical music piece from a movie soundtrack. There is a brass section holding a single chord while a saxophone and then a trumpet plays a solo in the lead. The rhythmic background is provided with a crescendo movement played by a timpani. The atmosphere is dramatic. This piece can be used in the soundtrack of a drama movie during scenes of elevated tension. | 2009-09-21T16:58:41Z | ryan W | Here is the 9th track from the thomas crown affair ost 9. Moments of Love This is my absolute favorite track on this ost. When you hear it you'll know why. | ["Brass instrument", "Clarinet", "Saxophone"] | ["classical music", "movie soundtrack", "instrumental", "brass section", "saxophone solo", "trumpet solo", "varying pitch", "timpani", "rising pattern", "dramatic", "tension"] | 9 | WrpWb-Zumnc | 3142 | |
Beauty and the Beast - Saxophone Wedding Song | This is a live performance of a movie music piece. The recording has a very poor quality. The saxophone is playing the main tune while the piano can be heard providing a melodic background. The atmosphere is romantic and it is probably a wedding setting. | 2008-04-27T14:01:36Z | saxophonedaniel | Beauty and the Beast - Saxophone Wedding Song | ["Music", "Wedding music", "Saxophone"] | ["movie music", "classical", "live performance", "no singer", "instrumental", "saxophone", "saxophone solo", "piano", "romantic", "emotional", "poor quality"] | 9 | as7MhTe961k | 3581 |
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;