musiccaps_details (view)
4 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "guitar" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- bass · 4 ✖
- guitar · 4 ✖
- percussion · 4 ✖
- low quality audio 2
- moderate tempo 2
- no voice 2
- accordion song 1
- amateur recording 1
- backing voices 1
- children's song 1
- country song 1
- dance song for children 1
- female backing voice 1
- female voice 1
- happy song 1
- instrumental 1
- keyboard 1
- latin rhythm song 1
- male voice 1
- melancholic mood 1
- no other instruments 1
- repetitive phrase 1
- rock 1
- romantic mood 1
- slow tempo 1
- tambourine 1
musiccaps_names (array) 10 ✖
- Music 2
- Accordion 1
- Drum kit 1
- Guitar 1
- Musical instrument 1
- Pulse 1
- Rock music 1
- Singing 1
- Ska 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Here We Go Loopy Loo - Children's Song - Kids Songs by THE LEARNING STATION | This children's song features a male voice singing the main melody. There are other voices singing backing vocals. This is accompanied by percussion playing a simple beat. A guitar strums the chords accenting the strums in between lines. The bass plays the root notes of the chords with a reggae feel. The keyboards play chords in the background. This song can be played at a children's party. | 2012-04-13T21:08:00Z | TheLearningStation - Kids Songs and Nursery Rhymes | HERE WE GO LOOPTY LOO Song by THE LEARNING STATION "Here We Go Loopty Loo", from the award-winning DVD, "Movin' & Groovin' Vids for Kids" Award-winning CD, "Here We Go Loopty Loo". "Movin' & Groovin' Vids for Kids" DVD: http://store.learningstationmusic.com/movinandgroovin.aspx. Here We Go Loopty Loo CD Download: http://store.learningstationmusic.com/herewegolooptyloodownload.aspx "Here We Go Loopty Loo" CD: http://store.learningstationmusic.com/herewegolooptyloo.aspx Visit The Learning Station: https://www.learningstationmusic.com/ Visit our store! CD's, CD Downloads, DVD's, Tee shirts & more: https://www.learningstationmusic.com/shop/ STAY IN TOUCH WITH US Facebook: http://www.facebook.com/pages/The-Learning-Station/115732872904 Twitter: http://twitter.com/#!/LearningStation * FREE STUFF * Sign-up for our FREE newsletter: http://learningstationmusic.com/newsletter.html FREE printable activities: http://learningstationmusic.com/printablehandouts.html Tony Chestnut official website: http://tonychestnut.com/ Tony Chestnut Tee Shirts:http://store.learningstationmusic.com/tonychestnutt-shirt.aspx Tony Chestnut printable lyrics, movements and activities:http://learningstationmusic.com/docs/Tony-Chestnut.pdf This song is part of our campaign that supports, Healthy Music for a Child's Heart, Body & Mind! Young children naturally love to sing, dance and move. "Here We Go Loopty Loo" is one of the most popular rhyming dance songs of all time and it invites children to actively participate as they learn the names of body parts. Songs that call for movement, participation and dance are also great for teaching coordination, balance and are filled with healthy fitness. And songs, chants, and action rhymes are a fun English-learning resource for ESL/EFL teachers and students. Here We Go Loopty Loo From the DVD, Movin' & Groovin' Vids for Kids (Online Video Design Production) From the CD, "Here We Go Loopty Loo" By The Learning Station ©Monopoli/The Learning Station HERE WE GO LOOPTY LOO (Activity: Have the chil… | ["Singing", "Music", "Ska"] | ["children's song", "male voice", "guitar", "percussion", "bass", "happy song", "keyboard", "backing voices", "dance song for children", "moderate tempo"] | 0 | 00M9FhCet6s | 109 | |
The Tea Party - Lullaby Live In Montreal - July 7, 2011 | This amateur recording features a rock song. A repetitive phrase is played on the guitar. The first bar consists of only the guitar sound. The bass and percussion start playing after one bar. The bass plays one note in groups of twos. The percussion plays a groovy rock beat. The hi-hat is played in a group of four strokes on the closed hi-hat followed by one stroke on the open hi-hat. There are no voices in this song. The mood of this song is melancholic. | 2011-07-10T12:36:07Z | Luc Beaulieu | Live at Le Métropolis, Montreal, Québec, Canada | ["Drum kit", "Guitar", "Music", "Musical instrument", "Rock music", "Pulse"] | ["amateur recording", "rock", "guitar", "repetitive phrase", "percussion", "bass", "no voice", "no other instruments", "slow tempo", "melancholic mood"] | 0 | GcYeBWujhjw | 1741 | |
Los Paraguayos | This low quality audio features an accordion playing the main melody. This is accompanied by percussion playing a simple beat. A tambourine is played with the percussion. This is a Latin style song. The guitar plays groups of three ascending and one descending note per bar. The bass plays a Latin rhythm. There are no voices in this song. This song is an instrumental. This song can be played at a house party. | 2008-07-24T14:35:37Z | Spiciu | Performing their tune MANANTIAL - The Spring. | ["Accordion"] | ["latin rhythm song", "accordion song", "guitar", "percussion", "no voice", "instrumental", "bass", "low quality audio"] | 0 | QNQ3sAMxZPY | 2616 | |
I'm Sorry I Love You - The Magnetic Fields | This country song features a female voice singing the main melody. Another female voice sings backing vocals in harmony with the main voice. This is accompanied by percussion playing a simple beat in common time. A guitar strums chords. The bass plays the root notes of the chords. After the voices pause, a guitar solo is played in a repetitive pattern. The mood of this song is romantic. Other instruments cannot be heard due to low quality of audio. This song can be played in a romantic movie. | 2009-01-29T20:00:09Z | mojorisin1986 | I'm Sorry I Love You - The Magnetic Fields | ["Vocal music"] | ["country song", "female voice", "female backing voice", "guitar", "percussion", "low quality audio", "bass", "moderate tempo", "tambourine", "romantic mood"] | 0 | W00eTCOgUNs | 3053 |
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;