johns_hopkins_csse_daily_reports

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

13,334 rows where province_or_state = "Indiana" sorted by day descending

View and edit SQL

province_or_state

  • Indiana · 13,334

country_or_region

  • US 13,334
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
135103 2020-08-12 US Indiana Adams 18001 117 2 0 115 40.7457653 -84.93671406 2020-08-13 04:29:15 Adams, Indiana, US
135104 2020-08-12 US Indiana Allen 18003 4040 163 0 3877 41.09194313 -85.06800636 2020-08-13 04:29:15 Allen, Indiana, US
135105 2020-08-12 US Indiana Bartholomew 18005 821 47 0 774 39.20744865 -85.89558181 2020-08-13 04:29:15 Bartholomew, Indiana, US
135106 2020-08-12 US Indiana Benton 18007 64 0 0 64 40.60626947 -87.31093999 2020-08-13 04:29:15 Benton, Indiana, US
135107 2020-08-12 US Indiana Blackford 18009 66 2 0 64 40.47388153 -85.32499702 2020-08-13 04:29:15 Blackford, Indiana, US
135108 2020-08-12 US Indiana Boone 18011 697 46 0 651 40.0509304 -86.46841646 2020-08-13 04:29:15 Boone, Indiana, US
135109 2020-08-12 US Indiana Brown 18013 75 2 0 73 39.19605589 -86.22868909 2020-08-13 04:29:15 Brown, Indiana, US
135110 2020-08-12 US Indiana Carroll 18015 200 3 0 197 40.580783200000006 -86.56198812 2020-08-13 04:29:15 Carroll, Indiana, US
135111 2020-08-12 US Indiana Cass 18017 1806 9 0 1797 40.76135835 -86.34830753 2020-08-13 04:29:15 Cass, Indiana, US
135112 2020-08-12 US Indiana Clark 18019 1307 50 0 1257 38.48015445 -85.70510334 2020-08-13 04:29:15 Clark, Indiana, US
135113 2020-08-12 US Indiana Clay 18021 131 5 0 126 39.39561833 -87.11723506 2020-08-13 04:29:15 Clay, Indiana, US
135114 2020-08-12 US Indiana Clinton 18023 450 4 0 446 40.30319754 -86.47277257 2020-08-13 04:29:15 Clinton, Indiana, US
135115 2020-08-12 US Indiana Crawford 18025 45 0 0 45 38.28814402 -86.44518825 2020-08-13 04:29:15 Crawford, Indiana, US
135116 2020-08-12 US Indiana Daviess 18027 279 20 0 259 38.70186039 -87.07185406 2020-08-13 04:29:15 Daviess, Indiana, US
135117 2020-08-12 US Indiana DeKalb 18033 238 4 0 234 41.39804622 -84.99906934 2020-08-13 04:29:15 DeKalb, Indiana, US
135118 2020-08-12 US Indiana Dearborn 18029 516 28 0 488 39.14647946 -84.97333539 2020-08-13 04:29:15 Dearborn, Indiana, US
135119 2020-08-12 US Indiana Decatur 18031 342 32 0 310 39.30712658 -85.50087166 2020-08-13 04:29:15 Decatur, Indiana, US
135120 2020-08-12 US Indiana Delaware 18035 760 52 0 708 40.22787247 -85.39732772 2020-08-13 04:29:15 Delaware, Indiana, US
135121 2020-08-12 US Indiana Dubois 18037 713 12 0 701 38.36597551 -86.87924170000002 2020-08-13 04:29:15 Dubois, Indiana, US
135122 2020-08-12 US Indiana Elkhart 18039 4955 86 0 4869 41.59761169 -85.85875695 2020-08-13 04:29:15 Elkhart, Indiana, US
135123 2020-08-12 US Indiana Fayette 18041 195 7 0 188 39.63684962 -85.17797541 2020-08-13 04:29:15 Fayette, Indiana, US
135124 2020-08-12 US Indiana Floyd 18043 822 49 0 773 38.32117957 -85.90385377 2020-08-13 04:29:15 Floyd, Indiana, US
135125 2020-08-12 US Indiana Fountain 18045 76 2 0 74 40.12361933 -87.24217689 2020-08-13 04:29:15 Fountain, Indiana, US
135126 2020-08-12 US Indiana Franklin 18047 247 15 0 232 39.4142482 -85.06062647 2020-08-13 04:29:15 Franklin, Indiana, US
135127 2020-08-12 US Indiana Fulton 18049 173 2 0 171 41.0469907 -86.26252745 2020-08-13 04:29:15 Fulton, Indiana, US
135128 2020-08-12 US Indiana Gibson 18051 233 4 0 229 38.30393723 -87.58054938 2020-08-13 04:29:15 Gibson, Indiana, US
135129 2020-08-12 US Indiana Grant 18053 531 30 0 501 40.51587228 -85.65468702 2020-08-13 04:29:15 Grant, Indiana, US
135130 2020-08-12 US Indiana Greene 18055 254 34 0 220 39.03630547 -86.96223202 2020-08-13 04:29:15 Greene, Indiana, US
135131 2020-08-12 US Indiana Hamilton 18057 2887 104 0 2783 40.07306535 -86.05244729 2020-08-13 04:29:15 Hamilton, Indiana, US
135132 2020-08-12 US Indiana Hancock 18059 688 39 0 649 39.82304555 -85.77566351 2020-08-13 04:29:15 Hancock, Indiana, US
135133 2020-08-12 US Indiana Harrison 18061 352 24 0 328 38.19467379 -86.10948271 2020-08-13 04:29:15 Harrison, Indiana, US
135134 2020-08-12 US Indiana Hendricks 18063 1943 108 0 1835 39.76719009 -86.51037283 2020-08-13 04:29:15 Hendricks, Indiana, US
135135 2020-08-12 US Indiana Henry 18065 418 20 0 398 39.93029017 -85.39625719 2020-08-13 04:29:15 Henry, Indiana, US
135136 2020-08-12 US Indiana Howard 18067 920 65 0 855 40.48527731 -86.11351892 2020-08-13 04:29:15 Howard, Indiana, US
135137 2020-08-12 US Indiana Huntington 18069 127 3 0 124 40.82907273 -85.48822092 2020-08-13 04:29:15 Huntington, Indiana, US
135138 2020-08-12 US Indiana Jackson 18071 597 5 0 592 38.90915820000001 -86.03851889 2020-08-13 04:29:15 Jackson, Indiana, US
135139 2020-08-12 US Indiana Jasper 18073 257 2 0 255 41.02078733 -87.11553319 2020-08-13 04:29:15 Jasper, Indiana, US
135140 2020-08-12 US Indiana Jay 18075 92 0 0 92 40.43781032 -85.00576229 2020-08-13 04:29:15 Jay, Indiana, US
135141 2020-08-12 US Indiana Jefferson 18077 166 2 0 164 38.78576239 -85.43633383 2020-08-13 04:29:15 Jefferson, Indiana, US
135142 2020-08-12 US Indiana Jennings 18079 228 12 0 216 38.99588883 -85.62710784 2020-08-13 04:29:15 Jennings, Indiana, US
135143 2020-08-12 US Indiana Johnson 18081 1794 119 0 1675 39.48994426 -86.10149107 2020-08-13 04:29:15 Johnson, Indiana, US
135144 2020-08-12 US Indiana Knox 18083 164 0 0 164 38.68861576 -87.4194665 2020-08-13 04:29:15 Knox, Indiana, US
135145 2020-08-12 US Indiana Kosciusko 18085 872 12 0 860 41.24521668 -85.86312322 2020-08-13 04:29:15 Kosciusko, Indiana, US
135146 2020-08-12 US Indiana LaGrange 18087 566 10 0 556 41.64232188 -85.42674232 2020-08-13 04:29:15 LaGrange, Indiana, US
135147 2020-08-12 US Indiana LaPorte 18091 935 30 0 905 41.54366008 -86.74072188 2020-08-13 04:29:15 LaPorte, Indiana, US
135148 2020-08-12 US Indiana Lake 18089 7742 281 0 7461 41.41874274 -87.38277575 2020-08-13 04:29:15 Lake, Indiana, US
135149 2020-08-12 US Indiana Lawrence 18093 357 27 0 330 38.84112637 -86.48361629 2020-08-13 04:29:15 Lawrence, Indiana, US
135150 2020-08-12 US Indiana Madison 18095 1030 66 0 964 40.16143691 -85.71964711 2020-08-13 04:29:15 Madison, Indiana, US
135151 2020-08-12 US Indiana Marion 18097 16194 731 0 15463 39.78163624 -86.13826325 2020-08-13 04:29:15 Marion, Indiana, US
135152 2020-08-12 US Indiana Marshall 18099 794 23 0 771 41.32467367 -86.26185087 2020-08-13 04:29:15 Marshall, Indiana, US
135153 2020-08-12 US Indiana Martin 18101 50 0 0 50 38.7099921 -86.80373186 2020-08-13 04:29:15 Martin, Indiana, US
135154 2020-08-12 US Indiana Miami 18103 277 2 0 275 40.76940965 -86.04525048 2020-08-13 04:29:15 Miami, Indiana, US
135155 2020-08-12 US Indiana Monroe 18105 767 32 0 735 39.16130004 -86.52414358 2020-08-13 04:29:15 Monroe, Indiana, US
135156 2020-08-12 US Indiana Montgomery 18107 360 21 0 339 40.04034823 -86.89335024 2020-08-13 04:29:15 Montgomery, Indiana, US
135157 2020-08-12 US Indiana Morgan 18109 489 34 0 455 39.47899078 -86.44573375 2020-08-13 04:29:15 Morgan, Indiana, US
135158 2020-08-12 US Indiana Newton 18111 121 10 0 111 40.95610449 -87.39635768 2020-08-13 04:29:15 Newton, Indiana, US
135159 2020-08-12 US Indiana Noble 18113 690 29 0 661 41.39672484 -85.41966713 2020-08-13 04:29:15 Noble, Indiana, US
135160 2020-08-12 US Indiana Ohio 18115 65 6 0 59 38.955305 -84.96515993 2020-08-13 04:29:15 Ohio, Indiana, US
135161 2020-08-12 US Indiana Orange 18117 178 24 0 154 38.54118920000001 -86.49523093 2020-08-13 04:29:15 Orange, Indiana, US
135162 2020-08-12 US Indiana Owen 18119 105 1 0 104 39.31145587 -86.83900724 2020-08-13 04:29:15 Owen, Indiana, US
135163 2020-08-12 US Indiana Parke 18121 55 1 0 54 39.77202286 -87.20375833 2020-08-13 04:29:15 Parke, Indiana, US
135164 2020-08-12 US Indiana Perry 18123 187 13 0 174 38.07809328 -86.63741946 2020-08-13 04:29:15 Perry, Indiana, US
135165 2020-08-12 US Indiana Pike 18125 62 0 0 62 38.40112197 -87.23574907 2020-08-13 04:29:15 Pike, Indiana, US
135166 2020-08-12 US Indiana Porter 18127 1362 39 0 1323 41.45986947 -87.06848888 2020-08-13 04:29:15 Porter, Indiana, US
135167 2020-08-12 US Indiana Posey 18129 180 0 0 180 38.02097333 -87.86480429 2020-08-13 04:29:15 Posey, Indiana, US
135168 2020-08-12 US Indiana Pulaski 18131 82 1 0 81 41.04166107 -86.69890683 2020-08-13 04:29:15 Pulaski, Indiana, US
135169 2020-08-12 US Indiana Putnam 18133 321 8 0 313 39.66437981 -86.84517605 2020-08-13 04:29:15 Putnam, Indiana, US
135170 2020-08-12 US Indiana Randolph 18135 127 4 0 123 40.15734772 -85.01139319 2020-08-13 04:29:15 Randolph, Indiana, US
135171 2020-08-12 US Indiana Ripley 18137 213 8 0 205 39.10235626 -85.26212744 2020-08-13 04:29:15 Ripley, Indiana, US
135172 2020-08-12 US Indiana Rush 18139 89 4 0 85 39.62002287 -85.4655599 2020-08-13 04:29:15 Rush, Indiana, US
135173 2020-08-12 US Indiana Scott 18143 273 10 0 263 38.68672078 -85.74627859 2020-08-13 04:29:15 Scott, Indiana, US
135174 2020-08-12 US Indiana Shelby 18145 568 28 0 540 39.52305623 -85.79158570000001 2020-08-13 04:29:15 Shelby, Indiana, US
135175 2020-08-12 US Indiana Spencer 18147 139 3 0 136 38.01519732 -87.0079644 2020-08-13 04:29:15 Spencer, Indiana, US
135176 2020-08-12 US Indiana St. Joseph 18141 3610 83 0 3527 41.61756781 -86.29040834 2020-08-13 04:29:15 St. Joseph, Indiana, US
135177 2020-08-12 US Indiana Starke 18149 180 7 0 173 41.27890281 -86.64686895 2020-08-13 04:29:15 Starke, Indiana, US
135178 2020-08-12 US Indiana Steuben 18151 215 3 0 212 41.64423868 -85.00101094 2020-08-13 04:29:15 Steuben, Indiana, US
135179 2020-08-12 US Indiana Sullivan 18153 141 1 0 140 39.08952258 -87.41414469 2020-08-13 04:29:15 Sullivan, Indiana, US
135180 2020-08-12 US Indiana Switzerland 18155 53 0 0 53 38.82767338 -85.03022429 2020-08-13 04:29:15 Switzerland, Indiana, US
135181 2020-08-12 US Indiana Tippecanoe 18157 1245 11 0 1234 40.38872739 -86.89413959 2020-08-13 04:29:15 Tippecanoe, Indiana, US
135182 2020-08-12 US Indiana Tipton 18159 149 12 0 137 40.31123252 -86.05234925 2020-08-13 04:29:15 Tipton, Indiana, US
135183 2020-08-12 US Indiana Unassigned 90018 0 208 0 -208 41.64423868 0.0 2020-08-13 04:29:15 Unassigned, Indiana, US
135184 2020-08-12 US Indiana Union 18161 41 0 0 41 39.62550777 -84.92497066 2020-08-13 04:29:15 Union, Indiana, US
135185 2020-08-12 US Indiana Vanderburgh 18163 2053 13 0 2040 38.02658833 -87.58763124 2020-08-13 04:29:15 Vanderburgh, Indiana, US
135186 2020-08-12 US Indiana Vermillion 18165 59 0 0 59 39.8523352 -87.46160542 2020-08-13 04:29:15 Vermillion, Indiana, US
135187 2020-08-12 US Indiana Vigo 18167 714 11 0 703 39.42944561 -87.39169027 2020-08-13 04:29:15 Vigo, Indiana, US
135188 2020-08-12 US Indiana Wabash 18169 171 5 0 166 40.84704239 -85.79328272 2020-08-13 04:29:15 Wabash, Indiana, US
135189 2020-08-12 US Indiana Warren 18171 24 1 0 23 40.34728141 -87.35602659 2020-08-13 04:29:15 Warren, Indiana, US
135190 2020-08-12 US Indiana Warrick 18173 588 30 0 558 38.08922676 -87.2716085 2020-08-13 04:29:15 Warrick, Indiana, US
135191 2020-08-12 US Indiana Washington 18175 144 1 0 143 38.60219804 -86.1049363 2020-08-13 04:29:15 Washington, Indiana, US
135192 2020-08-12 US Indiana Wayne 18177 388 10 0 378 39.8633444 -85.01044989 2020-08-13 04:29:15 Wayne, Indiana, US
135193 2020-08-12 US Indiana Wells 18179 178 2 0 176 40.72934187 -85.22132966 2020-08-13 04:29:15 Wells, Indiana, US
135194 2020-08-12 US Indiana White 18181 377 11 0 366 40.74911165 -86.86492015 2020-08-13 04:29:15 White, Indiana, US
135195 2020-08-12 US Indiana Whitley 18183 156 6 0 150 41.13863784 -85.50791236 2020-08-13 04:29:15 Whitley, Indiana, US
501473 2020-08-11 US Indiana Adams 18001 109 2 0 107 40.7457653 -84.93671406 2020-08-12 04:27:29 Adams, Indiana, US
501474 2020-08-11 US Indiana Allen 18003 4002 163 0 3839 41.09194313 -85.06800636 2020-08-12 04:27:29 Allen, Indiana, US
501475 2020-08-11 US Indiana Bartholomew 18005 817 47 0 770 39.20744865 -85.89558181 2020-08-12 04:27:29 Bartholomew, Indiana, US
501476 2020-08-11 US Indiana Benton 18007 64 0 0 64 40.60626947 -87.31093999 2020-08-12 04:27:29 Benton, Indiana, US
501477 2020-08-11 US Indiana Blackford 18009 65 2 0 63 40.47388153 -85.32499702 2020-08-12 04:27:29 Blackford, Indiana, US
501478 2020-08-11 US Indiana Boone 18011 687 46 0 641 40.0509304 -86.46841646 2020-08-12 04:27:29 Boone, Indiana, US
501479 2020-08-11 US Indiana Brown 18013 74 1 0 73 39.19605589 -86.22868909 2020-08-12 04:27:29 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] INTEGER,
   [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]);
Powered by Datasette · Query took 2100.882ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette