musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "Keyboard (musical)" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate · 3 ✖
- live performance 2
- bossa nova 1
- classical 1
- emotional 1
- fiesta 1
- giro 1
- groovy bass 1
- heart-touching 1
- instrumental music 1
- jazz 1
- keyboard styles 1
- latin dance groove 1
- latin dancers 1
- latin jazz music 1
- latin percussion instruments 1
- low quality 1
- madly in love 1
- medium tempo 1
- mellow keys chords 1
- memdium tenpo 1
- music keyboard demo 1
- old school romance 1
- party time 1
- passioante affair 1
- passionate affair 1
- piano 1
- punchy kick 1
- punchy snare 1
- rhodes organ 1
- …
musiccaps_names (array) 7 ✖
- Keyboard (musical) · 3 ✖
- Music · 3 ✖
- Piano 3
- Musical instrument 2
- Classical music 1
- Jazz 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Korg PA900 vs Roland BK9 Keyboard | The song is an instrumental. The song is medium tempo with various Latin percussion playing groovily to the sounds of a Rhodes organ melody. The song is romantic and passionate. The soundtrack is a demonstration for a keyboard model. | 2013-10-16T18:45:43Z | A&C Hamilton Musical Instruments | http://www.achamilton.co.uk/Korg/PA900/index.htm We thought we should do a quick video comparison of the Korg PA900 and Roland BK-9. This is just a small example of similar styles and sounds in the instruments. Which would you prefer? | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Synthesizer"] | ["latin dance groove", "bossa nova", "giro", "madly in love", "passioante affair", "old school romance", "passionate affair", "medium tempo", "latin percussion instruments", "memdium tenpo", "rhodes organ", "various percussion hits", "latin jazz music", "latin dancers", "romantic", "party time", "fiesta", "romantic", "spirited", "passionate", "keyboard styles", "instrumental music", "music keyboard demo"] | 1 | LKVSEQCLCLo | 2177 | |
Fender Rhodes Mark VII | The low quality recording features a live performance of a jazz song and it consists of a saxophone solo melody played over mellow keys chords, groovy bass, punchy snare and kick hits and shimmering hi hats. It sounds passionate and soulful. | 2007-01-29T02:12:06Z | alex.rodrigues | Namm Show report on New Rhodes MK 7 http://www.rhodespiano.com/namm_info.htm | ["Jazz", "Music", "Keyboard (musical)", "Piano"] | ["low quality", "jazz", "live performance", "saxophone solo melody", "shimmering hi hats", "punchy kick", "punchy snare", "mellow keys chords", "groovy bass", "passionate", "soulful"] | 4 | Oe_xSG_ic-c | 2455 | |
Schubert: Impromptu in G flat Op. 90 No. 3 | This is a classical music performance. The piece is played by a classical piano which is complex with rising and falling sequences. The atmosphere is filled with emotion and passion. This heart-touching piece could certainly be used in the soundtrack of a drama movie or a TV show. | 2012-12-25T19:58:02Z | Boris Bizjak | Piano recital by Olga Jegunova - http://www.jegunova.com/ Bishopsgate Institute (London), October 2012. Franz Schubert: Impromptu in G flat Op. 90 No. 3 Multimedia engineer - Boris Bizjak http://www.borisbizjak.com/#!hedone | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["classical", "piano", "live performance", "emotional", "passionate", "heart-touching"] | 9 | w_z9oSn-eIM | 5277 |
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;