musiccaps_details (view)
2 rows where musiccaps_aspects contains "in love with you" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- in love with you · 2 ✖
- romantic 2
- advertisement soundtrack 1
- backup singers 1
- beach party 1
- beautiful landscapes 1
- celtic music 1
- classical guitar hits 1
- comforting 1
- dance club 1
- dance floor 1
- dancing with you 1
- dj 1
- emotional 1
- emotional music 1
- energetic 1
- fast tempo 1
- female singer 1
- fret noises 1
- groovy 1
- groovy drumming rhythm 1
- guitar solo 1
- harmony 1
- instrumental hits 1
- instrumental music 1
- keyboard accompaniment poor audio quality 1
- life is beautiful 1
- melancholic 1
- party night 1
- percussion hits 1
- percussive bass line 1
- pleasant 1
- pop dance hit 1
- pop song 1
- relaxing 1
- soloist 1
- spanish guitar 1
- spirited 1
- the good life 1
- together always 1
- twilight 1
- vocal harmony 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 | |
รถบัส&เพลงแดนซ์ แอบจิตMIX(นฤมิตร)VOL.4 | A female singer sang this pop melody with female backup singers in vocal harmony. The song is fast tempo with various percussion instruments, but with a steady drumming rhythm, percussive bass line, guitar rhythm and keyboard accompaniment . The song is youthful and a party dance song. The song's audio quality is poor. | 2012-01-03T04:10:05Z | makrochai | Bus Thailand And Dance Remix ดีเจอ๊อฟ คนเก่า(แต่ไม่แก่) จัดหั้ย.ย.ย | ["Electronic music", "Music", "Electronic dance music", "Dance music"] | ["female singer", "advertisement soundtrack", "fast tempo", "romantic", "in love with you", "dancing with you", "together always", "backup singers", "vocal harmony", "pop song", "pop dance hit", "percussive bass line", "groovy drumming rhythm", "percussion hits", "party night", "dj", "dance club", "dance floor", "spirited", "energetic", "beach party", "keyboard accompaniment poor audio quality"] | 1 | OEjgIDubFbg | 2415 |
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;