ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" and fips = 1071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917228 | 917228 | 2021-01-11 | Jackson | Alabama | 1071 | 5631 | 34 |
913983 | 913983 | 2021-01-10 | Jackson | Alabama | 1071 | 5611 | 34 |
910738 | 910738 | 2021-01-09 | Jackson | Alabama | 1071 | 5567 | 34 |
907493 | 907493 | 2021-01-08 | Jackson | Alabama | 1071 | 5495 | 34 |
904247 | 904247 | 2021-01-07 | Jackson | Alabama | 1071 | 5466 | 34 |
901002 | 901002 | 2021-01-06 | Jackson | Alabama | 1071 | 5420 | 34 |
897757 | 897757 | 2021-01-05 | Jackson | Alabama | 1071 | 5324 | 34 |
894511 | 894511 | 2021-01-04 | Jackson | Alabama | 1071 | 5265 | 34 |
891265 | 891265 | 2021-01-03 | Jackson | Alabama | 1071 | 5254 | 34 |
888018 | 888018 | 2021-01-02 | Jackson | Alabama | 1071 | 5217 | 34 |
884773 | 884773 | 2021-01-01 | Jackson | Alabama | 1071 | 5183 | 34 |
881528 | 881528 | 2020-12-31 | Jackson | Alabama | 1071 | 5097 | 34 |
878283 | 878283 | 2020-12-30 | Jackson | Alabama | 1071 | 5028 | 34 |
875038 | 875038 | 2020-12-29 | Jackson | Alabama | 1071 | 4959 | 34 |
871793 | 871793 | 2020-12-28 | Jackson | Alabama | 1071 | 4915 | 34 |
868548 | 868548 | 2020-12-27 | Jackson | Alabama | 1071 | 4897 | 34 |
865303 | 865303 | 2020-12-26 | Jackson | Alabama | 1071 | 4884 | 34 |
862058 | 862058 | 2020-12-25 | Jackson | Alabama | 1071 | 4872 | 34 |
858813 | 858813 | 2020-12-24 | Jackson | Alabama | 1071 | 4834 | 34 |
855568 | 855568 | 2020-12-23 | Jackson | Alabama | 1071 | 4787 | 34 |
852323 | 852323 | 2020-12-22 | Jackson | Alabama | 1071 | 4737 | 33 |
849078 | 849078 | 2020-12-21 | Jackson | Alabama | 1071 | 4703 | 31 |
845833 | 845833 | 2020-12-20 | Jackson | Alabama | 1071 | 4689 | 31 |
842587 | 842587 | 2020-12-19 | Jackson | Alabama | 1071 | 4641 | 31 |
839342 | 839342 | 2020-12-18 | Jackson | Alabama | 1071 | 4595 | 29 |
836097 | 836097 | 2020-12-17 | Jackson | Alabama | 1071 | 4544 | 28 |
832851 | 832851 | 2020-12-16 | Jackson | Alabama | 1071 | 4505 | 28 |
829604 | 829604 | 2020-12-15 | Jackson | Alabama | 1071 | 4433 | 27 |
826358 | 826358 | 2020-12-14 | Jackson | Alabama | 1071 | 4387 | 26 |
823111 | 823111 | 2020-12-13 | Jackson | Alabama | 1071 | 4361 | 26 |
819865 | 819865 | 2020-12-12 | Jackson | Alabama | 1071 | 4306 | 26 |
816619 | 816619 | 2020-12-11 | Jackson | Alabama | 1071 | 4232 | 25 |
813373 | 813373 | 2020-12-10 | Jackson | Alabama | 1071 | 4188 | 24 |
810129 | 810129 | 2020-12-09 | Jackson | Alabama | 1071 | 4121 | 24 |
806884 | 806884 | 2020-12-08 | Jackson | Alabama | 1071 | 4021 | 23 |
803639 | 803639 | 2020-12-07 | Jackson | Alabama | 1071 | 3926 | 23 |
800394 | 800394 | 2020-12-06 | Jackson | Alabama | 1071 | 3896 | 23 |
797149 | 797149 | 2020-12-05 | Jackson | Alabama | 1071 | 3839 | 23 |
793904 | 793904 | 2020-12-04 | Jackson | Alabama | 1071 | 3735 | 23 |
790659 | 790659 | 2020-12-03 | Jackson | Alabama | 1071 | 3616 | 23 |
787414 | 787414 | 2020-12-02 | Jackson | Alabama | 1071 | 3507 | 23 |
784170 | 784170 | 2020-12-01 | Jackson | Alabama | 1071 | 3404 | 23 |
780925 | 780925 | 2020-11-30 | Jackson | Alabama | 1071 | 3298 | 23 |
777679 | 777679 | 2020-11-29 | Jackson | Alabama | 1071 | 3271 | 23 |
774434 | 774434 | 2020-11-28 | Jackson | Alabama | 1071 | 3204 | 23 |
771189 | 771189 | 2020-11-27 | Jackson | Alabama | 1071 | 3134 | 23 |
767943 | 767943 | 2020-11-26 | Jackson | Alabama | 1071 | 3117 | 23 |
764698 | 764698 | 2020-11-25 | Jackson | Alabama | 1071 | 3076 | 24 |
761453 | 761453 | 2020-11-24 | Jackson | Alabama | 1071 | 3025 | 24 |
758208 | 758208 | 2020-11-23 | Jackson | Alabama | 1071 | 2919 | 24 |
754961 | 754961 | 2020-11-22 | Jackson | Alabama | 1071 | 2905 | 24 |
751715 | 751715 | 2020-11-21 | Jackson | Alabama | 1071 | 2885 | 24 |
748469 | 748469 | 2020-11-20 | Jackson | Alabama | 1071 | 2837 | 24 |
745223 | 745223 | 2020-11-19 | Jackson | Alabama | 1071 | 2800 | 24 |
741976 | 741976 | 2020-11-18 | Jackson | Alabama | 1071 | 2769 | 24 |
738729 | 738729 | 2020-11-17 | Jackson | Alabama | 1071 | 2741 | 24 |
735485 | 735485 | 2020-11-16 | Jackson | Alabama | 1071 | 2728 | 23 |
732239 | 732239 | 2020-11-15 | Jackson | Alabama | 1071 | 2719 | 23 |
728994 | 728994 | 2020-11-14 | Jackson | Alabama | 1071 | 2688 | 23 |
725751 | 725751 | 2020-11-13 | Jackson | Alabama | 1071 | 2644 | 23 |
722508 | 722508 | 2020-11-12 | Jackson | Alabama | 1071 | 2595 | 23 |
719265 | 719265 | 2020-11-11 | Jackson | Alabama | 1071 | 2563 | 23 |
716022 | 716022 | 2020-11-10 | Jackson | Alabama | 1071 | 2509 | 23 |
712778 | 712778 | 2020-11-09 | Jackson | Alabama | 1071 | 2491 | 22 |
709534 | 709534 | 2020-11-08 | Jackson | Alabama | 1071 | 2476 | 22 |
706290 | 706290 | 2020-11-07 | Jackson | Alabama | 1071 | 2465 | 22 |
703047 | 703047 | 2020-11-06 | Jackson | Alabama | 1071 | 2439 | 21 |
699804 | 699804 | 2020-11-05 | Jackson | Alabama | 1071 | 2422 | 21 |
696560 | 696560 | 2020-11-04 | Jackson | Alabama | 1071 | 2386 | 19 |
693318 | 693318 | 2020-11-03 | Jackson | Alabama | 1071 | 2363 | 19 |
690075 | 690075 | 2020-11-02 | Jackson | Alabama | 1071 | 2359 | 19 |
686830 | 686830 | 2020-11-01 | Jackson | Alabama | 1071 | 2347 | 19 |
683586 | 683586 | 2020-10-31 | Jackson | Alabama | 1071 | 2321 | 19 |
680343 | 680343 | 2020-10-30 | Jackson | Alabama | 1071 | 2282 | 18 |
677100 | 677100 | 2020-10-29 | Jackson | Alabama | 1071 | 2253 | 17 |
673857 | 673857 | 2020-10-28 | Jackson | Alabama | 1071 | 2219 | 17 |
670615 | 670615 | 2020-10-27 | Jackson | Alabama | 1071 | 2194 | 17 |
667372 | 667372 | 2020-10-26 | Jackson | Alabama | 1071 | 2175 | 15 |
664127 | 664127 | 2020-10-25 | Jackson | Alabama | 1071 | 2159 | 15 |
660883 | 660883 | 2020-10-24 | Jackson | Alabama | 1071 | 2149 | 15 |
657639 | 657639 | 2020-10-23 | Jackson | Alabama | 1071 | 2125 | 15 |
654394 | 654394 | 2020-10-22 | Jackson | Alabama | 1071 | 2100 | 15 |
651149 | 651149 | 2020-10-21 | Jackson | Alabama | 1071 | 2055 | 15 |
647905 | 647905 | 2020-10-20 | Jackson | Alabama | 1071 | 2009 | 15 |
644660 | 644660 | 2020-10-19 | Jackson | Alabama | 1071 | 1991 | 14 |
641412 | 641412 | 2020-10-18 | Jackson | Alabama | 1071 | 1979 | 14 |
638165 | 638165 | 2020-10-17 | Jackson | Alabama | 1071 | 1964 | 14 |
634920 | 634920 | 2020-10-16 | Jackson | Alabama | 1071 | 1943 | 14 |
631675 | 631675 | 2020-10-15 | Jackson | Alabama | 1071 | 1901 | 13 |
628431 | 628431 | 2020-10-14 | Jackson | Alabama | 1071 | 1876 | 13 |
625188 | 625188 | 2020-10-13 | Jackson | Alabama | 1071 | 1845 | 12 |
621945 | 621945 | 2020-10-12 | Jackson | Alabama | 1071 | 1834 | 12 |
618702 | 618702 | 2020-10-11 | Jackson | Alabama | 1071 | 1818 | 12 |
615460 | 615460 | 2020-10-10 | Jackson | Alabama | 1071 | 1799 | 12 |
612219 | 612219 | 2020-10-09 | Jackson | Alabama | 1071 | 1777 | 12 |
608977 | 608977 | 2020-10-08 | Jackson | Alabama | 1071 | 1745 | 12 |
605734 | 605734 | 2020-10-07 | Jackson | Alabama | 1071 | 1735 | 12 |
602492 | 602492 | 2020-10-06 | Jackson | Alabama | 1071 | 1705 | 12 |
599249 | 599249 | 2020-10-05 | Jackson | Alabama | 1071 | 1694 | 12 |
596006 | 596006 | 2020-10-04 | Jackson | Alabama | 1071 | 1690 | 12 |
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);