johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

94,151 rows where province_or_state = "Indiana" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date)

province_or_state 1

  • Indiana · 94,151 ✖

country_or_region 1

  • US 94,151
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2753973 2753973 2022-12-29 US Indiana Adams 18001 8456 119 0   40.7457653 -84.93671406 2022-12-30 04:21:04 Adams, Indiana, US
2753974 2753974 2022-12-29 US Indiana Allen 18003 120806 1258 0   41.09194313 -85.06800636 2022-12-30 04:21:04 Allen, Indiana, US
2753975 2753975 2022-12-29 US Indiana Bartholomew 18005 25660 265 0   39.20744865 -85.89558181 2022-12-30 04:21:04 Bartholomew, Indiana, US
2753976 2753976 2022-12-29 US Indiana Benton 18007 2889 25 0   40.60626947 -87.31093999 2022-12-30 04:21:04 Benton, Indiana, US
2753977 2753977 2022-12-29 US Indiana Blackford 18009 3579 75 0   40.47388153 -85.32499702 2022-12-30 04:21:04 Blackford, Indiana, US
2753978 2753978 2022-12-29 US Indiana Boone 18011 17135 199 0   40.0509304 -86.46841646 2022-12-30 04:21:04 Boone, Indiana, US
2753979 2753979 2022-12-29 US Indiana Brown 18013 2932 63 0   39.19605589 -86.22868909 2022-12-30 04:21:04 Brown, Indiana, US
2753980 2753980 2022-12-29 US Indiana Carroll 18015 4791 72 0   40.5807832 -86.56198812 2022-12-30 04:21:04 Carroll, Indiana, US
2753981 2753981 2022-12-29 US Indiana Cass 18017 13644 179 0   40.76135835 -86.34830753 2022-12-30 04:21:04 Cass, Indiana, US
2753982 2753982 2022-12-29 US Indiana Clark 18019 39379 421 0   38.48015445 -85.70510334 2022-12-30 04:21:04 Clark, Indiana, US
2753983 2753983 2022-12-29 US Indiana Clay 18021 7937 97 0   39.39561833 -87.11723506 2022-12-30 04:21:04 Clay, Indiana, US
2753984 2753984 2022-12-29 US Indiana Clinton 18023 10378 140 0   40.30319754 -86.47277257 2022-12-30 04:21:04 Clinton, Indiana, US
2753985 2753985 2022-12-29 US Indiana Crawford 18025 2960 41 0   38.28814402 -86.44518825 2022-12-30 04:21:04 Crawford, Indiana, US
2753986 2753986 2022-12-29 US Indiana Daviess 18027 8721 160 0   38.70186039 -87.07185406 2022-12-30 04:21:04 Daviess, Indiana, US
2753987 2753987 2022-12-29 US Indiana DeKalb 18033 13316 161 0   41.39804622 -84.99906934 2022-12-30 04:21:04 DeKalb, Indiana, US
2753988 2753988 2022-12-29 US Indiana Dearborn 18029 15692 147 0   39.14647946 -84.97333539 2022-12-30 04:21:04 Dearborn, Indiana, US
2753989 2753989 2022-12-29 US Indiana Decatur 18031 8255 152 0   39.30712658 -85.50087166 2022-12-30 04:21:04 Decatur, Indiana, US
2753990 2753990 2022-12-29 US Indiana Delaware 18035 29227 481 0   40.22787247 -85.39732772 2022-12-30 04:21:04 Delaware, Indiana, US
2753991 2753991 2022-12-29 US Indiana Dubois 18037 14409 171 0   38.36597551 -86.8792417 2022-12-30 04:21:04 Dubois, Indiana, US
2753992 2753992 2022-12-29 US Indiana Elkhart 18039 60179 773 0   41.59761169 -85.85875695 2022-12-30 04:21:04 Elkhart, Indiana, US
2753993 2753993 2022-12-29 US Indiana Fayette 18041 8036 159 0   39.63684962 -85.17797541 2022-12-30 04:21:04 Fayette, Indiana, US
2753994 2753994 2022-12-29 US Indiana Floyd 18043 23247 322 0   38.32117957 -85.90385377 2022-12-30 04:21:04 Floyd, Indiana, US
2753995 2753995 2022-12-29 US Indiana Fountain 18045 6277 108 0   40.12361933 -87.24217689 2022-12-30 04:21:04 Fountain, Indiana, US
2753996 2753996 2022-12-29 US Indiana Franklin 18047 5083 69 0   39.4142482 -85.06062647 2022-12-30 04:21:04 Franklin, Indiana, US
2753997 2753997 2022-12-29 US Indiana Fulton 18049 5587 110 0   41.0469907 -86.26252745 2022-12-30 04:21:04 Fulton, Indiana, US
2753998 2753998 2022-12-29 US Indiana Gibson 18051 13818 156 0   38.30393723 -87.58054938 2022-12-30 04:21:04 Gibson, Indiana, US
2753999 2753999 2022-12-29 US Indiana Grant 18053 20336 375 0   40.51587228 -85.65468702 2022-12-30 04:21:04 Grant, Indiana, US
2754000 2754000 2022-12-29 US Indiana Greene 18055 8745 151 0   39.03630547 -86.96223202 2022-12-30 04:21:04 Greene, Indiana, US
2754001 2754001 2022-12-29 US Indiana Hamilton 18057 94458 708 0   40.07306535 -86.05244729 2022-12-30 04:21:04 Hamilton, Indiana, US
2754002 2754002 2022-12-29 US Indiana Hancock 18059 24269 291 0   39.82304555 -85.77566351 2022-12-30 04:21:04 Hancock, Indiana, US
2754003 2754003 2022-12-29 US Indiana Harrison 18061 12891 155 0   38.19467379 -86.10948271 2022-12-30 04:21:04 Harrison, Indiana, US
2754004 2754004 2022-12-29 US Indiana Hendricks 18063 46424 597 0   39.76719009 -86.51037283 2022-12-30 04:21:04 Hendricks, Indiana, US
2754005 2754005 2022-12-29 US Indiana Henry 18065 15648 249 0   39.93029017 -85.39625719 2022-12-30 04:21:04 Henry, Indiana, US
2754006 2754006 2022-12-29 US Indiana Howard 18067 29353 476 0   40.48527731 -86.11351892 2022-12-30 04:21:04 Howard, Indiana, US
2754007 2754007 2022-12-29 US Indiana Huntington 18069 13877 171 0   40.82907273 -85.48822092 2022-12-30 04:21:04 Huntington, Indiana, US
2754008 2754008 2022-12-29 US Indiana Jackson 18071 14620 138 0   38.9091582 -86.03851889 2022-12-30 04:21:04 Jackson, Indiana, US
2754009 2754009 2022-12-29 US Indiana Jasper 18073 10716 160 0   41.02078733 -87.11553319 2022-12-30 04:21:04 Jasper, Indiana, US
2754010 2754010 2022-12-29 US Indiana Jay 18075 5655 85 0   40.43781032 -85.00576229 2022-12-30 04:21:04 Jay, Indiana, US
2754011 2754011 2022-12-29 US Indiana Jefferson 18077 10786 175 0   38.78576239 -85.43633383 2022-12-30 04:21:04 Jefferson, Indiana, US
2754012 2754012 2022-12-29 US Indiana Jennings 18079 7989 119 0   38.99588883 -85.62710784 2022-12-30 04:21:04 Jennings, Indiana, US
2754013 2754013 2022-12-29 US Indiana Johnson 18081 49475 649 0   39.48994426 -86.10149107 2022-12-30 04:21:04 Johnson, Indiana, US
2754014 2754014 2022-12-29 US Indiana Knox 18083 13576 160 0   38.68861576 -87.4194665 2022-12-30 04:21:04 Knox, Indiana, US
2754015 2754015 2022-12-29 US Indiana Kosciusko 18085 22427 248 0   41.24521668 -85.86312322 2022-12-30 04:21:04 Kosciusko, Indiana, US
2754016 2754016 2022-12-29 US Indiana LaGrange 18087 6432 105 0   41.64232188 -85.42674232 2022-12-30 04:21:04 LaGrange, Indiana, US
2754017 2754017 2022-12-29 US Indiana LaPorte 18091 30873 389 0   41.54366008 -86.74072188 2022-12-30 04:21:04 LaPorte, Indiana, US
2754018 2754018 2022-12-29 US Indiana Lake 18089 129436 1941 0   41.41874274 -87.38277575 2022-12-30 04:21:04 Lake, Indiana, US
2754019 2754019 2022-12-29 US Indiana Lawrence 18093 14035 280 0   38.84112637 -86.48361629 2022-12-30 04:21:04 Lawrence, Indiana, US
2754020 2754020 2022-12-29 US Indiana Madison 18095 38433 678 0   40.16143691 -85.71964711 2022-12-30 04:21:04 Madison, Indiana, US
2754021 2754021 2022-12-29 US Indiana Marion 18097 261041 3162 0   39.78163624 -86.13826325 2022-12-30 04:21:04 Marion, Indiana, US
2754022 2754022 2022-12-29 US Indiana Marshall 18099 13716 206 0   41.32467367 -86.26185087 2022-12-30 04:21:04 Marshall, Indiana, US
2754023 2754023 2022-12-29 US Indiana Martin 18101 2532 30 0   38.7099921 -86.80373186 2022-12-30 04:21:04 Martin, Indiana, US
2754024 2754024 2022-12-29 US Indiana Miami 18103 10566 171 0   40.76940965 -86.04525048 2022-12-30 04:21:04 Miami, Indiana, US
2754025 2754025 2022-12-29 US Indiana Monroe 18105 33514 305 0   39.16130004 -86.52414358 2022-12-30 04:21:04 Monroe, Indiana, US
2754026 2754026 2022-12-29 US Indiana Montgomery 18107 11973 169 0   40.04034823 -86.89335024 2022-12-30 04:21:04 Montgomery, Indiana, US
2754027 2754027 2022-12-29 US Indiana Morgan 18109 19030 296 0   39.47899078 -86.44573375 2022-12-30 04:21:04 Morgan, Indiana, US
2754028 2754028 2022-12-29 US Indiana Newton 18111 3020 74 0   40.95610449 -87.39635768 2022-12-30 04:21:04 Newton, Indiana, US
2754029 2754029 2022-12-29 US Indiana Noble 18113 15339 168 0   41.39672484 -85.41966713 2022-12-30 04:21:04 Noble, Indiana, US
2754030 2754030 2022-12-29 US Indiana Ohio 18115 1705 19 0   38.955305 -84.96515993 2022-12-30 04:21:04 Ohio, Indiana, US
2754031 2754031 2022-12-29 US Indiana Orange 18117 5721 103 0   38.5411892 -86.49523093 2022-12-30 04:21:04 Orange, Indiana, US
2754032 2754032 2022-12-29 US Indiana Owen 18119 6733 134 0   39.31145587 -86.83900724 2022-12-30 04:21:04 Owen, Indiana, US
2754033 2754033 2022-12-29 US Indiana Parke 18121 4157 52 0   39.77202286 -87.20375833 2022-12-30 04:21:04 Parke, Indiana, US
2754034 2754034 2022-12-29 US Indiana Perry 18123 5662 72 0   38.07809328 -86.63741946 2022-12-30 04:21:04 Perry, Indiana, US
2754035 2754035 2022-12-29 US Indiana Pike 18125 4362 53 0   38.40112197 -87.23574907 2022-12-30 04:21:04 Pike, Indiana, US
2754036 2754036 2022-12-29 US Indiana Porter 18127 46162 603 0   41.45986947 -87.06848888 2022-12-30 04:21:04 Porter, Indiana, US
2754037 2754037 2022-12-29 US Indiana Posey 18129 7602 61 0   38.02097333 -87.86480429 2022-12-30 04:21:04 Posey, Indiana, US
2754038 2754038 2022-12-29 US Indiana Pulaski 18131 3468 91 0   41.04166107 -86.69890683 2022-12-30 04:21:04 Pulaski, Indiana, US
2754039 2754039 2022-12-29 US Indiana Putnam 18133 10851 134 0   39.66437981 -86.84517605 2022-12-30 04:21:04 Putnam, Indiana, US
2754040 2754040 2022-12-29 US Indiana Randolph 18135 6775 159 0   40.15734772 -85.01139319 2022-12-30 04:21:04 Randolph, Indiana, US
2754041 2754041 2022-12-29 US Indiana Ripley 18137 9746 144 0   39.10235626 -85.26212744 2022-12-30 04:21:04 Ripley, Indiana, US
2754042 2754042 2022-12-29 US Indiana Rush 18139 5851 59 0   39.62002287 -85.4655599 2022-12-30 04:21:04 Rush, Indiana, US
2754043 2754043 2022-12-29 US Indiana Scott 18143 9227 113 0   38.68672078 -85.74627859 2022-12-30 04:21:04 Scott, Indiana, US
2754044 2754044 2022-12-29 US Indiana Shelby 18145 16458 186 0   39.52305623 -85.7915857 2022-12-30 04:21:04 Shelby, Indiana, US
2754045 2754045 2022-12-29 US Indiana Spencer 18147 5928 62 0   38.01519732 -87.0079644 2022-12-30 04:21:04 Spencer, Indiana, US
2754046 2754046 2022-12-29 US Indiana St. Joseph 18141 82393 937 0   41.61756781 -86.29040834 2022-12-30 04:21:04 St. Joseph, Indiana, US
2754047 2754047 2022-12-29 US Indiana Starke 18149 5472 110 0   41.27890281 -86.64686895 2022-12-30 04:21:04 Starke, Indiana, US
2754048 2754048 2022-12-29 US Indiana Steuben 18151 11157 124 0   41.64423868 -85.00101094 2022-12-30 04:21:04 Steuben, Indiana, US
2754049 2754049 2022-12-29 US Indiana Sullivan 18153 6167 79 0   39.08952258 -87.41414469 2022-12-30 04:21:04 Sullivan, Indiana, US
2754050 2754050 2022-12-29 US Indiana Switzerland 18155 2582 21 0   38.82767338 -85.03022429 2022-12-30 04:21:04 Switzerland, Indiana, US
2754051 2754051 2022-12-29 US Indiana Tippecanoe 18157 59210 449 0   40.38872739 -86.89413959 2022-12-30 04:21:04 Tippecanoe, Indiana, US
2754052 2754052 2022-12-29 US Indiana Tipton 18159 3915 91 0   40.31123252 -86.05234925 2022-12-30 04:21:04 Tipton, Indiana, US
2754053 2754053 2022-12-29 US Indiana Unassigned 90018 0 202 0   41.64423868 0.0 2022-12-30 04:21:04 Unassigned, Indiana, US
2754054 2754054 2022-12-29 US Indiana Union 18161 2285 23 0   39.62550777 -84.92497066 2022-12-30 04:21:04 Union, Indiana, US
2754055 2754055 2022-12-29 US Indiana Vanderburgh 18163 68326 671 0   38.02658833 -87.58763124 2022-12-30 04:21:04 Vanderburgh, Indiana, US
2754056 2754056 2022-12-29 US Indiana Vermillion 18165 4776 82 0   39.8523352 -87.46160542 2022-12-30 04:21:04 Vermillion, Indiana, US
2754057 2754057 2022-12-29 US Indiana Vigo 18167 34039 436 0   39.42944561 -87.39169027 2022-12-30 04:21:04 Vigo, Indiana, US
2754058 2754058 2022-12-29 US Indiana Wabash 18169 10052 166 0   40.84704239 -85.79328272 2022-12-30 04:21:04 Wabash, Indiana, US
2754059 2754059 2022-12-29 US Indiana Warren 18171 2343 30 0   40.34728141 -87.35602659 2022-12-30 04:21:04 Warren, Indiana, US
2754060 2754060 2022-12-29 US Indiana Warrick 18173 24040 253 0   38.08922676 -87.2716085 2022-12-30 04:21:04 Warrick, Indiana, US
2754061 2754061 2022-12-29 US Indiana Washington 18175 6997 94 0   38.60219804 -86.1049363 2022-12-30 04:21:04 Washington, Indiana, US
2754062 2754062 2022-12-29 US Indiana Wayne 18177 22694 357 0   39.8633444 -85.01044989 2022-12-30 04:21:04 Wayne, Indiana, US
2754063 2754063 2022-12-29 US Indiana Wells 18179 7387 143 0   40.72934187 -85.22132966 2022-12-30 04:21:04 Wells, Indiana, US
2754064 2754064 2022-12-29 US Indiana White 18181 8070 98 0   40.74911165 -86.86492015 2022-12-30 04:21:04 White, Indiana, US
2754065 2754065 2022-12-29 US Indiana Whitley 18183 11126 88 0   41.13863784 -85.50791236 2022-12-30 04:21:04 Whitley, Indiana, US
1074979 1074979 2022-12-28 US Indiana Adams 18001 8456 119 0   40.7457653 -84.93671406 2022-12-29 04:21:01 Adams, Indiana, US
1074980 1074980 2022-12-28 US Indiana Allen 18003 120806 1258 0   41.09194313 -85.06800636 2022-12-29 04:21:01 Allen, Indiana, US
1074981 1074981 2022-12-28 US Indiana Bartholomew 18005 25660 265 0   39.20744865 -85.89558181 2022-12-29 04:21:01 Bartholomew, Indiana, US
1074982 1074982 2022-12-28 US Indiana Benton 18007 2889 25 0   40.60626947 -87.31093999 2022-12-29 04:21:01 Benton, Indiana, US
1074983 1074983 2022-12-28 US Indiana Blackford 18009 3579 75 0   40.47388153 -85.32499702 2022-12-29 04:21:01 Blackford, Indiana, US
1074984 1074984 2022-12-28 US Indiana Boone 18011 17135 199 0   40.0509304 -86.46841646 2022-12-29 04:21:01 Boone, Indiana, US
1074985 1074985 2022-12-28 US Indiana Brown 18013 2932 63 0   39.19605589 -86.22868909 2022-12-29 04:21: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]);