Data Sources
Where key PetWisePlus datasets come from, and when they were last refreshed.
| Dataset | Provider | PetWisePlus Refreshed | Provider Updated | Status | Notes |
|---|---|---|---|---|---|
|
Affordability resources
affordability_resources
|
manual | Feb 10, 2026, 6:19 PM UTC | Unknown | OK | Curated affordability resources (grants/financing/discount programs). |
|
Condition FAQ/Media Support Content
condition_support_content
|
curated_templates_plus_references | Feb 19, 2026, 11:14 AM UTC | Unknown | OK | Condition FAQ/media support content refreshed for condition detail pages. conditions_scanned=525, created_faq=0, updated_faq=24, created_media=0, skipped_fk_mismatch=517. |
|
Condition Structured Content
condition_structured_content
|
etl_curated_guideline_refs | Feb 19, 2026, 11:15 AM UTC | Unknown | OK | Condition enrichment refreshed. conditions_scanned=525, sections=3150, triage=1052, diagnosis=527, citations=3150, condition_meds=2. |
|
Daily Catalog ETL Pipeline
daily_catalog_etl_pipeline
|
celery-beat | Feb 14, 2026, 11:00 AM UTC | Unknown | OK | Daily ETL complete. store_products=38, vaccines=18, guides=8, medications=252 (publishable=236), fda_apps=1053, openfda_cases=1961, med_condition_links=396, med_diagnosis_codes=96, health_faq_rows=26, health_media_rows=19, health_condition_sections=3150, health_condition_citations=3150, health_condition_med_links=303, broken_links=76. Warnings=1. |
|
FDA Animal Drug Product Listing Directory (NDC)
fda_animal_drug_product_listing_directory
|
FDA | Feb 19, 2026, 11:00 AM UTC | Unknown | OK | Downloaded XLS (zipped) and imported package/product NDCs + listing metadata. |
|
FDA Animal Drugs @ FDA (Applications Catalog)
fda_animal_drugs_at_fda_catalog
|
FDA | Feb 19, 2026, 11:00 AM UTC | Unknown | OK | Application/product records imported from Animal Drugs @ FDA advancedSearch endpoint. |
|
FDA Animal Drugs @ FDA (Previews: labels/docs)
fda_animal_drugs_at_fda_previews
|
FDA | Feb 19, 2026, 11:00 AM UTC | Unknown | OK | Preview payloads cached from FDA retrievePreviewBean + SPL link metadata. |
|
Health Daily ETL Pipeline
health_daily_etl_pipeline
|
manual | Feb 19, 2026, 11:00 AM UTC | Unknown | OK | Health data pipeline complete. conditions=525 reviewed=490 concepts=511 symptoms=55 sections=3150 citations=3150 triage=1052 faq=26 media=19. |
|
Medication-condition links
medication_condition_links
|
PetWisePlus | Feb 19, 2026, 11:11 AM UTC | Unknown | OK | scanned=252, created=396, updated=0, deleted=396, medication_id=all |
|
Medication Content Enrichment (FDA/openFDA)
medication_content_enrichment_fda
|
FDA + openFDA | Feb 19, 2026, 11:10 AM UTC | Unknown | OK | Enriched medication narrative fields from FDA label highlights and openFDA reaction terms. changed=0. |
|
Medication Content Quality
medication_content_quality
|
petwiseplus-etl | Feb 19, 2026, 11:11 AM UTC | Unknown | OK | Medication content quality normalization complete. changed=0, verified=0, seeded=236, placeholders=16, total=252, manufacturer_backfilled=0, missing_manufacturer=16. |
|
Medication Daily ETL Pipeline
medication_daily_etl_pipeline
|
celery-beat | Feb 19, 2026, 11:00 AM UTC | Unknown | OK | Medication ETL complete. medications=252 (verified=0, placeholder=16), fda_apps=1053, openfda_cases=1993, condition_links=396, diagnosis_codes=96, documents=1614, field_facts=581. |
|
Medication Diagnosis Codes
medication_diagnosis_codes
|
condition_link_crosswalk | Feb 19, 2026, 11:14 AM UTC | Unknown | OK | Backfilled medication diagnosis codes from medication-condition links. scanned=396, created=0, updated=122, skipped_no_map=274. |
|
openFDA Animal/Veterinary Adverse Events (Case Summaries)
openfda_animal_vet_adverse_event_cases
|
FDA openFDA | Feb 19, 2026, 11:10 AM UTC | Unknown | OK | Imported recent openFDA animal/veterinary adverse event reports and linked them to medications by active ingredient. |
|
openFDA Animal/Veterinary Adverse Events (Top Reactions)
openfda_animal_vet_adverse_reactions
|
FDA openFDA | Feb 19, 2026, 11:06 AM UTC | Unknown | OK | Imported openFDA reaction-term counts and mapped them to medication species buckets. |
|
Pet insurance providers
pet_insurance_providers
|
fixture | Feb 10, 2026, 6:55 PM UTC | Unknown | OK | Insurance provider/plan catalog imported from a curated JSON file. |
|
Preventive Care: Guides
preventive_guides
|
seed | Feb 11, 2026, 4:49 AM UTC | Unknown | OK | Imported guides: created=6 updated=2 (dry_run=False) |
|
Preventive Care: Vaccines
preventive_vaccines
|
seed | Feb 11, 2026, 4:49 AM UTC | Unknown | OK | Imported vaccines: created=14 updated=4 (dry_run=False) |
|
Site Link Integrity
site_link_integrity
|
internal_link_checker | Feb 14, 2026, 11:11 AM UTC | Unknown | OK | Link check complete. pages=80, links=7729, broken=76. |
|
Site Link Remediation
site_link_remediation
|
known_url_rewrite_rules | Feb 16, 2026, 12:36 PM UTC | Unknown | OK | Auto-remediation run complete. checked=2, updated=2. |
|
Store Product Catalog
store_product_catalog
|
seed | Feb 11, 2026, 4:47 AM UTC | Unknown | OK | Catalog refreshed from products.json (json). Warnings: 0. |
How we rank clinics
Clinic ordering prioritizes urgency context, proximity, and data completeness. Emergency-capable clinics are elevated on emergency paths, while non-pet/human facilities are filtered out.
Rankings are deterministic and tied to the same safety/routing rules used by symptom and intake flows.