ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jackson" and fips = 48239 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
731699 | 731699 | 2020-11-14 | Jackson | Texas | 48239 | 719 | 16 |
728454 | 728454 | 2020-11-13 | Jackson | Texas | 48239 | 714 | 16 |
725211 | 725211 | 2020-11-12 | Jackson | Texas | 48239 | 693 | 16 |
721968 | 721968 | 2020-11-11 | Jackson | Texas | 48239 | 693 | 16 |
718725 | 718725 | 2020-11-10 | Jackson | Texas | 48239 | 692 | 16 |
715482 | 715482 | 2020-11-09 | Jackson | Texas | 48239 | 681 | 16 |
712238 | 712238 | 2020-11-08 | Jackson | Texas | 48239 | 675 | 16 |
708994 | 708994 | 2020-11-07 | Jackson | Texas | 48239 | 675 | 16 |
705750 | 705750 | 2020-11-06 | Jackson | Texas | 48239 | 676 | 16 |
702507 | 702507 | 2020-11-05 | Jackson | Texas | 48239 | 670 | 16 |
699264 | 699264 | 2020-11-04 | Jackson | Texas | 48239 | 669 | 16 |
696020 | 696020 | 2020-11-03 | Jackson | Texas | 48239 | 666 | 16 |
692778 | 692778 | 2020-11-02 | Jackson | Texas | 48239 | 663 | 16 |
689534 | 689534 | 2020-11-01 | Jackson | Texas | 48239 | 656 | 16 |
686289 | 686289 | 2020-10-31 | Jackson | Texas | 48239 | 656 | 16 |
683046 | 683046 | 2020-10-30 | Jackson | Texas | 48239 | 656 | 16 |
679803 | 679803 | 2020-10-29 | Jackson | Texas | 48239 | 654 | 16 |
676560 | 676560 | 2020-10-28 | Jackson | Texas | 48239 | 652 | 16 |
673317 | 673317 | 2020-10-27 | Jackson | Texas | 48239 | 650 | 16 |
670075 | 670075 | 2020-10-26 | Jackson | Texas | 48239 | 647 | 16 |
666832 | 666832 | 2020-10-25 | Jackson | Texas | 48239 | 646 | 16 |
663587 | 663587 | 2020-10-24 | Jackson | Texas | 48239 | 646 | 16 |
660343 | 660343 | 2020-10-23 | Jackson | Texas | 48239 | 640 | 16 |
657099 | 657099 | 2020-10-22 | Jackson | Texas | 48239 | 639 | 16 |
653854 | 653854 | 2020-10-21 | Jackson | Texas | 48239 | 639 | 16 |
650609 | 650609 | 2020-10-20 | Jackson | Texas | 48239 | 637 | 16 |
647365 | 647365 | 2020-10-19 | Jackson | Texas | 48239 | 636 | 16 |
644119 | 644119 | 2020-10-18 | Jackson | Texas | 48239 | 636 | 16 |
640871 | 640871 | 2020-10-17 | Jackson | Texas | 48239 | 636 | 16 |
637624 | 637624 | 2020-10-16 | Jackson | Texas | 48239 | 635 | 16 |
634379 | 634379 | 2020-10-15 | Jackson | Texas | 48239 | 635 | 16 |
631134 | 631134 | 2020-10-14 | Jackson | Texas | 48239 | 633 | 16 |
627890 | 627890 | 2020-10-13 | Jackson | Texas | 48239 | 633 | 16 |
624648 | 624648 | 2020-10-12 | Jackson | Texas | 48239 | 632 | 16 |
621405 | 621405 | 2020-10-11 | Jackson | Texas | 48239 | 626 | 16 |
618162 | 618162 | 2020-10-10 | Jackson | Texas | 48239 | 626 | 16 |
614920 | 614920 | 2020-10-09 | Jackson | Texas | 48239 | 627 | 16 |
611679 | 611679 | 2020-10-08 | Jackson | Texas | 48239 | 627 | 16 |
608437 | 608437 | 2020-10-07 | Jackson | Texas | 48239 | 626 | 16 |
605194 | 605194 | 2020-10-06 | Jackson | Texas | 48239 | 630 | 16 |
601952 | 601952 | 2020-10-05 | Jackson | Texas | 48239 | 633 | 16 |
598709 | 598709 | 2020-10-04 | Jackson | Texas | 48239 | 614 | 16 |
595466 | 595466 | 2020-10-03 | Jackson | Texas | 48239 | 614 | 16 |
592224 | 592224 | 2020-10-02 | Jackson | Texas | 48239 | 614 | 16 |
588984 | 588984 | 2020-10-01 | Jackson | Texas | 48239 | 612 | 16 |
585743 | 585743 | 2020-09-30 | Jackson | Texas | 48239 | 607 | 16 |
582503 | 582503 | 2020-09-29 | Jackson | Texas | 48239 | 608 | 16 |
579264 | 579264 | 2020-09-28 | Jackson | Texas | 48239 | 606 | 16 |
576023 | 576023 | 2020-09-27 | Jackson | Texas | 48239 | 606 | 16 |
572779 | 572779 | 2020-09-26 | Jackson | Texas | 48239 | 606 | 16 |
569537 | 569537 | 2020-09-25 | Jackson | Texas | 48239 | 606 | 15 |
566296 | 566296 | 2020-09-24 | Jackson | Texas | 48239 | 606 | 15 |
563055 | 563055 | 2020-09-23 | Jackson | Texas | 48239 | 606 | 15 |
559816 | 559816 | 2020-09-22 | Jackson | Texas | 48239 | 605 | 15 |
556580 | 556580 | 2020-09-21 | Jackson | Texas | 48239 | 604 | 15 |
553343 | 553343 | 2020-09-20 | Jackson | Texas | 48239 | 527 | 15 |
550104 | 550104 | 2020-09-19 | Jackson | Texas | 48239 | 527 | 15 |
546865 | 546865 | 2020-09-18 | Jackson | Texas | 48239 | 527 | 15 |
543628 | 543628 | 2020-09-17 | Jackson | Texas | 48239 | 526 | 15 |
540392 | 540392 | 2020-09-16 | Jackson | Texas | 48239 | 523 | 15 |
537155 | 537155 | 2020-09-15 | Jackson | Texas | 48239 | 522 | 15 |
533919 | 533919 | 2020-09-14 | Jackson | Texas | 48239 | 518 | 15 |
530684 | 530684 | 2020-09-13 | Jackson | Texas | 48239 | 518 | 15 |
527447 | 527447 | 2020-09-12 | Jackson | Texas | 48239 | 518 | 15 |
524211 | 524211 | 2020-09-11 | Jackson | Texas | 48239 | 517 | 15 |
520975 | 520975 | 2020-09-10 | Jackson | Texas | 48239 | 511 | 15 |
517739 | 517739 | 2020-09-09 | Jackson | Texas | 48239 | 511 | 15 |
514504 | 514504 | 2020-09-08 | Jackson | Texas | 48239 | 504 | 14 |
511271 | 511271 | 2020-09-07 | Jackson | Texas | 48239 | 505 | 14 |
508038 | 508038 | 2020-09-06 | Jackson | Texas | 48239 | 505 | 14 |
504806 | 504806 | 2020-09-05 | Jackson | Texas | 48239 | 505 | 14 |
501572 | 501572 | 2020-09-04 | Jackson | Texas | 48239 | 505 | 14 |
498338 | 498338 | 2020-09-03 | Jackson | Texas | 48239 | 505 | 14 |
495105 | 495105 | 2020-09-02 | Jackson | Texas | 48239 | 503 | 14 |
491871 | 491871 | 2020-09-01 | Jackson | Texas | 48239 | 502 | 14 |
488638 | 488638 | 2020-08-31 | Jackson | Texas | 48239 | 501 | 14 |
485405 | 485405 | 2020-08-30 | Jackson | Texas | 48239 | 501 | 14 |
482170 | 482170 | 2020-08-29 | Jackson | Texas | 48239 | 501 | 14 |
478936 | 478936 | 2020-08-28 | Jackson | Texas | 48239 | 496 | 14 |
475703 | 475703 | 2020-08-27 | Jackson | Texas | 48239 | 495 | 14 |
472470 | 472470 | 2020-08-26 | Jackson | Texas | 48239 | 492 | 13 |
469238 | 469238 | 2020-08-25 | Jackson | Texas | 48239 | 486 | 13 |
466009 | 466009 | 2020-08-24 | Jackson | Texas | 48239 | 477 | 13 |
462780 | 462780 | 2020-08-23 | Jackson | Texas | 48239 | 477 | 13 |
459551 | 459551 | 2020-08-22 | Jackson | Texas | 48239 | 477 | 13 |
456324 | 456324 | 2020-08-21 | Jackson | Texas | 48239 | 477 | 13 |
453096 | 453096 | 2020-08-20 | Jackson | Texas | 48239 | 463 | 13 |
449868 | 449868 | 2020-08-19 | Jackson | Texas | 48239 | 443 | 12 |
446640 | 446640 | 2020-08-18 | Jackson | Texas | 48239 | 438 | 11 |
443413 | 443413 | 2020-08-17 | Jackson | Texas | 48239 | 418 | 11 |
440187 | 440187 | 2020-08-16 | Jackson | Texas | 48239 | 418 | 11 |
436961 | 436961 | 2020-08-15 | Jackson | Texas | 48239 | 418 | 11 |
433735 | 433735 | 2020-08-14 | Jackson | Texas | 48239 | 415 | 11 |
430510 | 430510 | 2020-08-13 | Jackson | Texas | 48239 | 411 | 10 |
427283 | 427283 | 2020-08-12 | Jackson | Texas | 48239 | 411 | 9 |
424059 | 424059 | 2020-08-11 | Jackson | Texas | 48239 | 408 | 7 |
420838 | 420838 | 2020-08-10 | Jackson | Texas | 48239 | 406 | 7 |
417617 | 417617 | 2020-08-09 | Jackson | Texas | 48239 | 406 | 7 |
414396 | 414396 | 2020-08-08 | Jackson | Texas | 48239 | 406 | 6 |
411176 | 411176 | 2020-08-07 | Jackson | Texas | 48239 | 400 | 6 |
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);