musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "female backup"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- fast tempo · 2 ✖
- female backup · 2 ✖
- barrel drum 1
- chaotic 1
- cheerful 1
- confusing 1
- dhol 1
- dholaki 1
- duet 1
- ektara 1
- ektare 1
- energetic drumming 1
- female vocalisation 1
- festive 1
- groovy bass line 1
- happy 1
- happy occasion 1
- hip-hop 1
- indian festivities 1
- indian song 1
- inferior sound quality 1
- keyboard harmony 1
- male vocalist 1
- merry 1
- minimal instruments 1
- muffle audio 1
- punjabi song 1
- rap 1
- rhythmic patter 1
- sapp 1
- scratching sound 1
- shaker 1
- simple 1
- string instrument 1
- tano indian festivities 1
- tanpura 1
- unpleasant sound 1
- upbeat 1
- vocal battle 1
- vocal jugalbandi 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SKREW MSK AWR ARTIST WRITING | A male vocalist sings a lively hip hop. The tempo is fast with energetic drumming, groovy bass lines and keyboard accompaniment with female backup vocals. The song is incoherent and muffled with a loud scratching like sound dominating the audio. The audio is chaotic, confusing, incoherent and unpleasant to the ears. | 2008-11-26T23:03:40Z | Eddie Donaldson | GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/ | ["Scratching (performance technique)", "Music", "Scratch", "Writing"] | ["male vocalist", "fast tempo", "rap", "hip-hop", "keyboard harmony", "unpleasant sound", "female backup", "groovy bass line", "energetic drumming", "rhythmic patter", "muffle audio", "inferior sound quality", "scratching sound", "chaotic", "confusing"] | 7 | IlUcHzBzZvg | 1936 | |
Punjabi Boliyan Tappe | Part 2 | Geet Shagna De | Top Punjabi Wedding Songs | Marriage Song | This song is a happy Punjabi song. The tempo is fast with a male vocalist singing an enthusiastic melody to the beat of a dhol , tanpura and beat of a shaker. The song is lively, simple, energetic and festive. This song is sung at weddings. It is a jugalbandi between the bride and groom’s side where two vocalists compete playful in vocal battle. | 2012-03-16T17:19:04Z | Catrack Entertainment | This Song/Boliyan represents the Rich Punjabi Culture and Music and is Part of Rituals in every Traditional Punjabi Wedding Ceremony whether it takes place in a Village of Punjab (India) or Anywhere in the World. These Folk / Marriage Songs are integral part of Punjabi Culture and have various forms of Song & Dance like Tappe, Bolian, Gidha, Bhangra and Sithniyan. These are also called Shagna De Geet. Subscribe to Catrack's Youtube Channel http://www.youtube.com/subscription_center?add_user=catrackentertainment Join Us On Facebook http://www.facebook.com/CatrackOfficial Twitter https://twitter.com/catrack Google+ https://plus.google.com/112539272523400923462/ For Any Content, Advertising, or Marketing Related Queries , Kindly Visit: http://www.catrack.com | ["Music", "Wedding music"] | ["duet", "fast tempo", "female vocalisation", "vocal battle", "ektara", "tanpura", "indian festivities", "festive", "happy occasion", "simple", "minimal instruments", "vocal jugalbandi", "female backup", "ektare", "sapp", "shaker", "tano indian festivities", "punjabi song", "happy", "cheerful", "merry", "upbeat", "string instrument", "dhol", "barrel drum", "dholaki", "indian song"] | 7 | UQKLBsZJsww | 2915 |
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;