ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where deaths = 164 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 13
county 13
- Lawrence 46
- Clay 18
- Cass 7
- St. Francois 7
- Franklin 6
- St. Louis city 5
- Buchanan 3
- Jasper 3
- Cape Girardeau 2
- Christian 2
- Kansas City 2
- Phelps 2
- Jefferson 1
state 1
- Missouri · 104 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501132 | 2501132 | 2022-05-13 | Lawrence | Missouri | 29109 | 7798 | 164 |
2497874 | 2497874 | 2022-05-12 | Lawrence | Missouri | 29109 | 7789 | 164 |
2494616 | 2494616 | 2022-05-11 | Lawrence | Missouri | 29109 | 7789 | 164 |
2491358 | 2491358 | 2022-05-10 | Lawrence | Missouri | 29109 | 7789 | 164 |
2488100 | 2488100 | 2022-05-09 | Lawrence | Missouri | 29109 | 7789 | 164 |
2484843 | 2484843 | 2022-05-08 | Lawrence | Missouri | 29109 | 7789 | 164 |
2481585 | 2481585 | 2022-05-07 | Lawrence | Missouri | 29109 | 7789 | 164 |
2478327 | 2478327 | 2022-05-06 | Lawrence | Missouri | 29109 | 7789 | 164 |
2475069 | 2475069 | 2022-05-05 | Lawrence | Missouri | 29109 | 7786 | 164 |
2471812 | 2471812 | 2022-05-04 | Lawrence | Missouri | 29109 | 7786 | 164 |
2468556 | 2468556 | 2022-05-03 | Lawrence | Missouri | 29109 | 7786 | 164 |
2465300 | 2465300 | 2022-05-02 | Lawrence | Missouri | 29109 | 7786 | 164 |
2462045 | 2462045 | 2022-05-01 | Lawrence | Missouri | 29109 | 7786 | 164 |
2458789 | 2458789 | 2022-04-30 | Lawrence | Missouri | 29109 | 7786 | 164 |
2455533 | 2455533 | 2022-04-29 | Lawrence | Missouri | 29109 | 7786 | 164 |
2452277 | 2452277 | 2022-04-28 | Lawrence | Missouri | 29109 | 7786 | 164 |
2449021 | 2449021 | 2022-04-27 | Lawrence | Missouri | 29109 | 7786 | 164 |
2445764 | 2445764 | 2022-04-26 | Lawrence | Missouri | 29109 | 7786 | 164 |
2442509 | 2442509 | 2022-04-25 | Lawrence | Missouri | 29109 | 7786 | 164 |
2439253 | 2439253 | 2022-04-24 | Lawrence | Missouri | 29109 | 7786 | 164 |
2435997 | 2435997 | 2022-04-23 | Lawrence | Missouri | 29109 | 7786 | 164 |
2432741 | 2432741 | 2022-04-22 | Lawrence | Missouri | 29109 | 7786 | 164 |
2429485 | 2429485 | 2022-04-21 | Lawrence | Missouri | 29109 | 7786 | 164 |
2426229 | 2426229 | 2022-04-20 | Lawrence | Missouri | 29109 | 7786 | 164 |
2422973 | 2422973 | 2022-04-19 | Lawrence | Missouri | 29109 | 7786 | 164 |
2419716 | 2419716 | 2022-04-18 | Lawrence | Missouri | 29109 | 7786 | 164 |
2416461 | 2416461 | 2022-04-17 | Lawrence | Missouri | 29109 | 7786 | 164 |
2413205 | 2413205 | 2022-04-16 | Lawrence | Missouri | 29109 | 7786 | 164 |
2409949 | 2409949 | 2022-04-15 | Lawrence | Missouri | 29109 | 7786 | 164 |
2406693 | 2406693 | 2022-04-14 | Lawrence | Missouri | 29109 | 7786 | 164 |
2403437 | 2403437 | 2022-04-13 | Lawrence | Missouri | 29109 | 7786 | 164 |
2400182 | 2400182 | 2022-04-12 | Lawrence | Missouri | 29109 | 7786 | 164 |
2396927 | 2396927 | 2022-04-11 | Lawrence | Missouri | 29109 | 7786 | 164 |
2393672 | 2393672 | 2022-04-10 | Lawrence | Missouri | 29109 | 7786 | 164 |
2390416 | 2390416 | 2022-04-09 | Lawrence | Missouri | 29109 | 7786 | 164 |
2387160 | 2387160 | 2022-04-08 | Lawrence | Missouri | 29109 | 7786 | 164 |
2383905 | 2383905 | 2022-04-07 | Lawrence | Missouri | 29109 | 7786 | 164 |
2380650 | 2380650 | 2022-04-06 | Lawrence | Missouri | 29109 | 7786 | 164 |
2377395 | 2377395 | 2022-04-05 | Lawrence | Missouri | 29109 | 7786 | 164 |
2374142 | 2374142 | 2022-04-04 | Lawrence | Missouri | 29109 | 7786 | 164 |
2370890 | 2370890 | 2022-04-03 | Lawrence | Missouri | 29109 | 7786 | 164 |
2367637 | 2367637 | 2022-04-02 | Lawrence | Missouri | 29109 | 7786 | 164 |
2364384 | 2364384 | 2022-04-01 | Lawrence | Missouri | 29109 | 7786 | 164 |
2361130 | 2361130 | 2022-03-31 | Lawrence | Missouri | 29109 | 7786 | 164 |
2357876 | 2357876 | 2022-03-30 | Lawrence | Missouri | 29109 | 7785 | 164 |
2354623 | 2354623 | 2022-03-29 | Lawrence | Missouri | 29109 | 7783 | 164 |
1925356 | 1925356 | 2021-11-17 | Cape Girardeau | Missouri | 29031 | 13616 | 164 |
1925362 | 1925362 | 2021-11-17 | Christian | Missouri | 29043 | 13236 | 164 |
1922107 | 1922107 | 2021-11-16 | Cape Girardeau | Missouri | 29031 | 13468 | 164 |
1922113 | 1922113 | 2021-11-16 | Christian | Missouri | 29043 | 13218 | 164 |
1873366 | 1873366 | 2021-11-01 | Cass | Missouri | 29037 | 14437 | 164 |
1870117 | 1870117 | 2021-10-31 | Cass | Missouri | 29037 | 14422 | 164 |
1866868 | 1866868 | 2021-10-30 | Cass | Missouri | 29037 | 14411 | 164 |
1863619 | 1863619 | 2021-10-29 | Cass | Missouri | 29037 | 14397 | 164 |
1860370 | 1860370 | 2021-10-28 | Cass | Missouri | 29037 | 14379 | 164 |
1857121 | 1857121 | 2021-10-27 | Cass | Missouri | 29037 | 14354 | 164 |
1853872 | 1853872 | 2021-10-26 | Cass | Missouri | 29037 | 14331 | 164 |
1850706 | 1850706 | 2021-10-25 | St. Francois | Missouri | 29187 | 11944 | 164 |
1847456 | 1847456 | 2021-10-24 | St. Francois | Missouri | 29187 | 11940 | 164 |
1844206 | 1844206 | 2021-10-23 | St. Francois | Missouri | 29187 | 11930 | 164 |
1840956 | 1840956 | 2021-10-22 | St. Francois | Missouri | 29187 | 11922 | 164 |
1837707 | 1837707 | 2021-10-21 | St. Francois | Missouri | 29187 | 11908 | 164 |
1834458 | 1834458 | 2021-10-20 | St. Francois | Missouri | 29187 | 11896 | 164 |
1831209 | 1831209 | 2021-10-19 | St. Francois | Missouri | 29187 | 11882 | 164 |
1678455 | 1678455 | 2021-09-02 | Jasper | Missouri | 29097 | 12821 | 164 |
1675207 | 1675207 | 2021-09-01 | Jasper | Missouri | 29097 | 12782 | 164 |
1675241 | 1675241 | 2021-09-01 | Phelps | Missouri | 29161 | 5568 | 164 |
1671959 | 1671959 | 2021-08-31 | Jasper | Missouri | 29097 | 12747 | 164 |
1671993 | 1671993 | 2021-08-31 | Phelps | Missouri | 29161 | 5554 | 164 |
1305034 | 1305034 | 2021-05-10 | Clay | Missouri | 29047 | 10257 | 164 |
1301788 | 1301788 | 2021-05-09 | Clay | Missouri | 29047 | 10257 | 164 |
1298540 | 1298540 | 2021-05-08 | Clay | Missouri | 29047 | 10257 | 164 |
1295294 | 1295294 | 2021-05-07 | Clay | Missouri | 29047 | 10257 | 164 |
1292048 | 1292048 | 2021-05-06 | Clay | Missouri | 29047 | 10257 | 164 |
1288802 | 1288802 | 2021-05-05 | Clay | Missouri | 29047 | 10242 | 164 |
1285556 | 1285556 | 2021-05-04 | Clay | Missouri | 29047 | 10242 | 164 |
1282310 | 1282310 | 2021-05-03 | Clay | Missouri | 29047 | 10242 | 164 |
1279063 | 1279063 | 2021-05-02 | Clay | Missouri | 29047 | 10242 | 164 |
1275816 | 1275816 | 2021-05-01 | Clay | Missouri | 29047 | 10242 | 164 |
1272569 | 1272569 | 2021-04-30 | Clay | Missouri | 29047 | 10242 | 164 |
1269322 | 1269322 | 2021-04-29 | Clay | Missouri | 29047 | 10242 | 164 |
1266075 | 1266075 | 2021-04-28 | Clay | Missouri | 29047 | 10242 | 164 |
1262828 | 1262828 | 2021-04-27 | Clay | Missouri | 29047 | 10122 | 164 |
1259581 | 1259581 | 2021-04-26 | Clay | Missouri | 29047 | 10122 | 164 |
1256334 | 1256334 | 2021-04-25 | Clay | Missouri | 29047 | 10122 | 164 |
1253087 | 1253087 | 2021-04-24 | Clay | Missouri | 29047 | 10122 | 164 |
1217366 | 1217366 | 2021-04-13 | Clay | Missouri | 29047 | 10007 | 164 |
1100478 | 1100478 | 2021-03-08 | Franklin | Missouri | 29071 | 10059 | 164 |
1097231 | 1097231 | 2021-03-07 | Franklin | Missouri | 29071 | 8458 | 164 |
1093984 | 1093984 | 2021-03-06 | Franklin | Missouri | 29071 | 8455 | 164 |
1090738 | 1090738 | 2021-03-05 | Franklin | Missouri | 29071 | 8449 | 164 |
1087493 | 1087493 | 2021-03-04 | Franklin | Missouri | 29071 | 8444 | 164 |
1084248 | 1084248 | 2021-03-03 | Franklin | Missouri | 29071 | 8435 | 164 |
1061505 | 1061505 | 2021-02-24 | Buchanan | Missouri | 29021 | 10043 | 164 |
1058259 | 1058259 | 2021-02-23 | Buchanan | Missouri | 29021 | 10013 | 164 |
1055013 | 1055013 | 2021-02-22 | Buchanan | Missouri | 29021 | 10007 | 164 |
947946 | 947946 | 2021-01-20 | Jefferson | Missouri | 29099 | 19495 | 164 |
649417 | 649417 | 2020-10-20 | Kansas City | Missouri | 13733 | 164 | |
646173 | 646173 | 2020-10-19 | Kansas City | Missouri | 13733 | 164 | |
371454 | 371454 | 2020-07-26 | St. Louis city | Missouri | 29510 | 3998 | 164 |
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);