musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- accordion · 3 ✖
- upbeat 2
- acoustic guitars 1
- cheerful 1
- dance 1
- exciting 1
- female singing quarter 1
- fiddle 1
- flamenco style guitar playing 1
- folk inspired 1
- french inspired 1
- guitar strumming 1
- happy 1
- harmonies 1
- instrumental 1
- jazz 1
- jazz guitar 1
- latin inspired 1
- live performance 1
- live recording 1
- marimba 1
- no drums 1
- poor audio quality 1
- upright bass 1
- vibrant 1
- vintage european 1
- violin solo 1
- violins 1
- walking bassline 1
- western swing 1
musiccaps_names (array) 9 ✖
- Bowed string instrument · 3 ✖
- Music 2
- A capella 1
- Classical music 1
- Harp 1
- Musical instrument 1
- Pizzicato 1
- Swing music 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 |
---|---|---|---|---|---|---|---|---|---|---|
PIXAR: la fabbrica delle emozioni | This song is vibrant, alive, exciting and fun. It features elements of inspiration from Latin and French music, as heard in the use of the flamenco guitar alongside the accordion.The song is suitable for dancing, and has a charming bounce to it. The initial part of the song builds up to the section that's most alive and layered. | 2010-07-06T14:52:35Z | fumaluca89 | PIXAR: la fabbrica delle emozioni In occasione dell'uscita nelle sale di Toy Story 3 ecco un tributo alla PIXAR che ci regala film stupendi ogni anno. Musiche: -Parte Toy Story: "Andy's birthday" + "Infinity and beyond" - Randy Newman -Parte A bug's life: "A bug's life suite" - Randy Newman -Parte Toy Story 2: "Woody's roundup" - Riders in the sky -Parte Monsters & co.: "Monsters inc." - Randy Newman -Parte Alla ricerca di Nemo: "Nemo egg" - Thomas Newman -Parte Gli incredibili: "The incredits" - Michael Giacchino -Parte Cars: "The big race" - Randy Newman -Parte Ratatouille: "End creditouilles" - Michael Giacchino -Parte WALL-E: "Eve retrieve" - Thomas Newman -Parte UP: "Up with titles" - Michael Giacchino PIXAR: factory of emotions Toy story 3 is now in theaters and here it's a video tribute to PIXAR that give us wonderfull movies every year. Music: -Toy story: "Andy's birthday" + "Infinity and beyond" - Randy Newman -A bug's life: "A bug's life suite" - Randy Newman -Toy story 2: "Woody's roundup" - Riders in the sky -Monsters inc.: "Monsters inc." - Randy Newman -Finding Nemo: "Nemo egg" - Thomas Newman -The incredibles: "The incredits" - Michael Giacchino -Cars: "The big race" - Randy Newman -Ratatouille: "End creditouilles" - Michael Giacchino -WALL-E: "Eve retrieve" - Thomas Newman -UP: "Up with titles" - Michael Giacchino Edited by fumaluca89, 2010 This project was purely non-profit and not aimed at breaking copyright laws. | ["Harp", "Pizzicato", "Bowed string instrument"] | ["exciting", "vibrant", "upbeat", "flamenco style guitar playing", "acoustic guitars", "accordion", "marimba", "latin inspired", "dance", "french inspired", "folk inspired"] | 3 | EGIeykrN4eg | 1541 | |
2013 NorthWest Western Swing Festival - The Jangles Band | An instrumental western swing group featuring a violin or fiddle solo. The upright bass lays down a steady walking bassline while two jazz guitars accompanied by strumming chords. Accordion is also present, but drums are not. | 2013-10-17T08:36:09Z | Jeanne Yearian | In this video clip, The Jangles Band performs "I'm an Old Cowhand," "Sweet Sue" and "I'm a Long, Tall Texan" at the NorthWest Western Swing Music Society's 23rd Annual Western Swing Festival, held August 8-11, 2013. Billed as Seattle's premier Western Swing Band, The Jangles entertain around the northwest. For more information, check out their website at www.mikefaast.com/bands/jangles or look for them on Facebook. The NorthWest Western Swing Music Society's annual festival and Hall of Fame induction ceremony are held on the second week-end in August, at the Auburn Eagles Club in Auburn, Washington. For more information about western swing or the western swing music societies across the United States, please visit the Society's website at www.nwwsms.com. | ["Swing music", "Music", "Bowed string instrument"] | ["fiddle", "guitar strumming", "western swing", "accordion", "violin solo", "upright bass", "jazz guitar", "violin solo", "jazz", "walking bassline", "no drums", "instrumental"] | 8 | S2u5IE0n1ws | 2735 | |
Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 |
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;