ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where county = "Lawrence" and deaths = 5 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
- Kentucky 23
- South Dakota 23
- Alabama 17
- Arkansas 13
- Pennsylvania 6
- Mississippi 5
- Tennessee 3
- Ohio 2
- Indiana 1
county 1
- Lawrence · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
950710 | 950710 | 2021-01-21 | Lawrence | Kentucky | 21127 | 1021 | 5 |
947464 | 947464 | 2021-01-20 | Lawrence | Kentucky | 21127 | 1014 | 5 |
944217 | 944217 | 2021-01-19 | Lawrence | Kentucky | 21127 | 1001 | 5 |
940972 | 940972 | 2021-01-18 | Lawrence | Kentucky | 21127 | 999 | 5 |
937727 | 937727 | 2021-01-17 | Lawrence | Kentucky | 21127 | 997 | 5 |
934482 | 934482 | 2021-01-16 | Lawrence | Kentucky | 21127 | 993 | 5 |
931237 | 931237 | 2021-01-15 | Lawrence | Kentucky | 21127 | 987 | 5 |
927992 | 927992 | 2021-01-14 | Lawrence | Kentucky | 21127 | 977 | 5 |
924746 | 924746 | 2021-01-13 | Lawrence | Kentucky | 21127 | 964 | 5 |
921501 | 921501 | 2021-01-12 | Lawrence | Kentucky | 21127 | 947 | 5 |
918256 | 918256 | 2021-01-11 | Lawrence | Kentucky | 21127 | 932 | 5 |
915011 | 915011 | 2021-01-10 | Lawrence | Kentucky | 21127 | 932 | 5 |
911766 | 911766 | 2021-01-09 | Lawrence | Kentucky | 21127 | 925 | 5 |
908521 | 908521 | 2021-01-08 | Lawrence | Kentucky | 21127 | 911 | 5 |
905275 | 905275 | 2021-01-07 | Lawrence | Kentucky | 21127 | 906 | 5 |
902030 | 902030 | 2021-01-06 | Lawrence | Kentucky | 21127 | 894 | 5 |
898785 | 898785 | 2021-01-05 | Lawrence | Kentucky | 21127 | 876 | 5 |
895540 | 895540 | 2021-01-04 | Lawrence | Kentucky | 21127 | 846 | 5 |
892293 | 892293 | 2021-01-03 | Lawrence | Kentucky | 21127 | 837 | 5 |
889047 | 889047 | 2021-01-02 | Lawrence | Kentucky | 21127 | 825 | 5 |
885801 | 885801 | 2021-01-01 | Lawrence | Kentucky | 21127 | 758 | 5 |
882556 | 882556 | 2020-12-31 | Lawrence | Kentucky | 21127 | 758 | 5 |
879311 | 879311 | 2020-12-30 | Lawrence | Kentucky | 21127 | 758 | 5 |
653612 | 653612 | 2020-10-21 | Lawrence | South Dakota | 46081 | 710 | 5 |
650367 | 650367 | 2020-10-20 | Lawrence | South Dakota | 46081 | 693 | 5 |
647123 | 647123 | 2020-10-19 | Lawrence | South Dakota | 46081 | 676 | 5 |
643877 | 643877 | 2020-10-18 | Lawrence | South Dakota | 46081 | 662 | 5 |
640629 | 640629 | 2020-10-17 | Lawrence | South Dakota | 46081 | 641 | 5 |
637383 | 637383 | 2020-10-16 | Lawrence | South Dakota | 46081 | 630 | 5 |
634137 | 634137 | 2020-10-15 | Lawrence | South Dakota | 46081 | 611 | 5 |
630892 | 630892 | 2020-10-14 | Lawrence | South Dakota | 46081 | 596 | 5 |
627648 | 627648 | 2020-10-13 | Lawrence | South Dakota | 46081 | 569 | 5 |
624406 | 624406 | 2020-10-12 | Lawrence | South Dakota | 46081 | 567 | 5 |
621163 | 621163 | 2020-10-11 | Lawrence | South Dakota | 46081 | 561 | 5 |
617920 | 617920 | 2020-10-10 | Lawrence | South Dakota | 46081 | 550 | 5 |
614678 | 614678 | 2020-10-09 | Lawrence | South Dakota | 46081 | 533 | 5 |
611437 | 611437 | 2020-10-08 | Lawrence | South Dakota | 46081 | 525 | 5 |
608195 | 608195 | 2020-10-07 | Lawrence | South Dakota | 46081 | 513 | 5 |
604952 | 604952 | 2020-10-06 | Lawrence | South Dakota | 46081 | 487 | 5 |
601710 | 601710 | 2020-10-05 | Lawrence | South Dakota | 46081 | 475 | 5 |
598467 | 598467 | 2020-10-04 | Lawrence | South Dakota | 46081 | 466 | 5 |
595224 | 595224 | 2020-10-03 | Lawrence | South Dakota | 46081 | 457 | 5 |
591983 | 591983 | 2020-10-02 | Lawrence | South Dakota | 46081 | 449 | 5 |
588742 | 588742 | 2020-10-01 | Lawrence | South Dakota | 46081 | 442 | 5 |
585502 | 585502 | 2020-09-30 | Lawrence | South Dakota | 46081 | 428 | 5 |
582262 | 582262 | 2020-09-29 | Lawrence | South Dakota | 46081 | 418 | 5 |
511814 | 511814 | 2020-09-08 | Lawrence | Alabama | 1079 | 524 | 5 |
508581 | 508581 | 2020-09-07 | Lawrence | Alabama | 1079 | 523 | 5 |
505349 | 505349 | 2020-09-06 | Lawrence | Alabama | 1079 | 520 | 5 |
502115 | 502115 | 2020-09-05 | Lawrence | Alabama | 1079 | 518 | 5 |
498881 | 498881 | 2020-09-04 | Lawrence | Alabama | 1079 | 505 | 5 |
495648 | 495648 | 2020-09-03 | Lawrence | Alabama | 1079 | 503 | 5 |
492414 | 492414 | 2020-09-02 | Lawrence | Alabama | 1079 | 483 | 5 |
489181 | 489181 | 2020-09-01 | Lawrence | Alabama | 1079 | 480 | 5 |
485948 | 485948 | 2020-08-31 | Lawrence | Alabama | 1079 | 476 | 5 |
482713 | 482713 | 2020-08-30 | Lawrence | Alabama | 1079 | 472 | 5 |
479479 | 479479 | 2020-08-29 | Lawrence | Alabama | 1079 | 455 | 5 |
476246 | 476246 | 2020-08-28 | Lawrence | Alabama | 1079 | 448 | 5 |
473013 | 473013 | 2020-08-27 | Lawrence | Alabama | 1079 | 447 | 5 |
469781 | 469781 | 2020-08-26 | Lawrence | Alabama | 1079 | 442 | 5 |
466552 | 466552 | 2020-08-25 | Lawrence | Alabama | 1079 | 433 | 5 |
463323 | 463323 | 2020-08-24 | Lawrence | Alabama | 1079 | 425 | 5 |
460094 | 460094 | 2020-08-23 | Lawrence | Alabama | 1079 | 415 | 5 |
446004 | 446004 | 2020-08-18 | Lawrence | Ohio | 39087 | 364 | 5 |
442778 | 442778 | 2020-08-17 | Lawrence | Ohio | 39087 | 355 | 5 |
400249 | 400249 | 2020-08-04 | Lawrence | Mississippi | 28077 | 315 | 5 |
397035 | 397035 | 2020-08-03 | Lawrence | Mississippi | 28077 | 313 | 5 |
393819 | 393819 | 2020-08-02 | Lawrence | Mississippi | 28077 | 313 | 5 |
390602 | 390602 | 2020-08-01 | Lawrence | Mississippi | 28077 | 307 | 5 |
387385 | 387385 | 2020-07-31 | Lawrence | Mississippi | 28077 | 300 | 5 |
295882 | 295882 | 2020-07-02 | Lawrence | Tennessee | 47099 | 143 | 5 |
292726 | 292726 | 2020-07-01 | Lawrence | Tennessee | 47099 | 133 | 5 |
289574 | 289574 | 2020-06-30 | Lawrence | Tennessee | 47099 | 124 | 5 |
200062 | 200062 | 2020-06-02 | Lawrence | Arkansas | 5075 | 85 | 5 |
196989 | 196989 | 2020-06-01 | Lawrence | Arkansas | 5075 | 84 | 5 |
193919 | 193919 | 2020-05-31 | Lawrence | Arkansas | 5075 | 84 | 5 |
190852 | 190852 | 2020-05-30 | Lawrence | Arkansas | 5075 | 84 | 5 |
187787 | 187787 | 2020-05-29 | Lawrence | Arkansas | 5075 | 82 | 5 |
184731 | 184731 | 2020-05-28 | Lawrence | Arkansas | 5075 | 82 | 5 |
181677 | 181677 | 2020-05-27 | Lawrence | Arkansas | 5075 | 82 | 5 |
178633 | 178633 | 2020-05-26 | Lawrence | Arkansas | 5075 | 82 | 5 |
175589 | 175589 | 2020-05-25 | Lawrence | Arkansas | 5075 | 82 | 5 |
172545 | 172545 | 2020-05-24 | Lawrence | Arkansas | 5075 | 82 | 5 |
169504 | 169504 | 2020-05-23 | Lawrence | Arkansas | 5075 | 82 | 5 |
166468 | 166468 | 2020-05-22 | Lawrence | Arkansas | 5075 | 81 | 5 |
163436 | 163436 | 2020-05-21 | Lawrence | Arkansas | 5075 | 79 | 5 |
74916 | 74916 | 2020-04-20 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
72141 | 72141 | 2020-04-19 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
69374 | 69374 | 2020-04-18 | Lawrence | Pennsylvania | 42073 | 60 | 5 |
66616 | 66616 | 2020-04-17 | Lawrence | Pennsylvania | 42073 | 59 | 5 |
63870 | 63870 | 2020-04-16 | Lawrence | Pennsylvania | 42073 | 55 | 5 |
61144 | 61144 | 2020-04-15 | Lawrence | Pennsylvania | 42073 | 55 | 5 |
29022 | 29022 | 2020-04-03 | Lawrence | Indiana | 18093 | 23 | 5 |
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);