musiccaps_details (view)
5 rows where musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "soothing", musiccaps_aspects contains "steady drumming", musiccaps_author = 7 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
chris tomlin amazing love | A male vocalist sings this soft Christian Worship song. The tempo is medium with a keyboard accompaniment, steady drumming, flute melody, subtle bass line; rhythmic acoustic guitar and soft vocals. The song is a melodious, soothing, prayerful, calm ,contemporary Christian Praise and Worship song. | 2008-09-19T16:22:10Z | floydss1 | worship for you | ["Christian music", "Music"] | ["male vocalist", "medium tempo", "keyboard harmony", "calming", "soothing", "reverence", "devotion", "gratitude", "love", "honour", "steady drumming", "subtle bass line", "flute melody", "mellow", "soft vocals", "praise and worship", "christian worship song", "hymn", "christian contemporary worship", "church", "sunday worship", "rhythmic acoustic guitar"] | 7 | EwoCbcSXlSM | 1601 | |
Music Maker 2008 Chillout & Ambient 2 Songs | This song is an instrumental. The tempo is medium with a melodious keyboard harmony, rhythmic guitar accompaniment, punchy drumming, subtle bass line, synth arrangement and tambourine beats. The music is soft, mellow, ambient, pleasant, uplifting, and mellifluous. | 2008-03-10T18:25:25Z | Jonas Bayerlein | magix music maker 2008 | ["Music", "Tender music"] | ["instrumental", "medium tempo", "steady drumming", "acoustic guitar", "keyboard harmony", "soft bass", "digital drum", "cymbals", "ambient", "elctronic music", "tambourine beats", "melodious", "soft", "calming", "soothing", "mood", "atmospheric", "ethereal", "enigmatic", "punchy beat"] | 7 | P240GHf9Eq4 | 2494 | |
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 | |
Richard Burton... pedal steel guitar... last date | This music is a Country song instrumental. The tempo is medium with a pedal steel guitar lead harmony with steady drumming and keyboard accompaniment. The music is a simple,minimalist, sweet, dulcet, sentimental, nostalgic, soothing, pleasant and mellifluous , classic Country music instrumental. | 2011-02-03T00:25:39Z | Bob Adams | Richard's rendition of Floyd Cramer's 'Last Date' A sweet sound from that ZB Richard! | ["Blues", "Music", "Steel guitar, slide guitar"] | ["instrumental", "medium tempo", "keyboard accompaniment", "minimalist", "dulcet", "auto harp", "steel guitar", "pedal steel guitar", "steady drumming", "country song", "country song instrumental", "country instrument", "bluegrass", "regional music", "folk music", "pleasant", "nostalgic", "sentimental", "soothing", "mellifluous"] | 7 | qVT6GX1KHUY | 4788 |
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;