ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Jackson" and fips = 19097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921280 | 921280 | 2021-01-12 | Jackson | Iowa | 19097 | 1879 | 31 |
918035 | 918035 | 2021-01-11 | Jackson | Iowa | 19097 | 1863 | 31 |
914790 | 914790 | 2021-01-10 | Jackson | Iowa | 19097 | 1856 | 31 |
911545 | 911545 | 2021-01-09 | Jackson | Iowa | 19097 | 1853 | 31 |
908300 | 908300 | 2021-01-08 | Jackson | Iowa | 19097 | 1842 | 31 |
905054 | 905054 | 2021-01-07 | Jackson | Iowa | 19097 | 1833 | 30 |
901809 | 901809 | 2021-01-06 | Jackson | Iowa | 19097 | 1820 | 30 |
898564 | 898564 | 2021-01-05 | Jackson | Iowa | 19097 | 1811 | 29 |
895319 | 895319 | 2021-01-04 | Jackson | Iowa | 19097 | 1791 | 29 |
892072 | 892072 | 2021-01-03 | Jackson | Iowa | 19097 | 1788 | 29 |
888826 | 888826 | 2021-01-02 | Jackson | Iowa | 19097 | 1788 | 29 |
885580 | 885580 | 2021-01-01 | Jackson | Iowa | 19097 | 1785 | 29 |
882335 | 882335 | 2020-12-31 | Jackson | Iowa | 19097 | 1779 | 29 |
879090 | 879090 | 2020-12-30 | Jackson | Iowa | 19097 | 1768 | 29 |
875845 | 875845 | 2020-12-29 | Jackson | Iowa | 19097 | 1760 | 29 |
872600 | 872600 | 2020-12-28 | Jackson | Iowa | 19097 | 1752 | 29 |
869355 | 869355 | 2020-12-27 | Jackson | Iowa | 19097 | 1752 | 29 |
866110 | 866110 | 2020-12-26 | Jackson | Iowa | 19097 | 1752 | 29 |
862865 | 862865 | 2020-12-25 | Jackson | Iowa | 19097 | 1751 | 29 |
859620 | 859620 | 2020-12-24 | Jackson | Iowa | 19097 | 1744 | 29 |
856375 | 856375 | 2020-12-23 | Jackson | Iowa | 19097 | 1735 | 29 |
853130 | 853130 | 2020-12-22 | Jackson | Iowa | 19097 | 1725 | 29 |
849885 | 849885 | 2020-12-21 | Jackson | Iowa | 19097 | 1719 | 29 |
846640 | 846640 | 2020-12-20 | Jackson | Iowa | 19097 | 1719 | 29 |
843394 | 843394 | 2020-12-19 | Jackson | Iowa | 19097 | 1715 | 29 |
840149 | 840149 | 2020-12-18 | Jackson | Iowa | 19097 | 1706 | 25 |
836904 | 836904 | 2020-12-17 | Jackson | Iowa | 19097 | 1697 | 25 |
833658 | 833658 | 2020-12-16 | Jackson | Iowa | 19097 | 1692 | 23 |
830411 | 830411 | 2020-12-15 | Jackson | Iowa | 19097 | 1685 | 23 |
827165 | 827165 | 2020-12-14 | Jackson | Iowa | 19097 | 1673 | 23 |
823918 | 823918 | 2020-12-13 | Jackson | Iowa | 19097 | 1670 | 23 |
820672 | 820672 | 2020-12-12 | Jackson | Iowa | 19097 | 1662 | 23 |
817426 | 817426 | 2020-12-11 | Jackson | Iowa | 19097 | 1609 | 23 |
814180 | 814180 | 2020-12-10 | Jackson | Iowa | 19097 | 1595 | 23 |
810935 | 810935 | 2020-12-09 | Jackson | Iowa | 19097 | 1579 | 21 |
807690 | 807690 | 2020-12-08 | Jackson | Iowa | 19097 | 1555 | 18 |
804445 | 804445 | 2020-12-07 | Jackson | Iowa | 19097 | 1554 | 17 |
801200 | 801200 | 2020-12-06 | Jackson | Iowa | 19097 | 1548 | 17 |
797955 | 797955 | 2020-12-05 | Jackson | Iowa | 19097 | 1541 | 17 |
794710 | 794710 | 2020-12-04 | Jackson | Iowa | 19097 | 1527 | 17 |
791465 | 791465 | 2020-12-03 | Jackson | Iowa | 19097 | 1511 | 17 |
788220 | 788220 | 2020-12-02 | Jackson | Iowa | 19097 | 1488 | 14 |
784976 | 784976 | 2020-12-01 | Jackson | Iowa | 19097 | 1474 | 13 |
781731 | 781731 | 2020-11-30 | Jackson | Iowa | 19097 | 1465 | 13 |
778485 | 778485 | 2020-11-29 | Jackson | Iowa | 19097 | 1446 | 13 |
775240 | 775240 | 2020-11-28 | Jackson | Iowa | 19097 | 1443 | 13 |
771995 | 771995 | 2020-11-27 | Jackson | Iowa | 19097 | 1430 | 13 |
768750 | 768750 | 2020-11-26 | Jackson | Iowa | 19097 | 1421 | 13 |
765504 | 765504 | 2020-11-25 | Jackson | Iowa | 19097 | 1407 | 12 |
762259 | 762259 | 2020-11-24 | Jackson | Iowa | 19097 | 1385 | 11 |
759014 | 759014 | 2020-11-23 | Jackson | Iowa | 19097 | 1375 | 8 |
755767 | 755767 | 2020-11-22 | Jackson | Iowa | 19097 | 1360 | 8 |
752521 | 752521 | 2020-11-21 | Jackson | Iowa | 19097 | 1333 | 8 |
749275 | 749275 | 2020-11-20 | Jackson | Iowa | 19097 | 1308 | 8 |
746029 | 746029 | 2020-11-19 | Jackson | Iowa | 19097 | 1284 | 8 |
742782 | 742782 | 2020-11-18 | Jackson | Iowa | 19097 | 1270 | 8 |
739535 | 739535 | 2020-11-17 | Jackson | Iowa | 19097 | 1244 | 7 |
736291 | 736291 | 2020-11-16 | Jackson | Iowa | 19097 | 1216 | 6 |
733045 | 733045 | 2020-11-15 | Jackson | Iowa | 19097 | 1212 | 5 |
729800 | 729800 | 2020-11-14 | Jackson | Iowa | 19097 | 1201 | 5 |
726557 | 726557 | 2020-11-13 | Jackson | Iowa | 19097 | 1174 | 5 |
723314 | 723314 | 2020-11-12 | Jackson | Iowa | 19097 | 1128 | 5 |
720071 | 720071 | 2020-11-11 | Jackson | Iowa | 19097 | 1096 | 5 |
716828 | 716828 | 2020-11-10 | Jackson | Iowa | 19097 | 1070 | 5 |
713584 | 713584 | 2020-11-09 | Jackson | Iowa | 19097 | 1028 | 5 |
710340 | 710340 | 2020-11-08 | Jackson | Iowa | 19097 | 1015 | 5 |
707096 | 707096 | 2020-11-07 | Jackson | Iowa | 19097 | 964 | 5 |
703853 | 703853 | 2020-11-06 | Jackson | Iowa | 19097 | 918 | 5 |
700611 | 700611 | 2020-11-05 | Jackson | Iowa | 19097 | 882 | 5 |
697367 | 697367 | 2020-11-04 | Jackson | Iowa | 19097 | 831 | 5 |
694125 | 694125 | 2020-11-03 | Jackson | Iowa | 19097 | 810 | 4 |
690882 | 690882 | 2020-11-02 | Jackson | Iowa | 19097 | 796 | 3 |
687637 | 687637 | 2020-11-01 | Jackson | Iowa | 19097 | 769 | 3 |
684393 | 684393 | 2020-10-31 | Jackson | Iowa | 19097 | 750 | 3 |
681150 | 681150 | 2020-10-30 | Jackson | Iowa | 19097 | 722 | 3 |
677907 | 677907 | 2020-10-29 | Jackson | Iowa | 19097 | 689 | 3 |
674664 | 674664 | 2020-10-28 | Jackson | Iowa | 19097 | 666 | 3 |
671422 | 671422 | 2020-10-27 | Jackson | Iowa | 19097 | 647 | 3 |
668179 | 668179 | 2020-10-26 | Jackson | Iowa | 19097 | 633 | 3 |
664935 | 664935 | 2020-10-25 | Jackson | Iowa | 19097 | 628 | 3 |
661690 | 661690 | 2020-10-24 | Jackson | Iowa | 19097 | 603 | 3 |
658446 | 658446 | 2020-10-23 | Jackson | Iowa | 19097 | 579 | 3 |
655201 | 655201 | 2020-10-22 | Jackson | Iowa | 19097 | 563 | 3 |
651956 | 651956 | 2020-10-21 | Jackson | Iowa | 19097 | 548 | 3 |
648712 | 648712 | 2020-10-20 | Jackson | Iowa | 19097 | 539 | 3 |
645467 | 645467 | 2020-10-19 | Jackson | Iowa | 19097 | 528 | 3 |
642220 | 642220 | 2020-10-18 | Jackson | Iowa | 19097 | 525 | 3 |
638973 | 638973 | 2020-10-17 | Jackson | Iowa | 19097 | 518 | 3 |
635727 | 635727 | 2020-10-16 | Jackson | Iowa | 19097 | 508 | 3 |
632481 | 632481 | 2020-10-15 | Jackson | Iowa | 19097 | 491 | 3 |
629237 | 629237 | 2020-10-14 | Jackson | Iowa | 19097 | 468 | 3 |
625994 | 625994 | 2020-10-13 | Jackson | Iowa | 19097 | 463 | 3 |
622752 | 622752 | 2020-10-12 | Jackson | Iowa | 19097 | 456 | 3 |
619508 | 619508 | 2020-10-11 | Jackson | Iowa | 19097 | 453 | 3 |
616266 | 616266 | 2020-10-10 | Jackson | Iowa | 19097 | 446 | 3 |
613025 | 613025 | 2020-10-09 | Jackson | Iowa | 19097 | 437 | 3 |
609783 | 609783 | 2020-10-08 | Jackson | Iowa | 19097 | 433 | 3 |
606540 | 606540 | 2020-10-07 | Jackson | Iowa | 19097 | 418 | 3 |
603298 | 603298 | 2020-10-06 | Jackson | Iowa | 19097 | 412 | 3 |
600055 | 600055 | 2020-10-05 | Jackson | Iowa | 19097 | 409 | 3 |
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);