ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Lincoln", fips = 56023 and state = "Wyoming" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177435 | 2177435 | 2022-02-02 | Lincoln | Wyoming | 56023 | 3790 | 28 |
2174182 | 2174182 | 2022-02-01 | Lincoln | Wyoming | 56023 | 3769 | 28 |
2170930 | 2170930 | 2022-01-31 | Lincoln | Wyoming | 56023 | 3750 | 27 |
2167677 | 2167677 | 2022-01-30 | Lincoln | Wyoming | 56023 | 3724 | 27 |
2164422 | 2164422 | 2022-01-29 | Lincoln | Wyoming | 56023 | 3724 | 27 |
2161167 | 2161167 | 2022-01-28 | Lincoln | Wyoming | 56023 | 3724 | 27 |
2157911 | 2157911 | 2022-01-27 | Lincoln | Wyoming | 56023 | 3710 | 27 |
2154658 | 2154658 | 2022-01-26 | Lincoln | Wyoming | 56023 | 3690 | 27 |
2151405 | 2151405 | 2022-01-25 | Lincoln | Wyoming | 56023 | 3652 | 27 |
2148153 | 2148153 | 2022-01-24 | Lincoln | Wyoming | 56023 | 3617 | 27 |
2144901 | 2144901 | 2022-01-23 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2141646 | 2141646 | 2022-01-22 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2138390 | 2138390 | 2022-01-21 | Lincoln | Wyoming | 56023 | 3555 | 27 |
2135135 | 2135135 | 2022-01-20 | Lincoln | Wyoming | 56023 | 3521 | 27 |
2131883 | 2131883 | 2022-01-19 | Lincoln | Wyoming | 56023 | 3491 | 27 |
2128629 | 2128629 | 2022-01-18 | Lincoln | Wyoming | 56023 | 3439 | 27 |
2125376 | 2125376 | 2022-01-17 | Lincoln | Wyoming | 56023 | 3339 | 27 |
2122124 | 2122124 | 2022-01-16 | Lincoln | Wyoming | 56023 | 3339 | 27 |
2118872 | 2118872 | 2022-01-15 | Lincoln | Wyoming | 56023 | 3339 | 27 |
2115620 | 2115620 | 2022-01-14 | Lincoln | Wyoming | 56023 | 3339 | 27 |
2112368 | 2112368 | 2022-01-13 | Lincoln | Wyoming | 56023 | 3303 | 27 |
2109116 | 2109116 | 2022-01-12 | Lincoln | Wyoming | 56023 | 3274 | 27 |
2105865 | 2105865 | 2022-01-11 | Lincoln | Wyoming | 56023 | 3251 | 27 |
2102614 | 2102614 | 2022-01-10 | Lincoln | Wyoming | 56023 | 3224 | 27 |
2099363 | 2099363 | 2022-01-09 | Lincoln | Wyoming | 56023 | 3181 | 27 |
2096112 | 2096112 | 2022-01-08 | Lincoln | Wyoming | 56023 | 3181 | 27 |
2092860 | 2092860 | 2022-01-07 | Lincoln | Wyoming | 56023 | 3181 | 27 |
2089608 | 2089608 | 2022-01-06 | Lincoln | Wyoming | 56023 | 3165 | 27 |
2086357 | 2086357 | 2022-01-05 | Lincoln | Wyoming | 56023 | 3148 | 27 |
2083105 | 2083105 | 2022-01-04 | Lincoln | Wyoming | 56023 | 3135 | 27 |
2079853 | 2079853 | 2022-01-03 | Lincoln | Wyoming | 56023 | 3120 | 27 |
2076601 | 2076601 | 2022-01-02 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2073350 | 2073350 | 2022-01-01 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2070099 | 2070099 | 2021-12-31 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2066848 | 2066848 | 2021-12-30 | Lincoln | Wyoming | 56023 | 3087 | 27 |
2063598 | 2063598 | 2021-12-29 | Lincoln | Wyoming | 56023 | 3075 | 27 |
2060348 | 2060348 | 2021-12-28 | Lincoln | Wyoming | 56023 | 3065 | 27 |
2057099 | 2057099 | 2021-12-27 | Lincoln | Wyoming | 56023 | 3047 | 27 |
2053850 | 2053850 | 2021-12-26 | Lincoln | Wyoming | 56023 | 3040 | 27 |
2050600 | 2050600 | 2021-12-25 | Lincoln | Wyoming | 56023 | 3040 | 27 |
2047350 | 2047350 | 2021-12-24 | Lincoln | Wyoming | 56023 | 3040 | 27 |
2044100 | 2044100 | 2021-12-23 | Lincoln | Wyoming | 56023 | 3040 | 27 |
2040851 | 2040851 | 2021-12-22 | Lincoln | Wyoming | 56023 | 3028 | 27 |
2037601 | 2037601 | 2021-12-21 | Lincoln | Wyoming | 56023 | 3023 | 27 |
2034351 | 2034351 | 2021-12-20 | Lincoln | Wyoming | 56023 | 3017 | 27 |
2031101 | 2031101 | 2021-12-19 | Lincoln | Wyoming | 56023 | 3013 | 27 |
2027850 | 2027850 | 2021-12-18 | Lincoln | Wyoming | 56023 | 3013 | 27 |
2024599 | 2024599 | 2021-12-17 | Lincoln | Wyoming | 56023 | 3013 | 27 |
2021348 | 2021348 | 2021-12-16 | Lincoln | Wyoming | 56023 | 3013 | 27 |
2018097 | 2018097 | 2021-12-15 | Lincoln | Wyoming | 56023 | 3013 | 27 |
2014847 | 2014847 | 2021-12-14 | Lincoln | Wyoming | 56023 | 3012 | 27 |
2011596 | 2011596 | 2021-12-13 | Lincoln | Wyoming | 56023 | 3010 | 25 |
2008345 | 2008345 | 2021-12-12 | Lincoln | Wyoming | 56023 | 3003 | 25 |
2005094 | 2005094 | 2021-12-11 | Lincoln | Wyoming | 56023 | 3003 | 25 |
2001843 | 2001843 | 2021-12-10 | Lincoln | Wyoming | 56023 | 3003 | 25 |
1998593 | 1998593 | 2021-12-09 | Lincoln | Wyoming | 56023 | 3001 | 25 |
1995342 | 1995342 | 2021-12-08 | Lincoln | Wyoming | 56023 | 2998 | 25 |
1992091 | 1992091 | 2021-12-07 | Lincoln | Wyoming | 56023 | 2999 | 25 |
1988840 | 1988840 | 2021-12-06 | Lincoln | Wyoming | 56023 | 2997 | 24 |
1985590 | 1985590 | 2021-12-05 | Lincoln | Wyoming | 56023 | 2992 | 24 |
1982340 | 1982340 | 2021-12-04 | Lincoln | Wyoming | 56023 | 2992 | 24 |
1979090 | 1979090 | 2021-12-03 | Lincoln | Wyoming | 56023 | 2992 | 24 |
1975840 | 1975840 | 2021-12-02 | Lincoln | Wyoming | 56023 | 2980 | 24 |
1972591 | 1972591 | 2021-12-01 | Lincoln | Wyoming | 56023 | 2975 | 24 |
1969341 | 1969341 | 2021-11-30 | Lincoln | Wyoming | 56023 | 2970 | 24 |
1966091 | 1966091 | 2021-11-29 | Lincoln | Wyoming | 56023 | 2960 | 24 |
1962839 | 1962839 | 2021-11-28 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1959588 | 1959588 | 2021-11-27 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1956337 | 1956337 | 2021-11-26 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1953086 | 1953086 | 2021-11-25 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1949835 | 1949835 | 2021-11-24 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1946584 | 1946584 | 2021-11-23 | Lincoln | Wyoming | 56023 | 2951 | 24 |
1943333 | 1943333 | 2021-11-22 | Lincoln | Wyoming | 56023 | 2943 | 24 |
1940083 | 1940083 | 2021-11-21 | Lincoln | Wyoming | 56023 | 2933 | 24 |
1936833 | 1936833 | 2021-11-20 | Lincoln | Wyoming | 56023 | 2933 | 24 |
1933583 | 1933583 | 2021-11-19 | Lincoln | Wyoming | 56023 | 2933 | 24 |
1930331 | 1930331 | 2021-11-18 | Lincoln | Wyoming | 56023 | 2930 | 24 |
1927081 | 1927081 | 2021-11-17 | Lincoln | Wyoming | 56023 | 2924 | 24 |
1923831 | 1923831 | 2021-11-16 | Lincoln | Wyoming | 56023 | 2920 | 24 |
1920582 | 1920582 | 2021-11-15 | Lincoln | Wyoming | 56023 | 2910 | 23 |
1917332 | 1917332 | 2021-11-14 | Lincoln | Wyoming | 56023 | 2891 | 23 |
1914082 | 1914082 | 2021-11-13 | Lincoln | Wyoming | 56023 | 2891 | 23 |
1910832 | 1910832 | 2021-11-12 | Lincoln | Wyoming | 56023 | 2891 | 23 |
1907583 | 1907583 | 2021-11-11 | Lincoln | Wyoming | 56023 | 2880 | 23 |
1904334 | 1904334 | 2021-11-10 | Lincoln | Wyoming | 56023 | 2880 | 23 |
1901084 | 1901084 | 2021-11-09 | Lincoln | Wyoming | 56023 | 2869 | 23 |
1897834 | 1897834 | 2021-11-08 | Lincoln | Wyoming | 56023 | 2863 | 22 |
1894584 | 1894584 | 2021-11-07 | Lincoln | Wyoming | 56023 | 2845 | 22 |
1891334 | 1891334 | 2021-11-06 | Lincoln | Wyoming | 56023 | 2845 | 22 |
1888084 | 1888084 | 2021-11-05 | Lincoln | Wyoming | 56023 | 2845 | 22 |
1884834 | 1884834 | 2021-11-04 | Lincoln | Wyoming | 56023 | 2839 | 22 |
1881585 | 1881585 | 2021-11-03 | Lincoln | Wyoming | 56023 | 2824 | 22 |
1878336 | 1878336 | 2021-11-02 | Lincoln | Wyoming | 56023 | 2813 | 22 |
1875087 | 1875087 | 2021-11-01 | Lincoln | Wyoming | 56023 | 2796 | 20 |
1871838 | 1871838 | 2021-10-31 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1868589 | 1868589 | 2021-10-30 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1865340 | 1865340 | 2021-10-29 | Lincoln | Wyoming | 56023 | 2771 | 20 |
1862091 | 1862091 | 2021-10-28 | Lincoln | Wyoming | 56023 | 2752 | 20 |
1858842 | 1858842 | 2021-10-27 | Lincoln | Wyoming | 56023 | 2733 | 20 |
1855593 | 1855593 | 2021-10-26 | Lincoln | Wyoming | 56023 | 2720 | 20 |
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);