musiccaps_details (view)
5 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- acoustic drums · 5 ✖
- acoustic guitar · 5 ✖
- uptempo · 5 ✖
- e-bass 3
- male voice singing 3
- e-guitar 2
- positive energy 2
- accordion 1
- brass 1
- country 1
- country/folk 1
- e-bass backround noises 1
- harmonica 1
- higher key 1
- higher pitch 1
- male voices singing 1
- piano 1
- pop 1
- poprock 1
- reggae 1
- saxophone 1
- uplifting energy 1
- upright bass 1
- violin 1
musiccaps_names (array) 10 ✖
- Music 4
- Music of Africa 2
- Brass instrument 1
- Music of Latin America 1
- Reggae 1
- Ska 1
- Slosh 1
- Song 1
- Soul music 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hair Dryer (Alex Ferguson) by Glenn Staab | A male voice is singing along to a fast paced reggae instrumental. The drums are playing a reggae-groove along with a harmonica on the offbeat. Two e-guitars are playing a single note melody. Both are following the bassline adding harmonies. A saxophone is adding a little melody after every end of a phrase. The male voice is singing in the mid-range and sounds doubled. Some of the instruments are panned to the left and right side of the speakers. This song may be playing at a local bar. | 2010-12-09T21:04:50Z | mick jenner | Inspired by ska song Rough Ryder and dedicated to West Ham's 4 - 0 win over Man Utd 30.11.2010 (mick jenner) | ["Music of Africa", "Music", "Reggae", "Song"] | ["reggae", "saxophone", "acoustic guitar", "e-guitar", "e-bass", "acoustic drums", "harmonica", "male voice singing", "positive energy", "uptempo"] | 6 | ChyayWIp_vU | 1395 | |
Casar Hum Hum Gino e Geno Part Felipe Borges 2013 | A male voice is singing/shouting phrases while an acoustic drum is playing a dance groove along with an e-bass. On top of that a acoustic guitar is playing a melody and another one is strumming chords while an accordion is playing a loud melody that seems to be the lead. The drum fill-ins are panned to the left and right side of the speakers. This song sounds like the people are having fun. This song may be playing at a dance event in the countryside. | 2013-05-16T00:23:52Z | W Comunicação | Nova Música do Gino e Geno Lançamento | ["Music of Africa", "Music", "Ska", "Music of Latin America"] | ["country/folk", "acoustic drums", "e-bass", "accordion", "acoustic guitar", "male voice singing", "uptempo", "positive energy"] | 6 | Fv9swdLA-lo | 1674 | |
6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 | ||
"Pepsi Football Splash" กิจกรรมสุดมันส์ที่สวนน้ำ Cartoon Network Amazone | This song contains acoustic drums playing a simple rhythm along with an e-bass. The same rhythmic pattern gets played by an acoustic guitar and e-guitar strumming chords. In the background female voices are happily screaming to the sound of waves. This song may be playing for an advertisement. | 2016-07-18T02:45:54Z | Pepsi Thailand | ชวนแก๊งเพื่อนให้พร้อม แล้วมามันส์กับ "Pepsi Football Splash" กิจกรรมใหม่ล่าสุดจาก Pepsi และสวนน้ำ Cartoon Network Amazone เพียงซื้อแก้ว Pepsi Tumbler ที่สวนน้ำ Cartoon Network Amazone พัทยา ก็รับสิทธิ์ร่วมกิจกรรมฟรี! พร้อมลุ้นรับรางวัลอีกมากมาย รีบมามันส์กันได้เลยตลอดทั้งเดือนกรกฎาคม 2559 | ["Music", "Slosh"] | ["poprock", "acoustic drums", "acoustic guitar", "e-guitar", "e-bass backround noises", "uptempo"] | 6 | iP46w2o_HCk | 4180 | |
El Ultimo de la Fila - Dios de la Lluvia | This song contains an acoustic drum playing a simple groove with heat panned to both sides of the speakers. An e-bass is playing along while someone is strumming chords on an acoustic guitar. Two male voices are singing together in harmony. A viola is joining, playing along with the singer's melody. This song may be playing while cooking at home. | 2010-04-06T08:35:27Z | pidopoco | De el CD Como la Cabeza al Sombrero Track Nº1 Dios de la lluvia apiádate de las bestias y de mí. Vino tu llanto a redimir un mundo polvoriento y gris hecho a medida del triste reptil. Seguí la luz y te perdí, desde ese día rezaré para que vuelvas envuelto en tu bruma. Dejé a mi niña, dulce abril, entre aire de fresas y jazmín; se desdibuja en mi memoria la umbría vereda que tantas veces recorrí. Antiguos aromas flotando en el aire, espíritu de la bruma, no volverán. Ríe mi niña flotando en el suelo; Dios de la lluvia, devuélveme al ayer. Maldito el día en que crecí dejando atrás el sueño aquel del dulce mundo en que aprendí el dificil arte de vivir. Entre los campos verdes de abril, lejos del mundo, muy cerca de ti. Dios de la lluvia abrázame y bajo tus nubes volveré a considerar las múltiples formas de besar el aire bañado en tu perfume singular de antiguos aromas flotando en el aire espíritu de la bruma, no volverán. Ríe mi niña flotando entre helechos Dios de la lluvia devuélveme al ayer Dios de la lluvia apiádate de las bestias y de mí, pobre mortal. | ["Music", "Soul music"] | ["pop", "acoustic guitar", "e-bass", "acoustic drums", "violin", "male voices singing", "higher pitch", "uptempo"] | 6 | p9nbp0Oo1U0 | 4689 |
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;