musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "pop", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A Day Made of Glass 2: Same Day. Expanded Corning Vision (2012) | This song contains mallet instruments playing a fast melody in the mid and high register along with low notes as bassline. The marimba is full of reverb. Then a bass drum comes in playing on every beat. This song may be playing in an advertisement. | 2012-02-03T16:10:14Z | Corning Incorporated | http://bit.ly/xITx1H - Watch and share "A Day Made of Glass 2," Corning's expanded vision for the future of glass technologies. This video continues the story of how highly engineered glass, with companion technologies, will help shape our world. "Corning" "Corning video" "Day made of glass" "Future" "Future of glass" "Glass" "Gorilla glass" "Tech" "Technology" "World made of glass" "Vision" "Innovation" "Touch" "Touch screen" "Display" "Telemedicine" "Antimicrobial" "Photovoltaics" "Electrochromic" "3D" "eLearning" "GLW" | ["Music", "Marimba, xylophone", "Vibraphone"] | ["pop", "mallet melody", "acoustic drums", "uptempo"] | 6 | jZkHpNnXLB0 | 4262 | |
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 | |
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;