musiccaps_details (view)
3 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "medium fast tempo" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- male singer · 3 ✖
- medium fast tempo · 3 ✖
- sentimental 2
- acoustic guitar 1
- animated piano 1
- animated singing 1
- banjo 1
- bells 1
- beseeching 1
- celebration 1
- children’s favourite christmas song 1
- children’s song 1
- choral harmony 1
- christmas carols 1
- christmas songs 1
- christmas tree 1
- country music 1
- country pop 1
- country song 1
- country songs 1
- emotional 1
- emphatic vocals 1
- energetic acoustic guitar 1
- festivities 1
- fiddle 1
- fun 1
- groovy bass line 1
- jealous 1
- keyboard accompaniment 1
- lively piano accompaniment 1
- love song 1
- mandolin 1
- melodic 1
- merry 1
- nostalgia 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- passionate 1
- peppy 1
- perky 1
- pleading 1
- prayer 1
- presents 1
- regional music 1
- reindeer 1
- request 1
- resonator 1
- rhythmic acoustic guitar 1
- rhythmic drumming 1
- romantic 1
- santa claus 1
- snow 1
- soft 1
- spirited spanish guitar 1
- spirited string arrangement 1
- steady bass 1
- steady bass line 1
- steady drumming 1
- story telling 1
- string symphony 1
- tambourine beats 1
- vibrant ukelele harmony 1
- violin 1
- vocal backup 1
musiccaps_names (array) 7 ✖
- Music 3
- Christian music 1
- Christmas music 1
- Roll 1
- Singing 1
- Song 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 | |
Jingle Bell Rock - Hall & Oates | A vocalist sings this cheerful Christmas carol. The tempo is medium with an animated piano accompaniment, steady drumming, cymbals, tambourine beats, steady bass line and rhythmic acoustic guitar and melodic backup vocals;. The song is happy, fun, festive, celebratory, wishful, peppy and nostalgic. This song is a Christmas Carol. | 2010-11-26T02:57:05Z | R2197 | "Jingle Bell Rock" cover by Daryl Hall and John Oates. I do not own this music. No copyright infringement intended. For entertainment purposes only. Courtesy of Daryl Hall and John Oates. From the updated 2006 album "Home for Christmas". Enjoy. Lyrics: Jingle bell, jingle bell, jingle bell rock Jingle bells swing and jingle bells ring Snowin' and blowin' up bushels of fun Now the jingle hop has begun Jingle bell, jingle bell, jingle bell rock Jingle bells chime in jingle bell time Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell rock Jingle bell, jingle bell, jingle bell rock (repeat verse1's Jingle bells chime in jingle bell time last 4 lines) Dancin' and prancin' in Jingle Bell Square In the frosty air What a bright time, it's the right time To rock the night away Jingle bell time is a swell time To go glidin' in a one-horse sleigh Giddy-up jingle horse, pick up your feet Jingle around the clock Mix and a-mingle in the jinglin' feet That's the jingle bell That's the jingle bell That's the jingle bell rock! | ["Christmas music", "Christian music", "Music", "Song"] | ["male singer", "medium fast tempo", "animated piano", "vocal backup", "bells", "tambourine beats", "steady drumming", "steady bass line", "choral harmony", "rhythmic acoustic guitar", "christmas songs", "christmas carols", "children’s song", "children’s favourite christmas song", "santa claus", "christmas tree", "presents", "snow", "reindeer", "fun", "celebration", "festivities", "merry", "perky", "peppy", "nostalgia"] | 7 | ZUcHBeueBww | 3382 |
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;