musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "joyful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- fast tempo · 3 ✖
- happy 3
- instrumental · 3 ✖
- joyful · 3 ✖
- vivacious 2
- ambient outdoor sounds 1
- animated 1
- celebratory 1
- cheerful 1
- christmas carols 1
- christmas cheer 1
- distorted music 1
- energetic 1
- enthusiastic 1
- festive 1
- guiro 1
- guiro accompaniment 1
- hand percussion 1
- harp melody 1
- inferior audio quality 1
- jingle bells 1
- latin dance music 1
- latin folk 1
- latin influence music 1
- latin instrumental 1
- latin music 1
- latin regional music 1
- live music 1
- live performance 1
- lively acordion 1
- lively cheerful 1
- male vocalisation 1
- peppy 1
- piano melody 1
- santa claus 1
- scraper instrument 1
- shakers 1
- spirited 1
- spirited congas 1
- static 1
- ukelele harmony 1
- world music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Christmas Music - Jingle Bells - Piano Solo | This music is instrumental. The tempo is fast with an animated piano harmony of Jingle Bells. The music is upbeat, cheerful, happy, fun, joyful and vivacious. | 2007-12-11T03:46:19Z | Billy Pollard | Billy Pollard on his old Ragtime Piano, Strolling Down Memory Lane, Christmas 2006 Program, Billy & Willie Pollard's Country Gospel TV Program, http://billyandwillie.tripod.com | ["Jazz", "Music"] | ["instrumental", "fast tempo", "piano melody", "jingle bells", "vivacious", "christmas carols", "happy", "christmas cheer", "santa claus", "animated", "cheerful", "peppy", "cheerful", "joyful"] | 7 | 5mmUQUwr6tI | 693 | |
Carlos Alvarado y José Gregorio López: "Canción Recia" | This music is instrumental. His tempo is fast with a lively ukelele rhythm, melodious harp harmony and shaker beats with male vocalisation. This clip is the beginning of a song with latin music influences. The music is a lively, spirited, happy, cheerful, warm, energetic latin folk song. | 2009-02-01T22:59:40Z | MingaTV | Desde el llano venezolano, la energía de su música, el talento de sus artistas. | ["Harp", "Pizzicato"] | ["instrumental", "fast tempo", "ukelele harmony", "harp melody", "shakers", "hand percussion", "lively cheerful", "happy", "male vocalisation", "latin folk", "latin instrumental", "latin influence music", "vivacious", "happy", "joyful", "enthusiastic", "energetic"] | 7 | SsVc1TAVsSc | 2794 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 |
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;