ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 194 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 13
county 13
- Newberry 8
- Sumter 5
- Beaufort 3
- Kershaw 3
- Charleston 2
- Florence 2
- Anderson 1
- Dorchester 1
- Lancaster 1
- Laurens 1
- Oconee 1
- Richland 1
- Spartanburg 1
state 1
- South Carolina · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492260 | 2492260 | 2022-05-10 | Newberry | South Carolina | 45071 | 13318 | 194 |
2489002 | 2489002 | 2022-05-09 | Newberry | South Carolina | 45071 | 13318 | 194 |
2485745 | 2485745 | 2022-05-08 | Newberry | South Carolina | 45071 | 13318 | 194 |
2482487 | 2482487 | 2022-05-07 | Newberry | South Carolina | 45071 | 13318 | 194 |
2479229 | 2479229 | 2022-05-06 | Newberry | South Carolina | 45071 | 13318 | 194 |
2475971 | 2475971 | 2022-05-05 | Newberry | South Carolina | 45071 | 13318 | 194 |
2472714 | 2472714 | 2022-05-04 | Newberry | South Carolina | 45071 | 13318 | 194 |
2469458 | 2469458 | 2022-05-03 | Newberry | South Carolina | 45071 | 13318 | 194 |
1802812 | 1802812 | 2021-10-10 | Kershaw | South Carolina | 45055 | 11654 | 194 |
1799563 | 1799563 | 2021-10-09 | Kershaw | South Carolina | 45055 | 11654 | 194 |
1796314 | 1796314 | 2021-10-08 | Kershaw | South Carolina | 45055 | 11654 | 194 |
1786577 | 1786577 | 2021-10-05 | Oconee | South Carolina | 45073 | 14851 | 194 |
1767073 | 1767073 | 2021-09-29 | Laurens | South Carolina | 45059 | 10634 | 194 |
1718337 | 1718337 | 2021-09-14 | Lancaster | South Carolina | 45057 | 14201 | 194 |
1172834 | 1172834 | 2021-03-30 | Sumter | South Carolina | 45085 | 10066 | 194 |
1169587 | 1169587 | 2021-03-29 | Sumter | South Carolina | 45085 | 10059 | 194 |
1166339 | 1166339 | 2021-03-28 | Sumter | South Carolina | 45085 | 10055 | 194 |
1163091 | 1163091 | 2021-03-27 | Sumter | South Carolina | 45085 | 10050 | 194 |
1159842 | 1159842 | 2021-03-26 | Sumter | South Carolina | 45085 | 10043 | 194 |
1140324 | 1140324 | 2021-03-20 | Beaufort | South Carolina | 45013 | 16028 | 194 |
1137078 | 1137078 | 2021-03-19 | Beaufort | South Carolina | 45013 | 15996 | 194 |
1133832 | 1133832 | 2021-03-18 | Beaufort | South Carolina | 45013 | 15977 | 194 |
1114362 | 1114362 | 2021-03-12 | Dorchester | South Carolina | 45035 | 15603 | 194 |
650285 | 650285 | 2020-10-20 | Anderson | South Carolina | 45007 | 5275 | 194 |
601645 | 601645 | 2020-10-05 | Florence | South Carolina | 45041 | 5043 | 194 |
598402 | 598402 | 2020-10-04 | Florence | South Carolina | 45041 | 5032 | 194 |
566010 | 566010 | 2020-09-24 | Spartanburg | South Carolina | 45083 | 6618 | 194 |
478649 | 478649 | 2020-08-28 | Richland | South Carolina | 45079 | 10404 | 194 |
417301 | 417301 | 2020-08-09 | Charleston | South Carolina | 45019 | 12324 | 194 |
414080 | 414080 | 2020-08-08 | Charleston | South Carolina | 45019 | 12213 | 194 |
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);