Chicago Jail, Demographic, and Covid-19 Data (doi:10.7910/DVN/NNBEGK)

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

Chicago Jail, Demographic, and Covid-19 Data

doi:10.7910/DVN/NNBEGK

Harvard Dataverse

2021-04-15

1

DEJURE, WBG, 2021, "Chicago Jail, Demographic, and Covid-19 Data", https://doi.org/10.7910/DVN/NNBEGK, Harvard Dataverse, V1, UNF:6:zt4uWeYS682gsOOVuuSvEQ== [fileUNF]

Chicago Jail, Demographic, and Covid-19 Data

doi:10.7910/DVN/NNBEGK

DEJURE, WBG (World Bank Group)

Harvard Dataverse

DEJURE, WBG

DEJURE, WBG

2021-04-12

Law, Medicine, Health and Life Sciences, Social Sciences

Contains raw data, processed data, code, results and model outputs related to the paper, published in PNAS

Simply execute the R code "Data preparation.R" after downloading all the files to a single folder. The output file from R code shall be used upon next executing the code in STATA .do file "Models_tables_and_graphs.do". This will generate the output files

CC0 Waiver

• Number of cases: 1380

• No. of variables per record: 21

• Type of File: text/tab-separated-values

UNF:6:I1ATS+7l5kZ07TwEr9RHXw==

• Number of cases: 9117

• No. of variables per record: 5

• Type of File: text/tab-separated-values

UNF:6:QYZ9uKASBCJAiDLbfQw1zQ==

• ZIP Code - ZIP Code
• Week Number - Week Number
• Week Start - Week Start
• Week End - Week End
• Cases - Weekly - Cases - Weekly
• Cases - Cumulative - Cases - Cumulative
• Case Rate - Weekly - Case Rate - Weekly
• Case Rate - Cumulative - Case Rate - Cumulative
• Tests - Weekly - Tests - Weekly
• Tests - Cumulative - Tests - Cumulative
• Test Rate - Weekly - Test Rate - Weekly
• Test Rate - Cumulative - Test Rate - Cumulative
• Percent Tested Positive - Weekly - Percent Tested Positive - Weekly
• Percent Tested Positive - Cumulative - Percent Tested Positive - Cumulative
• Deaths - Weekly - Deaths - Weekly
• Deaths - Cumulative - Deaths - Cumulative
• Death Rate - Weekly - Death Rate - Weekly
• Death Rate - Cumulative - Death Rate - Cumulative
• Population - Population
• Row ID - Row ID
• ZIP Code Location - ZIP Code Location
• BookingID - BookingID
• releaseFromCustodyDate - releaseFromCustodyDate
• Race - Race
• Gender - Gender
• Zip - Zip

f4549876 Location:

Variable Format: character

Notes: UNF:6:0Qezao/Wyljlc0kqWDE69A==

f4549876 Location:

Summary Statistics: Mean 21.0; Max. 32.0; Min. 10.0; Valid 1380.0; StDev 6.635654238966592

Variable Format: numeric

Notes: UNF:6:QVBOWOezLBe9tzPJV0pLrA==

f4549876 Location:

Variable Format: character

Notes: UNF:6:87PHtAqvWIXP9+8B5drM6A==

f4549876 Location:

Variable Format: character

Notes: UNF:6:rVlAHQEfsVBFQ/ejjJwMhQ==

f4549876 Location:

Summary Statistics: Min. 0.0; Max. 684.0; StDev 73.69200409375553; Mean 52.61179361179368; Valid 1221.0

Variable Format: numeric

Notes: UNF:6:M2TLBuXK93oM1vWTj7YCPg==

f4549876 Location:

Summary Statistics: Valid 1221.0; Mean 662.1850941850947; Min. 5.0; StDev 774.8254812329027; Max. 4194.0

Variable Format: numeric

Notes: UNF:6:g9lD+PGLRKpqEE43Ztsq6w==

f4549876 Location:

Summary Statistics: Min. 0.0; Valid 1221.0; StDev 95.5028772391799; Mean 96.85257985257991; Max. 796.0

Variable Format: numeric

Notes: UNF:6:qosqUxylEW7MQiQQITm6bQ==

f4549876 Location:

Summary Statistics: Valid 1221.0; Mean 1224.323669123669; Min. 0.0; StDev 953.2855824944446; Max. 4541.8

Variable Format: numeric

Notes: UNF:6:tbXlvu8AS7qzda0kHUyWPw==

f4549876 Location:

Summary Statistics: Mean 367.077536231884; StDev 344.42187554873277; Valid 1380.0; Max. 2053.0; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:Y/1kiMzD1a6Iue9Fj57OzA==

f4549876 Location:

Summary Statistics: Max. 29351.0; Valid 1380.0; Min. 0.0; Mean 3279.4311594202914; StDev 3924.5234255652103

Variable Format: numeric

Notes: UNF:6:OqBxDaR80/iTfBrm1G1Wqg==

f4549876 Location:

Summary Statistics: StDev 529.4466265993598; Valid 1380.0; Mean 748.3413043478272; Min. 0.0; Max. 3580.0

Variable Format: numeric

Notes: UNF:6:uloSckdpk59vrTU8dcUaRg==

f4549876 Location:

Summary Statistics: Mean 6573.2189855072465; StDev 6242.234371324333; Max. 44243.8; Valid 1380.0; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:QFIVBkhp2ZTHSm8s+wEayA==

f4549876 Location:

Summary Statistics: Mean 0.14438984438984426; Min. 0.0; Max. 0.7; Valid 1221.0; StDev 0.13254776569924193

Variable Format: numeric

Notes: UNF:6:myO3iyJN/eDgkvWonKlvlQ==

f4549876 Location:

Summary Statistics: Max. 0.5; Valid 1221.0; Mean 0.20794430794430793; Min. 0.0; StDev 0.10555450853896231

Variable Format: numeric

Notes: UNF:6:oMIWYY4cZRPPWaJn5B8ZMA==

f4549876 Location:

Summary Statistics: Valid 1380.0; Max. 25.0; Min. 0.0; Mean 2.0420289855072484; StDev 3.3887116192747873

Variable Format: numeric

Notes: UNF:6:ircjzp572+4PIPDIaK+wXQ==

f4549876 Location:

Summary Statistics: Min. 0.0; Valid 1380.0; Mean 27.25724637681164; StDev 32.81470245592134; Max. 154.0;

Variable Format: numeric

Notes: UNF:6:fCrW/99sSY1/XxDNi/TbsQ==

f4549876 Location:

Summary Statistics: Max. 54.3; Min. 0.0; StDev 6.09588888767976; Mean 3.7142753623188374; Valid 1380.0

Variable Format: numeric

Notes: UNF:6:oCPiuszC645FsEENw+Y0rg==

f4549876 Location:

Summary Statistics: Mean 49.65644927536233; StDev 55.4470022625165; Valid 1380.0; Max. 267.3; Min. 0.0;

Variable Format: numeric

Notes: UNF:6:MwwoloS9PjfJbfn351qOCg==

f4549876 Location:

Summary Statistics: StDev 26859.832365244954; Min. 0.0; Mean 46230.21666666669; Valid 1380.0; Max. 111850.0;

Variable Format: numeric

Notes: UNF:6:3IMLvMSaPWYhgRq89nxSrw==

f4549876 Location:

Variable Format: character

Notes: UNF:6:nOjGI1Fyoakpw5ZWikr/lw==

f4549876 Location:

Variable Format: character

Notes: UNF:6:41zaPIeL/sSa43uxJsenqQ==

f4549881 Location:

Summary Statistics: Min. 1.9979795898E10; StDev 6618288.846453228; Max. 2.0200625091E10; Mean 2.0197188636538883E10; Valid 9117.0;

Variable Format: numeric

Notes: UNF:6:BzDRvK+Ez7SSewhNHvIpig==

f4549881 Location:

Variable Format: character

Notes: UNF:6:prx5N+vQdqoPG3yPByH1BA==

f4549881 Location:

Variable Format: character

Notes: UNF:6:rwBtBfeN+BMlDsEj9gvYfw==

f4549881 Location:

Variable Format: character

Notes: UNF:6:EtGfDJDbvp6ZSotJ/jyT1A==

f4549881 Location:

Variable Format: character

Notes: UNF:6:ECWBxVOPn2xs2ANMZoLoUQ==

Label:

ACS_2018_pct_variables_socialexplorer_aug_28.csv

Text:

Raw data

text/csv

Label:

Chicago merged dataset.csv

Text:

Processed data

text/csv

Label:

cumulativeestimates.csv

text/csv

Label:

Data preparation.R

Text:

Code 1

type/x-r-syntax

Label:

elastic_mlr.csv

Text:

Result

text/csv

Label:

estimates_cumulative_adjacent.csv

Text:

Result

text/csv

Label:

estimates_cumulative_testing.csv

Text:

Result

text/csv

Label:

filename_codebook.txt

Text:

Result

text/plain

Label:

Models_tables_and_graphs.do

Text:

Code 2

application/x-stata-syntax

Label:

pca_lasso.xlsx

Text:

Result

application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Label:

pca_mlr.csv

Text:

Result

text/csv

Label:

rcumulative_zip.eps

Text:

Result

application/postscript

Label:

rcumulative_zip.png

Text:

Result

image/png

Label:

rrolling_zip.eps

Text:

Result

application/postscript

Label:

rrolling_zip.png

Text:

Result

image/png

Label:

rsummtabweek.csv

Text:

Result

text/csv

Label:

weeklyestimates.csv

Text:

Result

text/csv

Label:

Zip_Codes.zip

Text:

Geometry data files for Chicago

application/zipped-shapefile