ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36,091 rows where state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 45019 223
- 45055 223
- 45083 221
- 45057 218
- 45013 215
- 45063 215
- 45007 214
- 45045 214
- 45051 214
- 45039 213
- 45017 212
- 45079 212
- 45091 212
- 45061 211
- 45001 210
- 45035 210
- 45081 210
- 45003 209
- 45015 209
- 45027 209
- 45031 209
- 45041 209
- 45075 209
- 45077 209
- 45085 209
- 45033 208
- 45037 208
- 45047 208
- 45053 208
- 45069 208
- …
county >30
- Charleston 223
- Kershaw 223
- Spartanburg 221
- Lancaster 218
- Beaufort 215
- Lexington 215
- Anderson 214
- Greenville 214
- Horry 214
- Fairfield 213
- Calhoun 212
- Richland 212
- York 212
- Lee 211
- Abbeville 210
- Dorchester 210
- Saluda 210
- Aiken 209
- Berkeley 209
- Clarendon 209
- Darlington 209
- Florence 209
- Orangeburg 209
- Pickens 209
- Sumter 209
- Dillon 208
- Edgefield 208
- Greenwood 208
- Jasper 208
- Marlboro 208
- …
state 1
- South Carolina · 9,595 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
630807 | 630807 | 2020-10-14 | Abbeville | South Carolina | 45001 | 694 | 15 |
630808 | 630808 | 2020-10-14 | Aiken | South Carolina | 45003 | 4644 | 85 |
630809 | 630809 | 2020-10-14 | Allendale | South Carolina | 45005 | 425 | 6 |
630810 | 630810 | 2020-10-14 | Anderson | South Carolina | 45007 | 5076 | 189 |
630811 | 630811 | 2020-10-14 | Bamberg | South Carolina | 45009 | 665 | 35 |
630812 | 630812 | 2020-10-14 | Barnwell | South Carolina | 45011 | 810 | 18 |
630813 | 630813 | 2020-10-14 | Beaufort | South Carolina | 45013 | 5909 | 89 |
630814 | 630814 | 2020-10-14 | Berkeley | South Carolina | 45015 | 5723 | 92 |
630815 | 630815 | 2020-10-14 | Calhoun | South Carolina | 45017 | 494 | 17 |
630816 | 630816 | 2020-10-14 | Charleston | South Carolina | 45019 | 16392 | 269 |
630817 | 630817 | 2020-10-14 | Cherokee | South Carolina | 45021 | 1313 | 46 |
630818 | 630818 | 2020-10-14 | Chester | South Carolina | 45023 | 1131 | 22 |
630819 | 630819 | 2020-10-14 | Chesterfield | South Carolina | 45025 | 1383 | 39 |
630820 | 630820 | 2020-10-14 | Clarendon | South Carolina | 45027 | 1133 | 68 |
630821 | 630821 | 2020-10-14 | Colleton | South Carolina | 45029 | 1167 | 43 |
630822 | 630822 | 2020-10-14 | Darlington | South Carolina | 45031 | 2286 | 63 |
630823 | 630823 | 2020-10-14 | Dillon | South Carolina | 45033 | 1226 | 44 |
630824 | 630824 | 2020-10-14 | Dorchester | South Carolina | 45035 | 4485 | 91 |
630825 | 630825 | 2020-10-14 | Edgefield | South Carolina | 45037 | 862 | 20 |
630826 | 630826 | 2020-10-14 | Fairfield | South Carolina | 45039 | 824 | 37 |
630827 | 630827 | 2020-10-14 | Florence | South Carolina | 45041 | 5259 | 199 |
630828 | 630828 | 2020-10-14 | Georgetown | South Carolina | 45043 | 2067 | 47 |
630829 | 630829 | 2020-10-14 | Greenville | South Carolina | 45045 | 15846 | 330 |
630830 | 630830 | 2020-10-14 | Greenwood | South Carolina | 45047 | 2418 | 73 |
630831 | 630831 | 2020-10-14 | Hampton | South Carolina | 45049 | 730 | 29 |
630832 | 630832 | 2020-10-14 | Horry | South Carolina | 45051 | 11527 | 207 |
630833 | 630833 | 2020-10-14 | Jasper | South Carolina | 45053 | 865 | 23 |
630834 | 630834 | 2020-10-14 | Kershaw | South Carolina | 45055 | 2244 | 41 |
630835 | 630835 | 2020-10-14 | Lancaster | South Carolina | 45057 | 2367 | 56 |
630836 | 630836 | 2020-10-14 | Laurens | South Carolina | 45059 | 1797 | 58 |
630837 | 630837 | 2020-10-14 | Lee | South Carolina | 45061 | 744 | 35 |
630838 | 630838 | 2020-10-14 | Lexington | South Carolina | 45063 | 8206 | 186 |
630839 | 630839 | 2020-10-14 | Marion | South Carolina | 45067 | 1024 | 32 |
630840 | 630840 | 2020-10-14 | Marlboro | South Carolina | 45069 | 1026 | 12 |
630841 | 630841 | 2020-10-14 | McCormick | South Carolina | 45065 | 253 | 7 |
630842 | 630842 | 2020-10-14 | Newberry | South Carolina | 45071 | 1506 | 35 |
630843 | 630843 | 2020-10-14 | Oconee | South Carolina | 45073 | 2191 | 29 |
630844 | 630844 | 2020-10-14 | Orangeburg | South Carolina | 45075 | 3219 | 129 |
630845 | 630845 | 2020-10-14 | Pickens | South Carolina | 45077 | 3695 | 52 |
630846 | 630846 | 2020-10-14 | Richland | South Carolina | 45079 | 16263 | 258 |
630847 | 630847 | 2020-10-14 | Saluda | South Carolina | 45081 | 710 | 22 |
630848 | 630848 | 2020-10-14 | Spartanburg | South Carolina | 45083 | 7802 | 210 |
630849 | 630849 | 2020-10-14 | Sumter | South Carolina | 45085 | 3350 | 84 |
630850 | 630850 | 2020-10-14 | Union | South Carolina | 45087 | 670 | 15 |
630851 | 630851 | 2020-10-14 | Williamsburg | South Carolina | 45089 | 1372 | 46 |
630852 | 630852 | 2020-10-14 | York | South Carolina | 45091 | 6016 | 90 |
627563 | 627563 | 2020-10-13 | Abbeville | South Carolina | 45001 | 694 | 15 |
627564 | 627564 | 2020-10-13 | Aiken | South Carolina | 45003 | 4542 | 85 |
627565 | 627565 | 2020-10-13 | Allendale | South Carolina | 45005 | 421 | 6 |
627566 | 627566 | 2020-10-13 | Anderson | South Carolina | 45007 | 5045 | 189 |
627567 | 627567 | 2020-10-13 | Bamberg | South Carolina | 45009 | 662 | 35 |
627568 | 627568 | 2020-10-13 | Barnwell | South Carolina | 45011 | 795 | 17 |
627569 | 627569 | 2020-10-13 | Beaufort | South Carolina | 45013 | 5899 | 90 |
627570 | 627570 | 2020-10-13 | Berkeley | South Carolina | 45015 | 5701 | 91 |
627571 | 627571 | 2020-10-13 | Calhoun | South Carolina | 45017 | 493 | 17 |
627572 | 627572 | 2020-10-13 | Charleston | South Carolina | 45019 | 16340 | 269 |
627573 | 627573 | 2020-10-13 | Cherokee | South Carolina | 45021 | 1311 | 46 |
627574 | 627574 | 2020-10-13 | Chester | South Carolina | 45023 | 1129 | 22 |
627575 | 627575 | 2020-10-13 | Chesterfield | South Carolina | 45025 | 1373 | 39 |
627576 | 627576 | 2020-10-13 | Clarendon | South Carolina | 45027 | 1133 | 68 |
627577 | 627577 | 2020-10-13 | Colleton | South Carolina | 45029 | 1152 | 43 |
627578 | 627578 | 2020-10-13 | Darlington | South Carolina | 45031 | 2265 | 63 |
627579 | 627579 | 2020-10-13 | Dillon | South Carolina | 45033 | 1212 | 44 |
627580 | 627580 | 2020-10-13 | Dorchester | South Carolina | 45035 | 4465 | 91 |
627581 | 627581 | 2020-10-13 | Edgefield | South Carolina | 45037 | 848 | 19 |
627582 | 627582 | 2020-10-13 | Fairfield | South Carolina | 45039 | 822 | 37 |
627583 | 627583 | 2020-10-13 | Florence | South Carolina | 45041 | 5230 | 198 |
627584 | 627584 | 2020-10-13 | Georgetown | South Carolina | 45043 | 2043 | 45 |
627585 | 627585 | 2020-10-13 | Greenville | South Carolina | 45045 | 15780 | 328 |
627586 | 627586 | 2020-10-13 | Greenwood | South Carolina | 45047 | 2394 | 73 |
627587 | 627587 | 2020-10-13 | Hampton | South Carolina | 45049 | 721 | 29 |
627588 | 627588 | 2020-10-13 | Horry | South Carolina | 45051 | 11436 | 207 |
627589 | 627589 | 2020-10-13 | Jasper | South Carolina | 45053 | 863 | 23 |
627590 | 627590 | 2020-10-13 | Kershaw | South Carolina | 45055 | 2233 | 41 |
627591 | 627591 | 2020-10-13 | Lancaster | South Carolina | 45057 | 2355 | 56 |
627592 | 627592 | 2020-10-13 | Laurens | South Carolina | 45059 | 1794 | 58 |
627593 | 627593 | 2020-10-13 | Lee | South Carolina | 45061 | 743 | 35 |
627594 | 627594 | 2020-10-13 | Lexington | South Carolina | 45063 | 8164 | 183 |
627595 | 627595 | 2020-10-13 | Marion | South Carolina | 45067 | 1014 | 32 |
627596 | 627596 | 2020-10-13 | Marlboro | South Carolina | 45069 | 1024 | 12 |
627597 | 627597 | 2020-10-13 | McCormick | South Carolina | 45065 | 251 | 7 |
627598 | 627598 | 2020-10-13 | Newberry | South Carolina | 45071 | 1492 | 32 |
627599 | 627599 | 2020-10-13 | Oconee | South Carolina | 45073 | 2180 | 29 |
627600 | 627600 | 2020-10-13 | Orangeburg | South Carolina | 45075 | 3210 | 128 |
627601 | 627601 | 2020-10-13 | Pickens | South Carolina | 45077 | 3662 | 52 |
627602 | 627602 | 2020-10-13 | Richland | South Carolina | 45079 | 16206 | 258 |
627603 | 627603 | 2020-10-13 | Saluda | South Carolina | 45081 | 710 | 22 |
627604 | 627604 | 2020-10-13 | Spartanburg | South Carolina | 45083 | 7723 | 210 |
627605 | 627605 | 2020-10-13 | Sumter | South Carolina | 45085 | 3343 | 84 |
627606 | 627606 | 2020-10-13 | Union | South Carolina | 45087 | 663 | 15 |
627607 | 627607 | 2020-10-13 | Williamsburg | South Carolina | 45089 | 1365 | 46 |
627608 | 627608 | 2020-10-13 | York | South Carolina | 45091 | 5982 | 87 |
624321 | 624321 | 2020-10-12 | Abbeville | South Carolina | 45001 | 693 | 15 |
624322 | 624322 | 2020-10-12 | Aiken | South Carolina | 45003 | 4526 | 85 |
624323 | 624323 | 2020-10-12 | Allendale | South Carolina | 45005 | 421 | 6 |
624324 | 624324 | 2020-10-12 | Anderson | South Carolina | 45007 | 5018 | 187 |
624325 | 624325 | 2020-10-12 | Bamberg | South Carolina | 45009 | 659 | 35 |
624326 | 624326 | 2020-10-12 | Barnwell | South Carolina | 45011 | 794 | 17 |
624327 | 624327 | 2020-10-12 | Beaufort | South Carolina | 45013 | 5890 | 89 |
624328 | 624328 | 2020-10-12 | Berkeley | South Carolina | 45015 | 5679 | 91 |
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);