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 47
- 45019 354
- 45055 354
- 45083 352
- 45057 349
- 45013 346
- 45063 346
- 45007 345
- 45045 345
- 45051 345
- 45039 344
- 45017 343
- 45079 343
- 45091 343
- 45061 342
- 45001 341
- 45035 341
- 45081 341
- 45003 340
- 45015 340
- 45027 340
- 45031 340
- 45041 340
- 45075 340
- 45077 340
- 45085 340
- 45033 339
- 45037 339
- 45047 339
- 45053 339
- 45069 339
- 45071 339
- 45029 338
- 45023 337
- 45043 337
- 45073 337
- 45025 336
- 45067 335
- 45087 335
- 45089 335
- 45059 332
- 45011 330
- 45009 329
- 45005 328
- 45021 327
- 45049 327
- 45065 327
- - 3
county 47
- Charleston 354
- Kershaw 354
- Spartanburg 352
- Lancaster 349
- Beaufort 346
- Lexington 346
- Anderson 345
- Greenville 345
- Horry 345
- Fairfield 344
- Calhoun 343
- Richland 343
- York 343
- Lee 342
- Abbeville 341
- Dorchester 341
- Saluda 341
- Aiken 340
- Berkeley 340
- Clarendon 340
- Darlington 340
- Florence 340
- Orangeburg 340
- Pickens 340
- Sumter 340
- Dillon 339
- Edgefield 339
- Greenwood 339
- Jasper 339
- Marlboro 339
- Newberry 339
- Colleton 338
- Chester 337
- Georgetown 337
- Oconee 337
- Chesterfield 336
- Marion 335
- Union 335
- Williamsburg 335
- Laurens 332
- Barnwell 330
- Bamberg 329
- Allendale 328
- Cherokee 327
- Hampton 327
- McCormick 327
- Unknown 3
state 1
- South Carolina · 15,621 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055920 | 1055920 | 2021-02-22 | Abbeville | South Carolina | 45001 | 2191 | 34 |
1055921 | 1055921 | 2021-02-22 | Aiken | South Carolina | 45003 | 15374 | 199 |
1055922 | 1055922 | 2021-02-22 | Allendale | South Carolina | 45005 | 826 | 15 |
1055923 | 1055923 | 2021-02-22 | Anderson | South Carolina | 45007 | 19823 | 450 |
1055924 | 1055924 | 2021-02-22 | Bamberg | South Carolina | 45009 | 1432 | 48 |
1055925 | 1055925 | 2021-02-22 | Barnwell | South Carolina | 45011 | 2350 | 48 |
1055926 | 1055926 | 2021-02-22 | Beaufort | South Carolina | 45013 | 15112 | 175 |
1055927 | 1055927 | 2021-02-22 | Berkeley | South Carolina | 45015 | 14533 | 164 |
1055928 | 1055928 | 2021-02-22 | Calhoun | South Carolina | 45017 | 1204 | 35 |
1055929 | 1055929 | 2021-02-22 | Charleston | South Carolina | 45019 | 37414 | 438 |
1055930 | 1055930 | 2021-02-22 | Cherokee | South Carolina | 45021 | 5286 | 131 |
1055931 | 1055931 | 2021-02-22 | Chester | South Carolina | 45023 | 3609 | 64 |
1055932 | 1055932 | 2021-02-22 | Chesterfield | South Carolina | 45025 | 4167 | 95 |
1055933 | 1055933 | 2021-02-22 | Clarendon | South Carolina | 45027 | 2915 | 97 |
1055934 | 1055934 | 2021-02-22 | Colleton | South Carolina | 45029 | 3179 | 110 |
1055935 | 1055935 | 2021-02-22 | Darlington | South Carolina | 45031 | 7726 | 162 |
1055936 | 1055936 | 2021-02-22 | Dillon | South Carolina | 45033 | 3882 | 77 |
1055937 | 1055937 | 2021-02-22 | Dorchester | South Carolina | 45035 | 14728 | 181 |
1055938 | 1055938 | 2021-02-22 | Edgefield | South Carolina | 45037 | 2710 | 35 |
1055939 | 1055939 | 2021-02-22 | Fairfield | South Carolina | 45039 | 2065 | 70 |
1055940 | 1055940 | 2021-02-22 | Florence | South Carolina | 45041 | 16391 | 376 |
1055941 | 1055941 | 2021-02-22 | Georgetown | South Carolina | 45043 | 6099 | 132 |
1055942 | 1055942 | 2021-02-22 | Greenville | South Carolina | 45045 | 62644 | 837 |
1055943 | 1055943 | 2021-02-22 | Greenwood | South Carolina | 45047 | 6934 | 155 |
1055944 | 1055944 | 2021-02-22 | Hampton | South Carolina | 45049 | 1649 | 42 |
1055945 | 1055945 | 2021-02-22 | Horry | South Carolina | 45051 | 33672 | 519 |
1055946 | 1055946 | 2021-02-22 | Jasper | South Carolina | 45053 | 2111 | 41 |
1055947 | 1055947 | 2021-02-22 | Kershaw | South Carolina | 45055 | 6536 | 118 |
1055948 | 1055948 | 2021-02-22 | Lancaster | South Carolina | 45057 | 9296 | 140 |
1055949 | 1055949 | 2021-02-22 | Laurens | South Carolina | 45059 | 6173 | 153 |
1055950 | 1055950 | 2021-02-22 | Lee | South Carolina | 45061 | 1754 | 56 |
1055951 | 1055951 | 2021-02-22 | Lexington | South Carolina | 45063 | 29138 | 426 |
1055952 | 1055952 | 2021-02-22 | Marion | South Carolina | 45067 | 3206 | 95 |
1055953 | 1055953 | 2021-02-22 | Marlboro | South Carolina | 45069 | 2950 | 50 |
1055954 | 1055954 | 2021-02-22 | McCormick | South Carolina | 45065 | 891 | 24 |
1055955 | 1055955 | 2021-02-22 | Newberry | South Carolina | 45071 | 4292 | 92 |
1055956 | 1055956 | 2021-02-22 | Oconee | South Carolina | 45073 | 8295 | 120 |
1055957 | 1055957 | 2021-02-22 | Orangeburg | South Carolina | 45075 | 8553 | 212 |
1055958 | 1055958 | 2021-02-22 | Pickens | South Carolina | 45077 | 16161 | 260 |
1055959 | 1055959 | 2021-02-22 | Richland | South Carolina | 45079 | 40504 | 488 |
1055960 | 1055960 | 2021-02-22 | Saluda | South Carolina | 45081 | 1573 | 43 |
1055961 | 1055961 | 2021-02-22 | Spartanburg | South Carolina | 45083 | 35028 | 682 |
1055962 | 1055962 | 2021-02-22 | Sumter | South Carolina | 45085 | 9226 | 168 |
1055963 | 1055963 | 2021-02-22 | Union | South Carolina | 45087 | 2569 | 73 |
1055964 | 1055964 | 2021-02-22 | Williamsburg | South Carolina | 45089 | 3732 | 86 |
1055965 | 1055965 | 2021-02-22 | York | South Carolina | 45091 | 25686 | 316 |
1052674 | 1052674 | 2021-02-21 | Abbeville | South Carolina | 45001 | 2184 | 34 |
1052675 | 1052675 | 2021-02-21 | Aiken | South Carolina | 45003 | 15268 | 199 |
1052676 | 1052676 | 2021-02-21 | Allendale | South Carolina | 45005 | 822 | 15 |
1052677 | 1052677 | 2021-02-21 | Anderson | South Carolina | 45007 | 19717 | 450 |
1052678 | 1052678 | 2021-02-21 | Bamberg | South Carolina | 45009 | 1427 | 48 |
1052679 | 1052679 | 2021-02-21 | Barnwell | South Carolina | 45011 | 2343 | 48 |
1052680 | 1052680 | 2021-02-21 | Beaufort | South Carolina | 45013 | 15078 | 175 |
1052681 | 1052681 | 2021-02-21 | Berkeley | South Carolina | 45015 | 14491 | 164 |
1052682 | 1052682 | 2021-02-21 | Calhoun | South Carolina | 45017 | 1203 | 35 |
1052683 | 1052683 | 2021-02-21 | Charleston | South Carolina | 45019 | 37332 | 437 |
1052684 | 1052684 | 2021-02-21 | Cherokee | South Carolina | 45021 | 5275 | 131 |
1052685 | 1052685 | 2021-02-21 | Chester | South Carolina | 45023 | 3598 | 64 |
1052686 | 1052686 | 2021-02-21 | Chesterfield | South Carolina | 45025 | 4162 | 95 |
1052687 | 1052687 | 2021-02-21 | Clarendon | South Carolina | 45027 | 2908 | 97 |
1052688 | 1052688 | 2021-02-21 | Colleton | South Carolina | 45029 | 3174 | 110 |
1052689 | 1052689 | 2021-02-21 | Darlington | South Carolina | 45031 | 7717 | 162 |
1052690 | 1052690 | 2021-02-21 | Dillon | South Carolina | 45033 | 3879 | 76 |
1052691 | 1052691 | 2021-02-21 | Dorchester | South Carolina | 45035 | 14679 | 179 |
1052692 | 1052692 | 2021-02-21 | Edgefield | South Carolina | 45037 | 2682 | 35 |
1052693 | 1052693 | 2021-02-21 | Fairfield | South Carolina | 45039 | 2058 | 70 |
1052694 | 1052694 | 2021-02-21 | Florence | South Carolina | 45041 | 16376 | 376 |
1052695 | 1052695 | 2021-02-21 | Georgetown | South Carolina | 45043 | 6094 | 133 |
1052696 | 1052696 | 2021-02-21 | Greenville | South Carolina | 45045 | 62535 | 837 |
1052697 | 1052697 | 2021-02-21 | Greenwood | South Carolina | 45047 | 6923 | 155 |
1052698 | 1052698 | 2021-02-21 | Hampton | South Carolina | 45049 | 1646 | 42 |
1052699 | 1052699 | 2021-02-21 | Horry | South Carolina | 45051 | 33602 | 518 |
1052700 | 1052700 | 2021-02-21 | Jasper | South Carolina | 45053 | 2107 | 41 |
1052701 | 1052701 | 2021-02-21 | Kershaw | South Carolina | 45055 | 6505 | 115 |
1052702 | 1052702 | 2021-02-21 | Lancaster | South Carolina | 45057 | 9259 | 140 |
1052703 | 1052703 | 2021-02-21 | Laurens | South Carolina | 45059 | 6155 | 153 |
1052704 | 1052704 | 2021-02-21 | Lee | South Carolina | 45061 | 1752 | 56 |
1052705 | 1052705 | 2021-02-21 | Lexington | South Carolina | 45063 | 29020 | 426 |
1052706 | 1052706 | 2021-02-21 | Marion | South Carolina | 45067 | 3202 | 95 |
1052707 | 1052707 | 2021-02-21 | Marlboro | South Carolina | 45069 | 2947 | 50 |
1052708 | 1052708 | 2021-02-21 | McCormick | South Carolina | 45065 | 889 | 24 |
1052709 | 1052709 | 2021-02-21 | Newberry | South Carolina | 45071 | 4270 | 92 |
1052710 | 1052710 | 2021-02-21 | Oconee | South Carolina | 45073 | 8277 | 120 |
1052711 | 1052711 | 2021-02-21 | Orangeburg | South Carolina | 45075 | 8530 | 211 |
1052712 | 1052712 | 2021-02-21 | Pickens | South Carolina | 45077 | 16131 | 260 |
1052713 | 1052713 | 2021-02-21 | Richland | South Carolina | 45079 | 40371 | 488 |
1052714 | 1052714 | 2021-02-21 | Saluda | South Carolina | 45081 | 1567 | 43 |
1052715 | 1052715 | 2021-02-21 | Spartanburg | South Carolina | 45083 | 34925 | 683 |
1052716 | 1052716 | 2021-02-21 | Sumter | South Carolina | 45085 | 9217 | 168 |
1052717 | 1052717 | 2021-02-21 | Union | South Carolina | 45087 | 2561 | 73 |
1052718 | 1052718 | 2021-02-21 | Williamsburg | South Carolina | 45089 | 3719 | 86 |
1052719 | 1052719 | 2021-02-21 | York | South Carolina | 45091 | 25572 | 315 |
1049427 | 1049427 | 2021-02-20 | Abbeville | South Carolina | 45001 | 2174 | 34 |
1049428 | 1049428 | 2021-02-20 | Aiken | South Carolina | 45003 | 15145 | 197 |
1049429 | 1049429 | 2021-02-20 | Allendale | South Carolina | 45005 | 815 | 15 |
1049430 | 1049430 | 2021-02-20 | Anderson | South Carolina | 45007 | 19613 | 448 |
1049431 | 1049431 | 2021-02-20 | Bamberg | South Carolina | 45009 | 1419 | 48 |
1049432 | 1049432 | 2021-02-20 | Barnwell | South Carolina | 45011 | 2326 | 47 |
1049433 | 1049433 | 2021-02-20 | Beaufort | South Carolina | 45013 | 15004 | 175 |
1049434 | 1049434 | 2021-02-20 | Berkeley | South Carolina | 45015 | 14422 | 163 |
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);