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 |
---|---|---|---|---|---|---|---|
1193144 | 1193144 | 2021-04-06 | Jackson | Alabama | 1071 | 6744 | 108 |
1189894 | 1189894 | 2021-04-05 | Jackson | Alabama | 1071 | 6742 | 108 |
1186647 | 1186647 | 2021-04-04 | Jackson | Alabama | 1071 | 6742 | 108 |
1183400 | 1183400 | 2021-04-03 | Jackson | Alabama | 1071 | 6742 | 108 |
1180153 | 1180153 | 2021-04-02 | Jackson | Alabama | 1071 | 6738 | 107 |
1176906 | 1176906 | 2021-04-01 | Jackson | Alabama | 1071 | 6733 | 106 |
1173659 | 1173659 | 2021-03-31 | Jackson | Alabama | 1071 | 6724 | 106 |
1170412 | 1170412 | 2021-03-30 | Jackson | Alabama | 1071 | 6723 | 106 |
1167164 | 1167164 | 2021-03-29 | Jackson | Alabama | 1071 | 6722 | 106 |
1163916 | 1163916 | 2021-03-28 | Jackson | Alabama | 1071 | 6720 | 106 |
1160668 | 1160668 | 2021-03-27 | Jackson | Alabama | 1071 | 6717 | 106 |
1157420 | 1157420 | 2021-03-26 | Jackson | Alabama | 1071 | 6714 | 106 |
1154173 | 1154173 | 2021-03-25 | Jackson | Alabama | 1071 | 6711 | 106 |
1150926 | 1150926 | 2021-03-24 | Jackson | Alabama | 1071 | 6704 | 106 |
1147679 | 1147679 | 2021-03-23 | Jackson | Alabama | 1071 | 6702 | 105 |
1144432 | 1144432 | 2021-03-22 | Jackson | Alabama | 1071 | 6705 | 105 |
1141185 | 1141185 | 2021-03-21 | Jackson | Alabama | 1071 | 6705 | 105 |
1137939 | 1137939 | 2021-03-20 | Jackson | Alabama | 1071 | 6702 | 105 |
1134693 | 1134693 | 2021-03-19 | Jackson | Alabama | 1071 | 6699 | 105 |
1131445 | 1131445 | 2021-03-18 | Jackson | Alabama | 1071 | 6687 | 105 |
1128198 | 1128198 | 2021-03-17 | Jackson | Alabama | 1071 | 6673 | 105 |
1124952 | 1124952 | 2021-03-16 | Jackson | Alabama | 1071 | 6662 | 105 |
1121706 | 1121706 | 2021-03-15 | Jackson | Alabama | 1071 | 6654 | 105 |
1118459 | 1118459 | 2021-03-14 | Jackson | Alabama | 1071 | 6578 | 105 |
1115212 | 1115212 | 2021-03-13 | Jackson | Alabama | 1071 | 6573 | 105 |
1111966 | 1111966 | 2021-03-12 | Jackson | Alabama | 1071 | 6570 | 105 |
1108720 | 1108720 | 2021-03-11 | Jackson | Alabama | 1071 | 6568 | 105 |
1105474 | 1105474 | 2021-03-10 | Jackson | Alabama | 1071 | 6558 | 105 |
1102228 | 1102228 | 2021-03-09 | Jackson | Alabama | 1071 | 6558 | 104 |
1098982 | 1098982 | 2021-03-08 | Jackson | Alabama | 1071 | 6554 | 104 |
1095734 | 1095734 | 2021-03-07 | Jackson | Alabama | 1071 | 6552 | 104 |
1092488 | 1092488 | 2021-03-06 | Jackson | Alabama | 1071 | 6551 | 104 |
1089242 | 1089242 | 2021-03-05 | Jackson | Alabama | 1071 | 6551 | 104 |
1085997 | 1085997 | 2021-03-04 | Jackson | Alabama | 1071 | 6545 | 104 |
1082751 | 1082751 | 2021-03-03 | Jackson | Alabama | 1071 | 6542 | 103 |
1079505 | 1079505 | 2021-03-02 | Jackson | Alabama | 1071 | 6503 | 103 |
1076260 | 1076260 | 2021-03-01 | Jackson | Alabama | 1071 | 6495 | 102 |
1073014 | 1073014 | 2021-02-28 | Jackson | Alabama | 1071 | 6492 | 102 |
1069768 | 1069768 | 2021-02-27 | Jackson | Alabama | 1071 | 6487 | 102 |
1066523 | 1066523 | 2021-02-26 | Jackson | Alabama | 1071 | 6483 | 102 |
1063278 | 1063278 | 2021-02-25 | Jackson | Alabama | 1071 | 6477 | 102 |
1060033 | 1060033 | 2021-02-24 | Jackson | Alabama | 1071 | 6466 | 102 |
1056787 | 1056787 | 2021-02-23 | Jackson | Alabama | 1071 | 6450 | 101 |
1053541 | 1053541 | 2021-02-22 | Jackson | Alabama | 1071 | 6442 | 99 |
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 |
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);