ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where date = "2020-05-22" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, 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 |
---|---|---|---|---|---|---|---|
168593 | 168593 | 2020-05-22 | Abbeville | South Carolina | 45001 | 36 | 0 |
168594 | 168594 | 2020-05-22 | Aiken | South Carolina | 45003 | 166 | 7 |
168595 | 168595 | 2020-05-22 | Allendale | South Carolina | 45005 | 34 | 3 |
168596 | 168596 | 2020-05-22 | Anderson | South Carolina | 45007 | 219 | 8 |
168597 | 168597 | 2020-05-22 | Bamberg | South Carolina | 45009 | 20 | 0 |
168598 | 168598 | 2020-05-22 | Barnwell | South Carolina | 45011 | 41 | 1 |
168599 | 168599 | 2020-05-22 | Beaufort | South Carolina | 45013 | 314 | 12 |
168600 | 168600 | 2020-05-22 | Berkeley | South Carolina | 45015 | 211 | 15 |
168601 | 168601 | 2020-05-22 | Calhoun | South Carolina | 45017 | 9 | 1 |
168602 | 168602 | 2020-05-22 | Charleston | South Carolina | 45019 | 540 | 11 |
168603 | 168603 | 2020-05-22 | Cherokee | South Carolina | 45021 | 26 | 2 |
168604 | 168604 | 2020-05-22 | Chester | South Carolina | 45023 | 44 | 0 |
168605 | 168605 | 2020-05-22 | Chesterfield | South Carolina | 45025 | 118 | 1 |
168606 | 168606 | 2020-05-22 | Clarendon | South Carolina | 45027 | 289 | 36 |
168607 | 168607 | 2020-05-22 | Colleton | South Carolina | 45029 | 66 | 8 |
168608 | 168608 | 2020-05-22 | Darlington | South Carolina | 45031 | 242 | 6 |
168609 | 168609 | 2020-05-22 | Dillon | South Carolina | 45033 | 146 | 3 |
168610 | 168610 | 2020-05-22 | Dorchester | South Carolina | 45035 | 126 | 3 |
168611 | 168611 | 2020-05-22 | Edgefield | South Carolina | 45037 | 47 | 2 |
168612 | 168612 | 2020-05-22 | Fairfield | South Carolina | 45039 | 155 | 9 |
168613 | 168613 | 2020-05-22 | Florence | South Carolina | 45041 | 574 | 30 |
168614 | 168614 | 2020-05-22 | Georgetown | South Carolina | 45043 | 54 | 3 |
168615 | 168615 | 2020-05-22 | Greenville | South Carolina | 45045 | 1200 | 50 |
168616 | 168616 | 2020-05-22 | Greenwood | South Carolina | 45047 | 79 | 1 |
168617 | 168617 | 2020-05-22 | Hampton | South Carolina | 45049 | 31 | 0 |
168618 | 168618 | 2020-05-22 | Horry | South Carolina | 45051 | 359 | 21 |
168619 | 168619 | 2020-05-22 | Jasper | South Carolina | 45053 | 30 | 2 |
168620 | 168620 | 2020-05-22 | Kershaw | South Carolina | 45055 | 289 | 13 |
168621 | 168621 | 2020-05-22 | Lancaster | South Carolina | 45057 | 120 | 5 |
168622 | 168622 | 2020-05-22 | Laurens | South Carolina | 45059 | 57 | 3 |
168623 | 168623 | 2020-05-22 | Lee | South Carolina | 45061 | 181 | 13 |
168624 | 168624 | 2020-05-22 | Lexington | South Carolina | 45063 | 537 | 29 |
168625 | 168625 | 2020-05-22 | Marion | South Carolina | 45067 | 60 | 4 |
168626 | 168626 | 2020-05-22 | Marlboro | South Carolina | 45069 | 91 | 0 |
168627 | 168627 | 2020-05-22 | McCormick | South Carolina | 45065 | 8 | 1 |
168628 | 168628 | 2020-05-22 | Newberry | South Carolina | 45071 | 44 | 1 |
168629 | 168629 | 2020-05-22 | Oconee | South Carolina | 45073 | 42 | 0 |
168630 | 168630 | 2020-05-22 | Orangeburg | South Carolina | 45075 | 122 | 2 |
168631 | 168631 | 2020-05-22 | Pickens | South Carolina | 45077 | 110 | 3 |
168632 | 168632 | 2020-05-22 | Richland | South Carolina | 45079 | 1333 | 62 |
168633 | 168633 | 2020-05-22 | Saluda | South Carolina | 45081 | 132 | 0 |
168634 | 168634 | 2020-05-22 | Spartanburg | South Carolina | 45083 | 439 | 16 |
168635 | 168635 | 2020-05-22 | Sumter | South Carolina | 45085 | 339 | 17 |
168636 | 168636 | 2020-05-22 | Union | South Carolina | 45087 | 31 | 0 |
168637 | 168637 | 2020-05-22 | Williamsburg | South Carolina | 45089 | 198 | 10 |
168638 | 168638 | 2020-05-22 | York | South Carolina | 45091 | 329 | 5 |
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);