ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where cases = 122 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
902578 | 902578 | 2021-01-06 | Worth | Missouri | 29227 | 122 | 1 |
899333 | 899333 | 2021-01-05 | Worth | Missouri | 29227 | 122 | 1 |
896088 | 896088 | 2021-01-04 | Worth | Missouri | 29227 | 122 | 1 |
892841 | 892841 | 2021-01-03 | Worth | Missouri | 29227 | 122 | 1 |
889595 | 889595 | 2021-01-02 | Worth | Missouri | 29227 | 122 | 1 |
886349 | 886349 | 2021-01-01 | Worth | Missouri | 29227 | 122 | 1 |
678603 | 678603 | 2020-10-29 | Holt | Missouri | 29087 | 122 | 1 |
633198 | 633198 | 2020-10-15 | Maries | Missouri | 29125 | 122 | 0 |
600768 | 600768 | 2020-10-05 | Linn | Missouri | 29115 | 122 | 1 |
597508 | 597508 | 2020-10-04 | Hickory | Missouri | 29085 | 122 | 3 |
597525 | 597525 | 2020-10-04 | Linn | Missouri | 29115 | 122 | 1 |
574817 | 574817 | 2020-09-27 | Gentry | Missouri | 29075 | 122 | 9 |
555372 | 555372 | 2020-09-21 | DeKalb | Missouri | 29063 | 122 | 2 |
545703 | 545703 | 2020-09-18 | Osage | Missouri | 29151 | 122 | 1 |
516506 | 516506 | 2020-09-09 | Barton | Missouri | 29011 | 122 | 0 |
516537 | 516537 | 2020-09-09 | Gasconade | Missouri | 29073 | 122 | 4 |
510123 | 510123 | 2020-09-07 | Ralls | Missouri | 29173 | 122 | 0 |
506831 | 506831 | 2020-09-06 | Dallas | Missouri | 29059 | 122 | 1 |
500439 | 500439 | 2020-09-04 | Ste. Genevieve | Missouri | 29186 | 122 | 1 |
477701 | 477701 | 2020-08-28 | Andrew | Missouri | 29003 | 122 | 1 |
471325 | 471325 | 2020-08-26 | Ray | Missouri | 29177 | 122 | 0 |
468095 | 468095 | 2020-08-25 | Ray | Missouri | 29177 | 122 | 0 |
464866 | 464866 | 2020-08-24 | Ray | Missouri | 29177 | 122 | 0 |
374631 | 374631 | 2020-07-27 | Mississippi | Missouri | 29133 | 122 | 0 |
371419 | 371419 | 2020-07-26 | Mississippi | Missouri | 29133 | 122 | 0 |
361781 | 361781 | 2020-07-23 | Lawrence | Missouri | 29109 | 122 | 2 |
361798 | 361798 | 2020-07-23 | New Madrid | Missouri | 29143 | 122 | 1 |
358575 | 358575 | 2020-07-22 | Lafayette | Missouri | 29107 | 122 | 2 |
352222 | 352222 | 2020-07-20 | Sullivan | Missouri | 29211 | 122 | 0 |
349022 | 349022 | 2020-07-19 | Sullivan | Missouri | 29211 | 122 | 0 |
345821 | 345821 | 2020-07-18 | Sullivan | Missouri | 29211 | 122 | 0 |
342621 | 342621 | 2020-07-17 | Sullivan | Missouri | 29211 | 122 | 0 |
339372 | 339372 | 2020-07-16 | Laclede | Missouri | 29105 | 122 | 1 |
339425 | 339425 | 2020-07-16 | Sullivan | Missouri | 29211 | 122 | 0 |
336133 | 336133 | 2020-07-15 | Butler | Missouri | 29023 | 122 | 0 |
332940 | 332940 | 2020-07-14 | Butler | Missouri | 29023 | 122 | 0 |
332987 | 332987 | 2020-07-14 | Lincoln | Missouri | 29113 | 122 | 1 |
320302 | 320302 | 2020-07-10 | Taney | Missouri | 29213 | 122 | 2 |
294935 | 294935 | 2020-07-02 | Pettis | Missouri | 29159 | 122 | 1 |
247820 | 247820 | 2020-06-17 | Audrain | Missouri | 29007 | 122 | 1 |
244707 | 244707 | 2020-06-16 | Audrain | Missouri | 29007 | 122 | 1 |
241596 | 241596 | 2020-06-15 | Audrain | Missouri | 29007 | 122 | 1 |
238487 | 238487 | 2020-06-14 | Audrain | Missouri | 29007 | 122 | 1 |
235380 | 235380 | 2020-06-13 | Audrain | Missouri | 29007 | 122 | 1 |
232274 | 232274 | 2020-06-12 | Audrain | Missouri | 29007 | 122 | 1 |
176897 | 176897 | 2020-05-25 | Boone | Missouri | 29019 | 122 | 1 |
111034 | 111034 | 2020-05-03 | Franklin | Missouri | 29071 | 122 | 12 |
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);