ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45015 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- …
state 1
- South Carolina · 685 ✖
fips 1
- 45015 · 685 ✖
county 1
- Berkeley 685
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176622 | 2176622 | 2022-02-02 | Berkeley | South Carolina | 45015 | 49085 | 396 |
2173368 | 2173368 | 2022-02-01 | Berkeley | South Carolina | 45015 | 48931 | 388 |
2170116 | 2170116 | 2022-01-31 | Berkeley | South Carolina | 45015 | 48824 | 388 |
2166862 | 2166862 | 2022-01-30 | Berkeley | South Carolina | 45015 | 47896 | 384 |
2163607 | 2163607 | 2022-01-29 | Berkeley | South Carolina | 45015 | 47896 | 384 |
2160352 | 2160352 | 2022-01-28 | Berkeley | South Carolina | 45015 | 47896 | 384 |
2157096 | 2157096 | 2022-01-27 | Berkeley | South Carolina | 45015 | 47434 | 382 |
2153843 | 2153843 | 2022-01-26 | Berkeley | South Carolina | 45015 | 46996 | 381 |
2150591 | 2150591 | 2022-01-25 | Berkeley | South Carolina | 45015 | 44696 | 376 |
2147339 | 2147339 | 2022-01-24 | Berkeley | South Carolina | 45015 | 44696 | 376 |
2144085 | 2144085 | 2022-01-23 | Berkeley | South Carolina | 45015 | 44696 | 376 |
2140830 | 2140830 | 2022-01-22 | Berkeley | South Carolina | 45015 | 44696 | 376 |
2137574 | 2137574 | 2022-01-21 | Berkeley | South Carolina | 45015 | 44696 | 376 |
2134320 | 2134320 | 2022-01-20 | Berkeley | South Carolina | 45015 | 44084 | 376 |
2131068 | 2131068 | 2022-01-19 | Berkeley | South Carolina | 45015 | 43302 | 374 |
2127814 | 2127814 | 2022-01-18 | Berkeley | South Carolina | 45015 | 42649 | 374 |
2124562 | 2124562 | 2022-01-17 | Berkeley | South Carolina | 45015 | 40079 | 372 |
2121310 | 2121310 | 2022-01-16 | Berkeley | South Carolina | 45015 | 40079 | 372 |
2118058 | 2118058 | 2022-01-15 | Berkeley | South Carolina | 45015 | 40079 | 372 |
2114807 | 2114807 | 2022-01-14 | Berkeley | South Carolina | 45015 | 40079 | 372 |
2111555 | 2111555 | 2022-01-13 | Berkeley | South Carolina | 45015 | 39372 | 371 |
2108303 | 2108303 | 2022-01-12 | Berkeley | South Carolina | 45015 | 38770 | 369 |
2105052 | 2105052 | 2022-01-11 | Berkeley | South Carolina | 45015 | 38162 | 368 |
2101801 | 2101801 | 2022-01-10 | Berkeley | South Carolina | 45015 | 37864 | 368 |
2098550 | 2098550 | 2022-01-09 | Berkeley | South Carolina | 45015 | 35955 | 365 |
2095298 | 2095298 | 2022-01-08 | Berkeley | South Carolina | 45015 | 35955 | 365 |
2092046 | 2092046 | 2022-01-07 | Berkeley | South Carolina | 45015 | 35955 | 365 |
2088794 | 2088794 | 2022-01-06 | Berkeley | South Carolina | 45015 | 35520 | 365 |
2085543 | 2085543 | 2022-01-05 | Berkeley | South Carolina | 45015 | 34852 | 365 |
2082291 | 2082291 | 2022-01-04 | Berkeley | South Carolina | 45015 | 34590 | 365 |
2079039 | 2079039 | 2022-01-03 | Berkeley | South Carolina | 45015 | 33348 | 365 |
2075788 | 2075788 | 2022-01-02 | Berkeley | South Carolina | 45015 | 33348 | 365 |
2072537 | 2072537 | 2022-01-01 | Berkeley | South Carolina | 45015 | 33348 | 365 |
2069286 | 2069286 | 2021-12-31 | Berkeley | South Carolina | 45015 | 33348 | 365 |
2066035 | 2066035 | 2021-12-30 | Berkeley | South Carolina | 45015 | 33011 | 363 |
2062785 | 2062785 | 2021-12-29 | Berkeley | South Carolina | 45015 | 32805 | 362 |
2059535 | 2059535 | 2021-12-28 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2056286 | 2056286 | 2021-12-27 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2053037 | 2053037 | 2021-12-26 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2049787 | 2049787 | 2021-12-25 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2046537 | 2046537 | 2021-12-24 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2043287 | 2043287 | 2021-12-23 | Berkeley | South Carolina | 45015 | 32327 | 361 |
2040038 | 2040038 | 2021-12-22 | Berkeley | South Carolina | 45015 | 32267 | 361 |
2036788 | 2036788 | 2021-12-21 | Berkeley | South Carolina | 45015 | 32213 | 361 |
2033538 | 2033538 | 2021-12-20 | Berkeley | South Carolina | 45015 | 32192 | 361 |
2030288 | 2030288 | 2021-12-19 | Berkeley | South Carolina | 45015 | 32079 | 359 |
2027037 | 2027037 | 2021-12-18 | Berkeley | South Carolina | 45015 | 32079 | 359 |
2023786 | 2023786 | 2021-12-17 | Berkeley | South Carolina | 45015 | 32079 | 359 |
2020535 | 2020535 | 2021-12-16 | Berkeley | South Carolina | 45015 | 32047 | 359 |
2017284 | 2017284 | 2021-12-15 | Berkeley | South Carolina | 45015 | 32003 | 359 |
2014034 | 2014034 | 2021-12-14 | Berkeley | South Carolina | 45015 | 31973 | 358 |
2010783 | 2010783 | 2021-12-13 | Berkeley | South Carolina | 45015 | 31940 | 358 |
2007532 | 2007532 | 2021-12-12 | Berkeley | South Carolina | 45015 | 31864 | 357 |
2004281 | 2004281 | 2021-12-11 | Berkeley | South Carolina | 45015 | 31864 | 357 |
2001030 | 2001030 | 2021-12-10 | Berkeley | South Carolina | 45015 | 31864 | 357 |
1997780 | 1997780 | 2021-12-09 | Berkeley | South Carolina | 45015 | 31800 | 356 |
1994529 | 1994529 | 2021-12-08 | Berkeley | South Carolina | 45015 | 31774 | 356 |
1991278 | 1991278 | 2021-12-07 | Berkeley | South Carolina | 45015 | 31748 | 354 |
1988027 | 1988027 | 2021-12-06 | Berkeley | South Carolina | 45015 | 31729 | 354 |
1984777 | 1984777 | 2021-12-05 | Berkeley | South Carolina | 45015 | 31645 | 353 |
1981527 | 1981527 | 2021-12-04 | Berkeley | South Carolina | 45015 | 31645 | 353 |
1978277 | 1978277 | 2021-12-03 | Berkeley | South Carolina | 45015 | 31645 | 353 |
1975027 | 1975027 | 2021-12-02 | Berkeley | South Carolina | 45015 | 31622 | 353 |
1971778 | 1971778 | 2021-12-01 | Berkeley | South Carolina | 45015 | 31592 | 353 |
1968528 | 1968528 | 2021-11-30 | Berkeley | South Carolina | 45015 | 31576 | 353 |
1965277 | 1965277 | 2021-11-29 | Berkeley | South Carolina | 45015 | 31566 | 353 |
1962025 | 1962025 | 2021-11-28 | Berkeley | South Carolina | 45015 | 31535 | 353 |
1958774 | 1958774 | 2021-11-27 | Berkeley | South Carolina | 45015 | 31535 | 353 |
1955523 | 1955523 | 2021-11-26 | Berkeley | South Carolina | 45015 | 31535 | 353 |
1952272 | 1952272 | 2021-11-25 | Berkeley | South Carolina | 45015 | 31519 | 353 |
1949021 | 1949021 | 2021-11-24 | Berkeley | South Carolina | 45015 | 31519 | 353 |
1945770 | 1945770 | 2021-11-23 | Berkeley | South Carolina | 45015 | 31507 | 353 |
1942519 | 1942519 | 2021-11-22 | Berkeley | South Carolina | 45015 | 31495 | 353 |
1939269 | 1939269 | 2021-11-21 | Berkeley | South Carolina | 45015 | 31443 | 353 |
1936019 | 1936019 | 2021-11-20 | Berkeley | South Carolina | 45015 | 31443 | 353 |
1932769 | 1932769 | 2021-11-19 | Berkeley | South Carolina | 45015 | 31443 | 353 |
1929518 | 1929518 | 2021-11-18 | Berkeley | South Carolina | 45015 | 31417 | 351 |
1926268 | 1926268 | 2021-11-17 | Berkeley | South Carolina | 45015 | 31394 | 351 |
1923018 | 1923018 | 2021-11-16 | Berkeley | South Carolina | 45015 | 31367 | 350 |
1919769 | 1919769 | 2021-11-15 | Berkeley | South Carolina | 45015 | 31359 | 349 |
1916519 | 1916519 | 2021-11-14 | Berkeley | South Carolina | 45015 | 31300 | 347 |
1913269 | 1913269 | 2021-11-13 | Berkeley | South Carolina | 45015 | 31300 | 347 |
1910019 | 1910019 | 2021-11-12 | Berkeley | South Carolina | 45015 | 31300 | 347 |
1906770 | 1906770 | 2021-11-11 | Berkeley | South Carolina | 45015 | 31239 | 347 |
1903521 | 1903521 | 2021-11-10 | Berkeley | South Carolina | 45015 | 31239 | 347 |
1900271 | 1900271 | 2021-11-09 | Berkeley | South Carolina | 45015 | 31242 | 345 |
1897021 | 1897021 | 2021-11-08 | Berkeley | South Carolina | 45015 | 31228 | 345 |
1893771 | 1893771 | 2021-11-07 | Berkeley | South Carolina | 45015 | 31169 | 344 |
1890521 | 1890521 | 2021-11-06 | Berkeley | South Carolina | 45015 | 31169 | 344 |
1887271 | 1887271 | 2021-11-05 | Berkeley | South Carolina | 45015 | 31169 | 344 |
1884021 | 1884021 | 2021-11-04 | Berkeley | South Carolina | 45015 | 31136 | 344 |
1880772 | 1880772 | 2021-11-03 | Berkeley | South Carolina | 45015 | 31121 | 343 |
1877523 | 1877523 | 2021-11-02 | Berkeley | South Carolina | 45015 | 31107 | 341 |
1874274 | 1874274 | 2021-11-01 | Berkeley | South Carolina | 45015 | 31103 | 341 |
1871025 | 1871025 | 2021-10-31 | Berkeley | South Carolina | 45015 | 31042 | 341 |
1867776 | 1867776 | 2021-10-30 | Berkeley | South Carolina | 45015 | 31042 | 341 |
1864527 | 1864527 | 2021-10-29 | Berkeley | South Carolina | 45015 | 31042 | 341 |
1861278 | 1861278 | 2021-10-28 | Berkeley | South Carolina | 45015 | 31009 | 339 |
1858029 | 1858029 | 2021-10-27 | Berkeley | South Carolina | 45015 | 30996 | 338 |
1854780 | 1854780 | 2021-10-26 | Berkeley | South Carolina | 45015 | 30978 | 335 |
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);