ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where county = "Lewis", deaths = 3 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
873311 | 873311 | 2020-12-28 | Lewis | Missouri | 29111 | 525 | 3 |
870066 | 870066 | 2020-12-27 | Lewis | Missouri | 29111 | 523 | 3 |
866821 | 866821 | 2020-12-26 | Lewis | Missouri | 29111 | 523 | 3 |
863576 | 863576 | 2020-12-25 | Lewis | Missouri | 29111 | 517 | 3 |
860331 | 860331 | 2020-12-24 | Lewis | Missouri | 29111 | 514 | 3 |
857086 | 857086 | 2020-12-23 | Lewis | Missouri | 29111 | 509 | 3 |
853841 | 853841 | 2020-12-22 | Lewis | Missouri | 29111 | 509 | 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);