musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical music", musiccaps_author = 3 and musiccaps_names contains "Classical music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- classical music · 3 ✖
- alto-flute 1
- brass instruments 1
- build-up 1
- cellos 1
- classical concert 1
- curiousity 1
- epic 1
- exploration 1
- fresh 1
- harpsichord 1
- impressive 1
- light 1
- live performance 1
- live recording 1
- magical 1
- recorder 1
- soothing 1
- string instruments 1
- tension building 1
- timpani 1
- trumpets 1
- uplifting 1
- viola da gamba 1
- violas 1
- violins 1
- whimsical 1
musiccaps_names (array) 12 ✖
- Classical music · 3 ✖
- Music 3
- Musical instrument 3
- Bowed string instrument 2
- Orchestra 2
- Brass instrument 1
- Cello 1
- Flute 1
- Harpsichord 1
- Piano 1
- Timpani 1
- Violin, fiddle 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 | |
Richard Strauss - Also Sprach Zarathustra (das Ziege) [Opening of 2001: A Space Goat Odyssey] | This is a classical orchestral piece. The melody played on the trumpets feels like a prelude to an important, impressive moment. This music would suit any momentous occasion - like the countdown to a rocket launch. | 2013-02-28T09:51:34Z | switchmodthree | Wait for it... :) --------------------- Source: http://www.youtube.com/watch?v=Y9QxaJLt7EA | ["Timpani", "Brass instrument", "Music", "Musical instrument", "Orchestra", "Classical music"] | ["classical music", "brass instruments", "trumpets", "timpani", "build-up", "epic", "uplifting", "impressive"] | 3 | LSaLPObrnZw | 2190 |
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;