ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where deaths = 189 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 19
county 19
- Newberry 14
- Chesterfield 9
- Greenwood 5
- Beaufort 4
- Darlington 4
- Spartanburg 4
- Anderson 3
- Berkeley 3
- Colleton 3
- Horry 3
- Orangeburg 3
- Kershaw 2
- Aiken 1
- Charleston 1
- Dorchester 1
- Georgetown 1
- Greenville 1
- Pickens 1
- York 1
state 1
- South Carolina · 64 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449900 | 2449900 | 2022-04-27 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2446643 | 2446643 | 2022-04-26 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2443388 | 2443388 | 2022-04-25 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2440132 | 2440132 | 2022-04-24 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2436876 | 2436876 | 2022-04-23 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2433620 | 2433620 | 2022-04-22 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2430364 | 2430364 | 2022-04-21 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2427108 | 2427108 | 2022-04-20 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2423852 | 2423852 | 2022-04-19 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2375043 | 2375043 | 2022-04-04 | Newberry | South Carolina | 45071 | 13257 | 189 |
2371791 | 2371791 | 2022-04-03 | Newberry | South Carolina | 45071 | 13257 | 189 |
2368538 | 2368538 | 2022-04-02 | Newberry | South Carolina | 45071 | 13257 | 189 |
2365285 | 2365285 | 2022-04-01 | Newberry | South Carolina | 45071 | 13257 | 189 |
2362032 | 2362032 | 2022-03-31 | Newberry | South Carolina | 45071 | 13257 | 189 |
2358778 | 2358778 | 2022-03-30 | Newberry | South Carolina | 45071 | 13257 | 189 |
2355524 | 2355524 | 2022-03-29 | Newberry | South Carolina | 45071 | 13257 | 189 |
2352271 | 2352271 | 2022-03-28 | Newberry | South Carolina | 45071 | 13250 | 189 |
2349019 | 2349019 | 2022-03-27 | Newberry | South Carolina | 45071 | 13250 | 189 |
2345766 | 2345766 | 2022-03-26 | Newberry | South Carolina | 45071 | 13250 | 189 |
2342513 | 2342513 | 2022-03-25 | Newberry | South Carolina | 45071 | 13250 | 189 |
2339260 | 2339260 | 2022-03-24 | Newberry | South Carolina | 45071 | 13250 | 189 |
2336006 | 2336006 | 2022-03-23 | Newberry | South Carolina | 45071 | 13250 | 189 |
2332752 | 2332752 | 2022-03-22 | Newberry | South Carolina | 45071 | 13250 | 189 |
2040052 | 2040052 | 2021-12-22 | Georgetown | South Carolina | 45043 | 10127 | 189 |
1858036 | 1858036 | 2021-10-27 | Colleton | South Carolina | 45029 | 5617 | 189 |
1854787 | 1854787 | 2021-10-26 | Colleton | South Carolina | 45029 | 5616 | 189 |
1851538 | 1851538 | 2021-10-25 | Colleton | South Carolina | 45029 | 5616 | 189 |
1770320 | 1770320 | 2021-09-30 | Kershaw | South Carolina | 45055 | 11384 | 189 |
1767071 | 1767071 | 2021-09-29 | Kershaw | South Carolina | 45055 | 11347 | 189 |
1757321 | 1757321 | 2021-09-26 | Greenwood | South Carolina | 45047 | 11006 | 189 |
1754073 | 1754073 | 2021-09-25 | Greenwood | South Carolina | 45047 | 11006 | 189 |
1750825 | 1750825 | 2021-09-24 | Greenwood | South Carolina | 45047 | 11006 | 189 |
1747576 | 1747576 | 2021-09-23 | Greenwood | South Carolina | 45047 | 10930 | 189 |
1744326 | 1744326 | 2021-09-22 | Greenwood | South Carolina | 45047 | 10868 | 189 |
1669598 | 1669598 | 2021-08-30 | Darlington | South Carolina | 45031 | 9879 | 189 |
1666351 | 1666351 | 2021-08-29 | Darlington | South Carolina | 45031 | 9654 | 189 |
1663103 | 1663103 | 2021-08-28 | Darlington | South Carolina | 45031 | 9654 | 189 |
1659855 | 1659855 | 2021-08-27 | Darlington | South Carolina | 45031 | 9654 | 189 |
1244249 | 1244249 | 2021-04-21 | Berkeley | South Carolina | 45015 | 17006 | 189 |
1241002 | 1241002 | 2021-04-20 | Berkeley | South Carolina | 45015 | 16977 | 189 |
1237755 | 1237755 | 2021-04-19 | Berkeley | South Carolina | 45015 | 16950 | 189 |
1104613 | 1104613 | 2021-03-09 | Beaufort | South Carolina | 45013 | 15741 | 189 |
1101367 | 1101367 | 2021-03-08 | Beaufort | South Carolina | 45013 | 15728 | 189 |
1098121 | 1098121 | 2021-03-07 | Beaufort | South Carolina | 45013 | 15701 | 189 |
1094873 | 1094873 | 2021-03-06 | Beaufort | South Carolina | 45013 | 15663 | 189 |
1094884 | 1094884 | 2021-03-06 | Dorchester | South Carolina | 45035 | 15410 | 189 |
1020218 | 1020218 | 2021-02-11 | Aiken | South Carolina | 45003 | 14095 | 189 |
1000781 | 1000781 | 2021-02-05 | Orangeburg | South Carolina | 45075 | 7775 | 189 |
997535 | 997535 | 2021-02-04 | Orangeburg | South Carolina | 45075 | 7688 | 189 |
994289 | 994289 | 2021-02-03 | Orangeburg | South Carolina | 45075 | 7655 | 189 |
948853 | 948853 | 2021-01-20 | Pickens | South Carolina | 45077 | 13658 | 189 |
909916 | 909916 | 2021-01-08 | York | South Carolina | 45091 | 17305 | 189 |
634055 | 634055 | 2020-10-15 | Anderson | South Carolina | 45007 | 5111 | 189 |
630810 | 630810 | 2020-10-14 | Anderson | South Carolina | 45007 | 5076 | 189 |
627566 | 627566 | 2020-10-13 | Anderson | South Carolina | 45007 | 5045 | 189 |
556295 | 556295 | 2020-09-21 | Spartanburg | South Carolina | 45083 | 6361 | 189 |
553058 | 553058 | 2020-09-20 | Spartanburg | South Carolina | 45083 | 6354 | 189 |
549819 | 549819 | 2020-09-19 | Spartanburg | South Carolina | 45083 | 6352 | 189 |
546580 | 546580 | 2020-09-18 | Spartanburg | South Carolina | 45083 | 6312 | 189 |
517438 | 517438 | 2020-09-09 | Horry | South Carolina | 45051 | 9647 | 189 |
514203 | 514203 | 2020-09-08 | Horry | South Carolina | 45051 | 9619 | 189 |
510970 | 510970 | 2020-09-07 | Horry | South Carolina | 45051 | 9602 | 189 |
410860 | 410860 | 2020-08-07 | Charleston | South Carolina | 45019 | 12118 | 189 |
398001 | 398001 | 2020-08-03 | Greenville | South Carolina | 45045 | 10306 | 189 |
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);