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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 45019 799
- 45055 799
- 45083 797
- 45057 794
- 45013 791
- 45063 791
- 45007 790
- 45045 790
- 45051 790
- 45039 789
- 45017 788
- 45079 788
- 45091 788
- 45061 787
- 45035 786
- 45081 786
- 45003 785
- 45015 785
- 45027 785
- 45031 785
- 45041 785
- 45075 785
- 45077 785
- 45085 785
- 45033 784
- 45037 784
- 45047 784
- 45053 784
- 45069 784
- 45071 784
- …
county >30
- Charleston 799
- Kershaw 799
- Spartanburg 797
- Lancaster 794
- Beaufort 791
- Lexington 791
- Anderson 790
- Greenville 790
- Horry 790
- Fairfield 789
- Calhoun 788
- Richland 788
- York 788
- Lee 787
- Dorchester 786
- Saluda 786
- Aiken 785
- Berkeley 785
- Clarendon 785
- Darlington 785
- Florence 785
- Orangeburg 785
- Pickens 785
- Sumter 785
- Dillon 784
- Edgefield 784
- Greenwood 784
- Jasper 784
- Marlboro 784
- Newberry 784
- …
state 1
- South Carolina · 35,991 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279978 | 279978 | 2020-06-27 | Abbeville | South Carolina | 45001 | 103 | 0 |
283124 | 283124 | 2020-06-28 | Abbeville | South Carolina | 45001 | 103 | 0 |
286269 | 286269 | 2020-06-29 | Abbeville | South Carolina | 45001 | 106 | 0 |
289420 | 289420 | 2020-06-30 | Abbeville | South Carolina | 45001 | 113 | 0 |
292572 | 292572 | 2020-07-01 | Abbeville | South Carolina | 45001 | 113 | 0 |
295728 | 295728 | 2020-07-02 | Abbeville | South Carolina | 45001 | 119 | 0 |
298887 | 298887 | 2020-07-03 | Abbeville | South Carolina | 45001 | 118 | 0 |
302051 | 302051 | 2020-07-04 | Abbeville | South Carolina | 45001 | 119 | 0 |
305214 | 305214 | 2020-07-05 | Abbeville | South Carolina | 45001 | 124 | 0 |
308381 | 308381 | 2020-07-06 | Abbeville | South Carolina | 45001 | 135 | 0 |
311550 | 311550 | 2020-07-07 | Abbeville | South Carolina | 45001 | 134 | 1 |
314722 | 314722 | 2020-07-08 | Abbeville | South Carolina | 45001 | 137 | 1 |
317895 | 317895 | 2020-07-09 | Abbeville | South Carolina | 45001 | 138 | 1 |
321073 | 321073 | 2020-07-10 | Abbeville | South Carolina | 45001 | 141 | 1 |
324253 | 324253 | 2020-07-11 | Abbeville | South Carolina | 45001 | 150 | 1 |
327438 | 327438 | 2020-07-12 | Abbeville | South Carolina | 45001 | 153 | 1 |
330624 | 330624 | 2020-07-13 | Abbeville | South Carolina | 45001 | 157 | 1 |
333816 | 333816 | 2020-07-14 | Abbeville | South Carolina | 45001 | 162 | 1 |
337010 | 337010 | 2020-07-15 | Abbeville | South Carolina | 45001 | 165 | 1 |
340207 | 340207 | 2020-07-16 | Abbeville | South Carolina | 45001 | 170 | 2 |
343405 | 343405 | 2020-07-17 | Abbeville | South Carolina | 45001 | 176 | 2 |
346605 | 346605 | 2020-07-18 | Abbeville | South Carolina | 45001 | 185 | 2 |
349805 | 349805 | 2020-07-19 | Abbeville | South Carolina | 45001 | 190 | 2 |
353008 | 353008 | 2020-07-20 | Abbeville | South Carolina | 45001 | 242 | 2 |
356211 | 356211 | 2020-07-21 | Abbeville | South Carolina | 45001 | 246 | 2 |
359415 | 359415 | 2020-07-22 | Abbeville | South Carolina | 45001 | 249 | 2 |
362621 | 362621 | 2020-07-23 | Abbeville | South Carolina | 45001 | 255 | 2 |
365827 | 365827 | 2020-07-24 | Abbeville | South Carolina | 45001 | 260 | 2 |
369036 | 369036 | 2020-07-25 | Abbeville | South Carolina | 45001 | 264 | 4 |
372248 | 372248 | 2020-07-26 | Abbeville | South Carolina | 45001 | 270 | 4 |
375461 | 375461 | 2020-07-27 | Abbeville | South Carolina | 45001 | 272 | 4 |
378677 | 378677 | 2020-07-28 | Abbeville | South Carolina | 45001 | 269 | 6 |
381894 | 381894 | 2020-07-29 | Abbeville | South Carolina | 45001 | 279 | 6 |
385112 | 385112 | 2020-07-30 | Abbeville | South Carolina | 45001 | 285 | 7 |
388329 | 388329 | 2020-07-31 | Abbeville | South Carolina | 45001 | 282 | 7 |
391546 | 391546 | 2020-08-01 | Abbeville | South Carolina | 45001 | 288 | 7 |
394762 | 394762 | 2020-08-02 | Abbeville | South Carolina | 45001 | 290 | 7 |
397979 | 397979 | 2020-08-03 | Abbeville | South Carolina | 45001 | 298 | 7 |
401194 | 401194 | 2020-08-04 | Abbeville | South Carolina | 45001 | 301 | 8 |
404412 | 404412 | 2020-08-05 | Abbeville | South Carolina | 45001 | 304 | 8 |
407631 | 407631 | 2020-08-06 | Abbeville | South Carolina | 45001 | 313 | 8 |
410851 | 410851 | 2020-08-07 | Abbeville | South Carolina | 45001 | 321 | 8 |
414071 | 414071 | 2020-08-08 | Abbeville | South Carolina | 45001 | 325 | 8 |
417292 | 417292 | 2020-08-09 | Abbeville | South Carolina | 45001 | 335 | 9 |
420512 | 420512 | 2020-08-10 | Abbeville | South Carolina | 45001 | 335 | 9 |
423735 | 423735 | 2020-08-11 | Abbeville | South Carolina | 45001 | 346 | 9 |
426958 | 426958 | 2020-08-12 | Abbeville | South Carolina | 45001 | 354 | 9 |
430183 | 430183 | 2020-08-13 | Abbeville | South Carolina | 45001 | 355 | 8 |
433409 | 433409 | 2020-08-14 | Abbeville | South Carolina | 45001 | 353 | 8 |
436636 | 436636 | 2020-08-15 | Abbeville | South Carolina | 45001 | 360 | 8 |
439861 | 439861 | 2020-08-16 | Abbeville | South Carolina | 45001 | 362 | 8 |
443088 | 443088 | 2020-08-17 | Abbeville | South Carolina | 45001 | 363 | 8 |
446314 | 446314 | 2020-08-18 | Abbeville | South Carolina | 45001 | 366 | 8 |
449542 | 449542 | 2020-08-19 | Abbeville | South Carolina | 45001 | 371 | 8 |
452770 | 452770 | 2020-08-20 | Abbeville | South Carolina | 45001 | 376 | 8 |
455998 | 455998 | 2020-08-21 | Abbeville | South Carolina | 45001 | 381 | 10 |
459226 | 459226 | 2020-08-22 | Abbeville | South Carolina | 45001 | 385 | 10 |
462454 | 462454 | 2020-08-23 | Abbeville | South Carolina | 45001 | 390 | 10 |
465683 | 465683 | 2020-08-24 | Abbeville | South Carolina | 45001 | 392 | 10 |
468911 | 468911 | 2020-08-25 | Abbeville | South Carolina | 45001 | 388 | 10 |
472143 | 472143 | 2020-08-26 | Abbeville | South Carolina | 45001 | 393 | 10 |
475377 | 475377 | 2020-08-27 | Abbeville | South Carolina | 45001 | 394 | 10 |
478610 | 478610 | 2020-08-28 | Abbeville | South Carolina | 45001 | 404 | 10 |
481844 | 481844 | 2020-08-29 | Abbeville | South Carolina | 45001 | 406 | 10 |
485079 | 485079 | 2020-08-30 | Abbeville | South Carolina | 45001 | 415 | 10 |
488312 | 488312 | 2020-08-31 | Abbeville | South Carolina | 45001 | 418 | 10 |
491545 | 491545 | 2020-09-01 | Abbeville | South Carolina | 45001 | 434 | 10 |
494779 | 494779 | 2020-09-02 | Abbeville | South Carolina | 45001 | 439 | 10 |
498012 | 498012 | 2020-09-03 | Abbeville | South Carolina | 45001 | 450 | 10 |
501246 | 501246 | 2020-09-04 | Abbeville | South Carolina | 45001 | 463 | 10 |
504480 | 504480 | 2020-09-05 | Abbeville | South Carolina | 45001 | 462 | 11 |
507712 | 507712 | 2020-09-06 | Abbeville | South Carolina | 45001 | 464 | 11 |
510945 | 510945 | 2020-09-07 | Abbeville | South Carolina | 45001 | 469 | 11 |
514178 | 514178 | 2020-09-08 | Abbeville | South Carolina | 45001 | 467 | 11 |
517413 | 517413 | 2020-09-09 | Abbeville | South Carolina | 45001 | 467 | 11 |
520649 | 520649 | 2020-09-10 | Abbeville | South Carolina | 45001 | 469 | 12 |
523885 | 523885 | 2020-09-11 | Abbeville | South Carolina | 45001 | 478 | 12 |
527121 | 527121 | 2020-09-12 | Abbeville | South Carolina | 45001 | 488 | 12 |
530358 | 530358 | 2020-09-13 | Abbeville | South Carolina | 45001 | 491 | 12 |
533593 | 533593 | 2020-09-14 | Abbeville | South Carolina | 45001 | 492 | 12 |
536829 | 536829 | 2020-09-15 | Abbeville | South Carolina | 45001 | 498 | 12 |
540066 | 540066 | 2020-09-16 | Abbeville | South Carolina | 45001 | 500 | 12 |
543302 | 543302 | 2020-09-17 | Abbeville | South Carolina | 45001 | 515 | 12 |
546539 | 546539 | 2020-09-18 | Abbeville | South Carolina | 45001 | 530 | 12 |
549778 | 549778 | 2020-09-19 | Abbeville | South Carolina | 45001 | 530 | 12 |
553017 | 553017 | 2020-09-20 | Abbeville | South Carolina | 45001 | 531 | 12 |
556254 | 556254 | 2020-09-21 | Abbeville | South Carolina | 45001 | 532 | 12 |
559491 | 559491 | 2020-09-22 | Abbeville | South Carolina | 45001 | 538 | 11 |
562728 | 562728 | 2020-09-23 | Abbeville | South Carolina | 45001 | 548 | 12 |
565969 | 565969 | 2020-09-24 | Abbeville | South Carolina | 45001 | 553 | 12 |
569210 | 569210 | 2020-09-25 | Abbeville | South Carolina | 45001 | 569 | 12 |
572452 | 572452 | 2020-09-26 | Abbeville | South Carolina | 45001 | 578 | 12 |
575696 | 575696 | 2020-09-27 | Abbeville | South Carolina | 45001 | 579 | 12 |
578937 | 578937 | 2020-09-28 | Abbeville | South Carolina | 45001 | 579 | 12 |
582177 | 582177 | 2020-09-29 | Abbeville | South Carolina | 45001 | 582 | 13 |
585417 | 585417 | 2020-09-30 | Abbeville | South Carolina | 45001 | 591 | 13 |
588657 | 588657 | 2020-10-01 | Abbeville | South Carolina | 45001 | 595 | 13 |
591898 | 591898 | 2020-10-02 | Abbeville | South Carolina | 45001 | 606 | 13 |
595139 | 595139 | 2020-10-03 | Abbeville | South Carolina | 45001 | 633 | 13 |
598382 | 598382 | 2020-10-04 | Abbeville | South Carolina | 45001 | 638 | 14 |
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);