musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music" and musiccaps_aspects contains "techno"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- dance music · 3 ✖
- techno · 3 ✖
- club music 2
- dance pop 2
- dj 2
- edm 2
- electronic music 2
- electronica 2
- fast tempo 2
- hypnotic 2
- instrumental 2
- trippy 2
- youthful 2
- ambient music 1
- anticipation 1
- bass 1
- building up 1
- buoyant 1
- burgeoning music 1
- dance floor 1
- digital drumming 1
- digital music 1
- dj mixer 1
- electrifying 1
- electropop 1
- female voice 1
- fourth world music 1
- futuristic 1
- hardcore 1
- high energy 1
- house music 1
- intense 1
- male voice 1
- new age 1
- programmed percussion 1
- progressive trance 1
- psychedelic 1
- psytrance 1
- pulsating 1
- repetitive beats 1
- simple beat 1
- siren sounds 1
- synth 1
- synthesiser arrangement 1
- synthesiser articulation 1
- tech trance 1
- techno pop 1
- technopop 1
- throbbing rhythm 1
- trance 1
- trance droning 1
- trance music 1
- trance song 1
- trap music 1
- vocal riff 1
musiccaps_names (array) 9 ✖
- Music 3
- Electronic dance music 2
- Dance music 1
- Disco 1
- Dubstep 1
- Electronic music 1
- Pop music 1
- Trance music 1
- Zing 1
youtube_published (date) 3 ✖
- 2010-05-01 1
- 2010-05-02 1
- 2013-01-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dj Tiesto Bass NEW SONG 2013 | This music is instrumental. The tempo is fast with a burgeoning beat and digital swishing sounds. The music clip seems to be the introduction of the song as it starts with a slow tempo and decibel and rapidly builds up to a faster beat. The music is youthful, buoyant, energetic, pulsating and high spirited. This song is an Electronica/Techno Pop. | 2013-01-15T20:48:09Z | Chaos Crew | ["Electronic music", "Music", "Trance music", "Electronic dance music"] | ["instrumental", "fast tempo", "intense", "techno", "technopop", "burgeoning music", "synthesiser articulation", "digital music", "edm", "electronic music", "throbbing rhythm", "pulsating", "building up", "electrifying", "anticipation", "simple beat", "buoyant", "club music", "dance pop", "dance music", "dj", "dance floor", "youthful", "trance", "hypnotic", "trap music", "electropop", "electronica", "futuristic", "fourth world music", "new age", "trippy"] | 7 | DGON0D8E17Q | 1457 | ||
TECKTONIK vs SHUFFLE.. | This music is an electronic instrumental. The tempo is fast with synthesiser arrangements, electronic beats , Dj mixer and a repetitive vocal riff. The music is incessant, psychedelic, hypnotic, trippy and trance like with a dance groove. This music is Techno Pop/EDM. | 2010-05-01T19:39:05Z | cireduard | hermano vs hermano familia TELLO | ["Disco", "Music", "Dubstep", "Electronic dance music", "Dance music"] | ["instrumental", "fast tempo", "electronic music", "house music", "progressive trance", "repetitive beats", "high energy", "tech trance", "ambient music", "hardcore", "psytrance", "edm", "electronica", "techno", "techno pop", "trippy", "trance droning", "dance pop", "psychedelic", "vocal riff", "dance music", "club music", "dj", "dj mixer", "digital drumming", "synthesiser arrangement", "hypnotic", "trance music", "trippy", "youthful"] | 7 | ITg9o6Gwsbo | 1910 | |
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;