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 148
- Georgia 143
- Alabama 138
- South Carolina 136
- Mississippi 134
- North Carolina 132
- Virginia 132
- Arkansas 122
- Texas 121
- Illinois 119
- Iowa 119
- Kentucky 65
fips 12
county 1
- Lee · 1,509 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386087 | 386087 | 2020-07-31 | Lee | Arkansas | 5077 | 882 | 6 |
386294 | 386294 | 2020-07-31 | Lee | Florida | 12071 | 15415 | 295 |
386415 | 386415 | 2020-07-31 | Lee | Georgia | 13177 | 501 | 22 |
386586 | 386586 | 2020-07-31 | Lee | Illinois | 17103 | 136 | 2 |
386785 | 386785 | 2020-07-31 | Lee | Iowa | 19111 | 89 | 3 |
386997 | 386997 | 2020-07-31 | Lee | Kentucky | 21129 | 3 | 0 |
387387 | 387387 | 2020-07-31 | Lee | Mississippi | 28081 | 1162 | 29 |
387873 | 387873 | 2020-07-31 | Lee | North Carolina | 37105 | 1141 | 9 |
388359 | 388359 | 2020-07-31 | Lee | South Carolina | 45061 | 487 | 26 |
388677 | 388677 | 2020-07-31 | Lee | Texas | 48287 | 151 | 8 |
388901 | 388901 | 2020-07-31 | Lee | Virginia | 51105 | 91 | 1 |
382762 | 382762 | 2020-07-30 | Lee | Alabama | 1081 | 2520 | 43 |
382869 | 382869 | 2020-07-30 | Lee | Arkansas | 5077 | 879 | 6 |
383076 | 383076 | 2020-07-30 | Lee | Florida | 12071 | 15136 | 286 |
383197 | 383197 | 2020-07-30 | Lee | Georgia | 13177 | 496 | 22 |
383368 | 383368 | 2020-07-30 | Lee | Illinois | 17103 | 136 | 2 |
383567 | 383567 | 2020-07-30 | Lee | Iowa | 19111 | 87 | 2 |
383779 | 383779 | 2020-07-30 | Lee | Kentucky | 21129 | 3 | 0 |
384169 | 384169 | 2020-07-30 | Lee | Mississippi | 28081 | 1115 | 28 |
384656 | 384656 | 2020-07-30 | Lee | North Carolina | 37105 | 1124 | 9 |
385142 | 385142 | 2020-07-30 | Lee | South Carolina | 45061 | 485 | 26 |
385460 | 385460 | 2020-07-30 | Lee | Texas | 48287 | 148 | 8 |
385684 | 385684 | 2020-07-30 | Lee | Virginia | 51105 | 86 | 0 |
379545 | 379545 | 2020-07-29 | Lee | Alabama | 1081 | 2486 | 43 |
379652 | 379652 | 2020-07-29 | Lee | Arkansas | 5077 | 878 | 6 |
379859 | 379859 | 2020-07-29 | Lee | Florida | 12071 | 14876 | 279 |
379980 | 379980 | 2020-07-29 | Lee | Georgia | 13177 | 490 | 22 |
380151 | 380151 | 2020-07-29 | Lee | Illinois | 17103 | 131 | 2 |
380350 | 380350 | 2020-07-29 | Lee | Iowa | 19111 | 83 | 2 |
380562 | 380562 | 2020-07-29 | Lee | Kentucky | 21129 | 3 | 0 |
380952 | 380952 | 2020-07-29 | Lee | Mississippi | 28081 | 1069 | 28 |
381438 | 381438 | 2020-07-29 | Lee | North Carolina | 37105 | 1115 | 9 |
381924 | 381924 | 2020-07-29 | Lee | South Carolina | 45061 | 479 | 25 |
382242 | 382242 | 2020-07-29 | Lee | Texas | 48287 | 146 | 10 |
382466 | 382466 | 2020-07-29 | Lee | Virginia | 51105 | 83 | 0 |
376329 | 376329 | 2020-07-28 | Lee | Alabama | 1081 | 2449 | 43 |
376436 | 376436 | 2020-07-28 | Lee | Arkansas | 5077 | 876 | 6 |
376642 | 376642 | 2020-07-28 | Lee | Florida | 12071 | 14715 | 272 |
376763 | 376763 | 2020-07-28 | Lee | Georgia | 13177 | 488 | 22 |
376934 | 376934 | 2020-07-28 | Lee | Illinois | 17103 | 129 | 2 |
377133 | 377133 | 2020-07-28 | Lee | Iowa | 19111 | 80 | 2 |
377345 | 377345 | 2020-07-28 | Lee | Kentucky | 21129 | 3 | 0 |
377735 | 377735 | 2020-07-28 | Lee | Mississippi | 28081 | 1050 | 28 |
378221 | 378221 | 2020-07-28 | Lee | North Carolina | 37105 | 1095 | 9 |
378707 | 378707 | 2020-07-28 | Lee | South Carolina | 45061 | 453 | 25 |
379025 | 379025 | 2020-07-28 | Lee | Texas | 48287 | 144 | 10 |
379249 | 379249 | 2020-07-28 | Lee | Virginia | 51105 | 80 | 0 |
373115 | 373115 | 2020-07-27 | Lee | Alabama | 1081 | 2412 | 43 |
373222 | 373222 | 2020-07-27 | Lee | Arkansas | 5077 | 876 | 6 |
373428 | 373428 | 2020-07-27 | Lee | Florida | 12071 | 14539 | 259 |
373549 | 373549 | 2020-07-27 | Lee | Georgia | 13177 | 483 | 22 |
373719 | 373719 | 2020-07-27 | Lee | Illinois | 17103 | 129 | 2 |
373918 | 373918 | 2020-07-27 | Lee | Iowa | 19111 | 77 | 2 |
374130 | 374130 | 2020-07-27 | Lee | Kentucky | 21129 | 3 | 0 |
374520 | 374520 | 2020-07-27 | Lee | Mississippi | 28081 | 1020 | 26 |
375005 | 375005 | 2020-07-27 | Lee | North Carolina | 37105 | 1074 | 9 |
375491 | 375491 | 2020-07-27 | Lee | South Carolina | 45061 | 447 | 25 |
375809 | 375809 | 2020-07-27 | Lee | Texas | 48287 | 143 | 10 |
376033 | 376033 | 2020-07-27 | Lee | Virginia | 51105 | 78 | 0 |
369903 | 369903 | 2020-07-26 | Lee | Alabama | 1081 | 2370 | 43 |
370010 | 370010 | 2020-07-26 | Lee | Arkansas | 5077 | 876 | 6 |
370216 | 370216 | 2020-07-26 | Lee | Florida | 12071 | 14414 | 258 |
370337 | 370337 | 2020-07-26 | Lee | Georgia | 13177 | 480 | 22 |
370507 | 370507 | 2020-07-26 | Lee | Illinois | 17103 | 126 | 2 |
370706 | 370706 | 2020-07-26 | Lee | Iowa | 19111 | 76 | 2 |
370918 | 370918 | 2020-07-26 | Lee | Kentucky | 21129 | 3 | 0 |
371308 | 371308 | 2020-07-26 | Lee | Mississippi | 28081 | 1002 | 26 |
371793 | 371793 | 2020-07-26 | Lee | North Carolina | 37105 | 1068 | 9 |
372278 | 372278 | 2020-07-26 | Lee | South Carolina | 45061 | 435 | 25 |
372596 | 372596 | 2020-07-26 | Lee | Texas | 48287 | 143 | 3 |
372819 | 372819 | 2020-07-26 | Lee | Virginia | 51105 | 74 | 0 |
366693 | 366693 | 2020-07-25 | Lee | Alabama | 1081 | 2332 | 43 |
366800 | 366800 | 2020-07-25 | Lee | Arkansas | 5077 | 871 | 6 |
367006 | 367006 | 2020-07-25 | Lee | Florida | 12071 | 14291 | 258 |
367127 | 367127 | 2020-07-25 | Lee | Georgia | 13177 | 480 | 22 |
367297 | 367297 | 2020-07-25 | Lee | Illinois | 17103 | 125 | 2 |
367496 | 367496 | 2020-07-25 | Lee | Iowa | 19111 | 72 | 2 |
367708 | 367708 | 2020-07-25 | Lee | Kentucky | 21129 | 3 | 0 |
368098 | 368098 | 2020-07-25 | Lee | Mississippi | 28081 | 968 | 26 |
368581 | 368581 | 2020-07-25 | Lee | North Carolina | 37105 | 1055 | 9 |
369066 | 369066 | 2020-07-25 | Lee | South Carolina | 45061 | 427 | 25 |
369384 | 369384 | 2020-07-25 | Lee | Texas | 48287 | 143 | 3 |
369607 | 369607 | 2020-07-25 | Lee | Virginia | 51105 | 66 | 0 |
363486 | 363486 | 2020-07-24 | Lee | Alabama | 1081 | 2292 | 42 |
363593 | 363593 | 2020-07-24 | Lee | Arkansas | 5077 | 869 | 6 |
363799 | 363799 | 2020-07-24 | Lee | Florida | 12071 | 14045 | 252 |
363920 | 363920 | 2020-07-24 | Lee | Georgia | 13177 | 472 | 22 |
364090 | 364090 | 2020-07-24 | Lee | Illinois | 17103 | 121 | 2 |
364289 | 364289 | 2020-07-24 | Lee | Iowa | 19111 | 70 | 2 |
364501 | 364501 | 2020-07-24 | Lee | Kentucky | 21129 | 3 | 0 |
364890 | 364890 | 2020-07-24 | Lee | Mississippi | 28081 | 941 | 26 |
365372 | 365372 | 2020-07-24 | Lee | North Carolina | 37105 | 1044 | 9 |
365857 | 365857 | 2020-07-24 | Lee | South Carolina | 45061 | 420 | 25 |
366175 | 366175 | 2020-07-24 | Lee | Texas | 48287 | 134 | 3 |
366398 | 366398 | 2020-07-24 | Lee | Virginia | 51105 | 61 | 0 |
360280 | 360280 | 2020-07-23 | Lee | Alabama | 1081 | 2261 | 41 |
360386 | 360386 | 2020-07-23 | Lee | Arkansas | 5077 | 868 | 6 |
360592 | 360592 | 2020-07-23 | Lee | Florida | 12071 | 13767 | 247 |
360713 | 360713 | 2020-07-23 | Lee | Georgia | 13177 | 464 | 22 |
360883 | 360883 | 2020-07-23 | Lee | Illinois | 17103 | 120 | 2 |
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);