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 305
- Georgia 300
- Alabama 296
- South Carolina 294
- Mississippi 292
- North Carolina 290
- Virginia 290
- Arkansas 279
- Texas 279
- Illinois 277
- Iowa 277
- Kentucky 223
fips 12
county 1
- Lee · 3,402 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
898373 | 898373 | 2021-01-05 | Lee | Illinois | 17103 | 2772 | 65 |
898571 | 898571 | 2021-01-05 | Lee | Iowa | 19111 | 2967 | 27 |
898786 | 898786 | 2021-01-05 | Lee | Kentucky | 21129 | 1055 | 18 |
899176 | 899176 | 2021-01-05 | Lee | Mississippi | 28081 | 8075 | 123 |
899677 | 899677 | 2021-01-05 | Lee | North Carolina | 37105 | 3723 | 44 |
900165 | 900165 | 2021-01-05 | Lee | South Carolina | 45061 | 1251 | 42 |
900486 | 900486 | 2021-01-05 | Lee | Texas | 48287 | 1005 | 28 |
900713 | 900713 | 2021-01-05 | Lee | Virginia | 51105 | 1594 | 31 |
894516 | 894516 | 2021-01-04 | Lee | Alabama | 1081 | 10656 | 75 |
894625 | 894625 | 2021-01-04 | Lee | Arkansas | 5077 | 1464 | 26 |
894833 | 894833 | 2021-01-04 | Lee | Florida | 12071 | 42367 | 680 |
894954 | 894954 | 2021-01-04 | Lee | Georgia | 13177 | 1613 | 33 |
895128 | 895128 | 2021-01-04 | Lee | Illinois | 17103 | 2750 | 64 |
895326 | 895326 | 2021-01-04 | Lee | Iowa | 19111 | 2932 | 27 |
895541 | 895541 | 2021-01-04 | Lee | Kentucky | 21129 | 1053 | 18 |
895931 | 895931 | 2021-01-04 | Lee | Mississippi | 28081 | 7927 | 122 |
896432 | 896432 | 2021-01-04 | Lee | North Carolina | 37105 | 3679 | 44 |
896920 | 896920 | 2021-01-04 | Lee | South Carolina | 45061 | 1240 | 42 |
897241 | 897241 | 2021-01-04 | Lee | Texas | 48287 | 983 | 28 |
897468 | 897468 | 2021-01-04 | Lee | Virginia | 51105 | 1566 | 30 |
891270 | 891270 | 2021-01-03 | Lee | Alabama | 1081 | 10560 | 75 |
891378 | 891378 | 2021-01-03 | Lee | Arkansas | 5077 | 1459 | 26 |
891586 | 891586 | 2021-01-03 | Lee | Florida | 12071 | 41915 | 675 |
891707 | 891707 | 2021-01-03 | Lee | Georgia | 13177 | 1592 | 33 |
891881 | 891881 | 2021-01-03 | Lee | Illinois | 17103 | 2744 | 64 |
892079 | 892079 | 2021-01-03 | Lee | Iowa | 19111 | 2906 | 25 |
892294 | 892294 | 2021-01-03 | Lee | Kentucky | 21129 | 1051 | 18 |
892684 | 892684 | 2021-01-03 | Lee | Mississippi | 28081 | 7872 | 120 |
893186 | 893186 | 2021-01-03 | Lee | North Carolina | 37105 | 3654 | 44 |
893674 | 893674 | 2021-01-03 | Lee | South Carolina | 45061 | 1229 | 42 |
893995 | 893995 | 2021-01-03 | Lee | Texas | 48287 | 983 | 28 |
894222 | 894222 | 2021-01-03 | Lee | Virginia | 51105 | 1550 | 30 |
888023 | 888023 | 2021-01-02 | Lee | Alabama | 1081 | 10508 | 75 |
888131 | 888131 | 2021-01-02 | Lee | Arkansas | 5077 | 1455 | 26 |
888339 | 888339 | 2021-01-02 | Lee | Florida | 12071 | 41312 | 675 |
888460 | 888460 | 2021-01-02 | Lee | Georgia | 13177 | 1585 | 33 |
888634 | 888634 | 2021-01-02 | Lee | Illinois | 17103 | 2741 | 64 |
888833 | 888833 | 2021-01-02 | Lee | Iowa | 19111 | 2895 | 25 |
889048 | 889048 | 2021-01-02 | Lee | Kentucky | 21129 | 1047 | 18 |
889438 | 889438 | 2021-01-02 | Lee | Mississippi | 28081 | 7807 | 118 |
889940 | 889940 | 2021-01-02 | Lee | North Carolina | 37105 | 3617 | 44 |
890428 | 890428 | 2021-01-02 | Lee | South Carolina | 45061 | 1206 | 42 |
890749 | 890749 | 2021-01-02 | Lee | Texas | 48287 | 977 | 28 |
890976 | 890976 | 2021-01-02 | Lee | Virginia | 51105 | 1531 | 30 |
884778 | 884778 | 2021-01-01 | Lee | Alabama | 1081 | 10450 | 75 |
884886 | 884886 | 2021-01-01 | Lee | Arkansas | 5077 | 1449 | 26 |
885094 | 885094 | 2021-01-01 | Lee | Florida | 12071 | 40634 | 672 |
885215 | 885215 | 2021-01-01 | Lee | Georgia | 13177 | 1574 | 33 |
885389 | 885389 | 2021-01-01 | Lee | Illinois | 17103 | 2707 | 64 |
885587 | 885587 | 2021-01-01 | Lee | Iowa | 19111 | 2878 | 24 |
885802 | 885802 | 2021-01-01 | Lee | Kentucky | 21129 | 1043 | 18 |
886192 | 886192 | 2021-01-01 | Lee | Mississippi | 28081 | 7758 | 118 |
886693 | 886693 | 2021-01-01 | Lee | North Carolina | 37105 | 3510 | 41 |
887181 | 887181 | 2021-01-01 | Lee | South Carolina | 45061 | 1194 | 42 |
887502 | 887502 | 2021-01-01 | Lee | Texas | 48287 | 977 | 28 |
887729 | 887729 | 2021-01-01 | Lee | Virginia | 51105 | 1506 | 29 |
881533 | 881533 | 2020-12-31 | Lee | Alabama | 1081 | 10320 | 75 |
881641 | 881641 | 2020-12-31 | Lee | Arkansas | 5077 | 1430 | 26 |
881849 | 881849 | 2020-12-31 | Lee | Florida | 12071 | 40634 | 672 |
881970 | 881970 | 2020-12-31 | Lee | Georgia | 13177 | 1546 | 33 |
882144 | 882144 | 2020-12-31 | Lee | Illinois | 17103 | 2707 | 64 |
882342 | 882342 | 2020-12-31 | Lee | Iowa | 19111 | 2859 | 24 |
882557 | 882557 | 2020-12-31 | Lee | Kentucky | 21129 | 1043 | 18 |
882947 | 882947 | 2020-12-31 | Lee | Mississippi | 28081 | 7668 | 118 |
883448 | 883448 | 2020-12-31 | Lee | North Carolina | 37105 | 3510 | 41 |
883936 | 883936 | 2020-12-31 | Lee | South Carolina | 45061 | 1194 | 42 |
884257 | 884257 | 2020-12-31 | Lee | Texas | 48287 | 962 | 27 |
884484 | 884484 | 2020-12-31 | Lee | Virginia | 51105 | 1476 | 29 |
878288 | 878288 | 2020-12-30 | Lee | Alabama | 1081 | 10159 | 75 |
878396 | 878396 | 2020-12-30 | Lee | Arkansas | 5077 | 1425 | 26 |
878604 | 878604 | 2020-12-30 | Lee | Florida | 12071 | 40168 | 673 |
878725 | 878725 | 2020-12-30 | Lee | Georgia | 13177 | 1499 | 33 |
878899 | 878899 | 2020-12-30 | Lee | Illinois | 17103 | 2694 | 64 |
879097 | 879097 | 2020-12-30 | Lee | Iowa | 19111 | 2840 | 24 |
879312 | 879312 | 2020-12-30 | Lee | Kentucky | 21129 | 1043 | 18 |
879702 | 879702 | 2020-12-30 | Lee | Mississippi | 28081 | 7566 | 118 |
880203 | 880203 | 2020-12-30 | Lee | North Carolina | 37105 | 3475 | 39 |
880691 | 880691 | 2020-12-30 | Lee | South Carolina | 45061 | 1185 | 41 |
881012 | 881012 | 2020-12-30 | Lee | Texas | 48287 | 920 | 27 |
881239 | 881239 | 2020-12-30 | Lee | Virginia | 51105 | 1439 | 29 |
875043 | 875043 | 2020-12-29 | Lee | Alabama | 1081 | 10047 | 74 |
875151 | 875151 | 2020-12-29 | Lee | Arkansas | 5077 | 1414 | 24 |
875359 | 875359 | 2020-12-29 | Lee | Florida | 12071 | 39678 | 653 |
875480 | 875480 | 2020-12-29 | Lee | Georgia | 13177 | 1454 | 33 |
875654 | 875654 | 2020-12-29 | Lee | Illinois | 17103 | 2670 | 64 |
875852 | 875852 | 2020-12-29 | Lee | Iowa | 19111 | 2828 | 24 |
876067 | 876067 | 2020-12-29 | Lee | Kentucky | 21129 | 1041 | 18 |
876457 | 876457 | 2020-12-29 | Lee | Mississippi | 28081 | 7455 | 118 |
876958 | 876958 | 2020-12-29 | Lee | North Carolina | 37105 | 3414 | 39 |
877446 | 877446 | 2020-12-29 | Lee | South Carolina | 45061 | 1175 | 41 |
877767 | 877767 | 2020-12-29 | Lee | Texas | 48287 | 911 | 25 |
877994 | 877994 | 2020-12-29 | Lee | Virginia | 51105 | 1425 | 29 |
871798 | 871798 | 2020-12-28 | Lee | Alabama | 1081 | 9928 | 74 |
871906 | 871906 | 2020-12-28 | Lee | Arkansas | 5077 | 1412 | 24 |
872114 | 872114 | 2020-12-28 | Lee | Florida | 12071 | 39331 | 652 |
872235 | 872235 | 2020-12-28 | Lee | Georgia | 13177 | 1413 | 33 |
872409 | 872409 | 2020-12-28 | Lee | Illinois | 17103 | 2658 | 64 |
872607 | 872607 | 2020-12-28 | Lee | Iowa | 19111 | 2818 | 24 |
872822 | 872822 | 2020-12-28 | Lee | Kentucky | 21129 | 1039 | 18 |
873212 | 873212 | 2020-12-28 | Lee | Mississippi | 28081 | 7370 | 115 |
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);