musiccaps_details (view)
4 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- bad audio quality · 4 ✖
- melancholic · 4 ✖
- instrumental music 3
- passionate 3
- emotional 2
- medium tempo 2
- romantic 2
- soloist 2
- spirited 2
- accordion harmony 1
- accordion lessons 1
- accordion player 1
- acoustic love song 1
- ambient room noise 1
- antique guitar 1
- buzzing noise 1
- cheerful 1
- club 1
- conductor 1
- country music 1
- distorted vocals 1
- documentary soundtrack 1
- documentary video 1
- fast tempo 1
- female singer 1
- great composers 1
- groovy 1
- guitar demo 1
- high gain music 1
- high pitched notes 1
- hissing noise 1
- home recording 1
- lilting music 1
- live performance 1
- master class 1
- missing you 1
- piano accompaniment 1
- poor audio quality 1
- pop cover 1
- pop songs 1
- rich country traditions 1
- sad song 1
- screechy tones 1
- slow tempo 1
- song covers 1
- string quartet 1
- string section 1
- studio 1
- super tone unique tone 1
- vibrato 1
- vintage guitar tone 1
- violin solo 1
- violin technique 1
- water splashing sound 1
- western classical music 1
- with you forever 1
- youtube music class 1
- youtube music video 1
musiccaps_names (array) 14 ✖
youtube_published (date) 4 ✖
- 2007-08-03 1
- 2010-01-18 1
- 2010-10-25 1
- 2013-07-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SOLD! Vintage Supertone Guitar / bottleneck slide blues hawaiian slack key | The song is an instrumental. The song is medium tempo played by a solo guitarist on a vintage super tone with an exquisite tone. The song is emotional and passionate. The song has poor audio quality. | 2010-01-18T16:55:46Z | Keni Lee Burgess | Please visit www.ebay.com Search: Keni Lee | ["Tapping (guitar technique)", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["bad audio quality", "vintage guitar tone", "passionate", "spirited", "guitar demo", "soloist", "antique guitar", "youtube music class", "master class", "buzzing noise", "instrumental music", "ambient room noise", "bad audio quality", "super tone unique tone", "melancholic", "country music", "medium tempo", "rich country traditions"] | 1 | -lPXTBXa0tE | 80 | |
Quatuor EBENE: Ravel, Debussy, Fauré -String Quartets | The song is instrumental. The tempo is fast with violins playing in harmony showing exemplary technique. The song is emotional, spirited and passionate. The song is a western classical music hit. The audio quality is poor. | 2013-07-26T16:49:10Z | Warner Classics | Debussy, Fauré & Ravel: String Quartets CD available on: http://bit.ly/FaureRavelStringquartet http://www.emiclassics.com/quatuor-ebene https://www.facebook.com/QuatuorEbene The Quatuor Ebènes debut recording on Virgin Classics brings together the string quartets of the three emblematic French composers of the late 19th and early 20tb centuries: Fauré, Debussy and Ravel. ________________________________________ ________________________________________ Buy from Amazon (USA): http://www.amazon.com/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (UK): http://www.amazon.co.uk/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (FR): http://www.amazon.fr/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ Buy from Amazon (DE): http://www.amazon.de/exec/obidos/ASIN/B001BWQWKS/emi-jazz-class-21/ref%3Dnosim ________________________________________ http://www.quatuorebene.com/ http://www.emiclassics.com http://www.emiclassics.de ________________________________________ __________ Warner Classics ► Website: http://www.warnerclassics.com Subscribe to our: ► YT- Channel: https://wnrcl.me/subscribeYT ► Newsletter https://wnrcl.me/subscribeNL Follow us on: ► Facebook: http://www.fb.com/WarnerClassicsErato ► Instagram: http://www.instagram.com/warner_classics ► Twitter: http://twitter.com/WarnerClassics ► YouTube: https://www.youtube.com/warnerclassics Listen to us on: ► Spotify: http://open.spotify.com/user/warnerclassics ► Apple Music: http://itunes.apple.com/curator/warner-classics/1153741571 ► Deezer https://www.deezer.com/profile/321050935 Warner Classics is the home of classical music, featuring iconic high audio quality recordings from the greatest classical legends, opera stars and orchestras of the last century. Discover our unique collection of live performances, studio sessions and films featuring Maria Callas, Jacqueline du … | ["Music", "Musical instrument", "Pour", "Violin, fiddle", "Bowed string instrument"] | ["water splashing sound", "violin solo", "instrumental music", "great composers", "conductor", "studio", "fast tempo", "string quartet", "string section", "fast tempo", "bad audio quality", "documentary soundtrack", "documentary video", "melancholic", "passionate", "spirited", "vibrato", "high pitched notes", "violin technique", "western classical music"] | 1 | 0qtbbK5HVMw | 213 | |
OPM Love Songs Medley by Kai Brosas | A female singer sings this beautiful melody. The tempo is medium with a piano or keyboard accompaniment and no other instrumentation. The song is emotional and passionate like a love song. The audio quality is very poor with a lot of hissing noise and distortion. | 2010-10-25T09:07:45Z | chelrada713 | ["Singing", "Bell", "Music"] | ["female singer", "poor audio quality", "hissing noise", "distorted vocals", "pop songs", "pop cover", "song covers", "piano accompaniment", "acoustic love song", "live performance", "club", "romantic", "emotional", "sad song", "passionate", "melancholic", "with you forever", "missing you", "passionate", "bad audio quality", "medium tempo"] | 1 | N8Fg3L1Cc5E | 2323 | ||
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 |
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;