ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Saluda" 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 |
---|---|---|---|---|---|---|---|
637338 | 637338 | 2020-10-16 | Saluda | South Carolina | 45081 | 713 | 22 |
634092 | 634092 | 2020-10-15 | Saluda | South Carolina | 45081 | 711 | 22 |
630847 | 630847 | 2020-10-14 | Saluda | South Carolina | 45081 | 710 | 22 |
627603 | 627603 | 2020-10-13 | Saluda | South Carolina | 45081 | 710 | 22 |
624361 | 624361 | 2020-10-12 | Saluda | South Carolina | 45081 | 707 | 22 |
621118 | 621118 | 2020-10-11 | Saluda | South Carolina | 45081 | 705 | 22 |
617875 | 617875 | 2020-10-10 | Saluda | South Carolina | 45081 | 703 | 22 |
614633 | 614633 | 2020-10-09 | Saluda | South Carolina | 45081 | 697 | 22 |
611392 | 611392 | 2020-10-08 | Saluda | South Carolina | 45081 | 697 | 22 |
608150 | 608150 | 2020-10-07 | Saluda | South Carolina | 45081 | 694 | 22 |
604907 | 604907 | 2020-10-06 | Saluda | South Carolina | 45081 | 694 | 22 |
601665 | 601665 | 2020-10-05 | Saluda | South Carolina | 45081 | 691 | 22 |
598422 | 598422 | 2020-10-04 | Saluda | South Carolina | 45081 | 691 | 22 |
595179 | 595179 | 2020-10-03 | Saluda | South Carolina | 45081 | 691 | 22 |
591938 | 591938 | 2020-10-02 | Saluda | South Carolina | 45081 | 689 | 22 |
588697 | 588697 | 2020-10-01 | Saluda | South Carolina | 45081 | 690 | 22 |
585457 | 585457 | 2020-09-30 | Saluda | South Carolina | 45081 | 691 | 21 |
582217 | 582217 | 2020-09-29 | Saluda | South Carolina | 45081 | 691 | 21 |
578977 | 578977 | 2020-09-28 | Saluda | South Carolina | 45081 | 688 | 21 |
575736 | 575736 | 2020-09-27 | Saluda | South Carolina | 45081 | 689 | 21 |
572492 | 572492 | 2020-09-26 | Saluda | South Carolina | 45081 | 689 | 21 |
569250 | 569250 | 2020-09-25 | Saluda | South Carolina | 45081 | 689 | 21 |
566009 | 566009 | 2020-09-24 | Saluda | South Carolina | 45081 | 685 | 20 |
562768 | 562768 | 2020-09-23 | Saluda | South Carolina | 45081 | 684 | 20 |
559531 | 559531 | 2020-09-22 | Saluda | South Carolina | 45081 | 678 | 20 |
556294 | 556294 | 2020-09-21 | Saluda | South Carolina | 45081 | 669 | 20 |
553057 | 553057 | 2020-09-20 | Saluda | South Carolina | 45081 | 669 | 20 |
549818 | 549818 | 2020-09-19 | Saluda | South Carolina | 45081 | 670 | 20 |
546579 | 546579 | 2020-09-18 | Saluda | South Carolina | 45081 | 668 | 20 |
543342 | 543342 | 2020-09-17 | Saluda | South Carolina | 45081 | 665 | 20 |
540106 | 540106 | 2020-09-16 | Saluda | South Carolina | 45081 | 664 | 20 |
536869 | 536869 | 2020-09-15 | Saluda | South Carolina | 45081 | 664 | 20 |
533633 | 533633 | 2020-09-14 | Saluda | South Carolina | 45081 | 661 | 20 |
530398 | 530398 | 2020-09-13 | Saluda | South Carolina | 45081 | 660 | 20 |
527161 | 527161 | 2020-09-12 | Saluda | South Carolina | 45081 | 658 | 19 |
523925 | 523925 | 2020-09-11 | Saluda | South Carolina | 45081 | 654 | 19 |
520689 | 520689 | 2020-09-10 | Saluda | South Carolina | 45081 | 635 | 18 |
517453 | 517453 | 2020-09-09 | Saluda | South Carolina | 45081 | 615 | 16 |
514218 | 514218 | 2020-09-08 | Saluda | South Carolina | 45081 | 615 | 15 |
510985 | 510985 | 2020-09-07 | Saluda | South Carolina | 45081 | 620 | 15 |
507752 | 507752 | 2020-09-06 | Saluda | South Carolina | 45081 | 608 | 15 |
504520 | 504520 | 2020-09-05 | Saluda | South Carolina | 45081 | 606 | 15 |
501286 | 501286 | 2020-09-04 | Saluda | South Carolina | 45081 | 600 | 14 |
498052 | 498052 | 2020-09-03 | Saluda | South Carolina | 45081 | 589 | 14 |
494819 | 494819 | 2020-09-02 | Saluda | South Carolina | 45081 | 577 | 14 |
491585 | 491585 | 2020-09-01 | Saluda | South Carolina | 45081 | 572 | 14 |
488352 | 488352 | 2020-08-31 | Saluda | South Carolina | 45081 | 559 | 13 |
485119 | 485119 | 2020-08-30 | Saluda | South Carolina | 45081 | 558 | 13 |
481884 | 481884 | 2020-08-29 | Saluda | South Carolina | 45081 | 551 | 13 |
478650 | 478650 | 2020-08-28 | Saluda | South Carolina | 45081 | 548 | 12 |
475417 | 475417 | 2020-08-27 | Saluda | South Carolina | 45081 | 534 | 12 |
472183 | 472183 | 2020-08-26 | Saluda | South Carolina | 45081 | 529 | 11 |
468951 | 468951 | 2020-08-25 | Saluda | South Carolina | 45081 | 526 | 11 |
465723 | 465723 | 2020-08-24 | Saluda | South Carolina | 45081 | 521 | 11 |
462494 | 462494 | 2020-08-23 | Saluda | South Carolina | 45081 | 512 | 11 |
459266 | 459266 | 2020-08-22 | Saluda | South Carolina | 45081 | 510 | 11 |
456038 | 456038 | 2020-08-21 | Saluda | South Carolina | 45081 | 501 | 11 |
452810 | 452810 | 2020-08-20 | Saluda | South Carolina | 45081 | 497 | 11 |
449582 | 449582 | 2020-08-19 | Saluda | South Carolina | 45081 | 495 | 10 |
446354 | 446354 | 2020-08-18 | Saluda | South Carolina | 45081 | 494 | 10 |
443128 | 443128 | 2020-08-17 | Saluda | South Carolina | 45081 | 491 | 10 |
439901 | 439901 | 2020-08-16 | Saluda | South Carolina | 45081 | 485 | 10 |
436676 | 436676 | 2020-08-15 | Saluda | South Carolina | 45081 | 482 | 10 |
433449 | 433449 | 2020-08-14 | Saluda | South Carolina | 45081 | 473 | 9 |
430223 | 430223 | 2020-08-13 | Saluda | South Carolina | 45081 | 469 | 9 |
426998 | 426998 | 2020-08-12 | Saluda | South Carolina | 45081 | 468 | 9 |
423775 | 423775 | 2020-08-11 | Saluda | South Carolina | 45081 | 465 | 8 |
420552 | 420552 | 2020-08-10 | Saluda | South Carolina | 45081 | 459 | 8 |
417332 | 417332 | 2020-08-09 | Saluda | South Carolina | 45081 | 458 | 8 |
414111 | 414111 | 2020-08-08 | Saluda | South Carolina | 45081 | 452 | 8 |
410891 | 410891 | 2020-08-07 | Saluda | South Carolina | 45081 | 449 | 8 |
407671 | 407671 | 2020-08-06 | Saluda | South Carolina | 45081 | 443 | 8 |
404452 | 404452 | 2020-08-05 | Saluda | South Carolina | 45081 | 431 | 8 |
401234 | 401234 | 2020-08-04 | Saluda | South Carolina | 45081 | 426 | 8 |
398019 | 398019 | 2020-08-03 | Saluda | South Carolina | 45081 | 421 | 8 |
394802 | 394802 | 2020-08-02 | Saluda | South Carolina | 45081 | 416 | 8 |
391586 | 391586 | 2020-08-01 | Saluda | South Carolina | 45081 | 408 | 7 |
388369 | 388369 | 2020-07-31 | Saluda | South Carolina | 45081 | 398 | 7 |
385152 | 385152 | 2020-07-30 | Saluda | South Carolina | 45081 | 395 | 7 |
381934 | 381934 | 2020-07-29 | Saluda | South Carolina | 45081 | 394 | 7 |
378717 | 378717 | 2020-07-28 | Saluda | South Carolina | 45081 | 386 | 6 |
375501 | 375501 | 2020-07-27 | Saluda | South Carolina | 45081 | 379 | 6 |
372288 | 372288 | 2020-07-26 | Saluda | South Carolina | 45081 | 376 | 6 |
369076 | 369076 | 2020-07-25 | Saluda | South Carolina | 45081 | 371 | 6 |
365867 | 365867 | 2020-07-24 | Saluda | South Carolina | 45081 | 368 | 6 |
362661 | 362661 | 2020-07-23 | Saluda | South Carolina | 45081 | 366 | 5 |
359455 | 359455 | 2020-07-22 | Saluda | South Carolina | 45081 | 366 | 4 |
356251 | 356251 | 2020-07-21 | Saluda | South Carolina | 45081 | 361 | 4 |
353048 | 353048 | 2020-07-20 | Saluda | South Carolina | 45081 | 350 | 4 |
349845 | 349845 | 2020-07-19 | Saluda | South Carolina | 45081 | 343 | 4 |
346645 | 346645 | 2020-07-18 | Saluda | South Carolina | 45081 | 332 | 4 |
343445 | 343445 | 2020-07-17 | Saluda | South Carolina | 45081 | 322 | 3 |
340247 | 340247 | 2020-07-16 | Saluda | South Carolina | 45081 | 307 | 3 |
337050 | 337050 | 2020-07-15 | Saluda | South Carolina | 45081 | 303 | 2 |
333856 | 333856 | 2020-07-14 | Saluda | South Carolina | 45081 | 300 | 2 |
330664 | 330664 | 2020-07-13 | Saluda | South Carolina | 45081 | 290 | 2 |
327478 | 327478 | 2020-07-12 | Saluda | South Carolina | 45081 | 281 | 2 |
324293 | 324293 | 2020-07-11 | Saluda | South Carolina | 45081 | 272 | 2 |
321113 | 321113 | 2020-07-10 | Saluda | South Carolina | 45081 | 259 | 2 |
317935 | 317935 | 2020-07-09 | Saluda | South Carolina | 45081 | 254 | 2 |
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);