musiccaps_details (view)
5 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_names contains "Piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- emotional · 5 ✖
- passionate · 5 ✖
- live performance 4
- instrumental music 2
- low quality 2
- noisy 2
- ambient noises 1
- ambient room sounds 1
- arpeggiated piano melody 1
- bad audio quality 1
- bell tones 1
- church organ 1
- church organ playing 1
- classical 1
- crowd noise 1
- devotional music 1
- documentary 1
- energetic 1
- energetic drums 1
- eternal love 1
- ethereal harmony 1
- greatest love sings 1
- groovy bass 1
- groovy bass line 1
- heart-touching 1
- key sounds 1
- keyboard 1
- keyboard accompaniment 1
- legendary musicians 1
- love song 1
- medium tempo 1
- mellow synth keys melody 1
- mono 1
- muffled male vocal 1
- never give up 1
- old school players 1
- organ legends 1
- organist 1
- piano 1
- poor audio quality 1
- pop super hits 1
- r&b 1
- retro pop hits 1
- romantic 1
- sad 1
- slow tempo 1
- song cover 1
- spiritual 1
- switch sounds 1
- theremin solo melody 1
- together forever 1
musiccaps_names (array) 10 ✖
- Piano · 5 ✖
- Keyboard (musical) 4
- Electric piano 2
- Music 2
- Musical instrument 2
- Organ 2
- Classical music 1
- Electronic organ 1
- Hammond organ 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rehearsal Part IV - Urban R&B Worship Flowing and Worshiping | The low quality recording features a live performance of a R&B song that consists of muffled male vocal singing over groovy bass guitar, mellow synth keys melody and energetic drums. There are some crowd noises in the background. The recording is noisy, as it was probably recorded with a phone, but it sounds energetic, passionate and emotional. | 2010-06-12T04:53:53Z | Gospel Musicians | http://gospelmusicians.com/ - Jamal Hartwell, Lydell on bass Tate, Cash on Drums. Worshipping during rehearsal to some Urban Worship | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "noisy", "crowd noise", "live performance", "r&b", "energetic drums", "muffled male vocal", "groovy bass", "mellow synth keys melody", "energetic", "passionate", "emotional"] | 4 | 2I6pPRWKsCQ | 348 | |
Frank Heinen auf der Wersi-Orgel in Konzert! | The song is an instrumental. The tempo is medium with a groovy bass line, keyboard accompaniment, percussive bass line , steady drumming drumming and other percussion hits. The song is a pop song cover with a bad audio quality. | 2009-08-26T20:34:40Z | derjaschka | Ausschnitte von diversen Veranstaltungen 2009! https://www.facebook.com/frankheinenwersi | ["Organ", "Electric piano", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ playing", "instrumental music", "passionate", "emotional", "romantic", "love song", "greatest love sings", "song cover", "live performance", "ambient noises", "bad audio quality", "medium tempo", "ethereal harmony", "bell tones", "keyboard accompaniment", "groovy bass line", "pop super hits", "retro pop hits", "romantic", "eternal love", "together forever", "never give up"] | 1 | Pgpd1yxLcLI | 2558 | |
Keyboard: Booker T. Jones - "Hang'em High" | The song is an instrumental. The song is slow tempo with an organist playing a tune on a church organ and sounds of switches being turned on and off. The song is emotional and sounds devotional in nature. The audio quality is poor with ambient room sounds. | 2009-04-09T19:38:11Z | MusicPlayerNetwork | To see the rest of the interview, head over to http://www.keyboardmag.tv | ["Organ", "Hammond organ", "Keyboard (musical)", "Piano"] | ["organist", "church organ", "organ legends", "old school players", "legendary musicians", "passionate", "spiritual", "switch sounds", "slow tempo", "instrumental music", "key sounds", "ambient room sounds", "keyboard", "emotional", "devotional music", "documentary", "poor audio quality"] | 1 | d9r_kYpOvW8 | 3766 | |
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;