ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 260 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
county 8
- Cherokee 9
- Kershaw 8
- Charleston 4
- Pickens 2
- Richland 2
- Beaufort 1
- Dorchester 1
- Lancaster 1
state 1
- South Carolina · 28 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492252 | 2492252 | 2022-05-10 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2488994 | 2488994 | 2022-05-09 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2485737 | 2485737 | 2022-05-08 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2482479 | 2482479 | 2022-05-07 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2479221 | 2479221 | 2022-05-06 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2475963 | 2475963 | 2022-05-05 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2472706 | 2472706 | 2022-05-04 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2469450 | 2469450 | 2022-05-03 | Kershaw | South Carolina | 45055 | 21550 | 260 |
2179894 | 2179894 | 2022-02-03 | Lancaster | South Carolina | 45057 | 23433 | 260 |
2020538 | 2020538 | 2021-12-16 | Cherokee | South Carolina | 45021 | 10472 | 260 |
2017287 | 2017287 | 2021-12-15 | Cherokee | South Carolina | 45021 | 10469 | 260 |
2014037 | 2014037 | 2021-12-14 | Cherokee | South Carolina | 45021 | 10460 | 260 |
2010786 | 2010786 | 2021-12-13 | Cherokee | South Carolina | 45021 | 10451 | 260 |
2007535 | 2007535 | 2021-12-12 | Cherokee | South Carolina | 45021 | 10422 | 260 |
2004284 | 2004284 | 2021-12-11 | Cherokee | South Carolina | 45021 | 10422 | 260 |
2001033 | 2001033 | 2021-12-10 | Cherokee | South Carolina | 45021 | 10422 | 260 |
1997783 | 1997783 | 2021-12-09 | Cherokee | South Carolina | 45021 | 10414 | 260 |
1994532 | 1994532 | 2021-12-08 | Cherokee | South Carolina | 45021 | 10402 | 260 |
1721563 | 1721563 | 2021-09-15 | Beaufort | South Carolina | 45013 | 25252 | 260 |
1676095 | 1676095 | 2021-09-01 | Dorchester | South Carolina | 45035 | 26497 | 260 |
1055958 | 1055958 | 2021-02-22 | Pickens | South Carolina | 45077 | 16161 | 260 |
1052712 | 1052712 | 2021-02-21 | Pickens | South Carolina | 45077 | 16131 | 260 |
640583 | 640583 | 2020-10-17 | Richland | South Carolina | 45079 | 16555 | 260 |
637337 | 637337 | 2020-10-16 | Richland | South Carolina | 45079 | 16476 | 260 |
578946 | 578946 | 2020-09-28 | Charleston | South Carolina | 45019 | 15865 | 260 |
575705 | 575705 | 2020-09-27 | Charleston | South Carolina | 45019 | 15817 | 260 |
572461 | 572461 | 2020-09-26 | Charleston | South Carolina | 45019 | 15780 | 260 |
569219 | 569219 | 2020-09-25 | Charleston | South Carolina | 45019 | 15728 | 260 |
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);