musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "spirited" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 3 ✖
- passionate 3
- spirited · 3 ✖
- instrumental music 2
- amateur play 1
- bad audio quality 1
- bells ringing 1
- building tension 1
- classical music 1
- country music 1
- documentary soundtrack 1
- dramatic music 1
- duel music 1
- dyi 1
- eerie 1
- exciting 1
- female opera singer 1
- french horn playing softly 1
- guitar lead 1
- gunslingers 1
- home video 1
- learner 1
- legato playing 1
- man narrates technique 1
- medium tempo 1
- movie soundtrack 1
- movie theme song 1
- music box tones 1
- narration 1
- no other instrumentation 1
- …
musiccaps_names (array) 4 ✖
- Brass instrument · 3 ✖
- French horn 1
- Saxophone 1
- Trombone 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 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 | |
Rotor Valve Care | A man narrates a repair technique for a French horn. The song plays at medium tempo, with a brass section playing in an orchestra. The song is medium tempo and plays a soundtrack for the repair video. | 2009-03-30T16:31:11Z | gemstonemusicaltv | Richard Barth of W. Nirschl, Weril and P. Weingrill Brass demonstrates how to care for rotor valves. | ["Brass instrument", "French horn"] | ["narration", "man narrates technique", "repair video soundtrack", "exciting", "emotional", "documentary soundtrack", "tragic", "passionate", "spirited", "youtube video", "dyi", "youtube repair video", "western classical music", "philharmonic orchestral music", "french horn playing softly"] | 1 | wQhycJsKSPE | 5265 |
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;