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 313
- Georgia 308
- Alabama 303
- South Carolina 301
- Mississippi 299
- North Carolina 297
- Virginia 297
- Arkansas 286
- Texas 286
- Illinois 284
- Iowa 284
- Kentucky 230
fips 12
county 1
- Lee · 3,488 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920794 | 920794 | 2021-01-12 | Lee | Florida | 12071 | 46103 | 715 |
920915 | 920915 | 2021-01-12 | Lee | Georgia | 13177 | 1914 | 36 |
921089 | 921089 | 2021-01-12 | Lee | Illinois | 17103 | 2921 | 70 |
921287 | 921287 | 2021-01-12 | Lee | Iowa | 19111 | 3076 | 28 |
921502 | 921502 | 2021-01-12 | Lee | Kentucky | 21129 | 1084 | 18 |
921892 | 921892 | 2021-01-12 | Lee | Mississippi | 28081 | 8526 | 135 |
922393 | 922393 | 2021-01-12 | Lee | North Carolina | 37105 | 4122 | 44 |
922881 | 922881 | 2021-01-12 | Lee | South Carolina | 45061 | 1343 | 43 |
923202 | 923202 | 2021-01-12 | Lee | Texas | 48287 | 1103 | 33 |
923429 | 923429 | 2021-01-12 | Lee | Virginia | 51105 | 1790 | 32 |
917233 | 917233 | 2021-01-11 | Lee | Alabama | 1081 | 11626 | 79 |
917341 | 917341 | 2021-01-11 | Lee | Arkansas | 5077 | 1520 | 28 |
917549 | 917549 | 2021-01-11 | Lee | Florida | 12071 | 45649 | 715 |
917670 | 917670 | 2021-01-11 | Lee | Georgia | 13177 | 1875 | 35 |
917844 | 917844 | 2021-01-11 | Lee | Illinois | 17103 | 2909 | 69 |
918042 | 918042 | 2021-01-11 | Lee | Iowa | 19111 | 3068 | 28 |
918257 | 918257 | 2021-01-11 | Lee | Kentucky | 21129 | 1080 | 18 |
918647 | 918647 | 2021-01-11 | Lee | Mississippi | 28081 | 8472 | 133 |
919148 | 919148 | 2021-01-11 | Lee | North Carolina | 37105 | 4085 | 44 |
919636 | 919636 | 2021-01-11 | Lee | South Carolina | 45061 | 1334 | 43 |
919957 | 919957 | 2021-01-11 | Lee | Texas | 48287 | 1102 | 31 |
920184 | 920184 | 2021-01-11 | Lee | Virginia | 51105 | 1763 | 32 |
913988 | 913988 | 2021-01-10 | Lee | Alabama | 1081 | 11565 | 79 |
914096 | 914096 | 2021-01-10 | Lee | Arkansas | 5077 | 1515 | 28 |
914304 | 914304 | 2021-01-10 | Lee | Florida | 12071 | 45281 | 714 |
914425 | 914425 | 2021-01-10 | Lee | Georgia | 13177 | 1834 | 35 |
914599 | 914599 | 2021-01-10 | Lee | Illinois | 17103 | 2885 | 69 |
914797 | 914797 | 2021-01-10 | Lee | Iowa | 19111 | 3058 | 28 |
915012 | 915012 | 2021-01-10 | Lee | Kentucky | 21129 | 1077 | 18 |
915402 | 915402 | 2021-01-10 | Lee | Mississippi | 28081 | 8448 | 133 |
915903 | 915903 | 2021-01-10 | Lee | North Carolina | 37105 | 4059 | 44 |
916391 | 916391 | 2021-01-10 | Lee | South Carolina | 45061 | 1320 | 43 |
916712 | 916712 | 2021-01-10 | Lee | Texas | 48287 | 1102 | 31 |
916939 | 916939 | 2021-01-10 | Lee | Virginia | 51105 | 1758 | 32 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
910851 | 910851 | 2021-01-09 | Lee | Arkansas | 5077 | 1511 | 28 |
911059 | 911059 | 2021-01-09 | Lee | Florida | 12071 | 44818 | 710 |
911180 | 911180 | 2021-01-09 | Lee | Georgia | 13177 | 1813 | 35 |
911354 | 911354 | 2021-01-09 | Lee | Illinois | 17103 | 2869 | 69 |
911552 | 911552 | 2021-01-09 | Lee | Iowa | 19111 | 3053 | 28 |
911767 | 911767 | 2021-01-09 | Lee | Kentucky | 21129 | 1076 | 18 |
912157 | 912157 | 2021-01-09 | Lee | Mississippi | 28081 | 8403 | 133 |
912658 | 912658 | 2021-01-09 | Lee | North Carolina | 37105 | 3986 | 44 |
913146 | 913146 | 2021-01-09 | Lee | South Carolina | 45061 | 1318 | 43 |
913467 | 913467 | 2021-01-09 | Lee | Texas | 48287 | 1102 | 31 |
913694 | 913694 | 2021-01-09 | Lee | Virginia | 51105 | 1746 | 32 |
907498 | 907498 | 2021-01-08 | Lee | Alabama | 1081 | 11355 | 79 |
907606 | 907606 | 2021-01-08 | Lee | Arkansas | 5077 | 1504 | 28 |
907814 | 907814 | 2021-01-08 | Lee | Florida | 12071 | 44394 | 708 |
907935 | 907935 | 2021-01-08 | Lee | Georgia | 13177 | 1767 | 33 |
908109 | 908109 | 2021-01-08 | Lee | Illinois | 17103 | 2864 | 69 |
908307 | 908307 | 2021-01-08 | Lee | Iowa | 19111 | 3042 | 28 |
908522 | 908522 | 2021-01-08 | Lee | Kentucky | 21129 | 1075 | 18 |
908912 | 908912 | 2021-01-08 | Lee | Mississippi | 28081 | 8305 | 131 |
909413 | 909413 | 2021-01-08 | Lee | North Carolina | 37105 | 3919 | 44 |
909901 | 909901 | 2021-01-08 | Lee | South Carolina | 45061 | 1295 | 43 |
910222 | 910222 | 2021-01-08 | Lee | Texas | 48287 | 1053 | 31 |
910449 | 910449 | 2021-01-08 | Lee | Virginia | 51105 | 1669 | 32 |
904252 | 904252 | 2021-01-07 | Lee | Alabama | 1081 | 11179 | 79 |
904360 | 904360 | 2021-01-07 | Lee | Arkansas | 5077 | 1496 | 27 |
904568 | 904568 | 2021-01-07 | Lee | Florida | 12071 | 43870 | 695 |
904689 | 904689 | 2021-01-07 | Lee | Georgia | 13177 | 1735 | 33 |
904863 | 904863 | 2021-01-07 | Lee | Illinois | 17103 | 2843 | 69 |
905061 | 905061 | 2021-01-07 | Lee | Iowa | 19111 | 3017 | 28 |
905276 | 905276 | 2021-01-07 | Lee | Kentucky | 21129 | 1073 | 18 |
905666 | 905666 | 2021-01-07 | Lee | Mississippi | 28081 | 8261 | 131 |
906168 | 906168 | 2021-01-07 | Lee | North Carolina | 37105 | 3845 | 44 |
906656 | 906656 | 2021-01-07 | Lee | South Carolina | 45061 | 1284 | 42 |
906977 | 906977 | 2021-01-07 | Lee | Texas | 48287 | 1031 | 30 |
907204 | 907204 | 2021-01-07 | Lee | Virginia | 51105 | 1632 | 32 |
901007 | 901007 | 2021-01-06 | Lee | Alabama | 1081 | 10964 | 75 |
901115 | 901115 | 2021-01-06 | Lee | Arkansas | 5077 | 1489 | 26 |
901323 | 901323 | 2021-01-06 | Lee | Florida | 12071 | 43326 | 691 |
901444 | 901444 | 2021-01-06 | Lee | Georgia | 13177 | 1694 | 33 |
901618 | 901618 | 2021-01-06 | Lee | Illinois | 17103 | 2821 | 66 |
901816 | 901816 | 2021-01-06 | Lee | Iowa | 19111 | 2990 | 28 |
902031 | 902031 | 2021-01-06 | Lee | Kentucky | 21129 | 1070 | 18 |
902421 | 902421 | 2021-01-06 | Lee | Mississippi | 28081 | 8161 | 125 |
902922 | 902922 | 2021-01-06 | Lee | North Carolina | 37105 | 3780 | 44 |
903410 | 903410 | 2021-01-06 | Lee | South Carolina | 45061 | 1267 | 42 |
903731 | 903731 | 2021-01-06 | Lee | Texas | 48287 | 1019 | 28 |
903958 | 903958 | 2021-01-06 | Lee | Virginia | 51105 | 1613 | 31 |
897762 | 897762 | 2021-01-05 | Lee | Alabama | 1081 | 10765 | 75 |
897870 | 897870 | 2021-01-05 | Lee | Arkansas | 5077 | 1482 | 26 |
898078 | 898078 | 2021-01-05 | Lee | Florida | 12071 | 42844 | 682 |
898199 | 898199 | 2021-01-05 | Lee | Georgia | 13177 | 1659 | 33 |
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 |
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);