johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94,151 rows where province_or_state = "Indiana" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
393361 | 393361 | 2020-11-27 | US | Indiana | Spencer | 18147 | 890 | 8 | 0 | 882 | 38.01519732 | -87.0079644 | 2020-11-28 05:25:50 | Spencer, Indiana, US |
397406 | 397406 | 2022-10-07 | US | Indiana | Spencer | 18147 | 5784 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-10-08 04:22:56 | Spencer, Indiana, US | |
401397 | 401397 | 2021-06-29 | US | Indiana | Spencer | 18147 | 2346 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-06-30 04:21:41 | Spencer, Indiana, US | |
405431 | 405431 | 2021-12-07 | US | Indiana | Spencer | 18147 | 3664 | 48 | 0 | 38.01519732 | -87.0079644 | 2021-12-08 04:22:46 | Spencer, Indiana, US | |
409427 | 409427 | 2021-07-28 | US | Indiana | Spencer | 18147 | 2387 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-07-29 04:21:33 | Spencer, Indiana, US | |
414575 | 414575 | 2020-07-05 | US | Indiana | Spencer | 18147 | 38 | 1 | 0 | 37 | 38.01519732 | -87.0079644 | 2020-07-06 04:33:57 | Spencer, Indiana, US |
418211 | 418211 | 2020-04-18 | US | Indiana | Spencer | 18147 | 4 | 0 | 0 | 4 | 38.01519732 | -87.0079644 | 2020-04-18 22:32:47 | Spencer, Indiana, US |
420477 | 420477 | 2022-09-18 | US | Indiana | Spencer | 18147 | 5750 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-09-19 04:21:49 | Spencer, Indiana, US | |
424487 | 424487 | 2021-10-10 | US | Indiana | Spencer | 18147 | 3356 | 41 | 0 | 38.01519732 | -87.0079644 | 2021-10-11 04:21:31 | Spencer, Indiana, US | |
428456 | 428456 | 2020-09-07 | US | Indiana | Spencer | 18147 | 175 | 3 | 0 | 172 | 38.01519732 | -87.0079644 | 2020-09-08 04:28:25 | Spencer, Indiana, US |
432499 | 432499 | 2022-11-03 | US | Indiana | Spencer | 18147 | 5810 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-04 04:22:11 | Spencer, Indiana, US | |
436483 | 436483 | 2021-01-21 | US | Indiana | Spencer | 18147 | 1880 | 20 | 0 | 1860 | 38.01519732 | -87.0079644 | 2021-01-22 05:22:10 | Spencer, Indiana, US |
441737 | 441737 | 2020-07-26 | US | Indiana | Spencer | 18147 | 102 | 1 | 0 | 101 | 38.01519732 | -87.0079644 | 2020-07-27 04:35:02 | Spencer, Indiana, US |
444491 | 444491 | 2021-10-20 | US | Indiana | Spencer | 18147 | 3402 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-21 04:21:18 | Spencer, Indiana, US | |
448508 | 448508 | 2021-11-17 | US | Indiana | Spencer | 18147 | 3490 | 46 | 0 | 38.01519732 | -87.0079644 | 2021-11-18 04:21:33 | Spencer, Indiana, US | |
452529 | 452529 | 2022-12-21 | US | Indiana | Spencer | 18147 | 5928 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-12-22 04:20:56 | Spencer, Indiana, US | |
457764 | 457764 | 2020-08-07 | US | Indiana | Spencer | 18147 | 131 | 3 | 0 | 128 | 38.01519732 | -87.0079644 | 2020-08-08 04:34:53 | Spencer, Indiana, US |
460517 | 460517 | 2022-02-02 | US | Indiana | Spencer | 18147 | 4997 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-03 04:21:21 | Spencer, Indiana, US | |
464534 | 464534 | 2022-05-02 | US | Indiana | Spencer | 18147 | 5234 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-05-03 04:21:00 | Spencer, Indiana, US | |
468548 | 468548 | 2021-10-07 | US | Indiana | Spencer | 18147 | 3335 | 39 | 0 | 38.01519732 | -87.0079644 | 2021-10-08 04:21:25 | Spencer, Indiana, US | |
472539 | 472539 | 2021-02-19 | US | Indiana | Spencer | 18147 | 2143 | 29 | 0 | 2114 | 38.01519732 | -87.0079644 | 2021-02-20 05:22:51 | Spencer, Indiana, US |
476581 | 476581 | 2022-06-26 | US | Indiana | Spencer | 18147 | 5343 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-06-27 04:21:00 | Spencer, Indiana, US | |
480732 | 480732 | 2022-11-08 | US | Indiana | Spencer | 18147 | 5810 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-09 04:21:22 | Spencer, Indiana, US | |
484723 | 484723 | 2021-07-19 | US | Indiana | Spencer | 18147 | 2360 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-07-20 04:21:48 | Spencer, Indiana, US | |
488762 | 488762 | 2022-11-25 | US | Indiana | Spencer | 18147 | 5840 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-26 04:21:11 | Spencer, Indiana, US | |
492772 | 492772 | 2021-10-14 | US | Indiana | Spencer | 18147 | 3373 | 42 | 0 | 38.01519732 | -87.0079644 | 2021-10-15 04:21:26 | Spencer, Indiana, US | |
496789 | 496789 | 2021-11-06 | US | Indiana | Spencer | 18147 | 3456 | 45 | 0 | 38.01519732 | -87.0079644 | 2021-11-07 04:21:53 | Spencer, Indiana, US | |
500806 | 500806 | 2022-04-02 | US | Indiana | Spencer | 18147 | 5217 | 60 | 0 | 38.01519732 | -87.0079644 | 2022-04-03 04:20:48 | Spencer, Indiana, US | |
504826 | 504826 | 2022-12-17 | US | Indiana | Spencer | 18147 | 5928 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-12-18 04:21:03 | Spencer, Indiana, US | |
508817 | 508817 | 2021-08-14 | US | Indiana | Spencer | 18147 | 2513 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-08-15 04:21:41 | Spencer, Indiana, US | |
512831 | 512831 | 2021-08-19 | US | Indiana | Spencer | 18147 | 2619 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-08-20 04:21:33 | Spencer, Indiana, US | |
516870 | 516870 | 2022-10-15 | US | Indiana | Spencer | 18147 | 5787 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-10-16 04:22:39 | Spencer, Indiana, US | |
521743 | 521743 | 2020-04-21 | US | Indiana | Spencer | 18147 | 5 | 0 | 0 | 5 | 38.01519732 | -87.0079644 | 2020-04-21 23:30:50 | Spencer, Indiana, US |
523987 | 523987 | 2021-06-09 | US | Indiana | Spencer | 18147 | 2339 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-06-10 04:23:17 | Spencer, Indiana, US | |
529138 | 529138 | 2020-07-04 | US | Indiana | Spencer | 18147 | 37 | 1 | 0 | 36 | 38.01519732 | -87.0079644 | 2020-07-05 04:33:46 | Spencer, Indiana, US |
531833 | 531833 | 2021-02-22 | US | Indiana | Spencer | 18147 | 2158 | 30 | 0 | 2128 | 38.01519732 | -87.0079644 | 2021-02-23 05:23:41 | Spencer, Indiana, US |
535872 | 535872 | 2021-10-27 | US | Indiana | Spencer | 18147 | 3431 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-28 04:22:08 | Spencer, Indiana, US | |
539894 | 539894 | 2022-10-26 | US | Indiana | Spencer | 18147 | 5804 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-10-27 04:22:01 | Spencer, Indiana, US | |
543910 | 543910 | 2022-12-15 | US | Indiana | Spencer | 18147 | 5928 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-12-16 04:21:01 | Spencer, Indiana, US | |
547873 | 547873 | 2020-09-12 | US | Indiana | Spencer | 18147 | 180 | 3 | 0 | 177 | 38.01519732 | -87.0079644 | 2020-09-13 04:30:52 | Spencer, Indiana, US |
551911 | 551911 | 2021-12-08 | US | Indiana | Spencer | 18147 | 3685 | 48 | 0 | 38.01519732 | -87.0079644 | 2021-12-09 04:22:49 | Spencer, Indiana, US | |
555927 | 555927 | 2022-01-16 | US | Indiana | Spencer | 18147 | 4314 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-01-17 04:21:08 | Spencer, Indiana, US | |
559945 | 559945 | 2022-06-16 | US | Indiana | Spencer | 18147 | 5316 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-06-17 04:20:56 | Spencer, Indiana, US | |
564099 | 564099 | 2021-06-22 | US | Indiana | Spencer | 18147 | 2346 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-06-23 04:21:46 | Spencer, Indiana, US | |
568240 | 568240 | 2021-10-29 | US | Indiana | Spencer | 18147 | 3436 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-30 04:22:03 | Spencer, Indiana, US | |
573302 | 573302 | 2020-06-06 | US | Indiana | Spencer | 18147 | 22 | 1 | 0 | 21 | 38.01519732 | -87.0079644 | 2020-06-07 03:53:30 | Spencer, Indiana, US |
575970 | 575970 | 2022-02-25 | US | Indiana | Spencer | 18147 | 5188 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-26 04:21:12 | Spencer, Indiana, US | |
579965 | 579965 | 2021-07-13 | US | Indiana | Spencer | 18147 | 2351 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-07-14 04:21:35 | Spencer, Indiana, US | |
583950 | 583950 | 2020-08-13 | US | Indiana | Spencer | 18147 | 139 | 3 | 0 | 136 | 38.01519732 | -87.0079644 | 2020-08-14 04:51:19 | Spencer, Indiana, US |
588565 | 588565 | 2020-04-05 | US | Indiana | Spencer | 18147 | 1 | 0 | 0 | 1 | 38.01519732 | -87.0079644 | 2020-04-05 23:06:45 | Spencer, Indiana, US |
590761 | 590761 | 2021-08-08 | US | Indiana | Spencer | 18147 | 2424 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-08-09 04:21:24 | Spencer, Indiana, US | |
594797 | 594797 | 2022-07-01 | US | Indiana | Spencer | 18147 | 5363 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-02 04:21:16 | Spencer, Indiana, US | |
598810 | 598810 | 2021-10-19 | US | Indiana | Spencer | 18147 | 3391 | 42 | 0 | 38.01519732 | -87.0079644 | 2021-10-20 04:21:00 | Spencer, Indiana, US | |
602825 | 602825 | 2021-09-23 | US | Indiana | Spencer | 18147 | 3208 | 36 | 0 | 38.01519732 | -87.0079644 | 2021-09-24 04:21:44 | Spencer, Indiana, US | |
606818 | 606818 | 2021-04-09 | US | Indiana | Spencer | 18147 | 2266 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-04-10 04:20:59 | Spencer, Indiana, US | |
610808 | 610808 | 2020-08-29 | US | Indiana | Spencer | 18147 | 155 | 3 | 0 | 152 | 38.01519732 | -87.0079644 | 2020-08-30 04:28:22 | Spencer, Indiana, US |
614815 | 614815 | 2021-02-08 | US | Indiana | Spencer | 18147 | 2085 | 28 | 0 | 2057 | 38.01519732 | -87.0079644 | 2021-02-09 05:23:30 | Spencer, Indiana, US |
619004 | 619004 | 2022-11-05 | US | Indiana | Spencer | 18147 | 5810 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-06 04:21:24 | Spencer, Indiana, US | |
623017 | 623017 | 2022-05-22 | US | Indiana | Spencer | 18147 | 5276 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-05-26 04:20:50 | Spencer, Indiana, US | |
627011 | 627011 | 2021-07-10 | US | Indiana | Spencer | 18147 | 2348 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-07-11 04:21:43 | Spencer, Indiana, US | |
631047 | 631047 | 2022-07-12 | US | Indiana | Spencer | 18147 | 5408 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-13 04:20:58 | Spencer, Indiana, US | |
635060 | 635060 | 2021-10-13 | US | Indiana | Spencer | 18147 | 3367 | 42 | 0 | 38.01519732 | -87.0079644 | 2021-10-14 04:21:29 | Spencer, Indiana, US | |
639051 | 639051 | 2021-03-31 | US | Indiana | Spencer | 18147 | 2255 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-04-01 04:27:05 | Spencer, Indiana, US | |
643071 | 643071 | 2021-09-07 | US | Indiana | Spencer | 18147 | 3005 | 33 | 0 | 38.01519732 | -87.0079644 | 2021-09-08 04:21:31 | Spencer, Indiana, US | |
647081 | 647081 | 2021-05-05 | US | Indiana | Spencer | 18147 | 2308 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-05-06 04:20:38 | Spencer, Indiana, US | |
651099 | 651099 | 2021-08-09 | US | Indiana | Spencer | 18147 | 2445 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-08-10 04:21:27 | Spencer, Indiana, US | |
655132 | 655132 | 2021-10-22 | US | Indiana | Spencer | 18147 | 3419 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-23 04:21:32 | Spencer, Indiana, US | |
659452 | 659452 | 2022-05-13 | US | Indiana | Spencer | 18147 | 5253 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-05-14 04:20:48 | Spencer, Indiana, US | |
663463 | 663463 | 2020-08-11 | US | Indiana | Spencer | 18147 | 137 | 3 | 0 | 134 | 38.01519732 | -87.0079644 | 2020-08-12 04:27:29 | Spencer, Indiana, US |
667398 | 667398 | 2020-09-16 | US | Indiana | Spencer | 18147 | 194 | 4 | 0 | 190 | 38.01519732 | -87.0079644 | 2020-09-17 04:22:00 | Spencer, Indiana, US |
671438 | 671438 | 2022-07-21 | US | Indiana | Spencer | 18147 | 5468 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-22 04:21:15 | Spencer, Indiana, US | |
675454 | 675454 | 2022-07-30 | US | Indiana | Spencer | 18147 | 5516 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-07-31 04:21:02 | Spencer, Indiana, US | |
679438 | 679438 | 2020-11-23 | US | Indiana | Spencer | 18147 | 804 | 7 | 0 | 797 | 38.01519732 | -87.0079644 | 2020-11-24 05:27:31 | Spencer, Indiana, US |
683477 | 683477 | 2021-10-24 | US | Indiana | Spencer | 18147 | 3422 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-25 04:22:31 | Spencer, Indiana, US | |
687494 | 687494 | 2021-11-13 | US | Indiana | Spencer | 18147 | 3481 | 46 | 0 | 38.01519732 | -87.0079644 | 2021-11-14 04:21:31 | Spencer, Indiana, US | |
691515 | 691515 | 2022-12-23 | US | Indiana | Spencer | 18147 | 5928 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-12-24 04:21:02 | Spencer, Indiana, US | |
695527 | 695527 | 2022-03-17 | US | Indiana | Spencer | 18147 | 5210 | 58 | 0 | 38.01519732 | -87.0079644 | 2022-03-18 04:20:55 | Spencer, Indiana, US | |
699542 | 699542 | 2021-11-04 | US | Indiana | Spencer | 18147 | 3451 | 45 | 0 | 38.01519732 | -87.0079644 | 2021-11-05 04:21:54 | Spencer, Indiana, US | |
703532 | 703532 | 2021-03-16 | US | Indiana | Spencer | 18147 | 2222 | 30 | 0 | 38.01519732 | -87.0079644 | 2021-03-17 05:25:07 | Spencer, Indiana, US | |
707570 | 707570 | 2021-09-29 | US | Indiana | Spencer | 18147 | 3260 | 37 | 0 | 38.01519732 | -87.0079644 | 2021-09-30 04:21:20 | Spencer, Indiana, US | |
711592 | 711592 | 2022-11-01 | US | Indiana | Spencer | 18147 | 5804 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-11-02 04:22:09 | Spencer, Indiana, US | |
715603 | 715603 | 2021-11-12 | US | Indiana | Spencer | 18147 | 3475 | 46 | 0 | 38.01519732 | -87.0079644 | 2021-11-13 04:21:38 | Spencer, Indiana, US | |
719624 | 719624 | 2022-12-04 | US | Indiana | Spencer | 18147 | 5851 | 62 | 0 | 38.01519732 | -87.0079644 | 2022-12-05 04:20:58 | Spencer, Indiana, US | |
723635 | 723635 | 2021-11-20 | US | Indiana | Spencer | 18147 | 3505 | 46 | 0 | 38.01519732 | -87.0079644 | 2021-11-21 04:22:13 | Spencer, Indiana, US | |
727627 | 727627 | 2021-05-22 | US | Indiana | Spencer | 18147 | 2333 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-05-23 04:20:51 | Spencer, Indiana, US | |
731665 | 731665 | 2021-12-27 | US | Indiana | Spencer | 18147 | 3899 | 52 | 0 | 38.01519732 | -87.0079644 | 2021-12-28 04:21:47 | Spencer, Indiana, US | |
736746 | 736746 | 2020-06-12 | US | Indiana | Spencer | 18147 | 22 | 1 | 0 | 21 | 38.01519732 | -87.0079644 | 2020-06-13 03:33:14 | Spencer, Indiana, US |
739427 | 739427 | 2020-12-02 | US | Indiana | Spencer | 18147 | 957 | 8 | 0 | 949 | 38.01519732 | -87.0079644 | 2020-12-03 05:28:22 | Spencer, Indiana, US |
743441 | 743441 | 2021-02-20 | US | Indiana | Spencer | 18147 | 2154 | 30 | 0 | 2124 | 38.01519732 | -87.0079644 | 2021-02-21 05:24:33 | Spencer, Indiana, US |
747482 | 747482 | 2022-04-23 | US | Indiana | Spencer | 18147 | 5224 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-04-24 04:20:56 | Spencer, Indiana, US | |
752716 | 752716 | 2020-08-01 | US | Indiana | Spencer | 18147 | 110 | 3 | 0 | 107 | 38.01519732 | -87.0079644 | 2020-08-02 04:34:47 | Spencer, Indiana, US |
755426 | 755426 | 2020-10-28 | US | Indiana | Spencer | 18147 | 433 | 6 | 0 | 427 | 38.01519732 | -87.0079644 | 2020-10-29 04:24:49 | Spencer, Indiana, US |
759465 | 759465 | 2021-11-26 | US | Indiana | Spencer | 18147 | 3534 | 46 | 0 | 38.01519732 | -87.0079644 | 2021-11-27 04:22:45 | Spencer, Indiana, US | |
763436 | 763436 | 2020-10-18 | US | Indiana | Spencer | 18147 | 365 | 6 | 0 | 359 | 38.01519732 | -87.0079644 | 2020-10-19 04:24:16 | Spencer, Indiana, US |
767446 | 767446 | 2020-12-29 | US | Indiana | Spencer | 18147 | 1422 | 12 | 0 | 1410 | 38.01519732 | -87.0079644 | 2020-12-30 05:22:34 | Spencer, Indiana, US |
771485 | 771485 | 2021-10-23 | US | Indiana | Spencer | 18147 | 3421 | 43 | 0 | 38.01519732 | -87.0079644 | 2021-10-24 04:21:22 | Spencer, Indiana, US | |
775474 | 775474 | 2021-01-12 | US | Indiana | Spencer | 18147 | 1744 | 18 | 0 | 1726 | 38.01519732 | -87.0079644 | 2021-01-13 05:22:15 | Spencer, Indiana, US |
779494 | 779494 | 2021-07-08 | US | Indiana | Spencer | 18147 | 2347 | 31 | 0 | 38.01519732 | -87.0079644 | 2021-07-09 04:21:21 | Spencer, Indiana, US | |
783528 | 783528 | 2021-12-13 | US | Indiana | Spencer | 18147 | 3752 | 48 | 0 | 38.01519732 | -87.0079644 | 2021-12-14 04:22:38 | Spencer, Indiana, US | |
787498 | 787498 | 2020-10-15 | US | Indiana | Spencer | 18147 | 345 | 6 | 0 | 339 | 38.01519732 | -87.0079644 | 2020-10-16 04:24:01 | Spencer, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);