musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "lively" and musiccaps_aspects contains "upbeat"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- electric guitar · 4 ✖
- lively · 4 ✖
- upbeat · 4 ✖
- bass guitar 3
- acoustic drums 2
- male vocal 2
- melodic singing 2
- accordion harmony 1
- acoustic drum 1
- animated 1
- audience clapping 1
- bongos 1
- catchy 1
- cheerful 1
- colourful 1
- complex harmonies 1
- conga 1
- contemporary traditional music 1
- dance 1
- dance groove 1
- danceable 1
- electronic reggae 1
- energetic 1
- fast tempo 1
- folk music 1
- groovy bass 1
- happy merry 1
- high-spirited 1
- instrumental 1
- keyboard 1
- latin folk 1
- loud 1
- male and female vocal 1
- party song 1
- polyrhythms 1
- pop music 1
- pop rock 1
- psychedelic 1
- raspy voice 1
- saxophone 1
- ska punk 1
- spanish language 1
- steel pan 1
- studio performance 1
- syncopated 1
- synth 1
- synthesiser arrangement 1
- trombone 1
- trumpets 1
- vivacious 1
- vivid 1
- world music 1
musiccaps_names (array) 6 ✖
- Music 4
- Ska 3
- Roll 2
- Drum kit 1
- Musical instrument 1
- Rock and roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
My SunShine ROCK'A'TRENCH cover HD 【THE FUCKIN' EVOLBAND】 | This is a pop rock music piece being performed in the studio. There is a male vocalist singing melodically in the lead. The electric guitar is playing a simple tune with the bass guitar in the background. The acoustic drums are playing an upbeat rhythm with off-beat hi-hat strokes. The atmosphere is energetic. This piece could be used as the opening theme of a Korean teenage drama TV series. | 2009-11-06T14:31:39Z | PROJECTJEI | in STUDIO YOU Oct. 30, 2009 | ["Drum kit", "Music", "Musical instrument", "Ska", "Roll"] | ["pop rock", "studio performance", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drum", "upbeat", "energetic", "lively"] | 9 | eJFZuX0WHgk | 3856 | |
Acrobatic Rock and Roll - Europe championship 2009 - Foot technique | This is the live recording of a dance performance that uses a pop music piece as accompaniment. There is a male and a female vocalist singing melodically. The tune of the piece is being played by the electric guitar, the bass guitar and the synth. There is an upbeat acoustic drum beat in the rhythmic background. The audience can be heard clapping to the beat. The atmosphere is loud and lively. It could work well as the backing track in a modern dance course. | 2009-11-16T10:03:37Z | Tomáš Tlášek | RNR - Velika Gorica - 7.11.2009 - Foot technique - Ivan KLIMOV - Katrin GAZAZYAN (RUS), Lukas FURST - Alzbeta SLAMOVA (CZE), Maurizio MANDORINO - Jade MANDORINO (SUI), Jacek TARCZYLO - Anna MIADZIELEC (POL), Julien FOULON - Ingrid FOULON (FRA), Michael TRÜB - Stephanie RÜEGG (SUI), Neven IVIC - Ivana MIHALIC (CRO) | ["Music", "Roll", "Rock and roll"] | ["pop music", "dance", "male and female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "synth", "audience clapping", "loud", "lively", "catchy", "upbeat"] | 9 | ggBivmG6yHQ | 4045 | |
Ondatrópica - Punkero Sonidero | This music is an upbeat instrumental. The tempo is fast with a plethora of instruments like trumpets, congas, bongos, steel drum, accordion,saxophone, keyboard,and electric guitar. The music is perky, buoyant, high spirited, enthusiastic, energetic with complex harmonies. This music is a contemporary take in Traditional Latin folk music. | 2012-06-29T08:59:31Z | Soundway Records | Artist: Ondatrópica Title: Punkero Sonidero Album: Punkero Sonidero Conceived by Colombian musician Mario Galeano, the force behind the band Frente Cumbiero, and English producer Will 'Quantic' Holland, Ondatrópica brings together an all-star cast representing both the classic and modern styles of la musica Colombiana. Label Website: http://www.soundwayrecords.com https://www.facebook.com/SoundwayRecords http://soundcloud.com/soundway-records https://twitter.com/#!/soundway Click here to subscribe to Soundway Records - http://www.bit.ly/sub2soundway MUSIC FROM PLANET EARTH: PAST, PRESENT & FUTURE Soundway Records was conceived in 2002 by label owner Miles Cleret whilst returning from Ghana with a hoard of dusty old 45s and LPs that had mostly not been heard outside the former Gold Coast since their original release. Planned on a whim the trip was not one of the carefully planned research expeditions that Miles would later embark on to any number of far-flung tropical destinations. On the contrary he left England with no idea of what he might find or that it might be the start of a career in the record business. Although the label has it's roots in West Africa the scope has grown to include many other parts of the tropical belt with the aim of making available recordings that have in most cases never been available outside of their original countries and often not even there for over 30 years. Over the years Soundway's modus operandi has been to approach the music from a different angle from many of the more established "World Music" labels. By focusing on more obscure artists as well as big names and often concentrating on progressive recordings more in sync with Cleret's generation and background in DJ culture and dance-music. Styles have included afro-beat, funk, highlife, ethio-jazz, molam, calypso, cumbia, champeta, biguine, latin-jazz and disco as well as many unclassifiable recordings. Since 2012 Soundway has begun releasing new material from a carefully selected handful of contemporary recording … | ["Music", "Ska"] | ["instrumental", "fast tempo", "trumpets", "complex harmonies", "syncopated", "electronic reggae", "synthesiser arrangement", "folk music", "latin folk", "world music", "accordion harmony", "psychedelic", "party song", "dance groove", "contemporary traditional music", "trombone", "conga", "bongos", "steel pan", "saxophone", "electric guitar", "groovy bass", "upbeat", "cheerful", "happy merry", "polyrhythms", "animated", "high-spirited", "lively", "colourful", "vivid", "vivacious"] | 7 | mcAsO331Z9s | 4482 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 |
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;