Replication Data for: A Hard Pill to Swallow: Social Capital, Opioids, and Health Outcomes in the United States (doi:10.7910/DVN/T4ZEMD)

View:

Part 1: Document Description
Part 2: Study Description
Part 3: Data Files Description
Part 4: Variable Description
Part 5: Other Study-Related Materials
Entire Codebook

Document Description
Citation
Title:	Replication Data for: A Hard Pill to Swallow: Social Capital, Opioids, and Health Outcomes in the United States
Identification Number:	doi:10.7910/DVN/T4ZEMD
Distributor:	Harvard Dataverse
Date of Distribution:	2024-12-10
Version:	1
Bibliographic Citation:	Hawes, Daniel, 2024, "Replication Data for: A Hard Pill to Swallow: Social Capital, Opioids, and Health Outcomes in the United States", https://doi.org/10.7910/DVN/T4ZEMD, Harvard Dataverse, V1, UNF:6:g04mts1dvYfbk29JZD0PbQ== [fileUNF]
Study Description
Citation
Title:	Replication Data for: A Hard Pill to Swallow: Social Capital, Opioids, and Health Outcomes in the United States
Identification Number:	doi:10.7910/DVN/T4ZEMD
Authoring Entity:	Hawes, Daniel (Kent State University)
Distributor:	Harvard Dataverse
Access Authority:	Hawes, Daniel
Depositor:	Hawes, Daniel
Date of Deposit:	2024-12-02
Holdings Information:	https://doi.org/10.7910/DVN/T4ZEMD
Study Scope
Keywords:	Social Sciences, Social Capital, Public Health, Opioid Crisis
Abstract:	Replication Files for "A Hard Pill to Swallow: Social Capital, Opiates, and Health Outcomes in the United States"
Methodology and Processing
Sources Statement
Data Access
Other Study Description Materials
File Description--f10740795
File: JPP_HardPill_Replication.tab
	Number of cases: 3230 No. of variables per record: 41 Type of File: text/tab-separated-values
Notes:	UNF:6:g04mts1dvYfbk29JZD0PbQ==
Variable Description
List of Variables:	FIPS_County - FIPS Code Alt_fips - Alt FIPS Code county_state - County, State Abbreviation statename - State stateabrv - State Abbreviation county - County Penn_SC - Penn State index unemploy_rt - Unemployment rate mlf_partic - Prime-age male labor force participation mhh_income - Median household income pov_rt - Poverty rate pct_debtcoll - % with debt in collection pct_graduatedcoll - % adults graduated high school mortality_rt_despair - Mortality rate from 'deaths of despair' mlf_segreg - Black-white segregation pct_foreign_born - % foreign born den_rt - Density mhh_time - Mean commute time net_migration - Net migration avgcrudert - Drug-Death Rate 2015-17 avgprescribrate - Opioid Prescription Rate 2015-17 relig_cong - Religious congregations p 1,000 SC_Index - County-Level Index talkneighbor - Talks to neighbors >1/week, CPS Data favors - Does favors >1/week, CPS Data fixprob - Fixes or improves somethign, CPS Data donate - Donated or charity, CPS Data education_and_trai_c - Gov transfers, Education & Training, 000s $ (BEA 2018) gdpqiFinance_an_e - Finance & Insurance, Quantity index, GDP (BEA 2018) gdpqiManagement_e - Management, Quantity index, GDP (BEA 2018) gdpqiManufactur_g - Manufacturing, Quantity index, GDP (BEA 2018) mj_law - Marijuana Law Index govideol - Government Ideology demleg - Percent Democrats in Legislature cnty_diversity - Racial Diversity SMAT_pc - Facilities Providing Some Medication Assisted Treatment per 10,000 Med_SA_pc - Substance Abuse Services Facilities Accepting Medicaid per 10,000 FQHC_pc - Federally Qualified Health Centers per 10000 Bup_Phys_pc HC_Resources - Healthcare Resources Index pct_need - Percent Needing but not Recieving Treatment
Variables
FIPS Code
f10740795 Location:	Variable Format: character Notes: UNF:6:AowF/VJSLJ4QFjm/QL+/Cg==
Alt FIPS Code
f10740795 Location:	Summary Statistics: Max. 72153.0; Min. 1001.0; Valid 3230.0; StDev 16291.469210929321; Mean 31412.788544891617 Variable Format: numeric Notes: UNF:6:SQcDtmofwZZq6f3Huts8Cg==
County, State Abbreviation
f10740795 Location:	Variable Format: character Notes: UNF:6:swYFn20lXZxAzPbdpJnepQ==
State
f10740795 Location:	Variable Format: character Notes: UNF:6:kx0Wi8mz5U1zFydPnnTHqA==
State Abbreviation
f10740795 Location:	Variable Format: character Notes: UNF:6:2P9GeVzlNTXn+4xWhxaFDQ==
County
f10740795 Location:	Variable Format: character Notes: UNF:6:sNS75HCke7ecTUPC//1dLA==
Penn State index
f10740795 Location:	Summary Statistics: Mean 0.0013663991440320984; StDev 1.2600698115253883; Max. 21.8088324623424; Valid 3139.0; Min. -3.18328117686795 Variable Format: numeric Notes: UNF:6:X31SHg/i2arMGO9ZCUokeg==
Unemployment rate
f10740795 Location:	Summary Statistics: Mean 4.029089751750477; Max. 18.8; Min. 0.0; StDev 1.6933829303224428; Valid 3142.0; Variable Format: numeric Notes: UNF:6:SYz8/B74FNmNc1bOY1TT4A==
Prime-age male labor force participation
f10740795 Location:	Summary Statistics: Valid 3142.0; StDev 6.6644813426332625; Min. 45.80549368968077; Max. 100.0; Mean 86.75401487920557; Variable Format: numeric Notes: UNF:6:utUBQtEKoIuiupyBs7LHsg==
Median household income
f10740795 Location:	Summary Statistics: Mean 47975.23917197462; Min. 18972.0; Valid 3140.0; Max. 125672.0; StDev 12598.794634257034 Variable Format: numeric Notes: UNF:6:YIVrRj/cFR/E1iFlrLFAPg==
Poverty rate
f10740795 Location:	Summary Statistics: Mean 16.406779121578612; StDev 6.5535500319475055; Max. 53.9; Valid 3142.0; Min. 1.8 Variable Format: numeric Notes: UNF:6:FkwmVztGPUoHc8pKvzg9Bw==
% with debt in collection
f10740795 Location:	Summary Statistics: Valid 2961.0; Mean 0.3399459642012834; Min. 0.06; Max. 0.68; StDev 0.11537891651616161 Variable Format: numeric Notes: UNF:6:QRRISdvOatuxch2WzdEjPg==
% adults graduated high school
f10740795 Location:	Summary Statistics: Min. 48.5; StDev 6.542048217218496; Mean 85.8115849777212; Max. 98.7; Valid 3142.0 Variable Format: numeric Notes: UNF:6:kNBMcR35lCJeMR08ZhwFUg==
Mortality rate from 'deaths of despair'
f10740795 Location:	Summary Statistics: Valid 1341.0; StDev 22.998993174609954; Mean 59.16524981357194; Min. 17.9; Max. 269.6 Variable Format: numeric Notes: UNF:6:TJbftmLIKLsL56usyAyHug==
Black-white segregation
f10740795 Location:	Summary Statistics: Max. 0.8453413; Mean 0.3699052126352642; Valid 3142.0; StDev 0.1235963615528674; Min. 0.0 Variable Format: numeric Notes: UNF:6:3Coe3Yv4k/ue31yk8MJG7w==
% foreign born
f10740795 Location:	Summary Statistics: Valid 3142.0; Max. 52.2; Min. 0.0; Mean 4.64805856142585; StDev 5.6841458372518705 Variable Format: numeric Notes: UNF:6:J03uhytRnezNh4EXl7yGyA==
Density
f10740795 Location:	Summary Statistics: Min. 0.0384867054892145; Max. 71615.8125273763; Valid 3142.0; StDev 1787.6129183399705; Mean 267.6466688572666; Variable Format: numeric Notes: UNF:6:XaVIbTirgIVymWV1wfRyUA==
Mean commute time
f10740795 Location:	Summary Statistics: Mean 7.621610439210692; Min. 0.0; Max. 33.9; Valid 3142.0; StDev 4.69602454191897 Variable Format: numeric Notes: UNF:6:Db1sb6O2tshJnXoBeBGqWw==
Net migration
f10740795 Location:	Summary Statistics: Valid 3141.0; Max. 0.22558424618916495; StDev 0.013849164969305178; Mean -0.006112994523432095; Min. -0.10282665363310524 Variable Format: numeric Notes: UNF:6:myglJHfd4h7OfJJfsOnlaA==
Drug-Death Rate 2015-17
f10740795 Location:	Summary Statistics: Min. 14.433333396911621; StDev 82.62971096305078; Mean 187.70619832172946; Max. 596.2999877929688; Valid 2455.0; Variable Format: numeric Notes: UNF:6:WVxxuUBgEpl4TXobNwh2Vg==
Opioid Prescription Rate 2015-17
f10740795 Location:	Summary Statistics: Mean 74.43800786345122; Max. 457.1000061035156; Min. 0.0; StDev 41.23335282185673; Valid 2970.0; Variable Format: numeric Notes: UNF:6:zEbVMyo9FxqOhnqpoqGGXg==
Religious congregations p 1,000
f10740795 Location:	Summary Statistics: Mean 2.4159770846594526; Max. 14.0; Valid 3142.0; Min. 0.4; StDev 1.4049938167378722 Variable Format: numeric Notes: UNF:6:dRMHVtScKeHrYLEiNeZLeA==
County-Level Index
f10740795 Location:	Summary Statistics: Mean 0.004154289872994755; StDev 1.0037776081134313; Max. 2.971351; Min. -4.315278; Valid 2992.0; Variable Format: numeric Notes: UNF:6:iKqwSmgRg71IP0OR9SHmxg==
Talks to neighbors >1/week, CPS Data
f10740795 Location:	Summary Statistics: Valid 3142.0; Mean 0.39373663742211423; Max. 0.48872068524360657; StDev 0.04916430559267538; Min. 0.2854340672492981 Variable Format: numeric Notes: UNF:6:KbC21Q51gJ7u+eK7UzFZpw==
Does favors >1/week, CPS Data
f10740795 Location:	Summary Statistics: Valid 3142.0; StDev 0.028816589581949027; Min. 0.05193113535642624; Mean 0.11334806684710509; Max. 0.1773325353860855 Variable Format: numeric Notes: UNF:6:kPHbZ18M1Su/FOAlc/Dmrg==
Fixes or improves somethign, CPS Data
f10740795 Location:	Summary Statistics: Min. 0.0032160801347345114; StDev 0.013872693451550122; Max. 0.0781172439455986; Mean 0.04702308417212234; Valid 3142.0 Variable Format: numeric Notes: UNF:6:jb/L35bTBh8P+EKDn1wRQw==
Donated or charity, CPS Data
f10740795 Location:	Summary Statistics: Min. 0.2724652588367462; Max. 0.43221959471702576; Valid 3142.0; StDev 0.03470729014154046; Mean 0.35779349838829905 Variable Format: numeric Notes: UNF:6:1axp41lctbLnOBKVFyCShw==
Gov transfers, Education & Training, 000s $ (BEA 2018)
f10740795 Location:	Summary Statistics: Mean 1621435.821133035; Min. 62508.0; Max. 9152026.0; Valid 3142.0; StDev 1531486.308137577 Variable Format: numeric Notes: UNF:6:HiFKD+UBLG6MmysHwdg3zg==
Finance & Insurance, Quantity index, GDP (BEA 2018)
f10740795 Location:	Summary Statistics: StDev 17.84819269508251; Max. 165.817; Valid 3142.0; Mean 112.50965276893697; Min. 72.49 Variable Format: numeric Notes: UNF:6:neYu+xlSbuUi9frNf4Pq8g==
Management, Quantity index, GDP (BEA 2018)
f10740795 Location:	Summary Statistics: Min. 76.965; Max. 324.319; StDev 33.954334219639755; Valid 3142.0; Mean 152.0997998090388; Variable Format: numeric Notes: UNF:6:zBl1qwMK1IkbeXdORZFvzw==
Manufacturing, Quantity index, GDP (BEA 2018)
f10740795 Location:	Summary Statistics: Mean 114.31272978994271; Valid 3142.0; Min. 78.734; Max. 208.037; StDev 18.644853251629108 Variable Format: numeric Notes: UNF:6:6x4BSNPgWzhSsUagbTOAiw==
Marijuana Law Index
f10740795 Location:	Summary Statistics: StDev 0.4359386696314364; Mean 0.25501432664756324; Min. 0.0; Max. 1.0; Valid 3141.0 Variable Format: numeric Notes: UNF:6:tSh3Iv2/LgSc3t/P3RXPlg==
Government Ideology
f10740795 Location:	Summary Statistics: Min. 7.909859; Max. 90.79214; StDev 22.710662543933676; Valid 3141.0; Mean 44.64895852785734 Variable Format: numeric Notes: UNF:6:/pFRz1uqaq0C2bBZDDF9lw==
Percent Democrats in Legislature
f10740795 Location:	Summary Statistics: Max. 90.47619047619048; Mean 51.48764174991545; StDev 12.514266713394212; Min. 15.23809523809524; Valid 3048.0; Variable Format: numeric Notes: UNF:6:wdboQZoY9FE7GGYU/BWlqQ==
Racial Diversity
f10740795 Location:	Summary Statistics: Mean 0.3039451120400541; Max. 0.8322939872741699; Valid 3142.0; Min. 0.0; StDev 0.18467911894156486 Variable Format: numeric Notes: UNF:6:+LhaPw60LgdJVD5k9tOy4g==
Facilities Providing Some Medication Assisted Treatment per 10,000
f10740795 Location:	Summary Statistics: StDev 0.44349376349501135; Min. 0.021940939128398895; Mean 0.3518037608779791; Valid 1183.0; Max. 5.474452495574951 Variable Format: numeric Notes: UNF:6:Az2CHYdk1jrF0yEnc6d4pQ==
Substance Abuse Services Facilities Accepting Medicaid per 10,000
f10740795 Location:	Summary Statistics: StDev 0.6729368668047718; Max. 10.45478343963623; Valid 1970.0; Mean 0.601608635926723; Min. 0.019273430109024048; Variable Format: numeric Notes: UNF:6:khYsj9bhNev/vuZwY3janA==
Federally Qualified Health Centers per 10000
f10740795 Location:	Summary Statistics: Valid 2029.0; Max. 57.14285659790039; Mean 1.271820785053631; StDev 2.747744063026666; Min. 0.01540413498878479 Variable Format: numeric Notes: UNF:6:ZBiabGH9UlkZrg77MqEcfQ==
Bup_Phys_pc
f10740795 Location:	Summary Statistics: Min. 0.09869330376386642; Valid 2001.0; StDev 2.3202225053045296; Max. 34.41802215576172; Mean 2.3881568406028566; Variable Format: numeric Notes: UNF:6:L4NvgoBYEI4V+vPdqTXZcA==
Healthcare Resources Index
f10740795 Location:	Summary Statistics: StDev 1.0000000036999475; Mean 2.2400638148395994E-12; Valid 890.0; Min. -1.1178085803985596; Max. 8.816064834594727 Variable Format: numeric Notes: UNF:6:29KRtdcV9ZdgVX6zLneLoQ==
Percent Needing but not Recieving Treatment
f10740795 Location:	Summary Statistics: Min. 77.02000427246094; Valid 3137.0; Max. 100.0; Mean 88.7034616905069; StDev 3.2254763272921116; Variable Format: numeric Notes: UNF:6:BfhtHOtOOJSwKmkAtB0IxQ==
Other Study-Related Materials
Label:	JPP_HardPill_Replication.do
Notes:	application/x-stata-syntax