Database Schema of NNDSS
| Tracking # |
20-01156-FOIA |
| Submitted | April 3, 2020 |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Matt Chapman
To Whom It May Concern:
Pursuant to the Freedom of Information Act, I hereby request the following records:
The names of all tables and all columns of all databases stored within the NNDSS system.
As the requested information will be used as the foundation for future requests, please expedite this request to that those future requests can be submitted ASAP.
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 20 business days, as the statute requires.
Sincerely,
Matt Chapman,
The Chicago Reporter
From: Centers for Disease Control and Prevention
Dear Chapman,Matt,
The status of your FOIA request #20-01156-FOIA has been updated to the following status 'Received'. To log into the CDC FOIA Public Access Link click on the Application URL below.
https://foia.cdc.gov/
Sincerely,
Centers for Disease Control and Prevention / Agency for Toxic Substances and Disease Registry
From: Centers for Disease Control and Prevention
Dear Matt Chapman,
Case Number 20-01156-FOIA has been assigned to the request you submitted. In all future correspondence regarding this request please reference case number 20-01156-FOIA.
Regards,
Centers for Disease Control and Prevention / Agency for Toxic Substances and Disease Registry
From: Centers for Disease Control and Prevention
Dear Chapman,Matt,
The status of your FOIA request #20-01155-FOIA has been updated to the following status 'Received'. To log into the CDC FOIA Public Access Link click on the Application URL below.
https://foia.cdc.gov/
Sincerely,
Centers for Disease Control and Prevention / Agency for Toxic Substances and Disease Registry
From: Centers for Disease Control and Prevention
Dear Matt Chapman,
Case Number 20-01155-FOIA has been assigned to the request you submitted. In all future correspondence regarding this request please reference case number 20-01155-FOIA.
Regards,
Centers for Disease Control and Prevention / Agency for Toxic Substances and Disease Registry
From: Centers for Disease Control and Prevention
April 16, 2020
Request Number: 20-01155-FOIA
Dear Mr. Chapman: This is regarding your Freedom of Information Act (FOIA) request of April 6, 2020, for To Whom It May Concern:Pursuant to the Freedom of Information Act, I hereby request the following records:The names of all tables and all columns of all databases stored within the NNDSS system.As the requested information will be used as the foundation for future requests, please expedite this request to that those future requests can be submitted ASAP.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 20 business days, as the statute requires.Sincerely,Matt Chapman,The Chicago Reporter.
Please see the attached letter.
Sincerely,
CDC/ATSDR FOIA Office
770-488-6399
From: Matt Chapman
Thank you for the link, however the records provided do not match the criteria for my request.
I am looking for the database schema of the DBMS itself. For example, if the DBMS is Oracle, the following SQL can be run to complete the request:
select col.table_name,
col.column_name,
from sys.all_tab_columns col
order by col.column_id;
Please let me know if you have any questions -- happy to speak over the phone.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on . Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on . Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on . Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on . Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on . Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on April 3, 2020. Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on April 3, 2020. Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on April 6, 2020. Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on April 6, 2020. Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Freedom of Information Act request, copied below, and originally submitted on April 6, 2020. Please let me know when I can expect to receive a response. You had assigned it reference number #20-01156-FOIA.
Thanks for your help, and let me know if further clarification is needed.
From: Centers for Disease Control and Prevention
Mr. Chapman,
Your request 20-001156 was a duplicate to 20-01155. Therefore it was closed administratively and you received the information in our 20-01155 response.
Best,
Jonesa Davis
Files
pages