musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "auto harp" and musiccaps_aspects contains "regional music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 84 ✖
- auto harp · 5 ✖
- regional music · 5 ✖
- sentimental 4
- banjo 3
- country music 3
- country pop 3
- fast tempo 3
- female singer 3
- fiddle 3
- country song 2
- dobro 2
- emotional 2
- enthusiastic 2
- folk music 2
- love song 2
- mandolin 2
- medium tempo 2
- resonator 2
- steady drumming 2
- acoustic guitar 1
- animated 1
- bluegrass 1
- breakup 1
- breakup song 1
- catchy 1
- catchy melody 1
- cello 1
- cheerful 1
- concert 1
- country folk music 1
- country hits 1
- country instrument 1
- country side 1
- country song instrumental 1
- cowboys 1
- despondent 1
- dog barking sound 1
- dulcet 1
- emphatic vocals 1
- enthusiastic drumming 1
- folk song 1
- fun 1
- girl singing 1
- happy 1
- harmonica 1
- high energy 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- live audience 1
- live performance 1
- lively backup 1
- lively vocals 1
- lonely 1
- male vocalist 1
- march like beat 1
- mellifluous 1
- mellow 1
- melodious tune 1
- merry 1
- minimalist 1
- nostalgic 1
- pedal steel guitar 1
- pensive 1
- people clapping 1
- peppy 1
- pleasant 1
- powerful vocals 1
- powerfully voice 1
- reflective lyrics 1
- resonator guitar 1
- sad song 1
- soft 1
- soothing 1
- spirited 1
- steady bass lines 1
- steel guitar 1
- story telling 1
- tambourine beats 1
- vibrant 1
- vocal emphasis 1
- vocalisation 1
- young vocalist 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 5
- Song 2
- Banjo 1
- Bluegrass 1
- Blues 1
- Christian music 1
- Country 1
- Happy music 1
- Musical instrument 1
- Steel guitar, slide guitar 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cutie girl singing (11 years old) | A young female vocalist sings this upbeat country song. The tempo is fast with keyboard harmony,enthusiastic drumming , rhythmic accompaniment of acoustic guitar, mandolin, fiddle, resonator, auto harp and dobro and tambourine beats. The song is fresh, youthful, energetic, vivacious, catchy, upbeat, simple and peppy. This song is Country Pop. | 2006-07-16T08:08:14Z | Trofimo | El origen de la Humanidad (la infancia) puede descubrirnos el origen de la música... | ["Yodeling", "Music", "Song"] | ["female singer", "fast tempo", "girl singing", "young vocalist", "peppy", "enthusiastic", "auto harp", "folk music", "regional music", "country side", "cowboys", "catchy", "country music", "country pop", "march like beat", "powerfully voice", "people clapping", "enthusiastic drumming", "fiddle", "mandolin", "resonator", "banjo", "tambourine beats", "youthful", "happy", "sentimental", "story telling", "powerful vocals", "vocal emphasis", "keyboard harmony", "spirited", "vibrant"] | 7 | hdlnugbWjKA | 4122 | |
You feel the same way too The Rankin family Lyrics | A female vocalist sings this sweet Country song. The music is fast with lively banjo, mandolin, acoustic guitar , dobro and Auto harp harmony, steady bass and rhythmic drumming . The song is emotional, sentimental, pensive, reflective, with a catchy beat. This song is classic Country Pop. | 2012-03-15T01:17:59Z | Kristi Nickerson | I loved this song when i was little! its a great song! **I do not own the music or lyrics in this song** | ["Music", "Happy music"] | ["female singer", "fast tempo", "country music", "emotional", "sentimental", "reflective lyrics", "pensive", "catchy melody", "emphatic vocals", "auto harp", "dog barking sound", "banjo", "mandolin", "fiddle", "love song", "country pop", "country hits", "regional music", "dobro", "resonator"] | 7 | qDSvHlHbAqM | 4764 | |
The Seldom Scene - After Midnight | A male vocalist sings this high energy Country Song. The tempo is fast with animated Banjo, fiddle, auto harp, acoustic guitar and cello. The song is cheerful, happy, enthusiastic, fervent, pulsating, buoyant and animated with vocalising and backup. This song is a spirited Country Folk Song. | 2008-01-14T14:52:51Z | BluegrassLibrary | John Duffey, Ben Eldridge, Mike Auldridge, Phil Rosenthal, & Tom Gray | ["Banjo", "Country", "Music", "Musical instrument", "Song", "Bluegrass"] | ["male vocalist", "fast tempo", "country music", "lively vocals", "lively backup", "banjo", "cello", "auto harp", "fiddle", "acoustic guitar", "country music", "country folk music", "vocalisation", "high energy", "fun", "merry", "cheerful", "live performance", "concert", "live audience", "enthusiastic", "animated", "regional music"] | 7 | q-sJu8CoZts | 4750 | |
~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 | |
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;