musiccaps_details (view)
6 rows where musiccaps_aspects contains "cheerful" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- cheerful · 6 ✖
- e-bass 3
- uptempo 3
- acoustic drums 2
- acoustic guitars 2
- amateur recording 2
- background voices 1
- backing vocals 1
- backing voices 1
- bells 1
- bowed string-instrument 1
- cajon 1
- clarinet 1
- country/folkrock 1
- e-guitar 1
- e-piano 1
- female sounding voice singing 1
- female voice singing 1
- male voice cheering 1
- male voice speaking 1
- mandolin 1
- marching band 1
- medium tempo 1
- medium to uptempo 1
- oriental/folkmusic 1
- percussion 1
- percussion's 1
- piano 1
- poor recording quality 1
- pop 1
- rock/pop 1
- romantic 1
- strings 1
- upbeat 1
- upright bass 1
musiccaps_names (array) 20 ✖
- Music 4
- Bluegrass 2
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Bass drum 1
- Blues 1
- Christian music 1
- Drum 1
- Drum roll 1
- Independent music 1
- Percussion 1
- Psychedelic rock 1
- Snare drum 1
- Song 1
- Soul music 1
- Steelpan 1
- Strum 1
youtube_published (date) 6 ✖
- 2006-09-25 1
- 2009-08-24 1
- 2011-06-01 1
- 2012-10-08 1
- 2012-11-27 1
- 2015-11-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Smokin' Guitar at the Super Srecret Bluegrass Jam | This song contains acoustic guitars being strummed fast, a mandolin playing the lead melody in a higher pitch and an upright bass providing an almost walking bassline. This song may be playing in the countryside while having a BBQ. | 2006-09-25T12:58:24Z | arenacom1 | We were playing so fast that my guitar started smoking at the end of the video. | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["amateur recording", "acoustic guitars", "mandolin", "upright bass", "uptempo", "cheerful"] | 6 | 0S5zWt91Bwo | 169 | |
Alaska Thunderfuck - Everyday Is Christmas [Official] from Christmas Queens | An acoustic drum is playing a constant groove along with an e-bass playing the footnote of an e-piano playing a major chord progression. A e-guitar is ending the phrases of the melody in a lower key. In the background you can hear bells playing. A female sounding voice is singing responding to a small choir taking turns singing a melody. This song may be playing during a cheerful event such as Christmas. | 2015-11-17T20:40:55Z | Alaska Thunderfuck | Buy Christmas Queens the full album on iTunes now! https://itunes.apple.com/album/christmas-queens/id1052800436?ls=1&app=itunes Executive Producer - David Charpentier Directed by Paul Alley Producer - Lydia Cartwright Associate Producer - Jessie Lee Pauli Assistant Director - Kushagar Budhwar Director of Photography - Karim Arab Assistant Camera - Nekisa Ghasemi Editor - Paul Alley Gaffer - Anwar Madrimov Grip - Almotaz Aljefri Makeup - Edwin Monzon Production Design by Dusti Cunningham Production Design Help - Andres Mejia Production Assistants - Danielle Rodriguez, Mary Ann Pianka, Tianzo Zhang, Haipeng Jia, Austin Guadayo Son 1: Jake Thompson Son 2: Jeremy Mikush Special Thanks to Nick Somers and Harmony "Spencer" Robertson Label/Management: Producer Entertainment Group david@producerentertainment.com | ["Christian music"] | ["rock/pop", "acoustic drums", "bells", "e-bass", "e-guitar", "female sounding voice singing", "e-piano", "backing vocals", "uptempo", "cheerful"] | 6 | Ny4wnDN4K1U | 2383 | |
VSU vs ECSC PERCUSSION BATTLE 2012 | This recording contains a marching band playing kick sounds, fast snare rolls and cymbal hits. In the background you can hear people talking and cheering. A male voice is speaking as if making an announcement. This may be playing during a cultural event. | 2012-10-08T18:45:27Z | juankiki25 | FOOTAGE BY DELVALLE | ["Drum", "Drum roll", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "marching band", "percussion", "male voice speaking", "background voices", "medium tempo", "cheerful"] | 6 | Qy77eJc72UQ | 2652 | |
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 | |
Roundstone summer Festival 09 - Micky Martin and friends... traditional irish music | This song is recorded in poor quality. Two acoustic guitars are playing. One of them is strumming chords while the other is playing a country solo up and down the fretboard. A cajon player is supported with mostly kick sounds. This song may be played at an Irish bar. | 2009-08-24T01:49:16Z | Alberto Graziotto | A great perform!!!! | ["Blues", "Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["country/folkrock", "acoustic guitars", "cajon", "male voice cheering", "uptempo", "cheerful", "poor recording quality"] | 6 | WhX3jQxHZWc | 3127 | |
İsmail Lumonowski Klarnet Şov | Percussions are playing together with a clarinet that takes the lead melody with very long notes. A bowed instrument is playing along with little fill-ins. An electric bass is playing a rather funky groove. The whole song sounds like it was made for dancing joyfully. | 2012-11-27T07:27:57Z | ufuk on7 | http://www.facebook.com/KORUOBAKOYU | ["Music", "Steelpan"] | ["oriental/folkmusic", "clarinet", "percussion's", "e-bass", "bowed string-instrument", "upbeat", "cheerful"] | 6 | sH_nDqYVq5E | 4937 |
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;