ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where deaths = 210 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Howell 37
- Jefferson 8
- Franklin 7
- St. Francois 6
- Taney 5
- Boone 2
- Cape Girardeau 2
- Joplin 2
- Christian 1
state 1
- Missouri · 70 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471801 | 2471801 | 2022-05-04 | Howell | Missouri | 29091 | 9002 | 210 |
2468545 | 2468545 | 2022-05-03 | Howell | Missouri | 29091 | 9002 | 210 |
2465289 | 2465289 | 2022-05-02 | Howell | Missouri | 29091 | 9002 | 210 |
2462034 | 2462034 | 2022-05-01 | Howell | Missouri | 29091 | 9002 | 210 |
2458778 | 2458778 | 2022-04-30 | Howell | Missouri | 29091 | 9002 | 210 |
2455522 | 2455522 | 2022-04-29 | Howell | Missouri | 29091 | 9002 | 210 |
2452266 | 2452266 | 2022-04-28 | Howell | Missouri | 29091 | 9002 | 210 |
2449010 | 2449010 | 2022-04-27 | Howell | Missouri | 29091 | 9002 | 210 |
2445753 | 2445753 | 2022-04-26 | Howell | Missouri | 29091 | 9002 | 210 |
2442498 | 2442498 | 2022-04-25 | Howell | Missouri | 29091 | 9002 | 210 |
2439242 | 2439242 | 2022-04-24 | Howell | Missouri | 29091 | 9002 | 210 |
2435986 | 2435986 | 2022-04-23 | Howell | Missouri | 29091 | 9002 | 210 |
2432730 | 2432730 | 2022-04-22 | Howell | Missouri | 29091 | 9002 | 210 |
2429474 | 2429474 | 2022-04-21 | Howell | Missouri | 29091 | 9002 | 210 |
2426218 | 2426218 | 2022-04-20 | Howell | Missouri | 29091 | 9002 | 210 |
2422962 | 2422962 | 2022-04-19 | Howell | Missouri | 29091 | 9002 | 210 |
2419705 | 2419705 | 2022-04-18 | Howell | Missouri | 29091 | 9002 | 210 |
2416450 | 2416450 | 2022-04-17 | Howell | Missouri | 29091 | 9002 | 210 |
2413194 | 2413194 | 2022-04-16 | Howell | Missouri | 29091 | 9002 | 210 |
2409938 | 2409938 | 2022-04-15 | Howell | Missouri | 29091 | 9002 | 210 |
2406682 | 2406682 | 2022-04-14 | Howell | Missouri | 29091 | 9002 | 210 |
2403426 | 2403426 | 2022-04-13 | Howell | Missouri | 29091 | 9002 | 210 |
2400171 | 2400171 | 2022-04-12 | Howell | Missouri | 29091 | 9002 | 210 |
2396916 | 2396916 | 2022-04-11 | Howell | Missouri | 29091 | 9002 | 210 |
2393661 | 2393661 | 2022-04-10 | Howell | Missouri | 29091 | 9002 | 210 |
2390405 | 2390405 | 2022-04-09 | Howell | Missouri | 29091 | 9002 | 210 |
2387149 | 2387149 | 2022-04-08 | Howell | Missouri | 29091 | 9002 | 210 |
2383894 | 2383894 | 2022-04-07 | Howell | Missouri | 29091 | 9002 | 210 |
2380639 | 2380639 | 2022-04-06 | Howell | Missouri | 29091 | 9002 | 210 |
2377384 | 2377384 | 2022-04-05 | Howell | Missouri | 29091 | 9002 | 210 |
2374131 | 2374131 | 2022-04-04 | Howell | Missouri | 29091 | 9002 | 210 |
2370879 | 2370879 | 2022-04-03 | Howell | Missouri | 29091 | 9002 | 210 |
2367626 | 2367626 | 2022-04-02 | Howell | Missouri | 29091 | 9002 | 210 |
2364373 | 2364373 | 2022-04-01 | Howell | Missouri | 29091 | 9002 | 210 |
2361119 | 2361119 | 2022-03-31 | Howell | Missouri | 29091 | 9002 | 210 |
2357865 | 2357865 | 2022-03-30 | Howell | Missouri | 29091 | 8996 | 210 |
2354612 | 2354612 | 2022-03-29 | Howell | Missouri | 29091 | 8985 | 210 |
2260350 | 2260350 | 2022-02-28 | Taney | Missouri | 29213 | 13188 | 210 |
2257099 | 2257099 | 2022-02-27 | Taney | Missouri | 29213 | 13176 | 210 |
2253848 | 2253848 | 2022-02-26 | Taney | Missouri | 29213 | 13176 | 210 |
2250597 | 2250597 | 2022-02-25 | Taney | Missouri | 29213 | 13176 | 210 |
2247346 | 2247346 | 2022-02-24 | Taney | Missouri | 29213 | 13171 | 210 |
2244038 | 2244038 | 2022-02-23 | Joplin | Missouri | 13654 | 210 | |
2240787 | 2240787 | 2022-02-22 | Joplin | Missouri | 13645 | 210 | |
2133402 | 2133402 | 2022-01-20 | Boone | Missouri | 29019 | 37375 | 210 |
2133408 | 2133408 | 2022-01-20 | Cape Girardeau | Missouri | 29031 | 16044 | 210 |
2130149 | 2130149 | 2022-01-19 | Boone | Missouri | 29019 | 36631 | 210 |
2130155 | 2130155 | 2022-01-19 | Cape Girardeau | Missouri | 29031 | 15857 | 210 |
2058630 | 2058630 | 2021-12-28 | Christian | Missouri | 29043 | 14793 | 210 |
1964450 | 1964450 | 2021-11-29 | St. Francois | Missouri | 29187 | 12664 | 210 |
1961199 | 1961199 | 2021-11-28 | St. Francois | Missouri | 29187 | 12580 | 210 |
1957948 | 1957948 | 2021-11-27 | St. Francois | Missouri | 29187 | 12580 | 210 |
1954697 | 1954697 | 2021-11-26 | St. Francois | Missouri | 29187 | 12580 | 210 |
1951446 | 1951446 | 2021-11-25 | St. Francois | Missouri | 29187 | 12580 | 210 |
1948195 | 1948195 | 2021-11-24 | St. Francois | Missouri | 29187 | 12580 | 210 |
1782408 | 1782408 | 2021-10-04 | Franklin | Missouri | 29071 | 13939 | 210 |
1779158 | 1779158 | 2021-10-03 | Franklin | Missouri | 29071 | 13916 | 210 |
1775908 | 1775908 | 2021-10-02 | Franklin | Missouri | 29071 | 13893 | 210 |
1772658 | 1772658 | 2021-10-01 | Franklin | Missouri | 29071 | 13864 | 210 |
1769409 | 1769409 | 2021-09-30 | Franklin | Missouri | 29071 | 13818 | 210 |
1766160 | 1766160 | 2021-09-29 | Franklin | Missouri | 29071 | 13780 | 210 |
1762911 | 1762911 | 2021-09-28 | Franklin | Missouri | 29071 | 13737 | 210 |
1081016 | 1081016 | 2021-03-02 | Jefferson | Missouri | 29099 | 21608 | 210 |
1077770 | 1077770 | 2021-03-01 | Jefferson | Missouri | 29099 | 21608 | 210 |
1074524 | 1074524 | 2021-02-28 | Jefferson | Missouri | 29099 | 21608 | 210 |
1071278 | 1071278 | 2021-02-27 | Jefferson | Missouri | 29099 | 21608 | 210 |
1068033 | 1068033 | 2021-02-26 | Jefferson | Missouri | 29099 | 21608 | 210 |
1064788 | 1064788 | 2021-02-25 | Jefferson | Missouri | 29099 | 21562 | 210 |
1061544 | 1061544 | 2021-02-24 | Jefferson | Missouri | 29099 | 21549 | 210 |
1058298 | 1058298 | 2021-02-23 | Jefferson | Missouri | 29099 | 21518 | 210 |
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);