musiccaps_details (view)
3 rows where musiccaps_author = 3 and musiccaps_names = "["Jazz", "Music"]"
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|
Jazz Funk - The Scratch - Surface Noise | The clip is an upbeat, groovy funk song with jazzy elements. The retro vintage electric piano chords add an old school jazzy feel to the song. The bassline is intricate and bouncy and enables easy dancing. | 2011-06-30T21:59:36Z | Herecomesmongo79 | The Scratch - Surface Noise - 1980 | ["Jazz", "Music"] | ["funk", "jazzy funk", "groovy bassline", "upbeat", "dance", "fun", "vibrant brass melody", "palm muted electric guitar", "rhythmic groovy drumline", "disco funk", "retro electric piano"] | 3 | TPYNIc_M1ng | 2835 | |
Madeline and the Dinosaur Bone 1 | The song is fun, playful and cheerful. It involves child vocalists who sing in unison, and various sound effects of children laughing, and a child exclaiming. The song features an intricate clarinet melody which follows the vocal in note selection. | 2010-01-27T07:42:27Z | littlemissmadeline28 | From the New Adventures of Madeline. No copyright infringement intended; for fan purposes only. | ["Jazz", "Music"] | ["children's song", "children singing", "cheery female vocalist", "children laughing", "cheerful upbeat song", "happy song", "clarinet", "brass instruments", "playful"] | 3 | UOAv5b6MGxw | 2911 | |
Mission Impossible Theme. SF Christo, harpsichord | This is an intricate melody played on the harpsichord. It's recorded live and has a suspenseful feeling to it. The melody is played at a medium tempo. | 2008-11-06T19:08:40Z | SFChristo | Mission Impossible Theme by Lalo Schifrin. FAQ: What are you doing at :38? I am pushing in the "shove coupler" which connects the upper and lower keyboards (manuals). This allows me to add an extra set of strings for more volume and power (in a way its like a 12 string guitar). I'm also getting a little glitch of an extra note in there which was unintentional but I decided to leave it in. Can you tell more more about harpsichords, how much they cost and how they work? Yes, please check out my video, "Harpsichord 101: How it Works". | ["Jazz", "Music"] | ["harpsichord", "intricate playing", "live recording", "suspenseful music"] | 3 | ZOKQFjrfbpw | 3372 |
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;