musiccaps_details (view)
5 rows where search matches "guitar", musiccaps_aspects contains "people talking" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 88 ✖
- people talking · 5 ✖
- instrumental 3
- bongos 2
- enthusiastic 2
- fast tempo 2
- keyboard harmony 2
- lively 2
- loud 2
- male vocalist 2
- abrupt end 1
- acoustic guitar 1
- acoustic guitar accompaniment 1
- amateur 1
- amateur home recording 1
- amateur recording 1
- ambient 1
- amplified guitar 1
- bass lines 1
- boomy 1
- bright 1
- catchy 1
- cheerful 1
- chord progression 1
- chords 1
- clapping 1
- congas 1
- dance music 1
- discarded oil drums 1
- electric guitar 1
- emphatic vocals 1
- energetic 1
- entertaining 1
- folk pop 1
- groovy bass line 1
- guider sound of breeze 1
- guiero rhythm 1
- guiro rhythm 1
- happy 1
- harp 1
- hawaiian guitar 1
- home video 1
- inferior audio quality 1
- intense electric guitar 1
- jarring 1
- joyful 1
- keyboard accompaniment 1
- loud feedback 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- melodic 1
- muffled music 1
- of static 1
- party song 1
- people cheering 1
- pleasant melody 1
- pop 1
- pop rock 1
- popular song 1
- punchy drumming 1
- recycled instrument 1
- regional pop 1
- rhythmic acoustic guitar 1
- rhythmic congas 1
- rock 1
- rock and roll 1
- sharp 1
- simple music 1
- singing along 1
- soft 1
- sonic power 1
- sound of bike starting 1
- sound of breeze 1
- spanish guitar 1
- spanish song 1
- static 1
- steady bass line 1
- steady bass lines 1
- steel pan 1
- string instrument 1
- string instrument harmony 1
- ukele 1
- upbeat 1
- vibrations 1
- vigorous vivacious 1
- vocal backup 1
- windy 1
- youthful 1
musiccaps_names (array) 19 ✖
- Music 5
- Musical instrument · 5 ✖
- Singing 2
- Steelpan 2
- Acoustic guitar 1
- Bass drum 1
- Chorus effect 1
- Clapping 1
- Distortion 1
- Drum 1
- Drum kit 1
- Effects unit 1
- Electric guitar 1
- Inside, large room or hall 1
- Percussion 1
- Plucked string instrument 1
- Rock music 1
- Roll 1
- Strum 1
youtube_published (date) 5 ✖
- 2008-02-17 1
- 2008-09-03 1
- 2009-04-26 1
- 2010-11-01 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 |
---|---|---|---|---|---|---|---|---|---|---|
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 | |
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 | |
Jamaica Farewell / Island In The Sun | This song is an instrumental. The tempo is slow with a keyboard harmony, steady bass lines, congas and bongo rhythm and sound of an instrument like a harp and string instrument like a ukelele or Hawaiian guitar.The music is soft, mellow, pleasant and simple with the sound of people talking in the background. This is a Regional/Folk Pop instrumental. | 2008-02-17T15:07:09Z | Steel Drum Music | Now on iTunes → click the little tab button for the link and 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 Steel drums at dinner party, Stranahan House, Fort Lauderdale, 2-13-08 | ["Music", "Musical instrument", "Steelpan"] | ["instrumental", "keyboard accompaniment", "congas", "string instrument harmony", "hawaiian guitar", "ukele", "steady bass lines", "regional pop", "folk pop", "pleasant melody", "bongos", "bass lines", "harp", "people talking", "soft", "mellow", "ambient", "muffled music"] | 7 | P996TZp25PM | 2512 | |
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 | ||
Danelectro FAB Chorus D 5 | This music is an electric guitar instrumental. The tempo is medium with a loud and energetic riff . The audio quality is inferior as it is a Home recording ,which is why the music is boomy and there are sounds of people talking in the background and some static. | 2010-11-01T07:01:01Z | musicnbooksdotcom | ["Effects unit", "Electric guitar", "Acoustic guitar", "Music", "Musical instrument", "Chorus effect", "Strum", "Plucked string instrument", "Distortion"] | ["acoustic guitar", "instrumental", "medium tempo", "static", "abrupt end", "string instrument", "chords", "chord progression", "vibrations", "sonic power", "loud feedback", "boomy", "people talking", "electric guitar", "amplified guitar", "amateur", "melodic", "of static", "loud", "sharp", "amateur recording", "home video"] | 7 | bqvl7IbPteU | 3659 |
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;