ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 45061 and state = "South Carolina" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
276860 | 276860 | 2020-06-26 | Lee | South Carolina | 45061 | 272 | 22 |
280008 | 280008 | 2020-06-27 | Lee | South Carolina | 45061 | 276 | 22 |
283154 | 283154 | 2020-06-28 | Lee | South Carolina | 45061 | 283 | 22 |
286299 | 286299 | 2020-06-29 | Lee | South Carolina | 45061 | 285 | 22 |
289450 | 289450 | 2020-06-30 | Lee | South Carolina | 45061 | 289 | 22 |
292602 | 292602 | 2020-07-01 | Lee | South Carolina | 45061 | 293 | 22 |
295758 | 295758 | 2020-07-02 | Lee | South Carolina | 45061 | 295 | 22 |
298917 | 298917 | 2020-07-03 | Lee | South Carolina | 45061 | 301 | 22 |
302081 | 302081 | 2020-07-04 | Lee | South Carolina | 45061 | 307 | 22 |
305244 | 305244 | 2020-07-05 | Lee | South Carolina | 45061 | 308 | 22 |
308411 | 308411 | 2020-07-06 | Lee | South Carolina | 45061 | 310 | 22 |
311580 | 311580 | 2020-07-07 | Lee | South Carolina | 45061 | 330 | 22 |
314752 | 314752 | 2020-07-08 | Lee | South Carolina | 45061 | 331 | 22 |
317925 | 317925 | 2020-07-09 | Lee | South Carolina | 45061 | 331 | 22 |
324283 | 324283 | 2020-07-11 | Lee | South Carolina | 45061 | 337 | 22 |
321103 | 321103 | 2020-07-10 | Lee | South Carolina | 45061 | 340 | 22 |
330654 | 330654 | 2020-07-13 | Lee | South Carolina | 45061 | 344 | 23 |
327468 | 327468 | 2020-07-12 | Lee | South Carolina | 45061 | 345 | 23 |
333846 | 333846 | 2020-07-14 | Lee | South Carolina | 45061 | 350 | 23 |
337040 | 337040 | 2020-07-15 | Lee | South Carolina | 45061 | 356 | 23 |
340237 | 340237 | 2020-07-16 | Lee | South Carolina | 45061 | 362 | 23 |
343435 | 343435 | 2020-07-17 | Lee | South Carolina | 45061 | 371 | 23 |
346635 | 346635 | 2020-07-18 | Lee | South Carolina | 45061 | 372 | 24 |
349835 | 349835 | 2020-07-19 | Lee | South Carolina | 45061 | 379 | 24 |
353038 | 353038 | 2020-07-20 | Lee | South Carolina | 45061 | 393 | 24 |
356241 | 356241 | 2020-07-21 | Lee | South Carolina | 45061 | 399 | 24 |
359445 | 359445 | 2020-07-22 | Lee | South Carolina | 45061 | 404 | 25 |
362651 | 362651 | 2020-07-23 | Lee | South Carolina | 45061 | 412 | 25 |
365857 | 365857 | 2020-07-24 | Lee | South Carolina | 45061 | 420 | 25 |
369066 | 369066 | 2020-07-25 | Lee | South Carolina | 45061 | 427 | 25 |
372278 | 372278 | 2020-07-26 | Lee | South Carolina | 45061 | 435 | 25 |
375491 | 375491 | 2020-07-27 | Lee | South Carolina | 45061 | 447 | 25 |
378707 | 378707 | 2020-07-28 | Lee | South Carolina | 45061 | 453 | 25 |
381924 | 381924 | 2020-07-29 | Lee | South Carolina | 45061 | 479 | 25 |
385142 | 385142 | 2020-07-30 | Lee | South Carolina | 45061 | 485 | 26 |
388359 | 388359 | 2020-07-31 | Lee | South Carolina | 45061 | 487 | 26 |
391576 | 391576 | 2020-08-01 | Lee | South Carolina | 45061 | 513 | 27 |
394792 | 394792 | 2020-08-02 | Lee | South Carolina | 45061 | 522 | 27 |
398009 | 398009 | 2020-08-03 | Lee | South Carolina | 45061 | 526 | 27 |
401224 | 401224 | 2020-08-04 | Lee | South Carolina | 45061 | 532 | 27 |
404442 | 404442 | 2020-08-05 | Lee | South Carolina | 45061 | 537 | 27 |
407661 | 407661 | 2020-08-06 | Lee | South Carolina | 45061 | 542 | 27 |
410881 | 410881 | 2020-08-07 | Lee | South Carolina | 45061 | 556 | 27 |
423765 | 423765 | 2020-08-11 | Lee | South Carolina | 45061 | 559 | 29 |
414101 | 414101 | 2020-08-08 | Lee | South Carolina | 45061 | 561 | 27 |
426988 | 426988 | 2020-08-12 | Lee | South Carolina | 45061 | 561 | 30 |
417322 | 417322 | 2020-08-09 | Lee | South Carolina | 45061 | 562 | 29 |
430213 | 430213 | 2020-08-13 | Lee | South Carolina | 45061 | 564 | 30 |
420542 | 420542 | 2020-08-10 | Lee | South Carolina | 45061 | 566 | 29 |
433439 | 433439 | 2020-08-14 | Lee | South Carolina | 45061 | 572 | 30 |
436666 | 436666 | 2020-08-15 | Lee | South Carolina | 45061 | 581 | 30 |
439891 | 439891 | 2020-08-16 | Lee | South Carolina | 45061 | 586 | 30 |
443118 | 443118 | 2020-08-17 | Lee | South Carolina | 45061 | 588 | 30 |
446344 | 446344 | 2020-08-18 | Lee | South Carolina | 45061 | 588 | 30 |
449572 | 449572 | 2020-08-19 | Lee | South Carolina | 45061 | 592 | 30 |
452800 | 452800 | 2020-08-20 | Lee | South Carolina | 45061 | 595 | 30 |
456028 | 456028 | 2020-08-21 | Lee | South Carolina | 45061 | 603 | 30 |
459256 | 459256 | 2020-08-22 | Lee | South Carolina | 45061 | 604 | 30 |
462484 | 462484 | 2020-08-23 | Lee | South Carolina | 45061 | 607 | 30 |
465713 | 465713 | 2020-08-24 | Lee | South Carolina | 45061 | 610 | 30 |
468941 | 468941 | 2020-08-25 | Lee | South Carolina | 45061 | 615 | 30 |
472173 | 472173 | 2020-08-26 | Lee | South Carolina | 45061 | 624 | 30 |
475407 | 475407 | 2020-08-27 | Lee | South Carolina | 45061 | 627 | 30 |
478640 | 478640 | 2020-08-28 | Lee | South Carolina | 45061 | 641 | 30 |
481874 | 481874 | 2020-08-29 | Lee | South Carolina | 45061 | 644 | 31 |
485109 | 485109 | 2020-08-30 | Lee | South Carolina | 45061 | 648 | 31 |
488342 | 488342 | 2020-08-31 | Lee | South Carolina | 45061 | 650 | 32 |
491575 | 491575 | 2020-09-01 | Lee | South Carolina | 45061 | 652 | 32 |
494809 | 494809 | 2020-09-02 | Lee | South Carolina | 45061 | 655 | 32 |
498042 | 498042 | 2020-09-03 | Lee | South Carolina | 45061 | 664 | 32 |
501276 | 501276 | 2020-09-04 | Lee | South Carolina | 45061 | 668 | 32 |
520679 | 520679 | 2020-09-10 | Lee | South Carolina | 45061 | 674 | 32 |
504510 | 504510 | 2020-09-05 | Lee | South Carolina | 45061 | 676 | 32 |
507742 | 507742 | 2020-09-06 | Lee | South Carolina | 45061 | 678 | 32 |
527151 | 527151 | 2020-09-12 | Lee | South Carolina | 45061 | 680 | 32 |
510975 | 510975 | 2020-09-07 | Lee | South Carolina | 45061 | 681 | 32 |
523915 | 523915 | 2020-09-11 | Lee | South Carolina | 45061 | 681 | 32 |
517443 | 517443 | 2020-09-09 | Lee | South Carolina | 45061 | 682 | 32 |
514208 | 514208 | 2020-09-08 | Lee | South Carolina | 45061 | 683 | 32 |
530388 | 530388 | 2020-09-13 | Lee | South Carolina | 45061 | 684 | 32 |
533623 | 533623 | 2020-09-14 | Lee | South Carolina | 45061 | 687 | 32 |
536859 | 536859 | 2020-09-15 | Lee | South Carolina | 45061 | 690 | 32 |
540096 | 540096 | 2020-09-16 | Lee | South Carolina | 45061 | 691 | 33 |
543332 | 543332 | 2020-09-17 | Lee | South Carolina | 45061 | 694 | 33 |
546569 | 546569 | 2020-09-18 | Lee | South Carolina | 45061 | 696 | 34 |
549808 | 549808 | 2020-09-19 | Lee | South Carolina | 45061 | 696 | 34 |
553047 | 553047 | 2020-09-20 | Lee | South Carolina | 45061 | 697 | 34 |
556284 | 556284 | 2020-09-21 | Lee | South Carolina | 45061 | 699 | 34 |
559521 | 559521 | 2020-09-22 | Lee | South Carolina | 45061 | 699 | 34 |
562758 | 562758 | 2020-09-23 | Lee | South Carolina | 45061 | 701 | 34 |
565999 | 565999 | 2020-09-24 | Lee | South Carolina | 45061 | 705 | 34 |
569240 | 569240 | 2020-09-25 | Lee | South Carolina | 45061 | 713 | 34 |
591928 | 591928 | 2020-10-02 | Lee | South Carolina | 45061 | 717 | 35 |
585447 | 585447 | 2020-09-30 | Lee | South Carolina | 45061 | 718 | 35 |
572482 | 572482 | 2020-09-26 | Lee | South Carolina | 45061 | 719 | 34 |
575726 | 575726 | 2020-09-27 | Lee | South Carolina | 45061 | 719 | 34 |
582207 | 582207 | 2020-09-29 | Lee | South Carolina | 45061 | 719 | 35 |
588687 | 588687 | 2020-10-01 | Lee | South Carolina | 45061 | 719 | 35 |
595169 | 595169 | 2020-10-03 | Lee | South Carolina | 45061 | 719 | 35 |
578967 | 578967 | 2020-09-28 | Lee | South Carolina | 45061 | 720 | 35 |
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);