musiccaps_details (view)
2 rows where musiccaps_aspects contains "western classical" and musiccaps_names contains "Country" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- western classical · 2 ✖
- animated 1
- beseeching 1
- bow stringed 1
- brass band 1
- bright 1
- cajun music 1
- classical music 1
- country music 1
- emotional 1
- emphatic vocals 1
- ethereal 1
- expressive vocals 1
- fast tempo 1
- female vocalist 1
- fiddle 1
- four stringed instrument 1
- harp 1
- high notes 1
- high pitched 1
- imploring 1
- instrumental 1
- intense cello 1
- lilting melody 1
- lively 1
- melodious 1
- opera 1
- opera singer 1
- orchestra 1
- passionate 1
- percussion 1
- pleading 1
- slow tempo 1
- soprano 1
- spirited 1
- story telling 1
- string instrument 1
- violin 1
- violins 1
musiccaps_names (array) 7 ✖
- Country · 2 ✖
- Music 2
- Bowed string instrument 1
- Musical instrument 1
- Opera 1
- Traditional music 1
- Violin, fiddle 1
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 | |
Dewey Balfa - Jai Ete Au Bal - Awesome Fiddlesticks | This music is a lively fiddle instrumental. The tempo is fast with a percussion accompaniment. The music is spirited, vibrant, enthusiastic,cheerful, happy , merry and sunny. This music is Country Folk. | 2008-02-03T02:16:58Z | Paul | Clip is taken from Yasha Aginsky's documentary "Les Blues de Balfa". It is an AWESOME film I would HIGHLY recommend. Dewey Balfa and his nephew Tony Balfa preforming Jai Ete Au Bal (I Went To The Dance). | ["Country", "Traditional music", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "fast tempo", "fiddle", "string instrument", "cajun music", "spirited", "bright", "melodious", "violin", "western classical", "four stringed instrument", "high pitched", "bow stringed", "country music", "lively", "animated", "percussion", "spirited"] | 7 | UFyOGqmITjM | 2901 |
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;