Add a hoursJson column with structured open hours per day, then use a server-side selector mapping that compares current time to the hours data and renders an Open Now or Opens at 8pm pill. Caching duration should be short (under an hour) for the open-status pill to feel accurate, while the rest of the page caches longer.

Add a holidayOverrides column with a JSON array of date-specific overrides. The selector mapping that determines open status checks holiday overrides before falling back to weekly hours. During winter holidays when one in three clinics closes early, this is the difference between a useful directory and one that gets abandoned.

Yes. Add an onSiteSurgery boolean and a surgicalSpecialties array column. A clinic that handles laceration repair on-site is meaningfully different from one that stabilizes and transfers to a specialty hospital. Owners with GDV or foreign-body cases need surgical clinics, not transfer points, and surfacing this saves critical time.

Add an icuBeds numeric column plus an oxygenCage and ventilator boolean column. Render as a small data block on each hospital page. Pet owners with critically ill animals (parvo puppies, heatstroke dogs, ARDS cats) need to know which hospitals can keep their pet stable for 48 hours, not just stabilize for transfer.

Yes. Define a specialty-emergency page group with /emergency-vets/{specialty}/{city}/ pattern. The filtered roster shows only hospitals with on-staff specialists or specialty consultation availability. This serves the referral path for general-practice vets sending out specialty cases overnight.

Some 24/7 hospitals route incoming cases to overflow partners when at capacity. Add a capacityStatus column with values like accepting, overflow-only, or full, updated by the hospital via a sheet permission. Render as a status pill on the hospital page. This avoids the worst experience of driving to a closed-to-new-patients emergency room at midnight.

Yes. Add an acceptedInsurance array column. Most emergency hospitals accept any insurance because they bill the owner directly, but some have direct-billing relationships with Trupanion or Nationwide that change the payment experience meaningfully. Surface this with a list mapping rendering carrier logos.

Google Maps shows pins by name and basic hours but cannot surface ICU capacity, on-site surgery, accepted insurance, or specialty availability. A SleekRank directory layers exactly those decision-driving fields with structured filtering, which turns the directory into a genuinely useful triage tool rather than a list of nearby names.