musiccaps_details (view)
2 rows where musiccaps_aspects contains "fresh" and musiccaps_aspects contains "live performance"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- fresh · 2 ✖
- live performance · 2 ✖
- acoustic guitar accompaniment 1
- bouncy 1
- classical music 1
- club music 1
- crowd cheering 1
- crowd hooting 1
- energetic 1
- enthusiastic 1
- female singer 1
- fresh punchy 1
- funky 1
- funky bass line 1
- gig 1
- harpsichord 1
- keyboard harmony 1
- light 1
- live recording 1
- lucid vocals 1
- magical 1
- medium tempo 1
- perky vocals 1
- pop 1
- punchy 1
- slick drumming 1
- soothing 1
- sound of chatter 1
- spirited 1
- upbeat groove 1
- viola da gamba 1
- whimsical 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Classical music 1
- Harpsichord 1
- Musical instrument 1
- Piano 1
- Singing 1
- Soul music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 |
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;