ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 45035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176632 | 2176632 | 2022-02-02 | Dorchester | South Carolina | 45035 | 53334 | 430 |
2173378 | 2173378 | 2022-02-01 | Dorchester | South Carolina | 45035 | 53157 | 423 |
2170126 | 2170126 | 2022-01-31 | Dorchester | South Carolina | 45035 | 52995 | 423 |
2166872 | 2166872 | 2022-01-30 | Dorchester | South Carolina | 45035 | 52125 | 414 |
2163617 | 2163617 | 2022-01-29 | Dorchester | South Carolina | 45035 | 52125 | 414 |
2160362 | 2160362 | 2022-01-28 | Dorchester | South Carolina | 45035 | 52125 | 414 |
2157106 | 2157106 | 2022-01-27 | Dorchester | South Carolina | 45035 | 51454 | 408 |
2153853 | 2153853 | 2022-01-26 | Dorchester | South Carolina | 45035 | 51069 | 407 |
2150601 | 2150601 | 2022-01-25 | Dorchester | South Carolina | 45035 | 48635 | 406 |
2147349 | 2147349 | 2022-01-24 | Dorchester | South Carolina | 45035 | 48635 | 406 |
2144095 | 2144095 | 2022-01-23 | Dorchester | South Carolina | 45035 | 48635 | 406 |
2140840 | 2140840 | 2022-01-22 | Dorchester | South Carolina | 45035 | 48635 | 406 |
2137584 | 2137584 | 2022-01-21 | Dorchester | South Carolina | 45035 | 48635 | 406 |
2134330 | 2134330 | 2022-01-20 | Dorchester | South Carolina | 45035 | 47584 | 403 |
2131078 | 2131078 | 2022-01-19 | Dorchester | South Carolina | 45035 | 47103 | 402 |
2127824 | 2127824 | 2022-01-18 | Dorchester | South Carolina | 45035 | 46714 | 402 |
2124572 | 2124572 | 2022-01-17 | Dorchester | South Carolina | 45035 | 44121 | 398 |
2121320 | 2121320 | 2022-01-16 | Dorchester | South Carolina | 45035 | 44121 | 398 |
2118068 | 2118068 | 2022-01-15 | Dorchester | South Carolina | 45035 | 44121 | 398 |
2114817 | 2114817 | 2022-01-14 | Dorchester | South Carolina | 45035 | 44121 | 398 |
2111565 | 2111565 | 2022-01-13 | Dorchester | South Carolina | 45035 | 43212 | 398 |
2108313 | 2108313 | 2022-01-12 | Dorchester | South Carolina | 45035 | 42604 | 399 |
2105062 | 2105062 | 2022-01-11 | Dorchester | South Carolina | 45035 | 42136 | 399 |
2101811 | 2101811 | 2022-01-10 | Dorchester | South Carolina | 45035 | 41733 | 399 |
2098560 | 2098560 | 2022-01-09 | Dorchester | South Carolina | 45035 | 39701 | 397 |
2095308 | 2095308 | 2022-01-08 | Dorchester | South Carolina | 45035 | 39701 | 397 |
2092056 | 2092056 | 2022-01-07 | Dorchester | South Carolina | 45035 | 39701 | 397 |
2088804 | 2088804 | 2022-01-06 | Dorchester | South Carolina | 45035 | 39180 | 397 |
2085553 | 2085553 | 2022-01-05 | Dorchester | South Carolina | 45035 | 38445 | 396 |
2082301 | 2082301 | 2022-01-04 | Dorchester | South Carolina | 45035 | 38103 | 395 |
2079049 | 2079049 | 2022-01-03 | Dorchester | South Carolina | 45035 | 36561 | 395 |
2075798 | 2075798 | 2022-01-02 | Dorchester | South Carolina | 45035 | 36561 | 395 |
2072547 | 2072547 | 2022-01-01 | Dorchester | South Carolina | 45035 | 36561 | 395 |
2069296 | 2069296 | 2021-12-31 | Dorchester | South Carolina | 45035 | 36561 | 395 |
2066045 | 2066045 | 2021-12-30 | Dorchester | South Carolina | 45035 | 36254 | 395 |
2062795 | 2062795 | 2021-12-29 | Dorchester | South Carolina | 45035 | 35959 | 395 |
2059545 | 2059545 | 2021-12-28 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2056296 | 2056296 | 2021-12-27 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2053047 | 2053047 | 2021-12-26 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2049797 | 2049797 | 2021-12-25 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2046547 | 2046547 | 2021-12-24 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2043297 | 2043297 | 2021-12-23 | Dorchester | South Carolina | 45035 | 35298 | 394 |
2040048 | 2040048 | 2021-12-22 | Dorchester | South Carolina | 45035 | 35212 | 394 |
2036798 | 2036798 | 2021-12-21 | Dorchester | South Carolina | 45035 | 35161 | 394 |
2033548 | 2033548 | 2021-12-20 | Dorchester | South Carolina | 45035 | 35139 | 393 |
2030298 | 2030298 | 2021-12-19 | Dorchester | South Carolina | 45035 | 34980 | 393 |
2027047 | 2027047 | 2021-12-18 | Dorchester | South Carolina | 45035 | 34980 | 393 |
2023796 | 2023796 | 2021-12-17 | Dorchester | South Carolina | 45035 | 34980 | 393 |
2020545 | 2020545 | 2021-12-16 | Dorchester | South Carolina | 45035 | 34945 | 393 |
2017294 | 2017294 | 2021-12-15 | Dorchester | South Carolina | 45035 | 34903 | 393 |
2014044 | 2014044 | 2021-12-14 | Dorchester | South Carolina | 45035 | 34873 | 393 |
2010793 | 2010793 | 2021-12-13 | Dorchester | South Carolina | 45035 | 34850 | 393 |
2007542 | 2007542 | 2021-12-12 | Dorchester | South Carolina | 45035 | 34752 | 391 |
2004291 | 2004291 | 2021-12-11 | Dorchester | South Carolina | 45035 | 34752 | 391 |
2001040 | 2001040 | 2021-12-10 | Dorchester | South Carolina | 45035 | 34752 | 391 |
1997790 | 1997790 | 2021-12-09 | Dorchester | South Carolina | 45035 | 34691 | 390 |
1994539 | 1994539 | 2021-12-08 | Dorchester | South Carolina | 45035 | 34649 | 390 |
1991288 | 1991288 | 2021-12-07 | Dorchester | South Carolina | 45035 | 34636 | 390 |
1988037 | 1988037 | 2021-12-06 | Dorchester | South Carolina | 45035 | 34605 | 390 |
1984787 | 1984787 | 2021-12-05 | Dorchester | South Carolina | 45035 | 34492 | 389 |
1981537 | 1981537 | 2021-12-04 | Dorchester | South Carolina | 45035 | 34492 | 389 |
1978287 | 1978287 | 2021-12-03 | Dorchester | South Carolina | 45035 | 34492 | 389 |
1975037 | 1975037 | 2021-12-02 | Dorchester | South Carolina | 45035 | 34448 | 389 |
1971788 | 1971788 | 2021-12-01 | Dorchester | South Carolina | 45035 | 34406 | 389 |
1968538 | 1968538 | 2021-11-30 | Dorchester | South Carolina | 45035 | 34379 | 388 |
1965287 | 1965287 | 2021-11-29 | Dorchester | South Carolina | 45035 | 34358 | 388 |
1962035 | 1962035 | 2021-11-28 | Dorchester | South Carolina | 45035 | 34326 | 388 |
1958784 | 1958784 | 2021-11-27 | Dorchester | South Carolina | 45035 | 34326 | 388 |
1955533 | 1955533 | 2021-11-26 | Dorchester | South Carolina | 45035 | 34326 | 388 |
1952282 | 1952282 | 2021-11-25 | Dorchester | South Carolina | 45035 | 34311 | 388 |
1949031 | 1949031 | 2021-11-24 | Dorchester | South Carolina | 45035 | 34311 | 388 |
1945780 | 1945780 | 2021-11-23 | Dorchester | South Carolina | 45035 | 34297 | 387 |
1942529 | 1942529 | 2021-11-22 | Dorchester | South Carolina | 45035 | 34282 | 386 |
1939279 | 1939279 | 2021-11-21 | Dorchester | South Carolina | 45035 | 34224 | 385 |
1936029 | 1936029 | 2021-11-20 | Dorchester | South Carolina | 45035 | 34224 | 385 |
1932779 | 1932779 | 2021-11-19 | Dorchester | South Carolina | 45035 | 34224 | 385 |
1929528 | 1929528 | 2021-11-18 | Dorchester | South Carolina | 45035 | 34209 | 385 |
1926278 | 1926278 | 2021-11-17 | Dorchester | South Carolina | 45035 | 34187 | 385 |
1923028 | 1923028 | 2021-11-16 | Dorchester | South Carolina | 45035 | 34168 | 385 |
1919779 | 1919779 | 2021-11-15 | Dorchester | South Carolina | 45035 | 34156 | 384 |
1916529 | 1916529 | 2021-11-14 | Dorchester | South Carolina | 45035 | 34115 | 383 |
1913279 | 1913279 | 2021-11-13 | Dorchester | South Carolina | 45035 | 34115 | 383 |
1910029 | 1910029 | 2021-11-12 | Dorchester | South Carolina | 45035 | 34115 | 383 |
1906780 | 1906780 | 2021-11-11 | Dorchester | South Carolina | 45035 | 34046 | 382 |
1903531 | 1903531 | 2021-11-10 | Dorchester | South Carolina | 45035 | 34046 | 382 |
1900281 | 1900281 | 2021-11-09 | Dorchester | South Carolina | 45035 | 34040 | 382 |
1897031 | 1897031 | 2021-11-08 | Dorchester | South Carolina | 45035 | 34031 | 382 |
1893781 | 1893781 | 2021-11-07 | Dorchester | South Carolina | 45035 | 33989 | 382 |
1890531 | 1890531 | 2021-11-06 | Dorchester | South Carolina | 45035 | 33989 | 382 |
1887281 | 1887281 | 2021-11-05 | Dorchester | South Carolina | 45035 | 33989 | 382 |
1884031 | 1884031 | 2021-11-04 | Dorchester | South Carolina | 45035 | 33963 | 382 |
1880782 | 1880782 | 2021-11-03 | Dorchester | South Carolina | 45035 | 33941 | 382 |
1877533 | 1877533 | 2021-11-02 | Dorchester | South Carolina | 45035 | 33925 | 382 |
1874284 | 1874284 | 2021-11-01 | Dorchester | South Carolina | 45035 | 33915 | 381 |
1871035 | 1871035 | 2021-10-31 | Dorchester | South Carolina | 45035 | 33841 | 380 |
1867786 | 1867786 | 2021-10-30 | Dorchester | South Carolina | 45035 | 33841 | 380 |
1864537 | 1864537 | 2021-10-29 | Dorchester | South Carolina | 45035 | 33841 | 380 |
1861288 | 1861288 | 2021-10-28 | Dorchester | South Carolina | 45035 | 33791 | 377 |
1858039 | 1858039 | 2021-10-27 | Dorchester | South Carolina | 45035 | 33766 | 377 |
1854790 | 1854790 | 2021-10-26 | Dorchester | South Carolina | 45035 | 33733 | 376 |
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);