ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where "date" is on date 2022-03-10 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Abbeville 1
- Aiken 1
- Allendale 1
- Anderson 1
- Bamberg 1
- Barnwell 1
- Beaufort 1
- Berkeley 1
- Calhoun 1
- Charleston 1
- Cherokee 1
- Chester 1
- Chesterfield 1
- Clarendon 1
- Colleton 1
- Darlington 1
- Dillon 1
- Dorchester 1
- Edgefield 1
- Fairfield 1
- Florence 1
- Georgetown 1
- Greenville 1
- Greenwood 1
- Hampton 1
- Horry 1
- Jasper 1
- Kershaw 1
- Lancaster 1
- Laurens 1
- …
state 1
- South Carolina · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2293685 | 2293685 | 2022-03-10 | Abbeville | South Carolina | 45001 | 6620 | 69 |
2293686 | 2293686 | 2022-03-10 | Aiken | South Carolina | 45003 | 41220 | 434 |
2293687 | 2293687 | 2022-03-10 | Allendale | South Carolina | 45005 | 2074 | 24 |
2293688 | 2293688 | 2022-03-10 | Anderson | South Carolina | 45007 | 57601 | 965 |
2293689 | 2293689 | 2022-03-10 | Bamberg | South Carolina | 45009 | 3406 | 74 |
2293690 | 2293690 | 2022-03-10 | Barnwell | South Carolina | 45011 | 5799 | 99 |
2293691 | 2293691 | 2022-03-10 | Beaufort | South Carolina | 45013 | 42858 | 371 |
2293692 | 2293692 | 2022-03-10 | Berkeley | South Carolina | 45015 | 51530 | 437 |
2293693 | 2293693 | 2022-03-10 | Calhoun | South Carolina | 45017 | 2772 | 61 |
2293694 | 2293694 | 2022-03-10 | Charleston | South Carolina | 45019 | 111163 | 911 |
2293695 | 2293695 | 2022-03-10 | Cherokee | South Carolina | 45021 | 14505 | 311 |
2293696 | 2293696 | 2022-03-10 | Chester | South Carolina | 45023 | 10082 | 142 |
2293697 | 2293697 | 2022-03-10 | Chesterfield | South Carolina | 45025 | 11750 | 185 |
2293698 | 2293698 | 2022-03-10 | Clarendon | South Carolina | 45027 | 8694 | 157 |
2293699 | 2293699 | 2022-03-10 | Colleton | South Carolina | 45029 | 8816 | 217 |
2293700 | 2293700 | 2022-03-10 | Darlington | South Carolina | 45031 | 18855 | 302 |
2293701 | 2293701 | 2022-03-10 | Dillon | South Carolina | 45033 | 9687 | 141 |
2293702 | 2293702 | 2022-03-10 | Dorchester | South Carolina | 45035 | 55722 | 483 |
2293703 | 2293703 | 2022-03-10 | Edgefield | South Carolina | 45037 | 6720 | 68 |
2293704 | 2293704 | 2022-03-10 | Fairfield | South Carolina | 45039 | 5966 | 104 |
2293705 | 2293705 | 2022-03-10 | Florence | South Carolina | 45041 | 41626 | 620 |
2293706 | 2293706 | 2022-03-10 | Georgetown | South Carolina | 45043 | 15773 | 221 |
2293707 | 2293707 | 2022-03-10 | Greenville | South Carolina | 45045 | 171545 | 1940 |
2293708 | 2293708 | 2022-03-10 | Greenwood | South Carolina | 45047 | 22454 | 296 |
2293709 | 2293709 | 2022-03-10 | Hampton | South Carolina | 45049 | 4996 | 83 |
2293710 | 2293710 | 2022-03-10 | Horry | South Carolina | 45051 | 95947 | 1128 |
2293711 | 2293711 | 2022-03-10 | Jasper | South Carolina | 45053 | 5881 | 93 |
2293712 | 2293712 | 2022-03-10 | Kershaw | South Carolina | 45055 | 21358 | 249 |
2293713 | 2293713 | 2022-03-10 | Lancaster | South Carolina | 45057 | 24979 | 275 |
2293714 | 2293714 | 2022-03-10 | Laurens | South Carolina | 45059 | 18548 | 289 |
2293715 | 2293715 | 2022-03-10 | Lee | South Carolina | 45061 | 4233 | 93 |
2293716 | 2293716 | 2022-03-10 | Lexington | South Carolina | 45063 | 95377 | 848 |
2293717 | 2293717 | 2022-03-10 | Marion | South Carolina | 45067 | 8514 | 160 |
2293718 | 2293718 | 2022-03-10 | Marlboro | South Carolina | 45069 | 7840 | 104 |
2293719 | 2293719 | 2022-03-10 | McCormick | South Carolina | 45065 | 2219 | 38 |
2293720 | 2293720 | 2022-03-10 | Newberry | South Carolina | 45071 | 13238 | 185 |
2293721 | 2293721 | 2022-03-10 | Oconee | South Carolina | 45073 | 24094 | 332 |
2293722 | 2293722 | 2022-03-10 | Orangeburg | South Carolina | 45075 | 23242 | 410 |
2293723 | 2293723 | 2022-03-10 | Pickens | South Carolina | 45077 | 45669 | 606 |
2293724 | 2293724 | 2022-03-10 | Richland | South Carolina | 45079 | 121931 | 920 |
2293725 | 2293725 | 2022-03-10 | Saluda | South Carolina | 45081 | 3947 | 74 |
2293726 | 2293726 | 2022-03-10 | Spartanburg | South Carolina | 45083 | 94170 | 1520 |
2293727 | 2293727 | 2022-03-10 | Sumter | South Carolina | 45085 | 27718 | 382 |
2293728 | 2293728 | 2022-03-10 | Union | South Carolina | 45087 | 7627 | 146 |
2293729 | 2293729 | 2022-03-10 | Williamsburg | South Carolina | 45089 | 8519 | 144 |
2293730 | 2293730 | 2022-03-10 | York | South Carolina | 45091 | 77305 | 620 |
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);