musiccaps_details (view)
5 rows where musiccaps_aspects contains "orchestra", musiccaps_aspects contains "passionate" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- low quality 5
- orchestra · 5 ✖
- passionate · 5 ✖
- emotional 3
- live performance 3
- noisy 3
- classical 2
- dynamic 2
- mono 2
- muffled 2
- easygoing 1
- epic 1
- female opera vocal 1
- floor crackling sounds 1
- loud brass section melody 1
- mellow brass melody 1
- mellow woodwinds melody 1
- metallic percussive foley 1
- muddy 1
- muffled percussion 1
- opera 1
- powerful 1
- quiet 1
- reverberant 1
- shimmering cymbals 1
- soft strings melody 1
- suspenseful violin melody 1
- sustained brass melody 1
- sustained strings melody 1
- sustained strings section 1
- wide french horn melody 1
- wide strings melody 1
musiccaps_names (array) 6 ✖
- Orchestra 3
- Brass instrument 1
- French horn 1
- Music 1
- Opera 1
- String section 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Star Trek Suite | The low quality recording features a live performance of an orchestra playing sustained brass melody, shimmering cymbals and sustained strings melody. It sounds muddy and muffled, as it was probably recorded with a poor quality microphone, but also passionate. The recording is noisy and in mono. | 2007-11-18T07:49:15Z | George Yefchak | "Star Trek Through the Years" (excerpts). Nova Vista Symphony conducted by George Yefchak while wearing a Starfleet Commander uniform (sciences division, circa 2373). | ["Orchestra"] | ["live performance", "low quality", "orchestra", "muffled", "muddy", "mono", "noisy", "sustained brass melody", "shimmering cymbals", "sustained strings melody", "passionate"] | 4 | Y8plCTF8xsY | 3258 | |
Aleko - Aria Of Zemfira | The low quality recording features a female opera vocalist singing over sustained strings. There is tinny metallic percussive foley at one point in the loop. It is a bit quiet, but it also sounds dynamic, emotional and passionate. | 2010-12-11T22:14:16Z | Joe Fenech | ["Music", "Opera"] | ["low quality", "orchestra", "opera", "female opera vocal", "sustained strings section", "quiet", "metallic percussive foley", "passionate", "emotional", "dynamic"] | 4 | bxoJOfGx3hM | 3668 | ||
Ennio Morricone Vienna 12.12.2007 (part 4) | The low quality recording features a live performance of an orchestra and it consists of loud brass melody, mellow woodwinds melody, suspenseful violin melody and muffled percussion. It sounds epic, powerful and passionate. The recording is in mono, a bit noisy and it is reverberant as it was performed in a large concert hall. | 2008-08-12T15:10:07Z | Tomáš Vlček | Ennio Morricone conducts his own music at Vienna Stadthalle - Ecstasy of gold (reprise). | ["String section", "Orchestra"] | ["low quality", "live performance", "noisy", "mono", "reverberant", "orchestra", "muffled", "epic", "powerful", "passionate", "suspenseful violin melody", "muffled percussion", "loud brass section melody", "mellow woodwinds melody"] | 4 | cJ80eZY03Yg | 3697 | |
「First Suite in Eb 1」(Holst) izumo daiichi Wind orchestra | The low quality recording features an orchestra playing classical music and it consists of a mellow brass melody and soft strings melody. There are also some floor crackling sounds, while the recording is noisy itself. It sounds passionate and emotional. | 2007-10-26T02:11:59Z | kanzennanoguso | Holst 「First Suite in Eb 1」 izumo 1st Junior High School Wind orchestra HOUKOKU ENSOUKAI | ["Orchestra"] | ["low quality", "noisy", "orchestra", "classical", "mellow brass melody", "soft strings melody", "floor crackling sounds", "passionate", "emotional"] | 4 | dqQgzsNpwoQ | 3817 | |
Baborak · Dohr · de Leval Jezierski · Willis · Rattle · Berliner Philharmoniker / Schumann | The low quality recording features an orchestral live performance of a classical song and it contains a wide french horn melody playing over a wide string melody. It sounds easygoing, passionate, dynamic and emotional. | 2011-02-15T01:54:23Z | tophornmusic | Watch the complete performance: http://www.digitalconcerthall.com/en/concert/18 Berliner Philharmoniker Sir Simon Rattle Radek Baborak, Stefan Dohr, Stefan de Leval Jezierski, Sarah Willis Robert Schumann: Concert Piece for four horns in F major | ["Brass instrument", "French horn"] | ["low quality", "classical", "orchestra", "live performance", "dynamic", "wide french horn melody", "wide strings melody", "easygoing", "passionate", "emotional"] | 4 | x14jW4c8YnQ | 5298 |
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;