ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 121 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
759762 | 759762 | 2020-11-23 | Schuyler | Missouri | 29197 | 121 | 0 |
756515 | 756515 | 2020-11-22 | Schuyler | Missouri | 29197 | 121 | 0 |
707848 | 707848 | 2020-11-07 | Shelby | Missouri | 29205 | 121 | 1 |
672175 | 672175 | 2020-10-27 | St. Clair | Missouri | 29185 | 121 | 1 |
629918 | 629918 | 2020-10-14 | Dade | Missouri | 29057 | 121 | 0 |
594284 | 594284 | 2020-10-03 | Linn | Missouri | 29115 | 121 | 1 |
581281 | 581281 | 2020-09-29 | Cedar | Missouri | 29039 | 121 | 0 |
578040 | 578040 | 2020-09-28 | Cedar | Missouri | 29039 | 121 | 0 |
565133 | 565133 | 2020-09-24 | Ozark | Missouri | 29153 | 121 | 0 |
561852 | 561852 | 2020-09-23 | Gentry | Missouri | 29075 | 121 | 9 |
522989 | 522989 | 2020-09-11 | Carroll | Missouri | 29033 | 121 | 1 |
523083 | 523083 | 2020-09-11 | Vernon | Missouri | 29217 | 121 | 0 |
519752 | 519752 | 2020-09-10 | Carroll | Missouri | 29033 | 121 | 1 |
519828 | 519828 | 2020-09-10 | Ripley | Missouri | 29181 | 121 | 0 |
516517 | 516517 | 2020-09-09 | Carroll | Missouri | 29033 | 121 | 1 |
516593 | 516593 | 2020-09-09 | Ripley | Missouri | 29181 | 121 | 0 |
503598 | 503598 | 2020-09-05 | Dallas | Missouri | 29059 | 121 | 1 |
500376 | 500376 | 2020-09-04 | Henry | Missouri | 29083 | 121 | 3 |
500444 | 500444 | 2020-09-04 | Texas | Missouri | 29215 | 121 | 1 |
490706 | 490706 | 2020-09-01 | Morgan | Missouri | 29141 | 121 | 0 |
480940 | 480940 | 2020-08-29 | Bollinger | Missouri | 29017 | 121 | 1 |
471259 | 471259 | 2020-08-26 | Clinton | Missouri | 29049 | 121 | 0 |
461635 | 461635 | 2020-08-23 | Ray | Missouri | 29177 | 121 | 0 |
448661 | 448661 | 2020-08-19 | Crawford | Missouri | 29055 | 121 | 0 |
390715 | 390715 | 2020-08-01 | Moniteau | Missouri | 29135 | 121 | 2 |
381040 | 381040 | 2020-07-29 | Howell | Missouri | 29091 | 121 | 0 |
368208 | 368208 | 2020-07-25 | Mississippi | Missouri | 29133 | 121 | 0 |
365000 | 365000 | 2020-07-24 | Mississippi | Missouri | 29133 | 121 | 0 |
365043 | 365043 | 2020-07-24 | Warren | Missouri | 29219 | 121 | 0 |
361793 | 361793 | 2020-07-23 | Mississippi | Missouri | 29133 | 121 | 0 |
361836 | 361836 | 2020-07-23 | Warren | Missouri | 29219 | 121 | 0 |
358588 | 358588 | 2020-07-22 | Mississippi | Missouri | 29133 | 121 | 0 |
336229 | 336229 | 2020-07-15 | Sullivan | Missouri | 29211 | 121 | 0 |
263434 | 263434 | 2020-06-22 | Cape Girardeau | Missouri | 29031 | 121 | 3 |
244806 | 244806 | 2020-06-16 | Stoddard | Missouri | 29207 | 121 | 7 |
216870 | 216870 | 2020-06-07 | Scott | Missouri | 29201 | 121 | 9 |
213781 | 213781 | 2020-06-06 | Scott | Missouri | 29201 | 121 | 9 |
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);