musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy" and musiccaps_aspects contains "string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- happy · 2 ✖
- string instrument · 2 ✖
- barrel drum 1
- bowed string instrument 1
- carnatic music 1
- cheerful 1
- classical ensemble 1
- concert 1
- dhol 1
- dholaki 1
- duet 1
- ektara 1
- ektare 1
- engaging 1
- fast tempo 1
- female backup 1
- female vocalisation 1
- festive 1
- flute harmony 1
- gadam rhythm 1
- happy occasion 1
- impactful 1
- indian clasical 1
- indian classical violin 1
- indian festivities 1
- indian percussion instruments 1
- indian song 1
- instrumental 1
- kriti 1
- lively 1
- medium fast tempo 1
- merry 1
- minimal instruments 1
- mridangam rhythm 1
- punjabi song 1
- ragas 1
- sapp 1
- shaker 1
- simple 1
- skilled 1
- south indian classical 1
- south indian traditional music 1
- sruti 1
- tala 1
- tano indian festivities 1
- tanpura 1
- traditional indian music 1
- upbeat 1
- violin 1
- vocal battle 1
- vocal jugalbandi 1
- wind instrument 1
musiccaps_names (array) 6 ✖
- Music 2
- Carnatic music 1
- Folk music 1
- Musical instrument 1
- Sitar 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Flute Raman V.K. & Violin Srikanth - Siddhi Vinayakam(Part2) | This music is an Indian Classical Instrumental. The tempo is medium fast with an ensemble of a lively violin, melodic flute and rhythmic accompaniment of the Indian percussion gadam and mridangam . The music uses ragas, talas and Sruti to form a harmony. It is classic, lively, rhythmic, engaging and enthralling. | 2008-03-13T08:28:15Z | pvedam | Doordarshan program - Song Siddhi Vinayakam - Raga Chamara - Talam Rupakam - Part 2 | ["Carnatic music", "Folk music", "Music", "Musical instrument", "Sitar"] | ["instrumental", "medium fast tempo", "engaging", "impactful", "concert", "indian clasical", "carnatic music", "south indian classical", "flute harmony", "violin", "indian classical violin", "ragas", "kriti", "tala", "sruti", "traditional indian music", "south indian traditional music", "happy", "skilled", "lively", "wind instrument", "string instrument", "bowed string instrument", "indian percussion instruments", "classical ensemble", "gadam rhythm", "mridangam rhythm"] | 7 | xyco-5DC_K8 | 5372 |
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;