musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- addictive · 3 ✖
- low quality 3
- passionate · 3 ✖
- traditional · 3 ✖
- wooden percussions 2
- addictive brass melody 1
- addictive strings melody 1
- breathy flute melody 1
- echoing male chant 1
- energetic 1
- folk 1
- harmonizing female vocals 1
- joyful 1
- mellow piano chords 1
- mono 1
- noisy 1
- punchy kick 1
- punchy snare 1
- short flute licks 1
- simple bass 1
- wide acoustic guitar chords 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Badke: KVS/les ballets C de la B/A.M. Qattan Foundation (c) Zaina Zarour | The low quality recording features a folk song that consists of an echoing male chant over punchy kick and snare hits, wooden percussion, addictive strings and brass melodies and simple bass. It sounds traditional, addictive, passionate and energetic. The recording is noisy and in mono. | 2014-04-25T11:45:31Z | balletsCdelaB | In 2006, KVS, les ballets C de la B and the A.M. Qattan Foundation launched a series of workshops with young Palestinian performing artists. Now, Koen Augustijnen, Rosalba Torres (les ballets C de la B) and Hildegard De Vuyst (KVS) present the dance production Badke, for which they work with ten Palestinian performers, young autodidacts from various disciplines including contemporary dance, hip hop, circus, etc. The term 'badke' is a distortion of 'dabke', a Palestinian folk dance. The performance starts out from the popular variant: the people's social, festive dabke. The performers go on to confront this locally rooted dance with elements from worldwide pop (dance) culture. Badke becomes a quest for a dabke that not only conveys the unique Palestinian desire to 'belong somewhere', but also the wish to be part of a world beyond that. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "folk", "echoing male chant", "punchy snare", "punchy kick", "addictive strings melody", "addictive brass melody", "traditional", "addictive", "passionate", "wooden percussions", "simple bass", "energetic"] | 4 | kMmjr8deHis | 4312 | |
♫ ♪ ♫ Irish Traditional Music ♪ ♫ ♪ ~ Matt Molloy & Donal Lunny | The low quality recording features a traditional song that consists of a breathy flute melody playing over wide acoustic guitar chords. It sounds addictive, joyful and passionate. | 2010-11-14T21:28:51Z | DJFozter | Two greats play two fine Irish reels. Tune #1 Master Crowley's Reel Tune #2 Roscommon Reel | ["Wind instrument, woodwind instrument", "Flute"] | ["low quality", "traditional", "wide acoustic guitar chords", "breathy flute melody", "addictive", "joyful", "passionate"] | 4 | nXfqAzdu8IY | 4548 | |
Ghadoli Bhar Aayee Aan | Geet Shagna De | Punjabi Marriage Ceremony Songs | Popular Wedding Music | The low quality recording features a traditional song sung by harmonizing female vocals and followed by wooden percussion, short flute licks and mellow piano chords. It sounds addictive and passionate. | 2012-03-18T14:50:28Z | 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. . All Punjabi Songs / Punjabi Music By Catrack is Available On I-Tunes, Spotify, Rhapsody, Nokia, emusic, Google Music, Amazon & Sound Cloud. 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 for All our Platforms, including Heeroz OTT, Kindly Visit: http://www.catrack.com | ["Singing", "Folk music", "Music", "Wedding music", "Middle Eastern music", "Song"] | ["low quality", "traditional", "harmonizing female vocals", "wooden percussions", "short flute licks", "addictive", "mellow piano chords", "passionate"] | 4 | ucSF9NIxK8A | 5128 |
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;