musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "male voice" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- bass guitar · 6 ✖
- male voice · 6 ✖
- acoustic drums 5
- acoustic guitar 3
- live performance 3
- electric guitar 2
- lively 2
- vibrant 2
- accordion 1
- advertising 1
- afrobeat 1
- background music 1
- bells 1
- cebuano language 1
- cheerful 1
- christmas music 1
- colorful 1
- description 1
- electric piano 1
- electronic drum beat 1
- female voice 1
- festive 1
- floghera 1
- gear 1
- generic 1
- greek folk music 1
- jam 1
- jingle 1
- keyboard 1
- melodic singing 1
- …
musiccaps_names (array) 13 ✖
youtube_published (date) 6 ✖
- 2007-08-13 1
- 2009-10-14 1
- 2010-12-10 1
- 2013-09-05 1
- 2014-03-12 1
- 2014-06-04 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Abeokuta Afrobeat na Ressaca do Bloco Uououou - Zombie | This is the live performance of an afrobeat music piece. There is a male voice singing occasionally. The melody is being played by a wide variety of instruments such as the electric guitar, the keyboard and the bass guitar. There is a saxophone playing a solo. In the rhythmic background, there is an acoustic drum beat in the style of afrobeat. It is joined by percussive elements. There is a vibrant atmosphere in this recording. This piece could be playing in the background of a West African cuisine restaurant. | 2014-03-12T03:57:41Z | Jedson Nobre | Abeokuta Afrobeat em apresentação na Ressaca do Bloco Uououou no Xinxim da Baiana, Olinda Interpretando Zombie, música de Fela Kuti. | ["Blues", "Music"] | ["afrobeat", "live performance", "male voice", "electric guitar", "bass guitar", "keyboard", "saxophone", "acoustic drums", "percussion", "vibrant", "colorful", "playful"] | 9 | Al_OdIuqoe0 | 1167 | |
GASP, Hardcore, Wrist Wraps | This is a product review video. There is a male voice describing the product. In the background music, there is a very generic jingle that contains an acoustic guitar, a bass guitar, an acoustic drum beat and bells. If the track can be isolated from the piece, it could be used as an advertisement jingle. | 2014-06-04T09:32:13Z | Bodybuilding Singapore | BUY FROM https://www.amazon.com/gp/search?ie=UTF8&tag=carlingnets0d-20&linkCode=ur2&linkId=afcb849ff72bf7c560a563a94352691c&camp=1789&creative=9325&index=aps&keywords=Wrist%20Wraps | ["Music", "Music for children", "Speech"] | ["product review", "male voice", "description", "background music", "jingle", "generic", "acoustic guitar", "bass guitar", "bells", "acoustic drums"] | 9 | RxBFh-zdid4 | 2731 | |
EL ORIGINAL DE LA SIERRA "LA DESVELADA" | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | 2009-10-14T02:38:05Z | FRONTERAVISUAL09 | MUSICAL EN BILLBOARD | ["Accordion"] | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | 9 | XOsHEjo-RSg | 3181 | |
Stelios Mpikakis -Rethemniotikos siganos by QRTSIDAKIS | This is a live performance of a Greek folk music piece. There is an orchestra performing the piece. There is a floghera flute playing the main tune while the oud and the bass guitar are playing in the background. The rhythm is being played by the acoustic drums. After the shout coming from a male voice, the orchestra starts accelerating. The atmosphere is lively. This piece could be playing in the background at a seaside Greek tavern. | 2007-08-13T17:16:13Z | QRTSIDAKISN | Stelios Mpikakis -Rethemniotikos siganos Live sti Fortetzza.Mia sinaulia san panigiri. | ["Traditional music", "Music"] | ["greek folk music", "live performance", "orchestra", "oud", "floghera", "bass guitar", "male voice", "acoustic drums", "lively", "repeated tune", "rising tempo"] | 9 | mWuX--EEq2E | 4477 | |
KR Mini: Energize your practices and performances with diverse rhythm patterns! | This is an advertisement video for a rhythm machine. Firstly, it is shown playing behind a bass guitar jam. Then, it is shown playing behind an acoustic guitar jam. A male voice is describing the benefits and functions of the rhythm machine. The parts where the instruments can be heard without the interruption of the voice can be sampled for use in beat-making. | 2013-09-05T01:01:42Z | Korg | Designed for guitarists, bassists, pianists or any musician looking for easy rhythm accompaniment, the KR mini features nostalgic looks and a simple design focused on easy, push-button control. The KR mini is also lightweight, can run on batteries and has a built-in speaker, allowing it to provide a backing rhythm pattern anywhere at any time. With a total of 60 diverse rhythm patterns across the genres, the compact KR Mini is ready to accompany any performance. For more information on the KR Mini Rhythm Machine, head over to http://www.Korg.com/KRmini. "Like" us -- https://www.facebook.com/KORGusa "Follow" us -- https://www.twitter.com/KorgUSA | ["Guitar", "Musical instrument", "Drum machine", "Plucked string instrument"] | ["jam", "gear", "rhythm machine", "electronic drum beat", "bass guitar", "acoustic guitar", "male voice", "advertising"] | 9 | rS8oECcQBCk | 4877 | |
Mag-ambahan | This is a Christmas music piece. There is a male voice and a female voice singing melodically in the Cebuano language. The electric piano is playing the main melody while the electric guitar and the bass guitar are playing in the background. The rhythm is provided by a simple and upbeat acoustic drum beat. The atmosphere is festive and cheerful. This piece could be the opening theme of a Christmas movie that takes place in the southern Philippines. | 2010-12-10T09:35:04Z | ryahnz | Mag-ambahan ta ning pasko sa kalipay Ang kagul-anan ta ato nga isalikway Ug duyog ning awit sa malipayong dughan Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya Wad-on ta ang mga kayugot Isalikway ta ang pagdumot Ang pagpasaylo mao'y angay buhaton ta Ning adlaw sa manunubos (Repeat Mag-ambahan stanza) Issignit ta ang kalipay'g hudyaka Kay pasko karon sa pagmaya | ["Christmas music", "Christian music", "Jingle (music)", "Music"] | ["christmas music", "male voice", "female voice", "melodic singing", "cebuano language", "electric piano", "electric guitar", "bass guitar", "acoustic drums", "festive", "cheerful"] | 9 | tDZPGf8WYmI | 5016 |
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;