musiccaps_details (view)
3 rows where musiccaps_aspects contains "hi-hat" and musiccaps_author = 2
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- hi-hat · 3 ✖
- kick drum 2
- altered female voice 1
- bass synth 1
- children voices 1
- china cymbal 1
- cowbell 1
- electronic dance music genre 1
- electronic sounds 1
- male backing vocals 1
- male voice 1
- marimba 1
- piano 1
- vinyl scratch 1
- zipper sound 1
musiccaps_names (array) 9 ✖
- Music 3
- Drum and bass 1
- Electronica 1
- Music of Asia 1
- Pop music 1
- Reggae 1
- Techno 1
- Trance music 1
- Zipper (clothing) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
X-In by Blanket Barricade (indie alternative progressive rock song) | The music features a male voice singing a melody while being backed at times by other male vocals. A piano accompanies the singer by playing a combination of chords and melody. For the most part a marimba plays in unison with the singer. In the low register, a synth bass plays long notes. The drummer makes use of only the hi-hat and China cymbal. | 2012-05-02T00:54:29Z | Background Music For Videos / Blanket Barricade (indie rock band & fun upbeat instrumental music) | X-In by Blanket Barricade CHECK ALL OF OUR INDIE ROCK MUSIC VIDEOS: http://www.youtube.com/playlist?list=PLD59463378FD19DEB DOWNLOAD THE SONG On iTUNES: http://bit.ly/itunes-paradebells Or Bandcamp: http://bit.ly/bandcamp-paradebells SUBSCRIBE for more of the band's music and songs! "Like" us on FACEBOOK - http://on.fb.me/vhqKXi "Follow" us on TWITTER - http://bit.ly/tWHkJs Sign up for our uber-awesome mailing list for the latest climactic prog rock from the band: http://eepurl.com/kuqD9 CREDITS: "X-In" From "Parade Bells", released 2012 All music and lyrics written by Wesley Krauss Produced, Arranged and Performed by Wesley Krauss Co-Produced by Michael Wiskar Mixed and Mastered by Kevin Kowal at FaderMaster Studios Dramatic prog rock drums by Ryan Stewart Background Vocals by Mary-Lee Néron Front/back cover art by Catherine Rocheleau Song art by Mary-Lee Néron LYRICS: The dreams we hold freshen up the day Gaining ground while nightmares sleep away No need to cry when life is perfect Don't make a fuss it's just not worth it On and on one day one day No need to cry when life is perfect Don't make a fuss unless you're worth it On and on day by day Once a long while ago I let loose, you took hold Blinded by sights of gold stars in your eyes Can you fill up these hollow sacks spit back the dirty laughs I've got to take a pass all on my own All on my own Music Copyrighted by Blanket Barricade 2016 / 2017. | ["Music", "Reggae"] | ["male voice", "male backing vocals", "piano", "marimba", "bass synth", "hi-hat", "china cymbal"] | 2 | 14hTDUjCr_g | 233 | |
Electronica Music DJ Venom Straight Bangin Vol 4 (2008) | Electronic dance music features a repeating melody played by an electronic sound. The beat of the music is being driven by a kick drum played on every beat, a hi-hat played four times every beat and some sampled claps played on beats two and four. In the background one can hear an altered female voice singing a short melody. Another electronic/synth sound can be heard in the background having sparse interventions. The music is meant to be danced to. | 2008-10-15T05:46:51Z | MariaGarcia281 | DJ Venom rocks the house! Straight Bangin, Vol. 4 Electronica music | ["Drum and bass", "Music of Asia", "Music", "Pop music", "Techno", "Trance music", "Electronica"] | ["electronic sounds", "kick drum", "altered female voice", "hi-hat", "electronic dance music genre"] | 2 | IbaQjxGDT-o | 1923 | |
Sesame Street: Z is for Zipper | The music features a small group of children singing a repeating melody. A kick drum along with a hi-hat drives the pulse of the music. Throughout the music excerpt one can hear zipper sounds, vinyl scratches and other percussive sounds like cowbells. | 2011-05-03T18:31:37Z | Sesame Street | If you're watching videos with your preschooler and would like to do so in a safe, child-friendly environment, please join us at http://www.sesamestreet.org The zipper rap. Sesame Street is a production of Sesame Workshop, a nonprofit educational organization which also produces Pinky Dinky Doo, The Electric Company, and other programs for children around the world. | ["Zipper (clothing)", "Music"] | ["hi-hat", "zipper sound", "kick drum", "vinyl scratch", "children voices", "cowbell"] | 2 | V3Jb0Q_e_pQ | 2970 |
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;