musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_author = 9 and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- energetic · 4 ✖
- instrumental 3
- no singer 3
- danceable 2
- electronic drums 2
- acoustic drums 1
- aggressive 1
- bass 1
- bass guitar 1
- bebop jazz 1
- complex 1
- cover 1
- crisp synth 1
- electric guitar sound 1
- electronic 1
- guitar solo 1
- hip-hop 1
- improvisation 1
- j-pop 1
- keyboard 1
- loud electronic drums 1
- melodic pad 1
- modern sounding 1
- organ 1
- piano sample 1
- piano sound 1
- poor quality 1
- repeated theme 1
- solo 1
- strong bass 1
- synth 1
- techno trance 1
- urban 1
- wobbly bass 1
musiccaps_names (array) 5 ✖
- Electric piano 4
- Keyboard (musical) 4
- Piano · 4 ✖
- Hammond organ 1
- Organ 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lil Debbie - "420" ft. Wiz Khalifa - OFFICIAL VERSION | This is a hip-hop music piece. There is a crisp synth sound playing the melody. The piece has a strong bass sound. There is a melodic pad with beat repeat effect that uses a piano sample. The rhythmic background is provided by a loud electronic drum beat. The piece is energetic and modern sounding. It could be used in the soundtrack of a sci-fi movie where there is a lot of action going on. | 2015-07-30T19:15:09Z | LiLDebbieTV | ["Electric piano", "Keyboard (musical)", "Piano"] | ["hip-hop", "electronic", "crisp synth", "melodic pad", "piano sample", "strong bass", "loud electronic drums", "modern sounding", "aggressive", "energetic"] | 9 | -YATTKBtmRA | 60 | ||
DJ Splash , DJ Inphinity , Capella on keyboard | This is a techno trance music piece being performed on the keyboard. It is an instrumental piece. Initially, a brief tune is being played with the piano sound. Then, a wobbly bass and an electronic drum beat starts playing. The atmosphere is energetic and the sound is urban. This piece could be used in the soundtrack of a mobile car racing game. | 2009-03-21T20:02:39Z | music01234567 | Here i'm trying to play the following songs: DJ Splash-Always and forever (From 2:12-3:12 ??? I just got carried away) DJ Splash-Crying soul DJ Inphinity-12 inch Capella-You got to let the music Hope you like it : ) | ["Electric piano", "Keyboard (musical)", "Piano"] | ["techno trance", "no singer", "instrumental", "piano sound", "wobbly bass", "electronic drums", "energetic", "urban", "danceable"] | 9 | 6XZGmRuaOfo | 765 | |
Cory henry | This is the poor quality recording of a bebop jazz music performance. The organ is playing an insanely complex improvised solo. In the background, there is a bass guitar and a jazz acoustic drum beat. The atmosphere is energetic. | 2007-10-17T20:56:15Z | joeydkeys | Cory killin donna lee | ["Organ", "Electric piano", "Hammond organ", "Keyboard (musical)", "Piano"] | ["poor quality", "no singer", "instrumental", "bebop jazz", "organ", "solo", "improvisation", "bass guitar", "acoustic drums", "energetic", "complex"] | 9 | GWxiiDBK5s8 | 1731 | |
Kis-My-Ft2 - SHE!HER!HER! 弾いてみた! | This is an instrumental cover of a J-pop music piece. There is no singer in this piece. The melodic background consists of the keyboard and the bass playing a repeated theme. There is a synth solo with an electric guitar sound being played as the lead. In the rhythmic background, there is a fast tempo electronic drum beat. The atmosphere is danceable and energetic. This piece can be used in the soundtrack of a car racing video game. It could also be used in the soundtrack of an anime during competitive scenes. | 2012-02-15T09:13:54Z | るるる | 3月21日発売キスマイの3rdシングルを弾いてみました。 チャンネル移転しました。今後はこちらで投稿していきます。 https://www.youtube.com/channel/UCEvafWR0r3HI3jgxGBjquwg?feature=watch たくさんのコメントありがとうございます。 一部のコメントや質問に関しまして、ドラムやベースからすべて私の打ち込みです。CDなしで弾いてくださいというコメントがありますが発売前ですし動画内でCDは一切使用しておりません。 ドラム含めて私自身の演奏ですのでご理解ください。 | ["Electric piano", "Keyboard (musical)", "Piano"] | ["j-pop", "cover", "no singer", "instrumental", "electric guitar sound", "guitar solo", "keyboard", "synth", "bass", "electronic drums", "repeated theme", "danceable", "energetic"] | 9 | Sa3Ky5sJshU | 2777 |
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;