musiccaps_details (view)
4 rows where musiccaps_aspects contains "sombre" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- sombre · 4 ✖
- accordions 1
- alternative rock 1
- classical music 1
- electric guitar arpeggio 1
- emotional 1
- instrumental 1
- intricate piano motifs 1
- italian singing 1
- live performance 1
- low quality audio 1
- mysterious 1
- piano 1
- piano melody 1
- romantic 1
- sad music 1
- sad piano music 1
- slow music 1
- violin 1
- whispering 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funny kitty video watch it now! | This song is an alternative rock song which features a male vocalist whispering the lyrics. The guitarist plays arpeggios of the chords while there is a screeching distorted sound in the background. | 2007-09-15T06:27:02Z | Dashron10 | Just letting everyone know i am thinking about making a new vid.. for everyone who said "maaybe you should have picked a shorter song, i decided this time i am going to take the time and individually download pics and place them into the video then delete them making room for more, I believe this time i am going to use Metallica. You got a problem with that keep it to yourself... | ["Psychedelic rock", "Rock music"] | ["alternative rock", "whispering", "electric guitar arpeggio", "sombre", "mysterious"] | 3 | 5CtvEcPtknI | 642 | |
16 VELHA TAPERA CAIDA HONEYDE BERTUSSI | This is a live recording of an italian song that is primarily played on the accordions. We have a male vocalist with a mature voice, who sings in a tone that feels a little bit sombre. The music itself has a romantic feeling to it. | 2014-10-01T20:27:49Z | LFV1113 | ["Accordion"] | ["live performance", "accordions", "italian singing", "low quality audio", "romantic", "sombre"] | 3 | hbqdthlv6CU | 4121 | ||
PLAYLIST Classical Instrumental Music for Weddings, Romance, Picnics. | This song is a classical music instrumental. The two main instruments it features are piano and violin - the piano plays arpeggiated chords while the violin plays legato notes. The song has a sombre and emotional tone to it. | 2014-05-02T01:15:31Z | Soundings of the Planet | Here is a half hour of Classical Instrumental Music for Weddings, Romance, Picnics. Hope you enjoy it :) Please like and subscribe, thank you!! music available at www.soundings.com For more information, please visit soundings.com Follow us at: Facebook: https://www.facebook.com/SoundingsofthePlanet/ Twitter: https://twitter.com/SoundingsPlanet Instagram: (Dean Evenson) https://www.instagram.com/deanevensonmusic/ Instagram: https://www.instagram.com/soundingsoftheplanet/ My YouTube channel: https://www.youtube.com/user/SoundingsofthePlanet For Free Music: http://soundings.com/newsletter-subscription-confirmation/ | ["Cello", "Double bass", "Bowed string instrument"] | ["violin", "slow music", "sad music", "piano", "classical music", "instrumental", "sombre"] | 3 | s_LMd1_XN1w | 4964 | |
Sad Sailor moon Background Music | This is a sad, emotional piano song. Initially, we hear the low pitch and high pitch notes played in unison. The low notes then serve as a bass backing for the treble. The song would suit a sad scene in a movie. | 2007-11-22T22:05:00Z | cuteyhony | beautyful Background music of Sailor moon (wunderschöne und dramatische hintergrundmusik) | ["Music", "Sad music"] | ["sad piano music", "piano melody", "sombre", "emotional", "intricate piano motifs"] | 3 | tOnjlUzqSC4 | 5032 |
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;