ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Lawrence" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921088 | 921088 | 2021-01-12 | Lawrence | Illinois | 17101 | 2121 | 29 |
917843 | 917843 | 2021-01-11 | Lawrence | Illinois | 17101 | 2107 | 29 |
914598 | 914598 | 2021-01-10 | Lawrence | Illinois | 17101 | 2079 | 29 |
911353 | 911353 | 2021-01-09 | Lawrence | Illinois | 17101 | 2077 | 29 |
908108 | 908108 | 2021-01-08 | Lawrence | Illinois | 17101 | 2070 | 29 |
904862 | 904862 | 2021-01-07 | Lawrence | Illinois | 17101 | 2039 | 29 |
901617 | 901617 | 2021-01-06 | Lawrence | Illinois | 17101 | 2029 | 29 |
898372 | 898372 | 2021-01-05 | Lawrence | Illinois | 17101 | 2016 | 27 |
895127 | 895127 | 2021-01-04 | Lawrence | Illinois | 17101 | 2001 | 27 |
891880 | 891880 | 2021-01-03 | Lawrence | Illinois | 17101 | 1992 | 27 |
888633 | 888633 | 2021-01-02 | Lawrence | Illinois | 17101 | 1990 | 27 |
885388 | 885388 | 2021-01-01 | Lawrence | Illinois | 17101 | 1985 | 27 |
882143 | 882143 | 2020-12-31 | Lawrence | Illinois | 17101 | 1985 | 27 |
878898 | 878898 | 2020-12-30 | Lawrence | Illinois | 17101 | 1935 | 27 |
875653 | 875653 | 2020-12-29 | Lawrence | Illinois | 17101 | 1869 | 27 |
872408 | 872408 | 2020-12-28 | Lawrence | Illinois | 17101 | 1863 | 27 |
869163 | 869163 | 2020-12-27 | Lawrence | Illinois | 17101 | 1859 | 26 |
865918 | 865918 | 2020-12-26 | Lawrence | Illinois | 17101 | 1859 | 25 |
862673 | 862673 | 2020-12-25 | Lawrence | Illinois | 17101 | 1853 | 25 |
859428 | 859428 | 2020-12-24 | Lawrence | Illinois | 17101 | 1762 | 24 |
856183 | 856183 | 2020-12-23 | Lawrence | Illinois | 17101 | 1740 | 24 |
852938 | 852938 | 2020-12-22 | Lawrence | Illinois | 17101 | 1715 | 24 |
849693 | 849693 | 2020-12-21 | Lawrence | Illinois | 17101 | 1706 | 24 |
846448 | 846448 | 2020-12-20 | Lawrence | Illinois | 17101 | 1703 | 24 |
843202 | 843202 | 2020-12-19 | Lawrence | Illinois | 17101 | 1643 | 24 |
839957 | 839957 | 2020-12-18 | Lawrence | Illinois | 17101 | 1558 | 23 |
836712 | 836712 | 2020-12-17 | Lawrence | Illinois | 17101 | 1511 | 22 |
833466 | 833466 | 2020-12-16 | Lawrence | Illinois | 17101 | 1488 | 22 |
830219 | 830219 | 2020-12-15 | Lawrence | Illinois | 17101 | 1454 | 21 |
826973 | 826973 | 2020-12-14 | Lawrence | Illinois | 17101 | 1437 | 21 |
823726 | 823726 | 2020-12-13 | Lawrence | Illinois | 17101 | 1432 | 21 |
820480 | 820480 | 2020-12-12 | Lawrence | Illinois | 17101 | 1414 | 20 |
817234 | 817234 | 2020-12-11 | Lawrence | Illinois | 17101 | 1380 | 19 |
813988 | 813988 | 2020-12-10 | Lawrence | Illinois | 17101 | 1338 | 18 |
810743 | 810743 | 2020-12-09 | Lawrence | Illinois | 17101 | 1319 | 15 |
807498 | 807498 | 2020-12-08 | Lawrence | Illinois | 17101 | 1294 | 15 |
804253 | 804253 | 2020-12-07 | Lawrence | Illinois | 17101 | 1279 | 14 |
801008 | 801008 | 2020-12-06 | Lawrence | Illinois | 17101 | 1259 | 14 |
797763 | 797763 | 2020-12-05 | Lawrence | Illinois | 17101 | 1232 | 14 |
794518 | 794518 | 2020-12-04 | Lawrence | Illinois | 17101 | 1211 | 14 |
791273 | 791273 | 2020-12-03 | Lawrence | Illinois | 17101 | 1183 | 14 |
788028 | 788028 | 2020-12-02 | Lawrence | Illinois | 17101 | 1147 | 13 |
784784 | 784784 | 2020-12-01 | Lawrence | Illinois | 17101 | 1118 | 12 |
781539 | 781539 | 2020-11-30 | Lawrence | Illinois | 17101 | 1082 | 11 |
778293 | 778293 | 2020-11-29 | Lawrence | Illinois | 17101 | 1070 | 11 |
775048 | 775048 | 2020-11-28 | Lawrence | Illinois | 17101 | 1042 | 11 |
771803 | 771803 | 2020-11-27 | Lawrence | Illinois | 17101 | 1017 | 10 |
768558 | 768558 | 2020-11-26 | Lawrence | Illinois | 17101 | 996 | 10 |
765312 | 765312 | 2020-11-25 | Lawrence | Illinois | 17101 | 957 | 10 |
762067 | 762067 | 2020-11-24 | Lawrence | Illinois | 17101 | 924 | 10 |
758822 | 758822 | 2020-11-23 | Lawrence | Illinois | 17101 | 873 | 9 |
755575 | 755575 | 2020-11-22 | Lawrence | Illinois | 17101 | 855 | 9 |
752329 | 752329 | 2020-11-21 | Lawrence | Illinois | 17101 | 821 | 9 |
749083 | 749083 | 2020-11-20 | Lawrence | Illinois | 17101 | 788 | 9 |
745837 | 745837 | 2020-11-19 | Lawrence | Illinois | 17101 | 712 | 9 |
742590 | 742590 | 2020-11-18 | Lawrence | Illinois | 17101 | 665 | 8 |
739343 | 739343 | 2020-11-17 | Lawrence | Illinois | 17101 | 634 | 8 |
736099 | 736099 | 2020-11-16 | Lawrence | Illinois | 17101 | 608 | 8 |
732853 | 732853 | 2020-11-15 | Lawrence | Illinois | 17101 | 586 | 8 |
729608 | 729608 | 2020-11-14 | Lawrence | Illinois | 17101 | 577 | 8 |
726365 | 726365 | 2020-11-13 | Lawrence | Illinois | 17101 | 563 | 8 |
723122 | 723122 | 2020-11-12 | Lawrence | Illinois | 17101 | 534 | 8 |
719879 | 719879 | 2020-11-11 | Lawrence | Illinois | 17101 | 530 | 8 |
716636 | 716636 | 2020-11-10 | Lawrence | Illinois | 17101 | 501 | 8 |
713392 | 713392 | 2020-11-09 | Lawrence | Illinois | 17101 | 458 | 8 |
710148 | 710148 | 2020-11-08 | Lawrence | Illinois | 17101 | 454 | 8 |
706904 | 706904 | 2020-11-07 | Lawrence | Illinois | 17101 | 437 | 8 |
703661 | 703661 | 2020-11-06 | Lawrence | Illinois | 17101 | 418 | 8 |
700418 | 700418 | 2020-11-05 | Lawrence | Illinois | 17101 | 403 | 8 |
697174 | 697174 | 2020-11-04 | Lawrence | Illinois | 17101 | 393 | 8 |
693932 | 693932 | 2020-11-03 | Lawrence | Illinois | 17101 | 385 | 8 |
690689 | 690689 | 2020-11-02 | Lawrence | Illinois | 17101 | 381 | 8 |
687444 | 687444 | 2020-11-01 | Lawrence | Illinois | 17101 | 379 | 8 |
684200 | 684200 | 2020-10-31 | Lawrence | Illinois | 17101 | 362 | 8 |
680957 | 680957 | 2020-10-30 | Lawrence | Illinois | 17101 | 362 | 8 |
677714 | 677714 | 2020-10-29 | Lawrence | Illinois | 17101 | 355 | 8 |
674471 | 674471 | 2020-10-28 | Lawrence | Illinois | 17101 | 351 | 8 |
671229 | 671229 | 2020-10-27 | Lawrence | Illinois | 17101 | 338 | 8 |
667986 | 667986 | 2020-10-26 | Lawrence | Illinois | 17101 | 336 | 8 |
664742 | 664742 | 2020-10-25 | Lawrence | Illinois | 17101 | 333 | 8 |
661497 | 661497 | 2020-10-24 | Lawrence | Illinois | 17101 | 332 | 8 |
658253 | 658253 | 2020-10-23 | Lawrence | Illinois | 17101 | 324 | 8 |
655008 | 655008 | 2020-10-22 | Lawrence | Illinois | 17101 | 323 | 8 |
651763 | 651763 | 2020-10-21 | Lawrence | Illinois | 17101 | 317 | 8 |
648519 | 648519 | 2020-10-20 | Lawrence | Illinois | 17101 | 306 | 8 |
645274 | 645274 | 2020-10-19 | Lawrence | Illinois | 17101 | 306 | 8 |
642027 | 642027 | 2020-10-18 | Lawrence | Illinois | 17101 | 306 | 8 |
638780 | 638780 | 2020-10-17 | Lawrence | Illinois | 17101 | 304 | 8 |
635534 | 635534 | 2020-10-16 | Lawrence | Illinois | 17101 | 302 | 8 |
632288 | 632288 | 2020-10-15 | Lawrence | Illinois | 17101 | 296 | 7 |
629044 | 629044 | 2020-10-14 | Lawrence | Illinois | 17101 | 293 | 6 |
625801 | 625801 | 2020-10-13 | Lawrence | Illinois | 17101 | 288 | 6 |
622559 | 622559 | 2020-10-12 | Lawrence | Illinois | 17101 | 288 | 6 |
619315 | 619315 | 2020-10-11 | Lawrence | Illinois | 17101 | 288 | 6 |
616073 | 616073 | 2020-10-10 | Lawrence | Illinois | 17101 | 286 | 6 |
612832 | 612832 | 2020-10-09 | Lawrence | Illinois | 17101 | 282 | 6 |
609590 | 609590 | 2020-10-08 | Lawrence | Illinois | 17101 | 279 | 6 |
606347 | 606347 | 2020-10-07 | Lawrence | Illinois | 17101 | 277 | 6 |
603105 | 603105 | 2020-10-06 | Lawrence | Illinois | 17101 | 275 | 6 |
599862 | 599862 | 2020-10-05 | Lawrence | Illinois | 17101 | 275 | 6 |
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);