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 360
- Georgia 355
- Alabama 351
- South Carolina 349
- Mississippi 347
- North Carolina 345
- Virginia 345
- Arkansas 334
- Texas 334
- Illinois 332
- Iowa 332
- Kentucky 278
fips 12
county 1
- Lee · 4,062 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076876 | 1076876 | 2021-03-01 | Lee | Illinois | 17103 | 3353 | 82 |
1077075 | 1077075 | 2021-03-01 | Lee | Iowa | 19111 | 3534 | 52 |
1077290 | 1077290 | 2021-03-01 | Lee | Kentucky | 21129 | 1194 | 19 |
1077679 | 1077679 | 2021-03-01 | Lee | Mississippi | 28081 | 9687 | 160 |
1078180 | 1078180 | 2021-03-01 | Lee | North Carolina | 37105 | 5477 | 72 |
1078668 | 1078668 | 2021-03-01 | Lee | South Carolina | 45061 | 1769 | 57 |
1078989 | 1078989 | 2021-03-01 | Lee | Texas | 48287 | 2011 | 36 |
1079216 | 1079216 | 2021-03-01 | Lee | Virginia | 51105 | 2290 | 41 |
1073019 | 1073019 | 2021-02-28 | Lee | Alabama | 1081 | 14961 | 153 |
1073127 | 1073127 | 2021-02-28 | Lee | Arkansas | 5077 | 1639 | 34 |
1073335 | 1073335 | 2021-02-28 | Lee | Florida | 12071 | 57736 | 872 |
1073456 | 1073456 | 2021-02-28 | Lee | Georgia | 13177 | 2595 | 51 |
1073630 | 1073630 | 2021-02-28 | Lee | Illinois | 17103 | 3352 | 82 |
1073829 | 1073829 | 2021-02-28 | Lee | Iowa | 19111 | 3526 | 52 |
1074044 | 1074044 | 2021-02-28 | Lee | Kentucky | 21129 | 1193 | 19 |
1074433 | 1074433 | 2021-02-28 | Lee | Mississippi | 28081 | 9683 | 160 |
1074935 | 1074935 | 2021-02-28 | Lee | North Carolina | 37105 | 5456 | 66 |
1075423 | 1075423 | 2021-02-28 | Lee | South Carolina | 45061 | 1766 | 57 |
1075744 | 1075744 | 2021-02-28 | Lee | Texas | 48287 | 2001 | 36 |
1075971 | 1075971 | 2021-02-28 | Lee | Virginia | 51105 | 2289 | 39 |
1069773 | 1069773 | 2021-02-27 | Lee | Alabama | 1081 | 14950 | 153 |
1069881 | 1069881 | 2021-02-27 | Lee | Arkansas | 5077 | 1642 | 35 |
1070089 | 1070089 | 2021-02-27 | Lee | Florida | 12071 | 57617 | 872 |
1070210 | 1070210 | 2021-02-27 | Lee | Georgia | 13177 | 2596 | 51 |
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 |
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);