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 2021-01-27 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
971530 | 971530 | 2021-01-27 | Abbeville | South Carolina | 45001 | 1742 | 28 |
971531 | 971531 | 2021-01-27 | Aiken | South Carolina | 45003 | 12410 | 167 |
971532 | 971532 | 2021-01-27 | Allendale | South Carolina | 45005 | 670 | 12 |
971533 | 971533 | 2021-01-27 | Anderson | South Carolina | 45007 | 16843 | 347 |
971534 | 971534 | 2021-01-27 | Bamberg | South Carolina | 45009 | 1210 | 44 |
971535 | 971535 | 2021-01-27 | Barnwell | South Carolina | 45011 | 2014 | 41 |
971536 | 971536 | 2021-01-27 | Beaufort | South Carolina | 45013 | 12969 | 141 |
971537 | 971537 | 2021-01-27 | Berkeley | South Carolina | 45015 | 12203 | 133 |
971538 | 971538 | 2021-01-27 | Calhoun | South Carolina | 45017 | 1084 | 28 |
971539 | 971539 | 2021-01-27 | Charleston | South Carolina | 45019 | 31520 | 364 |
971540 | 971540 | 2021-01-27 | Cherokee | South Carolina | 45021 | 4379 | 112 |
971541 | 971541 | 2021-01-27 | Chester | South Carolina | 45023 | 3080 | 48 |
971542 | 971542 | 2021-01-27 | Chesterfield | South Carolina | 45025 | 3273 | 77 |
971543 | 971543 | 2021-01-27 | Clarendon | South Carolina | 45027 | 2446 | 82 |
971544 | 971544 | 2021-01-27 | Colleton | South Carolina | 45029 | 2710 | 69 |
971545 | 971545 | 2021-01-27 | Darlington | South Carolina | 45031 | 6652 | 126 |
971546 | 971546 | 2021-01-27 | Dillon | South Carolina | 45033 | 3423 | 68 |
971547 | 971547 | 2021-01-27 | Dorchester | South Carolina | 45035 | 12090 | 142 |
971548 | 971548 | 2021-01-27 | Edgefield | South Carolina | 45037 | 2226 | 27 |
971549 | 971549 | 2021-01-27 | Fairfield | South Carolina | 45039 | 1820 | 59 |
971550 | 971550 | 2021-01-27 | Florence | South Carolina | 45041 | 14694 | 346 |
971551 | 971551 | 2021-01-27 | Georgetown | South Carolina | 45043 | 5372 | 118 |
971552 | 971552 | 2021-01-27 | Greenville | South Carolina | 45045 | 53974 | 663 |
971553 | 971553 | 2021-01-27 | Greenwood | South Carolina | 45047 | 5921 | 118 |
971554 | 971554 | 2021-01-27 | Hampton | South Carolina | 45049 | 1445 | 39 |
971555 | 971555 | 2021-01-27 | Horry | South Carolina | 45051 | 28026 | 408 |
971556 | 971556 | 2021-01-27 | Jasper | South Carolina | 45053 | 1815 | 33 |
971557 | 971557 | 2021-01-27 | Kershaw | South Carolina | 45055 | 5355 | 89 |
971558 | 971558 | 2021-01-27 | Lancaster | South Carolina | 45057 | 7536 | 111 |
971559 | 971559 | 2021-01-27 | Laurens | South Carolina | 45059 | 5255 | 113 |
971560 | 971560 | 2021-01-27 | Lee | South Carolina | 45061 | 1564 | 47 |
971561 | 971561 | 2021-01-27 | Lexington | South Carolina | 45063 | 23783 | 344 |
971562 | 971562 | 2021-01-27 | Marion | South Carolina | 45067 | 2814 | 86 |
971563 | 971563 | 2021-01-27 | Marlboro | South Carolina | 45069 | 2547 | 41 |
971564 | 971564 | 2021-01-27 | McCormick | South Carolina | 45065 | 673 | 11 |
971565 | 971565 | 2021-01-27 | Newberry | South Carolina | 45071 | 3679 | 79 |
971566 | 971566 | 2021-01-27 | Oconee | South Carolina | 45073 | 7286 | 87 |
971567 | 971567 | 2021-01-27 | Orangeburg | South Carolina | 45075 | 7226 | 181 |
971568 | 971568 | 2021-01-27 | Pickens | South Carolina | 45077 | 14296 | 200 |
971569 | 971569 | 2021-01-27 | Richland | South Carolina | 45079 | 34653 | 400 |
971570 | 971570 | 2021-01-27 | Saluda | South Carolina | 45081 | 1298 | 31 |
971571 | 971571 | 2021-01-27 | Spartanburg | South Carolina | 45083 | 28661 | 535 |
971572 | 971572 | 2021-01-27 | Sumter | South Carolina | 45085 | 7760 | 135 |
971573 | 971573 | 2021-01-27 | Union | South Carolina | 45087 | 2143 | 56 |
971574 | 971574 | 2021-01-27 | Williamsburg | South Carolina | 45089 | 3215 | 72 |
971575 | 971575 | 2021-01-27 | York | South Carolina | 45091 | 21476 | 215 |
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);