musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "mellow" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- live performance · 3 ✖
- low quality 3
- mellow · 3 ✖
- noisy 3
- soft 2
- arpeggiated acoustic guitar melody 1
- classical 1
- concert hall 1
- easygoing 1
- emotional 1
- mono 1
- opera 1
- passionate 1
- passionate female vocal 1
- plucked harp melody 1
- plucked strings melody 1
- reverberant 1
- sustained string melody 1
- tuba melody 1
- unbalanced stereo image 1
musiccaps_names (array) 7 ✖
- Brass instrument 1
- French horn 1
- Harp 1
- Music 1
- Opera 1
- Pizzicato 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dame Kiri Te Kanawa sings "The Virgin Washes the Swaddling" | The low quality recording features a live opera performance sung by passionate female vocalists and followed by sustained and plucked strings melody. The recording is very noisy and the stereo image is unbalanced, since the audio from the left channel is occasionally cut out. It sounds emotional, mellow and passionate. | 2008-11-09T05:47:07Z | Dame Kiri Lover | Dame Kiri Te Kanawa sings "The Virgin Washes the Swaddling" (John Dobbs; Traditional arr. Colin Matthews). With Philharmonia Orchestra, Carl Davis / conductor. Recorded at Barbican Center, London, UK, 1988. | ["Singing", "Music", "Opera"] | ["low quality", "noisy", "live performance", "opera", "sustained string melody", "plucked strings melody", "mellow", "passionate female vocal", "unbalanced stereo image", "passionate", "emotional"] | 4 | ADxuhHNZVCc | 1087 | |
Suite # 1 in G Major, BWV 1007 by Johann Sebastian Bach / arranged for horn & tuba | The low quality recording features a live performance of a classical song and it consists of tuba melody. It sounds mellow, soft and reverberant, as it was recorded in a huge concert hall. The recording is a bit noisy. | 2014-01-21T21:02:22Z | Sérgio Carolino | Johann Sebastian Bach Suite # 1 in G Major, BWV 1007 arranged by Tony Rickard for Horn & Tuba Jeff Nelsen, horn Sérgio Carolino, bass tuba Live at the FEUP Auditorium, December 2.2013 | ["Brass instrument", "French horn"] | ["low quality", "tuba melody", "reverberant", "mellow", "noisy", "soft", "concert hall", "classical", "live performance"] | 4 | G7pD1K3jYg4 | 1693 | |
MARCELO ROJAS (ARPISTA PARAGUAYO). Primer Festival Mundial del Arpa en Paraguay | The low quality recording features a live performance of an arpeggiated acoustic guitar melody and plucked harp melody. It sounds mellow, soft, easygoing and the recording is really noisy and in mono. | 2011-01-30T02:08:49Z | ArpaFolklorica | www.musicajarocha.com . Primer Festival Mundial del Arpa en Paraguay (Asunción, Paraguay, 2007). Una presentación de ITAIPU Binacional. Organizado por: Municipalidad de Asunción; Despacho de la Primera Dama de la Nación; REPADEH. Con el patrocinio de: UNESCO. Producción General: scappini lamarca, oficina de arte. Idea original: Rito Pedersen. Producción ejecutiva: Ana Scappini. Producción artística: Marlene Sosa Lugo. Dirección artística: César Cataldo. Coordinación artística: Luis Álvarez. Producción periodística: Marlene Sosa Lugo y Felipe Vallejos. Coordinación de clases magistrales: Lisandro Cardozo. Fotografías: Rodolfo Ramos, archivo de los artistas. Diseño e imagen: Noelia Pérez, Rocío Acosta y Luis Correa. Asistente de producción: María de Lourdes Sosa. Escenografía: Carlos Bracho. Iluminación: CF eventos. Sonido: Publicidad Martínez. Secretaría Nacional de Cultura: Bruno Barrios. Secretaría Nacional de Turismo SENATUR: Liz Crámer Campos, Laura Campuzano, Carmen Silva, Gianina Riboldi y Asunción Azcona. Centro Cultural de la Ciudad: Fernando Pistilli, Luis Szarán, Clotilde Cabral y Gilda Medina. Teatro Municipal "Ignacio A. Pane": Teresita Escobar. Producción y Realización Audiovisual: móvere. Dirección: Juana Miranda. Producción: Noemí Vega. Coordinación Técnica: Carlos Molina. Asistencia Técnica: Armando Aquino. Camarografía: Ever Alvarenga, René Santacruz, Agu Netto, Juana Miranda y Antoliano Villagra. Imágenes de archivo: "Arpa Paraguaya" -- Gabriel Sosa. Sonido: Carlos Molina. Montaje: Armando Aquino: Post-producción: Carlos Molina. | ["Harp", "Pizzicato"] | ["low quality", "plucked harp melody", "arpeggiated acoustic guitar melody", "noisy", "mono", "live performance", "mellow", "soft", "easygoing"] | 4 | hm0SeoNSGkc | 4139 |
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;