musiccaps_details (view)
2 rows where musiccaps_aspects contains "female opera singer" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional 2
- female opera singer · 2 ✖
- movie soundtrack 2
- passionate 2
- piano accompaniment 2
- bells ringing 1
- building tension 1
- cello playing 1
- conductor 1
- country music 1
- dramatic music 1
- duel music 1
- eerie 1
- guitar lead 1
- gunslingers 1
- instrumental music 1
- lilting vocals 1
- love song 1
- madly in love 1
- medium tempo 1
- movie theme song 1
- music box tones 1
- ominous 1
- operatic drama 1
- romantic 1
- sensual 1
- slow burn 1
- slow tempo 1
- soaring vocals 1
- soundtrack 1
- spirited 1
- string section harmony 1
- together forever 1
- tragic 1
- trumpets playing harmony 1
- violins 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
OUTLAWS Film | The song is an instrumental. The tempo is slow with a female operatic singer singing, piano accompaniment, bells singing, trumpets playing harmony, various percussion hits and strong bass line. The song is full of tension and sounds ominous like an impending gun fight. | 2015-09-22T08:34:40Z | Belstaff | Belstaff Films presents OUTLAWS. A surreal film within a film starring David Beckham as the Stranger - a mysterious drifter and motorcycle stuntman who is hunted by a maniacal Director seeking revenge. The film features Katherine Waterston, Cathy Moriarty and Harvey Keitel. Shot on location in Mexico, the film is written and directed by Geremy Jasper, produced by Belstaff Films and Legs (a Milk Media Company) and Executive Producer Liv Tyler. http://www.belstaff.com/outlaws | ["Brass instrument", "Trombone"] | ["instrumental music", "female opera singer", "bells ringing", "music box tones", "movie soundtrack", "guitar lead", "duel music", "country music", "slow tempo", "trumpets playing harmony", "guitar lead", "slow burn", "gunslingers", "eerie", "ominous", "building tension", "operatic drama", "dramatic music", "emotional", "spirited", "passionate", "movie theme song", "soundtrack", "piano accompaniment"] | 1 | 9HQNvz4eZPU | 988 | |
Fifty Shades Of Grey (2013) | Teaser Trailer | A female singer sings this operatic melody. The song is medium tempo with a string section playing harmony and a piano accompaniment. The song is emotional and passionate. The song is a classic western music hit and a movie soundtrack. | 2012-06-13T15:16:41Z | JLongbone | **WATCH IN HD** (NEW!! Jamie Dornan/Dakota Johnson version: https://www.youtube.com/watch?v=ddPxOJZKQmQ) **Fan made teaser** Song from trailer: http://www.youtube.com/watch?v=YBt-9LhE8ms | ["Music", "Opera"] | ["female opera singer", "medium tempo", "lilting vocals", "madly in love", "together forever", "movie soundtrack", "soaring vocals", "string section harmony", "violins", "piano accompaniment", "cello playing", "conductor", "emotional", "tragic", "passionate", "romantic", "love song", "sensual"] | 1 | TnJE6W6Z6mM | 2865 |
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;