musiccaps_details (view)
4 rows where musiccaps_aspects contains "programmed percussion", musiccaps_names contains "Music" and musiccaps_names contains "Zing"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| #Techno Autobahn | This techno song features a female voice singing only in non-lexical vocables. This is accompanied by programmed percussion. The percussion pauses after one and a half bars. It plays again after half a bar in an eighth note pattern. A synth plays a melody that is the same as that of the voice. The melody is repetitive. This song has a happy mood. This song can be played in a club. | 2009-02-20T19:39:21Z | smdileuca | is einfach cool | ["Electronic music", "Music", "Techno", "Zing"] | ["techno song", "dance song", "female voice", "vocables", "repetitive vocal melody", "synth music", "programmed percussion", "moderate melody"] | 0 | JzJCn-puzS4 | 2048 | |
| Ukraine Epic Dubstep | This folk dubstep features female voices singing the main melody. This is accompanied by percussion playing a dubstep beat. The tempo of the beat is fast, incorporating shuffles. A jaw harp plays a quirky sound in the background. The tempo of the song is fast. At the beginning, there is no bass. Toward the end, the bass plays while the percussion gets louder. This song can be played in a club. | 2013-05-18T14:16:11Z | Tvz777 | Kind Of Zero feat Marvinok-Коломийки. | ["Electronic music", "Music", "Pop music", "Zing", "Dubstep"] | ["folk dubstep", "fast tempo", "female voices", "jaw harp", "programmed percussion"] | 0 | qpwjSTEaswI | 4825 | |
| Da' Zoo- Boom Zoo Pow | This hip-hop song features a male voice singing the main melody. There are other quirky voices singing in the background. This is accompanied by programmed percussion playing deep kick and snare hits. Hand claps are played on alternate counts of the bar. This song can be played in a club. | 2009-10-05T04:46:11Z | cheiffortyseven | todo el crédito le pertenece a da zoo | ["Electronic music", "Music", "Zing"] | ["hip-hop song", "male voice", "quirky sounds", "hand claps", "programmed percussion", "synth sounds", "moderate tempo"] | 0 | sbOBTkrivXM | 4966 | |
| Original Doll - Mi Tutsi Pop | This techno song features a male voice singing the main melody. A female voice is heard singing vocables in the background. In the beginning of this clip, the voice is accompanied by a programmed percussion playing the kick at every count and the snare at alternate counts. A synth is playing the same melody as the main voice. A siren is playing in the background. After two bars of eight counts, the percussion plays a roll and the bass plays a groovy bassline. The synth plays a ring modulated sound. This song can be played in a club. | 2010-05-02T04:33:24Z | Imanol Prada | [ Mi Tutsi Pop ] Carmen Salinas: Ay cabrones, ¡Párense putos! ¡¡Agarren a esos pinches ratas!! ¡Hijos de la chingada! Sé que yo soy sexy Cuando me muevo así Voy por la calle y Tú me volteas a ver Chupo mi tutsi pop Y gano tu atención Y aunque digas que no Ya provoqué tu erección Tú dices que eres buga Esquivas mi mirada Pero piensas en mí Y me quieres en tu cama No sé por qué pero así soy Algo infantil con mi tutsi pop Labios cereza, a ti te enloquecen Soy niño fresa, ¿eso es lo que quieres? Nah, nah, ah, ah, ah No soy fácil, ya lo ves Y aunque sea irresistible Puedes verme, no tocar! Quítate de aquí Sólo yo en las spotlights Con mi personalidad Yo te quito propiedad Now, you, watch me shine! Mis ojitos como stars En el cole o en el antro Con mi tutsi en los labios OMFG! Chupando mi tutsi pop Enciendo tus fantasías Bienvenido a mi show De día voy a Starbucks Con Karla y Talia un rato De noche voy al antro Con mi tutsi en los labios No sé qué esta pasando Wannabe en todos lados Creo que impuse moda De una tutsi en la boca Mis labios son veneno Mi piel dorada y tersa Mi pose súper fresa Y mi tutsi pop cereza Ven y tómame un rato Nos fajamos en tu carro Dame un beso atascado Luego llévame al antro Después quítame los jeans Mi playera D&G Quiero verte desnudito Y hacerte mil feliz Nah, nah, ah, ah, ah No soy fácil, ya lo ves Y aunque sea irresistible Puedes verme, no tocar! Quítate de aquí Sólo yo en las spotlights Con mi personalidad Yo te quito propiedad Now, you, watch me shine! Mis ojitos como stars En el cole o en el antro Con mi tutsi en los labios OMFG! Chupando mi tutsi pop Enciendo tus fantasías Bienvenido a mi show Sé que tu cuerpo pide más de mi Que soy como una adicción para ti Y aunque te escondas, te voy a encontrar Pues tengo algo que te gustará Ah, ah Ah, ah Ah, ah Ah, ah Ah, ah, ah, ah, ah, ah, ah! Nah, nah, ah, ah, ah No soy fácil, ya lo ves Y aunque sea irresistible Puedes verme, no tocar! Quítate de aquí Sólo yo en las spotlights Con mi personalidad Yo te quito propiedad No… | ["Music", "Pop music", "Zing"] | ["techno", "dance music", "male voice", "female voice", "male voice", "synth", "programmed percussion", "siren sounds", "bass", "trance song"] | 0 | wMHBhCVv--g | 5259 |
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;