ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where county = "Lawrence" and deaths = 29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- Indiana 36
- Kentucky 18
- Illinois 9
- Mississippi 8
- Arkansas 2
- Ohio 1
- Pennsylvania 1
- South Dakota 1
county 1
- Lawrence · 76 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1678363 | 1678363 | 2021-09-02 | Lawrence | Mississippi | 28077 | 1929 | 29 |
1675115 | 1675115 | 2021-09-01 | Lawrence | Mississippi | 28077 | 1906 | 29 |
1671867 | 1671867 | 2021-08-31 | Lawrence | Mississippi | 28077 | 1890 | 29 |
1668620 | 1668620 | 2021-08-30 | Lawrence | Mississippi | 28077 | 1885 | 29 |
1665373 | 1665373 | 2021-08-29 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1662125 | 1662125 | 2021-08-28 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1658877 | 1658877 | 2021-08-27 | Lawrence | Mississippi | 28077 | 1852 | 29 |
1655628 | 1655628 | 2021-08-26 | Lawrence | Mississippi | 28077 | 1827 | 29 |
1632497 | 1632497 | 2021-08-19 | Lawrence | Kentucky | 21127 | 1699 | 29 |
1629250 | 1629250 | 2021-08-18 | Lawrence | Kentucky | 21127 | 1687 | 29 |
1626003 | 1626003 | 2021-08-17 | Lawrence | Kentucky | 21127 | 1673 | 29 |
1622756 | 1622756 | 2021-08-16 | Lawrence | Kentucky | 21127 | 1660 | 29 |
1619509 | 1619509 | 2021-08-15 | Lawrence | Kentucky | 21127 | 1644 | 29 |
1616261 | 1616261 | 2021-08-14 | Lawrence | Kentucky | 21127 | 1644 | 29 |
1613012 | 1613012 | 2021-08-13 | Lawrence | Kentucky | 21127 | 1644 | 29 |
1609764 | 1609764 | 2021-08-12 | Lawrence | Kentucky | 21127 | 1612 | 29 |
1606515 | 1606515 | 2021-08-11 | Lawrence | Kentucky | 21127 | 1607 | 29 |
1603266 | 1603266 | 2021-08-10 | Lawrence | Kentucky | 21127 | 1591 | 29 |
1600017 | 1600017 | 2021-08-09 | Lawrence | Kentucky | 21127 | 1578 | 29 |
1596769 | 1596769 | 2021-08-08 | Lawrence | Kentucky | 21127 | 1562 | 29 |
1593520 | 1593520 | 2021-08-07 | Lawrence | Kentucky | 21127 | 1562 | 29 |
1590271 | 1590271 | 2021-08-06 | Lawrence | Kentucky | 21127 | 1562 | 29 |
1587022 | 1587022 | 2021-08-05 | Lawrence | Kentucky | 21127 | 1556 | 29 |
1583772 | 1583772 | 2021-08-04 | Lawrence | Kentucky | 21127 | 1547 | 29 |
1580522 | 1580522 | 2021-08-03 | Lawrence | Kentucky | 21127 | 1544 | 29 |
1577273 | 1577273 | 2021-08-02 | Lawrence | Kentucky | 21127 | 1543 | 29 |
927579 | 927579 | 2021-01-14 | Lawrence | Illinois | 17101 | 2138 | 29 |
924333 | 924333 | 2021-01-13 | Lawrence | Illinois | 17101 | 2131 | 29 |
921088 | 921088 | 2021-01-12 | Lawrence | Illinois | 17101 | 2121 | 29 |
917843 | 917843 | 2021-01-11 | Lawrence | Illinois | 17101 | 2107 | 29 |
914598 | 914598 | 2021-01-10 | Lawrence | Illinois | 17101 | 2079 | 29 |
911353 | 911353 | 2021-01-09 | Lawrence | Illinois | 17101 | 2077 | 29 |
908108 | 908108 | 2021-01-08 | Lawrence | Illinois | 17101 | 2070 | 29 |
909956 | 909956 | 2021-01-08 | Lawrence | South Dakota | 46081 | 2634 | 29 |
904862 | 904862 | 2021-01-07 | Lawrence | Illinois | 17101 | 2039 | 29 |
901617 | 901617 | 2021-01-06 | Lawrence | Illinois | 17101 | 2029 | 29 |
784282 | 784282 | 2020-12-01 | Lawrence | Arkansas | 5075 | 1181 | 29 |
781037 | 781037 | 2020-11-30 | Lawrence | Arkansas | 5075 | 1171 | 29 |
692141 | 692141 | 2020-11-02 | Lawrence | Ohio | 39087 | 1114 | 29 |
656656 | 656656 | 2020-10-22 | Lawrence | Pennsylvania | 42073 | 777 | 29 |
528698 | 528698 | 2020-09-13 | Lawrence | Indiana | 18093 | 494 | 29 |
525462 | 525462 | 2020-09-12 | Lawrence | Indiana | 18093 | 492 | 29 |
522226 | 522226 | 2020-09-11 | Lawrence | Indiana | 18093 | 488 | 29 |
518989 | 518989 | 2020-09-10 | Lawrence | Indiana | 18093 | 485 | 29 |
515754 | 515754 | 2020-09-09 | Lawrence | Indiana | 18093 | 484 | 29 |
512521 | 512521 | 2020-09-08 | Lawrence | Indiana | 18093 | 483 | 29 |
509288 | 509288 | 2020-09-07 | Lawrence | Indiana | 18093 | 482 | 29 |
506056 | 506056 | 2020-09-06 | Lawrence | Indiana | 18093 | 482 | 29 |
502822 | 502822 | 2020-09-05 | Lawrence | Indiana | 18093 | 476 | 29 |
499588 | 499588 | 2020-09-04 | Lawrence | Indiana | 18093 | 471 | 29 |
496355 | 496355 | 2020-09-03 | Lawrence | Indiana | 18093 | 469 | 29 |
493121 | 493121 | 2020-09-02 | Lawrence | Indiana | 18093 | 466 | 29 |
489888 | 489888 | 2020-09-01 | Lawrence | Indiana | 18093 | 465 | 29 |
486655 | 486655 | 2020-08-31 | Lawrence | Indiana | 18093 | 456 | 29 |
483420 | 483420 | 2020-08-30 | Lawrence | Indiana | 18093 | 453 | 29 |
480186 | 480186 | 2020-08-29 | Lawrence | Indiana | 18093 | 446 | 29 |
476953 | 476953 | 2020-08-28 | Lawrence | Indiana | 18093 | 444 | 29 |
473720 | 473720 | 2020-08-27 | Lawrence | Indiana | 18093 | 442 | 29 |
470488 | 470488 | 2020-08-26 | Lawrence | Indiana | 18093 | 433 | 29 |
467259 | 467259 | 2020-08-25 | Lawrence | Indiana | 18093 | 426 | 29 |
464030 | 464030 | 2020-08-24 | Lawrence | Indiana | 18093 | 420 | 29 |
460801 | 460801 | 2020-08-23 | Lawrence | Indiana | 18093 | 387 | 29 |
457574 | 457574 | 2020-08-22 | Lawrence | Indiana | 18093 | 383 | 29 |
454346 | 454346 | 2020-08-21 | Lawrence | Indiana | 18093 | 379 | 29 |
451118 | 451118 | 2020-08-20 | Lawrence | Indiana | 18093 | 375 | 29 |
447890 | 447890 | 2020-08-19 | Lawrence | Indiana | 18093 | 374 | 29 |
444663 | 444663 | 2020-08-18 | Lawrence | Indiana | 18093 | 372 | 29 |
441437 | 441437 | 2020-08-17 | Lawrence | Indiana | 18093 | 370 | 29 |
438211 | 438211 | 2020-08-16 | Lawrence | Indiana | 18093 | 366 | 29 |
434985 | 434985 | 2020-08-15 | Lawrence | Indiana | 18093 | 364 | 29 |
431760 | 431760 | 2020-08-14 | Lawrence | Indiana | 18093 | 361 | 29 |
428532 | 428532 | 2020-08-13 | Lawrence | Indiana | 18093 | 360 | 29 |
425308 | 425308 | 2020-08-12 | Lawrence | Indiana | 18093 | 359 | 29 |
422087 | 422087 | 2020-08-11 | Lawrence | Indiana | 18093 | 354 | 29 |
418864 | 418864 | 2020-08-10 | Lawrence | Indiana | 18093 | 352 | 29 |
415643 | 415643 | 2020-08-09 | Lawrence | Indiana | 18093 | 348 | 29 |
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);