musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "happy", musiccaps_aspects contains "southern rock" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 11 ✖
- flat male vocal 1
- fun 1
- happy · 1 ✖
- low quality 1
- punchy snare 1
- shimmering hi hats 1
- short electric guitar lick 1
- simple kick pattern 1
- smooth bass guitar 1
- southern rock · 1 ✖
- wide acoustic rhythm guitar 1
musiccaps_names (array) 2 ✖
- /t/dd00032 1
- Music · 1 ✖
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 |
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;