musiccaps_details (view)
4 rows where musiccaps_aspects contains "dreamy" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- dreamy · 4 ✖
- piano · 4 ✖
- acoustic guitar 1
- acoustic jazz drums 1
- ballad 1
- cheerful 1
- complex 1
- cymbal 1
- dramatic 1
- e-bass 1
- electronic/meditation 1
- female vocal 1
- female voice sample 1
- flute 1
- gibberish singing 1
- jazz 1
- keyboard 1
- live performance 1
- male vocal 1
- medium tempo 1
- medium to uptempo 1
- medium-to-high pitch singing 1
- orchestra 1
- peaceful 1
- rock opera 1
- sentimental 1
- strings 1
- synth bass 1
- upright bass 1
- vibraphone 1
- video game theme 1
- xylophone 1
musiccaps_names (array) 9 ✖
- Music 4
- Background music 1
- Music of Asia 1
- New-age music 1
- Roll 1
- Sad music 1
- Singing 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
메이플스토리 BGM - 시간의신전(Temple of time) | This song contains a cymbal holding the rhythm while different piano and keyboards are playing melodies. A xylophone is playing a melody in a higher pitch on top of that. A female voice choir sample comes in every year and then being part of the rhythmic composition. This song may be playing in a adventure video-game with beautiful landscapes. | 2014-08-01T03:44:09Z | yeon H | 원하신 브금을 댓글창에 적어주시면 업로드 해드립니다. | ["Background music", "Music", "Tender music"] | ["ballad", "piano", "keyboard", "cymbal", "female voice sample", "xylophone", "medium tempo", "dreamy", "peaceful"] | 6 | BdhaR2QUGqY | 1269 | |
Katamari Roll (you up into my life) | This is a video game theme in the style of jazz music. There is a male vocalist singing gibberish while imitating a brass instrument. The vibraphone is playing the main melody. There is a piano playing chords in a syncopated manner. The bass guitar is playing a groovy bass line. The rhythmic background consists of an acoustic jazz drum beat. The atmosphere is dreamy and cheerful. This piece could be playing in the soundtrack of an animation movie during a dream sequence. | 2008-11-26T21:49:26Z | leftofftheark | I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, to you Im so in love with you I want to wad you up into my life Lets roll up to be a single star in the sky I need you to feel me I want to wad you up into my life Lets lump up to make a single star in the sky To you I know you love me I want to wad you up into my life Lets roll up to be a single star in the sky I hear you calling me I want to wad you up into my life Lets lump up to make a single star in the sky To you, oh to you Yes to you | ["Music", "Roll", "Soul music"] | ["video game theme", "jazz", "male vocal", "gibberish singing", "vibraphone", "piano", "upright bass", "acoustic jazz drums", "dreamy", "complex", "cheerful"] | 9 | Mv90uA0tmgc | 2307 | |
Dave Darrell - Children | This piece contains a lot of reverb and the instruments are using delay to create long arpeggio landscapes and rhythms. An acoustic guitar is being picked creating an arpeggio melody. A piano is playing a countermelody with a lot of reverb. A synth bassline playing one note in a 8th note rhythm is holding the ground of this composition. This song may be playing while dancing alone in your room. | 2008-09-13T15:02:12Z | a6n1a9 | Dave Darrell(or Darell, I don't know) - Children This video is dedicated to my bloody best friend! I wanna thank her for everything! I Love You Dick! =D ----------------------------- | ["New-age music", "Music"] | ["electronic/meditation", "acoustic guitar", "e-bass", "piano", "synth bass", "dreamy", "medium to uptempo"] | 6 | UeYmnV-B8so | 2931 | |
The Sound of Music - Musical-sing-a-long (repetitie) | This is a rock opera piece that is being sung by a female vocalist in a medium-to-high pitch range. There is an orchestra playing the melody in the background composed of strings, flute and a piano. The atmosphere of the piece is dreamy and sentimental. It could be used in the soundtrack of a fairytale movie. | 2014-09-01T19:54:18Z | Kindermuziek | De cast van The Sound of Music maakt haar opwachting tijdens de Musical-sing-a-long tijdens de Uitmarkt 2014 op het Museumplein in Amsterdam | ["Singing", "Music of Asia", "Music", "Sad music"] | ["rock opera", "live performance", "female vocal", "medium-to-high pitch singing", "orchestra", "strings", "flute", "piano", "dreamy", "sentimental", "dramatic"] | 9 | fZjQBgPD1Ys | 3960 |
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;