musiccaps_details (view)
5 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "traditional" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- passionate · 5 ✖
- traditional · 5 ✖
- low quality 4
- emotional 3
- mono 3
- noisy 3
- passionate female vocal 3
- wooden percussions 3
- soulful 2
- acoustic guitar chords 1
- addictive 1
- ambient crowd noise 1
- brass instruments harmony 1
- breathy flute melody 1
- child singer 1
- cowboys 1
- cymbals crashing 1
- harmonizing female vocals 1
- joyful 1
- keys chords 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- mellow piano chords 1
- people talking 1
- plucked strings melody 1
- romantic 1
- school concert 1
- shimmering shakers 1
- …
musiccaps_names (array) 12 ✖
- Music 5
- Singing · 5 ✖
- Carnatic music 2
- Middle Eastern music 2
- Song 2
- Folk music 1
- Music of Asia 1
- Music of Bollywood 1
- Musical instrument 1
- Traditional music 1
- Vocal music 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 |
---|---|---|---|---|---|---|---|---|---|---|
Forida Parvin - Ekta Bod Haoya | The low quality recording features a traditional song that consists of a passionate female vocal singing over breathy flute melody, wooden percussion, keys chords and acoustic guitar chords. It sounds soulful, passionate and the recording is in mono and noisy. | 2009-12-30T16:18:08Z | ChoncholaMon | Forida Parvin - Ekta Bod Haoya | ["Singing", "Carnatic music", "Music of Asia", "Music"] | ["low quality", "noisy", "mono", "breathy flute melody", "passionate female vocal", "wooden percussions", "acoustic guitar chords", "keys chords", "soulful", "traditional", "passionate"] | 4 | 6807299U5eg | 727 | |
Sebastien De La Cruz, EL CHARRO DE ORO, EL PASTOR | A child singer sings this passionate Latin melody. The song is slow tempo with steady drumming, tambourine percussions, a strong bass line and brass instruments playing countermelody. The song is spirited and passionate. The song has poor audio quality and has ambient crowd noises. | 2009-12-04T04:56:07Z | Juan De La Cruz | MARIACHI VARGAS EXTRAVAGANZA 2009 EL PASTOR, 7YR OLD WOW, THIRD PLACE VOCAL FINALIST | ["Singing", "Music", "Musical instrument", "Vocal music"] | ["child singer", "latin music", "ambient crowd noise", "steady bass line", "cymbals crashing", "people talking", "trumpets blaring", "school concert", "latin folk music", "latin folk music", "traditional", "cowboys", "latin country music", "yodelling music", "spirited", "passionate", "romantic", "emotional", "brass instruments harmony", "slow tempo", "latin brass band"] | 1 | 6C0HoQe4Y-Y | 734 | |
VERY POPULAR OLD PAKISTANI PUNJABI SONG SINGER MADAM NOOR JAHAN YouTube | The low quality recording features a traditional song that consists of passionate female vocal singing over sustained string melody, wobble bass, wooden percussive elements and shimmering shakers. It is a bit noisy, in mono and it sounds vintage, passionate, emotional and soulful. | 2013-06-19T20:26:26Z | KHALIQ Husson | ["Singing", "Carnatic music", "Music", "Middle Eastern music", "Song", "Music of Bollywood"] | ["wobble bass", "wooden percussive elements", "shimmering shakers", "passionate female vocal", "sustained strings melody", "traditional", "vintage", "noisy", "low quality", "passionate", "emotional", "soulful", "mono"] | 4 | 7_Sr2zv1sQc | 862 | ||
Jamilah sa'ad yemen song | The low quality recording features a passionate female vocalist singing over wooden percussion, synth lead melody and plucked strings melody playing in the background. It sounds passionate, emotional, joyful and traditional. | 2009-01-27T15:22:28Z | girhish | Jamilah sa'ad | ["Singing", "Traditional music", "Music"] | ["low quality", "mono", "noisy", "passionate female vocal", "wooden percussions", "synth lead melody", "plucked strings melody", "passionate", "emotional", "joyful", "traditional"] | 4 | gNpzuFPu6q8 | 4027 | |
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;