ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Lawrence" and fips = 17101 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1037927 | 1037927 | 2021-02-17 | Lawrence | Illinois | 17101 | 2260 | 33 |
1034682 | 1034682 | 2021-02-16 | Lawrence | Illinois | 17101 | 2260 | 33 |
1031436 | 1031436 | 2021-02-15 | Lawrence | Illinois | 17101 | 2259 | 33 |
1028189 | 1028189 | 2021-02-14 | Lawrence | Illinois | 17101 | 2259 | 33 |
1024944 | 1024944 | 2021-02-13 | Lawrence | Illinois | 17101 | 2259 | 33 |
1021699 | 1021699 | 2021-02-12 | Lawrence | Illinois | 17101 | 2259 | 33 |
1018454 | 1018454 | 2021-02-11 | Lawrence | Illinois | 17101 | 2258 | 33 |
1015209 | 1015209 | 2021-02-10 | Lawrence | Illinois | 17101 | 2255 | 32 |
1011964 | 1011964 | 2021-02-09 | Lawrence | Illinois | 17101 | 2254 | 32 |
1008718 | 1008718 | 2021-02-08 | Lawrence | Illinois | 17101 | 2251 | 32 |
1005472 | 1005472 | 2021-02-07 | Lawrence | Illinois | 17101 | 2251 | 32 |
1002226 | 1002226 | 2021-02-06 | Lawrence | Illinois | 17101 | 2250 | 32 |
998980 | 998980 | 2021-02-05 | Lawrence | Illinois | 17101 | 2245 | 32 |
995734 | 995734 | 2021-02-04 | Lawrence | Illinois | 17101 | 2238 | 31 |
992488 | 992488 | 2021-02-03 | Lawrence | Illinois | 17101 | 2233 | 31 |
989242 | 989242 | 2021-02-02 | Lawrence | Illinois | 17101 | 2231 | 31 |
985995 | 985995 | 2021-02-01 | Lawrence | Illinois | 17101 | 2226 | 31 |
982748 | 982748 | 2021-01-31 | Lawrence | Illinois | 17101 | 2223 | 31 |
979502 | 979502 | 2021-01-30 | Lawrence | Illinois | 17101 | 2223 | 31 |
976257 | 976257 | 2021-01-29 | Lawrence | Illinois | 17101 | 2222 | 31 |
973012 | 973012 | 2021-01-28 | Lawrence | Illinois | 17101 | 2220 | 31 |
969767 | 969767 | 2021-01-27 | Lawrence | Illinois | 17101 | 2211 | 31 |
966523 | 966523 | 2021-01-26 | Lawrence | Illinois | 17101 | 2207 | 31 |
963278 | 963278 | 2021-01-25 | Lawrence | Illinois | 17101 | 2207 | 30 |
960033 | 960033 | 2021-01-24 | Lawrence | Illinois | 17101 | 2207 | 30 |
956787 | 956787 | 2021-01-23 | Lawrence | Illinois | 17101 | 2208 | 30 |
953542 | 953542 | 2021-01-22 | Lawrence | Illinois | 17101 | 2205 | 30 |
950297 | 950297 | 2021-01-21 | Lawrence | Illinois | 17101 | 2190 | 30 |
947051 | 947051 | 2021-01-20 | Lawrence | Illinois | 17101 | 2184 | 30 |
943804 | 943804 | 2021-01-19 | Lawrence | Illinois | 17101 | 2176 | 30 |
940559 | 940559 | 2021-01-18 | Lawrence | Illinois | 17101 | 2172 | 30 |
937314 | 937314 | 2021-01-17 | Lawrence | Illinois | 17101 | 2167 | 30 |
934069 | 934069 | 2021-01-16 | Lawrence | Illinois | 17101 | 2167 | 30 |
930824 | 930824 | 2021-01-15 | Lawrence | Illinois | 17101 | 2151 | 30 |
927579 | 927579 | 2021-01-14 | Lawrence | Illinois | 17101 | 2138 | 29 |
924333 | 924333 | 2021-01-13 | Lawrence | Illinois | 17101 | 2131 | 29 |
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 |
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);