ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,522 rows where county = "Lawrence" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 11
- Mississippi 211
- Indiana 207
- Arkansas 206
- Ohio 206
- Pennsylvania 206
- Alabama 205
- South Dakota 204
- Tennessee 201
- Kentucky 200
- Illinois 193
- Missouri 167
fips 11
county 1
- Lawrence · 2,206 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635534 | 635534 | 2020-10-16 | Lawrence | Illinois | 17101 | 302 | 8 |
635633 | 635633 | 2020-10-16 | Lawrence | Indiana | 18093 | 716 | 34 |
635948 | 635948 | 2020-10-16 | Lawrence | Kentucky | 21127 | 115 | 0 |
636337 | 636337 | 2020-10-16 | Lawrence | Mississippi | 28077 | 489 | 14 |
636437 | 636437 | 2020-10-16 | Lawrence | Missouri | 29109 | 928 | 13 |
636987 | 636987 | 2020-10-16 | Lawrence | Ohio | 39087 | 859 | 24 |
637182 | 637182 | 2020-10-16 | Lawrence | Pennsylvania | 42073 | 685 | 24 |
637383 | 637383 | 2020-10-16 | Lawrence | South Dakota | 46081 | 630 | 5 |
637459 | 637459 | 2020-10-16 | Lawrence | Tennessee | 47099 | 1376 | 17 |
631679 | 631679 | 2020-10-15 | Lawrence | Alabama | 1079 | 759 | 30 |
631786 | 631786 | 2020-10-15 | Lawrence | Arkansas | 5075 | 693 | 14 |
632288 | 632288 | 2020-10-15 | Lawrence | Illinois | 17101 | 296 | 7 |
632387 | 632387 | 2020-10-15 | Lawrence | Indiana | 18093 | 672 | 33 |
632702 | 632702 | 2020-10-15 | Lawrence | Kentucky | 21127 | 110 | 0 |
633091 | 633091 | 2020-10-15 | Lawrence | Mississippi | 28077 | 483 | 14 |
633191 | 633191 | 2020-10-15 | Lawrence | Missouri | 29109 | 907 | 13 |
633741 | 633741 | 2020-10-15 | Lawrence | Ohio | 39087 | 846 | 24 |
633936 | 633936 | 2020-10-15 | Lawrence | Pennsylvania | 42073 | 681 | 24 |
634137 | 634137 | 2020-10-15 | Lawrence | South Dakota | 46081 | 611 | 5 |
634213 | 634213 | 2020-10-15 | Lawrence | Tennessee | 47099 | 1368 | 17 |
628435 | 628435 | 2020-10-14 | Lawrence | Alabama | 1079 | 748 | 28 |
628542 | 628542 | 2020-10-14 | Lawrence | Arkansas | 5075 | 640 | 13 |
629044 | 629044 | 2020-10-14 | Lawrence | Illinois | 17101 | 293 | 6 |
629143 | 629143 | 2020-10-14 | Lawrence | Indiana | 18093 | 667 | 33 |
629458 | 629458 | 2020-10-14 | Lawrence | Kentucky | 21127 | 108 | 0 |
629846 | 629846 | 2020-10-14 | Lawrence | Mississippi | 28077 | 479 | 14 |
629946 | 629946 | 2020-10-14 | Lawrence | Missouri | 29109 | 880 | 14 |
630496 | 630496 | 2020-10-14 | Lawrence | Ohio | 39087 | 831 | 24 |
630691 | 630691 | 2020-10-14 | Lawrence | Pennsylvania | 42073 | 653 | 24 |
630892 | 630892 | 2020-10-14 | Lawrence | South Dakota | 46081 | 596 | 5 |
630968 | 630968 | 2020-10-14 | Lawrence | Tennessee | 47099 | 1332 | 17 |
625192 | 625192 | 2020-10-13 | Lawrence | Alabama | 1079 | 741 | 28 |
625299 | 625299 | 2020-10-13 | Lawrence | Arkansas | 5075 | 613 | 13 |
625801 | 625801 | 2020-10-13 | Lawrence | Illinois | 17101 | 288 | 6 |
625900 | 625900 | 2020-10-13 | Lawrence | Indiana | 18093 | 659 | 32 |
626214 | 626214 | 2020-10-13 | Lawrence | Kentucky | 21127 | 90 | 0 |
626602 | 626602 | 2020-10-13 | Lawrence | Mississippi | 28077 | 474 | 14 |
626702 | 626702 | 2020-10-13 | Lawrence | Missouri | 29109 | 823 | 13 |
627252 | 627252 | 2020-10-13 | Lawrence | Ohio | 39087 | 809 | 24 |
627447 | 627447 | 2020-10-13 | Lawrence | Pennsylvania | 42073 | 643 | 23 |
627648 | 627648 | 2020-10-13 | Lawrence | South Dakota | 46081 | 569 | 5 |
627724 | 627724 | 2020-10-13 | Lawrence | Tennessee | 47099 | 1307 | 17 |
621949 | 621949 | 2020-10-12 | Lawrence | Alabama | 1079 | 729 | 28 |
622056 | 622056 | 2020-10-12 | Lawrence | Arkansas | 5075 | 604 | 13 |
622559 | 622559 | 2020-10-12 | Lawrence | Illinois | 17101 | 288 | 6 |
622658 | 622658 | 2020-10-12 | Lawrence | Indiana | 18093 | 650 | 32 |
622972 | 622972 | 2020-10-12 | Lawrence | Kentucky | 21127 | 88 | 0 |
623360 | 623360 | 2020-10-12 | Lawrence | Mississippi | 28077 | 469 | 14 |
623460 | 623460 | 2020-10-12 | Lawrence | Missouri | 29109 | 823 | 13 |
624010 | 624010 | 2020-10-12 | Lawrence | Ohio | 39087 | 802 | 24 |
624205 | 624205 | 2020-10-12 | Lawrence | Pennsylvania | 42073 | 628 | 23 |
624406 | 624406 | 2020-10-12 | Lawrence | South Dakota | 46081 | 567 | 5 |
624482 | 624482 | 2020-10-12 | Lawrence | Tennessee | 47099 | 1296 | 17 |
618706 | 618706 | 2020-10-11 | Lawrence | Alabama | 1079 | 716 | 28 |
618813 | 618813 | 2020-10-11 | Lawrence | Arkansas | 5075 | 592 | 13 |
619315 | 619315 | 2020-10-11 | Lawrence | Illinois | 17101 | 288 | 6 |
619414 | 619414 | 2020-10-11 | Lawrence | Indiana | 18093 | 637 | 32 |
619728 | 619728 | 2020-10-11 | Lawrence | Kentucky | 21127 | 86 | 0 |
620117 | 620117 | 2020-10-11 | Lawrence | Mississippi | 28077 | 465 | 14 |
620217 | 620217 | 2020-10-11 | Lawrence | Missouri | 29109 | 823 | 13 |
620767 | 620767 | 2020-10-11 | Lawrence | Ohio | 39087 | 792 | 24 |
620962 | 620962 | 2020-10-11 | Lawrence | Pennsylvania | 42073 | 622 | 23 |
621163 | 621163 | 2020-10-11 | Lawrence | South Dakota | 46081 | 561 | 5 |
621239 | 621239 | 2020-10-11 | Lawrence | Tennessee | 47099 | 1262 | 17 |
615464 | 615464 | 2020-10-10 | Lawrence | Alabama | 1079 | 711 | 28 |
615571 | 615571 | 2020-10-10 | Lawrence | Arkansas | 5075 | 583 | 13 |
616073 | 616073 | 2020-10-10 | Lawrence | Illinois | 17101 | 286 | 6 |
616172 | 616172 | 2020-10-10 | Lawrence | Indiana | 18093 | 628 | 32 |
616486 | 616486 | 2020-10-10 | Lawrence | Kentucky | 21127 | 80 | 0 |
616875 | 616875 | 2020-10-10 | Lawrence | Mississippi | 28077 | 465 | 14 |
616975 | 616975 | 2020-10-10 | Lawrence | Missouri | 29109 | 823 | 13 |
617525 | 617525 | 2020-10-10 | Lawrence | Ohio | 39087 | 788 | 24 |
617719 | 617719 | 2020-10-10 | Lawrence | Pennsylvania | 42073 | 608 | 23 |
617920 | 617920 | 2020-10-10 | Lawrence | South Dakota | 46081 | 550 | 5 |
617996 | 617996 | 2020-10-10 | Lawrence | Tennessee | 47099 | 1244 | 17 |
612223 | 612223 | 2020-10-09 | Lawrence | Alabama | 1079 | 699 | 26 |
612330 | 612330 | 2020-10-09 | Lawrence | Arkansas | 5075 | 567 | 13 |
612832 | 612832 | 2020-10-09 | Lawrence | Illinois | 17101 | 282 | 6 |
612931 | 612931 | 2020-10-09 | Lawrence | Indiana | 18093 | 617 | 32 |
613245 | 613245 | 2020-10-09 | Lawrence | Kentucky | 21127 | 78 | 0 |
613634 | 613634 | 2020-10-09 | Lawrence | Mississippi | 28077 | 463 | 14 |
613734 | 613734 | 2020-10-09 | Lawrence | Missouri | 29109 | 786 | 13 |
614283 | 614283 | 2020-10-09 | Lawrence | Ohio | 39087 | 778 | 23 |
614477 | 614477 | 2020-10-09 | Lawrence | Pennsylvania | 42073 | 602 | 23 |
614678 | 614678 | 2020-10-09 | Lawrence | South Dakota | 46081 | 533 | 5 |
614754 | 614754 | 2020-10-09 | Lawrence | Tennessee | 47099 | 1224 | 17 |
608981 | 608981 | 2020-10-08 | Lawrence | Alabama | 1079 | 689 | 26 |
609088 | 609088 | 2020-10-08 | Lawrence | Arkansas | 5075 | 546 | 13 |
609590 | 609590 | 2020-10-08 | Lawrence | Illinois | 17101 | 279 | 6 |
609689 | 609689 | 2020-10-08 | Lawrence | Indiana | 18093 | 600 | 32 |
610003 | 610003 | 2020-10-08 | Lawrence | Kentucky | 21127 | 77 | 0 |
610392 | 610392 | 2020-10-08 | Lawrence | Mississippi | 28077 | 459 | 14 |
610492 | 610492 | 2020-10-08 | Lawrence | Missouri | 29109 | 772 | 13 |
611042 | 611042 | 2020-10-08 | Lawrence | Ohio | 39087 | 766 | 23 |
611236 | 611236 | 2020-10-08 | Lawrence | Pennsylvania | 42073 | 593 | 23 |
611437 | 611437 | 2020-10-08 | Lawrence | South Dakota | 46081 | 525 | 5 |
611513 | 611513 | 2020-10-08 | Lawrence | Tennessee | 47099 | 1206 | 16 |
605738 | 605738 | 2020-10-07 | Lawrence | Alabama | 1079 | 685 | 26 |
605845 | 605845 | 2020-10-07 | Lawrence | Arkansas | 5075 | 508 | 13 |
606347 | 606347 | 2020-10-07 | Lawrence | Illinois | 17101 | 277 | 6 |
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);