ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 2500 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 8
- Montgomery 35
- Stoddard 2
- Benton 1
- Miller 1
- Mississippi 1
- Moniteau 1
- Vernon 1
- Wright 1
state 1
- Missouri · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471827 | 2471827 | 2022-05-04 | Montgomery | Missouri | 29139 | 2500 | 57 |
2468571 | 2468571 | 2022-05-03 | Montgomery | Missouri | 29139 | 2500 | 57 |
2465315 | 2465315 | 2022-05-02 | Montgomery | Missouri | 29139 | 2500 | 57 |
2462060 | 2462060 | 2022-05-01 | Montgomery | Missouri | 29139 | 2500 | 57 |
2458804 | 2458804 | 2022-04-30 | Montgomery | Missouri | 29139 | 2500 | 57 |
2455548 | 2455548 | 2022-04-29 | Montgomery | Missouri | 29139 | 2500 | 57 |
2452292 | 2452292 | 2022-04-28 | Montgomery | Missouri | 29139 | 2500 | 57 |
2449036 | 2449036 | 2022-04-27 | Montgomery | Missouri | 29139 | 2500 | 57 |
2445779 | 2445779 | 2022-04-26 | Montgomery | Missouri | 29139 | 2500 | 57 |
2442524 | 2442524 | 2022-04-25 | Montgomery | Missouri | 29139 | 2500 | 57 |
2439268 | 2439268 | 2022-04-24 | Montgomery | Missouri | 29139 | 2500 | 57 |
2436012 | 2436012 | 2022-04-23 | Montgomery | Missouri | 29139 | 2500 | 57 |
2432756 | 2432756 | 2022-04-22 | Montgomery | Missouri | 29139 | 2500 | 57 |
2429500 | 2429500 | 2022-04-21 | Montgomery | Missouri | 29139 | 2500 | 57 |
2426244 | 2426244 | 2022-04-20 | Montgomery | Missouri | 29139 | 2500 | 57 |
2422988 | 2422988 | 2022-04-19 | Montgomery | Missouri | 29139 | 2500 | 57 |
2419731 | 2419731 | 2022-04-18 | Montgomery | Missouri | 29139 | 2500 | 57 |
2416476 | 2416476 | 2022-04-17 | Montgomery | Missouri | 29139 | 2500 | 57 |
2413220 | 2413220 | 2022-04-16 | Montgomery | Missouri | 29139 | 2500 | 57 |
2409964 | 2409964 | 2022-04-15 | Montgomery | Missouri | 29139 | 2500 | 57 |
2406708 | 2406708 | 2022-04-14 | Montgomery | Missouri | 29139 | 2500 | 57 |
2403452 | 2403452 | 2022-04-13 | Montgomery | Missouri | 29139 | 2500 | 57 |
2400197 | 2400197 | 2022-04-12 | Montgomery | Missouri | 29139 | 2500 | 57 |
2396942 | 2396942 | 2022-04-11 | Montgomery | Missouri | 29139 | 2500 | 57 |
2393687 | 2393687 | 2022-04-10 | Montgomery | Missouri | 29139 | 2500 | 57 |
2390431 | 2390431 | 2022-04-09 | Montgomery | Missouri | 29139 | 2500 | 57 |
2387175 | 2387175 | 2022-04-08 | Montgomery | Missouri | 29139 | 2500 | 57 |
2383920 | 2383920 | 2022-04-07 | Montgomery | Missouri | 29139 | 2500 | 57 |
2380665 | 2380665 | 2022-04-06 | Montgomery | Missouri | 29139 | 2500 | 57 |
2377410 | 2377410 | 2022-04-05 | Montgomery | Missouri | 29139 | 2500 | 57 |
2374157 | 2374157 | 2022-04-04 | Montgomery | Missouri | 29139 | 2500 | 57 |
2370905 | 2370905 | 2022-04-03 | Montgomery | Missouri | 29139 | 2500 | 57 |
2367652 | 2367652 | 2022-04-02 | Montgomery | Missouri | 29139 | 2500 | 57 |
2364399 | 2364399 | 2022-04-01 | Montgomery | Missouri | 29139 | 2500 | 57 |
2361145 | 2361145 | 2022-03-31 | Montgomery | Missouri | 29139 | 2500 | 57 |
2055428 | 2055428 | 2021-12-27 | Mississippi | Missouri | 29133 | 2500 | 49 |
1772739 | 1772739 | 2021-10-01 | Wright | Missouri | 29229 | 2500 | 46 |
1766194 | 1766194 | 2021-09-29 | Moniteau | Missouri | 29135 | 2500 | 38 |
1762883 | 1762883 | 2021-09-28 | Benton | Missouri | 29015 | 2500 | 44 |
1626545 | 1626545 | 2021-08-17 | Vernon | Missouri | 29217 | 2500 | 50 |
1344078 | 1344078 | 2021-05-22 | Stoddard | Missouri | 29207 | 2500 | 41 |
1340829 | 1340829 | 2021-05-21 | Stoddard | Missouri | 29207 | 2500 | 41 |
1152455 | 1152455 | 2021-03-24 | Miller | Missouri | 29131 | 2500 | 53 |
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);