Correspondence between

| didn't get a chance to ask Martha about Junaid's access today, although she may not know anyway as he is gone this week. | certainly appreciate all the work you and Yan have done. Sent from my iPhone

When: Wednesday, December 16, 2015 1:30 PM-2:30 PM (UTC-05:00) Eastern Time (US & Canada). Where: 877-873-8017; 7931338 Scheduling per Corinne Miller’s request. Corinne will dial in as the host. Those located in Capitol View Bldg. are welcome to join the call in her office. 877-873-8017 Passcode: 7931338 Dec 16" (Wed) 1-2PM Thank you! Jasnese Bowlery Executive Secretary te Corinne Miler Sureau of Disexse Control, Prevention and Epidemiology MMehigan Department of Health & Mumen Services 203 Townsend Straat Lansing, Michigan 42923 Phone: (S17) S55-8734 Faw: (S27) 335-8285 << OLE Object: Picture (Device Independent Bitmap) >> xxxEND_PAGE:dhhs03_b0475_1725_1726_2

Yes, CLPPP and EBL staff plan to reach cut.

Oh no. Is there anyway that Mona could explain to them why they should have the investigation? She has credibility that we don't? Sent from my iPhone

Very Interesting and what we have been saying.

xxxEND_PAGE:dhhs02_b0614_2228_2229_1 002229 if you haven't seen the Bridge article based on Zip codes statewide the link to the article is in the text below. The alder annual reports an the MDHHS web site don’t suppress info, of course.

Yes, i'm serry. Go ahead and send her the update.

Can | send Linda the lead report for 12/7? This is the update, not the zip. Thanks, Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemioiagy Section |Michigan Department of Health and Human Services| Lifecourse Epidemiology and Genomics Division [PQ Box 30195 / 201 Townsend St 4" Floor - Lansing, MI 48909 | Cell ‘ PPI H {Office ph: 517-335-9456 Fax 517-335-9790 | [email protected] : : Work Hours: M_F 7:30am —4:00 pm Michigan has a public records law. Most written communications to or from state officials regarding state business are public records available to the public and media upon request. Your e-mail communications and any attachments to them may be subject to public disclosure. This message, including any attachments is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure, or distribution of any confidential and/or privileged information xxxEND_PAGE:dhhs02_b0611_2223_2224_1 002224 eenttofded in this CATH is expressly protibéted. if you are nett the intetnied recipient, phease eentdct the sender by reply e-rrril/ att! destroy any aid all copies of the orginal message. xxxEND_PAGE:dhhs02_b0611_2223_2224_2

Okay, thanks.

State20151204 rtf; 2014 zips.xlsx Hi all, Some of these are arepeat. Lead by zip code for 2044 is my file and is new. | ran this today to cornpare te Bob’s numbers. Bob’s file is “2044 zins” The ‘Documenting the SAS cade ‘fle walks through the numbers from the raw dataset to the final analytic fle that Yan and {| used. Bob has 143,123 for 2014 andi have 141,355 for children less than 6 years. Any thoughts. [would like to send the ‘Docurnenting the numbers to Boh/Martha/Junaid ASAP, Patti

igan.gav>; LyonCallo, Sarah (DHHS) <!y Is there anything | can do to step on the warehouse to give Junaid access? | don’t know if Martha sent in the form indicating permission needed to be granted ASAP. Corinne xxxEND_PAGE:dhhs02_b0431_1629_1629_1

He pulled by specimen date. Yan is going to document the number of records at each step when we deduplicated. We ran into this before with Flint where Bobs results and ours didn't agree and it was that we were including cap. This time we have fewer observations, but I'm not clear about how Bob deduplicated. Sent from my iPhone

xxxEND_PAGE:dhhs02_b0427_1617_1620_1 001618 Thanks Corinne. There is a flurry of emails about children by zip for 2014. Bob gave his numbers and the total differs

Until Junaicl has access to the warehouse, Pattl with Yan's additional support would be updating the blood leed test counts. Once Junaid has acress to the warehouse data he should be able to take this function an. {My understanding was that Patti has already demonstrated to you [Martha, Linda, Junaid] haw she pulis the data from the warehouse and then can provide SAS code for the analysis to Junaid.)

1 deduplicated this by year {this analyses} and by time period(previous analyses}. How are you deduplicating? Bob, the results from the last analysis are attached. These are pending Corinne’s approval, prior to forwarding. They are FY until Corinne approves. Patti

Thanks Patti!

No need to work on the weekend or get excel tables today. Let's address things on Monday.

(S) Thanks. Have a great holiday and | should be able to send you afl revised numbers on Monday. Patti

Goodness, do net work over weekend!

Hi all, | deduplicated to year for the state. | have SAS output for 2010-2015 by agegroup and by Michigan, Genesee, and Flint. By quarter and then broke 2015 to 1/1 to 9/30 and 10/1 onward. | can share the SAS output with you, but I’m entering into excel, which will be easier to read. The hand entering is going slowly, so | may not have the excel tables ready by this afternoon. also want Yan to double check the code that | modified to create the yearly datasets. So rough numbers | can provide today, something more polished probably won't be available until Monday. Unless | work on it during the weekend. Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemiology Section | Michigan Department of Health ang Human Lifecourse Epidemiology and Genomics Division [PC Box 30195 / 251 Townsend St 4" Floar - Lansing, Mi 48909 | Cell i ffice ph: 517-335-9456 Fax 517-335-9790 | [email protected] ‘ Work Hours: M_F 7:30am— 4:00 pm Michigan has a public records law. Most written communications to or from state officials regarding state business are public records available to the public and media upon request. Your e-mail communications and any attachments to them may be subject to public disclosure. This message, including any attachments is intended solely for the use of the named recipient(s) and. may contain confidential and/or privileged information. Any unauthorized review, use, disclosure, or distribution of any confidential and/or privileged information contained in this e-mail is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. xxxEND_PAGE:dhhs02_b0385_1466_1468_2 001468 xxxEND_PAGE:dhhs02_b0385_1466_1468_3

Yes, tell them the tables aren’t copying weil and they can refer to the exce! workbook.

Hi all, Bob Scott updated me on the upload of child lead data into the warehouse “As of next Monday, we'll be two weeks behind on Lead records in the Warehouse. Jessica’s computer (and everyone’s around here) was upgraded to Office 2013 last Friday. ....but Access 2013 will not handle DBF files. We have used Access for a few years as a pass-through to get the DBF format (dates, | think) exactly right for loading to the Warehouse. When | get back, I’ll work with the folks from Optum to see what we can do about getting files in Warehouse-ready format.” Bob will be back next Monday. ican pull data from the warehouse next Monday, but be aware that it may not be complete. Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epiderniology Section | Michigan Department of Health and Human Services | Lifecourse Epidemiology and Genomics Division | PO Box 30195 / 201 Townsend St 4" Floor - Lansing, MI 48909 | Cell Work Hours: M_F 7:30am — 4:00 pm Michigan has.a public records law. Most written communications to or from state officials regarding state business are public records available to the public and media upon request. Your e-mail communications and any attachments to them may be subject to public disclosure. xxxEND_PAGE:dhhs03_b0401_1522_1524_2 001524 This message, inclsttiag any attainments is intedred solely for the use af the RAHA reciprent(s) anh may eerttitin confistentia! and/or priviteged informtrtion. Any uirrtrehorzed review, use, dactesure, or distribation of any confitential endfor prviteged informenion eomtofded in this emi! is exprasty protibited. if you are net the irtterrfed recipient, please ewrtdct the sender by reply exraill art! destroy any td all copies of fe original messoge. xxxEND_PAGE:dhhs03_b0401_1522_1524_3

.20v>; LyonCallo, Sarah (DHHS) Talking Points: e <!--[if of positive lead tests (greater than or equal to 5 mcg/dl) vary over time partly due to small numbers and seasonal fluctuation. e = <!--[if after the 2010 quarters rates were below the state 5 year average in most Flint zip codes. e <!--[if in Quarter 3 of 2014 rates increased in all Flint zip codes except 48507 e = <!--[if Q1 2015 rates decreased, but begin rising and are highest in Q3 of 2015 in zip codes 48503 and 48504. e <!--[if for Q4 2015 is incomplete and based on tests drawn after October 1, with results reported to and processed in the MDHHS data warehouse. Data from this quarter should not be used for comparison until the quarter is complete. Also saved in the document Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemiology Section [Michigan Department of Health and Human i ifecourse Epidemiology and Genomics Division [PO Box 30195 / 201 Townsend St 4° Floor - Lansing, MI 48909 | Cell S47- Office ph: 517-335-9456 Fax 517-335-9790 | [email protected] Work Hours: M_F 7:30am — 4:00 pm xxxEND_PAGE:dhhs03_b0729_2549_2550_1 002550 Wiebipan hes a public records AW. Ment writen earmminiruaisns © or fem state officials regarthag state bursipress are pullléc reeurds availkitte te the public anid medita upon request. Your (adil EORIMHONe Sons ard any atter'NnRTits to them may be subject t public dRCRSUrE. This message, inclstiing any atecNnRres is INteInIed sofely for the use of the REAL recipent(s) a?it! may eeritizin confittentla! endfor priviteged informusion. Any uTetehtrized review, use, daciiesure, or dtribation ef any confidential and/ar priviteged information eentiafded in this CPR is expresty protibheted. if you are Pelt te irteedefed recipient, phease eentitict tre sender by reply G7! antl destroy any and all capies of the original message. xxxEND_PAGE:dhhs03_b0729_2549_2550_2

Thank you and Patth {and Yan}! Linda is in Flint this rnorning $0 | propose sending it to the larger group, including Linda. But Sarah - give me a call when you get back fram your mecting with Deb Kimball.