musiccaps_details (view)
3 rows where musiccaps_aspects contains "orchestral" and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- orchestral · 3 ✖
- strings 2
- brass-section 1
- cartoons 1
- cello 1
- cinematic 1
- clarinets 1
- classical music 1
- emotional 1
- flutes 1
- happy 1
- low cello melody 1
- low quality 1
- medium tempo 1
- no vocals 1
- oboes 1
- passionate 1
- positive 1
- timpanis 1
- upright basses 1
- violins 1
- wide violin melody 1
musiccaps_names (array) 7 ✖
- Classical music · 3 ✖
- Music 3
- Musical instrument 2
- Orchestra 2
- Bowed string instrument 1
- Timpani 1
- Violin, fiddle 1
youtube_published (date) 3 ✖
- 2009-01-11 1
- 2010-03-23 1
- 2013-03-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Stravinsky: Le Sacre du printemps / Rattle · Berliner Philharmoniker | This piece is full of orchestra instruments playing a sequence full of rapid changes with a little darker emotions. Sounding gigantic, dangerous and heroic. This song may be playing at a live concert or for a scene in a movie. | 2013-03-06T10:22:40Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/3401/?a=youtube&c=true Igor Stravinsky: Le Sacre du printemps (revised version from 1947) / Sir Simon Rattle, conductor · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 9 November 2012 The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Timpani", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["orchestral", "brass-section", "flutes", "strings", "timpanis", "upright basses", "oboes", "cinematic", "medium tempo"] | 6 | 6F8qv0JBWkE | 737 | |
Schubert - Marche Militaire Nr 1 (arr P Breiner) - Best-of Classical Music | Classical music features a variety of string instruments that play a bright melody. The sound is big and orchestral. A clarinet plays a high-pitched melody in the foreground. The atmosphere of the song is positive and happy. | 2010-03-23T15:55:12Z | TheFbiFilesRepeat | The audio is under "Public Domain" The public domain is an intellectual property designation for the range of content that is not owned or controlled by anyone. These materials are public property, and available for anyone to use freely (the "right to copy") for any purpose. ...50 years from creation year or 70 years after his death http://en.wikipedia.org/wiki/Public_domain | ["Music", "Classical music"] | ["classical music", "strings", "violins", "clarinets", "cello", "happy", "positive", "orchestral", "no vocals"] | 5 | axb48YrvRmw | 3589 | |
Mozart 'Dissonance' Quartet K.465 - 1st Movement | The low quality recording features an orchestral music played by wide violin melody and low cello. It sounds emotional and passionate - like something you would hear in old cartoons. | 2009-01-11T07:47:23Z | Calder Quartet | Calder Quartet live at the Colburn School December 5th 2008 | ["Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["low quality", "wide violin melody", "low cello melody", "emotional", "passionate", "orchestral", "cartoons"] | 4 | mjZylz3nCwQ | 4489 |
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;