musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "female vocal" and musiccaps_aspects contains "medium tempo" sorted by musiccaps_caption
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- acoustic drums · 2 ✖
- bass guitar 2
- female vocal · 2 ✖
- medium tempo · 2 ✖
- acoustic guitar 1
- children's song 1
- country music 1
- easygoing 1
- electric guitar 1
- emotional 1
- inspiring 1
- mandolin 1
- medium-to-high pitch singing 1
- playful 1
- repeated theme 1
- simple 1
- touching 1
musiccaps_names (array) 7 ✖
- Music 2
- Country 1
- Dance music 1
- Jazz 1
- Pop music 1
- Psychedelic rock 1
- Rock music 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Academy of Country Music Awards - Road to ACM Award - Band Perry Takes Vegas! | This is a country music piece. There is a female vocalist singing melodically as the lead at a medium-to-high range. A mandolin is playing the main theme while being backed by a bass guitar. The rhythmic background consists of a simple 4/4 acoustic drum beat. | 2011-04-03T18:39:30Z | CBS | Follow The Band Perry as they take on Vegas! Tune into the ACM Awards Sunday, April 3 at 8/7c | ["Country", "Music", "Psychedelic rock", "Pop music", "Rock music"] | ["country music", "female vocal", "medium-to-high pitch singing", "mandolin", "acoustic drums", "bass guitar", "touching", "emotional", "inspiring", "medium tempo"] | 9 | 2OI4QeokeRQ | 360 | |
Music and Movement Songs for Children: "Jump High" by Music with Miss Merry | This is a song for children. The song is in major key as is usual with almost all kids songs. There is a female vocalist in the lead. The melody is being played by an acoustic guitar while a bass guitar plays a simple bass line. The electric guitar is playing delayed notes for texture. The acoustic drums are playing a basic medium tempo beat in the rhythmic background. The atmosphere is easygoing. This piece could be used during activities in a kindergarten. | 2008-12-28T14:57:25Z | Meredith LeVande | Please visit https://musicwithmissmerry.com, plus stream this and more Music with Miss Merry children's music videos at https://musicwithmissmerry.vhx.tv. "Jump High" is a preschool music and movement children's music video by Monkey Monkey Music. This you tube music video along with other songs for children and nursery rhymes such as "Old MacDonald Had a Farm," "Twinkle Twinkle Little Star" and "abc songs" for kids are both fun and educational. Monkey Monkey Music videos are seen on public television before and after iconic PBS Kids shows like "Sid The Science Kid," "Sesame Street," "Curious George," "Barney," and "Dinosaur Train." Looking to throw a great New York birthday party? Also, please visit Music with Miss Merry's YouTube channel at https://www.youtube.com/@musicwithmissmerry. Copyright 2008. Monkey Monkey Music, LLC. All Rights Reserved. | ["Jazz", "Music", "Dance music"] | ["children's song", "female vocal", "acoustic guitar", "electric guitar", "bass guitar", "acoustic guitar", "repeated theme", "acoustic drums", "simple", "easygoing", "playful", "medium tempo"] | 9 | 0RcMzUdXDRQ | 166 |
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;