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 124
- Georgia 119
- Alabama 114
- South Carolina 112
- Mississippi 110
- North Carolina 108
- Virginia 108
- Arkansas 97
- Texas 97
- Illinois 95
- Iowa 95
- Kentucky 41
fips 12
county 1
- Lee · 1,220 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
309546 | 309546 | 2020-07-07 | Lee | Florida | 12071 | 7858 | 172 |
309667 | 309667 | 2020-07-07 | Lee | Georgia | 13177 | 410 | 22 |
309838 | 309838 | 2020-07-07 | Lee | Illinois | 17103 | 104 | 2 |
310037 | 310037 | 2020-07-07 | Lee | Iowa | 19111 | 54 | 2 |
310244 | 310244 | 2020-07-07 | Lee | Kentucky | 21129 | 1 | 0 |
310633 | 310633 | 2020-07-07 | Lee | Mississippi | 28081 | 562 | 20 |
311099 | 311099 | 2020-07-07 | Lee | North Carolina | 37105 | 875 | 8 |
311580 | 311580 | 2020-07-07 | Lee | South Carolina | 45061 | 330 | 22 |
311892 | 311892 | 2020-07-07 | Lee | Texas | 48287 | 85 | 3 |
312113 | 312113 | 2020-07-07 | Lee | Virginia | 51105 | 16 | 0 |
306068 | 306068 | 2020-07-06 | Lee | Alabama | 1081 | 1435 | 38 |
306174 | 306174 | 2020-07-06 | Lee | Arkansas | 5077 | 803 | 3 |
306378 | 306378 | 2020-07-06 | Lee | Florida | 12071 | 7660 | 167 |
306499 | 306499 | 2020-07-06 | Lee | Georgia | 13177 | 405 | 22 |
306670 | 306670 | 2020-07-06 | Lee | Illinois | 17103 | 103 | 2 |
306869 | 306869 | 2020-07-06 | Lee | Iowa | 19111 | 54 | 2 |
307076 | 307076 | 2020-07-06 | Lee | Kentucky | 21129 | 1 | 0 |
307465 | 307465 | 2020-07-06 | Lee | Mississippi | 28081 | 552 | 19 |
307931 | 307931 | 2020-07-06 | Lee | North Carolina | 37105 | 871 | 8 |
308411 | 308411 | 2020-07-06 | Lee | South Carolina | 45061 | 310 | 22 |
308723 | 308723 | 2020-07-06 | Lee | Texas | 48287 | 85 | 3 |
308944 | 308944 | 2020-07-06 | Lee | Virginia | 51105 | 16 | 0 |
302904 | 302904 | 2020-07-05 | Lee | Alabama | 1081 | 1408 | 38 |
303010 | 303010 | 2020-07-05 | Lee | Arkansas | 5077 | 803 | 2 |
303214 | 303214 | 2020-07-05 | Lee | Florida | 12071 | 7497 | 165 |
303335 | 303335 | 2020-07-05 | Lee | Georgia | 13177 | 402 | 22 |
303505 | 303505 | 2020-07-05 | Lee | Illinois | 17103 | 101 | 2 |
303704 | 303704 | 2020-07-05 | Lee | Iowa | 19111 | 54 | 2 |
303909 | 303909 | 2020-07-05 | Lee | Kentucky | 21129 | 1 | 0 |
304298 | 304298 | 2020-07-05 | Lee | Mississippi | 28081 | 547 | 18 |
304764 | 304764 | 2020-07-05 | Lee | North Carolina | 37105 | 869 | 8 |
305244 | 305244 | 2020-07-05 | Lee | South Carolina | 45061 | 308 | 22 |
305555 | 305555 | 2020-07-05 | Lee | Texas | 48287 | 72 | 3 |
305776 | 305776 | 2020-07-05 | Lee | Virginia | 51105 | 15 | 0 |
299740 | 299740 | 2020-07-04 | Lee | Alabama | 1081 | 1383 | 38 |
299846 | 299846 | 2020-07-04 | Lee | Arkansas | 5077 | 798 | 2 |
300050 | 300050 | 2020-07-04 | Lee | Florida | 12071 | 7214 | 162 |
300171 | 300171 | 2020-07-04 | Lee | Georgia | 13177 | 398 | 22 |
300341 | 300341 | 2020-07-04 | Lee | Illinois | 17103 | 101 | 2 |
300540 | 300540 | 2020-07-04 | Lee | Iowa | 19111 | 54 | 2 |
300745 | 300745 | 2020-07-04 | Lee | Kentucky | 21129 | 1 | 0 |
301134 | 301134 | 2020-07-04 | Lee | Mississippi | 28081 | 547 | 18 |
301601 | 301601 | 2020-07-04 | Lee | North Carolina | 37105 | 858 | 8 |
302081 | 302081 | 2020-07-04 | Lee | South Carolina | 45061 | 307 | 22 |
302391 | 302391 | 2020-07-04 | Lee | Texas | 48287 | 72 | 3 |
302612 | 302612 | 2020-07-04 | Lee | Virginia | 51105 | 12 | 0 |
296578 | 296578 | 2020-07-03 | Lee | Alabama | 1081 | 1326 | 38 |
296684 | 296684 | 2020-07-03 | Lee | Arkansas | 5077 | 761 | 2 |
296888 | 296888 | 2020-07-03 | Lee | Florida | 12071 | 6667 | 162 |
297009 | 297009 | 2020-07-03 | Lee | Georgia | 13177 | 397 | 22 |
297179 | 297179 | 2020-07-03 | Lee | Illinois | 17103 | 98 | 2 |
297378 | 297378 | 2020-07-03 | Lee | Iowa | 19111 | 53 | 2 |
297583 | 297583 | 2020-07-03 | Lee | Kentucky | 21129 | 1 | 0 |
297971 | 297971 | 2020-07-03 | Lee | Mississippi | 28081 | 532 | 18 |
298438 | 298438 | 2020-07-03 | Lee | North Carolina | 37105 | 856 | 8 |
298917 | 298917 | 2020-07-03 | Lee | South Carolina | 45061 | 301 | 22 |
299227 | 299227 | 2020-07-03 | Lee | Texas | 48287 | 63 | 3 |
299448 | 299448 | 2020-07-03 | Lee | Virginia | 51105 | 12 | 0 |
293423 | 293423 | 2020-07-02 | Lee | Alabama | 1081 | 1267 | 38 |
293528 | 293528 | 2020-07-02 | Lee | Arkansas | 5077 | 755 | 2 |
293732 | 293732 | 2020-07-02 | Lee | Florida | 12071 | 6222 | 161 |
293853 | 293853 | 2020-07-02 | Lee | Georgia | 13177 | 393 | 22 |
294022 | 294022 | 2020-07-02 | Lee | Illinois | 17103 | 98 | 2 |
294220 | 294220 | 2020-07-02 | Lee | Iowa | 19111 | 50 | 2 |
294425 | 294425 | 2020-07-02 | Lee | Kentucky | 21129 | 1 | 0 |
294813 | 294813 | 2020-07-02 | Lee | Mississippi | 28081 | 518 | 16 |
295278 | 295278 | 2020-07-02 | Lee | North Carolina | 37105 | 843 | 8 |
295758 | 295758 | 2020-07-02 | Lee | South Carolina | 45061 | 295 | 22 |
296066 | 296066 | 2020-07-02 | Lee | Texas | 48287 | 62 | 3 |
296286 | 296286 | 2020-07-02 | Lee | Virginia | 51105 | 12 | 0 |
290270 | 290270 | 2020-07-01 | Lee | Alabama | 1081 | 1211 | 38 |
290374 | 290374 | 2020-07-01 | Lee | Arkansas | 5077 | 746 | 2 |
290578 | 290578 | 2020-07-01 | Lee | Florida | 12071 | 5868 | 159 |
290699 | 290699 | 2020-07-01 | Lee | Georgia | 13177 | 390 | 22 |
290868 | 290868 | 2020-07-01 | Lee | Illinois | 17103 | 97 | 2 |
291066 | 291066 | 2020-07-01 | Lee | Iowa | 19111 | 49 | 2 |
291271 | 291271 | 2020-07-01 | Lee | Kentucky | 21129 | 1 | 0 |
291659 | 291659 | 2020-07-01 | Lee | Mississippi | 28081 | 493 | 16 |
292123 | 292123 | 2020-07-01 | Lee | North Carolina | 37105 | 841 | 8 |
292602 | 292602 | 2020-07-01 | Lee | South Carolina | 45061 | 293 | 22 |
292911 | 292911 | 2020-07-01 | Lee | Texas | 48287 | 60 | 3 |
293131 | 293131 | 2020-07-01 | Lee | Virginia | 51105 | 11 | 0 |
287120 | 287120 | 2020-06-30 | Lee | Alabama | 1081 | 1188 | 37 |
287223 | 287223 | 2020-06-30 | Lee | Arkansas | 5077 | 651 | 2 |
287427 | 287427 | 2020-06-30 | Lee | Florida | 12071 | 5587 | 158 |
287548 | 287548 | 2020-06-30 | Lee | Georgia | 13177 | 388 | 22 |
287718 | 287718 | 2020-06-30 | Lee | Illinois | 17103 | 97 | 2 |
287916 | 287916 | 2020-06-30 | Lee | Iowa | 19111 | 48 | 2 |
288121 | 288121 | 2020-06-30 | Lee | Kentucky | 21129 | 1 | 0 |
288508 | 288508 | 2020-06-30 | Lee | Mississippi | 28081 | 477 | 16 |
288971 | 288971 | 2020-06-30 | Lee | North Carolina | 37105 | 823 | 8 |
289450 | 289450 | 2020-06-30 | Lee | South Carolina | 45061 | 289 | 22 |
289758 | 289758 | 2020-06-30 | Lee | Texas | 48287 | 59 | 3 |
289978 | 289978 | 2020-06-30 | Lee | Virginia | 51105 | 11 | 0 |
283974 | 283974 | 2020-06-29 | Lee | Alabama | 1081 | 1157 | 37 |
284077 | 284077 | 2020-06-29 | Lee | Arkansas | 5077 | 641 | 2 |
284281 | 284281 | 2020-06-29 | Lee | Florida | 12071 | 5362 | 156 |
284402 | 284402 | 2020-06-29 | Lee | Georgia | 13177 | 385 | 22 |
284569 | 284569 | 2020-06-29 | Lee | Illinois | 17103 | 97 | 2 |
284767 | 284767 | 2020-06-29 | Lee | Iowa | 19111 | 47 | 1 |
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);