musiccaps_details (view)
3 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "male voice" and musiccaps_names contains "Zing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- bass · 3 ✖
- male voice · 3 ✖
- romantic theme 2
- dance music 1
- female voice 1
- low quality audio 1
- male backing voice 1
- moderate tempo 1
- percussion 1
- pop song 1
- programmed percussion 1
- siren sounds 1
- slow pop 1
- slow tempo 1
- strings 1
- synth 1
- synth layers 1
- synth sounds 1
- techno 1
- trance song 1
- trap beat 1
musiccaps_names (array) 5 ✖
- Zing · 3 ✖
- Music 2
- Hip hop music 1
- Pop music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
iZomi - Nang A Ding | This slow pop song features a male voice singing the main melody. Another male voice sings backing voices in harmony with the main melody. A synth plays the same melody as the main voice using staccato notes. This is accompanied by percussion playing a trap beat. The bass plays the root notes of the chords and flourishes during chord changes. The bass notes are played without pausing in between notes. Instead, the notes are slid into each other. The mood of this song is romantic. This song can be played in a heartbreak scene in a romantic movie. | 2011-04-09T01:25:02Z | Khan Taithul | Lasa - Muanpi Mungleuh Sangpy Laphuak - Sangpu, Muanpi, Sangpy, Khanpi Produce by Adamack Director Khanpi | ["Music", "Zing", "Hip hop music"] | ["slow pop", "trap beat", "synth layers", "male voice", "bass", "male backing voice", "slow tempo", "romantic theme"] | 0 | CM2rKZmcR0I | 1355 | |
Lucy & Sam// Strawberry fields forever | This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. Strings play staccato notes in the background and at the end of the bar, the notes are allowed to ring. A synth plays chords using an organ voice. This voice plays chords in the background. At the end, the synth plays the sound of two bells playing a descending sequence. This song can be played in a romantic movie. | 2010-05-19T16:57:04Z | DakotaDuff92 | ["Rhythm and blues", "Zing"] | ["low quality audio", "percussion", "bass", "male voice", "pop song", "strings", "synth sounds", "moderate tempo", "romantic theme"] | 0 | HkCYA4ax4jI | 1830 | ||
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;