ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Douglas" and fips = 17041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1037897 | 1037897 | 2021-02-17 | Douglas | Illinois | 17041 | 2304 | 36 |
1034652 | 1034652 | 2021-02-16 | Douglas | Illinois | 17041 | 2296 | 36 |
1031406 | 1031406 | 2021-02-15 | Douglas | Illinois | 17041 | 2284 | 36 |
1028159 | 1028159 | 2021-02-14 | Douglas | Illinois | 17041 | 2265 | 35 |
1024914 | 1024914 | 2021-02-13 | Douglas | Illinois | 17041 | 2265 | 35 |
1021669 | 1021669 | 2021-02-12 | Douglas | Illinois | 17041 | 2252 | 35 |
1018424 | 1018424 | 2021-02-11 | Douglas | Illinois | 17041 | 2229 | 35 |
1015179 | 1015179 | 2021-02-10 | Douglas | Illinois | 17041 | 2204 | 35 |
1011934 | 1011934 | 2021-02-09 | Douglas | Illinois | 17041 | 2185 | 35 |
1008688 | 1008688 | 2021-02-08 | Douglas | Illinois | 17041 | 2182 | 35 |
1005442 | 1005442 | 2021-02-07 | Douglas | Illinois | 17041 | 2172 | 35 |
1002196 | 1002196 | 2021-02-06 | Douglas | Illinois | 17041 | 2171 | 35 |
998950 | 998950 | 2021-02-05 | Douglas | Illinois | 17041 | 2162 | 35 |
995704 | 995704 | 2021-02-04 | Douglas | Illinois | 17041 | 2154 | 35 |
992458 | 992458 | 2021-02-03 | Douglas | Illinois | 17041 | 2145 | 35 |
989212 | 989212 | 2021-02-02 | Douglas | Illinois | 17041 | 2132 | 35 |
985965 | 985965 | 2021-02-01 | Douglas | Illinois | 17041 | 2124 | 35 |
982718 | 982718 | 2021-01-31 | Douglas | Illinois | 17041 | 2120 | 35 |
979472 | 979472 | 2021-01-30 | Douglas | Illinois | 17041 | 2109 | 35 |
976227 | 976227 | 2021-01-29 | Douglas | Illinois | 17041 | 2105 | 35 |
972982 | 972982 | 2021-01-28 | Douglas | Illinois | 17041 | 2092 | 34 |
969737 | 969737 | 2021-01-27 | Douglas | Illinois | 17041 | 2081 | 34 |
966493 | 966493 | 2021-01-26 | Douglas | Illinois | 17041 | 2064 | 34 |
963248 | 963248 | 2021-01-25 | Douglas | Illinois | 17041 | 2057 | 34 |
960003 | 960003 | 2021-01-24 | Douglas | Illinois | 17041 | 2045 | 34 |
956757 | 956757 | 2021-01-23 | Douglas | Illinois | 17041 | 2044 | 34 |
953512 | 953512 | 2021-01-22 | Douglas | Illinois | 17041 | 2034 | 34 |
950267 | 950267 | 2021-01-21 | Douglas | Illinois | 17041 | 2021 | 34 |
947021 | 947021 | 2021-01-20 | Douglas | Illinois | 17041 | 2007 | 33 |
943774 | 943774 | 2021-01-19 | Douglas | Illinois | 17041 | 1995 | 33 |
940529 | 940529 | 2021-01-18 | Douglas | Illinois | 17041 | 1987 | 33 |
937284 | 937284 | 2021-01-17 | Douglas | Illinois | 17041 | 1986 | 33 |
934039 | 934039 | 2021-01-16 | Douglas | Illinois | 17041 | 1986 | 33 |
930794 | 930794 | 2021-01-15 | Douglas | Illinois | 17041 | 1986 | 33 |
927549 | 927549 | 2021-01-14 | Douglas | Illinois | 17041 | 1982 | 33 |
924303 | 924303 | 2021-01-13 | Douglas | Illinois | 17041 | 1978 | 32 |
921058 | 921058 | 2021-01-12 | Douglas | Illinois | 17041 | 1967 | 32 |
917813 | 917813 | 2021-01-11 | Douglas | Illinois | 17041 | 1956 | 33 |
914568 | 914568 | 2021-01-10 | Douglas | Illinois | 17041 | 1945 | 33 |
911323 | 911323 | 2021-01-09 | Douglas | Illinois | 17041 | 1944 | 33 |
908078 | 908078 | 2021-01-08 | Douglas | Illinois | 17041 | 1942 | 34 |
904832 | 904832 | 2021-01-07 | Douglas | Illinois | 17041 | 1926 | 32 |
901587 | 901587 | 2021-01-06 | Douglas | Illinois | 17041 | 1914 | 31 |
898342 | 898342 | 2021-01-05 | Douglas | Illinois | 17041 | 1898 | 30 |
895097 | 895097 | 2021-01-04 | Douglas | Illinois | 17041 | 1883 | 29 |
891850 | 891850 | 2021-01-03 | Douglas | Illinois | 17041 | 1877 | 29 |
888603 | 888603 | 2021-01-02 | Douglas | Illinois | 17041 | 1876 | 28 |
885358 | 885358 | 2021-01-01 | Douglas | Illinois | 17041 | 1854 | 28 |
882113 | 882113 | 2020-12-31 | Douglas | Illinois | 17041 | 1854 | 28 |
878868 | 878868 | 2020-12-30 | Douglas | Illinois | 17041 | 1836 | 28 |
875623 | 875623 | 2020-12-29 | Douglas | Illinois | 17041 | 1820 | 27 |
872378 | 872378 | 2020-12-28 | Douglas | Illinois | 17041 | 1804 | 27 |
869133 | 869133 | 2020-12-27 | Douglas | Illinois | 17041 | 1789 | 27 |
865888 | 865888 | 2020-12-26 | Douglas | Illinois | 17041 | 1788 | 27 |
862643 | 862643 | 2020-12-25 | Douglas | Illinois | 17041 | 1779 | 26 |
859398 | 859398 | 2020-12-24 | Douglas | Illinois | 17041 | 1767 | 26 |
856153 | 856153 | 2020-12-23 | Douglas | Illinois | 17041 | 1743 | 26 |
852908 | 852908 | 2020-12-22 | Douglas | Illinois | 17041 | 1717 | 26 |
849663 | 849663 | 2020-12-21 | Douglas | Illinois | 17041 | 1707 | 24 |
846418 | 846418 | 2020-12-20 | Douglas | Illinois | 17041 | 1692 | 24 |
843172 | 843172 | 2020-12-19 | Douglas | Illinois | 17041 | 1686 | 24 |
839927 | 839927 | 2020-12-18 | Douglas | Illinois | 17041 | 1680 | 23 |
836682 | 836682 | 2020-12-17 | Douglas | Illinois | 17041 | 1658 | 22 |
833436 | 833436 | 2020-12-16 | Douglas | Illinois | 17041 | 1642 | 21 |
830189 | 830189 | 2020-12-15 | Douglas | Illinois | 17041 | 1622 | 21 |
826943 | 826943 | 2020-12-14 | Douglas | Illinois | 17041 | 1606 | 21 |
823696 | 823696 | 2020-12-13 | Douglas | Illinois | 17041 | 1598 | 21 |
820450 | 820450 | 2020-12-12 | Douglas | Illinois | 17041 | 1587 | 20 |
817204 | 817204 | 2020-12-11 | Douglas | Illinois | 17041 | 1574 | 19 |
813958 | 813958 | 2020-12-10 | Douglas | Illinois | 17041 | 1556 | 19 |
810713 | 810713 | 2020-12-09 | Douglas | Illinois | 17041 | 1543 | 18 |
807468 | 807468 | 2020-12-08 | Douglas | Illinois | 17041 | 1531 | 19 |
804223 | 804223 | 2020-12-07 | Douglas | Illinois | 17041 | 1510 | 19 |
800978 | 800978 | 2020-12-06 | Douglas | Illinois | 17041 | 1493 | 19 |
797733 | 797733 | 2020-12-05 | Douglas | Illinois | 17041 | 1484 | 19 |
794488 | 794488 | 2020-12-04 | Douglas | Illinois | 17041 | 1470 | 19 |
791243 | 791243 | 2020-12-03 | Douglas | Illinois | 17041 | 1447 | 18 |
787998 | 787998 | 2020-12-02 | Douglas | Illinois | 17041 | 1406 | 16 |
784754 | 784754 | 2020-12-01 | Douglas | Illinois | 17041 | 1385 | 16 |
781509 | 781509 | 2020-11-30 | Douglas | Illinois | 17041 | 1369 | 16 |
778263 | 778263 | 2020-11-29 | Douglas | Illinois | 17041 | 1354 | 16 |
775018 | 775018 | 2020-11-28 | Douglas | Illinois | 17041 | 1347 | 16 |
771773 | 771773 | 2020-11-27 | Douglas | Illinois | 17041 | 1327 | 16 |
768528 | 768528 | 2020-11-26 | Douglas | Illinois | 17041 | 1314 | 16 |
765282 | 765282 | 2020-11-25 | Douglas | Illinois | 17041 | 1289 | 16 |
762037 | 762037 | 2020-11-24 | Douglas | Illinois | 17041 | 1269 | 16 |
758792 | 758792 | 2020-11-23 | Douglas | Illinois | 17041 | 1254 | 16 |
755545 | 755545 | 2020-11-22 | Douglas | Illinois | 17041 | 1242 | 16 |
752299 | 752299 | 2020-11-21 | Douglas | Illinois | 17041 | 1231 | 15 |
749053 | 749053 | 2020-11-20 | Douglas | Illinois | 17041 | 1224 | 14 |
745807 | 745807 | 2020-11-19 | Douglas | Illinois | 17041 | 1197 | 12 |
742560 | 742560 | 2020-11-18 | Douglas | Illinois | 17041 | 1166 | 12 |
739313 | 739313 | 2020-11-17 | Douglas | Illinois | 17041 | 1144 | 11 |
736069 | 736069 | 2020-11-16 | Douglas | Illinois | 17041 | 1114 | 11 |
732823 | 732823 | 2020-11-15 | Douglas | Illinois | 17041 | 1105 | 11 |
729578 | 729578 | 2020-11-14 | Douglas | Illinois | 17041 | 1096 | 11 |
726335 | 726335 | 2020-11-13 | Douglas | Illinois | 17041 | 1078 | 11 |
723092 | 723092 | 2020-11-12 | Douglas | Illinois | 17041 | 1044 | 10 |
719849 | 719849 | 2020-11-11 | Douglas | Illinois | 17041 | 1034 | 10 |
716606 | 716606 | 2020-11-10 | Douglas | Illinois | 17041 | 1015 | 10 |
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);