musiccaps_details (view)
4 rows where musiccaps_aspects contains "crowd cheering", musiccaps_author = 6 and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- crowd cheering · 4 ✖
- acoustic drums 3
- amateur recording 3
- male voice singing 2
- uptempo 2
- acoustic guitars 1
- acoustic piano 1
- bongos 1
- e-bass 1
- female singer 1
- female singers 1
- higher pitch 1
- latin 1
- male backing voices 1
- mandolin 1
- medium tempo 1
- piano 1
- pop 1
- pop-ballad 1
- pop/singer-songwriter 1
- positive vibes 1
- sad 1
- slow tempo 1
- steel drum 1
- uplifting energy 1
musiccaps_names (array) 9 ✖
- Music 4
- Singing · 4 ✖
- /t/dd00004 1
- Banjo 1
- Country 1
- Independent music 1
- Music of Asia 1
- Pop music 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
REGINE VELASQUEZ & ANNE CURTIS - On The Wings Of Love (The Forbidden Concert!) | An acoustic piano is playing a sad melody while two women are singing as a duo taking turns. Their voices have some reverb and in the background you can hear the crowd cheering. This song may be playing live on stage. | 2014-05-16T19:42:18Z | iamQRITIKO | LIKE me on Facebook: https://www.facebook.com/Qritiko?ref=tn_tnmn FOLLOW me on Twitter: https://twitter.com/IAmQritiko | ["Singing", "Music", "/t/dd00004"] | ["pop-ballad", "acoustic piano", "female singers", "crowd cheering", "amateur recording", "slow tempo", "sad"] | 6 | GLIXnXZEOxY | 1710 | |
Elida Reyna y Avante - "Me Gustas" | An acoustic drum is playing a latin groove with a cowbell sound and bongos playing along with a bassline underlining. Someone is playing a melody on a steeldrum. The female voice starts singing the same melody. Male voices are supporting her with shouting sounds. The crowd is cheering and clapping along. This song may be playing at a summer festival. | 2010-05-05T13:45:38Z | gcarmona66 | Elida Reyna y Avante "Me Gustas" April 22, 2010 Cattleman's Square - Tejano Explosion San Antonio, Texas | ["Singing", "Music", "Steelpan"] | ["latin", "bongos", "acoustic drums", "female singer", "male backing voices", "e-bass", "steel drum", "crowd cheering", "amateur recording", "medium tempo", "positive vibes"] | 6 | s4PN7iTLdVM | 4921 | |
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;