COVID-19 Long Term Care facility data collection schema and documentation
| Submitted | Oct. 27, 2021 |
| Est. Completion | None |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Ben Welsh
To Whom It May Concern:
Pursuant to the Iowa Open Records Law, I hereby request the following records:
The schema or data dictionary of all data tables used to compile records on COVID-19 cases, deaths and outbreaks at long-term care faculties. I am requesting a copy of the names of the tables and columns that store the data collected by the state, as well as any documentation used to describe and define the databases.
The requested documents will be made available to the general public, and this request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 10 business days, as the statute requires.
Sincerely,
Ben Welsh
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Iowa Open Records Law request, copied below, and originally submitted on Oct. 27, 2021. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Department of Public Health
Dear Mr. Welsh. Please find the attached document and information in
response to your request for forms used to compile Covid-19 cases, deaths
and outbreaks at long-term care facilities.
A word document of the form used to collect information for all COVID-19
cases is attached. The form is formatted differently in Domo, but the
question that captures if a case works at a LTC facility is in the
'Work/School' section and if a case lives in a LTC facility is in the
'Household' section. Both sections have a question for the 'LTC Facility
Name' that is pre-populated with the Iowa LTC facilities. Screenshots of
the questions as they appear in Domo are provided below. All of the other
information captured on the form is the same for all COVID-19 cases.
*Work/School: LTC staff questions*
[image: image.png]
*Household: LTC resident questions*
[image: image.png]
[image: image.png]
All COVID-19 deaths are tracked by Vital Records. However, Vital Records
doesn't know that the decedent is a resident of a LTC when the death is
reported.
Please let us know if you have any questions.
Thanks!
--
Open Records
Iowa Department of Public Health
*Protecting and improving the health of Iowans*
--
Open Records
Iowa Department of Public Health
*Protecting and improving the health of Iowans*
--
This email message and its attachments may contain confidential information
that is exempt from disclosure under Iowa Code chapters 22, 139A, and other
applicable law. Confidential information is for the sole use of the
intended recipient. If you believe that you have received this transmission
in error, please reply to the sender, and then delete all copies of this
message and any attachments. If you are not the intended recipient, you are
hereby notified that any review, use, retention, dissemination,
distribution, or copying of this message is strictly prohibited by law.
From: Department of Public Health
Hello, Mr. Welsh.
Unfortunately, we do not have most of the requested information in the
format in which it is requested, but have provided a few screenshots below.
There is an excel document and a card in Domo that are used to track LTC
outbreaks. The column headers are provided below. The excel spreadsheet
has a tab for the 'Current Outbreaks' and a tab for the 'Past Outbreaks'.
[image: image.png]
[image: image.png]
Please let us know if you have any questions.
Thanks!
Rebecca McMahon
---------- Forwarded message ---------
From: RERC, IDPH <rerc@idph.iowa.gov>
Date: Thu, Oct 28, 2021 at 8:28 AM
Subject: Fwd: Iowa Open Records Law Request: COVID-19 Long Term Care
facility data collection schema and documentation
To: IDPH OpenRecords <idphopenrecords@idph.iowa.gov>
---------- Forwarded message ---------
From: <requests@muckrock.com>
Date: Wed, Oct 27, 2021 at 9:20 PM
Subject: Iowa Open Records Law Request: COVID-19 Long Term Care facility
data collection schema and documentation
To: <RERC@idph.iowa.gov>
Department of Public Health
ORA Office
321 East 12th Street
Des Moines, IA 50319-0075
October 27, 2021
To Whom It May Concern:
Pursuant to the Iowa Open Records Law, I hereby request the following
records:
The schema or data dictionary of all data tables used to compile records on
COVID-19 cases, deaths and outbreaks at long-term care faculties. I am
requesting a copy of the names of the tables and columns that store the
data collected by the state, as well as any documentation used to describe
and define the databases.
The requested documents will be made available to the general public, and
this request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform
me of the total charges in advance of fulfilling my request. I would prefer
the request filled electronically, by e-mail attachment if available or
CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I
look forward to receiving your response to this request within 10 business
days, as the statute requires.
Sincerely,
Ben Welsh
View request history, upload responsive documents, and report problems here:
https://www.muckrock.com/
Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com
For mailed responses, please address (see note):
MuckRock News
DEPT MR 120671
411A Highland Ave
Somerville, MA 02144-2516
PLEASE NOTE: This request is not filed by a MuckRock staff member, but is
being sent through MuckRock by the above in order to better track, share,
and manage public records requests. Also note that improperly addressed
(i.e., with the requester's name rather than "MuckRock News" and the
department number) requests might be returned as undeliverable.
--
Data Governance | Bureau of Public Health Performance | Iowa Department of
Public Health *|* Lucas State Office Building *|* 321 East 12th Street *|* Des
Moines, Iowa 50319 *| *RERC@idph.iowa.gov*|*
--
Open Records
Iowa Department of Public Health
*Protecting and improving the health of Iowans*
--
This email message and its attachments may contain confidential information
that is exempt from disclosure under Iowa Code chapters 22, 139A, and other
applicable law. Confidential information is for the sole use of the
intended recipient. If you believe that you have received this transmission
in error, please reply to the sender, and then delete all copies of this
message and any attachments. If you are not the intended recipient, you are
hereby notified that any review, use, retention, dissemination,
distribution, or copying of this message is strictly prohibited by law.
From: Department of Public Health
Hello, Mr. Welsh.
Unfortunately, we do not have most of the requested information in the
format in which it is requested, but have provided a few screenshots below.
There is an excel document and a card in Domo that are used to track LTC
outbreaks. The column headers are provided below. The excel spreadsheet
has a tab for the 'Current Outbreaks' and a tab for the 'Past Outbreaks'.
[image: image.png]
[image: image.png]
Please let us know if you have any questions.
Thanks!
Rebecca McMahon
--
Open Records
Iowa Department of Public Health
---------- Forwarded message ---------
From: <requests@muckrock.com>
Date: Wed, Oct 27, 2021 at 9:20 PM
Subject: Iowa Open Records Law Request: COVID-19 Long Term Care facility
data collection schema and documentation
To: <RERC@idph.iowa.gov>
Department of Public Health
ORA Office
321 East 12th Street
Des Moines, IA 50319-0075
October 27, 2021
To Whom It May Concern:
Pursuant to the Iowa Open Records Law, I hereby request the following
records:
The schema or data dictionary of all data tables used to compile records on
COVID-19 cases, deaths and outbreaks at long-term care faculties. I am
requesting a copy of the names of the tables and columns that store the
data collected by the state, as well as any documentation used to describe
and define the databases.
The requested documents will be made available to the general public, and
this request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform
me of the total charges in advance of fulfilling my request. I would prefer
the request filled electronically, by e-mail attachment if available or
CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I
look forward to receiving your response to this request within 10 business
days, as the statute requires.
Sincerely,
Ben Welsh
View request history, upload responsive documents, and report problems here:
https://www.muckrock.com/
Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com
For mailed responses, please address (see note):
MuckRock News
DEPT MR 120671
411A Highland Ave
Somerville, MA 02144-2516
*Protecting and improving the health of Iowans*
--
This email message and its attachments may contain confidential information
that is exempt from disclosure under Iowa Code chapters 22, 139A, and other
applicable law. Confidential information is for the sole use of the
intended recipient. If you believe that you have received this transmission
in error, please reply to the sender, and then delete all copies of this
message and any attachments. If you are not the intended recipient, you are
hereby notified that any review, use, retention, dissemination,
distribution, or copying of this message is strictly prohibited by law.
Files
pages