Yan Tian

Hi, Patti, Please find the attached file for the different Child_ID in our dataset and Bob’s dataset! Thanks, xxxEND_PAGE:dhhs02_b0443_1788_1797_01 001789 Yan

Great Bob. That is helpful. Yan do you have few minutes to meet with me? We can decide how to approach this.

Patti, i don’t have much further to add at this point, beyond what | showed you yesterday fooking at actual specimen dates and DOBs—i.e., f think the “Just Dates” file shows that my age calculations are correct. Not knowing SAS, | don’t know how to adjust the cade to adjust the SAS date calculations, but | think that’s what needs to be done. lll be happy to heip, if there is anything | can do. We do seem to be calculating the same number of individuals (differed by 1), and we're pulling zip code fram the same field, so f think it boils down to how the age is calculated. Bob xxxEND_PAGE:dhhs02_b0443_1788_1797_02 001790

HI Bob, Following up with you. Have you had a chance to look at the data? Yan is here today and can assist with exploring if the difference between the two datasets is due to how age Is calculate Please let us know. Thanks! Patti

Hi, Patti, fam wondering whether this problem has already been rescived. Otherwise, | can work on it. Thanks, Yan

xxxEND_PAGE:dhhs02_b0443_1788_1797_03 001791 My apologies. Yan is attending a training taday and isn’t in the office. Please let me know if ican assist you with this today. Thanks, Patti

Bob, tran the data for 2014 and | believe that the differences are due ta rounding, though | haven’t quantified them yet. ’'m copying Yan because she may have a way to look at this quicker, faster and easier than us manually reviewing records. Yan, Bob and | analyzed 2014 by zipcode for the state and got cifferent numbers. We have been asked to find out why. The Just Dates excel file is fram Bab- where he looked at individual level data to try to figure cut if the difference could be due to the way we are categorizing age. (You could create SAS dataset, which may make it easier to analyze. ©) Documenting the SAS cede is my atternpt to quantify each step by age group. Lead 2014 by zip is my analysis with SAS 2014 zips is Bob’s analysis Bob has 143,123 for 2014 and | have 141,355 for children less than 6 years. Yan, can you compare Bob's Just dates to the 2014 analytic file we created in SAS. Also I see results that have missing for sample type so we are including them ~—i thought this might be a difference too. i suspect it has to do with INTCK —do you know how it handles rounding? xxxEND_PAGE:dhhs02_b0443_1788_1797_04 001792 Thanks, Patti

xxxEND_PAGE:dhhs02_b0427_1617_1620_2 001619 Hi, Patti, Please find the attached tables and SAS codes for the updated lead data fram 2010 to 12/04/2015! also cleaned and annotated our SAS code from 2010 to 2015 and saved it in the folder T:\MCH Vital Records Data\Genesee Lead\Lead Dedup to Calendar year. If you have any question, please let me know! Thanks, Yan

Lead data for the year to date (based on specimen date) are in the file named Lead_1.1.15_12.4.15_spec date in this folder T:\MCH Vital Records Data\Genesee Lead\Access data from biquery They would like it deduplicated by year (for the state) and reported by quarter, for Michigan, Genesee and Flint. Highest test only. | created this folder T:\MCH Vital Records Data\Genesee Lead\Lead Dedup to Calendar year to keep the code and results and just the word document is fine. The word document says ‘state 2015, but it includes Genesee and Flint too. | did another query by report date for 12/4/2015 and found that the earliest specimen date was sometime in August 2015, so we don’t’ need to rerun the earlier years. xxxEND_PAGE:dhhs02_b0427_1617_1620_3 001620 Thanks so much for doing this, let me know if you have any questions. Also we will need prepare the codes that we use (annotate, clean if needed) to hand this off to Environmental Health. Patricia McKane, DVM MPH - Manager, Maternal & Child Health Epidemioiagy Section | Michigan Department of Health and Human 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_b0427_1617_1620_4

Hi, Patti, Please find the attached tables for Flint lead test for the period Jan 1, 2012 to April 14, 2074! For Children <6 years, 112 out of 3811 children have high lead result {EBLL>=S); For Children 6-17 years, 5 out of 676 children have high lead result (EBLL>=! For Adults 18+6 years, 22 out of 170 children have high lead result (EBLE: if you have any question, please fet me know! Thanks, Yan 01/01/2013 to 04/14/14 Children meg/dl meg/dl meg/dl meg/dl xxxEND_PAGE:dhhs02_b0521_2002_2004_1 002003 ee ee ee Children receiving blood lead test | 1987__| Capillary 1987__[ 1921 Table 2: Elevated Blood Levels among Children 6 years to 17 years, Flint MI, Specimen collected 01/01/2013 to 04/14/14 Total < 5-14 15-44 45+ Total > 5 Children meg/dl meg/dl meg/dl meg/dl meg/dl Tested | n_| % % 0 5 % Children receiving blood lead test | 1 [20] o | 0 | | 2 | 0. 2 Unknown oof o foto] o | Table 3: Elevated Blood Levels among Adults, Flint MI, Specimen collected 01/01/2013 to 04/14/14 Total 5-14 15-44 45+ Total > 5 Adults meg/dl meg/dl meg/dl meg/dl | no | % | n | % % | % | | %_| Adults receiving blood lead test | 0 | |_0_| | 0 | | | ft | o | o | 1 | 20 | | o | o | 4 | po [ o fo | Capillary

HI Yan, We were asked to provide the number of children < 6 years of age, tested and number >= 5 EBLL for Flint (same zip codes as before) for the time period Jan 1, 2013 through Dec 31, 2013. Deduplicated to child Id, retaining highest test. Does that make sense? They need it ASAP. Thank you and let me know if any questions. Patricia McKane, GVM MPH - Manager, Maternal & Child Health Epidemiclogy Section | Michigan Department of Health and Hurnan se si Lifecourse Epidemicicgy and Genomics Division [PO Box 30295 / 201 Townsend St 4° Floor ~ Lansing, Mi 42909 f Celf £ H Office ph: §17-335-9456 Fax $17-335-9790 | McKanepai michigan. gov xxxEND_PAGE:dhhs02_b0521_2002_2004_2 002004 Watkk Hours: MEE 7399911 =-49@ om Miéthigan has a pubtic records law. Merit written eonmenististions to er from state officials regarding state business are public records availhittte to the public art] media upon request. Your e-mail eonmaonitetions and amy attachments to them may be subject to pubiic dischssure. This message, indhetting any attevhnferts is ineerated sofely for the use of the RUAPE reeipfent(s) afd may eenttiin confittential and/or privdeged information. Any urretrehorized review, use, disclosure, or distribation of any confidential and/or privileged information eorrtiofded in this e-rnall is expressly promibéted. if you are net the interred recipient, please contact the semver by reply e-rrai! ent destroy any anu ail copies of the original massage. xxxEND_PAGE:dhhs02_b0521_2002_2004_3