Table 2.
Completeness of data submitted via the CCDAa and ELRb.
| Data field | CCDA data (N=86,499), n (%) | ELR data (N=408,741), n (%) | |
| Lab-confirmed SARS-CoV-2 | 11,491 (13.3) | 53,968 (13.2) | |
| Facility name/reporting lab | |||
|
|
Nonmissing | 86,499 (100.0) | 408,737 (100.0) |
|
|
Useful | 86,499 (100.0) | 408,463 (99.9) |
| Patient first name | |||
|
|
Nonmissing | 86,499 (100.0) | 408,732 (100.0) |
|
|
Useful | 86,499 (100.0) | 408,717 (100.0) |
| Patient last name | |||
|
|
Nonmissing | 86,499 (100.0) | 408,732 (100.0) |
|
|
Useful | 86,497 (100.0) | 408,718 (100.0) |
| Patient date of birth | |||
|
|
Nonmissing | 86,489 (100.0) | 408,270 (99.9) |
|
|
Useful | 86,480 (100.0) | 407,730 (99.9) |
| Patient sex (male/female/unknown) | |||
|
|
Nonmissing | 86,416 (99.9) | 408,540 (100.0) |
|
|
Useful | 86,405 (99.9) | 398,590 (97.5) |
| Patient race | |||
|
|
Nonmissing | 85,794 (99.2) | 382,097 (93.5) |
|
|
Useful | 71,345 (82.5) | 215,273 (52.7) |
| Patient ethnicity | |||
|
|
Nonmissing | 85,799 (99.2) | 333,122 (81.5) |
|
|
Useful | 68,507 (79.2) | 165,715 (49.7) |
| Patient address | |||
|
|
Nonmissing | 86,498 (100.0) | 385,073 (94.2) |
|
|
Useful | 85,471 (98.8) | 384,000 (93.9) |
| Patient city | |||
|
|
Nonmissing | 86,499 (100.0) | 408,741 (100.0) |
|
|
Useful | 86,499 (100.0) | 408,741 (100.0) |
| Patient zip code | |||
|
|
Nonmissing | 86,377 (99.9) | 408,026 (99.8) |
|
|
Useful | 86,375 (99.9) | 407,918 (99.8) |
| Patient home or cell phonec | |||
|
|
Nonmissing | 20,712 (23.9) | 321,121 (78.6) |
|
|
Useful | 20,712 (23.9) | 319,974 (78.3) |
| Test name (open text field) | |||
|
|
Nonmissing | 86,499 (100.0) | 408,694 (100.0) |
|
|
Useful | 86,499 (100.0) | 408,694 (100.0) |
| Logical Observation Identifiers Names and Codes (LOINC) | |||
|
|
Nonmissing | 0 | 408,741 (100.0) |
|
|
Useful | 0 | 408,727 (100.0) |
| Test results (raw feed/open text field) | |||
|
|
Nonmissing | 55,783 (64.5) | 405,650 (99.2) |
|
|
Useful | 55,235 (62.1) | 396,110 (96.9) |
| Test results (interpreted from open text fieldc) | |||
|
|
Nonmissing | 86,499 (100.0) | 408,741 (100.0) |
|
|
Useful | 86,499 (100.0) | 408,741 (100.0) |
| Test date | |||
|
|
Nonmissing | 83,999 (97.1) | 408,046 (99.8) |
|
|
Useful | 83,999 (97.1) | 408,046 (99.8) |
| Hospitalization (yes/no)d | |||
|
|
Nonmissing | 86,499 (100.0) | 0 |
|
|
Useful | 86,499 (100.0) | 0 |
| Comorbidities | |||
|
|
Nonmissing | 86,499 (100.0) | 0 |
|
|
Useful | 86,499 (100.0) | 0 |
aCCDA: consolidated clinical document architecture.
bELR: electronic laboratory reporting.
cCCDA completeness represents at least 1 phone number from either the home or cell data fields; the ELR feed has 1 phone field, so home and fields cell are not differentiated. “Nonmissing” refers to a populated data field. “Useful” refers to clean, complete information in a data field. Data were labeled not useful if any of the following were present in their respective fields: “unknown” in race, ethnicity, address, or other string fields; for address, the presence of PO boxes, unknown, homeless, or N/A; for phone, an implausible number (eg, 111-1111 or 999-999-9999), or less than 10 numbers; and for zip code, less than 5 digits or 99999, 00000, or letters (eg, “UUUUU”).