ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 543 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1922145 | 1922145 | 2021-11-16 | Knox | Missouri | 29103 | 543 | 3 |
1652512 | 1652512 | 2021-08-25 | Putnam | Missouri | 29171 | 543 | 5 |
1645971 | 1645971 | 2021-08-23 | Holt | Missouri | 29087 | 543 | 15 |
1642722 | 1642722 | 2021-08-22 | Holt | Missouri | 29087 | 543 | 15 |
1639472 | 1639472 | 2021-08-21 | Holt | Missouri | 29087 | 543 | 15 |
1636222 | 1636222 | 2021-08-20 | Holt | Missouri | 29087 | 543 | 15 |
1577797 | 1577797 | 2021-08-02 | Reynolds | Missouri | 29179 | 543 | 4 |
1574549 | 1574549 | 2021-08-01 | Reynolds | Missouri | 29179 | 543 | 4 |
1571301 | 1571301 | 2021-07-31 | Reynolds | Missouri | 29179 | 543 | 4 |
1568053 | 1568053 | 2021-07-30 | Reynolds | Missouri | 29179 | 543 | 4 |
1564805 | 1564805 | 2021-07-29 | Reynolds | Missouri | 29179 | 543 | 4 |
1386188 | 1386188 | 2021-06-04 | Carter | Missouri | 29035 | 543 | 11 |
1382943 | 1382943 | 2021-06-03 | Carter | Missouri | 29035 | 543 | 11 |
1379697 | 1379697 | 2021-06-02 | Carter | Missouri | 29035 | 543 | 11 |
1376452 | 1376452 | 2021-06-01 | Carter | Missouri | 29035 | 543 | 11 |
1373206 | 1373206 | 2021-05-31 | Carter | Missouri | 29035 | 543 | 11 |
1369961 | 1369961 | 2021-05-30 | Carter | Missouri | 29035 | 543 | 11 |
1366715 | 1366715 | 2021-05-29 | Carter | Missouri | 29035 | 543 | 11 |
1363469 | 1363469 | 2021-05-28 | Carter | Missouri | 29035 | 543 | 11 |
1360222 | 1360222 | 2021-05-27 | Carter | Missouri | 29035 | 543 | 11 |
1356976 | 1356976 | 2021-05-26 | Carter | Missouri | 29035 | 543 | 11 |
1353730 | 1353730 | 2021-05-25 | Carter | Missouri | 29035 | 543 | 11 |
1340741 | 1340741 | 2021-05-21 | Carter | Missouri | 29035 | 543 | 11 |
1337494 | 1337494 | 2021-05-20 | Carter | Missouri | 29035 | 543 | 11 |
1074534 | 1074534 | 2021-02-28 | Linn | Missouri | 29115 | 543 | 12 |
1029114 | 1029114 | 2021-02-14 | Ozark | Missouri | 29153 | 543 | 12 |
1025868 | 1025868 | 2021-02-13 | Ozark | Missouri | 29153 | 543 | 11 |
1022623 | 1022623 | 2021-02-12 | Ozark | Missouri | 29153 | 543 | 11 |
1019378 | 1019378 | 2021-02-11 | Ozark | Missouri | 29153 | 543 | 11 |
1016133 | 1016133 | 2021-02-10 | Ozark | Missouri | 29153 | 543 | 11 |
970713 | 970713 | 2021-01-27 | St. Clair | Missouri | 29185 | 543 | 6 |
931741 | 931741 | 2021-01-15 | Montgomery | Missouri | 29139 | 543 | 9 |
837591 | 837591 | 2020-12-17 | Douglas | Missouri | 29067 | 543 | 19 |
837595 | 837595 | 2020-12-17 | Gentry | Missouri | 29075 | 543 | 15 |
746712 | 746712 | 2020-11-19 | Dallas | Missouri | 29059 | 543 | 5 |
685109 | 685109 | 2020-10-31 | Madison | Missouri | 29123 | 543 | 3 |
597577 | 597577 | 2020-10-04 | Warren | Missouri | 29219 | 543 | 1 |
594336 | 594336 | 2020-10-03 | Warren | Missouri | 29219 | 543 | 1 |
584582 | 584582 | 2020-09-30 | Pemiscot | Missouri | 29155 | 543 | 10 |
484260 | 484260 | 2020-08-30 | Saline | Missouri | 29195 | 543 | 7 |
481025 | 481025 | 2020-08-29 | Saline | Missouri | 29195 | 543 | 7 |
461595 | 461595 | 2020-08-23 | Johnson | Missouri | 29101 | 543 | 3 |
371369 | 371369 | 2020-07-26 | Cass | Missouri | 29037 | 543 | 9 |
158684 | 158684 | 2020-05-19 | Buchanan | Missouri | 29021 | 543 | 2 |
93955 | 93955 | 2020-04-27 | St. Charles | Missouri | 29183 | 543 | 31 |
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);