ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,318 rows where county = "Lee" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

county

  • Lee · 1,318 ✖
Link rowid date ▲ county state fips cases deaths
334416 334416 2020-07-15 Lee Alabama 1081 1845 38
334523 334523 2020-07-15 Lee Arkansas 5077 851 5
334728 334728 2020-07-15 Lee Florida 12071 10848 206
334849 334849 2020-07-15 Lee Georgia 13177 436 22
335019 335019 2020-07-15 Lee Illinois 17103 110 2
335218 335218 2020-07-15 Lee Iowa 19111 54 2
335429 335429 2020-07-15 Lee Kentucky 21129 1 0
335818 335818 2020-07-15 Lee Mississippi 28081 662 23
336294 336294 2020-07-15 Lee North Carolina 37105 952 8
336778 336778 2020-07-15 Lee South Carolina 45061 356 23
337095 337095 2020-07-15 Lee Texas 48287 103 3
337315 337315 2020-07-15 Lee Virginia 51105 26 0
331225 331225 2020-07-14 Lee Alabama 1081 1768 38
331332 331332 2020-07-14 Lee Arkansas 5077 850 5
331537 331537 2020-07-14 Lee Florida 12071 10630 203
331658 331658 2020-07-14 Lee Georgia 13177 432 22
331828 331828 2020-07-14 Lee Illinois 17103 109 2
332027 332027 2020-07-14 Lee Iowa 19111 54 2
332238 332238 2020-07-14 Lee Kentucky 21129 1 0
332627 332627 2020-07-14 Lee Mississippi 28081 640 23
333102 333102 2020-07-14 Lee North Carolina 37105 947 8
333586 333586 2020-07-14 Lee South Carolina 45061 350 23
333902 333902 2020-07-14 Lee Texas 48287 98 3
334122 334122 2020-07-14 Lee Virginia 51105 22 0
328041 328041 2020-07-13 Lee Alabama 1081 1695 38
328148 328148 2020-07-13 Lee Arkansas 5077 828 4
328352 328352 2020-07-13 Lee Florida 12071 10343 188
328473 328473 2020-07-13 Lee Georgia 13177 426 22
328643 328643 2020-07-13 Lee Illinois 17103 107 2
328842 328842 2020-07-13 Lee Iowa 19111 54 2
329053 329053 2020-07-13 Lee Kentucky 21129 1 0
329442 329442 2020-07-13 Lee Mississippi 28081 630 22
329914 329914 2020-07-13 Lee North Carolina 37105 950 8
330396 330396 2020-07-13 Lee South Carolina 45061 344 23
330712 330712 2020-07-13 Lee Texas 48287 98 3
330931 330931 2020-07-13 Lee Virginia 51105 20 0
324857 324857 2020-07-12 Lee Alabama 1081 1636 38
324964 324964 2020-07-12 Lee Arkansas 5077 827 4
325168 325168 2020-07-12 Lee Florida 12071 10122 187
325289 325289 2020-07-12 Lee Georgia 13177 423 22
325459 325459 2020-07-12 Lee Illinois 17103 107 2
325658 325658 2020-07-12 Lee Iowa 19111 54 2
325869 325869 2020-07-12 Lee Kentucky 21129 1 0
326258 326258 2020-07-12 Lee Mississippi 28081 628 22
326729 326729 2020-07-12 Lee North Carolina 37105 927 8
327212 327212 2020-07-12 Lee South Carolina 45061 345 23
327528 327528 2020-07-12 Lee Texas 48287 98 3
327747 327747 2020-07-12 Lee Virginia 51105 19 0
321678 321678 2020-07-11 Lee Alabama 1081 1611 38
321785 321785 2020-07-11 Lee Arkansas 5077 825 3
321989 321989 2020-07-11 Lee Florida 12071 8847 186
322110 322110 2020-07-11 Lee Georgia 13177 418 22
322280 322280 2020-07-11 Lee Illinois 17103 105 2
322479 322479 2020-07-11 Lee Iowa 19111 54 2
322688 322688 2020-07-11 Lee Kentucky 21129 1 0
323077 323077 2020-07-11 Lee Mississippi 28081 612 22
323547 323547 2020-07-11 Lee North Carolina 37105 918 8
324029 324029 2020-07-11 Lee South Carolina 45061 337 22
324345 324345 2020-07-11 Lee Texas 48287 92 3
324564 324564 2020-07-11 Lee Virginia 51105 17 0
318501 318501 2020-07-10 Lee Alabama 1081 1571 38
318608 318608 2020-07-10 Lee Arkansas 5077 818 3
318812 318812 2020-07-10 Lee Florida 12071 8573 179
318933 318933 2020-07-10 Lee Georgia 13177 418 22
319103 319103 2020-07-10 Lee Illinois 17103 105 2
319302 319302 2020-07-10 Lee Iowa 19111 54 2
319511 319511 2020-07-10 Lee Kentucky 21129 1 0
319900 319900 2020-07-10 Lee Mississippi 28081 600 22
320369 320369 2020-07-10 Lee North Carolina 37105 909 8
320851 320851 2020-07-10 Lee South Carolina 45061 340 22
321166 321166 2020-07-10 Lee Texas 48287 89 3
321385 321385 2020-07-10 Lee Virginia 51105 17 0
315330 315330 2020-07-09 Lee Alabama 1081 1527 38
315437 315437 2020-07-09 Lee Arkansas 5077 817 3
315641 315641 2020-07-09 Lee Florida 12071 8339 176
315762 315762 2020-07-09 Lee Georgia 13177 414 22
315932 315932 2020-07-09 Lee Illinois 17103 104 2
316131 316131 2020-07-09 Lee Iowa 19111 54 2
316338 316338 2020-07-09 Lee Kentucky 21129 1 0
316727 316727 2020-07-09 Lee Mississippi 28081 586 21
317194 317194 2020-07-09 Lee North Carolina 37105 901 8
317675 317675 2020-07-09 Lee South Carolina 45061 331 22
317989 317989 2020-07-09 Lee Texas 48287 92 3
318208 318208 2020-07-09 Lee Virginia 51105 15 0
312157 312157 2020-07-08 Lee Alabama 1081 1491 38
312264 312264 2020-07-08 Lee Arkansas 5077 815 3
312468 312468 2020-07-08 Lee Florida 12071 8124 171
312589 312589 2020-07-08 Lee Georgia 13177 413 22
312760 312760 2020-07-08 Lee Illinois 17103 104 2
312959 312959 2020-07-08 Lee Iowa 19111 54 2
313166 313166 2020-07-08 Lee Kentucky 21129 1 0
313555 313555 2020-07-08 Lee Mississippi 28081 575 21
314022 314022 2020-07-08 Lee North Carolina 37105 888 8
314504 314504 2020-07-08 Lee South Carolina 45061 331 22
314818 314818 2020-07-08 Lee Texas 48287 88 3
315037 315037 2020-07-08 Lee Virginia 51105 15 0
308990 308990 2020-07-07 Lee Alabama 1081 1459 38
309096 309096 2020-07-07 Lee Arkansas 5077 805 3
309300 309300 2020-07-07 Lee Florida 12071 7858 172
309421 309421 2020-07-07 Lee Georgia 13177 410 22

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1088.228ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette