musiccaps_details (view)
4 rows where musiccaps_aspects contains "fun", musiccaps_names = "["Music", "/t/dd00032"]" and musiccaps_names contains "/t/dd00032"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chemistry Music Video 15: Elemental Funkiness | The low quality recording features a southern rock song that consists of flat male vocal singing over wide acoustic rhythm guitars, short electric guitar lick, smooth bass guitar, punchy snare, simple kick pattern and shimmering hi-hats. It sounds happy and fun. | 2009-08-30T02:43:28Z | Mark Rosengarten | This song outlines the properties of the elements in Groups 1, 2, 3-12, 17 and 18. Music and lyrics copyright 2005 by Mark Rosengarten. All rights reserved. Lyrics: In 1869, Dmitri Mendeleev could see That properties of elements vary periodically As atomic number increases, the properties repeat In a soothing rhythmic pattern that can form a funky beat The elements we know about, they number one-fourteen Some in quantities so small that theyve never been seen Most are common elements that are far and wide dispersed But all of them together make up all the universe Elements in Group 1 are called the alkalis They explode in water, and are of very tiny size They love to lose electrons when they form a bond Of these reactive atoms, I can say Im rather fond! Group 2 elements are often called alkaline earth Calciums been building bones since well before your birth They form nice +2 ions and are generally quite fun Though theyre not quite as reactive as the metals in Group 1 Since 1869, every one of us could see That properties of elements vary periodically As atomic number increases, the properties repeat In a soothing rhythmic pattern that can form a funky beat Metals in groups 3-12? Transition elements! Some of them are lightweight, and others really dense Things they have in common, they form charges, two or more And some form colored compounds, which is something we adore! If you want an element, just tell me once again If its in Group 17, youve got a halogen! Nonmetals so corrosive, theyre not found in their pure state They can gain electrons like theyre going out of date! Got one for you in Group 18, and its known as Noble Gas If youre looking for an element that just sits there on its %&@ If you wonder why and havent figured it out yet Their valence configuration is a big stable octet! So now it should be obvious that everyone should see That properties of elements vary periodically As atomic number increases, the properties repeat In a soothing rhythmi… | ["Music", "/t/dd00032"] | ["low quality", "flat male vocal", "wide acoustic rhythm guitar", "short electric guitar lick", "smooth bass guitar", "punchy snare", "simple kick pattern", "shimmering hi hats", "happy", "fun", "southern rock"] | 4 | 1PSzSTilu_s | 268 | |
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
The Sound of Music Video Audition Contest | The low quality recording features a cover of a children's song and it consists of an emotional girl vocal singing over acoustic rhythm guitar located in the right channel of the stereo image, which makes the stereo image unbalanced. The recording is a bit noisy and It sounds fun, happy, emotional and innocent. | 2009-08-17T18:08:11Z | Marty Frolick | Emily auditioning for Brigitta von Trapp | ["Music", "/t/dd00032"] | ["low quality", "emotional girl vocal", "acoustic rhythm guitar", "cover", "noisy", "unbalanced stereo", "fun", "happy", "emotional", "children song", "innocent"] | 4 | KCytKo5LzCc | 2066 | |
Red Baron II Theme Music - Main Menu 1 | The low quality recording features a big band song that consists of an addictive trumpet melody, simple woodwind melody, groovy trombone and muffled drums that include snare and crash hits. Overall it sounds dull and muffled, but still happy and fun. | 2012-01-18T21:14:27Z | stefanodesantisattore | From the PC game "Red Baron II" | ["Music", "/t/dd00032"] | ["low quality", "muffled", "dull", "happy", "fun", "groovy trombone", "simple woodwind melody", "addictive trumpet melody", "muffled snare hits", "muffled crash hit", "big bend"] | 4 | jP4M9V_Ka8k | 4249 |
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;