musiccaps_details (view)
7 rows where musiccaps_aspects contains "piano" and musiccaps_aspects contains "playful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- piano · 7 ✖
- playful · 7 ✖
- bass guitar 3
- female vocal 3
- acoustic drums 2
- instrumental 2
- jazz 2
- lively 2
- male vocal 2
- male vocals 2
- melodic singing 2
- upbeat 2
- big band 1
- cartoon theme 1
- childlike 1
- choir 1
- clarinet 1
- cumbia 1
- dance 1
- danceable 1
- electronic drums 1
- emotional 1
- energetic 1
- flute 1
- hip 1
- hip-hop 1
- japanese 1
- joyful 1
- latin 1
- latin dance 1
- latin percussion 1
- live performance 1
- merrily singing 1
- modern sounding 1
- musical piece 1
- no singer 1
- pop rock 1
- positive 1
- r&b 1
- rap-like singing 1
- rapping 1
- saxophone 1
- seductive singing 1
- strings 1
- theme music 1
- trombone 1
- trumpet 1
- trumpets 1
- uplifting 1
- upright bass 1
- winds section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 | |
A Griffon Day | This is a big band jazz music piece. It is an instrumental piece. The main melody is played by a wide variety of the winds section composed of the saxophone, the trumpet, the flute and the clarinet. The piano and the upright bass provide backing structures. The rhythmic background consists of a jazz acoustic drum beat. The atmosphere is playful. This piece could fit perfectly in the soundtrack of a Disney-type animation movie. | 2008-01-27T00:18:25Z | George Pfeiffer | Gus the Brussels Griffon documents a typical day in his life. If you like dogs...or monkeys...or Ewoks....then you'll love this little pooch! | ["Swing music", "Jazz", "Music"] | ["jazz", "big band", "instrumental", "winds section", "saxophone", "trumpet", "flute", "clarinet", "upright bass", "piano", "acoustic drums", "lively", "playful", "upbeat"] | 9 | JU6GUqRqbtI | 2011 | |
Ariana Grande Rap rapping singing THE WAY ft. Mac Miller | This is an r&b/hip-hop music piece. There is a male vocal rapping and a female vocal singing in a rap-like manner. The beat consists of a piano playing the chords of the tune with an electronic drum backing. The atmosphere of the piece is playful and energetic. This piece could be used in the soundtrack of a high school drama movie/TV show. It could also be played at birthday parties or beach parties. | 2013-10-11T08:10:43Z | Only Best | Like and Subscribe if you like Ariana! | ["Music", "Rapping", "Hip hop music", "Electronica"] | ["r&b", "hip-hop", "male vocal", "rapping", "female vocal", "rap-like singing", "piano", "electronic drums", "energetic", "hip", "danceable", "playful", "modern sounding"] | 9 | UcabTrKowlI | 2929 | |
Chas and Dave - Gertcha (1979) | This is a live performance of a pop rock music piece. Two male vocals are singing melodically at the same time. There is a piano playing an upbeat melody while the bass guitar plays a simple bass line in the background. The piece has a joyful aura to it. This piece could be used in the soundtrack of a sit-com during the scenes of a character happily walking through the city. | 2013-07-27T13:24:08Z | Chas and Dave Videos | Chas and Dave on 'Top Of The Pops', in 1979... they performed this song 3 times on TOTP, 31st May, 14th June & 28th June. This is probably either the 2nd or 3rd appearance. | ["Singing", "Music", "Ska", "Speech"] | ["pop rock", "live performance", "male vocals", "melodic singing", "piano", "bass guitar", "playful", "joyful", "upbeat"] | 9 | q87TmUmVg0Y | 4756 | |
WMB-12-007 情熱大陸(トロンボーン・ソロ) | This is a jazz music piece. There is a piano and a trombone playing a groovy tune. The atmosphere is lively. This piece could be used as an opening theme for a nighttime talk show or a historical YouTube channel. | 2012-12-07T06:47:10Z | めちゃモテ・シリーズ | ★管楽器プレイヤーのための新しいソロ楽譜"めちゃモテ"シリーズ ~トロンボーン~ 演奏:前田 大輔 編曲:前田大輔、萩原 隆、小林真人 この曲はTBS系ドキュメンタリー番組「情熱大陸」のオープニング曲です。 情熱的なヴァイオリンとバンドネオンのエキゾチックな響きが印象的で、 この曲が収録されたアルバム「image」は、イージーリスニング音楽のアルバムとして史上初のオリコン総合チャート1位を記録し話題となりました。 演奏に使われている楽譜の購入はコチラから ↓伴奏CD付楽譜 http://brass.winds-score.com/?pid=52535119 | ["Brass instrument", "Trombone"] | ["jazz", "no singer", "instrumental", "piano", "trombone", "lively", "playful", "theme music"] | 9 | tBKOvAiNOQE | 5014 | |
Doraemon Opening Theme Song (Japanese Version) | This is the theme of a cartoon. There is a female vocalist singing merrily at a medium-to-high pitch in the Japanese language. The melody is being played on the strings and the piano while a simple on-beat bass line can be heard being played in the background. There is a simple 4/4 acoustic drum beat for the rhythm. The piece has an uplifting atmosphere. This piece could be used in the soundtrack of a children's movie. It could also be used in anime soundtracks. | 2012-04-28T03:24:44Z | Jennifer Nguyen | Doraemon Opening Theme Song (Japanese Version) | ["Music", "Happy music"] | ["cartoon theme", "female vocal", "merrily singing", "strings", "piano", "bass guitar", "acoustic drums", "playful", "uplifting", "positive", "childlike", "japanese"] | 9 | wBozBh7BR6k | 5247 | |
Skylar Astin Singing 'Middle of a Moment' | This is a piece from a musical. The piano is playing a repetitive tune. There is a male vocalist singing melodically. There is a playful atmosphere to the piece. This piece could be playing in the background during activities for kids. | 2015-04-24T00:28:02Z | MoonshoesLisa | Skylar Astin Singing 'Middle of a Moment' for the James and the Giant Peach cast album, composed by Pasek & Paul. Download the album here: www.jatgp.com Original video from Entertainment Weekly http://www.ew.com/article/2015/04/20/watch-darren-criss-skylar-astin-sing-james-and-giant-peach-musical?hootPostID=2dca8c9b3fd0a9573b41648e9a71e093 | ["Electric piano", "Keyboard (musical)", "Piano"] | ["musical piece", "piano", "male vocal", "melodic singing", "playful", "emotional"] | 9 | z_fEIZOv0JY | 5494 |
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;