musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "lively", musiccaps_author = 7 and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- lively · 6 ✖
- fast tempo 4
- cheerful 3
- enthusiastic 3
- happy 3
- instrumental 3
- acoustic guitar accompaniment 2
- folk music 2
- foreign language 2
- people talking 2
- rhythmic acoustic guitar 2
- spirited 2
- upbeat 2
- 8 stringed instrument 1
- acordian harmony 1
- amateur home recording 1
- ambient outdoor sounds 1
- ambient sounds 1
- animated 1
- animated acoustic guitar rhythm 1
- bongos 1
- bright 1
- catchy 1
- chirpy 1
- clapping 1
- country music 1
- country pop 1
- dance music 1
- discarded oil drums 1
- earnest singing 1
- …
musiccaps_names (array) 21 ✖
- Music 6
- Musical instrument · 6 ✖
- Acoustic guitar 2
- Plucked string instrument 2
- Accordion 1
- Bass drum 1
- Bluegrass 1
- Bowed string instrument 1
- Clapping 1
- Country 1
- Drum 1
- Drum kit 1
- Guitar 1
- Mandolin 1
- Mantra 1
- Percussion 1
- Rattle (instrument) 1
- Singing 1
- Steelpan 1
- Strum 1
- Traditional music 1
youtube_published (date) 6 ✖
- 2007-01-30 1
- 2009-04-26 1
- 2011-09-09 1
- 2011-11-13 1
- 2013-04-23 1
- 2013-07-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
Brazil | This song is an instrumental. The tempo is medium fast with melodious steel pan, rhythmic percussion like bongos and congas, guitar sound, steady bass line and keyboard harmony. The sound of the breeze in the background indicates that music is being played outdoors. The music is invigorating, playful, light, pleasant, mellifluous and warm. | 2009-04-26T18:16:34Z | Steel Drum Music | Now on iTunes ♫ → click the 'Show More' button for info ↓ ↓ ↓ Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net The very popular samba 'Brazil' performed at ER Bradley's in West Palm Beach on 4/25/09 | ["Drum", "Drum kit", "Music", "Musical instrument", "Bass drum", "Percussion", "Steelpan"] | ["instrumental", "medium fast tempo", "lively", "steel pan", "sound of bike starting", "sound of breeze", "windy", "guiero rhythm", "recycled instrument", "discarded oil drums", "keyboard harmony", "steady bass line", "people talking", "guider sound of breeze", "guiro rhythm", "simple music", "catchy", "upbeat", "rhythmic congas", "bongos"] | 7 | NtM3gudMBCQ | 2375 | |
Sergio el duende ( y yo le canto al amor...) | A male vocalist sings this energetic song. The tempo is fast emphatic vocals, bright acoustic guitar accompaniment and clap beat. The song is youthful, energetic, popular, cheerful, engaging and happy. The music is minimal with ambient sounds of people clapping, cheering, singing along and keeping beat with claps. The audio is distorted and muffled as it is an amateur home recording. | 2013-07-09T13:09:10Z | Maria Luisa Asencio | ["Singing", "Music", "Musical instrument", "Clapping"] | ["male vocalist", "fast tempo", "acoustic guitar accompaniment", "spanish guitar", "lively", "entertaining", "enthusiastic", "party song", "happy", "joyful", "cheerful", "youthful", "clapping", "singing along", "people talking", "emphatic vocals", "amateur home recording", "spanish song", "popular song"] | 7 | PN3Lx8RutmI | 2529 | ||
Cel ce legi rani care dor-grup burla&horodnic | A group of male vocalists sing this charming melody in a foreign language. The tempo is fast with accordion lead music and acoustic guitar accompaniment. The song is lively, happy, light , warm, cheerful and charming . The audio quality is inferior as it seems to be an amateur home recording with ambient sounds. This Song is a Folk song. | 2011-11-13T02:38:31Z | dorin juravle | Dorin Gach, Dorin Medrihan, Valy Motac, Florin Motac, Danut Covali, Cornel Mihalescu | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["male singers", "male harmony", "fast tempo", "rhythmic acoustic guitar", "acordian harmony", "lively", "loud", "folk music", "emotional", "passionate singing", "three part harmony", "live performance", "ambient sounds", "inferior audio quality", "cheerful", "upbeat", "happy", "foreign language"] | 7 | QHCHK-NPO_U | 2607 | |
country guitar lesson | This music is a high spirited acoustic guitar instrumental. The tempo is fast and the music is lively, spirited, Vibrant and vivacious with static and the sound of tapping. This music is a country style acoustic melody. | 2007-01-30T10:48:28Z | maracm | I'm playing some rhythm in g slowly for u :))btw i made a real lesson check it out http://www.youtube.com/watch?v=zKwj9r8Jxn4 | ["Country", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument", "Bluegrass"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "country pop", "lively", "spirited", "enthusiastic", "energetic", "vigorous", "vivacious", "tapping sound", "static", "home recording", "country music"] | 7 | a_r8wKJ8ePw | 3555 | |
SINCHI WAIRA. MANTRA SUMA AMBIWASKA | A group of male vocalists sing this folk song in a foreign language. The tempo is fast with minimalist instruments like a lively acoustic guitar harmony, shakers and tambourine beat;The vocals are energetic, youthful, earnest, cheerful , happy, simple and chirpy. | 2013-04-23T07:17:55Z | Daniel Ortega | Poderoso mantra de sanación. Taita John Muchavisoy, Nicolas Lozada y Cristiam Herrán. Centro de sanación SINCHI WAIRA. | ["Mantra", "Music", "Musical instrument", "Rattle (instrument)", "Bowed string instrument"] | ["male vocalists", "fast tempo", "foreign language", "tambourine", "tambourine used as hand drum", "animated acoustic guitar rhythm", "hand percussions", "shakers", "smal hand drum", "folk song", "regional song", "outdoor singing", "ambient outdoor sounds", "engaging", "lively", "simple", "earnest singing", "enthusiastic", "melodic"] | 7 | qbIPQGY8RRA | 4800 |
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;