Healthcare Pandemic Preparedness Records
This dataset provides detailed simulated patient records, healthcare resource utilization, and system alerts across multiple pandemic scenarios, enabling robust modeling of health system preparedness and policy impact analysis. It supports granular tracking of resource strain, patient outcomes, and facility-level responses, making it invaluable for strategic planning and emergency response simulations.
Sample rows
preview · 8 of 200 rows · all 23 columns| patient_idstring | resource_typestring | resource_quantityinteger | alert_typestring | simulation_scenario_idstring | admission_datetimedatetime | discharge_datetimedatetime | ageinteger | genderstring | diagnosis_codestring | symptomsstring | severity_levelstring | hospital_idstring | resource_utilization_start_datetimedatetime | resource_utilization_end_datetimedatetime | alert_idstring | alert_datetimedatetime | facility_street_addressstring | facility_citystring | facility_statestring | facility_postal_codestring | facility_countrystring | alert_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PAT-0031 | icu_bed | 1 | resource_shortage | COVID19-WAVE1 | 2020-04-12T09:24:00 | 2020-04-16T14:53:00 | 57 | female | U07.1 | fever,cough,shortness of breath | severe | HOSP-1003 | 2020-04-12T09:45:00 | 2020-04-15T19:20:00 | ALRT-10001 | 2020-04-12T10:00:00 | 1200 Pine St | Seattle | WA | 98101 | USA | ICU bed shortage reported at HOSP-1003 during COVID19-WAVE1. |
| PAT-0032 | general_bed | 1 | blank | COVID19-WAVE1 | 2020-04-14T13:11:00 | 2020-04-20T10:08:00 | 42 | male | J09.X2 | cough,headache | moderate | HOSP-1004 | 2020-04-14T13:25:00 | 2020-04-20T09:30:00 | blank | blank | 4401 15th Ave | Minneapolis | MN | 55455 | USA | blank |
| PAT-0033 | general_bed | 1 | blank | COVID19-WAVE2 | 2020-09-05T16:44:00 | 2020-09-11T11:02:00 | 29 | female | J10.1 | headache,sore throat | mild | HOSP-1005 | 2020-09-05T17:00:00 | 2020-09-11T10:30:00 | blank | blank | 3200 Main St | Houston | TX | 77002 | USA | blank |
| PAT-0034 | medication | 2 | blank | FLU2021-SIM1 | 2021-02-18T07:18:00 | 2021-02-19T16:42:00 | 63 | male | J11.0 | fever,body aches | moderate | HOSP-1007 | 2021-02-18T07:40:00 | 2021-02-19T16:00:00 | blank | blank | 2155 North St | Boston | MA | 02115 | USA | blank |
| PAT-0035 | ventilator | 1 | resource_shortage | COVID19-WAVE2 | 2020-09-07T14:20:00 | blank | 34 | male | U07.1 | fever,cough,chest pain | severe | HOSP-1003 | 2020-09-07T14:50:00 | blank | ALRT-10002 | 2020-09-07T15:01:00 | 1200 Pine St | Seattle | WA | 98101 | USA | Ventilator shortage at HOSP-1003 during simulation COVID19-WAVE2. |
| PAT-0036 | medication | 1 | blank | FLU2021-SIM2 | 2021-03-09T10:33:00 | 2021-03-12T09:47:00 | 46 | female | J11.1 | fever,sore throat,runny nose | mild | HOSP-1008 | 2021-03-09T10:45:00 | 2021-03-12T09:00:00 | blank | blank | 7885 Elm St | Toronto | ON | M6H2B7 | Canada | blank |
| PAT-0037 | icu_bed | 1 | outbreak | COVID19-WAVE1 | 2020-04-18T19:40:00 | 2020-04-23T17:27:00 | 75 | female | J09.X2 | shortness of breath,weakness | critical | HOSP-1001 | 2020-04-18T20:10:00 | 2020-04-23T17:00:00 | ALRT-10003 | 2020-04-18T20:15:00 | 800 Oak Ave | Vancouver | BC | V6H3N1 | Canada | COVID-19 outbreak cluster detected at HOSP-1001. |
| PAT-0038 | icu_bed | 1 | staffing_issue | COVID19-WAVE2 | 2020-09-10T07:55:00 | blank | 59 | male | U07.1 | fever,cough,fatigue | critical | HOSP-1002 | 2020-09-10T08:30:00 | blank | ALRT-10004 | 2020-09-10T08:45:00 | 233 King St | Toronto | ON | M5V1J5 | Canada | Staffing shortage at HOSP-1002 ICU during COVID19-WAVE2. |
| PAT-0039 | medication | 1 | blank | FLU2021-SIM1 | 2021-02-20T14:30:00 | 2021-02-22T10:18:00 | 21 | female | J11.1 | sore throat,runny nose | mild | HOSP-1010 | 2021-02-20T14:45:00 | 2021-02-22T09:50:00 | blank | blank | 3100 Douglas Rd | Vancouver | BC | V5G3M2 | Canada | blank |
| PAT-0040 | ventilator | 1 | resource_shortage | COVID19-WAVE1 | 2020-04-21T07:13:00 | blank | 68 | male | U07.1 | fever,shortness of breath | critical | HOSP-1006 | 2020-04-21T07:30:00 | blank | ALRT-10005 | 2020-04-21T08:00:00 | 411 River Rd | Chicago | IL | 60601 | USA | Ventilator shortage at HOSP-1006 during COVID19-WAVE1. |
| PAT-0041 | icu_bed | 1 | blank | COVID19-WAVE2 | 2020-09-15T11:22:00 | 2020-09-19T15:11:00 | 80 | male | U07.1 | fatigue,shortness of breath | severe | HOSP-1002 | 2020-09-15T11:40:00 | 2020-09-19T14:40:00 | blank | blank | 233 King St | Toronto | ON | M5V1J5 | Canada | blank |
| PAT-0042 | medication | 1 | blank | FLU2021-SIM1 | 2021-02-21T10:18:00 | blank | 36 | female | J11.0 | body aches,headache | mild | HOSP-1007 | 2021-02-21T10:30:00 | blank | blank | blank | 2155 North St | Boston | MA | 02115 | USA | blank |
| PAT-0043 | general_bed | 1 | blank | COVID19-WAVE1 | 2020-04-16T15:29:00 | 2020-04-20T12:30:00 | 54 | male | U07.1 | fever,cough | moderate | HOSP-1004 | 2020-04-16T16:00:00 | 2020-04-20T11:30:00 | blank | blank | 4401 15th Ave | Minneapolis | MN | 55455 | USA | blank |
| PAT-0044 | icu_bed | 1 | resource_shortage | COVID19-WAVE2 | 2020-09-18T18:45:00 | blank | 72 | other | U07.1 | cough,fatigue | severe | HOSP-1005 | 2020-09-18T19:00:00 | blank | ALRT-10006 | 2020-09-18T19:20:00 | 3200 Main St | Houston | TX | 77002 | USA | Shortage of ICU beds at HOSP-1005 during COVID19-WAVE2. |
| PAT-0045 | medication | 1 | blank | FLU2021-SIM2 | 2021-03-15T15:19:00 | 2021-03-17T11:08:00 | 48 | male | J10.1 | sore throat,body aches | moderate | HOSP-1008 | 2021-03-15T15:30:00 | 2021-03-17T10:45:00 | blank | blank | 7885 Elm St | Toronto | ON | M6H2B7 | Canada | blank |
| PAT-0046 | icu_bed | 1 | blank | COVID19-WAVE2 | 2020-09-20T09:55:00 | 2020-09-26T16:02:00 | 68 | male | U07.1 | fever,weakness | severe | HOSP-1006 | 2020-09-20T10:15:00 | 2020-09-26T15:30:00 | blank | blank | 411 River Rd | Chicago | IL | 60601 | USA | blank |
| PAT-0047 | general_bed | 1 | blank | COVID19-WAVE1 | 2020-04-25T13:47:00 | blank | 51 | female | J09.X2 | cough,weakness | moderate | HOSP-1001 | 2020-04-25T14:00:00 | blank | blank | blank | 800 Oak Ave | Vancouver | BC | V6H3N1 | Canada | blank |
| PAT-0048 | general_bed | 1 | blank | COVID19-WAVE2 | 2020-09-23T16:30:00 | 2020-09-29T09:12:00 | 39 | female | U07.1 | cough,headache | moderate | HOSP-1004 | 2020-09-23T16:45:00 | 2020-09-29T09:00:00 | blank | blank | 4401 15th Ave | Minneapolis | MN | 55455 | USA | blank |
| PAT-0049 | medication | 2 | blank | FLU2021-SIM1 | 2021-02-23T12:07:00 | 2021-02-26T18:33:00 | 55 | female | J11.1 | fever,body aches | moderate | HOSP-1010 | 2021-02-23T12:25:00 | 2021-02-26T18:00:00 | blank | blank | 3100 Douglas Rd | Vancouver | BC | V5G3M2 | Canada | blank |
| PAT-0050 | icu_bed | 1 | staffing_issue | COVID19-WAVE1 | 2020-04-28T08:49:00 | 2020-05-02T09:43:00 | 66 | male | J09.X2 | shortness of breath,weakness | severe | HOSP-1003 | 2020-04-28T09:10:00 | 2020-05-02T09:00:00 | ALRT-10007 | 2020-04-28T09:15:00 | 1200 Pine St | Seattle | WA | 98101 | USA | Nurse shortage in ICU at HOSP-1003 during COVID19-WAVE1. |
What the 200 rows show
from the 200-row samplePpe (resource type) stands out: mean resource_
- 1median resource_
quantity - 2facility countries
- 4genders
- 4severity levels
- 22facility states
- 38simulation scenarios
Median 1, from 1 to 150.
- string 16
- integer 2
- datetime 5
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 16 columns | |||
patient_id | string | Unique identifier for each simulated patient recordunique | PAT-0031 |
simulation_scenario_id | string | Identifier for the pandemic simulation scenario | COVID19-WAVE1 |
gender | string | Gender of the patientmale · female · other · unknown | female |
diagnosis_code | string | Primary diagnosis code (ICD-10 or similar) | U07.1 |
symptoms | string | Comma-separated list of observed symptomsoptional | cough,headache |
severity_level | string | Severity of the case at admissionmild · moderate · severe · critical | severe |
hospital_id | string | Identifier for the hospital or facility | HOSP-1003 |
resource_type | string | Type of healthcare resource utilized (e.g., ICU bed, ventilator)6 values | icu_bed |
alert_id | string | Unique identifier for the health system alertunique · optional | ALRT-10001 |
alert_type | string | Type of alert issued (e.g., resource shortage, outbreak, policy change)5 values · optional | resource_shortage |
alert_description | string | Detailed description of the alertoptional | ICU bed shortage reported… |
facility_street_address | string | Street address of the hospital or facilityoptional | 1200 Pine St |
facility_city | string | City where the hospital or facility is locatedoptional | Seattle |
facility_state | string | State or region of the hospital or facilityoptional | WA |
facility_postal_code | string | Postal code of the hospital or facilityoptional | 98101 |
facility_country | string | Country of the hospital or facility2 countries · optional | USA |
| Numbers 2 columns | |||
age | integer | Age of the patient at admission0 to 120 | 57 |
resource_quantity | integer | Quantity of the resource utilized0 or more | 1 |
| Dates and times 5 columns | |||
admission_datetime | datetime | Date and time the patient was admitted | 2020-04-12T09:24:00 |
discharge_datetime | datetime | Date and time the patient was dischargedoptional | 2020-04-16T14:53:00 |
resource_utilization_start_datetime | datetime | Start date and time of resource utilization | 2020-04-12T09:45:00 |
resource_utilization_end_datetime | datetime | End date and time of resource utilizationoptional | 2020-04-15T19:20:00 |
alert_datetime | datetime | Date and time the alert was issuedoptional | 2020-04-12T10:00:00 |
Use it for
A healthcare dashboard
Resource_
quantity by resource_ type and a breakdown of alert_ type. Excel, Power BI or Tableau. Why do the 29 ppe rows have a mean resource_
quantity of 35.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Patients200PAT-00311icu_bedPAT-00321general_…PAT-00331general_…
A software demo
Believable patients with simulation_
scenario_ id, admission_ datetime and discharge_ datetime to fill a screen in front of a buyer.
This dataset200 rows23 columns
Yours1,000 rows23 columnsfacility_street_address: UK only
blueprint · healthcare-pandemic-preparedness-records
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 23 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Include patient demographics and symptoms
- Resource usage per facility per day
- Alert logs for system responses
- Integrate simulated imaging features
- Ensure anonymization and privacy compliance
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- healthcare-pandemic-preparedness-records