ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 3261 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Missouri · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475045 | 2475045 | 2022-05-05 | Dent | Missouri | 29065 | 3261 | 83 |
2471788 | 2471788 | 2022-05-04 | Dent | Missouri | 29065 | 3261 | 81 |
2468532 | 2468532 | 2022-05-03 | Dent | Missouri | 29065 | 3261 | 81 |
2465276 | 2465276 | 2022-05-02 | Dent | Missouri | 29065 | 3261 | 81 |
2462021 | 2462021 | 2022-05-01 | Dent | Missouri | 29065 | 3261 | 81 |
2458765 | 2458765 | 2022-04-30 | Dent | Missouri | 29065 | 3261 | 81 |
2455509 | 2455509 | 2022-04-29 | Dent | Missouri | 29065 | 3261 | 81 |
2452253 | 2452253 | 2022-04-28 | Dent | Missouri | 29065 | 3261 | 81 |
2448997 | 2448997 | 2022-04-27 | Dent | Missouri | 29065 | 3261 | 81 |
2445740 | 2445740 | 2022-04-26 | Dent | Missouri | 29065 | 3261 | 81 |
2442485 | 2442485 | 2022-04-25 | Dent | Missouri | 29065 | 3261 | 81 |
2439229 | 2439229 | 2022-04-24 | Dent | Missouri | 29065 | 3261 | 81 |
2435973 | 2435973 | 2022-04-23 | Dent | Missouri | 29065 | 3261 | 81 |
2432717 | 2432717 | 2022-04-22 | Dent | Missouri | 29065 | 3261 | 81 |
2429461 | 2429461 | 2022-04-21 | Dent | Missouri | 29065 | 3261 | 81 |
2426205 | 2426205 | 2022-04-20 | Dent | Missouri | 29065 | 3261 | 81 |
2422949 | 2422949 | 2022-04-19 | Dent | Missouri | 29065 | 3261 | 81 |
2419692 | 2419692 | 2022-04-18 | Dent | Missouri | 29065 | 3261 | 81 |
2416437 | 2416437 | 2022-04-17 | Dent | Missouri | 29065 | 3261 | 81 |
2413181 | 2413181 | 2022-04-16 | Dent | Missouri | 29065 | 3261 | 81 |
2409925 | 2409925 | 2022-04-15 | Dent | Missouri | 29065 | 3261 | 81 |
2406669 | 2406669 | 2022-04-14 | Dent | Missouri | 29065 | 3261 | 81 |
2403413 | 2403413 | 2022-04-13 | Dent | Missouri | 29065 | 3261 | 81 |
2400158 | 2400158 | 2022-04-12 | Dent | Missouri | 29065 | 3261 | 81 |
2396903 | 2396903 | 2022-04-11 | Dent | Missouri | 29065 | 3261 | 81 |
2393648 | 2393648 | 2022-04-10 | Dent | Missouri | 29065 | 3261 | 81 |
2390392 | 2390392 | 2022-04-09 | Dent | Missouri | 29065 | 3261 | 81 |
2387136 | 2387136 | 2022-04-08 | Dent | Missouri | 29065 | 3261 | 81 |
2383881 | 2383881 | 2022-04-07 | Dent | Missouri | 29065 | 3261 | 81 |
2380626 | 2380626 | 2022-04-06 | Dent | Missouri | 29065 | 3261 | 81 |
2377371 | 2377371 | 2022-04-05 | Dent | Missouri | 29065 | 3261 | 81 |
2374118 | 2374118 | 2022-04-04 | Dent | Missouri | 29065 | 3261 | 81 |
2370866 | 2370866 | 2022-04-03 | Dent | Missouri | 29065 | 3261 | 81 |
2367613 | 2367613 | 2022-04-02 | Dent | Missouri | 29065 | 3261 | 81 |
2364360 | 2364360 | 2022-04-01 | Dent | Missouri | 29065 | 3261 | 81 |
2361106 | 2361106 | 2022-03-31 | Dent | Missouri | 29065 | 3261 | 81 |
1795441 | 1795441 | 2021-10-08 | New Madrid | Missouri | 29143 | 3261 | 55 |
1561500 | 1561500 | 2021-07-28 | Dunklin | Missouri | 29069 | 3261 | 50 |
1269353 | 1269353 | 2021-04-29 | Laclede | Missouri | 29105 | 3261 | 68 |
1100528 | 1100528 | 2021-03-08 | Polk | Missouri | 29167 | 3261 | 39 |
866860 | 866860 | 2020-12-26 | Scott | Missouri | 29201 | 3261 | 59 |
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);