musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic dance music" and musiccaps_aspects contains "techno pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- electronic dance music · 2 ✖
- medium tempo 2
- techno pop music · 2 ✖
- all night party 1
- ambient noises 1
- average audio quality 1
- car repair video 1
- dance floor 1
- dance groove 1
- dance music 1
- dance party 1
- dance rhythm 1
- disc scratching noises 1
- discotheque 1
- dj face off 1
- dj turntable 1
- energetic 1
- exciting 1
- female singer 1
- groovy bass line 1
- groovy music 1
- keyboard accompaniment 1
- male vocals 1
- poor audio quality 1
- rapping vocals 1
- relaxing 1
- steady 1
- tambourine percussions 1
- trance music 1
- video soundtrack 1
- vocal chants 1
- vocal harmony 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2010-09-30 1
- 2014-09-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Place DJ NIFFTY - 2010 World DMC DJ Championships - South African Final | A male singer sings this rapping vocals with a backup singer. The song is medium tempo with a groovy drum rhythm, disc scratching sounds, strong bass line and string accompaniment. The song is groovy and has a dance rhythm. The song audio quality is poor. | 2010-09-30T14:21:46Z | edptv | Produced by: www.blackbirdproductions.co.za 2010 South African DMC DJ Championships Final. MULTI-CAM of Live Set - DJ NIFFTY - Club Atmospheer - Cape Town - South Africa. RESULTS: 1st - DJ NIFFTY (2010 South African DMC DJ Champion) http://www.youtube.com/watch?v=6YXjJ6ABnZU 2nd - DJ CODAX http://www.youtube.com/watch?v=dibExyXfC3c 3rd - DJ ON Q http://www.youtube.com/watch?v=rCIoFNNOdOE FINALISTS: DJ CALCULUS http://www.youtube.com/watch?v=kvmBoL-tmtA DJ SHAMELESS http://www.youtube.com/watch?v=Uo5YJZ6RFbI DJ MARV D http://www.youtube.com/watch?v=1NqCsKCitfA DJ JUICE http://www.youtube.com/watch?v=J4xzSdnnFLM | ["Scratching (performance technique)", "Electronic music", "Music", "Speech"] | ["techno pop music", "male vocals", "rapping vocals", "dance party", "all night party", "discotheque", "dance floor", "dance rhythm", "energetic", "exciting", "medium tempo", "dj turntable", "ambient noises", "poor audio quality", "dance music", "electronic dance music", "groovy music", "dj face off", "disc scratching noises"] | 1 | 6YXjJ6ABnZU | 766 | |
Car Alarm Actual Demo by Pulse Creative Innovations Toyota Isuzu Mitsubishi Honda Hyundai Nissan Kia | A female singer sings this vocal harmony with backup singers. The song is medium tempo with a steady drumming rhythm, tambourine percussion, groovy bass line and keyboard accompaniment. The song is trance-like and groovy. The song is a modern techno dance with an average audio quality. The song serves as a sound track for a car repairing video. | 2014-09-29T06:10:53Z | PCI HQ | Pulse Creative Innovations (PCI) is proud to bring you another innovation in the automotive industry.Pulse Creative Innovaton's Car alarm immobilizer (wouldn't start.. if not used to open the by the remote.. anti-theft feature which is one of the most effective. -autoremind when forgot to set the alarm -autoremind when doors locked via remote when a door is not properly/fully closed -silent/stealth mode -trunk release may be optional to this alarm system -very reliable alarm -blinking of interior and exterior lighting when a door is left open -autolock when driving after a few minutes -applicable to any car/auv/suv -shock sensitivity control We also have an available veteran electrical technician for your car accessory installations and minor electrical troubleshooting. *Meet-ups for the purchase is available even on weekends and holidays, just text ahead of time *Home services are still available as usual *Original Receipt can be provided for reimbursement of your service/products acquired Meeting places for product purchases: - Shell the Fort (for Makati Area) - Shell Katipunan in front of Miriam College (for QC Area) - Shell near Tiendesitas (C5 corner Julia Vargas Ave.) (for Pasig Area) -for South Area, SM Bicutan (additional 100 only) - for North Area: SM North (add 100 only) Additional fee in home services may apply Feel free to contact us for further inquiries and for the prices 24/7 OPEN (1st in the Philippines) Contact Us Smart - 0910-8897168 Sun - 0933-4541896 Globe -- 0917-4937886 (Viber)/ 0927-7084229 Landline:985-2216; Email: pulsecreative@ymail.com Official Website: http://www.pulsecreativeinnovations.com/ Facebook:https://www.facebook.com/PulseCreativeInnovations/ NOW ACCEPTING CREDIT CARD, DEBIT CARD AND GCASH OFFICE INFO: ADDRESS: Block 7 Lot 3 Narra St. Phase 1B Greenwoods Executive Village, near Mercedes Ave. Pasig City https://www.google.com.ph/maps/place/Pulse+Creative+Innovations/@14.5621308,121.0985547,17z/data=!3m1!4b1!4m2!3m1!1s0x3397c7c89c8e63a9:0xe86a42a361c4261e (f… | ["Music", "Zing"] | ["techno pop music", "electronic dance music", "car repair video", "video soundtrack", "medium tempo", "female singer", "dance groove", "relaxing", "trance music", "vocal chants", "vocal harmony", "keyboard accompaniment", "groovy bass line", "medium tempo", "tambourine percussions", "average audio quality", "steady"] | 1 | OFJG5Wo_knI | 2418 |
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;