Diabetes in the United States

Jacqueline Nosrati

Overview

Diabetes is becoming more common in American society for reasons such as increasing obesity and certain lifestyle changes. Today people tend to have much more hectic lives, work longer, and have changes in family roles. In today’s day and age everthing has to be fast and convenient for consumers, with ever-evolving technology and soon with self-driving cars that reduce physical activity among people in order to achieve something faster than before. Additionally, consumers turn to fast and inexpensive foods that have high calorie and/or sugar content and have increasingly easier access to fast food(Welch 2003).

In this week’s assignment I will examine adult diabetes rates in the U.S. across different states and counties. In addition, I will look at the ratio of soda prices to the national average and fast food expenditures per capita to see whether there is relationship between these two variables and diabetes rates.

Literature Review

Going through the literature, there were two findings. First, a 2015 study looked at comsumption of sugar-containing drinks by region and found that 64% of US adults drink sugar-containing drink once or more everyday. The chances of drinking a sugar-containing drink once or more per day are higher in the Northeast region than in the Midwest and West regions(Park, McGuire, and Galuska 2015). Second, a 2012 study from California found that sugar amounts in food and drinks have statistically significant effects on diabetes, while keeping other variables such as other food types(Basu et al. 2013).

Data & Variables

To study diabetes rates I will use data from the 2014 Food Environment Atlas data set, which is offered by the U.S. Department of Agriculture and contains data on food access, food prices, health and SES. I selected the following variables:

  • PCT_DIABETES_ADULTS10: This variable shows the percentage of adults with diabetes in 2010 for each county and state. I chose this variable as my overall topic of interest. I expect that diabetes is more common in larger cities where people have more access to sodas and fast food and where the weather is colder (specifically, East Coast).

  • SODA_PRICE10: This variable shows the ratio of soda prices to the national average for 2010. I chose this variable because it is known that excessive sugar consumption can lead to diabetes. I expect that those states with lower soda price ratios tend to have a higher percentage of individuals with diabetes.

  • PC_FFRSALES07: This variable shows the Fast Food Expenditures per capita in dollars. I chose this variable because it is also known that excessive fast food consumption can lead to diabetes. I expect that those states with higher fast food expenditures tend to have higher diabetes rates.

To analyze US diabetes rates, data was merged with a map of the United States on a county-level. In this case, the states of Hawaii and Alaska were excluded.

US Diabetes Rates

Looking at the map, we see that the highest diabetes rates (15 to 20%) can be found more in the Northeast and Southeast regions, specifically in Missisipi, Alabama, and South Carolina. In the Northern region there is one outlier with 15 to 20% diabetes, which is in South Dakota. This seems to confirm the hypothesis that areas with larger cities (the Northeast) and colder weather tend to have higher diabetes rates.

Soda Prices to National Average Ratios

Looking at the soda price ratios, we see that the highest soda prices are in Washington, Oregon, and California. Additionally, the lowest soda prices are again in the Northeast and Southeast. This seems to confirm the hypothesis that states with lower diabetes rates tend to have higher soda prices and states with lower soda prices have higher diabetes rates.

Fast Food Expenditures per Capita

When looking at fast food expenditures per capita in dollars we see that the state with the highest fast food expenditure is Nevada (with 1000 and 1100 dollars). This is followed by California, Oregon, Arizona, Colorado, and New Mexico. Interestingly, Nevada confirms the hypothis that the state with the highest fast food expenditures per capita, tends to to have one of the highest diabetes rates.

Conclusion

In conclusion, we see that diabetes rates are the highest in the North and Southeast regions and that soda prices do affect diabetes rates so that states with higher soda prices tend to have lower diabetes rates. Finally, we can see that in the case of Nevada that fast food expenditures per capita affect diabetes rates somewhat by stating that higher expenditures means higher diabetes rates. This conclusion can help organizations explain diabetes in United States and factors that affect those rates.

Bibliography

Basu, Sanjay, Paula Yoffe, Nancy Hills, and Robert H Lustig. 2013. “The Relationship of Sugar to Population-Level Diabetes Prevalence: An Econometric Analysis of Repeated Cross-Sectional Data.” PloS One 8 (2). Public Library of Science: e57873.

Park, Sohyun, Lisa C McGuire, and Deborah A Galuska. 2015. “Regional Differences in Sugar-Sweetened Beverage Intake Among Us Adults.” Journal of the Academy of Nutrition and Dietetics 115 (12). Elsevier: 1996–2002.

Welch, Garry. 2003. “Spending in the Us on Advertising for Fast Foods, Sodas, and Automobiles.” Diabetes Care 26 (2). Am Diabetes Assoc: 546–46.

LS0tDQp0aXRsZTogIldlZWsgMTAiDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCmJpYmxpb2dyYXBoeTogc29jNzEyX3dlZWsxMC5iaWINCi0tLQ0KDQoNCiMjKipEaWFiZXRlcyBpbiB0aGUgVW5pdGVkIFN0YXRlcyAqKg0KDQojIyMjSmFjcXVlbGluZSBOb3NyYXRpDQoNCiFbXShodHRwOi8vd3d3Lnp5cm9wYXRoeS5jb20vd3AtY29udGVudC91cGxvYWRzLzIwMTYvMDcvQ0RDX3VyZ2VzX3RvX2NoZWNrX3lvdXJfcmlza19mb3JfZGlhYmV0ZXNfNDAweDMwMDUwMHgyODAtMS5qcGcpDQoNCg0KIyMjT3ZlcnZpZXcNCg0KRGlhYmV0ZXMgaXMgYmVjb21pbmcgbW9yZSBjb21tb24gaW4gQW1lcmljYW4gc29jaWV0eSBmb3IgcmVhc29ucyBzdWNoIGFzIGluY3JlYXNpbmcgb2Jlc2l0eSBhbmQgY2VydGFpbiBsaWZlc3R5bGUgY2hhbmdlcy4gVG9kYXkgcGVvcGxlIHRlbmQgdG8gaGF2ZSBtdWNoIG1vcmUgaGVjdGljIGxpdmVzLCB3b3JrIGxvbmdlciwgYW5kIGhhdmUgY2hhbmdlcyBpbiBmYW1pbHkgcm9sZXMuIEluIHRvZGF5J3MgZGF5IGFuZCBhZ2UgZXZlcnRoaW5nIGhhcyB0byBiZSBmYXN0IGFuZCBjb252ZW5pZW50IGZvciBjb25zdW1lcnMsIHdpdGggZXZlci1ldm9sdmluZyB0ZWNobm9sb2d5IGFuZCBzb29uIHdpdGggc2VsZi1kcml2aW5nIGNhcnMgdGhhdCByZWR1Y2UgcGh5c2ljYWwgYWN0aXZpdHkgYW1vbmcgcGVvcGxlIGluIG9yZGVyIHRvIGFjaGlldmUgc29tZXRoaW5nIGZhc3RlciB0aGFuIGJlZm9yZS4gQWRkaXRpb25hbGx5LCBjb25zdW1lcnMgdHVybiB0byBmYXN0IGFuZCBpbmV4cGVuc2l2ZSBmb29kcyB0aGF0IGhhdmUgaGlnaCBjYWxvcmllIGFuZC9vciBzdWdhciBjb250ZW50IGFuZCBoYXZlIGluY3JlYXNpbmdseSBlYXNpZXIgYWNjZXNzIHRvIGZhc3QgZm9vZFtAd2VsY2gyMDAzc3BlbmRpbmddLiANCg0KSW4gdGhpcyB3ZWVrJ3MgYXNzaWdubWVudCBJIHdpbGwgZXhhbWluZSBhZHVsdCBkaWFiZXRlcyByYXRlcyBpbiB0aGUgVS5TLiBhY3Jvc3MgZGlmZmVyZW50IHN0YXRlcyBhbmQgY291bnRpZXMuIEluIGFkZGl0aW9uLCBJIHdpbGwgbG9vayBhdCB0aGUgcmF0aW8gb2Ygc29kYSBwcmljZXMgdG8gdGhlIG5hdGlvbmFsIGF2ZXJhZ2UgYW5kIGZhc3QgZm9vZCBleHBlbmRpdHVyZXMgcGVyIGNhcGl0YSB0byBzZWUgd2hldGhlciB0aGVyZSBpcyByZWxhdGlvbnNoaXAgYmV0d2VlbiB0aGVzZSB0d28gdmFyaWFibGVzIGFuZCBkaWFiZXRlcyByYXRlcy4gDQogDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSx3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFfQ0KbGlicmFyeShkcGx5cikNCmxpYnJhcnkodGlkeXZlcnNlKQ0KbGlicmFyeSh0aWR5cikNCmxpYnJhcnkocmVhZHIpDQpsaWJyYXJ5KHJlYWR4bCkNCmxpYnJhcnkoc2YpDQpsaWJyYXJ5KHRtYXApDQpsaWJyYXJ5KHRtYXB0b29scykNCmxpYnJhcnkodGlncmlzKQ0KbGlicmFyeShzcGRlcCkNCmxpYnJhcnkoZGF0YS53b3JsZCkNCmxpYnJhcnkoQ2l0ZSkNCmBgYA0KDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJ30NCnVzX21hcCA8LSBzdF9yZWFkKCJDOi9Vc2Vycy9QYXBhL0Rlc2t0b3AvU29jIDcxMiAtUi90bF8yMDE2X3VzX2NvdW50eS90bF8yMDE2X3VzX2NvdW50eS5zaHAiLCBzdHJpbmdzQXNGYWN0b3JzID0gRkFMU0UpDQpgYGANCg0KYGBge3IsbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRSwgcmVzdWx0cz0naGlkZSd9DQpuYW1lcyh1c19tYXApDQpgYGANCg0KIyMjTGl0ZXJhdHVyZSBSZXZpZXcNCg0KR29pbmcgdGhyb3VnaCB0aGUgbGl0ZXJhdHVyZSwgdGhlcmUgd2VyZSB0d28gZmluZGluZ3MuIEZpcnN0LCBhIDIwMTUgc3R1ZHkgbG9va2VkIGF0IGNvbXN1bXB0aW9uIG9mIHN1Z2FyLWNvbnRhaW5pbmcgZHJpbmtzIGJ5IHJlZ2lvbiBhbmQgZm91bmQgdGhhdCA2NCUgb2YgVVMgYWR1bHRzIGRyaW5rIHN1Z2FyLWNvbnRhaW5pbmcgZHJpbmsgb25jZSBvciBtb3JlIGV2ZXJ5ZGF5LiBUaGUgY2hhbmNlcyBvZiBkcmlua2luZyBhIHN1Z2FyLWNvbnRhaW5pbmcgZHJpbmsgb25jZSBvciBtb3JlIHBlciBkYXkgYXJlIGhpZ2hlciBpbiB0aGUgTm9ydGhlYXN0IHJlZ2lvbiB0aGFuIGluIHRoZSBNaWR3ZXN0IGFuZCBXZXN0IHJlZ2lvbnNbQHBhcmsyMDE1cmVnaW9uYWxdLiBTZWNvbmQsIGEgMjAxMiBzdHVkeSBmcm9tIENhbGlmb3JuaWEgZm91bmQgdGhhdCBzdWdhciBhbW91bnRzIGluIGZvb2QgYW5kIGRyaW5rcyBoYXZlIHN0YXRpc3RpY2FsbHkgc2lnbmlmaWNhbnQgZWZmZWN0cyBvbiBkaWFiZXRlcywgd2hpbGUga2VlcGluZyBvdGhlciB2YXJpYWJsZXMgc3VjaCBhcyBvdGhlciBmb29kIHR5cGVzW0BiYXN1MjAxM3JlbGF0aW9uc2hpcF0uIA0KDQojIyNEYXRhICYgVmFyaWFibGVzDQoNClRvIHN0dWR5IGRpYWJldGVzIHJhdGVzIEkgd2lsbCB1c2UgZGF0YSBmcm9tIHRoZSAyMDE0IEZvb2QgRW52aXJvbm1lbnQgQXRsYXMgZGF0YSBzZXQsIHdoaWNoIGlzIG9mZmVyZWQgYnkgdGhlIFUuUy4gRGVwYXJ0bWVudCBvZiBBZ3JpY3VsdHVyZSBhbmQgY29udGFpbnMgZGF0YSBvbiBmb29kIGFjY2VzcywgZm9vZCBwcmljZXMsIGhlYWx0aCBhbmQgU0VTLiBJIHNlbGVjdGVkIHRoZSBmb2xsb3dpbmcgdmFyaWFibGVzOiANCg0KKiAqKlBDVF9ESUFCRVRFU19BRFVMVFMxMDoqKiBUaGlzIHZhcmlhYmxlIHNob3dzIHRoZSBwZXJjZW50YWdlIG9mIGFkdWx0cyB3aXRoIGRpYWJldGVzIGluIDIwMTAgZm9yIGVhY2ggY291bnR5IGFuZCBzdGF0ZS4gSSBjaG9zZSB0aGlzIHZhcmlhYmxlIGFzIG15IG92ZXJhbGwgdG9waWMgb2YgaW50ZXJlc3QuIEkgZXhwZWN0IHRoYXQgZGlhYmV0ZXMgaXMgbW9yZSBjb21tb24gaW4gbGFyZ2VyIGNpdGllcyB3aGVyZSBwZW9wbGUgaGF2ZSBtb3JlIGFjY2VzcyB0byBzb2RhcyBhbmQgZmFzdCBmb29kIGFuZCB3aGVyZSB0aGUgd2VhdGhlciBpcyBjb2xkZXIgKHNwZWNpZmljYWxseSwgRWFzdCBDb2FzdCkuDQoNCiogKipTT0RBX1BSSUNFMTA6KiogVGhpcyB2YXJpYWJsZSBzaG93cyB0aGUgcmF0aW8gb2Ygc29kYSBwcmljZXMgdG8gdGhlIG5hdGlvbmFsIGF2ZXJhZ2UgZm9yIDIwMTAuIEkgY2hvc2UgdGhpcyB2YXJpYWJsZSBiZWNhdXNlIGl0IGlzIGtub3duIHRoYXQgZXhjZXNzaXZlIHN1Z2FyIGNvbnN1bXB0aW9uIGNhbiBsZWFkIHRvIGRpYWJldGVzLiBJIGV4cGVjdCB0aGF0IHRob3NlIHN0YXRlcyB3aXRoIGxvd2VyIHNvZGEgcHJpY2UgcmF0aW9zIHRlbmQgdG8gaGF2ZSBhIGhpZ2hlciBwZXJjZW50YWdlIG9mIGluZGl2aWR1YWxzIHdpdGggZGlhYmV0ZXMuDQoNCiogKipQQ19GRlJTQUxFUzA3OioqIFRoaXMgdmFyaWFibGUgc2hvd3MgdGhlIEZhc3QgRm9vZCBFeHBlbmRpdHVyZXMgcGVyIGNhcGl0YSBpbiBkb2xsYXJzLiBJIGNob3NlIHRoaXMgdmFyaWFibGUgYmVjYXVzZSBpdCBpcyBhbHNvIGtub3duIHRoYXQgZXhjZXNzaXZlIGZhc3QgZm9vZCBjb25zdW1wdGlvbiBjYW4gbGVhZCB0byBkaWFiZXRlcy4gSSBleHBlY3QgdGhhdCB0aG9zZSBzdGF0ZXMgd2l0aCBoaWdoZXIgZmFzdCBmb29kIGV4cGVuZGl0dXJlcyB0ZW5kIHRvIGhhdmUgaGlnaGVyIGRpYWJldGVzIHJhdGVzLiANCg0KVG8gYW5hbHl6ZSBVUyBkaWFiZXRlcyByYXRlcywgZGF0YSB3YXMgbWVyZ2VkIHdpdGggYSBtYXAgb2YgdGhlIFVuaXRlZCBTdGF0ZXMgb24gYSBjb3VudHktbGV2ZWwuIEluIHRoaXMgY2FzZSwgdGhlIHN0YXRlcyBvZiBIYXdhaWkgYW5kIEFsYXNrYSB3ZXJlIGV4Y2x1ZGVkLg0KDQoNCmBgYHtyLG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGVjaG89RkFMU0UsIGluY2x1ZGU9RkFMU0V9DQpoZWFsdGhfZGF0YSA8LSByZWFkX2NzdigiQzovVXNlcnMvUGFwYS9EZXNrdG9wL1NvYyA3MTIgLVIvaGVhbHRoX2Zvb2QuY3N2IikNCmhlYWQoaGVhbHRoX2RhdGEpDQpwcmljZXNfZGF0YSA8LSByZWFkX2NzdigiQzovVXNlcnMvUGFwYS9EZXNrdG9wL1NvYyA3MTIgLVIvcHJpY2VzX3RheGVzX2Zvb2QuY3N2IikNCmhlYWQocHJpY2VzX2RhdGEpDQpyZXN0YXVyYW50c19kYXRhIDwtIHJlYWRfY3N2KCJDOi9Vc2Vycy9QYXBhL0Rlc2t0b3AvU29jIDcxMiAtUi9yZXN0YXVyYW50c19mb29kLmNzdiIpDQpoZWFkKHJlc3RhdXJhbnRzX2RhdGEpDQpgYGANCg0KDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRSwgcmVzdWx0cz0naGlkZSd9DQp1c19tYXAgPC0gdXNfbWFwICU+JSANCiAgbXV0YXRlKEZJUFMgPSBwYXJzZV9pbnRlZ2VyKEdFT0lEKSkNCmhlYWx0aF9kYXRhIDwtIGhlYWx0aF9kYXRhICU+JQ0KICBtdXRhdGUoRklQUyA9IHBhcnNlX2ludGVnZXIoRklQUykpDQpgYGANCg0KYGBge3IsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGVjaG89RkFMU0UsIHJlc3VsdHM9J2hpZGUnfQ0KY29tYl9kYXRhIDwtIHVzX21hcCAlPiUgDQogIGxlZnRfam9pbihoZWFsdGhfZGF0YSwgYnkgPSAiRklQUyIpDQpgYGANCg0KYGBge3IsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGVjaG89RkFMU0UsIHJlc3VsdHM9J2hpZGUnfQ0KcHJpY2VzX2RhdGEgPC0gcHJpY2VzX2RhdGEgJT4lDQogIG11dGF0ZShGSVBTID0gcGFyc2VfaW50ZWdlcihGSVBTKSkNCmNvbWJfZGF0YTIgPC0gY29tYl9kYXRhICU+JSANCiAgbGVmdF9qb2luKHByaWNlc19kYXRhLCBieSA9ICJGSVBTIikNCmBgYA0KDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRSwgcmVzdWx0cz0naGlkZSd9DQpyZXN0YXVyYW50c19kYXRhIDwtIHJlc3RhdXJhbnRzX2RhdGEgJT4lDQogIG11dGF0ZShGSVBTID0gcGFyc2VfaW50ZWdlcihGSVBTKSkNCmNvbWJfZGF0YTMgPC0gY29tYl9kYXRhMiAlPiUgDQogIGxlZnRfam9pbihyZXN0YXVyYW50c19kYXRhLCBieSA9ICJGSVBTIikNCmBgYA0KDQojIyNVUyBEaWFiZXRlcyBSYXRlcw0KYGBge3IsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGVjaG89RkFMU0UsIHJlc3VsdHM9J2hpZGUnLCBpbmNsdWRlPUZBTFNFfQ0KdG1fc2hhcGUoY29tYl9kYXRhMykgKyB0bV9wb2x5Z29ucygiUENUX0RJQUJFVEVTX0FEVUxUUzEwIikNCmBgYA0KDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJywgaW5jbHVkZT1GQUxTRX0NCmNvbWJfZGF0YV9zdWIgPC0gY29tYl9kYXRhMyAlPiUgDQogIGZpbHRlcihTVEFURUZQICE9ICIwMiIpICU+JSANCiAgZmlsdGVyKFNUQVRFRlAgIT0gIjE1IikgJT4lIA0KICBmaWx0ZXIoU1RBVEVGUCAhPSAiNjAiKSAlPiUgDQogIGZpbHRlcihTVEFURUZQICE9ICI2NiIpICU+JSANCiAgZmlsdGVyKFNUQVRFRlAgIT0gIjY5IikgJT4lIA0KICBmaWx0ZXIoU1RBVEVGUCAhPSAiNzIiKSAlPiUgDQogIGZpbHRlcihTVEFURUZQICE9ICI3OSIpDQpgYGANCg0KDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRSwgcmVzdWx0cz0naGlkZScsIGluY2x1ZGU9RkFMU0V9DQp0bV9zaGFwZShjb21iX2RhdGFfc3ViLCBwcm9qZWN0aW9uID0gMjE2MykgKyB0bV9wb2x5Z29ucygiUENUX0RJQUJFVEVTX0FEVUxUUzEwIikNCmBgYA0KDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJ30NClVTX3N0YXRlcyA8LSBjb21iX2RhdGFfc3ViICU+JSANCglhZ2dyZWdhdGVfbWFwKGJ5ID0gIlNUQVRFRlAiKQ0KYGBgDQoNCg0KYGBge3IsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0UsIGVjaG89RkFMU0V9DQojIFVTIG1hcA0KVVNfU3RhdGVzMiA8LSB0bV9zaGFwZShjb21iX2RhdGFfc3ViLCBwcm9qZWN0aW9uPTIxNjMpICsNCgl0bV9wb2x5Z29ucygiUENUX0RJQUJFVEVTX0FEVUxUUzEwIiwgYm9yZGVyLmNvbCA9ICJncmF5NTAiLCBib3JkZXIuYWxwaGEgPSAuNCwgdGl0bGUgPSAiIiwgc2hvd05BID0gVFJVRSkgKw0KCXRtX3NoYXBlKFVTX3N0YXRlcykgKw0KCXRtX2JvcmRlcnMobHdkPTEsIGNvbCA9ICJibGFjayIsIGFscGhhID0gLjUpICsNCgl0bV9jcmVkaXRzKCJEYXRhIEAgVW5pdGVzIFN0YXRlcyBEZXBhcnRtZW50IG9mIEFncmljdWx0dXJlXG5TaGFwZSBAIFVTIENlbnN1cyBCdXJlYXUiLCBwb3NpdGlvbiA9IGMoInJpZ2h0IiwgImJvdHRvbSIpKSArDQoJdG1fbGF5b3V0KHRpdGxlPSIyMDEwIEFkdWx0IERpYWJldGVzIGJ5IENvdW50eSglKSIsIA0KCQkJICB0aXRsZS5wb3NpdGlvbiA9IGMoImNlbnRlciIsICJ0b3AiKSwgDQoJCQkgIGxlZ2VuZC5wb3NpdGlvbiA9IGMoImxlZnQiLCAiYm90dG9tIiksIA0KCQkJICBmcmFtZSA9IEZBTFNFLCANCgkJCSAgaW5uZXIubWFyZ2lucyA9IGMoMC4xLCAwLjEsIDAuMDUsIDAuMDUpKQ0KVVNfU3RhdGVzMg0KYGBgDQoNCkxvb2tpbmcgYXQgdGhlIG1hcCwgd2Ugc2VlIHRoYXQgdGhlIGhpZ2hlc3QgZGlhYmV0ZXMgcmF0ZXMgKDE1IHRvIDIwJSkgY2FuIGJlIGZvdW5kIG1vcmUgaW4gdGhlIE5vcnRoZWFzdCBhbmQgU291dGhlYXN0IHJlZ2lvbnMsIHNwZWNpZmljYWxseSBpbiBNaXNzaXNpcGksIEFsYWJhbWEsIGFuZCBTb3V0aCBDYXJvbGluYS4gSW4gdGhlIE5vcnRoZXJuIHJlZ2lvbiB0aGVyZSBpcyBvbmUgb3V0bGllciB3aXRoIDE1IHRvIDIwJSBkaWFiZXRlcywgd2hpY2ggaXMgaW4gU291dGggRGFrb3RhLiBUaGlzIHNlZW1zIHRvIGNvbmZpcm0gdGhlIGh5cG90aGVzaXMgdGhhdCBhcmVhcyB3aXRoIGxhcmdlciBjaXRpZXMgKHRoZSBOb3J0aGVhc3QpIGFuZCBjb2xkZXIgd2VhdGhlciB0ZW5kIHRvIGhhdmUgaGlnaGVyIGRpYWJldGVzIHJhdGVzLg0KDQojIyNTb2RhIFByaWNlcyB0byBOYXRpb25hbCBBdmVyYWdlIFJhdGlvcw0KDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRSwgcmVzdWx0cz0naGlkZSd9DQp0bV9zaGFwZShjb21iX2RhdGEzKSArIHRtX3BvbHlnb25zKCJTT0RBX1BSSUNFMTAiKQ0KYGBgDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJ30NCnRtX3NoYXBlKGNvbWJfZGF0YV9zdWIsIHByb2plY3Rpb24gPSAyMTYzKSArIHRtX3BvbHlnb25zKCJTT0RBX1BSSUNFMTAiKQ0KYGBgDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFfQ0KIyBVUyBtYXANClVTX1N0YXRlczMgPC0gdG1fc2hhcGUoY29tYl9kYXRhX3N1YiwgcHJvamVjdGlvbj0yMTYzKSArDQoJdG1fcG9seWdvbnMoIlNPREFfUFJJQ0UxMCIsIGJvcmRlci5jb2wgPSAiZ3JheTUwIiwgYm9yZGVyLmFscGhhID0gLjQsIHRpdGxlID0gIiIsIHNob3dOQSA9IFRSVUUpICsNCgl0bV9zaGFwZShVU19zdGF0ZXMpICsNCgl0bV9ib3JkZXJzKGx3ZD0xLCBjb2wgPSAiYmxhY2siLCBhbHBoYSA9IC41KSArDQoJdG1fY3JlZGl0cygiRGF0YSBAIFVuaXRlcyBTdGF0ZXMgRGVwYXJ0bWVudCBvZiBBZ3JpY3VsdHVyZVxuU2hhcGUgQCBVUyBDZW5zdXMgQnVyZWF1IiwgcG9zaXRpb24gPSBjKCJyaWdodCIsICJib3R0b20iKSkgKw0KCXRtX2xheW91dCh0aXRsZT0iMjAxMCBTb2RhIFByaWNlIHRvIE5hdGlvbmFsIEF2ZXJhZ2UgKFJhdGlvKSIsIA0KCQkJICB0aXRsZS5wb3NpdGlvbiA9IGMoImNlbnRlciIsICJ0b3AiKSwgDQoJCQkgIGxlZ2VuZC5wb3NpdGlvbiA9IGMoImxlZnQiLCAiYm90dG9tIiksIA0KCQkJICBmcmFtZSA9IEZBTFNFLCANCgkJCSAgaW5uZXIubWFyZ2lucyA9IGMoMC4xLCAwLjEsIDAuMDUsIDAuMDUpKQ0KVVNfU3RhdGVzMw0KYGBgDQoNCkxvb2tpbmcgYXQgdGhlIHNvZGEgcHJpY2UgcmF0aW9zLCB3ZSBzZWUgdGhhdCB0aGUgaGlnaGVzdCBzb2RhIHByaWNlcyBhcmUgaW4gV2FzaGluZ3RvbiwgT3JlZ29uLCBhbmQgQ2FsaWZvcm5pYS4gQWRkaXRpb25hbGx5LCB0aGUgbG93ZXN0IHNvZGEgcHJpY2VzIGFyZSBhZ2FpbiBpbiB0aGUgTm9ydGhlYXN0IGFuZCBTb3V0aGVhc3QuIFRoaXMgc2VlbXMgdG8gY29uZmlybSB0aGUgaHlwb3RoZXNpcyB0aGF0IHN0YXRlcyB3aXRoIGxvd2VyIGRpYWJldGVzIHJhdGVzIHRlbmQgdG8gaGF2ZSBoaWdoZXIgc29kYSBwcmljZXMgYW5kIHN0YXRlcyB3aXRoIGxvd2VyIHNvZGEgcHJpY2VzIGhhdmUgaGlnaGVyIGRpYWJldGVzIHJhdGVzLg0KDQojIyNGYXN0IEZvb2QgRXhwZW5kaXR1cmVzIHBlciBDYXBpdGENCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJ30NCnRtX3NoYXBlKGNvbWJfZGF0YTMpICsgdG1fcG9seWdvbnMoIlBDX0ZGUlNBTEVTMDciKQ0KYGBgDQoNCmBgYHtyLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFLCBlY2hvPUZBTFNFLCByZXN1bHRzPSdoaWRlJ30NCnRtX3NoYXBlKGNvbWJfZGF0YV9zdWIsIHByb2plY3Rpb24gPSAyMTYzKSArIHRtX3BvbHlnb25zKCJQQ19GRlJTQUxFUzA3IikNCmBgYA0KDQpgYGB7ciwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRSwgZWNobz1GQUxTRX0NCiMgVVMgbWFwDQpVU19TdGF0ZXM0IDwtIHRtX3NoYXBlKGNvbWJfZGF0YV9zdWIsIHByb2plY3Rpb249MjE2MykgKw0KCXRtX3BvbHlnb25zKCJQQ19GRlJTQUxFUzA3IiwgYm9yZGVyLmNvbCA9ICJncmF5NTAiLCBib3JkZXIuYWxwaGEgPSAuNCwgdGl0bGUgPSAiIiwgc2hvd05BID0gVFJVRSkgKw0KCXRtX3NoYXBlKFVTX3N0YXRlcykgKw0KCXRtX2JvcmRlcnMobHdkPTEsIGNvbCA9ICJibGFjayIsIGFscGhhID0gLjUpICsNCgl0bV9jcmVkaXRzKCJEYXRhIEAgVW5pdGVzIFN0YXRlcyBEZXBhcnRtZW50IG9mIEFncmljdWx0dXJlXG5TaGFwZSBAIFVTIENlbnN1cyBCdXJlYXUiLCBwb3NpdGlvbiA9IGMoInJpZ2h0IiwgImJvdHRvbSIpKSArDQoJdG1fbGF5b3V0KHRpdGxlPSIyMDEwIEZhc3QgRm9vZCBFeHBlbmRpdHVyZXMgcGVyIGNhcGl0YSAoJCkiLCANCgkJCSAgdGl0bGUucG9zaXRpb24gPSBjKCJsZWZ0IiwgInRvcCIpLCANCgkJCSAgbGVnZW5kLnBvc2l0aW9uID0gYygibGVmdCIsICJib3R0b20iKSwgDQoJCQkgIGZyYW1lID0gRkFMU0UsIA0KCQkJICBpbm5lci5tYXJnaW5zID0gYygwLjEsIDAuMSwgMC4wNSwgMC4wNSkpDQpVU19TdGF0ZXM0DQpgYGANCg0KV2hlbiBsb29raW5nIGF0IGZhc3QgZm9vZCBleHBlbmRpdHVyZXMgcGVyIGNhcGl0YSBpbiBkb2xsYXJzIHdlIHNlZSB0aGF0IHRoZSBzdGF0ZSB3aXRoIHRoZSBoaWdoZXN0IGZhc3QgZm9vZCBleHBlbmRpdHVyZSBpcyBOZXZhZGEgKHdpdGggMTAwMCBhbmQgMTEwMCBkb2xsYXJzKS4gVGhpcyBpcyBmb2xsb3dlZCBieSBDYWxpZm9ybmlhLCBPcmVnb24sIEFyaXpvbmEsIENvbG9yYWRvLCBhbmQgTmV3IE1leGljby4gSW50ZXJlc3RpbmdseSwgTmV2YWRhIGNvbmZpcm1zIHRoZSBoeXBvdGhpcyB0aGF0IHRoZSBzdGF0ZSB3aXRoIHRoZSBoaWdoZXN0IGZhc3QgZm9vZCBleHBlbmRpdHVyZXMgcGVyIGNhcGl0YSwgdGVuZHMgdG8gdG8gaGF2ZSBvbmUgb2YgdGhlIGhpZ2hlc3QgZGlhYmV0ZXMgcmF0ZXMuIA0KDQojIyNDb25jbHVzaW9uDQpJbiBjb25jbHVzaW9uLCB3ZSBzZWUgdGhhdCBkaWFiZXRlcyByYXRlcyBhcmUgdGhlIGhpZ2hlc3QgaW4gdGhlIE5vcnRoIGFuZCBTb3V0aGVhc3QgcmVnaW9ucyBhbmQgdGhhdCBzb2RhIHByaWNlcyBkbyBhZmZlY3QgZGlhYmV0ZXMgcmF0ZXMgc28gdGhhdCBzdGF0ZXMgd2l0aCBoaWdoZXIgc29kYSBwcmljZXMgdGVuZCB0byBoYXZlIGxvd2VyIGRpYWJldGVzIHJhdGVzLiBGaW5hbGx5LCB3ZSBjYW4gc2VlIHRoYXQgaW4gdGhlIGNhc2Ugb2YgTmV2YWRhIHRoYXQgZmFzdCBmb29kIGV4cGVuZGl0dXJlcyBwZXIgY2FwaXRhIGFmZmVjdCBkaWFiZXRlcyByYXRlcyBzb21ld2hhdCBieSBzdGF0aW5nIHRoYXQgaGlnaGVyIGV4cGVuZGl0dXJlcyBtZWFucyBoaWdoZXIgZGlhYmV0ZXMgcmF0ZXMuIFRoaXMgY29uY2x1c2lvbiBjYW4gaGVscCBvcmdhbml6YXRpb25zICBleHBsYWluIGRpYWJldGVzIGluIFVuaXRlZCBTdGF0ZXMgYW5kIGZhY3RvcnMgdGhhdCBhZmZlY3QgdGhvc2UgcmF0ZXMuDQoNCg0KIyMjQmlibGlvZ3JhcGh5DQoNCg0KDQoNCg0KDQo=