ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Berkeley" 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 |
---|---|---|---|---|---|---|---|
2339232 | 2339232 | 2022-03-24 | Berkeley | South Carolina | 45015 | 51629 | 440 |
2335978 | 2335978 | 2022-03-23 | Berkeley | South Carolina | 45015 | 51629 | 440 |
2332724 | 2332724 | 2022-03-22 | Berkeley | South Carolina | 45015 | 51629 | 440 |
2329471 | 2329471 | 2022-03-21 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2326219 | 2326219 | 2022-03-20 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2322966 | 2322966 | 2022-03-19 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2319712 | 2319712 | 2022-03-18 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2316458 | 2316458 | 2022-03-17 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2313205 | 2313205 | 2022-03-16 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2309952 | 2309952 | 2022-03-15 | Berkeley | South Carolina | 45015 | 51585 | 437 |
2306699 | 2306699 | 2022-03-14 | Berkeley | South Carolina | 45015 | 51560 | 438 |
2303448 | 2303448 | 2022-03-13 | Berkeley | South Carolina | 45015 | 51560 | 438 |
2300196 | 2300196 | 2022-03-12 | Berkeley | South Carolina | 45015 | 51560 | 438 |
2296944 | 2296944 | 2022-03-11 | Berkeley | South Carolina | 45015 | 51560 | 438 |
2293692 | 2293692 | 2022-03-10 | Berkeley | South Carolina | 45015 | 51530 | 437 |
2290440 | 2290440 | 2022-03-09 | Berkeley | South Carolina | 45015 | 51512 | 432 |
2287188 | 2287188 | 2022-03-08 | Berkeley | South Carolina | 45015 | 51499 | 432 |
2283936 | 2283936 | 2022-03-07 | Berkeley | South Carolina | 45015 | 51496 | 431 |
2280684 | 2280684 | 2022-03-06 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2277431 | 2277431 | 2022-03-05 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2274178 | 2274178 | 2022-03-04 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2270925 | 2270925 | 2022-03-03 | Berkeley | South Carolina | 45015 | 51450 | 426 |
2267673 | 2267673 | 2022-03-02 | Berkeley | South Carolina | 45015 | 51436 | 426 |
2264420 | 2264420 | 2022-03-01 | Berkeley | South Carolina | 45015 | 51430 | 424 |
2261170 | 2261170 | 2022-02-28 | Berkeley | South Carolina | 45015 | 51425 | 419 |
2257919 | 2257919 | 2022-02-27 | Berkeley | South Carolina | 45015 | 51321 | 418 |
2254668 | 2254668 | 2022-02-26 | Berkeley | South Carolina | 45015 | 51321 | 418 |
2251417 | 2251417 | 2022-02-25 | Berkeley | South Carolina | 45015 | 51321 | 418 |
2248166 | 2248166 | 2022-02-24 | Berkeley | South Carolina | 45015 | 51275 | 417 |
2244915 | 2244915 | 2022-02-23 | Berkeley | South Carolina | 45015 | 51252 | 416 |
2241664 | 2241664 | 2022-02-22 | Berkeley | South Carolina | 45015 | 51213 | 416 |
2238413 | 2238413 | 2022-02-21 | Berkeley | South Carolina | 45015 | 51062 | 415 |
2235162 | 2235162 | 2022-02-20 | Berkeley | South Carolina | 45015 | 51062 | 415 |
2231911 | 2231911 | 2022-02-19 | Berkeley | South Carolina | 45015 | 51062 | 415 |
2228660 | 2228660 | 2022-02-18 | Berkeley | South Carolina | 45015 | 51062 | 415 |
2225409 | 2225409 | 2022-02-17 | Berkeley | South Carolina | 45015 | 50990 | 416 |
2222158 | 2222158 | 2022-02-16 | Berkeley | South Carolina | 45015 | 50891 | 412 |
2218907 | 2218907 | 2022-02-15 | Berkeley | South Carolina | 45015 | 50828 | 408 |
2215656 | 2215656 | 2022-02-14 | Berkeley | South Carolina | 45015 | 50785 | 408 |
2212405 | 2212405 | 2022-02-13 | Berkeley | South Carolina | 45015 | 50385 | 405 |
2209152 | 2209152 | 2022-02-12 | Berkeley | South Carolina | 45015 | 50385 | 405 |
2205899 | 2205899 | 2022-02-11 | Berkeley | South Carolina | 45015 | 50385 | 405 |
2202646 | 2202646 | 2022-02-10 | Berkeley | South Carolina | 45015 | 50385 | 405 |
2199392 | 2199392 | 2022-02-09 | Berkeley | South Carolina | 45015 | 50266 | 402 |
2196138 | 2196138 | 2022-02-08 | Berkeley | South Carolina | 45015 | 50129 | 402 |
2192884 | 2192884 | 2022-02-07 | Berkeley | South Carolina | 45015 | 50060 | 401 |
2189630 | 2189630 | 2022-02-06 | Berkeley | South Carolina | 45015 | 49513 | 400 |
2186377 | 2186377 | 2022-02-05 | Berkeley | South Carolina | 45015 | 49513 | 400 |
2183125 | 2183125 | 2022-02-04 | Berkeley | South Carolina | 45015 | 49513 | 400 |
2179873 | 2179873 | 2022-02-03 | Berkeley | South Carolina | 45015 | 49277 | 399 |
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 |
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);