musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "soulful" and musiccaps_names contains "Keyboard (musical)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- low quality · 4 ✖
- soulful · 4 ✖
- passionate 3
- classical 1
- emotional 1
- exciting 1
- filtered synth bass 1
- groovy bass 1
- harpsichord melody 1
- harpsichord solo melody 1
- jazz 1
- live performance 1
- mellow keys chords 1
- noisy 1
- pop 1
- punchy kick 1
- punchy snare 1
- repetitive piano melody 1
- saxophone solo melody 1
- shimmering hi hats 1
- suspenseful synth 1
- sustained strings melody 1
- uplifting 1
musiccaps_names (array) 6 ✖
- Keyboard (musical) · 4 ✖
- Harpsichord 2
- Piano 2
- Electric piano 1
- Jazz 1
- Music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J. S. Bach - Toccata No. 3 in D Major BWV 912 (3/3) | The low quality recording features a harpsichord solo melody. It sounds passionate, emotional and the recording is noisy. | 2008-07-26T19:32:42Z | The30YearOldVirgin | Johann Sebastian Bach (1685 - 1750) Toccata for keyboard No.3 in D Major, BWV 912, Mov.III - Allegro Composed between 1707 and 1708. Performed by Jory Vinikour | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "harpsichord solo melody", "passionate", "soulful", "noisy"] | 4 | 9PQZSLa_A8A | 1002 | |
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 | |
J. S. Bach: Harpsichord concerto (from Vivaldi's RV Anh. 10) in B minor (BWV 979) I. (Adagio) | The low quality recording features a classical song played on harpsichord. It sounds emotional, soulful and passionate. | 2009-02-28T14:11:55Z | John Portman | GERMAN BAROQUE Johann Sebastian Bach Concerto for harpsichord (from Antonio Vivaldi or Giuseppe Torelli's RV Anh. 10) in B minor (BWV 979) I. (Adagio)-Allegro-Adagio-Allegro-(Grave)-Andante Olivia Giubboni (harpsichord) | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "harpsichord melody", "classical", "passionate", "emotional", "soulful"] | 4 | Uo-Okq1D8Xo | 2943 | |
Jess Mills - Live For What I'd Die For | The low quality recording features a pop song that consists of suspenseful synth, repetitive piano melody, filtered synth bass and sustained strings melody located in the left channel of the stereo image. It sounds uplifting, soulful and exciting. | 2011-07-01T16:20:26Z | JessMillsVEVO | NEW SINGLE PIXELATED PEOPLE OUT FEB 12th FREE DOWNLOAD 'A FOREST' HERE - http://www.jessmills.co.uk/download www.jessmills.co.uk | ["Electric piano", "Keyboard (musical)", "Piano"] | ["pop", "low quality", "suspenseful synth", "repetitive piano melody", "filtered synth bass", "sustained strings melody", "soulful", "uplifting", "exciting"] | 4 | Zbmm_hXcrA0 | 3397 |
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;