musiccaps_details (view)
2 rows where musiccaps_aspects contains "duet", musiccaps_aspects contains "happy" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- duet · 2 ✖
- fast tempo 2
- happy · 2 ✖
- acoustic guitar 1
- animated 1
- animated guitar 1
- animated vocals 1
- barrel drum 1
- cheerful 1
- children vocals 1
- children’s ryymes 1
- children’s song 1
- choral harmony 1
- dhol 1
- dholaki 1
- educational 1
- ektara 1
- ektare 1
- engaging 1
- female backup 1
- female vocalisation 1
- festive 1
- happy occasion 1
- home recording 1
- indian festivities 1
- indian song 1
- keyboard harmony 1
- learning 1
- merry 1
- mind stimulating 1
- minimal instruments 1
- muffled audio 1
- multi vocalists 1
- peppy 1
- punjabi song 1
- sapp 1
- shaker 1
- simple 1
- songs for children 1
- songs for kids 1
- steady drumming 1
- string instrument 1
- tano indian festivities 1
- tanpura 1
- toddlers 1
- upbeat 1
- vocal backup 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 | |
Care bears movie song" forest of feelings" | This song is an animated Children’s Song. The tempo is fast with many singing different parts. The song is simple and happy with spirited backup vocals, female, male and child vocals with an animated keyboard harmony, rhythmic drumming , acoustic guitar and choral harmony. The song is light, peppy, engaging and is designed for toddlers and children. The audio is a home recording and the song is muffled. | 2013-03-30T01:01:25Z | Kristy Rivera | Forest of feelings song when the care bears and Kim and jason get sent to earth buy instead get trapped between a world between care a lot and earth. | ["Music", "Rattle (instrument)"] | ["duet", "fast tempo", "multi vocalists", "engaging", "toddlers", "choral harmony", "peppy", "happy", "acoustic guitar", "muffled audio", "home recording", "animated", "muffled audio", "animated guitar", "vocal backup", "keyboard harmony", "steady drumming", "animated vocals", "children vocals", "children’s song", "children’s ryymes", "songs for kids", "songs for children", "educational", "learning", "mind stimulating", "animated"] | 7 | w3QIsHxQfPE | 5234 |
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;