musiccaps_details (view)
9 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "bass guitar" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- acoustic drums · 9 ✖
- bass guitar · 9 ✖
- electric guitar 9
- male vocal 7
- melodic singing 4
- cheerful 3
- energetic 3
- groovy 3
- keyboard 3
- danceable 2
- easygoing 2
- male vocals 2
- story-telling mood 2
- upbeat 2
- afrobeat 1
- chill 1
- christian 1
- country music 1
- devotional 1
- doo wop 1
- gospel 1
- high pitch singing 1
- joyful 1
- live performance 1
- lively 1
- male choir 1
- male narrator 1
- passionate singing 1
- playful singing 1
- pop punk 1
- …
youtube_published (date) 9 ✖
- 2007-02-10 1
- 2008-09-10 1
- 2008-10-17 1
- 2009-01-05 1
- 2009-03-10 1
- 2009-06-22 1
- 2010-06-16 1
- 2010-08-11 1
- 2013-10-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blue devils - Mystery girl | This is a rock-n-roll music piece. There is a male vocalist singing as if he is telling a story in the lead. The electric and the bass guitar are playing a simple tune. The acoustic drums are playing an upbeat rhythm with a heavy use of rimshots. The atmosphere of the piece is groovy. This piece could be used in the soundtrack of a romance/romantic comedy movie where the protagonist cannot stop thinking about a girl. | 2008-09-10T20:16:30Z | Tage_ | ["Music", "Ska", "Rock and roll"] | ["rock-n-roll", "male vocal", "story-telling mood", "electric guitar", "simple tune", "bass guitar", "acoustic drums", "rimshots", "upbeat", "energetic", "groovy"] | 9 | D6xrH93lnoc | 1437 | ||
The Videos - Trickle Trickle | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | 2009-03-10T17:37:32Z | chargertom | Oldies favorite "Trickle Trickle" by The Videos. Another record selection from the Oldies Jukebox at www.fhs1961.com | ["Music", "Ska"] | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | 9 | KV99GJg0tvA | 2089 | |
Everybody Hates Chris | This is an R&B music piece from a sit-com soundtrack. Initially, there is a male voice narrating what is going on in the episode. Then the piece starts playing with a high pitched male vocal at the forefront. The melody is being played by the electric guitar and the bass guitar while the rhythmic background consists of an acoustic drum beat. The atmosphere is urban. | 2007-02-10T13:09:18Z | tigerzrule | My Personal Fav Bits OF EHC | ["Music", "Ska", "Speech"] | ["sit-com soundtrack", "male narrator", "r&b music", "male vocal", "high pitch singing", "electric guitar", "bass guitar", "acoustic drums", "groovy", "urban"] | 9 | T78nMdsJMmk | 2810 | |
Jah prayza-Ngoda | This is an afrobeat music piece. There is a male vocalist singing playfully in the lead. The electric guitar is playing a groovy melody with the bass guitar playing in the background. The rhythm is being played by the acoustic drums. The atmosphere is cheerful. This piece could be used in the soundtrack of a feelgood movie taking place in Africa. | 2013-10-09T16:24:49Z | Edmore Chizororo | Jah Prayza the beast, the best!!! Good work | ["Music", "Ska"] | ["afrobeat", "male vocal", "playful singing", "electric guitar", "bass guitar", "acoustic drums", "cheerful", "chill", "easygoing"] | 9 | asYb6iDz_kM | 3583 | |
Phish - Roses Are Free | This is a live performance of a rock music piece. There are male vocals singing melodically. The electric guitar is playing the main tune. The bass guitar is playing a simple bass line. In the rhythmic background, there is a simple acoustic drum beat. The atmosphere is cheerful. This piece can be used in the soundtrack of a feelgood TV series during the credits. | 2009-06-22T00:34:04Z | Mark Jones | Phish rehearsing and playing Ween's Roses Are Free. | ["Singing", "Music", "Ska"] | ["rock music", "live performance", "male vocals", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "cheerful"] | 9 | fp0oCFL6w4o | 3978 | |
Ladybug - The Presidents Of The USA | This is a post-grunge/pop punk music piece. There is a male vocalist singing melodically in the lead. The main melody is being played by the electric guitar in the major key with the bass guitar backing it. The rhythmic background consists of an acoustic drum beat. The atmosphere is energetic and cheerful. This piece could be used in the soundtrack of a comedy TV series as the opening theme. | 2008-10-17T20:11:49Z | Rapscallion And Chums | Are these guys the FUNNEST guys in the music buisness - oh Mrs! You betcha bumcakes. I love PUSA and was almost literally over the moon to make this music video for them. presidentsrock.com is where you can explore more. | ["Ska"] | ["post-grunge", "pop punk", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "energetic", "cheerful"] | 9 | hwSOjoHFLn4 | 4151 | |
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 | |
Keith Wonderboy Johnson "Time to Get Close to Jesus" {Official Video} | This is a Christian gospel music piece. There is a male vocalist singing passionately in the lead with a male choir that is at a relatively higher pitch than him singing in the back. The main melody is played by the keyboard and the electric guitar. There is a bass guitar that can be heard. The acoustic drums are playing an upbeat rhythm. The atmosphere is religious. This piece could be played at Christian religious events. | 2009-01-05T22:09:48Z | Daphanie Cassel | Official Video for the New Single, Time to Get Close to Jesus, from Keith Wonderboy Johnson & The Spiritual Voices. | ["Singing", "Music", "Ska"] | ["gospel", "christian", "male vocal", "passionate singing", "male choir", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "religious", "spiritual", "devotional"] | 9 | xmSMAmnoRug | 5352 | |
Jim Reeves on the Grand Ole Opry This May Well Be The Best Jim Reeves Video on Youtube www keepvid com | This is a country/western swing music piece. There is a male vocalist singing melodically in the lead with a story-telling attitude. The main tune is being played by the electric guitar with a bass guitar backing. The rhythm is being played by the acoustic drums. The atmosphere is easygoing. This piece could be playing in the background at an American roadside diner. | 2010-06-16T20:31:33Z | petedrakemusic | ["Singing", "Country", "Music", "Ska", "Song"] | ["country music", "western swing", "male vocal", "melodic singing", "story-telling mood", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "groovy"] | 9 | ymGg5TA2YfM | 5437 |
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;