ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 91 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
798675 | 798675 | 2020-12-05 | Mercer | Missouri | 29129 | 91 | 1 |
698023 | 698023 | 2020-11-04 | Atchison | Missouri | 29005 | 91 | 1 |
694780 | 694780 | 2020-11-03 | Atchison | Missouri | 29005 | 91 | 1 |
649411 | 649411 | 2020-10-20 | Iron | Missouri | 29093 | 91 | 0 |
646167 | 646167 | 2020-10-19 | Iron | Missouri | 29093 | 91 | 0 |
642921 | 642921 | 2020-10-18 | Iron | Missouri | 29093 | 91 | 0 |
639673 | 639673 | 2020-10-17 | Iron | Missouri | 29093 | 91 | 0 |
626746 | 626746 | 2020-10-13 | St. Clair | Missouri | 29185 | 91 | 0 |
623504 | 623504 | 2020-10-12 | St. Clair | Missouri | 29185 | 91 | 0 |
620261 | 620261 | 2020-10-11 | St. Clair | Missouri | 29185 | 91 | 0 |
617019 | 617019 | 2020-10-10 | St. Clair | Missouri | 29185 | 91 | 0 |
597529 | 597529 | 2020-10-04 | Maries | Missouri | 29125 | 91 | 0 |
597536 | 597536 | 2020-10-04 | Monroe | Missouri | 29137 | 91 | 1 |
594295 | 594295 | 2020-10-03 | Monroe | Missouri | 29137 | 91 | 1 |
574837 | 574837 | 2020-09-27 | Lewis | Missouri | 29111 | 91 | 2 |
558597 | 558597 | 2020-09-22 | Cedar | Missouri | 29039 | 91 | 0 |
555360 | 555360 | 2020-09-21 | Cedar | Missouri | 29039 | 91 | 0 |
555371 | 555371 | 2020-09-21 | Daviess | Missouri | 29061 | 91 | 0 |
526240 | 526240 | 2020-09-12 | DeKalb | Missouri | 29063 | 91 | 2 |
523013 | 523013 | 2020-09-11 | Harrison | Missouri | 29081 | 91 | 1 |
519797 | 519797 | 2020-09-10 | Macon | Missouri | 29121 | 91 | 0 |
510074 | 510074 | 2020-09-07 | Grundy | Missouri | 29079 | 91 | 1 |
503646 | 503646 | 2020-09-05 | Osage | Missouri | 29151 | 91 | 1 |
493984 | 493984 | 2020-09-02 | Wright | Missouri | 29229 | 91 | 0 |
490726 | 490726 | 2020-09-01 | Ripley | Missouri | 29181 | 91 | 0 |
490750 | 490750 | 2020-09-01 | Wright | Missouri | 29229 | 91 | 0 |
477809 | 477809 | 2020-08-28 | Texas | Missouri | 29215 | 91 | 1 |
468093 | 468093 | 2020-08-25 | Ralls | Missouri | 29173 | 91 | 0 |
464880 | 464880 | 2020-08-24 | Ste. Genevieve | Missouri | 29186 | 91 | 1 |
390672 | 390672 | 2020-08-01 | Cooper | Missouri | 29053 | 91 | 0 |
342528 | 342528 | 2020-07-17 | Camden | Missouri | 29029 | 91 | 2 |
320198 | 320198 | 2020-07-10 | Barry | Missouri | 29009 | 91 | 0 |
307532 | 307532 | 2020-07-06 | Cole | Missouri | 29051 | 91 | 2 |
307574 | 307574 | 2020-07-06 | Mississippi | Missouri | 29133 | 91 | 0 |
304407 | 304407 | 2020-07-05 | Mississippi | Missouri | 29133 | 91 | 0 |
301243 | 301243 | 2020-07-04 | Mississippi | Missouri | 29133 | 91 | 0 |
298013 | 298013 | 2020-07-03 | Adair | Missouri | 29001 | 91 | 0 |
298080 | 298080 | 2020-07-03 | Mississippi | Missouri | 29133 | 91 | 0 |
294855 | 294855 | 2020-07-02 | Adair | Missouri | 29001 | 91 | 0 |
294909 | 294909 | 2020-07-02 | Lafayette | Missouri | 29107 | 91 | 2 |
294922 | 294922 | 2020-07-02 | Mississippi | Missouri | 29133 | 91 | 0 |
291701 | 291701 | 2020-07-01 | Adair | Missouri | 29001 | 91 | 0 |
291755 | 291755 | 2020-07-01 | Lafayette | Missouri | 29107 | 91 | 2 |
291768 | 291768 | 2020-07-01 | Mississippi | Missouri | 29133 | 91 | 0 |
288550 | 288550 | 2020-06-30 | Adair | Missouri | 29001 | 91 | 0 |
269727 | 269727 | 2020-06-24 | Johnson | Missouri | 29101 | 91 | 0 |
266594 | 266594 | 2020-06-23 | Johnson | Missouri | 29101 | 91 | 0 |
260347 | 260347 | 2020-06-21 | Lincoln | Missouri | 29113 | 91 | 1 |
257221 | 257221 | 2020-06-20 | Lincoln | Missouri | 29113 | 91 | 1 |
257243 | 257243 | 2020-06-20 | Perry | Missouri | 29157 | 91 | 0 |
254101 | 254101 | 2020-06-19 | Lincoln | Missouri | 29113 | 91 | 1 |
250986 | 250986 | 2020-06-18 | Lincoln | Missouri | 29113 | 91 | 1 |
251034 | 251034 | 2020-06-18 | Sullivan | Missouri | 29211 | 91 | 0 |
247921 | 247921 | 2020-06-17 | Sullivan | Missouri | 29211 | 91 | 0 |
216853 | 216853 | 2020-06-07 | Pemiscot | Missouri | 29155 | 91 | 5 |
213765 | 213765 | 2020-06-06 | Pemiscot | Missouri | 29155 | 91 | 5 |
170890 | 170890 | 2020-05-23 | Scott | Missouri | 29201 | 91 | 8 |
167851 | 167851 | 2020-05-22 | Scott | Missouri | 29201 | 91 | 8 |
122720 | 122720 | 2020-05-07 | Clay | Missouri | 29047 | 91 | 1 |
122732 | 122732 | 2020-05-07 | Greene | Missouri | 29077 | 91 | 8 |
116798 | 116798 | 2020-05-05 | Greene | Missouri | 29077 | 91 | 8 |
113916 | 113916 | 2020-05-04 | Greene | Missouri | 29077 | 91 | 8 |
65997 | 65997 | 2020-04-17 | Franklin | Missouri | 29071 | 91 | 5 |
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);