musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "romantic" and musiccaps_names contains "Independent music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- acoustic drums · 4 ✖
- romantic · 4 ✖
- bass guitar 3
- melodic singing 3
- emotional 2
- keyboard 2
- male vocal 2
- piano 2
- strings 2
- 80s feel 1
- acoustic guitar 1
- backing voices 1
- ballad 1
- cheerful 1
- e-bass 1
- electric guitar 1
- female back vocal 1
- female vocal 1
- female voice singing 1
- haunting 1
- hmong pop 1
- japanese pop 1
- medium to uptempo 1
- melancholic 1
- normal tempo 1
- pop 1
- pop music 1
- sentimental 1
- simple tune 1
- slow tempo 1
musiccaps_names (array) 6 ✖
- Independent music · 4 ✖
- Music 4
- Song 2
- Psychedelic rock 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 |
---|---|---|---|---|---|---|---|---|---|---|
Graham Bilbrough of Child singing The Answer To The Everything | This is a pop music ballad piece. There is a male vocal singing melodically in the lead with a female back vocal singing at a higher pitch in the background. The melodic background consists of the strings, the keyboard and the bass guitar. There is a 6/8 slow tempo acoustic drum beat in the rhythmic background. The piece has an emotional atmosphere. This piece could be used in a romantic setting such as a slow dance night event or a wedding. It could also be used in the soundtrack of a romance movie. | 2011-01-23T12:39:23Z | Eleanor Bilbrough | Graham Bilbrough/ Ricky Graham of Child singing The Answer To The Everything | ["Singing", "Music", "Independent music"] | ["pop music", "ballad", "80s feel", "male vocal", "melodic singing", "female back vocal", "strings", "keyboard", "bass guitar", "acoustic drums", "romantic", "emotional", "slow tempo"] | 9 | OpWCljke4oQ | 2473 | |
september rain | This is a Japanese pop music piece. The music has a 70s feel to it. There is a female vocalist singing melodically at the forefront. There is a keyboard playing a melody while being backed by an electric guitar and a bass guitar. There is a simple acoustic drum beat in the rhythmic background. The piece has a melancholic, haunting atmosphere to it. This piece could be used in drama movies and TV series that take place in Japan. | 2007-06-22T14:57:44Z | kklichiang | kugatsu__ame | ["Music", "Independent music"] | ["japanese pop", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "melancholic", "haunting", "romantic"] | 9 | Uxyu3XwXEV8 | 2963 | |
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 | |
wa love songs (ai yawn rai ) | This is a hmong pop music piece. There is a male vocalist singing melodically in the lead. The melody is being played by the piano, the acoustic guitar and the bass guitar. The rhythm is being played on the acoustic drums. There is a sentimental, romantic feel to it. The piece could be used in a romantic movie/TV show with a Hmong-language speaking setting. | 2012-12-06T21:05:00Z | ainapyawn hopang saniex hopang | wa love songs (ai yawn rai) | ["Music", "Independent music", "Song"] | ["hmong pop", "male vocal", "melodic singing", "piano", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "emotional", "romantic", "normal tempo", "simple tune"] | 9 | jhgX0OOoytQ | 4274 |
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;