ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1077 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193147 | 1193147 | 2021-04-06 | Lauderdale | Alabama | 1077 | 9165 | 227 |
1189897 | 1189897 | 2021-04-05 | Lauderdale | Alabama | 1077 | 9162 | 227 |
1186650 | 1186650 | 2021-04-04 | Lauderdale | Alabama | 1077 | 9159 | 227 |
1183403 | 1183403 | 2021-04-03 | Lauderdale | Alabama | 1077 | 9156 | 227 |
1180156 | 1180156 | 2021-04-02 | Lauderdale | Alabama | 1077 | 9148 | 223 |
1176909 | 1176909 | 2021-04-01 | Lauderdale | Alabama | 1077 | 9144 | 219 |
1173662 | 1173662 | 2021-03-31 | Lauderdale | Alabama | 1077 | 9140 | 219 |
1170415 | 1170415 | 2021-03-30 | Lauderdale | Alabama | 1077 | 9116 | 218 |
1167167 | 1167167 | 2021-03-29 | Lauderdale | Alabama | 1077 | 9102 | 218 |
1163919 | 1163919 | 2021-03-28 | Lauderdale | Alabama | 1077 | 9100 | 218 |
1160671 | 1160671 | 2021-03-27 | Lauderdale | Alabama | 1077 | 9089 | 218 |
1157423 | 1157423 | 2021-03-26 | Lauderdale | Alabama | 1077 | 9076 | 218 |
1154176 | 1154176 | 2021-03-25 | Lauderdale | Alabama | 1077 | 9070 | 218 |
1150929 | 1150929 | 2021-03-24 | Lauderdale | Alabama | 1077 | 9065 | 217 |
1147682 | 1147682 | 2021-03-23 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1144435 | 1144435 | 2021-03-22 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1141188 | 1141188 | 2021-03-21 | Lauderdale | Alabama | 1077 | 9024 | 217 |
1137942 | 1137942 | 2021-03-20 | Lauderdale | Alabama | 1077 | 9019 | 217 |
1134696 | 1134696 | 2021-03-19 | Lauderdale | Alabama | 1077 | 9007 | 217 |
1131448 | 1131448 | 2021-03-18 | Lauderdale | Alabama | 1077 | 9000 | 216 |
1128201 | 1128201 | 2021-03-17 | Lauderdale | Alabama | 1077 | 8993 | 216 |
1124955 | 1124955 | 2021-03-16 | Lauderdale | Alabama | 1077 | 8973 | 216 |
1121709 | 1121709 | 2021-03-15 | Lauderdale | Alabama | 1077 | 8962 | 216 |
1118462 | 1118462 | 2021-03-14 | Lauderdale | Alabama | 1077 | 8692 | 216 |
1115215 | 1115215 | 2021-03-13 | Lauderdale | Alabama | 1077 | 8683 | 216 |
1111969 | 1111969 | 2021-03-12 | Lauderdale | Alabama | 1077 | 8670 | 215 |
1108723 | 1108723 | 2021-03-11 | Lauderdale | Alabama | 1077 | 8662 | 214 |
1105477 | 1105477 | 2021-03-10 | Lauderdale | Alabama | 1077 | 8651 | 215 |
1102231 | 1102231 | 2021-03-09 | Lauderdale | Alabama | 1077 | 8636 | 214 |
1098985 | 1098985 | 2021-03-08 | Lauderdale | Alabama | 1077 | 8631 | 214 |
1095737 | 1095737 | 2021-03-07 | Lauderdale | Alabama | 1077 | 8630 | 214 |
1092491 | 1092491 | 2021-03-06 | Lauderdale | Alabama | 1077 | 8628 | 214 |
1089245 | 1089245 | 2021-03-05 | Lauderdale | Alabama | 1077 | 8618 | 214 |
1086000 | 1086000 | 2021-03-04 | Lauderdale | Alabama | 1077 | 8612 | 214 |
1082754 | 1082754 | 2021-03-03 | Lauderdale | Alabama | 1077 | 8610 | 212 |
1079508 | 1079508 | 2021-03-02 | Lauderdale | Alabama | 1077 | 8601 | 212 |
1076263 | 1076263 | 2021-03-01 | Lauderdale | Alabama | 1077 | 8607 | 211 |
1073017 | 1073017 | 2021-02-28 | Lauderdale | Alabama | 1077 | 8603 | 211 |
1069771 | 1069771 | 2021-02-27 | Lauderdale | Alabama | 1077 | 8594 | 211 |
1066526 | 1066526 | 2021-02-26 | Lauderdale | Alabama | 1077 | 8588 | 210 |
1063281 | 1063281 | 2021-02-25 | Lauderdale | Alabama | 1077 | 8581 | 210 |
1060036 | 1060036 | 2021-02-24 | Lauderdale | Alabama | 1077 | 8570 | 210 |
1056790 | 1056790 | 2021-02-23 | Lauderdale | Alabama | 1077 | 8541 | 209 |
1053544 | 1053544 | 2021-02-22 | Lauderdale | Alabama | 1077 | 8525 | 208 |
1050297 | 1050297 | 2021-02-21 | Lauderdale | Alabama | 1077 | 8523 | 208 |
1047050 | 1047050 | 2021-02-20 | Lauderdale | Alabama | 1077 | 8515 | 208 |
1043805 | 1043805 | 2021-02-19 | Lauderdale | Alabama | 1077 | 8513 | 207 |
1040560 | 1040560 | 2021-02-18 | Lauderdale | Alabama | 1077 | 8508 | 205 |
1037315 | 1037315 | 2021-02-17 | Lauderdale | Alabama | 1077 | 8480 | 205 |
1034070 | 1034070 | 2021-02-16 | Lauderdale | Alabama | 1077 | 8479 | 201 |
1030824 | 1030824 | 2021-02-15 | Lauderdale | Alabama | 1077 | 8476 | 201 |
1027577 | 1027577 | 2021-02-14 | Lauderdale | Alabama | 1077 | 8471 | 201 |
1024332 | 1024332 | 2021-02-13 | Lauderdale | Alabama | 1077 | 8460 | 201 |
1021087 | 1021087 | 2021-02-12 | Lauderdale | Alabama | 1077 | 8442 | 201 |
1017842 | 1017842 | 2021-02-11 | Lauderdale | Alabama | 1077 | 8432 | 196 |
1014597 | 1014597 | 2021-02-10 | Lauderdale | Alabama | 1077 | 8411 | 193 |
1011352 | 1011352 | 2021-02-09 | Lauderdale | Alabama | 1077 | 8399 | 182 |
1008106 | 1008106 | 2021-02-08 | Lauderdale | Alabama | 1077 | 8380 | 179 |
1004860 | 1004860 | 2021-02-07 | Lauderdale | Alabama | 1077 | 8366 | 179 |
1001614 | 1001614 | 2021-02-06 | Lauderdale | Alabama | 1077 | 8350 | 179 |
998368 | 998368 | 2021-02-05 | Lauderdale | Alabama | 1077 | 8332 | 179 |
995122 | 995122 | 2021-02-04 | Lauderdale | Alabama | 1077 | 8298 | 176 |
991876 | 991876 | 2021-02-03 | Lauderdale | Alabama | 1077 | 8255 | 174 |
988630 | 988630 | 2021-02-02 | Lauderdale | Alabama | 1077 | 8216 | 160 |
985383 | 985383 | 2021-02-01 | Lauderdale | Alabama | 1077 | 8191 | 156 |
982136 | 982136 | 2021-01-31 | Lauderdale | Alabama | 1077 | 8180 | 156 |
978890 | 978890 | 2021-01-30 | Lauderdale | Alabama | 1077 | 8134 | 151 |
975645 | 975645 | 2021-01-29 | Lauderdale | Alabama | 1077 | 8134 | 151 |
972400 | 972400 | 2021-01-28 | Lauderdale | Alabama | 1077 | 8088 | 127 |
969155 | 969155 | 2021-01-27 | Lauderdale | Alabama | 1077 | 8049 | 121 |
965911 | 965911 | 2021-01-26 | Lauderdale | Alabama | 1077 | 7986 | 112 |
962666 | 962666 | 2021-01-25 | Lauderdale | Alabama | 1077 | 7946 | 107 |
959421 | 959421 | 2021-01-24 | Lauderdale | Alabama | 1077 | 7871 | 107 |
956175 | 956175 | 2021-01-23 | Lauderdale | Alabama | 1077 | 7847 | 107 |
952930 | 952930 | 2021-01-22 | Lauderdale | Alabama | 1077 | 7798 | 103 |
949685 | 949685 | 2021-01-21 | Lauderdale | Alabama | 1077 | 7733 | 99 |
946439 | 946439 | 2021-01-20 | Lauderdale | Alabama | 1077 | 7686 | 98 |
943192 | 943192 | 2021-01-19 | Lauderdale | Alabama | 1077 | 7631 | 83 |
939947 | 939947 | 2021-01-18 | Lauderdale | Alabama | 1077 | 7600 | 83 |
936702 | 936702 | 2021-01-17 | Lauderdale | Alabama | 1077 | 7546 | 83 |
933457 | 933457 | 2021-01-16 | Lauderdale | Alabama | 1077 | 7528 | 83 |
930212 | 930212 | 2021-01-15 | Lauderdale | Alabama | 1077 | 7451 | 83 |
926967 | 926967 | 2021-01-14 | Lauderdale | Alabama | 1077 | 7402 | 82 |
923721 | 923721 | 2021-01-13 | Lauderdale | Alabama | 1077 | 7350 | 81 |
920476 | 920476 | 2021-01-12 | Lauderdale | Alabama | 1077 | 7296 | 73 |
917231 | 917231 | 2021-01-11 | Lauderdale | Alabama | 1077 | 7214 | 72 |
913986 | 913986 | 2021-01-10 | Lauderdale | Alabama | 1077 | 7191 | 72 |
910741 | 910741 | 2021-01-09 | Lauderdale | Alabama | 1077 | 7149 | 72 |
907496 | 907496 | 2021-01-08 | Lauderdale | Alabama | 1077 | 7051 | 71 |
904250 | 904250 | 2021-01-07 | Lauderdale | Alabama | 1077 | 6930 | 71 |
901005 | 901005 | 2021-01-06 | Lauderdale | Alabama | 1077 | 6839 | 70 |
897760 | 897760 | 2021-01-05 | Lauderdale | Alabama | 1077 | 6766 | 70 |
894514 | 894514 | 2021-01-04 | Lauderdale | Alabama | 1077 | 6702 | 70 |
891268 | 891268 | 2021-01-03 | Lauderdale | Alabama | 1077 | 6682 | 70 |
888021 | 888021 | 2021-01-02 | Lauderdale | Alabama | 1077 | 6613 | 70 |
884776 | 884776 | 2021-01-01 | Lauderdale | Alabama | 1077 | 6566 | 70 |
881531 | 881531 | 2020-12-31 | Lauderdale | Alabama | 1077 | 6478 | 70 |
878286 | 878286 | 2020-12-30 | Lauderdale | Alabama | 1077 | 6371 | 69 |
875041 | 875041 | 2020-12-29 | Lauderdale | Alabama | 1077 | 6230 | 68 |
871796 | 871796 | 2020-12-28 | Lauderdale | Alabama | 1077 | 6162 | 68 |
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);