ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 45061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176645 | 2176645 | 2022-02-02 | Lee | South Carolina | 45061 | 4086 | 88 |
2173391 | 2173391 | 2022-02-01 | Lee | South Carolina | 45061 | 4078 | 86 |
2170139 | 2170139 | 2022-01-31 | Lee | South Carolina | 45061 | 4074 | 86 |
2166885 | 2166885 | 2022-01-30 | Lee | South Carolina | 45061 | 3995 | 85 |
2163630 | 2163630 | 2022-01-29 | Lee | South Carolina | 45061 | 3995 | 85 |
2160375 | 2160375 | 2022-01-28 | Lee | South Carolina | 45061 | 3995 | 85 |
2157119 | 2157119 | 2022-01-27 | Lee | South Carolina | 45061 | 3942 | 85 |
2153866 | 2153866 | 2022-01-26 | Lee | South Carolina | 45061 | 3927 | 85 |
2150614 | 2150614 | 2022-01-25 | Lee | South Carolina | 45061 | 3698 | 85 |
2147362 | 2147362 | 2022-01-24 | Lee | South Carolina | 45061 | 3698 | 85 |
2144108 | 2144108 | 2022-01-23 | Lee | South Carolina | 45061 | 3698 | 85 |
2140853 | 2140853 | 2022-01-22 | Lee | South Carolina | 45061 | 3698 | 85 |
2137597 | 2137597 | 2022-01-21 | Lee | South Carolina | 45061 | 3698 | 85 |
2134343 | 2134343 | 2022-01-20 | Lee | South Carolina | 45061 | 3643 | 85 |
2131091 | 2131091 | 2022-01-19 | Lee | South Carolina | 45061 | 3605 | 84 |
2127837 | 2127837 | 2022-01-18 | Lee | South Carolina | 45061 | 3575 | 84 |
2124585 | 2124585 | 2022-01-17 | Lee | South Carolina | 45061 | 3360 | 83 |
2121333 | 2121333 | 2022-01-16 | Lee | South Carolina | 45061 | 3360 | 83 |
2118081 | 2118081 | 2022-01-15 | Lee | South Carolina | 45061 | 3360 | 83 |
2114830 | 2114830 | 2022-01-14 | Lee | South Carolina | 45061 | 3360 | 83 |
2111578 | 2111578 | 2022-01-13 | Lee | South Carolina | 45061 | 3314 | 83 |
2108326 | 2108326 | 2022-01-12 | Lee | South Carolina | 45061 | 3267 | 83 |
2105075 | 2105075 | 2022-01-11 | Lee | South Carolina | 45061 | 3225 | 83 |
2101824 | 2101824 | 2022-01-10 | Lee | South Carolina | 45061 | 3194 | 82 |
2098573 | 2098573 | 2022-01-09 | Lee | South Carolina | 45061 | 3060 | 82 |
2095321 | 2095321 | 2022-01-08 | Lee | South Carolina | 45061 | 3060 | 82 |
2092069 | 2092069 | 2022-01-07 | Lee | South Carolina | 45061 | 3060 | 82 |
2088817 | 2088817 | 2022-01-06 | Lee | South Carolina | 45061 | 3030 | 82 |
2085566 | 2085566 | 2022-01-05 | Lee | South Carolina | 45061 | 2988 | 82 |
2082314 | 2082314 | 2022-01-04 | Lee | South Carolina | 45061 | 2962 | 82 |
2079062 | 2079062 | 2022-01-03 | Lee | South Carolina | 45061 | 2843 | 82 |
2075811 | 2075811 | 2022-01-02 | Lee | South Carolina | 45061 | 2843 | 82 |
2072560 | 2072560 | 2022-01-01 | Lee | South Carolina | 45061 | 2843 | 82 |
2069309 | 2069309 | 2021-12-31 | Lee | South Carolina | 45061 | 2843 | 82 |
2066058 | 2066058 | 2021-12-30 | Lee | South Carolina | 45061 | 2810 | 82 |
2062808 | 2062808 | 2021-12-29 | Lee | South Carolina | 45061 | 2784 | 82 |
2059558 | 2059558 | 2021-12-28 | Lee | South Carolina | 45061 | 2740 | 81 |
2056309 | 2056309 | 2021-12-27 | Lee | South Carolina | 45061 | 2740 | 81 |
2053060 | 2053060 | 2021-12-26 | Lee | South Carolina | 45061 | 2740 | 81 |
2049810 | 2049810 | 2021-12-25 | Lee | South Carolina | 45061 | 2740 | 81 |
2046560 | 2046560 | 2021-12-24 | Lee | South Carolina | 45061 | 2740 | 81 |
2043310 | 2043310 | 2021-12-23 | Lee | South Carolina | 45061 | 2740 | 81 |
2040061 | 2040061 | 2021-12-22 | Lee | South Carolina | 45061 | 2733 | 80 |
2036811 | 2036811 | 2021-12-21 | Lee | South Carolina | 45061 | 2731 | 80 |
2033561 | 2033561 | 2021-12-20 | Lee | South Carolina | 45061 | 2729 | 80 |
2030311 | 2030311 | 2021-12-19 | Lee | South Carolina | 45061 | 2715 | 79 |
2027060 | 2027060 | 2021-12-18 | Lee | South Carolina | 45061 | 2715 | 79 |
2023809 | 2023809 | 2021-12-17 | Lee | South Carolina | 45061 | 2715 | 79 |
2020558 | 2020558 | 2021-12-16 | Lee | South Carolina | 45061 | 2716 | 79 |
2017307 | 2017307 | 2021-12-15 | Lee | South Carolina | 45061 | 2710 | 79 |
2014057 | 2014057 | 2021-12-14 | Lee | South Carolina | 45061 | 2707 | 79 |
2010806 | 2010806 | 2021-12-13 | Lee | South Carolina | 45061 | 2704 | 79 |
2007555 | 2007555 | 2021-12-12 | Lee | South Carolina | 45061 | 2694 | 79 |
2004304 | 2004304 | 2021-12-11 | Lee | South Carolina | 45061 | 2694 | 79 |
2001053 | 2001053 | 2021-12-10 | Lee | South Carolina | 45061 | 2694 | 79 |
1997803 | 1997803 | 2021-12-09 | Lee | South Carolina | 45061 | 2689 | 79 |
1994552 | 1994552 | 2021-12-08 | Lee | South Carolina | 45061 | 2686 | 79 |
1991301 | 1991301 | 2021-12-07 | Lee | South Carolina | 45061 | 2683 | 79 |
1988050 | 1988050 | 2021-12-06 | Lee | South Carolina | 45061 | 2680 | 79 |
1984800 | 1984800 | 2021-12-05 | Lee | South Carolina | 45061 | 2665 | 79 |
1981550 | 1981550 | 2021-12-04 | Lee | South Carolina | 45061 | 2665 | 79 |
1978300 | 1978300 | 2021-12-03 | Lee | South Carolina | 45061 | 2665 | 79 |
1975050 | 1975050 | 2021-12-02 | Lee | South Carolina | 45061 | 2659 | 79 |
1971801 | 1971801 | 2021-12-01 | Lee | South Carolina | 45061 | 2658 | 79 |
1968551 | 1968551 | 2021-11-30 | Lee | South Carolina | 45061 | 2653 | 78 |
1965300 | 1965300 | 2021-11-29 | Lee | South Carolina | 45061 | 2647 | 78 |
1962048 | 1962048 | 2021-11-28 | Lee | South Carolina | 45061 | 2636 | 78 |
1958797 | 1958797 | 2021-11-27 | Lee | South Carolina | 45061 | 2636 | 78 |
1955546 | 1955546 | 2021-11-26 | Lee | South Carolina | 45061 | 2636 | 78 |
1952295 | 1952295 | 2021-11-25 | Lee | South Carolina | 45061 | 2635 | 77 |
1949044 | 1949044 | 2021-11-24 | Lee | South Carolina | 45061 | 2635 | 77 |
1945793 | 1945793 | 2021-11-23 | Lee | South Carolina | 45061 | 2633 | 77 |
1942542 | 1942542 | 2021-11-22 | Lee | South Carolina | 45061 | 2630 | 77 |
1939292 | 1939292 | 2021-11-21 | Lee | South Carolina | 45061 | 2601 | 75 |
1936042 | 1936042 | 2021-11-20 | Lee | South Carolina | 45061 | 2601 | 75 |
1932792 | 1932792 | 2021-11-19 | Lee | South Carolina | 45061 | 2601 | 75 |
1929541 | 1929541 | 2021-11-18 | Lee | South Carolina | 45061 | 2598 | 75 |
1926291 | 1926291 | 2021-11-17 | Lee | South Carolina | 45061 | 2596 | 75 |
1923041 | 1923041 | 2021-11-16 | Lee | South Carolina | 45061 | 2591 | 75 |
1919792 | 1919792 | 2021-11-15 | Lee | South Carolina | 45061 | 2588 | 75 |
1916542 | 1916542 | 2021-11-14 | Lee | South Carolina | 45061 | 2573 | 75 |
1913292 | 1913292 | 2021-11-13 | Lee | South Carolina | 45061 | 2573 | 75 |
1910042 | 1910042 | 2021-11-12 | Lee | South Carolina | 45061 | 2573 | 75 |
1906793 | 1906793 | 2021-11-11 | Lee | South Carolina | 45061 | 2568 | 75 |
1903544 | 1903544 | 2021-11-10 | Lee | South Carolina | 45061 | 2568 | 75 |
1900294 | 1900294 | 2021-11-09 | Lee | South Carolina | 45061 | 2565 | 75 |
1897044 | 1897044 | 2021-11-08 | Lee | South Carolina | 45061 | 2564 | 75 |
1893794 | 1893794 | 2021-11-07 | Lee | South Carolina | 45061 | 2561 | 75 |
1890544 | 1890544 | 2021-11-06 | Lee | South Carolina | 45061 | 2561 | 75 |
1887294 | 1887294 | 2021-11-05 | Lee | South Carolina | 45061 | 2561 | 75 |
1884044 | 1884044 | 2021-11-04 | Lee | South Carolina | 45061 | 2552 | 75 |
1880795 | 1880795 | 2021-11-03 | Lee | South Carolina | 45061 | 2549 | 75 |
1877546 | 1877546 | 2021-11-02 | Lee | South Carolina | 45061 | 2552 | 75 |
1874297 | 1874297 | 2021-11-01 | Lee | South Carolina | 45061 | 2550 | 75 |
1871048 | 1871048 | 2021-10-31 | Lee | South Carolina | 45061 | 2530 | 75 |
1867799 | 1867799 | 2021-10-30 | Lee | South Carolina | 45061 | 2530 | 75 |
1864550 | 1864550 | 2021-10-29 | Lee | South Carolina | 45061 | 2530 | 75 |
1861301 | 1861301 | 2021-10-28 | Lee | South Carolina | 45061 | 2525 | 75 |
1858052 | 1858052 | 2021-10-27 | Lee | South Carolina | 45061 | 2524 | 74 |
1854803 | 1854803 | 2021-10-26 | Lee | South Carolina | 45061 | 2524 | 74 |
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);