musiccaps_details (view)
3 rows where musiccaps_aspects contains "orchestra", musiccaps_aspects contains "violins" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- orchestra · 3 ✖
- violins · 3 ✖
- brass band 2
- cello 2
- intense 2
- slow tempo 2
- viola 2
- acoustic drums 1
- bass drum 1
- bell ringing 1
- beseeching 1
- brass instruments 1
- burgeoning 1
- classical music 1
- dangerous 1
- deep bass 1
- droning 1
- emotional 1
- emphatic vocals 1
- ethereal 1
- expressive vocals 1
- female vocalist 1
- grim 1
- harp 1
- high notes 1
- imploring 1
- instrumental 1
- intense cello 1
- lilting melody 1
- lively piano 1
- opera 1
- opera singer 1
- orchestral music 1
- passionate 1
- percussions 1
- pleading 1
- serious 1
- sinister 1
- snare drums 1
- soprano 1
- story telling 1
- suspenseful 1
- symphony 1
- synced harmonies 1
- synthesiser articulation 1
- tambourine 1
- triumphant 1
- trumpets 1
- vibrations 1
- violin symphony 1
- western classical 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 | |
Titanic underwater mission by Tarim_T | This music is a grim instrumental. The tempo is slow with a Violin symphony. The deep bass of the cello to the accompaniment of a steady, droning violin melody and the sound of a ringing bell give it a very intense and serious vibe. The music is enthralling, powerful,impactful, intense, sinister, scary and anticipatory. This is an orchestral harmony. | 2011-01-24T19:13:19Z | RACCITUP | Footage of The under water expedition of Titanic and its surface searching for wreckage of ship and, interviews of the crew who were involvd in the mission. An extremely well made footage showing were titanic had sunk. | ["Music", "Scary music"] | ["instrumental", "slow tempo", "orchestra", "vibrations", "droning", "violins", "cello", "viola", "deep bass", "bell ringing", "violin symphony", "grim", "serious", "intense", "sinister", "dangerous", "suspenseful", "synthesiser articulation"] | 7 | hNKTrKk4hZs | 4099 | |
Mark Mothersbaugh - Ping Island / Lightning Strike Rescue Op | This song is an instrumental. The tempo is medium with lively trumpets, trombone ,enthusiastic percussion like the snare, cymbals and bass drum, tambourine , an intense and bright string harmony of violins, viola and cello. The music is intense, serious and is gradually building up. This is an Orchestral piece. | 2007-12-02T16:36:53Z | Evil Chicken MEDIA | The Life Aquatic with Steve Zissou-theme. On of the greatest movies ever made. If you havn't seen it; Go play with Barbie-dolls. | ["Timpani", "Music"] | ["snare drums", "trumpets", "violins", "triumphant", "acoustic drums", "tambourine", "orchestral music", "intense", "burgeoning", "synced harmonies", "bass drum", "viola", "cello", "brass band", "orchestra", "symphony", "brass instruments", "percussions", "lively piano"] | 7 | vOAXAoHtl7o | 5178 |
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;