musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Dubstep"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- electronic music · 2 ✖
- medium tempo · 2 ✖
- atmospheric synthesiser 1
- club 1
- club music 1
- dance groove 1
- dance hits 1
- dance music 1
- dance pop 1
- digital drums 1
- dissonant 1
- drum machine 1
- drum rhythm 1
- edm 1
- eerie 1
- electronic drums 1
- enigmatic 1
- female vocals 1
- heavily synthesised 1
- high notes 1
- high pitched 1
- no singer 1
- pad 1
- party music 1
- pop 1
- psychedelic 1
- synth 1
- trance 1
- transition effect 1
- trap 1
- trippy 1
- youthful 1
musiccaps_names (array) 7 ✖
- Dubstep · 2 ✖
- Music 2
- Electronic music 1
- Electronica 1
- Sampler 1
- Techno 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mt Eden Dubstep - Sarah McLachlan: Silence | A female vocalist sings this trippy vocal riff. The tempo is medium with atmospheric synthesiser and digital drums. The song is heavily synthesised and is psychedelic, intense, enigmatic, mysterious and youthful with a dance groove. This song is an EDM/Electro Pop song. | 2009-06-12T09:12:04Z | Mt Eden Official | ► FREE DOWNLOAD : http://click.dj/mreden/sarah-mclachlan-silence-mt-eden-remix ► Facebook: https://www.facebook.com/MtEdenOfficial ► SoundCloud: http://soundcloud.com/mtedenofficial ► YouTube: http://www.youtube.com/MtEdenDnB08 ► Twitter: https://twitter.com/MtEdenOfficial ► Beatport: http://www.beatport.com/artist/mt-ede... Cheers for all the support . We can't wait to share more with you Enjoy | ["Electronic music", "Music", "Dubstep"] | ["female vocals", "electronic music", "enigmatic", "medium tempo", "atmospheric synthesiser", "electronic music", "high notes", "high pitched", "dissonant", "psychedelic", "heavily synthesised", "drum rhythm", "digital drums", "drum machine", "youthful", "dance music", "dance hits", "pop", "dance pop", "club", "club music", "dance music", "party music", "dance groove", "edm", "trance", "trap", "trippy"] | 7 | Nymjfq2kXnI | 2384 | |
Maishäckseln 2015 | Maisernte | Chopping Maize | FENDT | CLAAS | DEUTZ | NEW HOLLAND | This is an electronic music piece with characteristics of the German industrial scene. A sharp synth is playing the main theme while there is a faint high-pitched pad in the background. A transition effect is used before the drum beat starts. The rhythmic background is provided by a medium tempo electronic drum beat. There is an eerie atmosphere to this piece. It could be used in the soundtrack of a dystopian-future themed movie or a video game. | 2015-09-26T20:29:00Z | LandtechnikMünsterland | Watch in 1080p! Das Lohnunternehmen Klein-Hitpaß aus Lankern häckselt Mais für einen Milchviehbetrieb im Münsterland. Gehäckselt wurde mit einem Claas Jaguar 960+ Claas Orbis 750. Abgefahren wurde mit mehreren Gespannen der Marken Fendt,Deutz,Claas,New Holland. Kamera:Sony,GoPro Musik:MachinimaSound.com Copyright by LandtechnikMünsterland | ["Sampler", "Music", "Techno", "Trance music", "Dubstep", "Electronica"] | ["electronic music", "no singer", "synth", "pad", "electronic drums", "transition effect", "eerie", "medium tempo"] | 9 | brEMnFXsTqo | 3661 |
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;