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

93 rows where "day" is on date 2020-10-12 and province_or_state = "Indiana" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Indiana · 93 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2292492 2292492 2020-10-12 US Indiana Adams 18001 383 4 0 379 40.7457653 -84.93671406 2020-10-13 04:24:02 Adams, Indiana, US
2292493 2292493 2020-10-12 US Indiana Allen 18003 7158 214 0 6944 41.09194313 -85.06800636 2020-10-13 04:24:02 Allen, Indiana, US
2292494 2292494 2020-10-12 US Indiana Bartholomew 18005 1293 67 0 1226 39.20744865 -85.89558181 2020-10-13 04:24:02 Bartholomew, Indiana, US
2292495 2292495 2020-10-12 US Indiana Benton 18007 94 0 0 94 40.60626947 -87.31093999 2020-10-13 04:24:02 Benton, Indiana, US
2292496 2292496 2020-10-12 US Indiana Blackford 18009 165 3 0 162 40.47388153 -85.32499702 2020-10-13 04:24:02 Blackford, Indiana, US
2292497 2292497 2020-10-12 US Indiana Boone 18011 1115 51 0 1064 40.0509304 -86.46841646 2020-10-13 04:24:02 Boone, Indiana, US
2292498 2292498 2020-10-12 US Indiana Brown 18013 121 3 0 118 39.19605589 -86.22868909 2020-10-13 04:24:02 Brown, Indiana, US
2292499 2292499 2020-10-12 US Indiana Carroll 18015 299 13 0 286 40.580783200000006 -86.56198812 2020-10-13 04:24:02 Carroll, Indiana, US
2292500 2292500 2020-10-12 US Indiana Cass 18017 2128 21 0 2107 40.76135835 -86.34830753 2020-10-13 04:24:02 Cass, Indiana, US
2292501 2292501 2020-10-12 US Indiana Clark 18019 2595 59 0 2536 38.48015445 -85.70510334 2020-10-13 04:24:02 Clark, Indiana, US
2292502 2292502 2020-10-12 US Indiana Clay 18021 376 7 0 369 39.39561833 -87.11723506 2020-10-13 04:24:02 Clay, Indiana, US
2292503 2292503 2020-10-12 US Indiana Clinton 18023 740 14 0 726 40.30319754 -86.47277257 2020-10-13 04:24:02 Clinton, Indiana, US
2292504 2292504 2020-10-12 US Indiana Crawford 18025 130 1 0 129 38.28814402 -86.44518825 2020-10-13 04:24:02 Crawford, Indiana, US
2292505 2292505 2020-10-12 US Indiana Daviess 18027 754 30 0 724 38.70186039 -87.07185406 2020-10-13 04:24:02 Daviess, Indiana, US
2292506 2292506 2020-10-12 US Indiana DeKalb 18033 598 15 0 583 41.39804622 -84.99906934 2020-10-13 04:24:02 DeKalb, Indiana, US
2292507 2292507 2020-10-12 US Indiana Dearborn 18029 791 31 0 760 39.14647946 -84.97333539 2020-10-13 04:24:02 Dearborn, Indiana, US
2292508 2292508 2020-10-12 US Indiana Decatur 18031 478 39 0 439 39.30712658 -85.50087166 2020-10-13 04:24:02 Decatur, Indiana, US
2292509 2292509 2020-10-12 US Indiana Delaware 18035 2476 71 0 2405 40.22787247 -85.39732772 2020-10-13 04:24:02 Delaware, Indiana, US
2292510 2292510 2020-10-12 US Indiana Dubois 18037 1208 21 0 1187 38.36597551 -86.87924170000002 2020-10-13 04:24:02 Dubois, Indiana, US
2292511 2292511 2020-10-12 US Indiana Elkhart 18039 7646 129 0 7517 41.59761169 -85.85875695 2020-10-13 04:24:02 Elkhart, Indiana, US
2292512 2292512 2020-10-12 US Indiana Fayette 18041 506 15 0 491 39.63684962 -85.17797541 2020-10-13 04:24:02 Fayette, Indiana, US
2292513 2292513 2020-10-12 US Indiana Floyd 18043 1602 75 0 1527 38.32117957 -85.90385377 2020-10-13 04:24:02 Floyd, Indiana, US
2292514 2292514 2020-10-12 US Indiana Fountain 18045 225 2 0 223 40.12361933 -87.24217689 2020-10-13 04:24:02 Fountain, Indiana, US
2292515 2292515 2020-10-12 US Indiana Franklin 18047 327 25 0 302 39.4142482 -85.06062647 2020-10-13 04:24:02 Franklin, Indiana, US
2292516 2292516 2020-10-12 US Indiana Fulton 18049 291 2 0 289 41.0469907 -86.26252745 2020-10-13 04:24:02 Fulton, Indiana, US
2292517 2292517 2020-10-12 US Indiana Gibson 18051 744 10 0 734 38.30393723 -87.58054938 2020-10-13 04:24:02 Gibson, Indiana, US
2292518 2292518 2020-10-12 US Indiana Grant 18053 1088 39 0 1049 40.51587228 -85.65468702 2020-10-13 04:24:02 Grant, Indiana, US
2292519 2292519 2020-10-12 US Indiana Greene 18055 467 36 0 431 39.03630547 -86.96223202 2020-10-13 04:24:02 Greene, Indiana, US
2292520 2292520 2020-10-12 US Indiana Hamilton 18057 5529 115 0 5414 40.07306535 -86.05244729 2020-10-13 04:24:02 Hamilton, Indiana, US
2292521 2292521 2020-10-12 US Indiana Hancock 18059 1053 44 0 1009 39.82304555 -85.77566351 2020-10-13 04:24:02 Hancock, Indiana, US
2292522 2292522 2020-10-12 US Indiana Harrison 18061 676 26 0 650 38.19467379 -86.10948271 2020-10-13 04:24:02 Harrison, Indiana, US
2292523 2292523 2020-10-12 US Indiana Hendricks 18063 2971 131 0 2840 39.76719009 -86.51037283 2020-10-13 04:24:02 Hendricks, Indiana, US
2292524 2292524 2020-10-12 US Indiana Henry 18065 1041 27 0 1014 39.93029017 -85.39625719 2020-10-13 04:24:02 Henry, Indiana, US
2292525 2292525 2020-10-12 US Indiana Howard 18067 1493 68 0 1425 40.48527731 -86.11351892 2020-10-13 04:24:02 Howard, Indiana, US
2292526 2292526 2020-10-12 US Indiana Huntington 18069 330 4 0 326 40.82907273 -85.48822092 2020-10-13 04:24:02 Huntington, Indiana, US
2292527 2292527 2020-10-12 US Indiana Jackson 18071 946 10 0 936 38.90915820000001 -86.03851889 2020-10-13 04:24:02 Jackson, Indiana, US
2292528 2292528 2020-10-12 US Indiana Jasper 18073 455 3 0 452 41.02078733 -87.11553319 2020-10-13 04:24:02 Jasper, Indiana, US
2292529 2292529 2020-10-12 US Indiana Jay 18075 244 2 0 242 40.43781032 -85.00576229 2020-10-13 04:24:02 Jay, Indiana, US
2292530 2292530 2020-10-12 US Indiana Jefferson 18077 307 4 0 303 38.78576239 -85.43633383 2020-10-13 04:24:02 Jefferson, Indiana, US
2292531 2292531 2020-10-12 US Indiana Jennings 18079 341 13 0 328 38.99588883 -85.62710784 2020-10-13 04:24:02 Jennings, Indiana, US
2292532 2292532 2020-10-12 US Indiana Johnson 18081 2740 138 0 2602 39.48994426 -86.10149107 2020-10-13 04:24:02 Johnson, Indiana, US
2292533 2292533 2020-10-12 US Indiana Knox 18083 605 14 0 591 38.68861576 -87.4194665 2020-10-13 04:24:02 Knox, Indiana, US
2292534 2292534 2020-10-12 US Indiana Kosciusko 18085 1523 18 0 1505 41.24521668 -85.86312322 2020-10-13 04:24:02 Kosciusko, Indiana, US
2292535 2292535 2020-10-12 US Indiana LaGrange 18087 720 13 0 707 41.64232188 -85.42674232 2020-10-13 04:24:02 LaGrange, Indiana, US
2292536 2292536 2020-10-12 US Indiana LaPorte 18091 1883 50 0 1833 41.54366008 -86.74072188 2020-10-13 04:24:02 LaPorte, Indiana, US
2292537 2292537 2020-10-12 US Indiana Lake 18089 11971 372 0 11599 41.41874274 -87.38277575 2020-10-13 04:24:02 Lake, Indiana, US
2292538 2292538 2020-10-12 US Indiana Lawrence 18093 648 32 0 616 38.84112637 -86.48361629 2020-10-13 04:24:02 Lawrence, Indiana, US
2292539 2292539 2020-10-12 US Indiana Madison 18095 2050 86 0 1964 40.16143691 -85.71964711 2020-10-13 04:24:02 Madison, Indiana, US
2292540 2292540 2020-10-12 US Indiana Marion 18097 23314 817 0 22497 39.78163624 -86.13826325 2020-10-13 04:24:02 Marion, Indiana, US
2292541 2292541 2020-10-12 US Indiana Marshall 18099 1189 28 0 1161 41.32467367 -86.26185087 2020-10-13 04:24:02 Marshall, Indiana, US
2292542 2292542 2020-10-12 US Indiana Martin 18101 183 0 0 183 38.7099921 -86.80373186 2020-10-13 04:24:02 Martin, Indiana, US
2292543 2292543 2020-10-12 US Indiana Miami 18103 495 4 0 491 40.76940965 -86.04525048 2020-10-13 04:24:02 Miami, Indiana, US
2292544 2292544 2020-10-12 US Indiana Monroe 18105 3015 39 0 2976 39.16130004 -86.52414358 2020-10-13 04:24:02 Monroe, Indiana, US
2292545 2292545 2020-10-12 US Indiana Montgomery 18107 533 23 0 510 40.04034823 -86.89335024 2020-10-13 04:24:02 Montgomery, Indiana, US
2292546 2292546 2020-10-12 US Indiana Morgan 18109 835 41 0 794 39.47899078 -86.44573375 2020-10-13 04:24:02 Morgan, Indiana, US
2292547 2292547 2020-10-12 US Indiana Newton 18111 190 12 0 178 40.95610449 -87.39635768 2020-10-13 04:24:02 Newton, Indiana, US
2292548 2292548 2020-10-12 US Indiana Noble 18113 1017 34 0 983 41.39672484 -85.41966713 2020-10-13 04:24:02 Noble, Indiana, US
2292549 2292549 2020-10-12 US Indiana Ohio 18115 90 8 0 82 38.955305 -84.96515993 2020-10-13 04:24:02 Ohio, Indiana, US
2292550 2292550 2020-10-12 US Indiana Orange 18117 345 24 0 321 38.54118920000001 -86.49523093 2020-10-13 04:24:02 Orange, Indiana, US
2292551 2292551 2020-10-12 US Indiana Owen 18119 183 2 0 181 39.31145587 -86.83900724 2020-10-13 04:24:02 Owen, Indiana, US
2292552 2292552 2020-10-12 US Indiana Parke 18121 174 2 0 172 39.77202286 -87.20375833 2020-10-13 04:24:02 Parke, Indiana, US
2292553 2292553 2020-10-12 US Indiana Perry 18123 255 13 0 242 38.07809328 -86.63741946 2020-10-13 04:24:02 Perry, Indiana, US
2292554 2292554 2020-10-12 US Indiana Pike 18125 285 7 0 278 38.40112197 -87.23574907 2020-10-13 04:24:02 Pike, Indiana, US
2292555 2292555 2020-10-12 US Indiana Porter 18127 2642 53 0 2589 41.45986947 -87.06848888 2020-10-13 04:24:02 Porter, Indiana, US
2292556 2292556 2020-10-12 US Indiana Posey 18129 589 3 0 586 38.02097333 -87.86480429 2020-10-13 04:24:02 Posey, Indiana, US
2292557 2292557 2020-10-12 US Indiana Pulaski 18131 124 1 0 123 41.04166107 -86.69890683 2020-10-13 04:24:02 Pulaski, Indiana, US
2292558 2292558 2020-10-12 US Indiana Putnam 18133 665 15 0 650 39.66437981 -86.84517605 2020-10-13 04:24:02 Putnam, Indiana, US
2292559 2292559 2020-10-12 US Indiana Randolph 18135 283 9 0 274 40.15734772 -85.01139319 2020-10-13 04:24:02 Randolph, Indiana, US
2292560 2292560 2020-10-12 US Indiana Ripley 18137 363 8 0 355 39.10235626 -85.26212744 2020-10-13 04:24:02 Ripley, Indiana, US
2292561 2292561 2020-10-12 US Indiana Rush 18139 172 4 0 168 39.62002287 -85.4655599 2020-10-13 04:24:02 Rush, Indiana, US
2292562 2292562 2020-10-12 US Indiana Scott 18143 478 11 0 467 38.68672078 -85.74627859 2020-10-13 04:24:02 Scott, Indiana, US
2292563 2292563 2020-10-12 US Indiana Shelby 18145 725 29 0 696 39.52305623 -85.79158570000001 2020-10-13 04:24:02 Shelby, Indiana, US
2292564 2292564 2020-10-12 US Indiana Spencer 18147 338 6 0 332 38.01519732 -87.0079644 2020-10-13 04:24:02 Spencer, Indiana, US
2292565 2292565 2020-10-12 US Indiana St. Joseph 18141 7967 155 0 7812 41.61756781 -86.29040834 2020-10-13 04:24:02 St. Joseph, Indiana, US
2292566 2292566 2020-10-12 US Indiana Starke 18149 340 8 0 332 41.27890281 -86.64686895 2020-10-13 04:24:02 Starke, Indiana, US
2292567 2292567 2020-10-12 US Indiana Steuben 18151 510 9 0 501 41.64423868 -85.00101094 2020-10-13 04:24:02 Steuben, Indiana, US
2292568 2292568 2020-10-12 US Indiana Sullivan 18153 381 14 0 367 39.08952258 -87.41414469 2020-10-13 04:24:02 Sullivan, Indiana, US
2292569 2292569 2020-10-12 US Indiana Switzerland 18155 75 0 0 75 38.82767338 -85.03022429 2020-10-13 04:24:02 Switzerland, Indiana, US
2292570 2292570 2020-10-12 US Indiana Tippecanoe 18157 3169 13 0 3156 40.38872739 -86.89413959 2020-10-13 04:24:02 Tippecanoe, Indiana, US
2292571 2292571 2020-10-12 US Indiana Tipton 18159 254 25 0 229 40.31123252 -86.05234925 2020-10-13 04:24:02 Tipton, Indiana, US
2292572 2292572 2020-10-12 US Indiana Unassigned 90018 0 80 0 0 41.64423868 0.0 2020-10-13 04:24:02 Unassigned, Indiana, US
2292573 2292573 2020-10-12 US Indiana Union 18161 85 0 0 85 39.62550777 -84.92497066 2020-10-13 04:24:02 Union, Indiana, US
2292574 2292574 2020-10-12 US Indiana Vanderburgh 18163 4950 49 0 4901 38.02658833 -87.58763124 2020-10-13 04:24:02 Vanderburgh, Indiana, US
2292575 2292575 2020-10-12 US Indiana Vermillion 18165 164 1 0 163 39.8523352 -87.46160542 2020-10-13 04:24:02 Vermillion, Indiana, US
2292576 2292576 2020-10-12 US Indiana Vigo 18167 2229 41 0 2188 39.42944561 -87.39169027 2020-10-13 04:24:02 Vigo, Indiana, US
2292577 2292577 2020-10-12 US Indiana Wabash 18169 321 10 0 311 40.84704239 -85.79328272 2020-10-13 04:24:02 Wabash, Indiana, US
2292578 2292578 2020-10-12 US Indiana Warren 18171 59 2 0 57 40.34728141 -87.35602659 2020-10-13 04:24:02 Warren, Indiana, US
2292579 2292579 2020-10-12 US Indiana Warrick 18173 1719 58 0 1661 38.08922676 -87.2716085 2020-10-13 04:24:02 Warrick, Indiana, US
2292580 2292580 2020-10-12 US Indiana Washington 18175 310 2 0 308 38.60219804 -86.1049363 2020-10-13 04:24:02 Washington, Indiana, US
2292581 2292581 2020-10-12 US Indiana Wayne 18177 984 17 0 967 39.8633444 -85.01044989 2020-10-13 04:24:02 Wayne, Indiana, US
2292582 2292582 2020-10-12 US Indiana Wells 18179 334 6 0 328 40.72934187 -85.22132966 2020-10-13 04:24:02 Wells, Indiana, US
2292583 2292583 2020-10-12 US Indiana White 18181 525 15 0 510 40.74911165 -86.86492015 2020-10-13 04:24:02 White, Indiana, US
2292584 2292584 2020-10-12 US Indiana Whitley 18183 373 10 0 363 41.13863784 -85.50791236 2020-10-13 04:24:02 Whitley, Indiana, US

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]);