musiccaps_details (view)
3 rows where musiccaps_author = 0, musiccaps_names contains "Keyboard (musical)" and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 21 ✖
- no other instruments 2
- no voices 2
- bass notes 1
- different tones 1
- electric piano 1
- instrumental 1
- jazz tone 1
- male voice 1
- music fading out 1
- no melody 1
- no percussion 1
- organ music 1
- piano song 1
- reverb 1
- ringing guitar chord 1
- romantic mood 1
- slow pop 1
- slow tempo 1
- sound testing 1
- synth song 1
- treble notes 1
musiccaps_names (array) 8 ✖
- Keyboard (musical) · 3 ✖
- Piano · 3 ✖
- Electric piano 2
- Hammond organ 1
- Music 1
- Musical instrument 1
- Organ 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Resolution - Jack's Mannequin (Live, Acoustic) | This slow pop song features the end of a song. A male voice sings one syllable. The piano plays three notes followed by two high pitch notes. A guitar chord is heard ringing in the background. There is no percussion in this song. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2008-11-30T20:47:21Z | cassielovesandrew | ⓒBuzznet 2008, enjoy & comment! :) | ["Electric piano", "Keyboard (musical)", "Piano"] | ["slow pop", "piano song", "reverb", "male voice", "music fading out", "slow tempo", "ringing guitar chord", "romantic mood"] | 0 | QmIhKF1BqCg | 2640 | |
Korg BX3 Demo | This song features an electric organ playing different tones. There is no melody in this song. This is a demo of the different tones that can be played on the electric organ. There are no voices in this song. This can be played in a demo video of this electric organ. | 2008-04-13T18:33:02Z | hankiegirl2 | This is a one of the old original KORG BX3 witgh a Leslie 760. Good heavy sound with mega overdrive og and click | ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] | ["organ music", "different tones", "no voices", "no other instruments", "no percussion", "no melody"] | 0 | QyMcSnNsAPw | 2653 | |
Yamaha MOX8 vs Korg Krome 88 | This clip features a synth being played. The tone is that of an electric piano. This synth plays the bass notes as well as the treble notes. This song has no other instruments. This is an instrumental song with no voices. This song can be played in an instructional video for synthesizers. | 2013-01-24T18:54:05Z | A&C Hamilton Musical Instruments | Stuart Smythe at instruments2go plays a bunch of tunes on the mighty MOX8 and Krome 88 side by side. Which do you like best? Let us know in the comments! | ["Electric piano", "Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["synth song", "jazz tone", "electric piano", "no other instruments", "no voices", "instrumental", "bass notes", "treble notes", "sound testing"] | 0 | g8XTU3OalGs | 4009 |
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;