musiccaps_details (view)
6 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "pop" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- bass · 6 ✖
- pop · 6 ✖
- digital drums 4
- uptempo 4
- amateur recording 2
- flute sound 2
- higher register 2
- male voice singing 2
- bright acoustic guitar solo 1
- country 1
- crowd cheering and singing 1
- digital strings and brass 1
- e-guitar 1
- emotional 1
- female voice singing 1
- guitar melody 1
- keyboard melodies 1
- male voices singing 1
- medium tempo 1
- percussion's 1
- positive atmosphere 1
- sad male vocals 1
- sad mood 1
- scratchy male vocals 1
- strings 1
- strummed acoustic guitar 1
- synth pad 1
- synthesizer 1
musiccaps_names (array) 10 ✖
- Music · 6 ✖
- Bellow 1
- Bluegrass 1
- Burst, pop 1
- Crowd 1
- Happy music 1
- Mandolin 1
- Middle Eastern music 1
- Pop 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 |
---|---|---|---|---|---|---|---|---|---|---|
DANIJEL BOTO - URNEBES (OFFICIAL MUSIC VIDEO) | Digital drums are playing a four on the floor rhythm with a kick on every beat along with a bassline and a keyboard sound playing short rhythmic chords and a e-guitar playing a simple melody along. A male voice is singing in a higher key. This song may be playing at a folkfest. | 2012-10-31T00:15:59Z | CinematixStudios | Danijel Boto - Urnebes 1.dio Ima jeda smeđa mala oduvijek je plesat znala Kad zanjiše kukovima pomuti nam pamet svima... A,i ona mala plava kako pleše boli glava nezna čovjek šta bi reko ovaj stol je samo na njih čeko... REFREN: Hajmo svi na stol to je ovi fol hajmo svi a ples bit će URNEBES 2.dio Konobaru toči piće atmosfera luda biće donesi am piće svima mi smo već na stolovima Šta je ovo moji ljudi ova pjesma sve nas budi sve je ludo gori sve plešemo uz dobre ritmove... REFREN: Hajmo svi na stol 2x | ["Music", "Wedding music"] | ["pop", "digital drums", "e-guitar", "keyboard melodies", "male voice singing", "higher register", "bass", "uptempo", "positive atmosphere"] | 6 | -bgHkxwoliw | 65 | |
New Ethiopian Music 2014 by Tsehay Amare Kora Yalew | This song contains percussive digital drums. In the background you can hear a string instrument playing a melody along with a digital flute sound. A keyboard is playing digital strings and brass sounds setting accents and a countermelody. The female voice is singing in the same melody as the strings. A bass is also playing the melody but at the low register. This song may be playing in a dance video-clip. | 2014-05-24T22:08:54Z | Sora Tv | New Ethiopian Music 2014 by Tsehay Amare Kora Yalew | ["Music", "Happy music"] | ["pop", "digital drums", "bass", "digital strings and brass", "flute sound", "female voice singing", "medium tempo"] | 6 | 9Qd6AdTq3Ls | 1005 | |
Elite car show Golf sound system | Someone is playing a song out of a speaker. The song contains a guitar melody and a digital drum hitting the bass drum on every beat along with a bass-melody. This is an amateur recording. The song is in very poor audio-quality. | 2010-07-04T23:20:07Z | Guillermo Leal | ["Music", "Burst, pop"] | ["pop", "amateur recording", "digital drums", "guitar melody", "bass", "uptempo"] | 6 | Qz8hNRg-7G0 | 2655 | ||
Frog Holler - Least Most Wanted - at Godfrey Daniels 071909 - Bethlehem, PA | The country music features a male vocalist with a scratchy voice. Two acoustic guitars play a melodic intro riff that goes from melody to strumming. The strings are very sharp-sounding and bright. The atmosphere of the song is sad. | 2009-08-30T06:33:12Z | pmryan25 | Frog Holler - Least Most Wanted - at Godfrey Daniels 071909 - Bethlehem, PA | ["Music", "Mandolin", "Bluegrass"] | ["country", "pop", "sad mood", "sad male vocals", "emotional", "scratchy male vocals", "bright acoustic guitar solo", "bass", "strummed acoustic guitar"] | 5 | SBeC9TISHz8 | 2746 | |
[HD Fancam] 121027 GD&TOP Stage - Big Bang ALIVE Tour in Malaysia | This song contains digital drums with a kick on every beat and an open hi hat on the backbeat. A synth bass is playing a melody along with an e-bass. A male voice is singing along with a male backing singer. The crowd is cheering and singing along. This is an amateur recording and of poor audio-quality. This song may be playing at a live concert. | 2012-10-28T10:36:56Z | Choi Rain | Song - High High and Knock Out Credit to Me | ["Crowd", "Music", "Pop music", "Bellow"] | ["pop", "amateur recording", "digital drums", "synthesizer", "bass", "male voices singing", "crowd cheering and singing", "uptempo"] | 6 | cabjr3xtcR4 | 3722 | |
Ax kardia mou Konstantinos Galanos.... | A male voice is singing loud and in a higher register while a flute is playing a counter melody. Percussions are playing a fast paced groove along with a soft minimalistic bass. In the background you can hear a synth pad playing chords. This song may be playing in a oriental barber shop. | 2009-09-19T19:41:52Z | Mazzika | ["Music", "Middle Eastern music"] | ["pop", "bass", "strings", "flute sound", "percussion's", "synth pad", "male voice singing", "higher register", "uptempo"] | 6 | oczJZV87k9A | 4647 |
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;