musiccaps_details (view)
4 rows where musiccaps_aspects contains "classical music", musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- classical music · 4 ✖
- live performance 2
- violin 2
- alto-flute 1
- amateur recording 1
- cellos 1
- classical concert 1
- curiousity 1
- exploration 1
- fresh 1
- harpsichord 1
- heart-touching 1
- instrumental 1
- light 1
- live recording 1
- magical 1
- melancholic 1
- movie music 1
- orchestra 1
- recorder 1
- sentimental 1
- slightly poor quality 1
- soothing 1
- string instruments 1
- suspenseful 1
- tension building 1
- viola da gamba 1
- violas 1
- violins 1
- whimsical 1
musiccaps_names (array) 11 ✖
- Bowed string instrument · 4 ✖
- Classical music · 4 ✖
- Music 4
- Musical instrument 4
- Violin, fiddle 3
- Cello 1
- Flute 1
- Harpsichord 1
- Inside, small room 1
- Orchestra 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Klassikkuppel: Solisten, A.Vivaldi: Konzert für Blockflöte, Streicher und Basso continuo | This song elicits feelings of mystery, exploration and curiosity. It's a classical piece including violins, violas, cellos and a recorder or alto-flute. The end section builds tension and suspense - as if in a movie scene when a character is peaking curiously around new terrain. | 2012-07-30T02:21:01Z | Klassikkuppel | Antonio Vivaldi: Konzert für Blockflöte, Streicher und Basso continuo in c-Moll RV 441 Solo: M.Gloor Aus dem Konzert vom 19.04.2012, Kuppel Basel Produktion: Olivier Mueller Aufnahmen und Schnitt: Reverse.ch | ["Music", "Musical instrument", "Orchestra", "Violin, fiddle", "Classical music", "Bowed string instrument", "Flute"] | ["classical music", "classical concert", "string instruments", "violins", "cellos", "violas", "recorder", "alto-flute", "tension building", "exploration", "curiousity"] | 3 | 4vGLTrW04UE | 616 | |
Forqueray: Pièces de viole avec la basse continue | Lorenzo y Vittorio Ghielmi | This is a classical music piece played on the viola da gamba and the harpsichord. The performance is live, and the song has a refreshing, light and fun "Spring" feel to it. | 2014-12-05T11:36:32Z | FUNDACIÓN JUAN MARCH | Antoine Forqueray, competidor de Marais en los ambientes cortesanos, tuvo siempre el apoyo de Luis XIV. Fue admirado por su virtuosismo en la viola da gamba, a la que quiso trasladar la agilidad y la técnica de los violinistas italianos. Buena muestra de ello son las piezas que interpretan Vittorio y Lorenzo Ghielmi, y que proceden de su colección más conocida: las Pièces pour le viole, publicadas en 1747. Antoine Forqueray: Pièces de viole avec la basse continue (selección) Lorenzo Ghielmi, clave y Vittorio Ghielmi, viola da gamba Extracto de "El canto del cisneon", segundo cierto del ciclo “Origen y esplendor de la viola da gamba” http://www.march.es/musica/detalle.aspx?p5=11030&l=1 14 de mayo de 2014 Fundación Juan March, Madrid http://www.march.es/videos/?p0=4678&l=1 | ["Cello", "Harpsichord", "Music", "Musical instrument", "Piano", "Classical music", "Bowed string instrument"] | ["live performance", "classical music", "live recording", "viola da gamba", "harpsichord", "soothing", "whimsical", "magical", "light", "fresh"] | 3 | ECP7EJka6N8 | 1538 | |
The Red Violin Caprices, Theme, Written for Joshua Bell | This is a classical music piece. It is an instrumental piece. There is a violin playing a melancholic tune. The atmosphere is suspenseful. The quality of the recording is slightly poor. This piece could suit well during a mysterious sequence in a thriller movie. | 2008-03-31T16:01:05Z | eboyinc | Sound Sample of fine Italian Violin. Piece is an excerpt from "The Red Violin Caprices" - Theme, written John Corigliano. Joshua Bell performed this for the soundtrack of the movie, "The Red Violin" which starred Samuel L. Jackson. | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "Inside, small room"] | ["classical music", "amateur recording", "instrumental", "violin", "melancholic", "suspenseful", "movie music", "slightly poor quality"] | 9 | WCiS9IDILQg | 3073 | |
Nicola Benedetti plays Bruch at the Last Night of the Proms 2012 | This is a live performance of a classical music piece. There is an orchestra performing the piece with a violin lead playing the main melody. The atmosphere is sentimental and heart-touching. This piece could be playing in the background at a classy restaurant. | 2012-09-10T19:04:24Z | ecodef | Violin concerto No. 1 in G minor, by Bruch soloist: Nicola Benedetti conductor: Jiri Belohlavek BBC Symphony Orchestra recorded @ the Royal Albert Hall, London (8 sept. 2012) | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument"] | ["classical music", "live performance", "orchestra", "violin", "sentimental", "heart-touching"] | 9 | XmMN-6g1L8w | 3222 |
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;