ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1129 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050323 | 1050323 | 2021-02-21 | Washington | Alabama | 1129 | 1546 | 32 |
1047076 | 1047076 | 2021-02-20 | Washington | Alabama | 1129 | 1542 | 32 |
1043831 | 1043831 | 2021-02-19 | Washington | Alabama | 1129 | 1540 | 32 |
1040586 | 1040586 | 2021-02-18 | Washington | Alabama | 1129 | 1534 | 31 |
1037341 | 1037341 | 2021-02-17 | Washington | Alabama | 1129 | 1533 | 31 |
1034096 | 1034096 | 2021-02-16 | Washington | Alabama | 1129 | 1534 | 31 |
1030850 | 1030850 | 2021-02-15 | Washington | Alabama | 1129 | 1532 | 31 |
1027603 | 1027603 | 2021-02-14 | Washington | Alabama | 1129 | 1528 | 31 |
1024358 | 1024358 | 2021-02-13 | Washington | Alabama | 1129 | 1525 | 31 |
1021113 | 1021113 | 2021-02-12 | Washington | Alabama | 1129 | 1519 | 31 |
1017868 | 1017868 | 2021-02-11 | Washington | Alabama | 1129 | 1513 | 31 |
1014623 | 1014623 | 2021-02-10 | Washington | Alabama | 1129 | 1503 | 30 |
1011378 | 1011378 | 2021-02-09 | Washington | Alabama | 1129 | 1503 | 30 |
1008132 | 1008132 | 2021-02-08 | Washington | Alabama | 1129 | 1501 | 29 |
1004886 | 1004886 | 2021-02-07 | Washington | Alabama | 1129 | 1495 | 29 |
1001640 | 1001640 | 2021-02-06 | Washington | Alabama | 1129 | 1491 | 29 |
998394 | 998394 | 2021-02-05 | Washington | Alabama | 1129 | 1485 | 29 |
995148 | 995148 | 2021-02-04 | Washington | Alabama | 1129 | 1478 | 29 |
991902 | 991902 | 2021-02-03 | Washington | Alabama | 1129 | 1483 | 29 |
988656 | 988656 | 2021-02-02 | Washington | Alabama | 1129 | 1481 | 27 |
985409 | 985409 | 2021-02-01 | Washington | Alabama | 1129 | 1476 | 27 |
982162 | 982162 | 2021-01-31 | Washington | Alabama | 1129 | 1474 | 27 |
978916 | 978916 | 2021-01-30 | Washington | Alabama | 1129 | 1464 | 27 |
975671 | 975671 | 2021-01-29 | Washington | Alabama | 1129 | 1464 | 27 |
972426 | 972426 | 2021-01-28 | Washington | Alabama | 1129 | 1454 | 27 |
969181 | 969181 | 2021-01-27 | Washington | Alabama | 1129 | 1447 | 27 |
965937 | 965937 | 2021-01-26 | Washington | Alabama | 1129 | 1440 | 27 |
962692 | 962692 | 2021-01-25 | Washington | Alabama | 1129 | 1427 | 27 |
959447 | 959447 | 2021-01-24 | Washington | Alabama | 1129 | 1423 | 27 |
956201 | 956201 | 2021-01-23 | Washington | Alabama | 1129 | 1417 | 27 |
952956 | 952956 | 2021-01-22 | Washington | Alabama | 1129 | 1401 | 27 |
949711 | 949711 | 2021-01-21 | Washington | Alabama | 1129 | 1395 | 27 |
946465 | 946465 | 2021-01-20 | Washington | Alabama | 1129 | 1391 | 26 |
943218 | 943218 | 2021-01-19 | Washington | Alabama | 1129 | 1383 | 26 |
939973 | 939973 | 2021-01-18 | Washington | Alabama | 1129 | 1377 | 26 |
936728 | 936728 | 2021-01-17 | Washington | Alabama | 1129 | 1376 | 26 |
933483 | 933483 | 2021-01-16 | Washington | Alabama | 1129 | 1370 | 26 |
930238 | 930238 | 2021-01-15 | Washington | Alabama | 1129 | 1365 | 26 |
926993 | 926993 | 2021-01-14 | Washington | Alabama | 1129 | 1354 | 26 |
923747 | 923747 | 2021-01-13 | Washington | Alabama | 1129 | 1342 | 26 |
920502 | 920502 | 2021-01-12 | Washington | Alabama | 1129 | 1326 | 26 |
917257 | 917257 | 2021-01-11 | Washington | Alabama | 1129 | 1323 | 26 |
914012 | 914012 | 2021-01-10 | Washington | Alabama | 1129 | 1320 | 26 |
910767 | 910767 | 2021-01-09 | Washington | Alabama | 1129 | 1312 | 26 |
907522 | 907522 | 2021-01-08 | Washington | Alabama | 1129 | 1305 | 26 |
904276 | 904276 | 2021-01-07 | Washington | Alabama | 1129 | 1283 | 26 |
901031 | 901031 | 2021-01-06 | Washington | Alabama | 1129 | 1256 | 24 |
897786 | 897786 | 2021-01-05 | Washington | Alabama | 1129 | 1244 | 24 |
894540 | 894540 | 2021-01-04 | Washington | Alabama | 1129 | 1234 | 24 |
891294 | 891294 | 2021-01-03 | Washington | Alabama | 1129 | 1224 | 24 |
888047 | 888047 | 2021-01-02 | Washington | Alabama | 1129 | 1211 | 24 |
884802 | 884802 | 2021-01-01 | Washington | Alabama | 1129 | 1199 | 24 |
881557 | 881557 | 2020-12-31 | Washington | Alabama | 1129 | 1184 | 24 |
878312 | 878312 | 2020-12-30 | Washington | Alabama | 1129 | 1176 | 24 |
875067 | 875067 | 2020-12-29 | Washington | Alabama | 1129 | 1165 | 24 |
871822 | 871822 | 2020-12-28 | Washington | Alabama | 1129 | 1159 | 24 |
868577 | 868577 | 2020-12-27 | Washington | Alabama | 1129 | 1158 | 24 |
865332 | 865332 | 2020-12-26 | Washington | Alabama | 1129 | 1149 | 24 |
862087 | 862087 | 2020-12-25 | Washington | Alabama | 1129 | 1145 | 24 |
858842 | 858842 | 2020-12-24 | Washington | Alabama | 1129 | 1138 | 24 |
855597 | 855597 | 2020-12-23 | Washington | Alabama | 1129 | 1125 | 24 |
852352 | 852352 | 2020-12-22 | Washington | Alabama | 1129 | 1121 | 23 |
849107 | 849107 | 2020-12-21 | Washington | Alabama | 1129 | 1109 | 23 |
845862 | 845862 | 2020-12-20 | Washington | Alabama | 1129 | 1105 | 23 |
842616 | 842616 | 2020-12-19 | Washington | Alabama | 1129 | 1086 | 23 |
839371 | 839371 | 2020-12-18 | Washington | Alabama | 1129 | 1073 | 23 |
836126 | 836126 | 2020-12-17 | Washington | Alabama | 1129 | 1052 | 23 |
832880 | 832880 | 2020-12-16 | Washington | Alabama | 1129 | 1041 | 23 |
829633 | 829633 | 2020-12-15 | Washington | Alabama | 1129 | 1037 | 23 |
826387 | 826387 | 2020-12-14 | Washington | Alabama | 1129 | 1032 | 23 |
823140 | 823140 | 2020-12-13 | Washington | Alabama | 1129 | 1026 | 23 |
819894 | 819894 | 2020-12-12 | Washington | Alabama | 1129 | 1020 | 23 |
816648 | 816648 | 2020-12-11 | Washington | Alabama | 1129 | 1003 | 22 |
813402 | 813402 | 2020-12-10 | Washington | Alabama | 1129 | 992 | 22 |
810158 | 810158 | 2020-12-09 | Washington | Alabama | 1129 | 980 | 22 |
806913 | 806913 | 2020-12-08 | Washington | Alabama | 1129 | 969 | 22 |
803668 | 803668 | 2020-12-07 | Washington | Alabama | 1129 | 965 | 22 |
800423 | 800423 | 2020-12-06 | Washington | Alabama | 1129 | 952 | 22 |
797178 | 797178 | 2020-12-05 | Washington | Alabama | 1129 | 944 | 22 |
793933 | 793933 | 2020-12-04 | Washington | Alabama | 1129 | 942 | 22 |
790688 | 790688 | 2020-12-03 | Washington | Alabama | 1129 | 939 | 21 |
787443 | 787443 | 2020-12-02 | Washington | Alabama | 1129 | 933 | 19 |
784199 | 784199 | 2020-12-01 | Washington | Alabama | 1129 | 932 | 19 |
780954 | 780954 | 2020-11-30 | Washington | Alabama | 1129 | 922 | 19 |
777708 | 777708 | 2020-11-29 | Washington | Alabama | 1129 | 916 | 19 |
774463 | 774463 | 2020-11-28 | Washington | Alabama | 1129 | 912 | 19 |
771218 | 771218 | 2020-11-27 | Washington | Alabama | 1129 | 909 | 19 |
767972 | 767972 | 2020-11-26 | Washington | Alabama | 1129 | 907 | 19 |
764727 | 764727 | 2020-11-25 | Washington | Alabama | 1129 | 902 | 19 |
761482 | 761482 | 2020-11-24 | Washington | Alabama | 1129 | 899 | 18 |
758237 | 758237 | 2020-11-23 | Washington | Alabama | 1129 | 900 | 18 |
754990 | 754990 | 2020-11-22 | Washington | Alabama | 1129 | 898 | 18 |
751744 | 751744 | 2020-11-21 | Washington | Alabama | 1129 | 896 | 18 |
748498 | 748498 | 2020-11-20 | Washington | Alabama | 1129 | 891 | 18 |
745252 | 745252 | 2020-11-19 | Washington | Alabama | 1129 | 884 | 17 |
742005 | 742005 | 2020-11-18 | Washington | Alabama | 1129 | 878 | 17 |
738758 | 738758 | 2020-11-17 | Washington | Alabama | 1129 | 880 | 17 |
735514 | 735514 | 2020-11-16 | Washington | Alabama | 1129 | 877 | 12 |
732268 | 732268 | 2020-11-15 | Washington | Alabama | 1129 | 875 | 12 |
729023 | 729023 | 2020-11-14 | Washington | Alabama | 1129 | 869 | 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);