ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where county = "Lawrence" and deaths = 14 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 9
- Mississippi 75
- Ohio 10
- Missouri 8
- Tennessee 7
- Arkansas 5
- Illinois 5
- Indiana 5
- Kentucky 1
- Pennsylvania 1
county 1
- Lawrence · 117 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
98867 | 98867 | 2020-04-29 | Lawrence | Indiana | 18093 | 95 | 14 |
101718 | 101718 | 2020-04-30 | Lawrence | Indiana | 18093 | 100 | 14 |
104574 | 104574 | 2020-05-01 | Lawrence | Indiana | 18093 | 100 | 14 |
107439 | 107439 | 2020-05-02 | Lawrence | Indiana | 18093 | 106 | 14 |
110309 | 110309 | 2020-05-03 | Lawrence | Indiana | 18093 | 106 | 14 |
407515 | 407515 | 2020-08-06 | Lawrence | Pennsylvania | 42073 | 383 | 14 |
478300 | 478300 | 2020-08-28 | Lawrence | Ohio | 39087 | 422 | 14 |
481534 | 481534 | 2020-08-29 | Lawrence | Ohio | 39087 | 429 | 14 |
484769 | 484769 | 2020-08-30 | Lawrence | Ohio | 39087 | 429 | 14 |
488002 | 488002 | 2020-08-31 | Lawrence | Ohio | 39087 | 434 | 14 |
491235 | 491235 | 2020-09-01 | Lawrence | Ohio | 39087 | 445 | 14 |
494469 | 494469 | 2020-09-02 | Lawrence | Ohio | 39087 | 454 | 14 |
497702 | 497702 | 2020-09-03 | Lawrence | Ohio | 39087 | 465 | 14 |
500936 | 500936 | 2020-09-04 | Lawrence | Ohio | 39087 | 470 | 14 |
504170 | 504170 | 2020-09-05 | Lawrence | Ohio | 39087 | 477 | 14 |
507402 | 507402 | 2020-09-06 | Lawrence | Ohio | 39087 | 480 | 14 |
581218 | 581218 | 2020-09-29 | Lawrence | Mississippi | 28077 | 437 | 14 |
584459 | 584459 | 2020-09-30 | Lawrence | Mississippi | 28077 | 439 | 14 |
585578 | 585578 | 2020-09-30 | Lawrence | Tennessee | 47099 | 1108 | 14 |
587699 | 587699 | 2020-10-01 | Lawrence | Mississippi | 28077 | 439 | 14 |
588818 | 588818 | 2020-10-01 | Lawrence | Tennessee | 47099 | 1122 | 14 |
590940 | 590940 | 2020-10-02 | Lawrence | Mississippi | 28077 | 440 | 14 |
592059 | 592059 | 2020-10-02 | Lawrence | Tennessee | 47099 | 1130 | 14 |
594181 | 594181 | 2020-10-03 | Lawrence | Mississippi | 28077 | 441 | 14 |
595300 | 595300 | 2020-10-03 | Lawrence | Tennessee | 47099 | 1139 | 14 |
597422 | 597422 | 2020-10-04 | Lawrence | Mississippi | 28077 | 443 | 14 |
598543 | 598543 | 2020-10-04 | Lawrence | Tennessee | 47099 | 1140 | 14 |
600665 | 600665 | 2020-10-05 | Lawrence | Mississippi | 28077 | 444 | 14 |
601786 | 601786 | 2020-10-05 | Lawrence | Tennessee | 47099 | 1160 | 14 |
603907 | 603907 | 2020-10-06 | Lawrence | Mississippi | 28077 | 449 | 14 |
605028 | 605028 | 2020-10-06 | Lawrence | Tennessee | 47099 | 1175 | 14 |
607150 | 607150 | 2020-10-07 | Lawrence | Mississippi | 28077 | 453 | 14 |
610392 | 610392 | 2020-10-08 | Lawrence | Mississippi | 28077 | 459 | 14 |
613634 | 613634 | 2020-10-09 | Lawrence | Mississippi | 28077 | 463 | 14 |
616875 | 616875 | 2020-10-10 | Lawrence | Mississippi | 28077 | 465 | 14 |
620117 | 620117 | 2020-10-11 | Lawrence | Mississippi | 28077 | 465 | 14 |
623360 | 623360 | 2020-10-12 | Lawrence | Mississippi | 28077 | 469 | 14 |
626602 | 626602 | 2020-10-13 | Lawrence | Mississippi | 28077 | 474 | 14 |
629846 | 629846 | 2020-10-14 | Lawrence | Mississippi | 28077 | 479 | 14 |
629946 | 629946 | 2020-10-14 | Lawrence | Missouri | 29109 | 880 | 14 |
631786 | 631786 | 2020-10-15 | Lawrence | Arkansas | 5075 | 693 | 14 |
633091 | 633091 | 2020-10-15 | Lawrence | Mississippi | 28077 | 483 | 14 |
635032 | 635032 | 2020-10-16 | Lawrence | Arkansas | 5075 | 700 | 14 |
636337 | 636337 | 2020-10-16 | Lawrence | Mississippi | 28077 | 489 | 14 |
638277 | 638277 | 2020-10-17 | Lawrence | Arkansas | 5075 | 718 | 14 |
639583 | 639583 | 2020-10-17 | Lawrence | Mississippi | 28077 | 489 | 14 |
639683 | 639683 | 2020-10-17 | Lawrence | Missouri | 29109 | 944 | 14 |
641524 | 641524 | 2020-10-18 | Lawrence | Arkansas | 5075 | 722 | 14 |
642830 | 642830 | 2020-10-18 | Lawrence | Mississippi | 28077 | 489 | 14 |
642931 | 642931 | 2020-10-18 | Lawrence | Missouri | 29109 | 957 | 14 |
644772 | 644772 | 2020-10-19 | Lawrence | Arkansas | 5075 | 731 | 14 |
646077 | 646077 | 2020-10-19 | Lawrence | Mississippi | 28077 | 495 | 14 |
646177 | 646177 | 2020-10-19 | Lawrence | Missouri | 29109 | 974 | 14 |
649321 | 649321 | 2020-10-20 | Lawrence | Mississippi | 28077 | 499 | 14 |
649421 | 649421 | 2020-10-20 | Lawrence | Missouri | 29109 | 974 | 14 |
652566 | 652566 | 2020-10-21 | Lawrence | Mississippi | 28077 | 504 | 14 |
652666 | 652666 | 2020-10-21 | Lawrence | Missouri | 29109 | 1006 | 14 |
655811 | 655811 | 2020-10-22 | Lawrence | Mississippi | 28077 | 507 | 14 |
655911 | 655911 | 2020-10-22 | Lawrence | Missouri | 29109 | 1018 | 14 |
659056 | 659056 | 2020-10-23 | Lawrence | Mississippi | 28077 | 512 | 14 |
659156 | 659156 | 2020-10-23 | Lawrence | Missouri | 29109 | 1034 | 14 |
662300 | 662300 | 2020-10-24 | Lawrence | Mississippi | 28077 | 518 | 14 |
665545 | 665545 | 2020-10-25 | Lawrence | Mississippi | 28077 | 518 | 14 |
668789 | 668789 | 2020-10-26 | Lawrence | Mississippi | 28077 | 525 | 14 |
672031 | 672031 | 2020-10-27 | Lawrence | Mississippi | 28077 | 534 | 14 |
675274 | 675274 | 2020-10-28 | Lawrence | Mississippi | 28077 | 544 | 14 |
678516 | 678516 | 2020-10-29 | Lawrence | Mississippi | 28077 | 553 | 14 |
681760 | 681760 | 2020-10-30 | Lawrence | Mississippi | 28077 | 562 | 14 |
685003 | 685003 | 2020-10-31 | Lawrence | Mississippi | 28077 | 570 | 14 |
688247 | 688247 | 2020-11-01 | Lawrence | Mississippi | 28077 | 571 | 14 |
691492 | 691492 | 2020-11-02 | Lawrence | Mississippi | 28077 | 574 | 14 |
694734 | 694734 | 2020-11-03 | Lawrence | Mississippi | 28077 | 578 | 14 |
697977 | 697977 | 2020-11-04 | Lawrence | Mississippi | 28077 | 581 | 14 |
701221 | 701221 | 2020-11-05 | Lawrence | Mississippi | 28077 | 589 | 14 |
704463 | 704463 | 2020-11-06 | Lawrence | Mississippi | 28077 | 593 | 14 |
707706 | 707706 | 2020-11-07 | Lawrence | Mississippi | 28077 | 595 | 14 |
710950 | 710950 | 2020-11-08 | Lawrence | Mississippi | 28077 | 596 | 14 |
714194 | 714194 | 2020-11-09 | Lawrence | Mississippi | 28077 | 598 | 14 |
717438 | 717438 | 2020-11-10 | Lawrence | Mississippi | 28077 | 600 | 14 |
720681 | 720681 | 2020-11-11 | Lawrence | Mississippi | 28077 | 604 | 14 |
723924 | 723924 | 2020-11-12 | Lawrence | Mississippi | 28077 | 608 | 14 |
727167 | 727167 | 2020-11-13 | Lawrence | Mississippi | 28077 | 617 | 14 |
730410 | 730410 | 2020-11-14 | Lawrence | Mississippi | 28077 | 633 | 14 |
733655 | 733655 | 2020-11-15 | Lawrence | Mississippi | 28077 | 640 | 14 |
736901 | 736901 | 2020-11-16 | Lawrence | Mississippi | 28077 | 645 | 14 |
740145 | 740145 | 2020-11-17 | Lawrence | Mississippi | 28077 | 651 | 14 |
743392 | 743392 | 2020-11-18 | Lawrence | Mississippi | 28077 | 668 | 14 |
746639 | 746639 | 2020-11-19 | Lawrence | Mississippi | 28077 | 674 | 14 |
749885 | 749885 | 2020-11-20 | Lawrence | Mississippi | 28077 | 685 | 14 |
753131 | 753131 | 2020-11-21 | Lawrence | Mississippi | 28077 | 697 | 14 |
756377 | 756377 | 2020-11-22 | Lawrence | Mississippi | 28077 | 698 | 14 |
759624 | 759624 | 2020-11-23 | Lawrence | Mississippi | 28077 | 699 | 14 |
762869 | 762869 | 2020-11-24 | Lawrence | Mississippi | 28077 | 702 | 14 |
766114 | 766114 | 2020-11-25 | Lawrence | Mississippi | 28077 | 703 | 14 |
769360 | 769360 | 2020-11-26 | Lawrence | Mississippi | 28077 | 707 | 14 |
772605 | 772605 | 2020-11-27 | Lawrence | Mississippi | 28077 | 708 | 14 |
775850 | 775850 | 2020-11-28 | Lawrence | Mississippi | 28077 | 718 | 14 |
779095 | 779095 | 2020-11-29 | Lawrence | Mississippi | 28077 | 726 | 14 |
782341 | 782341 | 2020-11-30 | Lawrence | Mississippi | 28077 | 734 | 14 |
785585 | 785585 | 2020-12-01 | Lawrence | Mississippi | 28077 | 738 | 14 |
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);