# Clinical Data in the ODM

**URL:** <https://odm.discourse.group/t/clinical-data-in-the-odm/146>\
**Category:** Support\
**Tags:** odm-v2, data-types, mapping\
**Created:** [February 13, 2024, 9:28pm UTC](https://odm.discourse.group/t/clinical-data-in-the-odm/146 "2024-02-13T21:28:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![matthomson](https://avatars.discourse-cdn.com/v4/letter/m/dec6dc/32.png) [@matthomson](https://odm.discourse.group/u/matthomson)\
**Post date:** [February 13, 2024, 9:28pm UTC](https://odm.discourse.group/t/clinical-data-in-the-odm/146/1 "2024-02-13T21:28:59Z")

</div>

A user requested support with integrating COVID-19 case counts and hospitalization data into the larger wastewater/environmental surveillance database that is in ODM format. They were wanting to integrate the data in a wide format.

As a reminder, the wide names for measures follow the structure: `compartment_specimen_fraction_measure_unit_aggregation_index_attribute`

So the pieces for this clinical data would be:

- Compartment = hum (for human)
- Specimen = po (for population)
- Fraction = NA (not relevant for clinical data)
- Measure = cov (for covid-19 infection)
- Unit = confEp (if we’re talking about confirmed cases by episode date) **OR**
- Unit = confRep (if we’re talking about confirmed cases by report date) **OR**
- Unit = acti (if we’re talking about active cases) **OR**
- Unit = hosa (if we’re talking about Hospital admissions) **OR**
- Unit = vax1plus, vax2plus, vax3plus, vax4plus, or vax1, vax2, vax3, vax4 (if we’re talking about vaccination levels, depending on how many doses and one weather you want “at least x doses” or “exactly x doses”)
- Aggregation = 7dma (if we’re talking about a 7-day moving average) **OR**
- Aggregation = sum14 (if we’re talking about a rolling sum of previous 14 days -? I’d also recommend checking out the parts for daily count (daiCo) and cumulative count (cuCo)) **OR**
- Aggregation = total (if it’s just a count).
- index = NA (not relevant)
- Attribute = value (given that we are reporting/integrating the counts/numbers).

So:

- COVID-19 confirmed cases by episode date by sewershed → **hum\_po\_NA\_cov\_confEp\_total\_NA\_value**
- 7-day moving average of sewershed’s COVID-19 confirmed cases by episode date → **hum\_po\_NA\_cov\_confEp\_7dma\_NA\_value**
- COVID-19 active cases by episode date (rolling sum of previous 14 days) by sewershed → **hum\_po\_NA\_cov\_acti\_sum14\_NA\_value**
- COVID-19 cases by reported date (date case was reported to public health) by sewershed → **hum\_po\_NA\_cov\_confRep\_total\_NA\_value**
- 7-day moving average of sewershed’s COVID-19 cases by reported date → **hum\_po\_NA\_cov\_confRep\_7dma\_NA\_value**
- COVID-19 hospital admissions by sewershed → **hum\_po\_NA\_cov\_hosa\_total\_NA\_value**
- 7-day moving average of sewershed’s COVID-19 hospital admissions → **hum\_po\_NA\_cov\_hosa\_7dma\_NA\_value**
- COVID-19 vaccine coverage by sewershed - All ages with at least two doses → **hum\_po\_NA\_cov\_ vax2plus\_total\_NA\_value**
- COVID-19 vaccine coverage by sewershed - All ages with at least three doses → **hum\_po\_NA\_cov\_ vax3plus\_total\_NA\_value**
- COVID-19 vaccine coverage by sewershed - All ages with at least four doses → **hum\_po\_NA\_cov\_ vax4plus\_total\_NA\_value**

@asmabahamyirou

---

<div class="post-metadata">

**Author:** ![asmabahamyirou](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@asmabahamyirou](https://odm.discourse.group/u/asmabahamyirou)\
**Post date:** [February 14, 2024, 1:52pm UTC](https://odm.discourse.group/t/clinical-data-in-the-odm/146/2 "2024-02-14T13:52:02Z")

</div>

Thank you @matthomson. is that make sense to use

- **actiEp** - as active cases by episode date

---

<div class="post-metadata">

**Author:** ![matthomson](https://avatars.discourse-cdn.com/v4/letter/m/dec6dc/32.png) [@matthomson](https://odm.discourse.group/u/matthomson)\
**Post date:** [February 14, 2024, 6:13pm UTC](https://odm.discourse.group/t/clinical-data-in-the-odm/146/3 "2024-02-14T18:13:04Z")

</div>

For sure! If your active cases are organized/recorded by episode date, then that part makes sense. I’ll double check we don’t already have it, but you should see it in the development dictionary shortly.