musiccaps_details (view)
3 rows where musiccaps_aspects contains "rhythmic acoustic guitar", musiccaps_aspects contains "vocal backup" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- rhythmic acoustic guitar · 3 ✖
- vocal backup · 3 ✖
- male vocalist 2
- animated piano 1
- bells 1
- bright 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
- classic pop 1
- dance music 1
- elcetric guitar lead 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- festivities 1
- fun 1
- groovy bass line 1
- inferior audio quality 1
- insightful 1
- intense electric guitar 1
- jarring 1
- keyboard harmony 1
- loud 1
- male singer 1
- medium fast tempo 1
- melancholic 1
- mellow 1
- melodious 1
- merry 1
- nostalgia 1
- nostalgic 1
- pensive 1
- people cheering 1
- people talking 1
- peppy 1
- perky 1
- pop 1
- pop hits 1
- pop rock 1
- presents 1
- punchy drumming 1
- reindeer 1
- retro 1
- rock 1
- rock and roll 1
- sad 1
- santa claus 1
- slow tempo 1
- snow 1
- soft 1
- soft bass line 1
- static 1
- steady bass line 1
- steady drumming 1
- tambourine beats 1
- vigorous vivacious 1
musiccaps_names (array) 10 ✖
- Music 3
- Song 2
- Christian music 1
- Christmas music 1
- Inside, large room or hall 1
- Musical instrument 1
- Rock music 1
- Roll 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Simon and Garfunkel - The Sounds of Silence (1A) | A male vocalist sings this retro classic melody. The tempo is slow with a melodious electric guitar lead, soft acoustic guitar accompaniment and subtle bass complimenting the soft vocals and backup. The song is mellow, melancholic, pensive, insightful, euphonious, dulcet and soothing. There is a sound of static in the background. This song is classic Rock. | 2010-02-19T07:53:08Z | TheStaticAirwaves | Sounds of Silence is an album by Simon and Garfunkel, released on January 17, 1966. The album's title is a slight modification of the title of the duo's first major hit, "The Sounds of Silence", which was released previously on the album Wednesday Morning, 3 A.M., and also on the soundtrack to the movie The Graduate. It was taken from their debut and electric instruments and drums were overdubbed by Bob Dylan's studio band on June 15, 1965 and released in September 1965 as a single. "Homeward Bound" was released on the album in the UK. It was also released as part of the box set Simon & Garfunkel Collected Works, on both LP and CD. | ["Music", "Song", "Soul music"] | ["male vocalist", "slow tempo", "static", "vocal backup", "insightful", "mellow", "melodious", "soft", "melancholic", "pensive", "sad", "nostalgic", "retro", "elcetric guitar lead", "rhythmic acoustic guitar", "classic pop", "pop hits", "soft bass line"] | 7 | 11FeId69WOk | 230 | |
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
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;