ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 18005 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921142 | 921142 | 2021-01-12 | Bartholomew | Indiana | 18005 | 6110 | 99 |
917897 | 917897 | 2021-01-11 | Bartholomew | Indiana | 18005 | 6062 | 97 |
914652 | 914652 | 2021-01-10 | Bartholomew | Indiana | 18005 | 6008 | 97 |
911407 | 911407 | 2021-01-09 | Bartholomew | Indiana | 18005 | 5964 | 97 |
908162 | 908162 | 2021-01-08 | Bartholomew | Indiana | 18005 | 5893 | 95 |
904916 | 904916 | 2021-01-07 | Bartholomew | Indiana | 18005 | 5820 | 95 |
901671 | 901671 | 2021-01-06 | Bartholomew | Indiana | 18005 | 5760 | 96 |
898426 | 898426 | 2021-01-05 | Bartholomew | Indiana | 18005 | 5713 | 95 |
895181 | 895181 | 2021-01-04 | Bartholomew | Indiana | 18005 | 5676 | 95 |
891934 | 891934 | 2021-01-03 | Bartholomew | Indiana | 18005 | 5631 | 93 |
888688 | 888688 | 2021-01-02 | Bartholomew | Indiana | 18005 | 5582 | 93 |
885442 | 885442 | 2021-01-01 | Bartholomew | Indiana | 18005 | 5541 | 93 |
882197 | 882197 | 2020-12-31 | Bartholomew | Indiana | 18005 | 5485 | 91 |
878952 | 878952 | 2020-12-30 | Bartholomew | Indiana | 18005 | 5413 | 90 |
875707 | 875707 | 2020-12-29 | Bartholomew | Indiana | 18005 | 5350 | 90 |
872462 | 872462 | 2020-12-28 | Bartholomew | Indiana | 18005 | 5317 | 85 |
869217 | 869217 | 2020-12-27 | Bartholomew | Indiana | 18005 | 5304 | 85 |
865972 | 865972 | 2020-12-26 | Bartholomew | Indiana | 18005 | 5277 | 84 |
862727 | 862727 | 2020-12-25 | Bartholomew | Indiana | 18005 | 5240 | 84 |
859482 | 859482 | 2020-12-24 | Bartholomew | Indiana | 18005 | 5211 | 84 |
856237 | 856237 | 2020-12-23 | Bartholomew | Indiana | 18005 | 5119 | 84 |
852992 | 852992 | 2020-12-22 | Bartholomew | Indiana | 18005 | 5080 | 84 |
849747 | 849747 | 2020-12-21 | Bartholomew | Indiana | 18005 | 5040 | 83 |
846502 | 846502 | 2020-12-20 | Bartholomew | Indiana | 18005 | 4987 | 83 |
843256 | 843256 | 2020-12-19 | Bartholomew | Indiana | 18005 | 4921 | 83 |
840011 | 840011 | 2020-12-18 | Bartholomew | Indiana | 18005 | 4895 | 83 |
836766 | 836766 | 2020-12-17 | Bartholomew | Indiana | 18005 | 4822 | 82 |
833520 | 833520 | 2020-12-16 | Bartholomew | Indiana | 18005 | 4735 | 80 |
830273 | 830273 | 2020-12-15 | Bartholomew | Indiana | 18005 | 4697 | 79 |
827027 | 827027 | 2020-12-14 | Bartholomew | Indiana | 18005 | 4636 | 76 |
823780 | 823780 | 2020-12-13 | Bartholomew | Indiana | 18005 | 4573 | 76 |
820534 | 820534 | 2020-12-12 | Bartholomew | Indiana | 18005 | 4514 | 75 |
817288 | 817288 | 2020-12-11 | Bartholomew | Indiana | 18005 | 4431 | 75 |
814042 | 814042 | 2020-12-10 | Bartholomew | Indiana | 18005 | 4339 | 74 |
810797 | 810797 | 2020-12-09 | Bartholomew | Indiana | 18005 | 4271 | 73 |
807552 | 807552 | 2020-12-08 | Bartholomew | Indiana | 18005 | 4222 | 73 |
804307 | 804307 | 2020-12-07 | Bartholomew | Indiana | 18005 | 4149 | 73 |
801062 | 801062 | 2020-12-06 | Bartholomew | Indiana | 18005 | 4087 | 73 |
797817 | 797817 | 2020-12-05 | Bartholomew | Indiana | 18005 | 4024 | 73 |
794572 | 794572 | 2020-12-04 | Bartholomew | Indiana | 18005 | 3933 | 71 |
791327 | 791327 | 2020-12-03 | Bartholomew | Indiana | 18005 | 3818 | 70 |
788082 | 788082 | 2020-12-02 | Bartholomew | Indiana | 18005 | 3693 | 70 |
784838 | 784838 | 2020-12-01 | Bartholomew | Indiana | 18005 | 3634 | 70 |
781593 | 781593 | 2020-11-30 | Bartholomew | Indiana | 18005 | 3569 | 70 |
778347 | 778347 | 2020-11-29 | Bartholomew | Indiana | 18005 | 3490 | 70 |
775102 | 775102 | 2020-11-28 | Bartholomew | Indiana | 18005 | 3426 | 70 |
771857 | 771857 | 2020-11-27 | Bartholomew | Indiana | 18005 | 3370 | 70 |
768612 | 768612 | 2020-11-26 | Bartholomew | Indiana | 18005 | 3252 | 68 |
765366 | 765366 | 2020-11-25 | Bartholomew | Indiana | 18005 | 3185 | 68 |
762121 | 762121 | 2020-11-24 | Bartholomew | Indiana | 18005 | 3101 | 67 |
758876 | 758876 | 2020-11-23 | Bartholomew | Indiana | 18005 | 3049 | 67 |
755629 | 755629 | 2020-11-22 | Bartholomew | Indiana | 18005 | 2979 | 67 |
752383 | 752383 | 2020-11-21 | Bartholomew | Indiana | 18005 | 2905 | 66 |
749137 | 749137 | 2020-11-20 | Bartholomew | Indiana | 18005 | 2805 | 66 |
745891 | 745891 | 2020-11-19 | Bartholomew | Indiana | 18005 | 2686 | 66 |
742644 | 742644 | 2020-11-18 | Bartholomew | Indiana | 18005 | 2589 | 66 |
739397 | 739397 | 2020-11-17 | Bartholomew | Indiana | 18005 | 2505 | 66 |
736153 | 736153 | 2020-11-16 | Bartholomew | Indiana | 18005 | 2461 | 65 |
732907 | 732907 | 2020-11-15 | Bartholomew | Indiana | 18005 | 2394 | 65 |
729662 | 729662 | 2020-11-14 | Bartholomew | Indiana | 18005 | 2279 | 65 |
726419 | 726419 | 2020-11-13 | Bartholomew | Indiana | 18005 | 2193 | 65 |
723176 | 723176 | 2020-11-12 | Bartholomew | Indiana | 18005 | 2106 | 65 |
719933 | 719933 | 2020-11-11 | Bartholomew | Indiana | 18005 | 2037 | 65 |
716690 | 716690 | 2020-11-10 | Bartholomew | Indiana | 18005 | 1990 | 65 |
713446 | 713446 | 2020-11-09 | Bartholomew | Indiana | 18005 | 1913 | 64 |
710202 | 710202 | 2020-11-08 | Bartholomew | Indiana | 18005 | 1873 | 64 |
706958 | 706958 | 2020-11-07 | Bartholomew | Indiana | 18005 | 1835 | 63 |
703715 | 703715 | 2020-11-06 | Bartholomew | Indiana | 18005 | 1769 | 63 |
700473 | 700473 | 2020-11-05 | Bartholomew | Indiana | 18005 | 1743 | 63 |
697229 | 697229 | 2020-11-04 | Bartholomew | Indiana | 18005 | 1700 | 63 |
693987 | 693987 | 2020-11-03 | Bartholomew | Indiana | 18005 | 1671 | 63 |
690744 | 690744 | 2020-11-02 | Bartholomew | Indiana | 18005 | 1638 | 63 |
687499 | 687499 | 2020-11-01 | Bartholomew | Indiana | 18005 | 1612 | 63 |
684255 | 684255 | 2020-10-31 | Bartholomew | Indiana | 18005 | 1586 | 63 |
681012 | 681012 | 2020-10-30 | Bartholomew | Indiana | 18005 | 1568 | 63 |
677769 | 677769 | 2020-10-29 | Bartholomew | Indiana | 18005 | 1547 | 63 |
674526 | 674526 | 2020-10-28 | Bartholomew | Indiana | 18005 | 1522 | 62 |
671284 | 671284 | 2020-10-27 | Bartholomew | Indiana | 18005 | 1505 | 62 |
668041 | 668041 | 2020-10-26 | Bartholomew | Indiana | 18005 | 1494 | 62 |
664797 | 664797 | 2020-10-25 | Bartholomew | Indiana | 18005 | 1484 | 62 |
661552 | 661552 | 2020-10-24 | Bartholomew | Indiana | 18005 | 1468 | 62 |
658308 | 658308 | 2020-10-23 | Bartholomew | Indiana | 18005 | 1448 | 62 |
655063 | 655063 | 2020-10-22 | Bartholomew | Indiana | 18005 | 1430 | 62 |
651818 | 651818 | 2020-10-21 | Bartholomew | Indiana | 18005 | 1412 | 62 |
648574 | 648574 | 2020-10-20 | Bartholomew | Indiana | 18005 | 1412 | 62 |
645329 | 645329 | 2020-10-19 | Bartholomew | Indiana | 18005 | 1401 | 61 |
642082 | 642082 | 2020-10-18 | Bartholomew | Indiana | 18005 | 1390 | 61 |
638835 | 638835 | 2020-10-17 | Bartholomew | Indiana | 18005 | 1378 | 61 |
635589 | 635589 | 2020-10-16 | Bartholomew | Indiana | 18005 | 1358 | 61 |
632343 | 632343 | 2020-10-15 | Bartholomew | Indiana | 18005 | 1344 | 61 |
629099 | 629099 | 2020-10-14 | Bartholomew | Indiana | 18005 | 1327 | 61 |
625856 | 625856 | 2020-10-13 | Bartholomew | Indiana | 18005 | 1322 | 61 |
622614 | 622614 | 2020-10-12 | Bartholomew | Indiana | 18005 | 1308 | 61 |
619370 | 619370 | 2020-10-11 | Bartholomew | Indiana | 18005 | 1298 | 61 |
616128 | 616128 | 2020-10-10 | Bartholomew | Indiana | 18005 | 1288 | 61 |
612887 | 612887 | 2020-10-09 | Bartholomew | Indiana | 18005 | 1279 | 61 |
609645 | 609645 | 2020-10-08 | Bartholomew | Indiana | 18005 | 1261 | 61 |
606402 | 606402 | 2020-10-07 | Bartholomew | Indiana | 18005 | 1247 | 61 |
603160 | 603160 | 2020-10-06 | Bartholomew | Indiana | 18005 | 1247 | 61 |
599917 | 599917 | 2020-10-05 | Bartholomew | Indiana | 18005 | 1243 | 61 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);