ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
224 rows where county = "Lewis" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 5
- Washington 114
- Missouri 46
- Idaho 37
- West Virginia 26
- Tennessee 1
county 1
- Lewis · 224 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
999884 | 999884 | 2021-02-05 | Lewis | Missouri | 29111 | 623 | 3 |
996638 | 996638 | 2021-02-04 | Lewis | Missouri | 29111 | 621 | 3 |
993392 | 993392 | 2021-02-03 | Lewis | Missouri | 29111 | 621 | 3 |
990146 | 990146 | 2021-02-02 | Lewis | Missouri | 29111 | 621 | 3 |
986899 | 986899 | 2021-02-01 | Lewis | Missouri | 29111 | 620 | 3 |
983652 | 983652 | 2021-01-31 | Lewis | Missouri | 29111 | 621 | 3 |
980406 | 980406 | 2021-01-30 | Lewis | Missouri | 29111 | 621 | 3 |
977160 | 977160 | 2021-01-29 | Lewis | Missouri | 29111 | 619 | 3 |
973915 | 973915 | 2021-01-28 | Lewis | Missouri | 29111 | 616 | 3 |
970670 | 970670 | 2021-01-27 | Lewis | Missouri | 29111 | 617 | 3 |
967425 | 967425 | 2021-01-26 | Lewis | Missouri | 29111 | 617 | 3 |
964181 | 964181 | 2021-01-25 | Lewis | Missouri | 29111 | 617 | 3 |
960936 | 960936 | 2021-01-24 | Lewis | Missouri | 29111 | 615 | 3 |
957690 | 957690 | 2021-01-23 | Lewis | Missouri | 29111 | 615 | 3 |
954445 | 954445 | 2021-01-22 | Lewis | Missouri | 29111 | 613 | 3 |
951200 | 951200 | 2021-01-21 | Lewis | Missouri | 29111 | 609 | 3 |
947954 | 947954 | 2021-01-20 | Lewis | Missouri | 29111 | 609 | 3 |
944707 | 944707 | 2021-01-19 | Lewis | Missouri | 29111 | 607 | 3 |
941462 | 941462 | 2021-01-18 | Lewis | Missouri | 29111 | 604 | 3 |
938217 | 938217 | 2021-01-17 | Lewis | Missouri | 29111 | 603 | 3 |
934972 | 934972 | 2021-01-16 | Lewis | Missouri | 29111 | 601 | 3 |
931727 | 931727 | 2021-01-15 | Lewis | Missouri | 29111 | 596 | 3 |
928482 | 928482 | 2021-01-14 | Lewis | Missouri | 29111 | 591 | 3 |
925236 | 925236 | 2021-01-13 | Lewis | Missouri | 29111 | 588 | 3 |
921991 | 921991 | 2021-01-12 | Lewis | Missouri | 29111 | 583 | 3 |
918746 | 918746 | 2021-01-11 | Lewis | Missouri | 29111 | 581 | 3 |
915501 | 915501 | 2021-01-10 | Lewis | Missouri | 29111 | 580 | 3 |
912256 | 912256 | 2021-01-09 | Lewis | Missouri | 29111 | 576 | 3 |
909011 | 909011 | 2021-01-08 | Lewis | Missouri | 29111 | 570 | 3 |
905765 | 905765 | 2021-01-07 | Lewis | Missouri | 29111 | 565 | 3 |
902520 | 902520 | 2021-01-06 | Lewis | Missouri | 29111 | 564 | 3 |
899275 | 899275 | 2021-01-05 | Lewis | Missouri | 29111 | 559 | 3 |
896030 | 896030 | 2021-01-04 | Lewis | Missouri | 29111 | 557 | 3 |
892783 | 892783 | 2021-01-03 | Lewis | Missouri | 29111 | 557 | 3 |
889537 | 889537 | 2021-01-02 | Lewis | Missouri | 29111 | 555 | 3 |
886291 | 886291 | 2021-01-01 | Lewis | Missouri | 29111 | 549 | 3 |
883046 | 883046 | 2020-12-31 | Lewis | Missouri | 29111 | 539 | 3 |
879801 | 879801 | 2020-12-30 | Lewis | Missouri | 29111 | 537 | 3 |
876556 | 876556 | 2020-12-29 | Lewis | Missouri | 29111 | 526 | 3 |
878118 | 878118 | 2020-12-29 | Lewis | West Virginia | 54041 | 486 | 3 |
873311 | 873311 | 2020-12-28 | Lewis | Missouri | 29111 | 525 | 3 |
874873 | 874873 | 2020-12-28 | Lewis | West Virginia | 54041 | 471 | 3 |
870066 | 870066 | 2020-12-27 | Lewis | Missouri | 29111 | 523 | 3 |
871628 | 871628 | 2020-12-27 | Lewis | West Virginia | 54041 | 467 | 3 |
866821 | 866821 | 2020-12-26 | Lewis | Missouri | 29111 | 523 | 3 |
868383 | 868383 | 2020-12-26 | Lewis | West Virginia | 54041 | 469 | 3 |
863576 | 863576 | 2020-12-25 | Lewis | Missouri | 29111 | 517 | 3 |
865138 | 865138 | 2020-12-25 | Lewis | West Virginia | 54041 | 465 | 3 |
860331 | 860331 | 2020-12-24 | Lewis | Missouri | 29111 | 514 | 3 |
861893 | 861893 | 2020-12-24 | Lewis | West Virginia | 54041 | 447 | 3 |
857086 | 857086 | 2020-12-23 | Lewis | Missouri | 29111 | 509 | 3 |
858648 | 858648 | 2020-12-23 | Lewis | West Virginia | 54041 | 433 | 3 |
853841 | 853841 | 2020-12-22 | Lewis | Missouri | 29111 | 509 | 3 |
855403 | 855403 | 2020-12-22 | Lewis | West Virginia | 54041 | 421 | 3 |
852158 | 852158 | 2020-12-21 | Lewis | West Virginia | 54041 | 406 | 3 |
848913 | 848913 | 2020-12-20 | Lewis | West Virginia | 54041 | 398 | 3 |
845668 | 845668 | 2020-12-19 | Lewis | West Virginia | 54041 | 392 | 3 |
842422 | 842422 | 2020-12-18 | Lewis | West Virginia | 54041 | 383 | 3 |
839177 | 839177 | 2020-12-17 | Lewis | West Virginia | 54041 | 369 | 3 |
835932 | 835932 | 2020-12-16 | Lewis | West Virginia | 54041 | 359 | 3 |
832686 | 832686 | 2020-12-15 | Lewis | West Virginia | 54041 | 347 | 3 |
829439 | 829439 | 2020-12-14 | Lewis | West Virginia | 54041 | 343 | 3 |
826193 | 826193 | 2020-12-13 | Lewis | West Virginia | 54041 | 340 | 3 |
822946 | 822946 | 2020-12-12 | Lewis | West Virginia | 54041 | 330 | 3 |
819700 | 819700 | 2020-12-11 | Lewis | West Virginia | 54041 | 316 | 3 |
816454 | 816454 | 2020-12-10 | Lewis | West Virginia | 54041 | 301 | 3 |
813208 | 813208 | 2020-12-09 | Lewis | West Virginia | 54041 | 298 | 3 |
809964 | 809964 | 2020-12-08 | Lewis | West Virginia | 54041 | 290 | 3 |
806719 | 806719 | 2020-12-07 | Lewis | West Virginia | 54041 | 283 | 3 |
803474 | 803474 | 2020-12-06 | Lewis | West Virginia | 54041 | 278 | 3 |
800229 | 800229 | 2020-12-05 | Lewis | West Virginia | 54041 | 266 | 3 |
796984 | 796984 | 2020-12-04 | Lewis | West Virginia | 54041 | 262 | 3 |
768494 | 768494 | 2020-11-26 | Lewis | Idaho | 16061 | 192 | 3 |
765248 | 765248 | 2020-11-25 | Lewis | Idaho | 16061 | 192 | 3 |
762003 | 762003 | 2020-11-24 | Lewis | Idaho | 16061 | 192 | 3 |
758758 | 758758 | 2020-11-23 | Lewis | Idaho | 16061 | 188 | 3 |
755511 | 755511 | 2020-11-22 | Lewis | Idaho | 16061 | 175 | 3 |
752265 | 752265 | 2020-11-21 | Lewis | Idaho | 16061 | 175 | 3 |
749019 | 749019 | 2020-11-20 | Lewis | Idaho | 16061 | 172 | 3 |
745773 | 745773 | 2020-11-19 | Lewis | Idaho | 16061 | 165 | 3 |
742526 | 742526 | 2020-11-18 | Lewis | Idaho | 16061 | 158 | 3 |
739279 | 739279 | 2020-11-17 | Lewis | Idaho | 16061 | 157 | 3 |
736035 | 736035 | 2020-11-16 | Lewis | Idaho | 16061 | 152 | 3 |
732789 | 732789 | 2020-11-15 | Lewis | Idaho | 16061 | 145 | 3 |
729544 | 729544 | 2020-11-14 | Lewis | Idaho | 16061 | 145 | 3 |
726301 | 726301 | 2020-11-13 | Lewis | Idaho | 16061 | 145 | 3 |
723058 | 723058 | 2020-11-12 | Lewis | Idaho | 16061 | 133 | 3 |
719815 | 719815 | 2020-11-11 | Lewis | Idaho | 16061 | 121 | 3 |
716572 | 716572 | 2020-11-10 | Lewis | Idaho | 16061 | 121 | 3 |
713328 | 713328 | 2020-11-09 | Lewis | Idaho | 16061 | 117 | 3 |
710084 | 710084 | 2020-11-08 | Lewis | Idaho | 16061 | 111 | 3 |
706840 | 706840 | 2020-11-07 | Lewis | Idaho | 16061 | 111 | 3 |
703597 | 703597 | 2020-11-06 | Lewis | Idaho | 16061 | 111 | 3 |
700354 | 700354 | 2020-11-05 | Lewis | Idaho | 16061 | 103 | 3 |
697110 | 697110 | 2020-11-04 | Lewis | Idaho | 16061 | 97 | 3 |
693868 | 693868 | 2020-11-03 | Lewis | Idaho | 16061 | 97 | 3 |
690625 | 690625 | 2020-11-02 | Lewis | Idaho | 16061 | 90 | 3 |
687380 | 687380 | 2020-11-01 | Lewis | Idaho | 16061 | 85 | 3 |
684136 | 684136 | 2020-10-31 | Lewis | Idaho | 16061 | 85 | 3 |
680893 | 680893 | 2020-10-30 | Lewis | Idaho | 16061 | 85 | 3 |
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);