musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_names contains "Musical instrument" and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- passionate · 3 ✖
- emotional 2
- live performance 2
- arpeggiated piano melody 1
- bossa nova 1
- classical 1
- fiesta 1
- giro 1
- heart-touching 1
- instrumental music 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
- memdium tenpo 1
- mono 1
- music keyboard demo 1
- noisy 1
- old school romance 1
- party time 1
- passioante affair 1
- passionate affair 1
- piano 1
- rhodes organ 1
- romantic 1
- sad 1
- spirited 1
- theremin solo melody 1
- various percussion hits 1
musiccaps_names (array) 7 ✖
- Music 3
- Musical instrument · 3 ✖
- Piano · 3 ✖
- Keyboard (musical) 2
- Classical music 1
- Synthesizer 1
- Theremin 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 | |
Elvis on Theremin | The low quality recording features a live performance that consists of a theremin solo melody played over arpeggiated piano melody. It sounds sad, emotional and passionate, even though the recording is noisy and in mono. | 2007-08-22T03:47:23Z | MisterScott99 | Scott Marshall performs the Elvis standard on Theremin to his own piano back track from a sequencer. | ["Music", "Musical instrument", "Piano", "Theremin"] | ["low quality", "live performance", "arpeggiated piano melody", "noisy", "mono", "theremin solo melody", "sad", "emotional", "passionate"] | 4 | vZUup6rK728 | 5192 | |
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;