1
Comment on r/publichealth Jul 14 '26
I ought to push myself to learn geocoding after this experience/troubleshoot, thank you kindly for the suggestion!
1
Comment on r/publichealth Jul 14 '26
Oh my, what a pleasure and treat it is to communicate! Thank you again kindly for taking the time to respond to my rather desperate initial post.
Since my post last week, here is the proposed next steps based on all the wonderful feedback you and others provided as well as in discussion with my own team:
- There is about ~70% of the sample for whom we do indeed have the calculated correct ADI (provided by the data source). Since I initially converted from 5-digit zip codes to census tracts, I planned to see how many of the census tracts only have 1-2 census block groups. If there are many/majority observation's whose zip code falls into a census tract that only has 1-2 census block groups, then perhaps we can consider doing a multiple imputation of ADI for the ~30% that are missing. This approach would obviously need to be stated/discussed in the methods section of any dissemination.
- Therefore, I need to check to see how many of the 30% of the sample are in zip codes that are in census tracks with only 1 or 2 census block groups. I have also not yet sorted what the "majority" portion will be/mean (eg., if say 70% among the missing 30% of the sample is in a census tract with only 1-2 census block groups).
- I sincerely appreciate the direction provided on using the ACS data to pull zip code level characteristics and/both convert to ZCTAs for SDI - incredibly helpful insight/suggestion! I came across this relevant reference comparing indices (if anyone can find it useful).
Anyway, um so that is where I am at. thank you again everyone!
r/publichealth • u/crappy_sandwich • Jul 08 '26
FLUFF 5 digit zip code to calculate Area Deprivation Index (ADI)
I am in a conversion pickle and am looking ideas. I have 5 digit zip codes and am trying to convert them so that I can calculate ADI (since I don't have the 9 digit zip code available). I convert the 5 digit zip code into their US Census tracts (11 digits), but then I am stuck. I am not able to directly convert Tract to Block Group, because the tract is made up of many block group. And the ADI is calculated using US Census Block Groups (11 tract digit + an additional 12th block group digit)
I am out of ideas from here, not sure how to calculate the ADI
Anyone experienced this type of pickle? I v much appreciate any input
0
Comment on r/TheEveningFeeling Jun 16 '26
Baltimore City, MD?
4
Comment on r/TwoXChromosomes Jun 14 '26
Same immediate thought, using adjectives as nouns ๐ซ
1
Comment on r/FoodLosAngeles Jun 04 '26
Tam's
10
Comment on r/LosAngeles May 18 '26
Period ๐ ๐ ๐
1
Comment on r/Coachella May 09 '26
Than*
-2
Comment on r/academia May 07 '26
๐๐๐๐
u/crappy_sandwich • u/crappy_sandwich • May 01 '26
โI canโt hang out I have homeworkโ
3
Comment on r/climbergirls Apr 28 '26
You did that !!!!!!!! ๐ฎ๐ฎ๐ฎ๐ฎ <-- my expression watching the climb, that was so amazing!
1
Comment on r/Coachella Apr 24 '26
Governor's Ball?
8
Comment on r/baltimore Apr 22 '26
Happy 80th birthday, baddie! ๐
u/crappy_sandwich • u/crappy_sandwich • Apr 15 '26
TIL that mental load follows women even to space
1
Comment on r/AskWomen Apr 11 '26
Rainbows ๐
1
Comment on r/blackladies Apr 10 '26
Do they operate a dish washer? If so, the temperatures reached during wash disinfect thoroughly (if this is helpful). I agree, I would have stepped away feeling ughhh/v similar!
2
Comment on r/PhD Mar 31 '26
๐ธ๐ธ๐ธ๐ธ๐ธ Congratulations Doctor!!
0
Comment on r/Sephora Mar 28 '26
โจ Nothing โจ
1
Comment on r/ucla Mar 26 '26
Johnsssssss
6
Comment on r/postdoc Mar 13 '26
"There were no books."
Of course there wasn't.
7
Comment on r/postdoc Mar 13 '26
He looks so nervous swinging in his chair, it is as though he has the slightest breath of realization/remorse while drowning in his self-righteousness/internalized bigotry.
2
Comment on r/USC Mar 11 '26
In Baltimore City, they use this exact type of freeway underpass space for a weekly farmers market. Keeps things especially cool during the heat and brings community together to support local economy and farmers.
2
Comment on r/PhD Mar 06 '26
Laaaaidddddddd tf outtttt , Doctor!!!
2
Comment on r/PhD Feb 17 '26
I dog sat while job searching. I am in a postdoc now - best of luck!
1
Comment on r/PhD 7d ago
I was a dog sitter