musiccaps_details (view)
4 rows where musiccaps_aspects contains "happy mood" and musiccaps_aspects contains "repetitive melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- happy mood · 4 ✖
- repetitive melody · 4 ✖
- male voice 3
- moderate tempo 3
- dance song 2
- female voice 2
- groovy bassline 2
- percussion 2
- african beat 1
- banjo song 1
- bass 1
- children's song 1
- children's voices 1
- duet 1
- female backing voice 1
- flute 1
- folk song 1
- guitar song 1
- keyboard music 1
- male backing voice 1
- male backing voices 1
- minimal instruments 1
- no percussion 1
- pop song 1
- programmed percussion 1
- r&b feel 1
- slow tempo 1
- trumpet 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 4
- Banjo 1
- Bluegrass 1
- Christmas music 1
- Country 1
- Funk 1
- Jingle (music) 1
- Music for children 1
- Music of Africa 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SUPERSCI - Get! (Feat. Remedeeh) (Official Video) | This pop song features a female voice singing the main melody. This is accompanied by male and female backing voices. The voices sing a repetitive melody. This is accompanied by percussion playing a simple beat. Trumpets play a backing melody. The bass plays a groovy descending bassline. The mood of this song is happy. This song can be played at a club. | 2006-06-07T17:33:35Z | Supersci Flyphonic | Swedish hip hop at its finest with a sweet summer vibe. Supersci's first video from the 2006 album "Pinetrees on the Pavement". Shot around the Sundsvall area using super-8 film. Video directed by Måns Berthas. Music produced by Flyphonic Beats. Lyrics by Mr Noun, Arka and Remedeeh. www.flyphonic.com/supersci | ["Funk", "Music"] | ["pop song", "female voice", "male backing voice", "female backing voice", "percussion", "trumpet", "bass", "moderate tempo", "dance song", "repetitive melody", "happy mood"] | 0 | EtmKuWPpjG0 | 1598 | |
Scar Tissue (The Red Hot Chili Peppers) | This folk song is a duet and features a male and a female voice singing in harmony. This is accompanied by an acoustic guitar strumming chords. A banjo player fills in between lines. There is no percussion in this song. The mood of this song is happy and upbeat. This song can be played in a coffee shop. | 2012-12-24T02:14:04Z | goosebearmusic | if you dig the tune you can download it here: https://soundcloud.com/thejunebugs/scar-tissue-the-red-hot-chili Goose and me throwing out some 90's folk... or something like that. | ["Christmas music", "Banjo", "Country", "Music", "Song", "Bluegrass"] | ["folk song", "duet", "male voice", "female voice", "vocal harmony", "banjo song", "guitar song", "no percussion", "minimal instruments", "happy mood", "moderate tempo", "repetitive melody"] | 0 | f6wrXzvByrg | 3922 | |
Zigido-Eddy Kenzo[Official] | This African beat song features a male voice singing the main melody. Other voices sing one word after each line. This is accompanied by percussion playing an African dance beat. The bass plays a groovy bassline. A flute plays the same melody as the main voice. This song has a happy mood. This song can be played in a dance party. | 2015-06-10T11:28:50Z | Eddy Kenzo | In this song Eddy Kenzo Talks about the struggle of a Ghetto boy who suffered a lot during his childhood but due to hard-work and believing in GOD, Zigido is seeing success. CHECK IT OUT. WORK-HARD~BELIEVE~ACHIEVE. #BIGTALENTMUSIC. Subscribe to this channel = http://www.youtube.com/suscription_center?add_user=eddykenzo Like my official Facebook page = https://www.facebook.com/syfepro1 Follow me on Twitter = https://twitter.com/eddykenzoficial Follow me on Twitter = https://instagram.com/eddykenzo/ | ["Music of Africa", "Music"] | ["dance song", "african beat", "male voice", "male backing voices", "percussion", "groovy bassline", "flute", "moderate tempo", "happy mood", "repetitive melody"] | 0 | mpymEs4Mcw8 | 4494 | |
Thanksgiving Counting Songs for kids - Turkey Gobble Song - Littlestorybug | This children's song features a male voice singing the main melody. Children repeat numbers after the main voice sings. This is accompanied by percussion playing a simple beat. The bass plays a groovy bassline. A keyboard plays in the background. A sound like a marimba plays individual notes in an ascending order followed by descending notes. An organ plays chords in the background. The mood of this song is happy. This song can be played in a children's educational animation movie. | 2012-11-16T00:23:23Z | littlestorybug | Join Miss Tracey as she counts turkeys from 1 to 20. Happy Thanksgiving!!!!! Music & Video Created by Bill Phillips, Jr. LittleStoryBug's Preschool Songs, Vol. 2 iTunes: http://apple.co/1NxiPa7 CDBaby http://bit.ly/1WDuCWY Amazon: http://amzn.to/28VCoe7 LittleStoryBug's Preschool Songs, Vol. 1 iTunes http://bit.ly/UIi25Q CDBaby http://bit.ly/TzV0Aj Amazon http://amzn.to/YC3juB SUBSCRIBE to LittleStoryBug: http://bit.ly/29f4NWQ I'm GREAT Video: http://bit.ly/2a3kHoh Head, Shoulders, Knees & Toes Video: http://bit.ly/29dpRDu | ["Jingle (music)", "Music", "Music for children"] | ["children's song", "r&b feel", "groovy bassline", "male voice", "children's voices", "slow tempo", "programmed percussion", "keyboard music", "happy mood", "repetitive melody"] | 0 | tpamd6BKYU4 | 5069 |
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;