musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "cheerful" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- cheerful · 3 ✖
- pop · 3 ✖
- fast tempo 2
- acoustic drums 1
- animated voices 1
- auto harp 1
- backing voices 1
- breezy 1
- bright 1
- buoyant 1
- catchy 1
- cello 1
- child playing 1
- child’s voice 1
- colourful 1
- duet 1
- e-bass 1
- electric guitar 1
- energetic 1
- enthusiastic 1
- female voice singing 1
- folk 1
- foreign language 1
- fun 1
- galloping rhythm 1
- groovy bass lines 1
- high-spirited 1
- infectious 1
- infectious drumming 1
- instrumental 1
- intense 1
- keyboard harmony 1
- medium to uptempo 1
- piano 1
- playful 1
- poor audio quality 1
- regional music 1
- rhythmic acoustic guitar 1
- romantic 1
- simple melody 1
- spirited 1
- static 1
- strings 1
- ukrainian song 1
- upbeat 1
- viola 1
- violins 1
- vocalisation 1
musiccaps_names (array) 12 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Independent music 1
- Jazz 1
- Pizzicato 1
- Psychedelic rock 1
- Rhythm and blues 1
- Song 1
- Soul music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Українська Весільна Музика 9 (Ukrainian Wedding Music 9) | This song is a lively Ukrainian duet. The tempo is fast and upbeat with a bright keyboard harmony, infectious drumming , groovy bass line and rhythmic acoustic guitar. The music is energetic, enthusiastic, lively, high-spirited , cheerful, happy, warm, buoyant and catchy with a simple melody. This song is a Ukrainian Pop song. | 2009-11-29T18:52:15Z | UAWaveofMusic | Українська Весільна Музика!!!!! ENJOY AND PLEASE SUBSCRIBE!!!!!! | ["Jazz", "Music", "Wedding music", "Rhythm and blues"] | ["duet", "fast tempo", "upbeat", "ukrainian song", "spirited", "enthusiastic", "energetic", "buoyant", "bright", "colourful", "catchy", "simple melody", "cheerful", "high-spirited", "pop", "foreign language", "infectious", "folk", "regional music", "keyboard harmony", "groovy bass lines", "infectious drumming", "galloping rhythm", "rhythmic acoustic guitar"] | 7 | 0ADP-O_V3vA | 129 | |
Neil Sedaka - Laughter In The Rain [w/ lyrics] | An acoustic drum is played along with a bassline, an acoustic guitar and piano all playing the same rhythm. Strings are playing a melody in the mid range along with the female singer that gets accompanied by backing vocals singing harmonies along. This song sounds romantic and cheerful. This song may be playing at the beginning scene of a rom-com movie. | 2011-06-01T19:40:57Z | cyberman000051 | "Laughter in the Rain" is a song recorded by Neil Sedaka, composed by him with lyrics by Phil Cody. It includes a 20-second saxophone solo by Jim Horn.[1] Cody reports writing the lyrics in about five minutes after smoking marijuana and falling asleep under a tree for a couple of hours. In the USA, "Laughter in the Rain" reached number one on the Billboard Hot 100 on February 1, 1975 (it was his first single to top the Hot 100 since 1962).[3] The song spent two weeks at the top of the adult contemporary chart. The song was likewise a major hit in Canada, reaching number two on the pop singles chart and number one on the Adult Contemporary chart. The song was also released in the UK where it spent nine weeks on the Singles Chart, peaking at No. 15 on June 22, 1974 | ["Music", "Independent music", "Psychedelic rock", "Song", "Soul music"] | ["pop", "strings", "acoustic drums", "piano", "e-bass", "acoustic drums", "female voice singing", "backing voices", "medium to uptempo", "romantic", "cheerful"] | 6 | VCusyLPrFCo | 2984 | |
Snoopy & Woodstock 3 | This music is an animated instrumental. The tempo is fast with a lively cello bass line , viola and violin harmony with a lead strung instrument which is either an Auto Harp or electric guitar. There is a child’s voice superimposed on the music with incoherent words and a lot of static. The music is lively, intense,playful, fun, cheerful, animated and breezy. This music is an animated Pop. | 2007-02-19T00:19:07Z | HITMANIV | Snoopy and Woodstock get their roll on | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "fast tempo", "animated voices", "cello", "pop", "fun", "breezy", "child playing", "auto harp", "static", "poor audio quality", "electric guitar", "violins", "auto harp", "viola", "intense", "playful", "child’s voice", "vocalisation", "cheerful"] | 7 | sUh43prJYMM | 4954 |
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;