musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "symphonic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental 2
- slow tempo · 2 ✖
- symphonic music · 2 ✖
- art music 1
- bow stringed instrument 1
- chamber music 1
- classical music 1
- flute melody 1
- french composer 1
- french composition 1
- french horn 1
- french music 1
- harpsichord accompaniment 1
- horns fading away 1
- keyboard instrument 1
- no voice 1
- orchestral music 1
- plucked string instrument 1
- rich 1
- violin harmony 1
- western classical 1
- wind instrument 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rameau - Pièces de clavecin en concert N° 5 (La Cupis) / Il Giardino Armonico | This music is a Western classical piece. The tempo is slow with a lilting harpsichord melody, flute harmony and violin accompaniment. The music is classical, serene, splendid, uplifting, lush, melancholic, pensive, dreamy symphonic music. | 2008-04-01T06:59:22Z | protestant7 | ※ Better than / Please, click here (watch in high quality - 480p) ※ http://youtube.com/watch?v=8kH-dzSBthI&fmt=18 Jean-Philippe Rameau (1683~1764) - Pièces de clavecin en concerts, 1741 - Concert n° 5 en ré mineur 2. La Cupis Il Giardino Armonico flûte traversière: Giovanni Antonini violon: Enrico Onofri viole de gambe: Vittorio Ghielmi clavecin: Ottavio Dantone Directed by Giovanni Antonini Performed by Il Giardino Armonico (On period instruments) from the DVD ' Music of The French Baroque ' | ["Wind instrument, woodwind instrument", "Flute"] | ["instrumental", "slow tempo", "western classical", "symphonic music", "chamber music", "art music", "art music", "harpsichord accompaniment", "flute melody", "violin harmony", "western classical", "classical music", "keyboard instrument", "plucked string instrument", "wind instrument", "bow stringed instrument", "rich", "french composition", "french composer", "french music"] | 7 | 8kH-dzSBthI | 940 | |
Fanfare for the Uncommon Woman No.3 | This symphonic song features french horns playing in harmony. The notes played are descending and they finally fade away. There are no other instruments in this song. There are no voices in this song. This song can be played in a dream sequence in a movie. | 2014-06-29T13:00:00Z | Masahito Kuramoto | Fanfare for the Uncommon Woman No.3 - World Premiere Joan Tower Carnegie Hall Centennial Gala May 05, 1991 Carnegie Hall - New York, NY Choir 1 - Members of New York Philharmonic (aka Principal Brass) Philip Smith, trumpet George Coble, trumpet Philip Myers, horn Joseph Alessi, trombone Warren Deck, tuba Choir 2 - Empire Brass Rolf Smedvig, trumpet Jeffrey Curnow, trumpet Eric Ruske, horn Scott Hartman, trombone Samuel Pilafian, tuba Zubin Mehta, conductor | ["Brass instrument", "French horn"] | ["orchestral music", "french horn", "symphonic music", "slow tempo", "horns fading away", "instrumental", "no voice"] | 0 | hnlVKC7rxdg | 4141 |
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;