ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 128 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922049 | 922049 | 2021-01-12 | Worth | Missouri | 29227 | 128 | 1 |
769498 | 769498 | 2020-11-26 | Schuyler | Missouri | 29197 | 128 | 1 |
717580 | 717580 | 2020-11-10 | Shelby | Missouri | 29205 | 128 | 1 |
685069 | 685069 | 2020-10-31 | Clark | Missouri | 29045 | 128 | 1 |
685147 | 685147 | 2020-10-31 | St. Clair | Missouri | 29185 | 128 | 1 |
681904 | 681904 | 2020-10-30 | St. Clair | Missouri | 29185 | 128 | 1 |
613690 | 613690 | 2020-10-09 | Caldwell | Missouri | 29025 | 128 | 1 |
610495 | 610495 | 2020-10-08 | Linn | Missouri | 29115 | 128 | 1 |
600751 | 600751 | 2020-10-05 | Hickory | Missouri | 29085 | 128 | 3 |
581340 | 581340 | 2020-09-29 | Ozark | Missouri | 29153 | 128 | 0 |
578099 | 578099 | 2020-09-28 | Ozark | Missouri | 29153 | 128 | 0 |
558655 | 558655 | 2020-09-22 | Osage | Missouri | 29151 | 128 | 1 |
535932 | 535932 | 2020-09-15 | Carroll | Missouri | 29033 | 128 | 1 |
532697 | 532697 | 2020-09-14 | Carroll | Missouri | 29033 | 128 | 1 |
523061 | 523061 | 2020-09-11 | Ralls | Missouri | 29173 | 128 | 0 |
519769 | 519769 | 2020-09-10 | Douglas | Missouri | 29067 | 128 | 3 |
519824 | 519824 | 2020-09-10 | Ralls | Missouri | 29173 | 128 | 0 |
500425 | 500425 | 2020-09-04 | Ray | Missouri | 29177 | 128 | 0 |
497191 | 497191 | 2020-09-03 | Ray | Missouri | 29177 | 128 | 0 |
493912 | 493912 | 2020-09-02 | Howard | Missouri | 29089 | 128 | 0 |
493940 | 493940 | 2020-09-02 | Morgan | Missouri | 29141 | 128 | 0 |
490723 | 490723 | 2020-09-01 | Randolph | Missouri | 29175 | 128 | 1 |
487490 | 487490 | 2020-08-31 | Randolph | Missouri | 29175 | 128 | 1 |
480956 | 480956 | 2020-08-29 | Clinton | Missouri | 29049 | 128 | 0 |
442264 | 442264 | 2020-08-17 | Phelps | Missouri | 29161 | 128 | 0 |
413282 | 413282 | 2020-08-08 | Webster | Missouri | 29225 | 128 | 1 |
410062 | 410062 | 2020-08-07 | Webster | Missouri | 29225 | 128 | 1 |
406842 | 406842 | 2020-08-06 | Webster | Missouri | 29225 | 128 | 1 |
380995 | 380995 | 2020-07-29 | Adair | Missouri | 29001 | 128 | 0 |
381063 | 381063 | 2020-07-29 | Mississippi | Missouri | 29133 | 128 | 0 |
342568 | 342568 | 2020-07-17 | Laclede | Missouri | 29105 | 128 | 1 |
339376 | 339376 | 2020-07-16 | Lincoln | Missouri | 29113 | 128 | 1 |
320219 | 320219 | 2020-07-10 | Cole | Missouri | 29051 | 128 | 2 |
320228 | 320228 | 2020-07-10 | Dunklin | Missouri | 29069 | 128 | 3 |
304425 | 304425 | 2020-07-05 | Pulaski | Missouri | 29169 | 128 | 1 |
301256 | 301256 | 2020-07-04 | Pettis | Missouri | 29159 | 128 | 1 |
301261 | 301261 | 2020-07-04 | Pulaski | Missouri | 29169 | 128 | 1 |
294940 | 294940 | 2020-07-02 | Pulaski | Missouri | 29169 | 128 | 1 |
226156 | 226156 | 2020-06-10 | Scott | Missouri | 29201 | 128 | 10 |
131688 | 131688 | 2020-05-10 | Franklin | Missouri | 29071 | 128 | 13 |
128698 | 128698 | 2020-05-09 | Franklin | Missouri | 29071 | 128 | 13 |
25034 | 25034 | 2020-04-01 | Kansas City | Missouri | 128 | 0 |
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);