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 790
- Georgia 785
- Alabama 781
- South Carolina 779
- Mississippi 777
- North Carolina 775
- Virginia 775
- Arkansas 764
- Texas 764
- Illinois 762
- Iowa 762
- Kentucky 708
fips 12
county 1
- Lee · 9,222 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474165 | 2474165 | 2022-05-05 | Lee | Illinois | 17103 | 8923 | 118 |
2474365 | 2474365 | 2022-05-05 | Lee | Iowa | 19111 | 7866 | 142 |
2474580 | 2474580 | 2022-05-05 | Lee | Kentucky | 21129 | 2948 | 52 |
2474970 | 2474970 | 2022-05-05 | Lee | Mississippi | 28081 | 26744 | 301 |
2475475 | 2475475 | 2022-05-05 | Lee | North Carolina | 37105 | 16052 | 151 |
2475966 | 2475966 | 2022-05-05 | Lee | South Carolina | 45061 | 4266 | 95 |
2476287 | 2476287 | 2022-05-05 | Lee | Texas | 48287 | 4268 | 60 |
2476515 | 2476515 | 2022-05-05 | Lee | Virginia | 51105 | 6183 | 93 |
2470295 | 2470295 | 2022-05-04 | Lee | Alabama | 1081 | 37789 | 340 |
2470404 | 2470404 | 2022-05-04 | Lee | Arkansas | 5077 | 2910 | 59 |
2470612 | 2470612 | 2022-05-04 | Lee | Florida | 12071 | 190313 | 2156 |
2470733 | 2470733 | 2022-05-04 | Lee | Georgia | 13177 | 7374 | 103 |
2470908 | 2470908 | 2022-05-04 | Lee | Illinois | 17103 | 8914 | 118 |
2471108 | 2471108 | 2022-05-04 | Lee | Iowa | 19111 | 7866 | 142 |
2471323 | 2471323 | 2022-05-04 | Lee | Kentucky | 21129 | 2948 | 52 |
2471713 | 2471713 | 2022-05-04 | Lee | Mississippi | 28081 | 26744 | 301 |
2472218 | 2472218 | 2022-05-04 | Lee | North Carolina | 37105 | 16052 | 151 |
2472709 | 2472709 | 2022-05-04 | Lee | South Carolina | 45061 | 4266 | 95 |
2473030 | 2473030 | 2022-05-04 | Lee | Texas | 48287 | 4264 | 60 |
2473257 | 2473257 | 2022-05-04 | Lee | Virginia | 51105 | 6183 | 93 |
2467039 | 2467039 | 2022-05-03 | Lee | Alabama | 1081 | 37786 | 340 |
2467148 | 2467148 | 2022-05-03 | Lee | Arkansas | 5077 | 2910 | 59 |
2467356 | 2467356 | 2022-05-03 | Lee | Florida | 12071 | 190313 | 2152 |
2467477 | 2467477 | 2022-05-03 | Lee | Georgia | 13177 | 7369 | 103 |
2467652 | 2467652 | 2022-05-03 | Lee | Illinois | 17103 | 8904 | 118 |
2467852 | 2467852 | 2022-05-03 | Lee | Iowa | 19111 | 7863 | 142 |
2468067 | 2468067 | 2022-05-03 | Lee | Kentucky | 21129 | 2948 | 52 |
2468457 | 2468457 | 2022-05-03 | Lee | Mississippi | 28081 | 26744 | 301 |
2468962 | 2468962 | 2022-05-03 | Lee | North Carolina | 37105 | 16004 | 146 |
2469453 | 2469453 | 2022-05-03 | Lee | South Carolina | 45061 | 4266 | 95 |
2469774 | 2469774 | 2022-05-03 | Lee | Texas | 48287 | 4263 | 60 |
2470001 | 2470001 | 2022-05-03 | Lee | Virginia | 51105 | 6183 | 93 |
2463784 | 2463784 | 2022-05-02 | Lee | Alabama | 1081 | 37776 | 339 |
2463893 | 2463893 | 2022-05-02 | Lee | Arkansas | 5077 | 2910 | 59 |
2464101 | 2464101 | 2022-05-02 | Lee | Florida | 12071 | 190313 | 2152 |
2464222 | 2464222 | 2022-05-02 | Lee | Georgia | 13177 | 7369 | 103 |
2464397 | 2464397 | 2022-05-02 | Lee | Illinois | 17103 | 8896 | 118 |
2464597 | 2464597 | 2022-05-02 | Lee | Iowa | 19111 | 7863 | 142 |
2464812 | 2464812 | 2022-05-02 | Lee | Kentucky | 21129 | 2948 | 52 |
2465202 | 2465202 | 2022-05-02 | Lee | Mississippi | 28081 | 26744 | 301 |
2465706 | 2465706 | 2022-05-02 | Lee | North Carolina | 37105 | 16004 | 146 |
2466197 | 2466197 | 2022-05-02 | Lee | South Carolina | 45061 | 4254 | 95 |
2466518 | 2466518 | 2022-05-02 | Lee | Texas | 48287 | 4248 | 60 |
2466745 | 2466745 | 2022-05-02 | Lee | Virginia | 51105 | 6210 | 94 |
2460528 | 2460528 | 2022-05-01 | Lee | Alabama | 1081 | 37762 | 339 |
2460637 | 2460637 | 2022-05-01 | Lee | Arkansas | 5077 | 2910 | 59 |
2460845 | 2460845 | 2022-05-01 | Lee | Florida | 12071 | 190313 | 2152 |
2460966 | 2460966 | 2022-05-01 | Lee | Georgia | 13177 | 7369 | 103 |
2461141 | 2461141 | 2022-05-01 | Lee | Illinois | 17103 | 8881 | 118 |
2461341 | 2461341 | 2022-05-01 | Lee | Iowa | 19111 | 7863 | 142 |
2461556 | 2461556 | 2022-05-01 | Lee | Kentucky | 21129 | 2946 | 50 |
2461946 | 2461946 | 2022-05-01 | Lee | Mississippi | 28081 | 26690 | 301 |
2462451 | 2462451 | 2022-05-01 | Lee | North Carolina | 37105 | 16004 | 146 |
2462942 | 2462942 | 2022-05-01 | Lee | South Carolina | 45061 | 4254 | 95 |
2463263 | 2463263 | 2022-05-01 | Lee | Texas | 48287 | 4248 | 60 |
2463490 | 2463490 | 2022-05-01 | Lee | Virginia | 51105 | 6210 | 94 |
2457272 | 2457272 | 2022-04-30 | Lee | Alabama | 1081 | 37762 | 339 |
2457381 | 2457381 | 2022-04-30 | Lee | Arkansas | 5077 | 2910 | 59 |
2457589 | 2457589 | 2022-04-30 | Lee | Florida | 12071 | 190313 | 2152 |
2457710 | 2457710 | 2022-04-30 | Lee | Georgia | 13177 | 7369 | 103 |
2457885 | 2457885 | 2022-04-30 | Lee | Illinois | 17103 | 8881 | 118 |
2458085 | 2458085 | 2022-04-30 | Lee | Iowa | 19111 | 7863 | 142 |
2458300 | 2458300 | 2022-04-30 | Lee | Kentucky | 21129 | 2946 | 50 |
2458690 | 2458690 | 2022-04-30 | Lee | Mississippi | 28081 | 26690 | 301 |
2459195 | 2459195 | 2022-04-30 | Lee | North Carolina | 37105 | 16004 | 146 |
2459686 | 2459686 | 2022-04-30 | Lee | South Carolina | 45061 | 4254 | 95 |
2460007 | 2460007 | 2022-04-30 | Lee | Texas | 48287 | 4248 | 60 |
2460234 | 2460234 | 2022-04-30 | Lee | Virginia | 51105 | 6210 | 94 |
2454016 | 2454016 | 2022-04-29 | Lee | Alabama | 1081 | 37762 | 339 |
2454125 | 2454125 | 2022-04-29 | Lee | Arkansas | 5077 | 2909 | 59 |
2454333 | 2454333 | 2022-04-29 | Lee | Florida | 12071 | 190313 | 2152 |
2454454 | 2454454 | 2022-04-29 | Lee | Georgia | 13177 | 7369 | 103 |
2454629 | 2454629 | 2022-04-29 | Lee | Illinois | 17103 | 8881 | 118 |
2454829 | 2454829 | 2022-04-29 | Lee | Iowa | 19111 | 7863 | 142 |
2455044 | 2455044 | 2022-04-29 | Lee | Kentucky | 21129 | 2946 | 50 |
2455434 | 2455434 | 2022-04-29 | Lee | Mississippi | 28081 | 26690 | 301 |
2455939 | 2455939 | 2022-04-29 | Lee | North Carolina | 37105 | 16004 | 146 |
2456430 | 2456430 | 2022-04-29 | Lee | South Carolina | 45061 | 4254 | 95 |
2456751 | 2456751 | 2022-04-29 | Lee | Texas | 48287 | 4248 | 60 |
2456978 | 2456978 | 2022-04-29 | Lee | Virginia | 51105 | 6210 | 94 |
2450760 | 2450760 | 2022-04-28 | Lee | Alabama | 1081 | 37754 | 339 |
2450869 | 2450869 | 2022-04-28 | Lee | Arkansas | 5077 | 2909 | 59 |
2451077 | 2451077 | 2022-04-28 | Lee | Florida | 12071 | 190313 | 2152 |
2451198 | 2451198 | 2022-04-28 | Lee | Georgia | 13177 | 7369 | 103 |
2451373 | 2451373 | 2022-04-28 | Lee | Illinois | 17103 | 8865 | 118 |
2451573 | 2451573 | 2022-04-28 | Lee | Iowa | 19111 | 7863 | 142 |
2451788 | 2451788 | 2022-04-28 | Lee | Kentucky | 21129 | 2946 | 50 |
2452178 | 2452178 | 2022-04-28 | Lee | Mississippi | 28081 | 26690 | 301 |
2452683 | 2452683 | 2022-04-28 | Lee | North Carolina | 37105 | 16004 | 146 |
2453174 | 2453174 | 2022-04-28 | Lee | South Carolina | 45061 | 4254 | 95 |
2453495 | 2453495 | 2022-04-28 | Lee | Texas | 48287 | 4248 | 60 |
2453722 | 2453722 | 2022-04-28 | Lee | Virginia | 51105 | 6211 | 94 |
2447504 | 2447504 | 2022-04-27 | Lee | Alabama | 1081 | 37749 | 339 |
2447613 | 2447613 | 2022-04-27 | Lee | Arkansas | 5077 | 2909 | 59 |
2447821 | 2447821 | 2022-04-27 | Lee | Florida | 12071 | 190313 | 2152 |
2447942 | 2447942 | 2022-04-27 | Lee | Georgia | 13177 | 7369 | 103 |
2448117 | 2448117 | 2022-04-27 | Lee | Illinois | 17103 | 8847 | 118 |
2448317 | 2448317 | 2022-04-27 | Lee | Iowa | 19111 | 7863 | 142 |
2448532 | 2448532 | 2022-04-27 | Lee | Kentucky | 21129 | 2946 | 50 |
2448922 | 2448922 | 2022-04-27 | Lee | Mississippi | 28081 | 26690 | 301 |
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);