musiccaps_details (view)
2 rows where musiccaps_aspects contains "jazz song" and musiccaps_names contains "Jazz"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- jazz song · 2 ✖
- chindong 1
- double bass 1
- instrumental 1
- latin style percussion 1
- low quality audio 1
- male narrator 1
- moderate tempo 1
- no voice 1
- outro 1
- percussion 1
- piano 1
- saxophone 1
- upbeat 1
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 | |
ある道化師の週末 / cicala-mvta (chin-dong-punk-jazz!!) | This is a low quality audio clip. This jazz song features percussion playing a Latin style beat. A chindong is being played along with the main percussion. This instrument has a 'tin' sound. There are no other instruments in this song. The male singer narrates one line in the course of this song. This is an instrumental song. The mood of this song is happy. | 2008-11-30T14:28:35Z | ebirin831 | Cicala-Mvta is One of Japanese Most Exciting and Original Groups. Both Traditional Chindon and the Retro-futuristic Sound of Cicala-Mvta is an Entirely Natural Combination of the Old and New, the East with the West. (Amazon review) Cicala Mvta is a group described by some UK music critics as the most impressive exponents of contemporary Japanese grass roots music. The music presents old-fashioned and brass band music. Featuring chindon, a kind of Japanese drum, saxophones, clarinets and tubas, Cicala Mvta's music is a kind of street music originally played at funerals or the openings of local shops. But the band blends the cheesy music with social critique, thus creating a sarcastic outlook, in both its musical style and in its stage performance. (TAIPEI TIMES By Yu Sen-lun Jun 18, 2004) シカラムータLIVE! 2008.11.29 @京都『磔磔』 | ["Jazz", "Music", "Orchestra", "Rattle (instrument)", "Speech"] | ["jazz song", "low quality audio", "latin style percussion", "chindong", "male narrator"] | 0 | sZQ4TeLueSs | 4960 |
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;