musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "uplifting energy" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- medium tempo · 4 ✖
- uplifting energy · 4 ✖
- e-bass 2
- accordion-like sound 1
- acoustic drums 1
- acoustic piano 1
- brass section 1
- celli 1
- classical 1
- cymbals 1
- digital drums 1
- flutes 1
- higher register 1
- keys 1
- male voice sample 1
- male voices singing 1
- new ethiopian music 1
- orchestral/jingle 1
- organ 1
- reggae 1
- synth pluck sound 1
- xylophone 1
musiccaps_names (array) 7 ✖
- Music 3
- Classical music 1
- Gospel music 1
- Jazz 1
- Orchestra 1
- Soul music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Melaku Nigus track 4 2013 New Ethiopian music, Rayan Music, Wollo Music, Ethiopian Music | A digital drum is playing a simple beat along with some percussive sounds. A bass is playing the same melody as the accordion-like instrument. A male voice is shouting little phrases. This song may be playing a country having a traditional dance. | 2013-08-05T08:14:54Z | At Love | Rayan music, Wollo Music, Ethiopian Music, Amharic Music, Rayan Cultural Music, Wollo Cultural Music, | ["Jazz", "Music"] | ["new ethiopian music", "digital drums", "male voice sample", "accordion-like sound", "e-bass", "medium tempo", "uplifting energy"] | 6 | 0PMFAO4TIU4 | 161 | |
Tokyo Kosei Wind Orchestra - Jingle Bells | This audio contains an orchestral composition. A brass section is playing an uplifting melody with a horn playing a bassline. Cymbals are playing a 8th notes rhythm and flutes and a trombone are playing a countermelody. On top of that a xylophone is playing a melody in a higher pitch on top. This song may be playing during a cheerful cultural event such as Christmas. | 2010-12-25T15:15:04Z | Ivan Župić | ["Orchestra"] | ["orchestral/jingle", "brass section", "flutes", "xylophone", "cymbals", "medium tempo", "uplifting energy"] | 6 | 4Udqs0trpMw | 576 | ||
Christian Classical Music | This song contains an acoustic piano playing a melody in the higher register playing mostly one note at a time. Celli is playing along the melody then changing into staccato strokes playing a melody in the low to high register. This song may be playing live during a dance scene in a musical. | 2012-07-08T23:25:35Z | Priscilla Cris | God Bless you! Everything is for the glory and honor of God. No copyright infringement intended. | ["Gospel music", "Music", "Wedding music", "Classical music"] | ["classical", "acoustic piano", "celli", "medium tempo", "uplifting energy"] | 6 | KeSbjmMeyrY | 2103 | |
Tribal seeds- The Harvest(lyrics) | An acoustic drum is playing a groove that is not strongly connected to reggae rhythm. A e-bass and piano-keys are bringing the typical reggae backbeat while another synth sound is playing short plucks as a melody. The male voice is singing in a reggae-fashion and in a higher key. In the background you can hear a big organ sound coming in and playing along with the melody. The elements are spread along the speakers. This song may be playing with speakers riding on your bike. | 2012-01-08T06:20:54Z | molokaiboi1998 | hope u guys liike it:) srry if da lyrics r wrong i got it off da internet dont turn off da annotations there's corrections to da lyrics Lyrics: (verse 1) Ooooh, ooooh, Yeah When I first picked up the mic I was 3 and on my brother's side Didn't know what I singing but the vibe was always right Didn't think sound would have such a strong impact on my life This music it gets I and I in such a natural high (chorus) Now a days we a work we a work we a work to spread Jah word(2x) Cause in a this a life we have to strive all the time strive to do good works and achieve this at mind Spreading the word in a positive vibe Educate the youth and tell them no lie Play the music of Jah, in the harvest time Come with sweet melodies, to ease your mind(2x) Ooooh, Ooooh, Yeah (verse 2) Now I'm 21 still working, never, never got the education Never want to be a stock on a shelf, wanted to be my self It in a world living in hell, you see you can't do very well So a man keep my mind focused and uprised it's worth my while (chorus) | ["Music", "Soul music"] | ["reggae", "acoustic drums", "e-bass", "keys", "synth pluck sound", "organ", "male voices singing", "higher register", "medium tempo", "uplifting energy"] | 6 | ZM0imDMXuw8 | 3367 |
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;