musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy mood" and musiccaps_aspects contains "upbeat song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- happy mood · 3 ✖
- upbeat song · 3 ✖
- moderate tempo 2
- autotune voice 1
- backing voice 1
- bass 1
- cartoon whistles 1
- chimes 1
- clarinet 1
- dance music 1
- distortion guitars 1
- fast tempo 1
- female voice 1
- female voices 1
- folk song 1
- foreign language 1
- fusion song 1
- guitar 1
- koboro drums 1
- male voice 1
- percussion 1
- piano 1
- pop rock song 1
- pop song 1
- quirky sounds 1
- rebab 1
- simple percussion 1
- traditional instruments 1
- traditional string instrument 1
- traditional wind instruments 1
musiccaps_names (array) 11 ✖
- Music 2
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Exciting music 1
- Percussion 1
- Pop music 1
- Rimshot 1
- Snare drum 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
World Cup Twinkles 2009 Music | This pop song features female voices singing the main melody. This is accompanied by fast paced drumming. The percussion plays a simple fast paced beat in common time. Distortion guitars play power chords. The bass plays the root notes of the chords. There are quirky sounds played in the background. A cartoon whistle is played in the background. A triangle is also heard in the background. There is the sound of a cartoon laser blast in the background. The mood of the song is happy. This song can be played during the end credits of a college comedy movie. | 2013-11-01T20:57:11Z | WorldCupAllstarCheer | ["Music", "Pop music", "Exciting music"] | ["pop song", "female voices", "quirky sounds", "chimes", "fast tempo", "cartoon whistles", "percussion", "distortion guitars", "upbeat song", "dance music", "happy mood"] | 0 | UvCY9FHpKC8 | 2955 | ||
Hanson Returns! | This pop rock song features a male voice singing the main melody. A backing male voice sings the last part of the line in harmony. This is accompanied by a piano playing staccato chords. There is a momentary silence of instruments except the percussion after the chords are struck. An acoustic guitar plays chords in the background. A bass guitar plays the root notes of the chords. The percussion plays a simple beat in common time and finishes the bar with a roll. Then the drum plays with the beat with an open hi-hat. The mood of this song is happy. This song can be played in a coming of age movie. | 2008-09-06T22:44:23Z | CBS | It may be hard to believe that all three of these brothers are now married and have children, but the hit 90's pop group Hanson still knows how to rock. The trio perform live on the Second Cup Café. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["pop rock song", "male voice", "simple percussion", "guitar", "piano", "bass", "backing voice", "upbeat song", "happy mood", "moderate tempo"] | 0 | pwX5SArqGKU | 4743 | |
Amazing New Traditional Music By*Helen Pawlos* (Halawley) 2013 | This folk song starts off with a female voice singing the main melody. The voice has the added effect of autotune. This is accompanied by a rebab or a bowed instrument playing the same melody as the voice. Another stringed instrument is plucked, playing the same melody as the voice. The bass plays the root notes of the chords. The voice rests and other instruments come in. A clarinet plays a descending fill. Koboro percussion is played giving this song a middle-eastern feel. This song has a happy feel. It is a fusion between a folk song and a more modern beat. This song can be played as a party song. | 2013-09-24T10:57:49Z | Helen Pawlos | *Helen Pawlos* New 2013 Song Album *Mehenen* # 3(Halawley) The very beautiful and talented Eritrean artist Helen Pawlos sat down Her New album 2013 Mehenen a Very Loveley And Positive Words correspondent for a special Art Of Eritrea. Artist Helen Pawlos her love of music started at an early age. As a young kid, she had a traditional drum (koboro), which she used to enjoy. She said her mother got her to start a guitar lesson, but as she was learning the music notes, her mind would wonder away and start to sing. She was then asked to join a band and meet with Artist Bereket Mengisteab. At the age of 15, Bereket took Helen under his wings, and gave her an opportunity to visit Addis Ababa for a month. Helen , after she returned back home to Asmara, she decided she would have more options and opportunities if she moved to Addis, and so she did. Helen was very much accepted and encouraged despite her young age. She remembered Ethiopian artists such as Haile Tadesse and Aregahegn Worash,Minalush Reta,Buzuayehu Demsse,Gossaye Tesfaye,Abnet Agonafir And More Ethiopian and Sudanes Artists with whom she had opportunities to be on stage and perform. These artists and many others were instrumental to her growth and success in the music business, and expressed her gratitude. In regards to her family's reaction when she was a very young aspiring musician,Helen that they strongly opposed it mainly due to her age. "They wanted Her to concentrate on school", During the interview, the beautiful artist QUEEN OF THE STAGE shows her unbelievable talent by singing in Tigrignga,Arabic,Amharic, Tigre,and even Oromigna andGuragigna And More Lungueges Helen Had Realesed 2 Albums *Vol 1(Tarikna yu) on 2001.And *Vol 2 (Niani) on 2005 Single Songs Hagerey 2005 Misakina 2006 Shama Nibel 2009 Tegezemi Eritrea 2011 The 3rd Album On This Year 2013 (Mehenen) Helen Pawlos @ this time She Live in Sweden | ["Traditional music", "Music"] | ["folk song", "fusion song", "foreign language", "autotune voice", "rebab", "traditional instruments", "clarinet", "koboro drums", "female voice", "traditional wind instruments", "upbeat song", "moderate tempo", "traditional string instrument", "happy mood"] | 0 | yn4-OtUmyWo | 5440 |
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;