musiccaps_details (view)
4 rows where musiccaps_aspects contains "lilting melody" and musiccaps_author = 7
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Phantom of the Opera AND Music of the Night - Boyertown High School | A female vocalist sings this soprano solo. The tempo is slow with a classic orchestral accompaniment of violin harmony, an intense incessant cello melody, brass instrument and organ. The song is an intense, emotional, beseeching, sad, and imploring classic opera . | 2011-10-15T23:21:13Z | BASHMusical | This is from Boyertown Area Senior High School's fantastic 2011 production of Andrew Lloyd Webber's "The Phantom of the Opera." | ["Country", "Music", "Opera"] | ["female vocalist", "slow tempo", "soprano", "intense cello", "beseeching", "imploring", "classical music", "western classical", "opera singer", "violins", "brass band", "story telling", "passionate", "emotional", "pleading", "opera", "orchestra", "lilting melody", "expressive vocals", "emphatic vocals", "ethereal", "high notes", "harp"] | 7 | -w12aSkQ9No | 101 | |
| SRPSKE RASE PASA-Serbian Dog Breeds | A male vocalist sings this intense melody in a foreign language.The tempo is slow with a keyboard and organ accompaniment that is burgeoning as the song progresses. The vocals are eloquent, emphatic, persuasive and lilting and the vibe of the song is mellow, persuasive, passionate, emotional and appealing. | 2014-06-08T08:25:31Z | Miroslav Visnjic | http://www.srpskipas.com/ | ["Mantra", "Music"] | ["male singer", "slow tempo", "foreign language", "passionate", "burgeoning music", "eloquent vocals", "emphatic", "persuasive", "sad vibe", "keyboard harmony", "church organ", "minimalist", "lilting melody", "soft", "mellow", "emotional", "passioante", "intense"] | 7 | 2dyxjGTXSpA | 393 | |
| Afghan song Pashto music Zarsanga beautiful song | A female vocalist sings this lilting Folk song in a foreign language. The tempo is slow with an Oud accompaniment, violin harmony, tabla and dhol rhythm. The performance is live with ambient sounds. The song is simple, sweet, charming and lilting. | 2009-01-14T16:53:16Z | Muhammad Bashir | دوى څومره زوره وردي هريو کاريې دى په وس کې ياران له ما بهتر دي ځکه ښکار يې دى په وس کې ها ښکلې جادوګره کرشمې لري منګول کې اقرار يې دى په لاس کې او انکاريې دى په وس کې رمې رمې ښکلا يې په سازونو کې ده نغښتې شپونکى يار مې اتل دى يکه زار يې دى په وس کې څپې د سين به سپيني وي خو داترې کمه نه ده څارونکى بختور دى چې دا څار يې دى په وس کې Baby girl just look at me And then you'll see How much you mean to me I want only you BooBee... I dream that i could hold you now I would do anything but i dunno how I hope that you'll be mine again Cuz i wanna erase forever that pain. Its too bad that you cant see In spite of everything i tell you How i need you next to me And how much i love you | ["Traditional music", "Music"] | ["female vocalist", "slow tempo", "foreign language", "live performance", "ambient sounds", "lilting melody", "afghan song", "afghan music", "simple", "percussive instruments", "dhol", "tabla", "rhythmic oud", "violin harmony", "classical", "folk song", "folk music", "middle eastern music", "middle eastern influences", "charming"] | 7 | 5FbQu7QTme0 | 647 | |
| How to Play the Irish Tenor Banjo : Banjo Basics | This music is an enthusiastic Irish tenor Banjo instrumental. The tempo is fast with a lively, upbeat, soothing, emphatic, twangy, sweet, rich, and engaging with traditional and folksy groove. | 2013-07-09T01:02:01Z | ehow | Subscribe Now: http://www.youtube.com/subscription_center?add_user=ehow Watch More: http://www.youtube.com/ehow The tenor banjo is tuned in straight fifths. Find out how to play the Irish tenor banjo with help from an experienced music professional in this free video clip. Expert: Peter S. Kohman Contact: www.retrofret.com Bio: Peter Kohman became interested in old banjos and guitars at the age of 16. Filmmaker: B. Michael Sullivan Series Description: Owning a banjo requires you to both know how to play it and know how to take excellent care of it to preserve it for the future. Find out about banjo basics with help from an experienced music professional in this free video series. | ["Banjo", "Music", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["instrumental", "fast tempo", "banjo harmony", "sweet", "rich", "dulcet", "stringed instrument", "twangy", "engaging", "empahtic", "dominant", "solo", "irish banjo", "irish style banjo", "lively", "spirited", "engaging", "captivating", "pleasant", "lilting melody", "strong melodic lines", "banjo solo", "banjo lead", "tenor banjo", "four stringed instrument", "traditional music", "folk music", "classical music"] | 7 | JYYfw3id3ek | 2017 |
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;