musiccaps_details (view)
1 row where musiccaps_aspects contains "dance groove", musiccaps_aspects contains "groovy bass line", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "trance music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| 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;