musiccaps_details (view)
2 rows where "youtube_published" is on date 2006-06-07 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- afro chant 1
- bass 1
- candomble 1
- congregation 1
- dance song 1
- female backing voice 1
- female voice 1
- folk 1
- happy mood 1
- male backing voice 1
- moderate tempo 1
- pandemonium 1
- percussion 1
- percussive elements 1
- pop song 1
- repetitive melody 1
- santeria 1
- trumpet 1
- yoruba 1
musiccaps_names (array) 4 ✖
- Music 2
- Funk 1
- Maraca 1
- Rattle (instrument) 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 | |
CHANT TO ELEGUA | This is a chant to a deity that is venerated in Yoruba, Candomble and Santeria religions. There are many people chanting in a devotional manner to this deity. There are a lot of percussive elements playing intertwined syncopations. The conflict of all the sounds and voices make the piece sound like a scene from a pandemonium. This piece can be used in a nightmare sequence at a horror movie. | 2006-06-07T18:26:30Z | kimbiza | DEDICATED TO THE ORICHA OF THE CROSSROADS,AND HIS MANY AVATARS | ["Music", "Rattle (instrument)", "Maraca"] | ["afro chant", "folk", "yoruba", "santeria", "candomble", "congregation", "percussive elements", "pandemonium"] | 9 | dwFtlQLdbq0 | 3829 |
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;