musiccaps_details (view)
1 row where musiccaps_aspects contains "french horn" and musiccaps_aspects contains "no voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 7 ✖
- french horn · 1 ✖
- horns fading away 1
- instrumental 1
- no voice · 1 ✖
- orchestral music 1
- slow tempo 1
- symphonic music 1
musiccaps_names (array) 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;