musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "medium tempo", musiccaps_aspects contains "mellow", musiccaps_aspects contains "steady drumming" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) >30 ✖
- medium tempo · 4 ✖
- mellow · 4 ✖
- steady drumming · 4 ✖
- emotional 3
- keyboard harmony 3
- male singer 2
- sentimental 2
- soft 2
- acoustic guitar 1
- alternative rap 1
- amateur recording 1
- amateur singer 1
- auto harp 1
- backup harmony 1
- breakup 1
- breakup song 1
- calming 1
- christian contemporary worship 1
- christian worship song 1
- church 1
- country pop 1
- country song 1
- despondent 1
- devotion 1
- dobro 1
- engaging 1
- female singer 1
- flute melody 1
- folk song 1
- foreign language 1
- …
musiccaps_names (array) 6 ✖
- Music · 4 ✖
- Christian music 2
- Christmas music 1
- Rapping 1
- Reggae 1
- Song 1
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 | |
Thien kong nyit cie jiu ko ho ( Hakka song ) | A male vocalist sings this soft melody. The song is medium tempo, with violin harmony, steady drumming, straight bass lines, acoustic guitar and keyboard accompaniment with vocal backup. The song is in a foreign language. It is slow, and has a mellow, soft, emotional , sentimental and romantic vibe. This is a regional Pop song. | 2007-11-02T14:18:16Z | HakkaNyinXmantan | hakka love song | ["Christmas music", "Music", "Song"] | ["male singer", "medium tempo", "foreign language", "steady drumming", "keyboard harmony", "straight bass lines", "acoustic guitar", "vocal backup", "violin harmony", "violin symphony", "emotional", "sentimental", "mellow", "soft", "reverb", "backup harmony", "karaoke", "amateur recording", "amateur singer", "soft", "mellow", "emotional", "sentimental", "pop"] | 7 | MZhaDGgULtc | 2281 | |
South Central Cartel - It's A S.C.C. Thang ft. The Chi-Lites | A male vocalist sings this groovy R&B. The tempo is medium with a funky bass guitar, steady guitar, bright electric guitar and keyboard harmony. The song is mellow, emotional, soft, smooth and engaging. This song is an R&B. | 2009-11-23T18:52:26Z | SthCentralCartelVEVO | Music video by South Central Cartel performing It's A S.C.C. Thang. (C) 1994 RAL/Def Jam | ["Music", "Rapping", "Reggae"] | ["male singer", "medium tempo", "groovy bass line", "mellow", "smooth", "emotional", "engaging", "steady drumming", "keyboard harmony", "hip-hop", "r&b", "soul", "alternative rap", "rhythmic electric guitar"] | 7 | S7R3NMq3MKk | 2739 | |
~Good As I Was To You~ (With Lyrics) | A female singer sings this sad Country song. The tempo is medium with a Harmonica harmony, steady bass line, acoustic guitar, auto harp and dobro accompaniment. The song is soft, mellow, sad, poignant, emotional, sentimental and despondent with a melodious tune. This Song is a classic Country Pop. | 2008-09-22T07:04:10Z | VampiressSilvia | Lorrie Morgan's Good As I Was To You With the lyrics | ["Christian music", "Music"] | ["female singer", "medium tempo", "country song", "despondent", "melodious tune", "country pop", "regional music", "folk song", "love song", "sad song", "breakup song", "breakup", "harmonica", "steady drumming", "steady bass lines", "auto harp", "dobro", "resonator guitar", "mellow", "lonely", "soft", "sentimental", "emotional"] | 7 | tUJ_ZniLjhc | 5038 |
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;