musiccaps_details (view)
4 rows where musiccaps_aspects contains "soulful" and musiccaps_names contains "Saxophone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality 4
- soulful · 4 ✖
- mono 3
- noisy 3
- passionate 3
- jazz 2
- saxophone solo melody 2
- shimmering hi hats 2
- emotional 1
- flat male vocal 1
- groovy bass 1
- groovy double bass 1
- groovy piano 1
- harmonizing clarinet melodies 1
- live performance 1
- mellow piano chords 1
- punchy kick 1
- punchy snare 1
- snappy rimshots 1
- sustained strings 1
- tenor sax solo melody 1
musiccaps_names (array) 7 ✖
- Brass instrument 4
- Saxophone · 4 ✖
- Clarinet 1
- Jazz 1
- Music 1
- Musical instrument 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ben Webster - For All We Know | The low quality recording features a jazz song that consists of a saxophone solo melody played over groovy piano, groovy double bass, shimmering hi hats and punchy snare. It sounds passionate and soulful, even though the recording is noisy and in mono. | 2010-03-07T16:01:07Z | IrishDutchman | A great tune played in an uncharacteristically upbeat tempo by the master of ballads, Ben Webster. It sounds like the band is having a great time and if you listen closely you can overhear a few snippets of conversation between the players. Sadly I don't know who he recorded this track with. If you happen to know, feel free to send me a message. Hope you like it! | ["Brass instrument", "Saxophone"] | ["low quality", "noisy", "mono", "jazz", "saxophone solo melody", "shimmering hi hats", "groovy piano", "groovy double bass", "passionate", "soulful", "punchy snare"] | 4 | 8sSV_vqOlS4 | 957 | |
Tears in Heaven | The low quality recording features a saxophone solo melody being played. It sounds passionate, soulful and the recording is noisy and in mono. | 2008-08-10T16:12:57Z | saxanon | Been learning the sax for a few months! Got a long way to go! | ["Brass instrument", "Saxophone"] | ["low quality", "mono", "noisy", "saxophone solo melody", "passionate", "soulful"] | 4 | LRz6Y6oltQ4 | 2189 | |
High School Band Teacher | The low quality recording features a flat male talking, after which there are harmonizing clarinet melodies playing. It sounds soulful and the recording is in mono and noisy. | 2013-08-02T17:29:12Z | GO PUBLIC: A Day in the Life of an American School District | Joel Lopez is the high school band director at Marshall Secondary School. He educates his class of aspiring rock stars and jazz musicians by day, then takes care of his baby daughter by night. For more information visit www.gopublicproject.org | ["Brass instrument", "Clarinet", "Saxophone"] | ["low quality", "mono", "noisy", "harmonizing clarinet melodies", "flat male vocal", "soulful"] | 4 | k6F3gc8f8kI | 4299 | |
Tony on Tenor Sax | The low quality recording features a live performance of a jazz song that consists of a tenor sax solo melody playing over mellow piano chords, sustained strings, groovy bass, snappy rimshots, shimmering hi hats and punchy kicks. It sounds emotional, passionate and soulful. | 2008-01-24T22:22:32Z | Tony Bolivar | Because of Who You Are | ["Brass instrument", "Jazz", "Music", "Musical instrument", "Wedding music", "Saxophone"] | ["low quality", "live performance", "jazz", "tenor sax solo melody", "groovy bass", "mellow piano chords", "shimmering hi hats", "punchy kick", "snappy rimshots", "sustained strings", "passionate", "emotional", "soulful"] | 4 | tuoBmxts5Xo | 5075 |
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;