musiccaps_details (view)
2 rows where musiccaps_aspects contains "simple", musiccaps_aspects contains "upbeat" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- fast tempo 2
- simple · 2 ✖
- string instrument 2
- upbeat · 2 ✖
- barrel drum 1
- cheerful 1
- dance master’s fiddle 1
- dhol 1
- dholaki 1
- duet 1
- ektara 1
- ektare 1
- engaging 1
- female backup 1
- female vocalisation 1
- festive 1
- happy 1
- happy occasion 1
- indian festivities 1
- indian song 1
- instrumental 1
- kit 1
- lead harmony 1
- lively 1
- merry 1
- minimal instruments 1
- minimalist 1
- pochette 1
- punjabi song 1
- sapp 1
- shaker 1
- small bowed string instrument 1
- spirited 1
- stringed instrument 1
- tano indian festivities 1
- tanpura 1
- violin like instrument 1
- vocal battle 1
- vocal jugalbandi 1
musiccaps_names (array) 3 ✖
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 | |
polatidis v UMUT AYVAZ - TUZCUOGLU | This music is a lively instrumental. The tempo is fast with a spirited violin which is most likely a pochette playing a spirited harmony. The music is upbeat, catchy, happy,cheerful, engaging and energetic. This instrumental is a folk song instrumental. | 2008-07-22T17:38:32Z | kalospaidas | polatidis v UMUT AYVAZ - TUZCUOGLU | ["Traditional music", "Music"] | ["instrumental", "fast tempo", "stringed instrument", "lively", "spirited", "upbeat", "engaging", "simple", "lead harmony", "minimalist", "violin like instrument", "pochette", "string instrument", "small bowed string instrument", "kit", "dance master’s fiddle"] | 7 | ehJKd9HLA04 | 3891 |
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;