ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lee" and fips = 1081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193149 | 1193149 | 2021-04-06 | Lee | Alabama | 1081 | 15468 | 165 |
1189899 | 1189899 | 2021-04-05 | Lee | Alabama | 1081 | 15459 | 166 |
1186652 | 1186652 | 2021-04-04 | Lee | Alabama | 1081 | 15457 | 166 |
1183405 | 1183405 | 2021-04-03 | Lee | Alabama | 1081 | 15452 | 166 |
1180158 | 1180158 | 2021-04-02 | Lee | Alabama | 1081 | 15444 | 166 |
1176911 | 1176911 | 2021-04-01 | Lee | Alabama | 1081 | 15433 | 166 |
1173664 | 1173664 | 2021-03-31 | Lee | Alabama | 1081 | 15417 | 166 |
1170417 | 1170417 | 2021-03-30 | Lee | Alabama | 1081 | 15397 | 166 |
1167169 | 1167169 | 2021-03-29 | Lee | Alabama | 1081 | 15394 | 166 |
1163921 | 1163921 | 2021-03-28 | Lee | Alabama | 1081 | 15389 | 166 |
1160673 | 1160673 | 2021-03-27 | Lee | Alabama | 1081 | 15381 | 166 |
1157425 | 1157425 | 2021-03-26 | Lee | Alabama | 1081 | 15371 | 166 |
1154178 | 1154178 | 2021-03-25 | Lee | Alabama | 1081 | 15355 | 166 |
1150931 | 1150931 | 2021-03-24 | Lee | Alabama | 1081 | 15333 | 166 |
1147684 | 1147684 | 2021-03-23 | Lee | Alabama | 1081 | 15292 | 166 |
1144437 | 1144437 | 2021-03-22 | Lee | Alabama | 1081 | 15290 | 166 |
1141190 | 1141190 | 2021-03-21 | Lee | Alabama | 1081 | 15282 | 166 |
1137944 | 1137944 | 2021-03-20 | Lee | Alabama | 1081 | 15274 | 166 |
1134698 | 1134698 | 2021-03-19 | Lee | Alabama | 1081 | 15248 | 166 |
1131450 | 1131450 | 2021-03-18 | Lee | Alabama | 1081 | 15231 | 163 |
1128203 | 1128203 | 2021-03-17 | Lee | Alabama | 1081 | 15218 | 163 |
1124957 | 1124957 | 2021-03-16 | Lee | Alabama | 1081 | 15205 | 163 |
1121711 | 1121711 | 2021-03-15 | Lee | Alabama | 1081 | 15197 | 163 |
1118464 | 1118464 | 2021-03-14 | Lee | Alabama | 1081 | 15147 | 163 |
1115217 | 1115217 | 2021-03-13 | Lee | Alabama | 1081 | 15138 | 163 |
1111971 | 1111971 | 2021-03-12 | Lee | Alabama | 1081 | 15122 | 162 |
1108725 | 1108725 | 2021-03-11 | Lee | Alabama | 1081 | 15117 | 162 |
1105479 | 1105479 | 2021-03-10 | Lee | Alabama | 1081 | 15108 | 161 |
1102233 | 1102233 | 2021-03-09 | Lee | Alabama | 1081 | 15087 | 161 |
1098987 | 1098987 | 2021-03-08 | Lee | Alabama | 1081 | 15084 | 161 |
1095739 | 1095739 | 2021-03-07 | Lee | Alabama | 1081 | 15083 | 161 |
1092493 | 1092493 | 2021-03-06 | Lee | Alabama | 1081 | 15070 | 161 |
1089247 | 1089247 | 2021-03-05 | Lee | Alabama | 1081 | 15057 | 158 |
1086002 | 1086002 | 2021-03-04 | Lee | Alabama | 1081 | 15039 | 157 |
1082756 | 1082756 | 2021-03-03 | Lee | Alabama | 1081 | 15021 | 155 |
1079510 | 1079510 | 2021-03-02 | Lee | Alabama | 1081 | 14980 | 154 |
1076265 | 1076265 | 2021-03-01 | Lee | Alabama | 1081 | 14967 | 153 |
1073019 | 1073019 | 2021-02-28 | Lee | Alabama | 1081 | 14961 | 153 |
1069773 | 1069773 | 2021-02-27 | Lee | Alabama | 1081 | 14950 | 153 |
1066528 | 1066528 | 2021-02-26 | Lee | Alabama | 1081 | 14926 | 151 |
1063283 | 1063283 | 2021-02-25 | Lee | Alabama | 1081 | 14900 | 150 |
1060038 | 1060038 | 2021-02-24 | Lee | Alabama | 1081 | 14883 | 147 |
1056792 | 1056792 | 2021-02-23 | Lee | Alabama | 1081 | 14827 | 147 |
1053546 | 1053546 | 2021-02-22 | Lee | Alabama | 1081 | 14809 | 146 |
1050299 | 1050299 | 2021-02-21 | Lee | Alabama | 1081 | 14798 | 146 |
1047052 | 1047052 | 2021-02-20 | Lee | Alabama | 1081 | 14779 | 146 |
1043807 | 1043807 | 2021-02-19 | Lee | Alabama | 1081 | 14766 | 146 |
1040562 | 1040562 | 2021-02-18 | Lee | Alabama | 1081 | 14729 | 141 |
1037317 | 1037317 | 2021-02-17 | Lee | Alabama | 1081 | 14684 | 141 |
1034072 | 1034072 | 2021-02-16 | Lee | Alabama | 1081 | 14641 | 137 |
1030826 | 1030826 | 2021-02-15 | Lee | Alabama | 1081 | 14622 | 137 |
1027579 | 1027579 | 2021-02-14 | Lee | Alabama | 1081 | 14608 | 137 |
1024334 | 1024334 | 2021-02-13 | Lee | Alabama | 1081 | 14563 | 137 |
1021089 | 1021089 | 2021-02-12 | Lee | Alabama | 1081 | 14524 | 137 |
1017844 | 1017844 | 2021-02-11 | Lee | Alabama | 1081 | 14491 | 137 |
1014599 | 1014599 | 2021-02-10 | Lee | Alabama | 1081 | 14443 | 136 |
1011354 | 1011354 | 2021-02-09 | Lee | Alabama | 1081 | 14391 | 132 |
1008108 | 1008108 | 2021-02-08 | Lee | Alabama | 1081 | 14361 | 132 |
1004862 | 1004862 | 2021-02-07 | Lee | Alabama | 1081 | 14337 | 132 |
1001616 | 1001616 | 2021-02-06 | Lee | Alabama | 1081 | 14277 | 132 |
998370 | 998370 | 2021-02-05 | Lee | Alabama | 1081 | 14197 | 132 |
995124 | 995124 | 2021-02-04 | Lee | Alabama | 1081 | 14149 | 131 |
991878 | 991878 | 2021-02-03 | Lee | Alabama | 1081 | 14048 | 128 |
988632 | 988632 | 2021-02-02 | Lee | Alabama | 1081 | 13958 | 128 |
985385 | 985385 | 2021-02-01 | Lee | Alabama | 1081 | 13878 | 128 |
982138 | 982138 | 2021-01-31 | Lee | Alabama | 1081 | 13829 | 128 |
978892 | 978892 | 2021-01-30 | Lee | Alabama | 1081 | 13679 | 124 |
975647 | 975647 | 2021-01-29 | Lee | Alabama | 1081 | 13679 | 124 |
972402 | 972402 | 2021-01-28 | Lee | Alabama | 1081 | 13602 | 113 |
969157 | 969157 | 2021-01-27 | Lee | Alabama | 1081 | 13482 | 112 |
965913 | 965913 | 2021-01-26 | Lee | Alabama | 1081 | 13378 | 109 |
962668 | 962668 | 2021-01-25 | Lee | Alabama | 1081 | 13261 | 107 |
959423 | 959423 | 2021-01-24 | Lee | Alabama | 1081 | 13205 | 107 |
956177 | 956177 | 2021-01-23 | Lee | Alabama | 1081 | 13137 | 107 |
952932 | 952932 | 2021-01-22 | Lee | Alabama | 1081 | 13036 | 105 |
949687 | 949687 | 2021-01-21 | Lee | Alabama | 1081 | 12901 | 102 |
946441 | 946441 | 2021-01-20 | Lee | Alabama | 1081 | 12749 | 102 |
943194 | 943194 | 2021-01-19 | Lee | Alabama | 1081 | 12603 | 101 |
939949 | 939949 | 2021-01-18 | Lee | Alabama | 1081 | 12515 | 101 |
936704 | 936704 | 2021-01-17 | Lee | Alabama | 1081 | 12465 | 101 |
933459 | 933459 | 2021-01-16 | Lee | Alabama | 1081 | 12393 | 101 |
930214 | 930214 | 2021-01-15 | Lee | Alabama | 1081 | 12261 | 101 |
926969 | 926969 | 2021-01-14 | Lee | Alabama | 1081 | 12120 | 97 |
923723 | 923723 | 2021-01-13 | Lee | Alabama | 1081 | 11983 | 97 |
920478 | 920478 | 2021-01-12 | Lee | Alabama | 1081 | 11812 | 87 |
917233 | 917233 | 2021-01-11 | Lee | Alabama | 1081 | 11626 | 79 |
913988 | 913988 | 2021-01-10 | Lee | Alabama | 1081 | 11565 | 79 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
907498 | 907498 | 2021-01-08 | Lee | Alabama | 1081 | 11355 | 79 |
904252 | 904252 | 2021-01-07 | Lee | Alabama | 1081 | 11179 | 79 |
901007 | 901007 | 2021-01-06 | Lee | Alabama | 1081 | 10964 | 75 |
897762 | 897762 | 2021-01-05 | Lee | Alabama | 1081 | 10765 | 75 |
894516 | 894516 | 2021-01-04 | Lee | Alabama | 1081 | 10656 | 75 |
891270 | 891270 | 2021-01-03 | Lee | Alabama | 1081 | 10560 | 75 |
888023 | 888023 | 2021-01-02 | Lee | Alabama | 1081 | 10508 | 75 |
884778 | 884778 | 2021-01-01 | Lee | Alabama | 1081 | 10450 | 75 |
881533 | 881533 | 2020-12-31 | Lee | Alabama | 1081 | 10320 | 75 |
878288 | 878288 | 2020-12-30 | Lee | Alabama | 1081 | 10159 | 75 |
875043 | 875043 | 2020-12-29 | Lee | Alabama | 1081 | 10047 | 74 |
871798 | 871798 | 2020-12-28 | Lee | Alabama | 1081 | 9928 | 74 |
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);