ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Kershaw" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176642 | 2176642 | 2022-02-02 | Kershaw | South Carolina | 45055 | 19823 | 227 |
2173388 | 2173388 | 2022-02-01 | Kershaw | South Carolina | 45055 | 19759 | 224 |
2170136 | 2170136 | 2022-01-31 | Kershaw | South Carolina | 45055 | 19699 | 224 |
2166882 | 2166882 | 2022-01-30 | Kershaw | South Carolina | 45055 | 19293 | 223 |
2163627 | 2163627 | 2022-01-29 | Kershaw | South Carolina | 45055 | 19293 | 223 |
2160372 | 2160372 | 2022-01-28 | Kershaw | South Carolina | 45055 | 19293 | 223 |
2157116 | 2157116 | 2022-01-27 | Kershaw | South Carolina | 45055 | 19012 | 222 |
2153863 | 2153863 | 2022-01-26 | Kershaw | South Carolina | 45055 | 18877 | 222 |
2150611 | 2150611 | 2022-01-25 | Kershaw | South Carolina | 45055 | 17772 | 219 |
2147359 | 2147359 | 2022-01-24 | Kershaw | South Carolina | 45055 | 17772 | 219 |
2144105 | 2144105 | 2022-01-23 | Kershaw | South Carolina | 45055 | 17772 | 219 |
2140850 | 2140850 | 2022-01-22 | Kershaw | South Carolina | 45055 | 17772 | 219 |
2137594 | 2137594 | 2022-01-21 | Kershaw | South Carolina | 45055 | 17772 | 219 |
2134340 | 2134340 | 2022-01-20 | Kershaw | South Carolina | 45055 | 17489 | 219 |
2131088 | 2131088 | 2022-01-19 | Kershaw | South Carolina | 45055 | 17270 | 219 |
2127834 | 2127834 | 2022-01-18 | Kershaw | South Carolina | 45055 | 17124 | 219 |
2124582 | 2124582 | 2022-01-17 | Kershaw | South Carolina | 45055 | 16061 | 219 |
2121330 | 2121330 | 2022-01-16 | Kershaw | South Carolina | 45055 | 16061 | 219 |
2118078 | 2118078 | 2022-01-15 | Kershaw | South Carolina | 45055 | 16061 | 219 |
2114827 | 2114827 | 2022-01-14 | Kershaw | South Carolina | 45055 | 16061 | 219 |
2111575 | 2111575 | 2022-01-13 | Kershaw | South Carolina | 45055 | 15761 | 219 |
2108323 | 2108323 | 2022-01-12 | Kershaw | South Carolina | 45055 | 15429 | 219 |
2105072 | 2105072 | 2022-01-11 | Kershaw | South Carolina | 45055 | 15257 | 219 |
2101821 | 2101821 | 2022-01-10 | Kershaw | South Carolina | 45055 | 15107 | 219 |
2098570 | 2098570 | 2022-01-09 | Kershaw | South Carolina | 45055 | 14491 | 219 |
2095318 | 2095318 | 2022-01-08 | Kershaw | South Carolina | 45055 | 14491 | 219 |
2092066 | 2092066 | 2022-01-07 | Kershaw | South Carolina | 45055 | 14491 | 219 |
2088814 | 2088814 | 2022-01-06 | Kershaw | South Carolina | 45055 | 14336 | 219 |
2085563 | 2085563 | 2022-01-05 | Kershaw | South Carolina | 45055 | 14042 | 219 |
2082311 | 2082311 | 2022-01-04 | Kershaw | South Carolina | 45055 | 13919 | 218 |
2079059 | 2079059 | 2022-01-03 | Kershaw | South Carolina | 45055 | 13317 | 218 |
2075808 | 2075808 | 2022-01-02 | Kershaw | South Carolina | 45055 | 13317 | 218 |
2072557 | 2072557 | 2022-01-01 | Kershaw | South Carolina | 45055 | 13317 | 218 |
2069306 | 2069306 | 2021-12-31 | Kershaw | South Carolina | 45055 | 13317 | 218 |
2066055 | 2066055 | 2021-12-30 | Kershaw | South Carolina | 45055 | 13195 | 218 |
2062805 | 2062805 | 2021-12-29 | Kershaw | South Carolina | 45055 | 13095 | 218 |
2059555 | 2059555 | 2021-12-28 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2056306 | 2056306 | 2021-12-27 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2053057 | 2053057 | 2021-12-26 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2049807 | 2049807 | 2021-12-25 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2046557 | 2046557 | 2021-12-24 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2043307 | 2043307 | 2021-12-23 | Kershaw | South Carolina | 45055 | 12822 | 218 |
2040058 | 2040058 | 2021-12-22 | Kershaw | South Carolina | 45055 | 12779 | 217 |
2036808 | 2036808 | 2021-12-21 | Kershaw | South Carolina | 45055 | 12753 | 217 |
2033558 | 2033558 | 2021-12-20 | Kershaw | South Carolina | 45055 | 12746 | 217 |
2030308 | 2030308 | 2021-12-19 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2027057 | 2027057 | 2021-12-18 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2023806 | 2023806 | 2021-12-17 | Kershaw | South Carolina | 45055 | 12683 | 217 |
2020555 | 2020555 | 2021-12-16 | Kershaw | South Carolina | 45055 | 12662 | 217 |
2017304 | 2017304 | 2021-12-15 | Kershaw | South Carolina | 45055 | 12649 | 217 |
2014054 | 2014054 | 2021-12-14 | Kershaw | South Carolina | 45055 | 12638 | 217 |
2010803 | 2010803 | 2021-12-13 | Kershaw | South Carolina | 45055 | 12622 | 216 |
2007552 | 2007552 | 2021-12-12 | Kershaw | South Carolina | 45055 | 12526 | 215 |
2004301 | 2004301 | 2021-12-11 | Kershaw | South Carolina | 45055 | 12526 | 215 |
2001050 | 2001050 | 2021-12-10 | Kershaw | South Carolina | 45055 | 12526 | 215 |
1997800 | 1997800 | 2021-12-09 | Kershaw | South Carolina | 45055 | 12506 | 214 |
1994549 | 1994549 | 2021-12-08 | Kershaw | South Carolina | 45055 | 12477 | 213 |
1991298 | 1991298 | 2021-12-07 | Kershaw | South Carolina | 45055 | 12450 | 213 |
1988047 | 1988047 | 2021-12-06 | Kershaw | South Carolina | 45055 | 12433 | 213 |
1984797 | 1984797 | 2021-12-05 | Kershaw | South Carolina | 45055 | 12334 | 212 |
1981547 | 1981547 | 2021-12-04 | Kershaw | South Carolina | 45055 | 12334 | 212 |
1978297 | 1978297 | 2021-12-03 | Kershaw | South Carolina | 45055 | 12334 | 212 |
1975047 | 1975047 | 2021-12-02 | Kershaw | South Carolina | 45055 | 12295 | 212 |
1971798 | 1971798 | 2021-12-01 | Kershaw | South Carolina | 45055 | 12276 | 212 |
1968548 | 1968548 | 2021-11-30 | Kershaw | South Carolina | 45055 | 12256 | 211 |
1965297 | 1965297 | 2021-11-29 | Kershaw | South Carolina | 45055 | 12238 | 211 |
1962045 | 1962045 | 2021-11-28 | Kershaw | South Carolina | 45055 | 12217 | 210 |
1958794 | 1958794 | 2021-11-27 | Kershaw | South Carolina | 45055 | 12217 | 210 |
1955543 | 1955543 | 2021-11-26 | Kershaw | South Carolina | 45055 | 12217 | 210 |
1952292 | 1952292 | 2021-11-25 | Kershaw | South Carolina | 45055 | 12207 | 209 |
1949041 | 1949041 | 2021-11-24 | Kershaw | South Carolina | 45055 | 12207 | 209 |
1945790 | 1945790 | 2021-11-23 | Kershaw | South Carolina | 45055 | 12196 | 209 |
1942539 | 1942539 | 2021-11-22 | Kershaw | South Carolina | 45055 | 12194 | 208 |
1939289 | 1939289 | 2021-11-21 | Kershaw | South Carolina | 45055 | 12161 | 206 |
1936039 | 1936039 | 2021-11-20 | Kershaw | South Carolina | 45055 | 12161 | 206 |
1932789 | 1932789 | 2021-11-19 | Kershaw | South Carolina | 45055 | 12161 | 206 |
1929538 | 1929538 | 2021-11-18 | Kershaw | South Carolina | 45055 | 12150 | 205 |
1926288 | 1926288 | 2021-11-17 | Kershaw | South Carolina | 45055 | 12137 | 205 |
1923038 | 1923038 | 2021-11-16 | Kershaw | South Carolina | 45055 | 12131 | 205 |
1919789 | 1919789 | 2021-11-15 | Kershaw | South Carolina | 45055 | 12124 | 205 |
1916539 | 1916539 | 2021-11-14 | Kershaw | South Carolina | 45055 | 12102 | 205 |
1913289 | 1913289 | 2021-11-13 | Kershaw | South Carolina | 45055 | 12102 | 205 |
1910039 | 1910039 | 2021-11-12 | Kershaw | South Carolina | 45055 | 12102 | 205 |
1906790 | 1906790 | 2021-11-11 | Kershaw | South Carolina | 45055 | 12086 | 203 |
1903541 | 1903541 | 2021-11-10 | Kershaw | South Carolina | 45055 | 12086 | 203 |
1900291 | 1900291 | 2021-11-09 | Kershaw | South Carolina | 45055 | 12078 | 203 |
1897041 | 1897041 | 2021-11-08 | Kershaw | South Carolina | 45055 | 12076 | 203 |
1893791 | 1893791 | 2021-11-07 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1890541 | 1890541 | 2021-11-06 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1887291 | 1887291 | 2021-11-05 | Kershaw | South Carolina | 45055 | 12047 | 203 |
1884041 | 1884041 | 2021-11-04 | Kershaw | South Carolina | 45055 | 12033 | 203 |
1880792 | 1880792 | 2021-11-03 | Kershaw | South Carolina | 45055 | 12019 | 202 |
1877543 | 1877543 | 2021-11-02 | Kershaw | South Carolina | 45055 | 12013 | 202 |
1874294 | 1874294 | 2021-11-01 | Kershaw | South Carolina | 45055 | 12006 | 202 |
1871045 | 1871045 | 2021-10-31 | Kershaw | South Carolina | 45055 | 11978 | 202 |
1867796 | 1867796 | 2021-10-30 | Kershaw | South Carolina | 45055 | 11978 | 202 |
1864547 | 1864547 | 2021-10-29 | Kershaw | South Carolina | 45055 | 11978 | 202 |
1861298 | 1861298 | 2021-10-28 | Kershaw | South Carolina | 45055 | 11961 | 201 |
1858049 | 1858049 | 2021-10-27 | Kershaw | South Carolina | 45055 | 11950 | 200 |
1854800 | 1854800 | 2021-10-26 | Kershaw | South Carolina | 45055 | 11937 | 200 |
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);