ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 99 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668879 | 668879 | 2020-10-26 | Iron | Missouri | 29093 | 99 | 0 |
659198 | 659198 | 2020-10-23 | Shelby | Missouri | 29205 | 99 | 1 |
642897 | 642897 | 2020-10-18 | Clark | Missouri | 29045 | 99 | 0 |
639649 | 639649 | 2020-10-17 | Clark | Missouri | 29045 | 99 | 0 |
633206 | 633206 | 2020-10-15 | Montgomery | Missouri | 29139 | 99 | 1 |
633235 | 633235 | 2020-10-15 | St. Clair | Missouri | 29185 | 99 | 1 |
555417 | 555417 | 2020-09-21 | Oregon | Missouri | 29149 | 99 | 0 |
552109 | 552109 | 2020-09-20 | Bates | Missouri | 29013 | 99 | 1 |
548940 | 548940 | 2020-09-19 | Oregon | Missouri | 29149 | 99 | 0 |
545666 | 545666 | 2020-09-18 | Harrison | Missouri | 29081 | 99 | 1 |
542429 | 542429 | 2020-09-17 | Harrison | Missouri | 29081 | 99 | 1 |
542467 | 542467 | 2020-09-17 | Ozark | Missouri | 29153 | 99 | 0 |
539193 | 539193 | 2020-09-16 | Harrison | Missouri | 29081 | 99 | 1 |
523050 | 523050 | 2020-09-11 | Osage | Missouri | 29151 | 99 | 1 |
519813 | 519813 | 2020-09-10 | Osage | Missouri | 29151 | 99 | 1 |
503682 | 503682 | 2020-09-05 | Wayne | Missouri | 29223 | 99 | 0 |
493904 | 493904 | 2020-09-02 | Gasconade | Missouri | 29073 | 99 | 3 |
474571 | 474571 | 2020-08-27 | Ste. Genevieve | Missouri | 29186 | 99 | 1 |
471264 | 471264 | 2020-08-26 | Dallas | Missouri | 29059 | 99 | 1 |
471339 | 471339 | 2020-08-26 | Ste. Genevieve | Missouri | 29186 | 99 | 1 |
451903 | 451903 | 2020-08-20 | Henry | Missouri | 29083 | 99 | 3 |
416471 | 416471 | 2020-08-09 | Pike | Missouri | 29163 | 99 | 1 |
406744 | 406744 | 2020-08-06 | Carroll | Missouri | 29033 | 99 | 0 |
403526 | 403526 | 2020-08-05 | Carroll | Missouri | 29033 | 99 | 0 |
400309 | 400309 | 2020-08-04 | Carroll | Missouri | 29033 | 99 | 0 |
397095 | 397095 | 2020-08-03 | Carroll | Missouri | 29033 | 99 | 0 |
342582 | 342582 | 2020-07-17 | Mississippi | Missouri | 29133 | 99 | 0 |
332997 | 332997 | 2020-07-14 | Mississippi | Missouri | 29133 | 99 | 0 |
329810 | 329810 | 2020-07-13 | Mississippi | Missouri | 29133 | 99 | 0 |
326624 | 326624 | 2020-07-12 | Mississippi | Missouri | 29133 | 99 | 0 |
304340 | 304340 | 2020-07-05 | Adair | Missouri | 29001 | 99 | 0 |
301176 | 301176 | 2020-07-04 | Adair | Missouri | 29001 | 99 | 0 |
294912 | 294912 | 2020-07-02 | Lincoln | Missouri | 29113 | 99 | 1 |
285411 | 285411 | 2020-06-29 | Butler | Missouri | 29023 | 99 | 0 |
244785 | 244785 | 2020-06-16 | Platte | Missouri | 29165 | 99 | 3 |
241674 | 241674 | 2020-06-15 | Platte | Missouri | 29165 | 99 | 3 |
232346 | 232346 | 2020-06-12 | Pemiscot | Missouri | 29155 | 99 | 6 |
229242 | 229242 | 2020-06-11 | Pemiscot | Missouri | 29155 | 99 | 6 |
226139 | 226139 | 2020-06-10 | Pemiscot | Missouri | 29155 | 99 | 6 |
210625 | 210625 | 2020-06-05 | Cass | Missouri | 29037 | 99 | 8 |
207625 | 207625 | 2020-06-04 | Stoddard | Missouri | 29207 | 99 | 4 |
99562 | 99562 | 2020-04-29 | Boone | Missouri | 29019 | 99 | 1 |
96716 | 96716 | 2020-04-28 | Boone | Missouri | 29019 | 99 | 1 |
85433 | 85433 | 2020-04-24 | Boone | Missouri | 29019 | 99 | 1 |
74289 | 74289 | 2020-04-20 | Franklin | Missouri | 29071 | 99 | 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);