musiccaps_details (view)
3 rows where musiccaps_names = "["Jazz"]" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Watercolour Paintings by Marvin Chew | This jazz song features a saxophone playing the main melody. This is accompanied by percussion playing a jazz beat. A piano plays jazz chords. The double bass plays the root notes with flourishes and fills. This song is the outro of a song and abruptly pauses. The mood of this song is happy. There are no voices in this song. This is an instrumental song. This song can be played in a luxury bar. | 2009-03-30T13:57:17Z | mkjchew | A compilation of Marvin's watercolour paintings. From peaceful landscapes, river scenes to busy markets, Marvin has painted them all in his semi-realistic style with distinctive brushstokes. Visit Marvin's website at http://www.marvinchew.com or be a fan in his Facebook page http://www.facebook.com/pages/Marvin-Chew/10863617213 | ["Jazz"] | ["jazz song", "saxophone", "piano", "percussion", "double bass", "no voice", "instrumental", "upbeat", "moderate tempo", "outro"] | 0 | 50fuQm8B2Yg | 625 | |
Fat Freddy's Drop Blackbird Album Bones | This is a dub/jazz music piece. There is an electric guitar playing the main melody while a fat bass guitar is supporting it in the background. The rhythm is being played by a laid-back acoustic drum beat. The atmosphere is chill and trippy. This piece could be playing in the background at a dance club for a slow dance night. It could also be used in the soundtrack of a romance movie that takes place in the city, especially during intimate scenes. | 2013-10-22T10:00:01Z | Fat Freddy's Drop | Fat Freddy's Drop -- Bones Subscribe now to Fat Freddy's Drop TV - http://bit.ly/Subscribe2FatFreddysDropTV Taken from the album Blackbird released June 2013. Buy the album here - http://smarturl.it/1uy8fl Freddy HQ - http://www.fatfreddysdrop.com ---------------------------- Follow Freddy's at: https://www.facebook.com/fatfreddysdropnz https://www.instagram.com/fatfreddysdropnz https://twitter.com/fatfreddysdrop1 Upcoming Tours: https://tinyurl.com/ydgo2j9w http://fatfreddysdrop.com/gig-guide Merch: https://tinyurl.com/y84dv3ow ---------------------------- | ["Jazz"] | ["dub", "jazz", "reggae", "electric guitar", "bass guitar", "acoustic drums", "chill", "groovy", "trippy"] | 9 | OeNTAUKZgKs | 2454 | |
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;