musiccaps_details (view)
1 row where search matches "guitar", musiccaps_aspects contains "exciting" and musiccaps_aspects contains "latin inspired" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- accordion 1
- acoustic guitars 1
- dance 1
- exciting · 1 ✖
- flamenco style guitar playing 1
- folk inspired 1
- french inspired 1
- latin inspired · 1 ✖
- marimba 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 3 ✖
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 |
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;