Database Schema of NNDSS

Matt Chapman filed this request with the Centers for Disease Control and Prevention of the United States of America.
Tracking #

20-01156-FOIA

Due May 1, 2020
Est. Completion None
Status
Awaiting Response

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.

Files

pages

Close