musiccaps_details (view)

5 rows where musiccaps_author = 2 and musiccaps_names contains "Happy music"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: musiccaps_names, youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
[NEW] All SNSD Music Videos 2007-2014 (OFFICIAL) The pop music features a female voice singing and being accompanied by other female voices. The drums and bass guitar play a simple and repetitive groove and drive the pulsation of the music. An electric guitar is playing a funky accompaniment. A group of strings play a repetitive melody that ascends in pitch with each repetition. 2014-12-07T18:59:58Z soshistars This is all the Music Videos SNSD has made from 2007 to 2014! Lets hope they make more in the future! Thanks for watching please like, comment, share & SUBSCRIBE! (if you havent already!) New Videos Every week of Kpop girl groups (especially SNSD) and SM boy groups! ["Music", "Dance music", "Happy music"] ["female voice", "female backing vocals", "drums", "bass guitar", "strings", "electric guitar", "pop genreș"] 2 32C6w8V7TX8 435
Hengameh - Khalkoobi The music features a female voice singing an ascending melody. The rhythm section consists of a bass guitar, a pair of congas and a ride cymbal. An electric piano accompanies the singer with chords. In the background an electric guitar plays an accompaniment that combines melody and chords. Right at the end of the music excerpt a China cymbal can be heard. 2011-06-01T21:33:00Z shan5400 ["Music", "Happy music"] ["female voice", "electric guitar", "congas", "ride cymbal", "china cymbal", "bass guitar", "electric piano"] 2 6N1LWG4aztA 748
Laura Veirs - Galaxies (Video) The music features a female voice singing a long note melody for the first half of the excerpt. The drums play a steady rhythm and together with the bass guitar and tambourine drive the pulse of the music. A synth sound is playing a wobbly melody. 2009-10-27T01:54:06Z Warner Records Vault © 2006 WMG Galaxies (Video) ["Music", "Happy music"] ["female voice", "drums", "tambourine", "bass guitar", "synth sounds", "electric guitar"] 2 PE1ges9nn6A 2518
Sesame Street: Preview: Singing With The Stars DVD The music features a male voice singing and being accompanied by backing vocals. The drums play a laid-back rhythm and together with the bass guitar drive the pulse of the music. An acoustic guitar is accompanying the singer lightly. In the background one can hear birds chirping and children having fun. The overall atmosphere is uplifting. 2012-04-24T22:13:13Z Sesame Street Enjoy this preview of the all new Singing With The Stars DVD. This DVD includes special guest appearances by Adam Sandler, REM, Destiny's Child, Jason Mraz, Feist and so many more! DVD Available 5/1/2012. Available in the official Sesame Street Store http://store.sesamestreet.org/Product.aspx?cp=21415_21456_21463&pc=6EAM1251 For more fun games and videos for your preschooler in a safe, child-friendly environment, visit us at http://www.sesamestreet.org 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. ["Music", "Happy music"] ["male voice", "backing vocals", "drums", "bass guitar", "acoustic guitar", "uplifting atmosphere", "bird chirping", "children having fun"] 2 Vr7wbGcvFts 3035
I Can Hear the Bells The music features a female voice that sings in a theatrical style, similar to Broadway musicals. The bass guitar and drums blend together and play a light accompaniment. A piano can also be heard contributing to the overall accompaniment. A string section plays a long note melody that transitions into playing in unison with the singer's melody. 2011-01-05T13:59:15Z Hairsprayhome "I Can Hear the Bells" - Nikki Blonsky From the movie "Hairspray" from 2007 See the other songs from the movie at my chanel Pleas note: I OWNS NO RIGHTS FOR THE PICTURS OR THE SOUNDTRACK OF THE VIDEO! ["Music", "Happy music"] ["theatrical female voice", "strings", "bass guitar", "drums", "piano", "broadway musical vibes"] 2 ZbdmiykoJm8 3396

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;