musiccaps_details (view)
3 rows where musiccaps_aspects contains "dreamy", musiccaps_aspects contains "no vocals" and musiccaps_author = 5
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- dreamy · 3 ✖
- no vocals · 3 ✖
- bass guitar 1
- bright xylophone 1
- cello 1
- chorus electric guitar 1
- guitar effects pedal 1
- instrumental 1
- kids music 1
- lullaby 1
- mellow mellody 1
- mid tempo 1
- nostalgic 1
- psychedelic 1
- quirky 1
- sleepy 1
- slow tempo 1
- subtle strings 1
- sustained piano synth 1
- theremin 1
- wobbly 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jack's Lament - Baby Lullaby Music, by Baby Rockstar (From "The Nightmare Before Christmas") | This is a lullaby that features a main melody made with a xylophone that has a bright sound. A sustained piano synth creates a dreamy and sleepy ambience sound. A subtle cello plays single chords that bounce from one beat to the next. This is a song a baby could fall asleep to. | 2014-01-26T23:31:32Z | Baby Rockstar | Visit the Baby Rockstar Lullaby store at http://www.babyrockstarmusic.com Baby Rockstar arranges popular music as lullabies for your baby and you. These beautiful melodies are played by soothing bells over sleepy tones and light percussive effects. Baby Rockstar is sure to ignite a musical curiosity in your little ones and be a favorite for years to come. Time to get your little rockstars ready for bedtime! | ["Music", "Ambient music"] | ["sustained piano synth", "lullaby", "bright xylophone", "mellow mellody", "bass guitar", "dreamy", "kids music", "slow tempo", "nostalgic", "cello", "no vocals", "sleepy"] | 5 | -QuWdnmn-kM | 44 | |
T.C. Electronic SCF Stereo Chorus, Pitch Modulator & Flanger | The track features an electric guitar with a chorus pedal effect. The guitar alternates between riff to melody. The sound is space-like and almost psychedelic. The atmosphere is sweet and dreamy. | 2014-09-03T03:06:21Z | dadahru | T.C. Electronic SCF Stereo Chorus, Pitch Modulator & Flanger and a little bit of Bearfoot Sparkling Yellow Overdrive 2 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["chorus electric guitar", "guitar effects pedal", "mid tempo", "psychedelic", "no vocals", "dreamy"] | 5 | 4Psyk_xyBl0 | 567 | |
Theremin Cover of "Edelweiss" | The music features no vocals and the main melody is made with a theremin. The sound is wobbly and quirky. In the background there are subtle strings that contrast the main melody by sustaining chords. This is a song you could hear in a movie about aliens. | 2009-02-09T03:31:03Z | Terry Barbre | This is me covering the tune "Edelweiss" from the musical "The Sound of Music." I'm playing the theremin. I'm "hand-syncing" on the video as any theremin player could tell since I'm too close to the computer and furniture. I sequenced all the background parts on my Mac, and then took the best of about 15 takes with the theremin. Cut me some slack. I've been a thereminist for about 48 hours. Once I get better I'll post more videos. | ["Music", "Musical instrument", "Theremin"] | ["instrumental", "no vocals", "theremin", "wobbly", "subtle strings", "quirky", "dreamy"] | 5 | JP637fg_ZC0 | 2001 |
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;