musiccaps_details (view)
2 rows where musiccaps_aspects contains "techno" and musiccaps_names contains "House music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- techno · 2 ✖
- aggressive 1
- buzzy synth leads 1
- claps 1
- digital drums 1
- dj scratching sound effects 1
- energetic 1
- female voice sample 1
- groovy bass 1
- low quality 1
- pop 1
- punchy "4 on the floor" kick pattern 1
- shimmering hi hats 1
- synth pads/plucks 1
- uptempo 1
- weird 1
musiccaps_names (array) 7 ✖
- House music · 2 ✖
- Music 2
- Burst, pop 1
- Dance music 1
- Electronic dance music 1
- Electronic music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Madonna - Living For Love (Dirty Pop Dubinstrumental) | This song contains a female voice sample that is repeating itself. A digital drum is playing snare hits that are building up in speed along with synthesizer pads with a ping pong delay panning to both sides of the speaker along with other synth sounds rising up in pitch creating tension. This song may be playing in a techno club. | 2015-01-21T03:11:58Z | Madonna | Download the new album now! http://smarturl.it/RebelHeart | ["House music", "Music", "Burst, pop", "Electronic dance music", "Dance music"] | ["techno", "pop", "digital drums", "female voice sample", "synth pads/plucks", "uptempo"] | 6 | RBniJk6GKK0 | 2675 | |
Dancing to Techno Music | The low quality recording features a techno song that consists of DJ scratching sound effects, groovy bass, buzzy synth leads, punchy "4 on the floor" kick pattern, shimmering hi hats and some claps. It sounds energetic, aggressive and weird - due to those synth lead "screams". | 2007-10-27T05:55:40Z | Sebastien Verrot | A french dancer, Spoke, dancing to techno music with a combination of smurf, break dance and tecktonik. | ["Electronic music", "House music", "Music", "Techno"] | ["techno", "low quality", "dj scratching sound effects", "groovy bass", "buzzy synth leads", "punchy \"4 on the floor\" kick pattern", "shimmering hi hats", "claps", "energetic", "weird", "aggressive"] | 4 | nvoGwmKh6NI | 4592 |
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;