musiccaps_details (view)
6 rows where musiccaps_aspects contains "male voice singing", musiccaps_aspects contains "piano" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- male voice singing · 6 ✖
- piano · 6 ✖
- uptempo · 6 ✖
- acoustic drums 5
- e-bass 3
- e-guitar 3
- higher pitch 2
- reggae 2
- upright bass 2
- acoustic guitar 1
- backing vocals 1
- brass 1
- brass section 1
- chimes 1
- country 1
- crowd cheering 1
- female backing voice 1
- higher key 1
- motor racing sound 1
- old recording 1
- organ 1
- pop 1
- pop/rock 1
- sound-effects 1
- string section 1
- uplifting energy 1
- uplifting mood 1
musiccaps_names (array) 14 ✖
- Music 4
- Brass instrument 1
- Christian music 1
- Funk 1
- Independent music 1
- Music of Asia 1
- Pop music 1
- Reggae 1
- Rhythm and blues 1
- Rock music 1
- Singing 1
- Soul music 1
- Swing 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ngayong Gabi - brownman revival | This audio contains reggae-like drums playing along with a bass. An e-guitar is strumming short chords on the backbeat giving this song its typical reggae feel. An organ is playing a melody panned to the left side of the speakers playing short fast chords. A male voice is singing a melody in a higher pitch than a piano is walking down the scale creating a melody then a chime comes in getting the song ready for the next part. This song may be playing while sitting by a lake with your friends. | 2010-09-06T03:16:22Z | gin2141 | ["Soul music"] | ["reggae", "e-bass", "e-guitar", "acoustic drums", "male voice singing", "higher pitch", "organ", "piano", "chimes", "uptempo"] | 6 | 8HHrlxQuZKE | 909 | ||
12'' Sound Iration & Tena Stelin - Give Thanks & Praise | An acoustic drum is playing a fast groove with a kick-hit on every beat. The snare hit is full of reverb and panned to the right side of the speaker. A loud e-bass is playing a melody along with a clean e-guitar. A piano is playing a chord progression also adding a rhythmic element to the song. The male voice is singing in the mid range and gets support from backing voices that are barely noticeable. This song may be playing at a headshop. | 2012-01-20T00:18:05Z | RasDashanSound | www.youtube.com/user/RasDashanSound | ["Funk", "Music", "Reggae", "Rhythm and blues"] | ["reggae", "acoustic drums", "piano", "e-guitar", "e-bass", "male voice singing", "sound-effects", "backing vocals", "uptempo"] | 6 | Fsm-xDmyFKg | 1669 | |
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 | ||
vroom vroom i värmlandsskogen | This song contains acoustic drums holding the rhythm together with a bass and almost clean e-guitar strumming chords. A piano is adding single notes on top while a male voice is singing a melody getting backed up by a female voice singing along. In the background motor race sounds can be heard. This song may be playing in a car with windows open on a road trip. | 2013-01-14T20:08:43Z | robert bengtsson | ["Christian music", "Music", "Rock music"] | ["pop/rock", "e-bass", "piano", "e-guitar", "acoustic drums", "motor racing sound", "male voice singing", "female backing voice", "uptempo"] | 6 | WyGJdstaxK4 | 3153 | ||
Gilberto Mazzi - Dove sei Lulù (con testo).wmv | A brass section is playing a melody along with a lead trumpet. In the background you can hear strings playing in the mid to high range. An upright bass is holding the rhythmic side of the song. A piano is playing the same melody as the male singer. This song may be playing in a retro bar. | 2013-02-05T18:27:36Z | Melodieantiche di Fausto Cartoni | GILBERTO MAZZI -- DOVE SEI LULU'; di Mascheroni-Marf; 1939; Orchestra Cetra diretta dal Maestro Pippo Barzizza; Parlophon GP 92968; dal film "Imputato alzatevi". TESTO DELLA CANZONE E BIOGRAFIA DELL'INTERPRETE TESTO: Da una settimana m'è scappata e se n'è andata, non so perché. Era tutta quanta la mia vita, ora è fuggita, non so dov'è. Dove sei, Lulù? Cosa fai, Lulù? A Parigi sei con Pippo oppur con Gigi? Dove sei, Lulù? Cosa fai, Lulù? Sei tu forse a Gorgonzola con Nicola? Sei tu in giro per Rovigo, con Pancrazio o con Arrigo, o sei forse a Persiceto con Felice od Anacleto? Dove sei, Lulù? Cosa fai, Lulù? Non lo so, ma senza te non vivo più. "Mancia competente a chi la trova!" Ma a nulla giova, chissà dov'è?! Ora ho già perduta ogni speranza, soffro a distanza, pensando a te. Dove sei, Lulù? Cosa fai, Lulù? A Parigi sei con Pippo oppur con Gigi? Dove sei, Lulù? Cosa fai, Lulù? Sei tu forse a Gorgonzola con Nicola? Sei tu in giro per Rovigo, con Pancrazio o con Arrigo, o sei forse a Persiceto con Felice od Anacleto? Dove sei, Lulù? Cosa fai, Lulù? Non lo so, ma senza te non vivo più. BIOGRAFIA (da Wikipedia): Gilberto Mazzi (Alessandria, 3 gennaio 1909 -- Roma, 8 giugno 1978) è stato un cantante e attore italiano. Alla prima Gara nazionale per gli artisti della canzone bandita dall'EIAR nell'ottobre 1938, il ventinovenne Mazzi si classifica tra i quattordici vincitori prendendo parte, il 18 gennaio 1939, con le orchestre di Angelini, Barzizza e Tito Petralia alla loro prima trasmissione radiofonica. Dotato di una voce intonata e gradevole, Gilberto Mazzi inizia una carriera da cantante il cui punto più alto coincide con il grande successo della canzone Mille lire al mese, che lo conduce poi a partecipare a numerosi spettacoli di varietà, fra cui Non c'è radio senza spine (1940), Clan (1941). Nel 1948 entra a far parte della Compagnia del Teatro Comico Musicale di Radio Roma della RAI, suoi compagni sono Isa Bellini, Wanda Tettoni, Raffaele Pisu, Giusi Raspani Dandolo, ed altri, con la direzione di Riccardo … | ["Swing music", "Music"] | ["old recording", "brass section", "string section", "piano", "upright bass", "male voice singing", "uptempo", "uplifting mood"] | 6 | qEGNzCWQdqo | 4767 | |
BEAST - You / Fiction LIVE | THis song contains a piano playing a major chord progression in the midrange with the left hand playing bass notes creating a simple bassline. An acoustic drum is playing a constant groove without any big changes. A male voice is singing in a higher register getting backing vocals from another male voice. In the background you can hear the crowd cheering. It mostly sounds like female voices. This song may be playing at a live concert. | 2011-06-16T14:16:43Z | DBSKtelevison | Having already won a triple crown for "Fiction", the B2ST boys performed a special goodbye stage for their fans on today's Mnet M! Countdown. Though it has only been a month, the boys are wrapping up promotions on a high, having won triple crowns on M! Countdown and Music Bank, and being a two-time Mutizen winner on Inkigayo. In gratitude, B2ST will present their fans with a performance of their cute and lively song, "You". The production crew for M! Countdown stated, "B2ST, who showed their sorrowful and charismatic performance with their song 'Fiction', will be showing their sweet and lovely side through this performance. Please look forward to it!" | ["Singing", "Music of Asia", "Music", "Independent music", "Pop music"] | ["pop", "piano", "acoustic drums", "crowd cheering", "male voice singing", "higher pitch", "uptempo"] | 6 | yIFP8fkq8GU | 5398 |
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;