ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,322 rows where county = "Lee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 12
- Florida 358
- Georgia 353
- Alabama 349
- South Carolina 347
- Mississippi 345
- North Carolina 343
- Virginia 343
- Arkansas 332
- Texas 332
- Illinois 330
- Iowa 330
- Kentucky 276
fips 12
county 1
- Lee · 4,038 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1070384 | 1070384 | 2021-02-27 | Lee | Illinois | 17103 | 3351 | 82 |
1070583 | 1070583 | 2021-02-27 | Lee | Iowa | 19111 | 3526 | 52 |
1070798 | 1070798 | 2021-02-27 | Lee | Kentucky | 21129 | 1193 | 19 |
1071187 | 1071187 | 2021-02-27 | Lee | Mississippi | 28081 | 9679 | 160 |
1071689 | 1071689 | 2021-02-27 | Lee | North Carolina | 37105 | 5456 | 66 |
1072177 | 1072177 | 2021-02-27 | Lee | South Carolina | 45061 | 1763 | 56 |
1072498 | 1072498 | 2021-02-27 | Lee | Texas | 48287 | 2001 | 36 |
1072725 | 1072725 | 2021-02-27 | Lee | Virginia | 51105 | 2287 | 39 |
1066528 | 1066528 | 2021-02-26 | Lee | Alabama | 1081 | 14926 | 151 |
1066636 | 1066636 | 2021-02-26 | Lee | Arkansas | 5077 | 1641 | 35 |
1066844 | 1066844 | 2021-02-26 | Lee | Florida | 12071 | 57468 | 872 |
1066965 | 1066965 | 2021-02-26 | Lee | Georgia | 13177 | 2593 | 51 |
1067139 | 1067139 | 2021-02-26 | Lee | Illinois | 17103 | 3343 | 82 |
1067338 | 1067338 | 2021-02-26 | Lee | Iowa | 19111 | 3526 | 52 |
1067553 | 1067553 | 2021-02-26 | Lee | Kentucky | 21129 | 1191 | 19 |
1067942 | 1067942 | 2021-02-26 | Lee | Mississippi | 28081 | 9671 | 160 |
1068443 | 1068443 | 2021-02-26 | Lee | North Carolina | 37105 | 5444 | 66 |
1068931 | 1068931 | 2021-02-26 | Lee | South Carolina | 45061 | 1761 | 56 |
1069252 | 1069252 | 2021-02-26 | Lee | Texas | 48287 | 1997 | 36 |
1069479 | 1069479 | 2021-02-26 | Lee | Virginia | 51105 | 2282 | 39 |
1063283 | 1063283 | 2021-02-25 | Lee | Alabama | 1081 | 14900 | 150 |
1063391 | 1063391 | 2021-02-25 | Lee | Arkansas | 5077 | 1636 | 35 |
1063599 | 1063599 | 2021-02-25 | Lee | Florida | 12071 | 57274 | 869 |
1063720 | 1063720 | 2021-02-25 | Lee | Georgia | 13177 | 2584 | 51 |
1063894 | 1063894 | 2021-02-25 | Lee | Illinois | 17103 | 3342 | 82 |
1064093 | 1064093 | 2021-02-25 | Lee | Iowa | 19111 | 3519 | 51 |
1064308 | 1064308 | 2021-02-25 | Lee | Kentucky | 21129 | 1188 | 19 |
1064697 | 1064697 | 2021-02-25 | Lee | Mississippi | 28081 | 9663 | 160 |
1065198 | 1065198 | 2021-02-25 | Lee | North Carolina | 37105 | 5429 | 66 |
1065686 | 1065686 | 2021-02-25 | Lee | South Carolina | 45061 | 1760 | 56 |
1066007 | 1066007 | 2021-02-25 | Lee | Texas | 48287 | 1991 | 36 |
1066234 | 1066234 | 2021-02-25 | Lee | Virginia | 51105 | 2276 | 38 |
1060038 | 1060038 | 2021-02-24 | Lee | Alabama | 1081 | 14883 | 147 |
1060146 | 1060146 | 2021-02-24 | Lee | Arkansas | 5077 | 1635 | 35 |
1060354 | 1060354 | 2021-02-24 | Lee | Florida | 12071 | 57123 | 869 |
1060475 | 1060475 | 2021-02-24 | Lee | Georgia | 13177 | 2580 | 50 |
1060649 | 1060649 | 2021-02-24 | Lee | Illinois | 17103 | 3328 | 82 |
1060848 | 1060848 | 2021-02-24 | Lee | Iowa | 19111 | 3483 | 51 |
1061063 | 1061063 | 2021-02-24 | Lee | Kentucky | 21129 | 1187 | 19 |
1061453 | 1061453 | 2021-02-24 | Lee | Mississippi | 28081 | 9641 | 160 |
1061954 | 1061954 | 2021-02-24 | Lee | North Carolina | 37105 | 5408 | 66 |
1062441 | 1062441 | 2021-02-24 | Lee | South Carolina | 45061 | 1757 | 56 |
1062762 | 1062762 | 2021-02-24 | Lee | Texas | 48287 | 1983 | 36 |
1062989 | 1062989 | 2021-02-24 | Lee | Virginia | 51105 | 2269 | 38 |
1056792 | 1056792 | 2021-02-23 | Lee | Alabama | 1081 | 14827 | 147 |
1056900 | 1056900 | 2021-02-23 | Lee | Arkansas | 5077 | 1633 | 35 |
1057108 | 1057108 | 2021-02-23 | Lee | Florida | 12071 | 56936 | 870 |
1057229 | 1057229 | 2021-02-23 | Lee | Georgia | 13177 | 2562 | 50 |
1057403 | 1057403 | 2021-02-23 | Lee | Illinois | 17103 | 3324 | 82 |
1057602 | 1057602 | 2021-02-23 | Lee | Iowa | 19111 | 3483 | 51 |
1057817 | 1057817 | 2021-02-23 | Lee | Kentucky | 21129 | 1185 | 19 |
1058207 | 1058207 | 2021-02-23 | Lee | Mississippi | 28081 | 9635 | 160 |
1058708 | 1058708 | 2021-02-23 | Lee | North Carolina | 37105 | 5357 | 66 |
1059196 | 1059196 | 2021-02-23 | Lee | South Carolina | 45061 | 1756 | 56 |
1059517 | 1059517 | 2021-02-23 | Lee | Texas | 48287 | 1959 | 36 |
1059744 | 1059744 | 2021-02-23 | Lee | Virginia | 51105 | 2264 | 38 |
1053546 | 1053546 | 2021-02-22 | Lee | Alabama | 1081 | 14809 | 146 |
1053654 | 1053654 | 2021-02-22 | Lee | Arkansas | 5077 | 1632 | 35 |
1053862 | 1053862 | 2021-02-22 | Lee | Florida | 12071 | 56786 | 865 |
1053983 | 1053983 | 2021-02-22 | Lee | Georgia | 13177 | 2554 | 50 |
1054157 | 1054157 | 2021-02-22 | Lee | Illinois | 17103 | 3303 | 82 |
1054356 | 1054356 | 2021-02-22 | Lee | Iowa | 19111 | 3483 | 51 |
1054571 | 1054571 | 2021-02-22 | Lee | Kentucky | 21129 | 1182 | 19 |
1054961 | 1054961 | 2021-02-22 | Lee | Mississippi | 28081 | 9627 | 160 |
1055462 | 1055462 | 2021-02-22 | Lee | North Carolina | 37105 | 5350 | 66 |
1055950 | 1055950 | 2021-02-22 | Lee | South Carolina | 45061 | 1754 | 56 |
1056271 | 1056271 | 2021-02-22 | Lee | Texas | 48287 | 1952 | 36 |
1056498 | 1056498 | 2021-02-22 | Lee | Virginia | 51105 | 2259 | 38 |
1050299 | 1050299 | 2021-02-21 | Lee | Alabama | 1081 | 14798 | 146 |
1050407 | 1050407 | 2021-02-21 | Lee | Arkansas | 5077 | 1632 | 35 |
1050615 | 1050615 | 2021-02-21 | Lee | Florida | 12071 | 56637 | 865 |
1050736 | 1050736 | 2021-02-21 | Lee | Georgia | 13177 | 2552 | 50 |
1050910 | 1050910 | 2021-02-21 | Lee | Illinois | 17103 | 3300 | 82 |
1051109 | 1051109 | 2021-02-21 | Lee | Iowa | 19111 | 3483 | 51 |
1051324 | 1051324 | 2021-02-21 | Lee | Kentucky | 21129 | 1180 | 19 |
1051714 | 1051714 | 2021-02-21 | Lee | Mississippi | 28081 | 9620 | 160 |
1052216 | 1052216 | 2021-02-21 | Lee | North Carolina | 37105 | 5337 | 66 |
1052704 | 1052704 | 2021-02-21 | Lee | South Carolina | 45061 | 1752 | 56 |
1053025 | 1053025 | 2021-02-21 | Lee | Texas | 48287 | 1949 | 36 |
1053252 | 1053252 | 2021-02-21 | Lee | Virginia | 51105 | 2255 | 38 |
1047052 | 1047052 | 2021-02-20 | Lee | Alabama | 1081 | 14779 | 146 |
1047160 | 1047160 | 2021-02-20 | Lee | Arkansas | 5077 | 1632 | 35 |
1047368 | 1047368 | 2021-02-20 | Lee | Florida | 12071 | 56491 | 865 |
1047489 | 1047489 | 2021-02-20 | Lee | Georgia | 13177 | 2552 | 50 |
1047663 | 1047663 | 2021-02-20 | Lee | Illinois | 17103 | 3298 | 82 |
1047862 | 1047862 | 2021-02-20 | Lee | Iowa | 19111 | 3483 | 51 |
1048077 | 1048077 | 2021-02-20 | Lee | Kentucky | 21129 | 1181 | 19 |
1048467 | 1048467 | 2021-02-20 | Lee | Mississippi | 28081 | 9618 | 160 |
1048969 | 1048969 | 2021-02-20 | Lee | North Carolina | 37105 | 5324 | 66 |
1049457 | 1049457 | 2021-02-20 | Lee | South Carolina | 45061 | 1745 | 56 |
1049778 | 1049778 | 2021-02-20 | Lee | Texas | 48287 | 1949 | 36 |
1050005 | 1050005 | 2021-02-20 | Lee | Virginia | 51105 | 2255 | 38 |
1043807 | 1043807 | 2021-02-19 | Lee | Alabama | 1081 | 14766 | 146 |
1043915 | 1043915 | 2021-02-19 | Lee | Arkansas | 5077 | 1630 | 35 |
1044123 | 1044123 | 2021-02-19 | Lee | Florida | 12071 | 56276 | 864 |
1044244 | 1044244 | 2021-02-19 | Lee | Georgia | 13177 | 2549 | 50 |
1044418 | 1044418 | 2021-02-19 | Lee | Illinois | 17103 | 3295 | 82 |
1044617 | 1044617 | 2021-02-19 | Lee | Iowa | 19111 | 3483 | 51 |
1044832 | 1044832 | 2021-02-19 | Lee | Kentucky | 21129 | 1178 | 19 |
1045221 | 1045221 | 2021-02-19 | Lee | Mississippi | 28081 | 9608 | 159 |
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);