ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Jackson" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050294 | 1050294 | 2021-02-21 | Jackson | Alabama | 1071 | 6438 | 99 |
1047047 | 1047047 | 2021-02-20 | Jackson | Alabama | 1071 | 6428 | 99 |
1043802 | 1043802 | 2021-02-19 | Jackson | Alabama | 1071 | 6424 | 99 |
1040557 | 1040557 | 2021-02-18 | Jackson | Alabama | 1071 | 6421 | 95 |
1037312 | 1037312 | 2021-02-17 | Jackson | Alabama | 1071 | 6416 | 93 |
1034067 | 1034067 | 2021-02-16 | Jackson | Alabama | 1071 | 6418 | 92 |
1030821 | 1030821 | 2021-02-15 | Jackson | Alabama | 1071 | 6417 | 92 |
1027574 | 1027574 | 2021-02-14 | Jackson | Alabama | 1071 | 6413 | 92 |
1024329 | 1024329 | 2021-02-13 | Jackson | Alabama | 1071 | 6406 | 92 |
1021084 | 1021084 | 2021-02-12 | Jackson | Alabama | 1071 | 6398 | 88 |
1017839 | 1017839 | 2021-02-11 | Jackson | Alabama | 1071 | 6401 | 86 |
1014594 | 1014594 | 2021-02-10 | Jackson | Alabama | 1071 | 6374 | 84 |
1011349 | 1011349 | 2021-02-09 | Jackson | Alabama | 1071 | 6371 | 78 |
1008103 | 1008103 | 2021-02-08 | Jackson | Alabama | 1071 | 6370 | 78 |
1004857 | 1004857 | 2021-02-07 | Jackson | Alabama | 1071 | 6364 | 78 |
1001611 | 1001611 | 2021-02-06 | Jackson | Alabama | 1071 | 6352 | 78 |
998365 | 998365 | 2021-02-05 | Jackson | Alabama | 1071 | 6343 | 77 |
995119 | 995119 | 2021-02-04 | Jackson | Alabama | 1071 | 6333 | 77 |
991873 | 991873 | 2021-02-03 | Jackson | Alabama | 1071 | 6275 | 77 |
988627 | 988627 | 2021-02-02 | Jackson | Alabama | 1071 | 6254 | 73 |
985380 | 985380 | 2021-02-01 | Jackson | Alabama | 1071 | 6251 | 70 |
982133 | 982133 | 2021-01-31 | Jackson | Alabama | 1071 | 6245 | 70 |
978887 | 978887 | 2021-01-30 | Jackson | Alabama | 1071 | 6200 | 69 |
975642 | 975642 | 2021-01-29 | Jackson | Alabama | 1071 | 6200 | 69 |
972397 | 972397 | 2021-01-28 | Jackson | Alabama | 1071 | 6171 | 62 |
969152 | 969152 | 2021-01-27 | Jackson | Alabama | 1071 | 6115 | 57 |
965908 | 965908 | 2021-01-26 | Jackson | Alabama | 1071 | 6056 | 49 |
962663 | 962663 | 2021-01-25 | Jackson | Alabama | 1071 | 6032 | 45 |
959418 | 959418 | 2021-01-24 | Jackson | Alabama | 1071 | 6015 | 45 |
956172 | 956172 | 2021-01-23 | Jackson | Alabama | 1071 | 5991 | 45 |
952927 | 952927 | 2021-01-22 | Jackson | Alabama | 1071 | 5946 | 44 |
949682 | 949682 | 2021-01-21 | Jackson | Alabama | 1071 | 5903 | 41 |
946436 | 946436 | 2021-01-20 | Jackson | Alabama | 1071 | 5863 | 41 |
943189 | 943189 | 2021-01-19 | Jackson | Alabama | 1071 | 5837 | 41 |
939944 | 939944 | 2021-01-18 | Jackson | Alabama | 1071 | 5813 | 41 |
936699 | 936699 | 2021-01-17 | Jackson | Alabama | 1071 | 5803 | 41 |
933454 | 933454 | 2021-01-16 | Jackson | Alabama | 1071 | 5788 | 41 |
930209 | 930209 | 2021-01-15 | Jackson | Alabama | 1071 | 5744 | 41 |
926964 | 926964 | 2021-01-14 | Jackson | Alabama | 1071 | 5719 | 37 |
923718 | 923718 | 2021-01-13 | Jackson | Alabama | 1071 | 5691 | 36 |
920473 | 920473 | 2021-01-12 | Jackson | Alabama | 1071 | 5648 | 35 |
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 |
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);