ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Spartanburg" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176656 | 2176656 | 2022-02-02 | Spartanburg | South Carolina | 45083 | 90272 | 1359 |
2173402 | 2173402 | 2022-02-01 | Spartanburg | South Carolina | 45083 | 89954 | 1359 |
2170150 | 2170150 | 2022-01-31 | Spartanburg | South Carolina | 45083 | 89781 | 1354 |
2166896 | 2166896 | 2022-01-30 | Spartanburg | South Carolina | 45083 | 88610 | 1331 |
2163641 | 2163641 | 2022-01-29 | Spartanburg | South Carolina | 45083 | 88610 | 1331 |
2160386 | 2160386 | 2022-01-28 | Spartanburg | South Carolina | 45083 | 88610 | 1331 |
2157130 | 2157130 | 2022-01-27 | Spartanburg | South Carolina | 45083 | 87762 | 1326 |
2153877 | 2153877 | 2022-01-26 | Spartanburg | South Carolina | 45083 | 87180 | 1324 |
2150625 | 2150625 | 2022-01-25 | Spartanburg | South Carolina | 45083 | 83102 | 1325 |
2147373 | 2147373 | 2022-01-24 | Spartanburg | South Carolina | 45083 | 83102 | 1325 |
2144119 | 2144119 | 2022-01-23 | Spartanburg | South Carolina | 45083 | 83102 | 1325 |
2140864 | 2140864 | 2022-01-22 | Spartanburg | South Carolina | 45083 | 83102 | 1325 |
2137608 | 2137608 | 2022-01-21 | Spartanburg | South Carolina | 45083 | 83102 | 1325 |
2134354 | 2134354 | 2022-01-20 | Spartanburg | South Carolina | 45083 | 82277 | 1321 |
2131102 | 2131102 | 2022-01-19 | Spartanburg | South Carolina | 45083 | 81810 | 1321 |
2127848 | 2127848 | 2022-01-18 | Spartanburg | South Carolina | 45083 | 80708 | 1321 |
2124596 | 2124596 | 2022-01-17 | Spartanburg | South Carolina | 45083 | 76206 | 1312 |
2121344 | 2121344 | 2022-01-16 | Spartanburg | South Carolina | 45083 | 76206 | 1312 |
2118092 | 2118092 | 2022-01-15 | Spartanburg | South Carolina | 45083 | 76206 | 1312 |
2114841 | 2114841 | 2022-01-14 | Spartanburg | South Carolina | 45083 | 76206 | 1312 |
2111589 | 2111589 | 2022-01-13 | Spartanburg | South Carolina | 45083 | 74877 | 1306 |
2108337 | 2108337 | 2022-01-12 | Spartanburg | South Carolina | 45083 | 73622 | 1302 |
2105086 | 2105086 | 2022-01-11 | Spartanburg | South Carolina | 45083 | 72378 | 1297 |
2101835 | 2101835 | 2022-01-10 | Spartanburg | South Carolina | 45083 | 72040 | 1297 |
2098584 | 2098584 | 2022-01-09 | Spartanburg | South Carolina | 45083 | 69488 | 1293 |
2095332 | 2095332 | 2022-01-08 | Spartanburg | South Carolina | 45083 | 69488 | 1293 |
2092080 | 2092080 | 2022-01-07 | Spartanburg | South Carolina | 45083 | 69488 | 1293 |
2088828 | 2088828 | 2022-01-06 | Spartanburg | South Carolina | 45083 | 68878 | 1293 |
2085577 | 2085577 | 2022-01-05 | Spartanburg | South Carolina | 45083 | 67989 | 1286 |
2082325 | 2082325 | 2022-01-04 | Spartanburg | South Carolina | 45083 | 67639 | 1283 |
2079073 | 2079073 | 2022-01-03 | Spartanburg | South Carolina | 45083 | 65984 | 1281 |
2075822 | 2075822 | 2022-01-02 | Spartanburg | South Carolina | 45083 | 65984 | 1281 |
2072571 | 2072571 | 2022-01-01 | Spartanburg | South Carolina | 45083 | 65984 | 1281 |
2069320 | 2069320 | 2021-12-31 | Spartanburg | South Carolina | 45083 | 65984 | 1281 |
2066069 | 2066069 | 2021-12-30 | Spartanburg | South Carolina | 45083 | 65641 | 1280 |
2062819 | 2062819 | 2021-12-29 | Spartanburg | South Carolina | 45083 | 65385 | 1280 |
2059569 | 2059569 | 2021-12-28 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2056320 | 2056320 | 2021-12-27 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2053071 | 2053071 | 2021-12-26 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2049821 | 2049821 | 2021-12-25 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2046571 | 2046571 | 2021-12-24 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2043321 | 2043321 | 2021-12-23 | Spartanburg | South Carolina | 45083 | 64630 | 1273 |
2040072 | 2040072 | 2021-12-22 | Spartanburg | South Carolina | 45083 | 64527 | 1268 |
2036822 | 2036822 | 2021-12-21 | Spartanburg | South Carolina | 45083 | 64469 | 1264 |
2033572 | 2033572 | 2021-12-20 | Spartanburg | South Carolina | 45083 | 64422 | 1263 |
2030322 | 2030322 | 2021-12-19 | Spartanburg | South Carolina | 45083 | 64193 | 1259 |
2027071 | 2027071 | 2021-12-18 | Spartanburg | South Carolina | 45083 | 64193 | 1259 |
2023820 | 2023820 | 2021-12-17 | Spartanburg | South Carolina | 45083 | 64193 | 1259 |
2020569 | 2020569 | 2021-12-16 | Spartanburg | South Carolina | 45083 | 64132 | 1258 |
2017318 | 2017318 | 2021-12-15 | Spartanburg | South Carolina | 45083 | 64070 | 1256 |
2014068 | 2014068 | 2021-12-14 | Spartanburg | South Carolina | 45083 | 64012 | 1255 |
2010817 | 2010817 | 2021-12-13 | Spartanburg | South Carolina | 45083 | 63979 | 1255 |
2007566 | 2007566 | 2021-12-12 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
2004315 | 2004315 | 2021-12-11 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
2001064 | 2001064 | 2021-12-10 | Spartanburg | South Carolina | 45083 | 63807 | 1254 |
1997814 | 1997814 | 2021-12-09 | Spartanburg | South Carolina | 45083 | 63752 | 1252 |
1994563 | 1994563 | 2021-12-08 | Spartanburg | South Carolina | 45083 | 63670 | 1252 |
1991312 | 1991312 | 2021-12-07 | Spartanburg | South Carolina | 45083 | 63610 | 1250 |
1988061 | 1988061 | 2021-12-06 | Spartanburg | South Carolina | 45083 | 63570 | 1250 |
1984811 | 1984811 | 2021-12-05 | Spartanburg | South Carolina | 45083 | 63407 | 1245 |
1981561 | 1981561 | 2021-12-04 | Spartanburg | South Carolina | 45083 | 63407 | 1245 |
1978311 | 1978311 | 2021-12-03 | Spartanburg | South Carolina | 45083 | 63407 | 1245 |
1975061 | 1975061 | 2021-12-02 | Spartanburg | South Carolina | 45083 | 63308 | 1245 |
1971812 | 1971812 | 2021-12-01 | Spartanburg | South Carolina | 45083 | 63263 | 1236 |
1968562 | 1968562 | 2021-11-30 | Spartanburg | South Carolina | 45083 | 63178 | 1234 |
1965311 | 1965311 | 2021-11-29 | Spartanburg | South Carolina | 45083 | 63146 | 1234 |
1962059 | 1962059 | 2021-11-28 | Spartanburg | South Carolina | 45083 | 63001 | 1232 |
1958808 | 1958808 | 2021-11-27 | Spartanburg | South Carolina | 45083 | 63001 | 1232 |
1955557 | 1955557 | 2021-11-26 | Spartanburg | South Carolina | 45083 | 63001 | 1232 |
1952306 | 1952306 | 2021-11-25 | Spartanburg | South Carolina | 45083 | 62952 | 1229 |
1949055 | 1949055 | 2021-11-24 | Spartanburg | South Carolina | 45083 | 62952 | 1229 |
1945804 | 1945804 | 2021-11-23 | Spartanburg | South Carolina | 45083 | 62916 | 1229 |
1942553 | 1942553 | 2021-11-22 | Spartanburg | South Carolina | 45083 | 62880 | 1229 |
1939303 | 1939303 | 2021-11-21 | Spartanburg | South Carolina | 45083 | 62731 | 1229 |
1936053 | 1936053 | 2021-11-20 | Spartanburg | South Carolina | 45083 | 62731 | 1229 |
1932803 | 1932803 | 2021-11-19 | Spartanburg | South Carolina | 45083 | 62731 | 1229 |
1929552 | 1929552 | 2021-11-18 | Spartanburg | South Carolina | 45083 | 62667 | 1229 |
1926302 | 1926302 | 2021-11-17 | Spartanburg | South Carolina | 45083 | 62623 | 1228 |
1923052 | 1923052 | 2021-11-16 | Spartanburg | South Carolina | 45083 | 62587 | 1225 |
1919803 | 1919803 | 2021-11-15 | Spartanburg | South Carolina | 45083 | 62557 | 1224 |
1916553 | 1916553 | 2021-11-14 | Spartanburg | South Carolina | 45083 | 62433 | 1221 |
1913303 | 1913303 | 2021-11-13 | Spartanburg | South Carolina | 45083 | 62433 | 1221 |
1910053 | 1910053 | 2021-11-12 | Spartanburg | South Carolina | 45083 | 62433 | 1221 |
1906804 | 1906804 | 2021-11-11 | Spartanburg | South Carolina | 45083 | 62309 | 1215 |
1903555 | 1903555 | 2021-11-10 | Spartanburg | South Carolina | 45083 | 62309 | 1215 |
1900305 | 1900305 | 2021-11-09 | Spartanburg | South Carolina | 45083 | 62270 | 1210 |
1897055 | 1897055 | 2021-11-08 | Spartanburg | South Carolina | 45083 | 62243 | 1210 |
1893805 | 1893805 | 2021-11-07 | Spartanburg | South Carolina | 45083 | 62134 | 1201 |
1890555 | 1890555 | 2021-11-06 | Spartanburg | South Carolina | 45083 | 62134 | 1201 |
1887305 | 1887305 | 2021-11-05 | Spartanburg | South Carolina | 45083 | 62134 | 1201 |
1884055 | 1884055 | 2021-11-04 | Spartanburg | South Carolina | 45083 | 62083 | 1201 |
1880806 | 1880806 | 2021-11-03 | Spartanburg | South Carolina | 45083 | 62033 | 1194 |
1877557 | 1877557 | 2021-11-02 | Spartanburg | South Carolina | 45083 | 61999 | 1191 |
1874308 | 1874308 | 2021-11-01 | Spartanburg | South Carolina | 45083 | 61961 | 1191 |
1871059 | 1871059 | 2021-10-31 | Spartanburg | South Carolina | 45083 | 61778 | 1185 |
1867810 | 1867810 | 2021-10-30 | Spartanburg | South Carolina | 45083 | 61778 | 1185 |
1864561 | 1864561 | 2021-10-29 | Spartanburg | South Carolina | 45083 | 61778 | 1185 |
1861312 | 1861312 | 2021-10-28 | Spartanburg | South Carolina | 45083 | 61666 | 1181 |
1858063 | 1858063 | 2021-10-27 | Spartanburg | South Carolina | 45083 | 61599 | 1173 |
1854814 | 1854814 | 2021-10-26 | Spartanburg | South Carolina | 45083 | 61540 | 1170 |
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);