⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

32,027 rows where province_or_state = "Indiana" sorted by day descending

View and edit SQL

province_or_state

  • Indiana · 32,027

country_or_region

  • US 32,027
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
802342 2021-03-01 US Indiana Adams 18001 3235 49 0 3186 40.7457653 -84.93671406 2021-03-02 05:23:30 Adams, Indiana, US
802343 2021-03-01 US Indiana Allen 18003 35861 636 0 35225 41.09194313 -85.06800636 2021-03-02 05:23:30 Allen, Indiana, US
802344 2021-03-01 US Indiana Bartholomew 18005 7456 147 0 7309 39.20744865 -85.89558181 2021-03-02 05:23:30 Bartholomew, Indiana, US
802345 2021-03-01 US Indiana Benton 18007 920 13 0 907 40.60626947 -87.31093999 2021-03-02 05:23:30 Benton, Indiana, US
802346 2021-03-01 US Indiana Blackford 18009 1206 27 0 1179 40.47388153 -85.32499702 2021-03-02 05:23:30 Blackford, Indiana, US
802347 2021-03-01 US Indiana Boone 18011 6090 88 0 6002 40.0509304 -86.46841646 2021-03-02 05:23:30 Boone, Indiana, US
802348 2021-03-01 US Indiana Brown 18013 950 39 0 911 39.19605589 -86.22868909 2021-03-02 05:23:30 Brown, Indiana, US
802349 2021-03-01 US Indiana Carroll 18015 1765 18 0 1747 40.580783200000006 -86.56198812 2021-03-02 05:23:30 Carroll, Indiana, US
802350 2021-03-01 US Indiana Cass 18017 5444 99 0 5345 40.76135835 -86.34830753 2021-03-02 05:23:30 Cass, Indiana, US
802351 2021-03-01 US Indiana Clark 18019 11965 181 0 11784 38.48015445 -85.70510334 2021-03-02 05:23:30 Clark, Indiana, US
802352 2021-03-01 US Indiana Clay 18021 2414 44 0 2370 39.39561833 -87.11723506 2021-03-02 05:23:30 Clay, Indiana, US
802353 2021-03-01 US Indiana Clinton 18023 3958 53 0 3905 40.30319754 -86.47277257 2021-03-02 05:23:30 Clinton, Indiana, US
802354 2021-03-01 US Indiana Crawford 18025 907 13 0 894 38.28814402 -86.44518825 2021-03-02 05:23:30 Crawford, Indiana, US
802355 2021-03-01 US Indiana Daviess 18027 2853 96 0 2757 38.70186039 -87.07185406 2021-03-02 05:23:30 Daviess, Indiana, US
802356 2021-03-01 US Indiana DeKalb 18033 3852 78 0 3774 41.39804622 -84.99906934 2021-03-02 05:23:30 DeKalb, Indiana, US
802357 2021-03-01 US Indiana Dearborn 18029 5474 67 0 5407 39.14647946 -84.97333539 2021-03-02 05:23:30 Dearborn, Indiana, US
802358 2021-03-01 US Indiana Decatur 18031 2708 88 0 2620 39.30712658 -85.50087166 2021-03-02 05:23:30 Decatur, Indiana, US
802359 2021-03-01 US Indiana Delaware 18035 9838 179 0 9659 40.22787247 -85.39732772 2021-03-02 05:23:30 Delaware, Indiana, US
802360 2021-03-01 US Indiana Dubois 18037 5910 111 0 5799 38.36597551 -86.87924170000002 2021-03-02 05:23:30 Dubois, Indiana, US
802361 2021-03-01 US Indiana Elkhart 18039 25386 415 0 24971 41.59761169 -85.85875695 2021-03-02 05:23:30 Elkhart, Indiana, US
802362 2021-03-01 US Indiana Fayette 18041 2719 56 0 2663 39.63684962 -85.17797541 2021-03-02 05:23:30 Fayette, Indiana, US
802363 2021-03-01 US Indiana Floyd 18043 7207 169 0 7038 38.32117957 -85.90385377 2021-03-02 05:23:30 Floyd, Indiana, US
802364 2021-03-01 US Indiana Fountain 18045 2015 42 0 1973 40.12361933 -87.24217689 2021-03-02 05:23:30 Fountain, Indiana, US
802365 2021-03-01 US Indiana Franklin 18047 1594 35 0 1559 39.4142482 -85.06062647 2021-03-02 05:23:30 Franklin, Indiana, US
802366 2021-03-01 US Indiana Fulton 18049 1782 37 0 1745 41.0469907 -86.26252745 2021-03-02 05:23:30 Fulton, Indiana, US
802367 2021-03-01 US Indiana Gibson 18051 4012 81 0 3931 38.30393723 -87.58054938 2021-03-02 05:23:30 Gibson, Indiana, US
802368 2021-03-01 US Indiana Grant 18053 6427 157 0 6270 40.51587228 -85.65468702 2021-03-02 05:23:30 Grant, Indiana, US
802369 2021-03-01 US Indiana Greene 18055 2612 80 0 2532 39.03630547 -86.96223202 2021-03-02 05:23:30 Greene, Indiana, US
802370 2021-03-01 US Indiana Hamilton 18057 32099 397 0 31702 40.07306535 -86.05244729 2021-03-02 05:23:30 Hamilton, Indiana, US
802371 2021-03-01 US Indiana Hancock 18059 7409 131 0 7278 39.82304555 -85.77566351 2021-03-02 05:23:30 Hancock, Indiana, US
802372 2021-03-01 US Indiana Harrison 18061 3998 64 0 3934 38.19467379 -86.10948271 2021-03-02 05:23:30 Harrison, Indiana, US
802373 2021-03-01 US Indiana Hendricks 18063 15825 300 0 15525 39.76719009 -86.51037283 2021-03-02 05:23:30 Hendricks, Indiana, US
802374 2021-03-01 US Indiana Henry 18065 5423 93 0 5330 39.93029017 -85.39625719 2021-03-02 05:23:30 Henry, Indiana, US
802375 2021-03-01 US Indiana Howard 18067 9056 197 0 8859 40.48527731 -86.11351892 2021-03-02 05:23:30 Howard, Indiana, US
802376 2021-03-01 US Indiana Huntington 18069 3444 76 0 3368 40.82907273 -85.48822092 2021-03-02 05:23:30 Huntington, Indiana, US
802377 2021-03-01 US Indiana Jackson 18071 4647 67 0 4580 38.90915820000001 -86.03851889 2021-03-02 05:23:30 Jackson, Indiana, US
802378 2021-03-01 US Indiana Jasper 18073 3161 43 0 3118 41.02078733 -87.11553319 2021-03-02 05:23:30 Jasper, Indiana, US
802379 2021-03-01 US Indiana Jay 18075 1778 28 0 1750 40.43781032 -85.00576229 2021-03-02 05:23:30 Jay, Indiana, US
802380 2021-03-01 US Indiana Jefferson 18077 2949 73 0 2876 38.78576239 -85.43633383 2021-03-02 05:23:30 Jefferson, Indiana, US
802381 2021-03-01 US Indiana Jennings 18079 2152 44 0 2108 38.99588883 -85.62710784 2021-03-02 05:23:30 Jennings, Indiana, US
802382 2021-03-01 US Indiana Johnson 18081 16349 360 0 15989 39.48994426 -86.10149107 2021-03-02 05:23:30 Johnson, Indiana, US
802383 2021-03-01 US Indiana Knox 18083 3574 85 0 3489 38.68861576 -87.4194665 2021-03-02 05:23:30 Knox, Indiana, US
802384 2021-03-01 US Indiana Kosciusko 18085 8562 110 0 8452 41.24521668 -85.86312322 2021-03-02 05:23:30 Kosciusko, Indiana, US
802385 2021-03-01 US Indiana LaGrange 18087 2408 70 0 2338 41.64232188 -85.42674232 2021-03-02 05:23:30 LaGrange, Indiana, US
802386 2021-03-01 US Indiana LaPorte 18091 9772 196 0 9576 41.54366008 -86.74072188 2021-03-02 05:23:30 LaPorte, Indiana, US
802387 2021-03-01 US Indiana Lake 18089 48425 878 0 47547 41.41874274 -87.38277575 2021-03-02 05:23:30 Lake, Indiana, US
802388 2021-03-01 US Indiana Lawrence 18093 4184 112 0 4072 38.84112637 -86.48361629 2021-03-02 05:23:30 Lawrence, Indiana, US
802389 2021-03-01 US Indiana Madison 18095 11746 318 0 11428 40.16143691 -85.71964711 2021-03-02 05:23:30 Madison, Indiana, US
802390 2021-03-01 US Indiana Marion 18097 90706 1645 0 89061 39.78163624 -86.13826325 2021-03-02 05:23:30 Marion, Indiana, US
802391 2021-03-01 US Indiana Marshall 18099 5425 104 0 5321 41.32467367 -86.26185087 2021-03-02 05:23:30 Marshall, Indiana, US
802392 2021-03-01 US Indiana Martin 18101 801 14 0 787 38.7099921 -86.80373186 2021-03-02 05:23:30 Martin, Indiana, US
802393 2021-03-01 US Indiana Miami 18103 3574 63 0 3511 40.76940965 -86.04525048 2021-03-02 05:23:30 Miami, Indiana, US
802394 2021-03-01 US Indiana Monroe 18105 10333 161 0 10172 39.16130004 -86.52414358 2021-03-02 05:23:30 Monroe, Indiana, US
802395 2021-03-01 US Indiana Montgomery 18107 3870 83 0 3787 40.04034823 -86.89335024 2021-03-02 05:23:30 Montgomery, Indiana, US
802396 2021-03-01 US Indiana Morgan 18109 6092 125 0 5967 39.47899078 -86.44573375 2021-03-02 05:23:30 Morgan, Indiana, US
802397 2021-03-01 US Indiana Newton 18111 965 31 0 934 40.95610449 -87.39635768 2021-03-02 05:23:30 Newton, Indiana, US
802398 2021-03-01 US Indiana Noble 18113 5093 78 0 5015 41.39672484 -85.41966713 2021-03-02 05:23:30 Noble, Indiana, US
802399 2021-03-01 US Indiana Ohio 18115 537 11 0 526 38.955305 -84.96515993 2021-03-02 05:23:30 Ohio, Indiana, US
802400 2021-03-01 US Indiana Orange 18117 1712 50 0 1662 38.54118920000001 -86.49523093 2021-03-02 05:23:30 Orange, Indiana, US
802401 2021-03-01 US Indiana Owen 18119 1821 53 0 1768 39.31145587 -86.83900724 2021-03-02 05:23:30 Owen, Indiana, US
802402 2021-03-01 US Indiana Parke 18121 1393 16 0 1377 39.77202286 -87.20375833 2021-03-02 05:23:30 Parke, Indiana, US
802403 2021-03-01 US Indiana Perry 18123 1732 35 0 1697 38.07809328 -86.63741946 2021-03-02 05:23:30 Perry, Indiana, US
802404 2021-03-01 US Indiana Pike 18125 1276 32 0 1244 38.40112197 -87.23574907 2021-03-02 05:23:30 Pike, Indiana, US
802405 2021-03-01 US Indiana Porter 18127 15975 270 0 15705 41.45986947 -87.06848888 2021-03-02 05:23:30 Porter, Indiana, US
802406 2021-03-01 US Indiana Posey 18129 2609 31 0 2578 38.02097333 -87.86480429 2021-03-02 05:23:30 Posey, Indiana, US
802407 2021-03-01 US Indiana Pulaski 18131 1064 44 0 1020 41.04166107 -86.69890683 2021-03-02 05:23:30 Pulaski, Indiana, US
802408 2021-03-01 US Indiana Putnam 18133 3305 59 0 3246 39.66437981 -86.84517605 2021-03-02 05:23:30 Putnam, Indiana, US
802409 2021-03-01 US Indiana Randolph 18135 2255 76 0 2179 40.15734772 -85.01139319 2021-03-02 05:23:30 Randolph, Indiana, US
802410 2021-03-01 US Indiana Ripley 18137 3271 61 0 3210 39.10235626 -85.26212744 2021-03-02 05:23:30 Ripley, Indiana, US
802411 2021-03-01 US Indiana Rush 18139 1648 22 0 1626 39.62002287 -85.4655599 2021-03-02 05:23:30 Rush, Indiana, US
802412 2021-03-01 US Indiana Scott 18143 2503 50 0 2453 38.68672078 -85.74627859 2021-03-02 05:23:30 Scott, Indiana, US
802413 2021-03-01 US Indiana Shelby 18145 4606 90 0 4516 39.52305623 -85.79158570000001 2021-03-02 05:23:30 Shelby, Indiana, US
802414 2021-03-01 US Indiana Spencer 18147 2173 30 0 2143 38.01519732 -87.0079644 2021-03-02 05:23:30 Spencer, Indiana, US
802415 2021-03-01 US Indiana St. Joseph 18141 29996 512 0 29484 41.61756781 -86.29040834 2021-03-02 05:23:30 St. Joseph, Indiana, US
802416 2021-03-01 US Indiana Starke 18149 1881 51 0 1830 41.27890281 -86.64686895 2021-03-02 05:23:30 Starke, Indiana, US
802417 2021-03-01 US Indiana Steuben 18151 3383 55 0 3328 41.64423868 -85.00101094 2021-03-02 05:23:30 Steuben, Indiana, US
802418 2021-03-01 US Indiana Sullivan 18153 2034 39 0 1995 39.08952258 -87.41414469 2021-03-02 05:23:30 Sullivan, Indiana, US
802419 2021-03-01 US Indiana Switzerland 18155 754 8 0 746 38.82767338 -85.03022429 2021-03-02 05:23:30 Switzerland, Indiana, US
802420 2021-03-01 US Indiana Tippecanoe 18157 20024 201 0 19823 40.38872739 -86.89413959 2021-03-02 05:23:30 Tippecanoe, Indiana, US
802421 2021-03-01 US Indiana Tipton 18159 1464 41 0 1423 40.31123252 -86.05234925 2021-03-02 05:23:30 Tipton, Indiana, US
802422 2021-03-01 US Indiana Unassigned 90018 0 433 0 -433 41.64423868 0.0 2021-03-02 05:23:30 Unassigned, Indiana, US
802423 2021-03-01 US Indiana Union 18161 671 10 0 661 39.62550777 -84.92497066 2021-03-02 05:23:30 Union, Indiana, US
802424 2021-03-01 US Indiana Vanderburgh 18163 21247 378 0 20869 38.02658833 -87.58763124 2021-03-02 05:23:30 Vanderburgh, Indiana, US
802425 2021-03-01 US Indiana Vermillion 18165 1605 42 0 1563 39.8523352 -87.46160542 2021-03-02 05:23:30 Vermillion, Indiana, US
802426 2021-03-01 US Indiana Vigo 18167 11612 229 0 11383 39.42944561 -87.39169027 2021-03-02 05:23:30 Vigo, Indiana, US
802427 2021-03-01 US Indiana Wabash 18169 3314 76 0 3238 40.84704239 -85.79328272 2021-03-02 05:23:30 Wabash, Indiana, US
802428 2021-03-01 US Indiana Warren 18171 758 14 0 744 40.34728141 -87.35602659 2021-03-02 05:23:30 Warren, Indiana, US
802429 2021-03-01 US Indiana Warrick 18173 7416 151 0 7265 38.08922676 -87.2716085 2021-03-02 05:23:30 Warrick, Indiana, US
802430 2021-03-01 US Indiana Washington 18175 2112 27 0 2085 38.60219804 -86.1049363 2021-03-02 05:23:30 Washington, Indiana, US
802431 2021-03-01 US Indiana Wayne 18177 6633 191 0 6442 39.8633444 -85.01044989 2021-03-02 05:23:30 Wayne, Indiana, US
802432 2021-03-01 US Indiana Wells 18179 2582 75 0 2507 40.72934187 -85.22132966 2021-03-02 05:23:30 Wells, Indiana, US
802433 2021-03-01 US Indiana White 18181 2973 52 0 2921 40.74911165 -86.86492015 2021-03-02 05:23:30 White, Indiana, US
802434 2021-03-01 US Indiana Whitley 18183 3494 36 0 3458 41.13863784 -85.50791236 2021-03-02 05:23:30 Whitley, Indiana, US
1067484 2021-02-28 US Indiana Adams 18001 3231 49 0 3182 40.7457653 -84.93671406 2021-03-01 05:23:01 Adams, Indiana, US
1067485 2021-02-28 US Indiana Allen 18003 35806 635 0 35171 41.09194313 -85.06800636 2021-03-01 05:23:01 Allen, Indiana, US
1067486 2021-02-28 US Indiana Bartholomew 18005 7448 147 0 7301 39.20744865 -85.89558181 2021-03-01 05:23:01 Bartholomew, Indiana, US
1067487 2021-02-28 US Indiana Benton 18007 919 13 0 906 40.60626947 -87.31093999 2021-03-01 05:23:01 Benton, Indiana, US
1067488 2021-02-28 US Indiana Blackford 18009 1206 27 0 1179 40.47388153 -85.32499702 2021-03-01 05:23:01 Blackford, Indiana, US
1067489 2021-02-28 US Indiana Boone 18011 6082 88 0 5994 40.0509304 -86.46841646 2021-03-01 05:23:01 Boone, Indiana, US
1067490 2021-02-28 US Indiana Brown 18013 949 39 0 910 39.19605589 -86.22868909 2021-03-01 05:23:01 Brown, Indiana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);