ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 163 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Lawrence 14
- Clay 10
- Laclede 9
- Butler 7
- Cape Girardeau 7
- Christian 7
- Phelps 5
- Camden 4
- Jackson 1
- Kansas City 1
- St. Charles 1
state 1
- Missouri · 66 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2351370 | 2351370 | 2022-03-28 | Lawrence | Missouri | 29109 | 7783 | 163 |
2348118 | 2348118 | 2022-03-27 | Lawrence | Missouri | 29109 | 7778 | 163 |
2344865 | 2344865 | 2022-03-26 | Lawrence | Missouri | 29109 | 7778 | 163 |
2341612 | 2341612 | 2022-03-25 | Lawrence | Missouri | 29109 | 7778 | 163 |
2338359 | 2338359 | 2022-03-24 | Lawrence | Missouri | 29109 | 7776 | 163 |
2335105 | 2335105 | 2022-03-23 | Lawrence | Missouri | 29109 | 7775 | 163 |
2331851 | 2331851 | 2022-03-22 | Lawrence | Missouri | 29109 | 7773 | 163 |
2328553 | 2328553 | 2022-03-21 | Butler | Missouri | 29023 | 9952 | 163 |
2328598 | 2328598 | 2022-03-21 | Lawrence | Missouri | 29109 | 7771 | 163 |
2325301 | 2325301 | 2022-03-20 | Butler | Missouri | 29023 | 9949 | 163 |
2325346 | 2325346 | 2022-03-20 | Lawrence | Missouri | 29109 | 7765 | 163 |
2322047 | 2322047 | 2022-03-19 | Butler | Missouri | 29023 | 9949 | 163 |
2322092 | 2322092 | 2022-03-19 | Lawrence | Missouri | 29109 | 7765 | 163 |
2318793 | 2318793 | 2022-03-18 | Butler | Missouri | 29023 | 9949 | 163 |
2318838 | 2318838 | 2022-03-18 | Lawrence | Missouri | 29109 | 7765 | 163 |
2315540 | 2315540 | 2022-03-17 | Butler | Missouri | 29023 | 9944 | 163 |
2315585 | 2315585 | 2022-03-17 | Lawrence | Missouri | 29109 | 7759 | 163 |
2312287 | 2312287 | 2022-03-16 | Butler | Missouri | 29023 | 9941 | 163 |
2312332 | 2312332 | 2022-03-16 | Lawrence | Missouri | 29109 | 7753 | 163 |
2309034 | 2309034 | 2022-03-15 | Butler | Missouri | 29023 | 9937 | 163 |
2309079 | 2309079 | 2022-03-15 | Lawrence | Missouri | 29109 | 7750 | 163 |
2244041 | 2244041 | 2022-02-23 | Laclede | Missouri | 29105 | 8032 | 163 |
2240790 | 2240790 | 2022-02-22 | Laclede | Missouri | 29105 | 8026 | 163 |
2237539 | 2237539 | 2022-02-21 | Laclede | Missouri | 29105 | 8006 | 163 |
2234288 | 2234288 | 2022-02-20 | Laclede | Missouri | 29105 | 8006 | 163 |
2231037 | 2231037 | 2022-02-19 | Laclede | Missouri | 29105 | 8006 | 163 |
2227786 | 2227786 | 2022-02-18 | Laclede | Missouri | 29105 | 8006 | 163 |
2224535 | 2224535 | 2022-02-17 | Laclede | Missouri | 29105 | 8004 | 163 |
2221284 | 2221284 | 2022-02-16 | Laclede | Missouri | 29105 | 7999 | 163 |
2218033 | 2218033 | 2022-02-15 | Laclede | Missouri | 29105 | 7993 | 163 |
2169201 | 2169201 | 2022-01-31 | Camden | Missouri | 29029 | 8830 | 163 |
2165946 | 2165946 | 2022-01-30 | Camden | Missouri | 29029 | 8786 | 163 |
2162691 | 2162691 | 2022-01-29 | Camden | Missouri | 29029 | 8772 | 163 |
2159436 | 2159436 | 2022-01-28 | Camden | Missouri | 29029 | 8720 | 163 |
1918857 | 1918857 | 2021-11-15 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1918863 | 1918863 | 2021-11-15 | Christian | Missouri | 29043 | 13203 | 163 |
1915607 | 1915607 | 2021-11-14 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1915613 | 1915613 | 2021-11-14 | Christian | Missouri | 29043 | 13183 | 163 |
1912357 | 1912357 | 2021-11-13 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1912363 | 1912363 | 2021-11-13 | Christian | Missouri | 29043 | 13174 | 163 |
1909107 | 1909107 | 2021-11-12 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1909113 | 1909113 | 2021-11-12 | Christian | Missouri | 29043 | 13142 | 163 |
1905858 | 1905858 | 2021-11-11 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1905864 | 1905864 | 2021-11-11 | Christian | Missouri | 29043 | 13105 | 163 |
1902609 | 1902609 | 2021-11-10 | Cape Girardeau | Missouri | 29031 | 13468 | 163 |
1902615 | 1902615 | 2021-11-10 | Christian | Missouri | 29043 | 13105 | 163 |
1899359 | 1899359 | 2021-11-09 | Cape Girardeau | Missouri | 29031 | 13338 | 163 |
1899365 | 1899365 | 2021-11-09 | Christian | Missouri | 29043 | 13090 | 163 |
1668746 | 1668746 | 2021-08-30 | Phelps | Missouri | 29161 | 5537 | 163 |
1665499 | 1665499 | 2021-08-29 | Phelps | Missouri | 29161 | 5512 | 163 |
1662251 | 1662251 | 2021-08-28 | Phelps | Missouri | 29161 | 5503 | 163 |
1659003 | 1659003 | 2021-08-27 | Phelps | Missouri | 29161 | 5488 | 163 |
1655754 | 1655754 | 2021-08-26 | Phelps | Missouri | 29161 | 5471 | 163 |
1249840 | 1249840 | 2021-04-23 | Clay | Missouri | 29047 | 10122 | 163 |
1246593 | 1246593 | 2021-04-22 | Clay | Missouri | 29047 | 10122 | 163 |
1243346 | 1243346 | 2021-04-21 | Clay | Missouri | 29047 | 10122 | 163 |
1240099 | 1240099 | 2021-04-20 | Clay | Missouri | 29047 | 10122 | 163 |
1236852 | 1236852 | 2021-04-19 | Clay | Missouri | 29047 | 10063 | 163 |
1233605 | 1233605 | 2021-04-18 | Clay | Missouri | 29047 | 10063 | 163 |
1230357 | 1230357 | 2021-04-17 | Clay | Missouri | 29047 | 10063 | 163 |
1227109 | 1227109 | 2021-04-16 | Clay | Missouri | 29047 | 10063 | 163 |
1223861 | 1223861 | 2021-04-15 | Clay | Missouri | 29047 | 10063 | 163 |
1220614 | 1220614 | 2021-04-14 | Clay | Missouri | 29047 | 10063 | 163 |
740236 | 740236 | 2020-11-17 | Jackson | Missouri | 29095 | 14380 | 163 |
691635 | 691635 | 2020-11-02 | St. Charles | Missouri | 29183 | 12590 | 163 |
642927 | 642927 | 2020-10-18 | Kansas City | Missouri | 13614 | 163 |
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);