musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical", musiccaps_aspects contains "orchestra" and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- classical · 3 ✖
- orchestra · 3 ✖
- allegro 1
- allergissimo 1
- arpeggiated strings melody 1
- baroque 1
- captivating 1
- cello 1
- chamber music 1
- cinematic 1
- concert 1
- delicate 1
- dynamic 1
- electrifying 1
- emotional 1
- enchanting 1
- energetic orchestra drums 1
- english dance 1
- enthralling 1
- epic 1
- exquisite 1
- extravagant 1
- fast tempo 1
- floor crackling sounds 1
- instrumental 1
- italian classical 1
- live audience 1
- live performance 1
- low quality 1
- mellow brass melody 1
- merry 1
- noisy 1
- paino accompaniment 1
- passionate 1
- pulsating 1
- shimmering brass melody 1
- soft strings melody 1
- spectacular 1
- symphony 1
- viola 1
- violin solo 1
- violin symphony 1
- woodwinds 1
musiccaps_names (array) 5 ✖
- Orchestra · 3 ✖
- Classical music 1
- Music 1
- Musical instrument 1
- Timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tomomi Nishimoto - Tchaikovsky : Symphony No.6 「Pathétique」3rd Mov | The Classical song features a dynamic arrangement of energetic orchestra drums, woodwinds, arpeggiated strings melody and shimmering brass melody. It sounds cinematic and epic - like a background movie soundtrack. | 2009-09-05T15:16:42Z | CLASSICsungtaek | [ Pyotr Ilyich Tchaikovsky ] - Symphony No.6 in B minor Op. 74「Pathétique」 III. Allegro molto vivace Tchaikovsky Foundation Russian Symphony Orchestra Tomomi Nishimoto, conductor | ["Timpani", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical", "dynamic", "orchestra", "energetic orchestra drums", "woodwinds", "arpeggiated strings melody", "shimmering brass melody", "cinematic", "epic"] | 4 | HQb2jhmw1BE | 1800 | |
Antonio Vivaldi Concerto for Violin in D minor 'Per Pisendel' RV 242 | This music is a rich Italian Classical Orchestra. The tempo is fast with a symphonic orchestra with a rich ,animated violin solo, complete with violin, cello viola , flute and piano accompaniment . This music is a sonic treat. It is rich, expressive, exquisite, spectacular, enthralling and captivating. This music is a Baroque classical. | 2011-12-10T06:57:27Z | Ahmed Barod | ["Orchestra"] | ["instrumental", "fast tempo", "orchestra", "allergissimo", "allegro", "symphony", "violin symphony", "violin solo", "italian classical", "violin solo", "cello", "viola", "classical", "exquisite", "delicate", "merry", "enchanting", "captivating", "enthralling", "baroque", "english dance", "chamber music", "extravagant", "spectacular", "pulsating", "electrifying", "live performance", "live audience", "concert", "paino accompaniment"] | 7 | adHhqDnyZv8 | 3561 | ||
「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 |
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;