musiccaps_details (view)
5 rows where musiccaps_aspects contains "jazz", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "saxophone solo melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- jazz · 5 ✖
- low quality · 5 ✖
- saxophone solo melody · 5 ✖
- passionate 3
- shimmering hi hats 3
- energetic 2
- groovy double bass 2
- mono 2
- noisy 2
- punchy snare 2
- soulful 2
- brass melody 1
- dark 1
- easygoing 1
- groovy 1
- groovy bass 1
- groovy drums 1
- groovy piano 1
- hollow snare 1
- live performance 1
- mellow keys chords 1
- muddy 1
- muffled 1
- punchy kick 1
- reverberant 1
- shimmering cymbals 1
- shimmering shakers 1
- trombone melody 1
- unbalanced stereo 1
- uptempo 1
- walking double bass 1
- warm 1
musiccaps_names (array) 7 ✖
- Brass instrument 2
- Jazz 2
- Music 2
- Saxophone 2
- Carnatic music 1
- Keyboard (musical) 1
- Piano 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 | |
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
Dragon Slayer - Classic Finish | The low quality recording features a jazz song that consists of a saxophone solo melody played over hollow snare, groovy double bass, shimmering hi hats, shimmering shakers and brass melody. It sounds uptempo, groovy and passionate - like something you would hear in a jazz club. | 2008-02-17T22:26:33Z | Nathan | Get all pieces of the runescape triforce... um ya I mean map. Fix up broken boat check, own Elvarg Dragon in classic who is lv 110 perhaps =o. Either way one of us must fall!!! Would or released this videos sooner but I had to lv smithing to 33 in classic =p I do the video in one run, so what you see is what I saw for the very first time while I attempt to beat quests... | ["Brass instrument", "Saxophone"] | ["low quality", "jazz", "uptempo", "groovy", "passionate", "saxophone solo melody", "hollow snare", "groovy double bass", "shimmering hi hats", "shimmering shakers", "brass melody", "energetic"] | 4 | bxZeGrM_0ac | 3667 | |
Carnatic Music Idol #4 Final Instrumental Part 2 | The low quality recording features a jazz song being played in a big room and it consists of a saxophone solo melody over groovy drums. Due to frequency clashing, it sounds muddy and muffled and it has an unbalanced stereo image, as it was probably recorded with a poor quality microphone. It is still energetic and easygoing at the same time - thanks to that saxophone. | 2015-10-21T12:58:14Z | nsushma | ["Carnatic music", "Music"] | ["unbalanced stereo", "low quality", "jazz", "groovy drums", "muffled", "reverberant", "muddy", "saxophone solo melody", "energetic", "easygoing"] | 4 | ciJOulWFhfA | 3734 | ||
Drought Hack: Paint Your Lawn Green... | The low quality recording features a jazz performance that consists of saxophone solo melody played over shimmering cymbals, followed by trombone melody and walking double bass. It sounds warm, but dark, due to the poor quality microphone it was recorded with. | 2015-07-21T19:18:52Z | AJ+ | Lawn painting is one way Californians are dealing with the drought – literally turning brown lawns green. Fresno lawn painter Josh Cox shows AJ+ how it's not too different from painting a house. From video journalist Jessica Sherry in California. Subscribe for more videos: http://www.youtube.com/channel/UCV3Nm3T-XAgVhKH9jT0ViRg?sub_confirmation=1 Like us on Facebook: https://www.facebook.com/ajplusenglish Download the AJ+ app at http://www.ajplus.net/ Follow us on Twitter: https://twitter.com/ajplus | ["Jazz"] | ["low quality", "mono", "noisy", "shimmering cymbals", "trombone melody", "saxophone solo melody", "walking double bass", "jazz", "warm", "dark"] | 4 | e6lTl9JIW5Y | 3844 |
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;