ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jackson" and fips = 18071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921175 | 921175 | 2021-01-12 | Jackson | Indiana | 18071 | 4058 | 46 |
917930 | 917930 | 2021-01-11 | Jackson | Indiana | 18071 | 4046 | 46 |
914685 | 914685 | 2021-01-10 | Jackson | Indiana | 18071 | 4030 | 46 |
911440 | 911440 | 2021-01-09 | Jackson | Indiana | 18071 | 3999 | 46 |
908195 | 908195 | 2021-01-08 | Jackson | Indiana | 18071 | 3966 | 46 |
904949 | 904949 | 2021-01-07 | Jackson | Indiana | 18071 | 3944 | 46 |
901704 | 901704 | 2021-01-06 | Jackson | Indiana | 18071 | 3892 | 45 |
898459 | 898459 | 2021-01-05 | Jackson | Indiana | 18071 | 3868 | 45 |
895214 | 895214 | 2021-01-04 | Jackson | Indiana | 18071 | 3849 | 44 |
891967 | 891967 | 2021-01-03 | Jackson | Indiana | 18071 | 3838 | 44 |
888721 | 888721 | 2021-01-02 | Jackson | Indiana | 18071 | 3817 | 44 |
885475 | 885475 | 2021-01-01 | Jackson | Indiana | 18071 | 3792 | 44 |
882230 | 882230 | 2020-12-31 | Jackson | Indiana | 18071 | 3760 | 44 |
878985 | 878985 | 2020-12-30 | Jackson | Indiana | 18071 | 3712 | 44 |
875740 | 875740 | 2020-12-29 | Jackson | Indiana | 18071 | 3697 | 44 |
872495 | 872495 | 2020-12-28 | Jackson | Indiana | 18071 | 3681 | 43 |
869250 | 869250 | 2020-12-27 | Jackson | Indiana | 18071 | 3669 | 43 |
866005 | 866005 | 2020-12-26 | Jackson | Indiana | 18071 | 3662 | 43 |
862760 | 862760 | 2020-12-25 | Jackson | Indiana | 18071 | 3638 | 43 |
859515 | 859515 | 2020-12-24 | Jackson | Indiana | 18071 | 3605 | 43 |
856270 | 856270 | 2020-12-23 | Jackson | Indiana | 18071 | 3572 | 43 |
853025 | 853025 | 2020-12-22 | Jackson | Indiana | 18071 | 3540 | 42 |
849780 | 849780 | 2020-12-21 | Jackson | Indiana | 18071 | 3509 | 42 |
846535 | 846535 | 2020-12-20 | Jackson | Indiana | 18071 | 3475 | 42 |
843289 | 843289 | 2020-12-19 | Jackson | Indiana | 18071 | 3440 | 42 |
840044 | 840044 | 2020-12-18 | Jackson | Indiana | 18071 | 3417 | 42 |
836799 | 836799 | 2020-12-17 | Jackson | Indiana | 18071 | 3368 | 42 |
833553 | 833553 | 2020-12-16 | Jackson | Indiana | 18071 | 3320 | 42 |
830306 | 830306 | 2020-12-15 | Jackson | Indiana | 18071 | 3281 | 42 |
827060 | 827060 | 2020-12-14 | Jackson | Indiana | 18071 | 3236 | 42 |
823813 | 823813 | 2020-12-13 | Jackson | Indiana | 18071 | 3183 | 42 |
820567 | 820567 | 2020-12-12 | Jackson | Indiana | 18071 | 3158 | 42 |
817321 | 817321 | 2020-12-11 | Jackson | Indiana | 18071 | 3090 | 42 |
814075 | 814075 | 2020-12-10 | Jackson | Indiana | 18071 | 3031 | 42 |
810830 | 810830 | 2020-12-09 | Jackson | Indiana | 18071 | 2985 | 42 |
807585 | 807585 | 2020-12-08 | Jackson | Indiana | 18071 | 2944 | 41 |
804340 | 804340 | 2020-12-07 | Jackson | Indiana | 18071 | 2911 | 39 |
801095 | 801095 | 2020-12-06 | Jackson | Indiana | 18071 | 2834 | 39 |
797850 | 797850 | 2020-12-05 | Jackson | Indiana | 18071 | 2777 | 39 |
794605 | 794605 | 2020-12-04 | Jackson | Indiana | 18071 | 2722 | 39 |
791360 | 791360 | 2020-12-03 | Jackson | Indiana | 18071 | 2670 | 39 |
788115 | 788115 | 2020-12-02 | Jackson | Indiana | 18071 | 2556 | 38 |
784871 | 784871 | 2020-12-01 | Jackson | Indiana | 18071 | 2482 | 35 |
781626 | 781626 | 2020-11-30 | Jackson | Indiana | 18071 | 2424 | 35 |
778380 | 778380 | 2020-11-29 | Jackson | Indiana | 18071 | 2359 | 35 |
775135 | 775135 | 2020-11-28 | Jackson | Indiana | 18071 | 2310 | 35 |
771890 | 771890 | 2020-11-27 | Jackson | Indiana | 18071 | 2267 | 35 |
768645 | 768645 | 2020-11-26 | Jackson | Indiana | 18071 | 2230 | 35 |
765399 | 765399 | 2020-11-25 | Jackson | Indiana | 18071 | 2159 | 35 |
762154 | 762154 | 2020-11-24 | Jackson | Indiana | 18071 | 2130 | 34 |
758909 | 758909 | 2020-11-23 | Jackson | Indiana | 18071 | 2067 | 34 |
755662 | 755662 | 2020-11-22 | Jackson | Indiana | 18071 | 2005 | 34 |
752416 | 752416 | 2020-11-21 | Jackson | Indiana | 18071 | 1957 | 34 |
749170 | 749170 | 2020-11-20 | Jackson | Indiana | 18071 | 1921 | 33 |
745924 | 745924 | 2020-11-19 | Jackson | Indiana | 18071 | 1881 | 33 |
742677 | 742677 | 2020-11-18 | Jackson | Indiana | 18071 | 1827 | 32 |
739430 | 739430 | 2020-11-17 | Jackson | Indiana | 18071 | 1784 | 32 |
736186 | 736186 | 2020-11-16 | Jackson | Indiana | 18071 | 1737 | 30 |
732940 | 732940 | 2020-11-15 | Jackson | Indiana | 18071 | 1704 | 30 |
729695 | 729695 | 2020-11-14 | Jackson | Indiana | 18071 | 1679 | 30 |
726452 | 726452 | 2020-11-13 | Jackson | Indiana | 18071 | 1640 | 30 |
723209 | 723209 | 2020-11-12 | Jackson | Indiana | 18071 | 1593 | 29 |
719966 | 719966 | 2020-11-11 | Jackson | Indiana | 18071 | 1568 | 29 |
716723 | 716723 | 2020-11-10 | Jackson | Indiana | 18071 | 1533 | 27 |
713479 | 713479 | 2020-11-09 | Jackson | Indiana | 18071 | 1485 | 26 |
710235 | 710235 | 2020-11-08 | Jackson | Indiana | 18071 | 1466 | 25 |
706991 | 706991 | 2020-11-07 | Jackson | Indiana | 18071 | 1449 | 23 |
703748 | 703748 | 2020-11-06 | Jackson | Indiana | 18071 | 1417 | 23 |
700506 | 700506 | 2020-11-05 | Jackson | Indiana | 18071 | 1395 | 23 |
697262 | 697262 | 2020-11-04 | Jackson | Indiana | 18071 | 1372 | 21 |
694020 | 694020 | 2020-11-03 | Jackson | Indiana | 18071 | 1354 | 21 |
690777 | 690777 | 2020-11-02 | Jackson | Indiana | 18071 | 1331 | 21 |
687532 | 687532 | 2020-11-01 | Jackson | Indiana | 18071 | 1303 | 21 |
684288 | 684288 | 2020-10-31 | Jackson | Indiana | 18071 | 1290 | 21 |
681045 | 681045 | 2020-10-30 | Jackson | Indiana | 18071 | 1273 | 21 |
677802 | 677802 | 2020-10-29 | Jackson | Indiana | 18071 | 1258 | 21 |
674559 | 674559 | 2020-10-28 | Jackson | Indiana | 18071 | 1237 | 20 |
671317 | 671317 | 2020-10-27 | Jackson | Indiana | 18071 | 1229 | 20 |
668074 | 668074 | 2020-10-26 | Jackson | Indiana | 18071 | 1214 | 19 |
664830 | 664830 | 2020-10-25 | Jackson | Indiana | 18071 | 1189 | 18 |
661585 | 661585 | 2020-10-24 | Jackson | Indiana | 18071 | 1168 | 18 |
658341 | 658341 | 2020-10-23 | Jackson | Indiana | 18071 | 1148 | 17 |
655096 | 655096 | 2020-10-22 | Jackson | Indiana | 18071 | 1133 | 16 |
651851 | 651851 | 2020-10-21 | Jackson | Indiana | 18071 | 1098 | 14 |
648607 | 648607 | 2020-10-20 | Jackson | Indiana | 18071 | 1091 | 14 |
645362 | 645362 | 2020-10-19 | Jackson | Indiana | 18071 | 1078 | 13 |
642115 | 642115 | 2020-10-18 | Jackson | Indiana | 18071 | 1068 | 13 |
638868 | 638868 | 2020-10-17 | Jackson | Indiana | 18071 | 1048 | 13 |
635622 | 635622 | 2020-10-16 | Jackson | Indiana | 18071 | 1014 | 12 |
632376 | 632376 | 2020-10-15 | Jackson | Indiana | 18071 | 990 | 11 |
629132 | 629132 | 2020-10-14 | Jackson | Indiana | 18071 | 968 | 11 |
625889 | 625889 | 2020-10-13 | Jackson | Indiana | 18071 | 960 | 11 |
622647 | 622647 | 2020-10-12 | Jackson | Indiana | 18071 | 950 | 11 |
619403 | 619403 | 2020-10-11 | Jackson | Indiana | 18071 | 931 | 11 |
616161 | 616161 | 2020-10-10 | Jackson | Indiana | 18071 | 911 | 11 |
612920 | 612920 | 2020-10-09 | Jackson | Indiana | 18071 | 894 | 11 |
609678 | 609678 | 2020-10-08 | Jackson | Indiana | 18071 | 873 | 11 |
606435 | 606435 | 2020-10-07 | Jackson | Indiana | 18071 | 868 | 11 |
603193 | 603193 | 2020-10-06 | Jackson | Indiana | 18071 | 865 | 11 |
599950 | 599950 | 2020-10-05 | Jackson | Indiana | 18071 | 835 | 11 |
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);