ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Union" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637341 | 637341 | 2020-10-16 | Union | South Carolina | 45087 | 677 | 15 |
634095 | 634095 | 2020-10-15 | Union | South Carolina | 45087 | 675 | 15 |
630850 | 630850 | 2020-10-14 | Union | South Carolina | 45087 | 670 | 15 |
627606 | 627606 | 2020-10-13 | Union | South Carolina | 45087 | 663 | 15 |
624364 | 624364 | 2020-10-12 | Union | South Carolina | 45087 | 656 | 15 |
621121 | 621121 | 2020-10-11 | Union | South Carolina | 45087 | 655 | 15 |
617878 | 617878 | 2020-10-10 | Union | South Carolina | 45087 | 650 | 15 |
614636 | 614636 | 2020-10-09 | Union | South Carolina | 45087 | 644 | 14 |
611395 | 611395 | 2020-10-08 | Union | South Carolina | 45087 | 634 | 14 |
608153 | 608153 | 2020-10-07 | Union | South Carolina | 45087 | 631 | 14 |
604910 | 604910 | 2020-10-06 | Union | South Carolina | 45087 | 628 | 13 |
601668 | 601668 | 2020-10-05 | Union | South Carolina | 45087 | 623 | 13 |
598425 | 598425 | 2020-10-04 | Union | South Carolina | 45087 | 617 | 13 |
595182 | 595182 | 2020-10-03 | Union | South Carolina | 45087 | 612 | 13 |
591941 | 591941 | 2020-10-02 | Union | South Carolina | 45087 | 589 | 13 |
588700 | 588700 | 2020-10-01 | Union | South Carolina | 45087 | 581 | 13 |
585460 | 585460 | 2020-09-30 | Union | South Carolina | 45087 | 575 | 12 |
582220 | 582220 | 2020-09-29 | Union | South Carolina | 45087 | 574 | 12 |
578980 | 578980 | 2020-09-28 | Union | South Carolina | 45087 | 565 | 12 |
575739 | 575739 | 2020-09-27 | Union | South Carolina | 45087 | 565 | 12 |
572495 | 572495 | 2020-09-26 | Union | South Carolina | 45087 | 564 | 12 |
569253 | 569253 | 2020-09-25 | Union | South Carolina | 45087 | 562 | 12 |
566012 | 566012 | 2020-09-24 | Union | South Carolina | 45087 | 560 | 12 |
562771 | 562771 | 2020-09-23 | Union | South Carolina | 45087 | 551 | 12 |
559534 | 559534 | 2020-09-22 | Union | South Carolina | 45087 | 542 | 11 |
556297 | 556297 | 2020-09-21 | Union | South Carolina | 45087 | 534 | 11 |
553060 | 553060 | 2020-09-20 | Union | South Carolina | 45087 | 534 | 11 |
549821 | 549821 | 2020-09-19 | Union | South Carolina | 45087 | 534 | 11 |
546582 | 546582 | 2020-09-18 | Union | South Carolina | 45087 | 526 | 11 |
543345 | 543345 | 2020-09-17 | Union | South Carolina | 45087 | 520 | 11 |
540109 | 540109 | 2020-09-16 | Union | South Carolina | 45087 | 516 | 10 |
536872 | 536872 | 2020-09-15 | Union | South Carolina | 45087 | 514 | 10 |
533636 | 533636 | 2020-09-14 | Union | South Carolina | 45087 | 507 | 10 |
530401 | 530401 | 2020-09-13 | Union | South Carolina | 45087 | 507 | 10 |
527164 | 527164 | 2020-09-12 | Union | South Carolina | 45087 | 505 | 10 |
523928 | 523928 | 2020-09-11 | Union | South Carolina | 45087 | 499 | 10 |
520692 | 520692 | 2020-09-10 | Union | South Carolina | 45087 | 491 | 9 |
517456 | 517456 | 2020-09-09 | Union | South Carolina | 45087 | 490 | 9 |
514221 | 514221 | 2020-09-08 | Union | South Carolina | 45087 | 489 | 9 |
510988 | 510988 | 2020-09-07 | Union | South Carolina | 45087 | 487 | 9 |
507755 | 507755 | 2020-09-06 | Union | South Carolina | 45087 | 486 | 9 |
504523 | 504523 | 2020-09-05 | Union | South Carolina | 45087 | 486 | 9 |
501289 | 501289 | 2020-09-04 | Union | South Carolina | 45087 | 483 | 9 |
498055 | 498055 | 2020-09-03 | Union | South Carolina | 45087 | 469 | 7 |
494822 | 494822 | 2020-09-02 | Union | South Carolina | 45087 | 464 | 7 |
491588 | 491588 | 2020-09-01 | Union | South Carolina | 45087 | 460 | 7 |
488355 | 488355 | 2020-08-31 | Union | South Carolina | 45087 | 458 | 5 |
485122 | 485122 | 2020-08-30 | Union | South Carolina | 45087 | 455 | 5 |
481887 | 481887 | 2020-08-29 | Union | South Carolina | 45087 | 451 | 5 |
478653 | 478653 | 2020-08-28 | Union | South Carolina | 45087 | 446 | 5 |
475420 | 475420 | 2020-08-27 | Union | South Carolina | 45087 | 442 | 5 |
472186 | 472186 | 2020-08-26 | Union | South Carolina | 45087 | 443 | 5 |
468954 | 468954 | 2020-08-25 | Union | South Carolina | 45087 | 440 | 5 |
465726 | 465726 | 2020-08-24 | Union | South Carolina | 45087 | 435 | 5 |
462497 | 462497 | 2020-08-23 | Union | South Carolina | 45087 | 435 | 5 |
459269 | 459269 | 2020-08-22 | Union | South Carolina | 45087 | 424 | 5 |
456041 | 456041 | 2020-08-21 | Union | South Carolina | 45087 | 417 | 5 |
452813 | 452813 | 2020-08-20 | Union | South Carolina | 45087 | 413 | 5 |
449585 | 449585 | 2020-08-19 | Union | South Carolina | 45087 | 409 | 5 |
446357 | 446357 | 2020-08-18 | Union | South Carolina | 45087 | 407 | 4 |
443131 | 443131 | 2020-08-17 | Union | South Carolina | 45087 | 403 | 4 |
439904 | 439904 | 2020-08-16 | Union | South Carolina | 45087 | 400 | 4 |
436679 | 436679 | 2020-08-15 | Union | South Carolina | 45087 | 399 | 4 |
433452 | 433452 | 2020-08-14 | Union | South Carolina | 45087 | 386 | 4 |
430226 | 430226 | 2020-08-13 | Union | South Carolina | 45087 | 383 | 4 |
427001 | 427001 | 2020-08-12 | Union | South Carolina | 45087 | 378 | 4 |
423778 | 423778 | 2020-08-11 | Union | South Carolina | 45087 | 375 | 4 |
420555 | 420555 | 2020-08-10 | Union | South Carolina | 45087 | 364 | 4 |
417335 | 417335 | 2020-08-09 | Union | South Carolina | 45087 | 362 | 4 |
414114 | 414114 | 2020-08-08 | Union | South Carolina | 45087 | 360 | 4 |
410894 | 410894 | 2020-08-07 | Union | South Carolina | 45087 | 355 | 4 |
407674 | 407674 | 2020-08-06 | Union | South Carolina | 45087 | 346 | 3 |
404455 | 404455 | 2020-08-05 | Union | South Carolina | 45087 | 344 | 3 |
401237 | 401237 | 2020-08-04 | Union | South Carolina | 45087 | 342 | 3 |
398022 | 398022 | 2020-08-03 | Union | South Carolina | 45087 | 335 | 2 |
394805 | 394805 | 2020-08-02 | Union | South Carolina | 45087 | 334 | 2 |
391589 | 391589 | 2020-08-01 | Union | South Carolina | 45087 | 332 | 2 |
388372 | 388372 | 2020-07-31 | Union | South Carolina | 45087 | 324 | 2 |
385155 | 385155 | 2020-07-30 | Union | South Carolina | 45087 | 307 | 2 |
381937 | 381937 | 2020-07-29 | Union | South Carolina | 45087 | 302 | 2 |
378720 | 378720 | 2020-07-28 | Union | South Carolina | 45087 | 291 | 2 |
375504 | 375504 | 2020-07-27 | Union | South Carolina | 45087 | 274 | 1 |
372291 | 372291 | 2020-07-26 | Union | South Carolina | 45087 | 270 | 1 |
369079 | 369079 | 2020-07-25 | Union | South Carolina | 45087 | 262 | 1 |
365870 | 365870 | 2020-07-24 | Union | South Carolina | 45087 | 255 | 1 |
362664 | 362664 | 2020-07-23 | Union | South Carolina | 45087 | 249 | 1 |
359458 | 359458 | 2020-07-22 | Union | South Carolina | 45087 | 238 | 0 |
356254 | 356254 | 2020-07-21 | Union | South Carolina | 45087 | 224 | 0 |
353051 | 353051 | 2020-07-20 | Union | South Carolina | 45087 | 203 | 0 |
349848 | 349848 | 2020-07-19 | Union | South Carolina | 45087 | 198 | 0 |
346648 | 346648 | 2020-07-18 | Union | South Carolina | 45087 | 190 | 0 |
343448 | 343448 | 2020-07-17 | Union | South Carolina | 45087 | 186 | 0 |
340250 | 340250 | 2020-07-16 | Union | South Carolina | 45087 | 183 | 0 |
337053 | 337053 | 2020-07-15 | Union | South Carolina | 45087 | 170 | 0 |
333859 | 333859 | 2020-07-14 | Union | South Carolina | 45087 | 163 | 0 |
330667 | 330667 | 2020-07-13 | Union | South Carolina | 45087 | 162 | 0 |
327481 | 327481 | 2020-07-12 | Union | South Carolina | 45087 | 154 | 0 |
324296 | 324296 | 2020-07-11 | Union | South Carolina | 45087 | 153 | 0 |
321116 | 321116 | 2020-07-10 | Union | South Carolina | 45087 | 138 | 0 |
317938 | 317938 | 2020-07-09 | Union | South Carolina | 45087 | 133 | 0 |
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);