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 225
- Georgia 220
- Alabama 215
- South Carolina 213
- Mississippi 211
- North Carolina 209
- Virginia 209
- Arkansas 198
- Texas 198
- Illinois 196
- Iowa 196
- Kentucky 142
fips 12
county 1
- Lee · 2,432 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635241 | 635241 | 2020-10-16 | Lee | Florida | 12071 | 21752 | 492 |
635362 | 635362 | 2020-10-16 | Lee | Georgia | 13177 | 800 | 26 |
635535 | 635535 | 2020-10-16 | Lee | Illinois | 17103 | 562 | 1 |
635734 | 635734 | 2020-10-16 | Lee | Iowa | 19111 | 850 | 9 |
635949 | 635949 | 2020-10-16 | Lee | Kentucky | 21129 | 33 | 0 |
636339 | 636339 | 2020-10-16 | Lee | Mississippi | 28081 | 3354 | 79 |
636840 | 636840 | 2020-10-16 | Lee | North Carolina | 37105 | 1913 | 16 |
637328 | 637328 | 2020-10-16 | Lee | South Carolina | 45061 | 753 | 35 |
637648 | 637648 | 2020-10-16 | Lee | Texas | 48287 | 235 | 14 |
637874 | 637874 | 2020-10-16 | Lee | Virginia | 51105 | 366 | 9 |
631680 | 631680 | 2020-10-15 | Lee | Alabama | 1081 | 6367 | 66 |
631787 | 631787 | 2020-10-15 | Lee | Arkansas | 5077 | 1094 | 18 |
631995 | 631995 | 2020-10-15 | Lee | Florida | 12071 | 21612 | 489 |
632116 | 632116 | 2020-10-15 | Lee | Georgia | 13177 | 797 | 26 |
632289 | 632289 | 2020-10-15 | Lee | Illinois | 17103 | 549 | 1 |
632488 | 632488 | 2020-10-15 | Lee | Iowa | 19111 | 826 | 9 |
632703 | 632703 | 2020-10-15 | Lee | Kentucky | 21129 | 30 | 0 |
633093 | 633093 | 2020-10-15 | Lee | Mississippi | 28081 | 3316 | 79 |
633594 | 633594 | 2020-10-15 | Lee | North Carolina | 37105 | 1888 | 16 |
634082 | 634082 | 2020-10-15 | Lee | South Carolina | 45061 | 750 | 35 |
634403 | 634403 | 2020-10-15 | Lee | Texas | 48287 | 235 | 14 |
634629 | 634629 | 2020-10-15 | Lee | Virginia | 51105 | 359 | 8 |
628436 | 628436 | 2020-10-14 | Lee | Alabama | 1081 | 6346 | 64 |
628543 | 628543 | 2020-10-14 | Lee | Arkansas | 5077 | 1093 | 18 |
628751 | 628751 | 2020-10-14 | Lee | Florida | 12071 | 21488 | 485 |
628872 | 628872 | 2020-10-14 | Lee | Georgia | 13177 | 796 | 26 |
629045 | 629045 | 2020-10-14 | Lee | Illinois | 17103 | 525 | 1 |
629244 | 629244 | 2020-10-14 | Lee | Iowa | 19111 | 803 | 9 |
629459 | 629459 | 2020-10-14 | Lee | Kentucky | 21129 | 27 | 0 |
629848 | 629848 | 2020-10-14 | Lee | Mississippi | 28081 | 3290 | 78 |
630349 | 630349 | 2020-10-14 | Lee | North Carolina | 37105 | 1866 | 16 |
630837 | 630837 | 2020-10-14 | Lee | South Carolina | 45061 | 744 | 35 |
631158 | 631158 | 2020-10-14 | Lee | Texas | 48287 | 234 | 14 |
631384 | 631384 | 2020-10-14 | Lee | Virginia | 51105 | 354 | 8 |
625193 | 625193 | 2020-10-13 | Lee | Alabama | 1081 | 6335 | 64 |
625300 | 625300 | 2020-10-13 | Lee | Arkansas | 5077 | 1092 | 18 |
625508 | 625508 | 2020-10-13 | Lee | Florida | 12071 | 21437 | 484 |
625629 | 625629 | 2020-10-13 | Lee | Georgia | 13177 | 794 | 26 |
625802 | 625802 | 2020-10-13 | Lee | Illinois | 17103 | 517 | 1 |
626001 | 626001 | 2020-10-13 | Lee | Iowa | 19111 | 782 | 9 |
626215 | 626215 | 2020-10-13 | Lee | Kentucky | 21129 | 21 | 0 |
626604 | 626604 | 2020-10-13 | Lee | Mississippi | 28081 | 3239 | 78 |
627105 | 627105 | 2020-10-13 | Lee | North Carolina | 37105 | 1842 | 16 |
627593 | 627593 | 2020-10-13 | Lee | South Carolina | 45061 | 743 | 35 |
627914 | 627914 | 2020-10-13 | Lee | Texas | 48287 | 234 | 14 |
628140 | 628140 | 2020-10-13 | Lee | Virginia | 51105 | 343 | 8 |
621950 | 621950 | 2020-10-12 | Lee | Alabama | 1081 | 6325 | 64 |
622057 | 622057 | 2020-10-12 | Lee | Arkansas | 5077 | 1092 | 18 |
622265 | 622265 | 2020-10-12 | Lee | Florida | 12071 | 21362 | 483 |
622386 | 622386 | 2020-10-12 | Lee | Georgia | 13177 | 792 | 26 |
622560 | 622560 | 2020-10-12 | Lee | Illinois | 17103 | 505 | 1 |
622759 | 622759 | 2020-10-12 | Lee | Iowa | 19111 | 776 | 9 |
622973 | 622973 | 2020-10-12 | Lee | Kentucky | 21129 | 21 | 0 |
623362 | 623362 | 2020-10-12 | Lee | Mississippi | 28081 | 3208 | 77 |
623863 | 623863 | 2020-10-12 | Lee | North Carolina | 37105 | 1836 | 15 |
624351 | 624351 | 2020-10-12 | Lee | South Carolina | 45061 | 739 | 35 |
624671 | 624671 | 2020-10-12 | Lee | Texas | 48287 | 234 | 14 |
624897 | 624897 | 2020-10-12 | Lee | Virginia | 51105 | 331 | 8 |
618707 | 618707 | 2020-10-11 | Lee | Alabama | 1081 | 6292 | 64 |
618814 | 618814 | 2020-10-11 | Lee | Arkansas | 5077 | 1091 | 18 |
619022 | 619022 | 2020-10-11 | Lee | Florida | 12071 | 21331 | 483 |
619143 | 619143 | 2020-10-11 | Lee | Georgia | 13177 | 789 | 26 |
619316 | 619316 | 2020-10-11 | Lee | Illinois | 17103 | 501 | 1 |
619515 | 619515 | 2020-10-11 | Lee | Iowa | 19111 | 775 | 9 |
619729 | 619729 | 2020-10-11 | Lee | Kentucky | 21129 | 18 | 0 |
620119 | 620119 | 2020-10-11 | Lee | Mississippi | 28081 | 3195 | 77 |
620620 | 620620 | 2020-10-11 | Lee | North Carolina | 37105 | 1829 | 15 |
621108 | 621108 | 2020-10-11 | Lee | South Carolina | 45061 | 739 | 35 |
621428 | 621428 | 2020-10-11 | Lee | Texas | 48287 | 234 | 14 |
621654 | 621654 | 2020-10-11 | Lee | Virginia | 51105 | 324 | 8 |
615465 | 615465 | 2020-10-10 | Lee | Alabama | 1081 | 6281 | 64 |
615572 | 615572 | 2020-10-10 | Lee | Arkansas | 5077 | 1091 | 18 |
615780 | 615780 | 2020-10-10 | Lee | Florida | 12071 | 21174 | 481 |
615901 | 615901 | 2020-10-10 | Lee | Georgia | 13177 | 789 | 26 |
616074 | 616074 | 2020-10-10 | Lee | Illinois | 17103 | 497 | 1 |
616273 | 616273 | 2020-10-10 | Lee | Iowa | 19111 | 766 | 9 |
616487 | 616487 | 2020-10-10 | Lee | Kentucky | 21129 | 18 | 0 |
616877 | 616877 | 2020-10-10 | Lee | Mississippi | 28081 | 3181 | 76 |
617378 | 617378 | 2020-10-10 | Lee | North Carolina | 37105 | 1816 | 15 |
617865 | 617865 | 2020-10-10 | Lee | South Carolina | 45061 | 735 | 35 |
618185 | 618185 | 2020-10-10 | Lee | Texas | 48287 | 234 | 14 |
618411 | 618411 | 2020-10-10 | Lee | Virginia | 51105 | 320 | 7 |
612224 | 612224 | 2020-10-09 | Lee | Alabama | 1081 | 6268 | 64 |
612331 | 612331 | 2020-10-09 | Lee | Arkansas | 5077 | 1088 | 18 |
612539 | 612539 | 2020-10-09 | Lee | Florida | 12071 | 21174 | 481 |
612660 | 612660 | 2020-10-09 | Lee | Georgia | 13177 | 789 | 26 |
612833 | 612833 | 2020-10-09 | Lee | Illinois | 17103 | 484 | 1 |
613032 | 613032 | 2020-10-09 | Lee | Iowa | 19111 | 754 | 9 |
613246 | 613246 | 2020-10-09 | Lee | Kentucky | 21129 | 18 | 0 |
613636 | 613636 | 2020-10-09 | Lee | Mississippi | 28081 | 3139 | 75 |
614136 | 614136 | 2020-10-09 | Lee | North Carolina | 37105 | 1805 | 15 |
614623 | 614623 | 2020-10-09 | Lee | South Carolina | 45061 | 727 | 35 |
614943 | 614943 | 2020-10-09 | Lee | Texas | 48287 | 233 | 14 |
615169 | 615169 | 2020-10-09 | Lee | Virginia | 51105 | 315 | 7 |
608982 | 608982 | 2020-10-08 | Lee | Alabama | 1081 | 6243 | 64 |
609089 | 609089 | 2020-10-08 | Lee | Arkansas | 5077 | 1087 | 18 |
609297 | 609297 | 2020-10-08 | Lee | Florida | 12071 | 21088 | 479 |
609418 | 609418 | 2020-10-08 | Lee | Georgia | 13177 | 785 | 26 |
609591 | 609591 | 2020-10-08 | Lee | Illinois | 17103 | 472 | 1 |
609790 | 609790 | 2020-10-08 | Lee | Iowa | 19111 | 749 | 9 |
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);