musiccaps_details (view)
2 rows where musiccaps_aspects contains "harmony" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- harmony · 2 ✖
- instrumental music 2
- average audio quality 1
- banjo band 1
- banjo players 1
- banjo playing demonstration 1
- beautiful landscapes 1
- celtic music 1
- classical guitar hits 1
- classical music 1
- clean tones 1
- comforting 1
- emotional 1
- emotional music 1
- folk music 1
- fret noises 1
- groovy 1
- guitar solo 1
- home video recording 1
- in love with you 1
- instrumental duet 1
- instrumental hits 1
- life is beautiful 1
- medium tempo 1
- melancholic 1
- music practice 1
- mysterious 1
- no other instrumentation 1
- no percussion instruments 1
- pleasant 1
- powerful 1
- relaxing 1
- romantic 1
- soloist 1
- spanish guitar 1
- strong tones 1
- the good life 1
- twilight 1
- youthful 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sad Classical Guitar Music - Lost Melody | The song is an instrumental. The song is in medium tempo with a classical guitar playing a lilting melody in accompaniment style. The song is emotional and romantic. The song is a romantic instrumental song. | 2013-10-16T02:38:43Z | Graham Daniel McLaughlin | Instruments used: Acoustic Guitar (Classical), Violin Soundcloud: https://soundcloud.com/graham-daniel-mclaughlin/sad-classical-guitar-music (Free Download) Spotify: https://open.spotify.com/track/5KceXwi3K9TiRaw6JCbB0I Apple Music: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762 iTunes: https://music.apple.com/us/album/lost-melody/1457733757?i=1457733762&app=itunes Amazon Music: https://music.amazon.com/albums/B07Q2KSY5S?trackAsin=B07Q2KF8RW&ref=dm_sh_b07e-7fb5-dmcp-49ae-e76f6&musicTerritory=US&marketplaceId=ATVPDKIKX0DER Facebook: https://www.facebook.com/DreamsOfGraham Guitar Tabs: https://docs.google.com/document/d/14OOCK3J1SYLxRuwKfnAvQcS70mbRWrJ6eQuIY5Bf20E/edit?usp=sharing ______________________________ Made this song today, just thinking about schooling and all what's expected of people to be part of a society. Sometimes I just can't live up to the robotic terms, and I may end up creating stuff like this. ______________________________ All audio material owned by © Graham Daniel McLaughlin ℗ Graham Daniel McLaughlin Song inspired by this artwork: http://reyed33.deviantart.com/art/1-Lost-Melody-207902132 The artist of the picture used is unknown, I really wish I could give them credit and a thanks. I downloaded it from nik.bot.nu. | ["Music", "Sad music"] | ["spanish guitar", "guitar solo", "soloist", "emotional music", "beautiful landscapes", "twilight", "pleasant", "the good life", "instrumental hits", "celtic music", "classical guitar hits", "harmony", "instrumental music", "fret noises", "emotional", "relaxing", "in love with you", "melancholic", "life is beautiful", "comforting", "romantic", "groovy"] | 1 | KHjEIheD-Cg | 2072 | |
Dueling Banjos - Sleepy Man Banjo Boys - Revenge of the Guitar | Two banjo players trade solos in this instrumental song. The song is medium tempo with banjos playing in a call and response manner and no other instrumentation. The song is energetic and has a middle eastern classical music vibe. The audio quality is average and recorded at Jo e. | 2012-03-13T03:15:13Z | Sleepy Man | Become a fan! https://sleepyman.com/fanclub The boys practice a version of Eric Weissberg's "Dueling Banjos" in the Bedroom - Sleepy Man Banjo Boys - 9 Year old Jonny Mizzone (banjo) and his brothers Robbie Mizzone, 13 (fiddle), and Tommy Mizzone,14 (guitar). | ["Banjo", "Music", "Strum"] | ["banjo players", "instrumental duet", "average audio quality", "harmony", "home video recording", "banjo band", "youthful", "classical music", "clean tones", "mysterious", "folk music", "instrumental music", "medium tempo", "banjo playing demonstration", "no percussion instruments", "powerful", "strong tones", "music practice", "no other instrumentation"] | 1 | RFbWkL818XQ | 2685 |
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;