ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 247 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
fips 12
county 12
- Laurens 12
- Lancaster 6
- Kershaw 2
- Spartanburg 2
- Aiken 1
- Anderson 1
- Charleston 1
- Lexington 1
- Oconee 1
- Orangeburg 1
- Pickens 1
- Sumter 1
state 1
- South Carolina · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287208 | 2287208 | 2022-03-08 | Kershaw | South Carolina | 45055 | 21356 | 247 |
2283956 | 2283956 | 2022-03-07 | Kershaw | South Carolina | 45055 | 21354 | 247 |
2105074 | 2105074 | 2022-01-11 | Laurens | South Carolina | 45059 | 13999 | 247 |
2101823 | 2101823 | 2022-01-10 | Laurens | South Carolina | 45059 | 13907 | 247 |
2098572 | 2098572 | 2022-01-09 | Laurens | South Carolina | 45059 | 13376 | 247 |
2095320 | 2095320 | 2022-01-08 | Laurens | South Carolina | 45059 | 13376 | 247 |
2092068 | 2092068 | 2022-01-07 | Laurens | South Carolina | 45059 | 13376 | 247 |
2088816 | 2088816 | 2022-01-06 | Laurens | South Carolina | 45059 | 13253 | 247 |
2085565 | 2085565 | 2022-01-05 | Laurens | South Carolina | 45059 | 13019 | 247 |
2082313 | 2082313 | 2022-01-04 | Laurens | South Carolina | 45059 | 12913 | 247 |
2079060 | 2079060 | 2022-01-03 | Lancaster | South Carolina | 45057 | 17632 | 247 |
2079061 | 2079061 | 2022-01-03 | Laurens | South Carolina | 45059 | 12618 | 247 |
2075809 | 2075809 | 2022-01-02 | Lancaster | South Carolina | 45057 | 17632 | 247 |
2075810 | 2075810 | 2022-01-02 | Laurens | South Carolina | 45059 | 12618 | 247 |
2072558 | 2072558 | 2022-01-01 | Lancaster | South Carolina | 45057 | 17632 | 247 |
2072559 | 2072559 | 2022-01-01 | Laurens | South Carolina | 45059 | 12618 | 247 |
2069307 | 2069307 | 2021-12-31 | Lancaster | South Carolina | 45057 | 17632 | 247 |
2069308 | 2069308 | 2021-12-31 | Laurens | South Carolina | 45059 | 12618 | 247 |
2066056 | 2066056 | 2021-12-30 | Lancaster | South Carolina | 45057 | 17531 | 247 |
2062806 | 2062806 | 2021-12-29 | Lancaster | South Carolina | 45057 | 17469 | 247 |
1991307 | 1991307 | 2021-12-07 | Oconee | South Carolina | 45073 | 16140 | 247 |
1715103 | 1715103 | 2021-09-13 | Sumter | South Carolina | 45085 | 14272 | 247 |
1669584 | 1669584 | 2021-08-30 | Aiken | South Carolina | 45003 | 22180 | 247 |
1292981 | 1292981 | 2021-05-06 | Orangeburg | South Carolina | 45075 | 9706 | 247 |
1023500 | 1023500 | 2021-02-12 | Pickens | South Carolina | 45077 | 15511 | 247 |
828767 | 828767 | 2020-12-14 | Lexington | South Carolina | 45063 | 13411 | 247 |
822246 | 822246 | 2020-12-12 | Anderson | South Carolina | 45007 | 9403 | 247 |
715196 | 715196 | 2020-11-09 | Spartanburg | South Carolina | 45083 | 10031 | 247 |
711952 | 711952 | 2020-11-08 | Spartanburg | South Carolina | 45083 | 9976 | 247 |
510954 | 510954 | 2020-09-07 | Charleston | South Carolina | 45019 | 14485 | 247 |
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);