ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 123 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 |
---|---|---|---|---|---|---|---|
857095 | 857095 | 2020-12-23 | Mercer | Missouri | 29129 | 123 | 1 |
694824 | 694824 | 2020-11-03 | Iron | Missouri | 29093 | 123 | 0 |
681847 | 681847 | 2020-10-30 | Holt | Missouri | 29087 | 123 | 1 |
675418 | 675418 | 2020-10-28 | St. Clair | Missouri | 29185 | 123 | 1 |
633163 | 633163 | 2020-10-15 | Dade | Missouri | 29057 | 123 | 0 |
604010 | 604010 | 2020-10-06 | Linn | Missouri | 29115 | 123 | 1 |
584533 | 584533 | 2020-09-30 | Daviess | Missouri | 29061 | 123 | 1 |
584540 | 584540 | 2020-09-30 | Gentry | Missouri | 29075 | 123 | 9 |
581292 | 581292 | 2020-09-29 | Daviess | Missouri | 29061 | 123 | 1 |
578051 | 578051 | 2020-09-28 | Daviess | Missouri | 29061 | 123 | 1 |
574786 | 574786 | 2020-09-27 | Bates | Missouri | 29013 | 123 | 2 |
574856 | 574856 | 2020-09-27 | Oregon | Missouri | 29149 | 123 | 0 |
558609 | 558609 | 2020-09-22 | DeKalb | Missouri | 29063 | 123 | 2 |
526225 | 526225 | 2020-09-12 | Carroll | Missouri | 29033 | 123 | 1 |
513355 | 513355 | 2020-09-08 | Ralls | Missouri | 29173 | 123 | 0 |
510064 | 510064 | 2020-09-07 | Dallas | Missouri | 29059 | 123 | 1 |
474491 | 474491 | 2020-08-27 | Clinton | Missouri | 29049 | 123 | 0 |
439037 | 439037 | 2020-08-16 | Phelps | Missouri | 29161 | 123 | 0 |
413274 | 413274 | 2020-08-08 | Stone | Missouri | 29209 | 123 | 1 |
410054 | 410054 | 2020-08-07 | Stone | Missouri | 29209 | 123 | 1 |
400407 | 400407 | 2020-08-04 | Webster | Missouri | 29225 | 123 | 1 |
397148 | 397148 | 2020-08-03 | Moniteau | Missouri | 29135 | 123 | 2 |
393932 | 393932 | 2020-08-02 | Moniteau | Missouri | 29135 | 123 | 2 |
390659 | 390659 | 2020-08-01 | Callaway | Missouri | 29027 | 123 | 1 |
384256 | 384256 | 2020-07-30 | Howell | Missouri | 29091 | 123 | 1 |
326664 | 326664 | 2020-07-12 | Taney | Missouri | 29213 | 123 | 3 |
323481 | 323481 | 2020-07-11 | Taney | Missouri | 29213 | 123 | 3 |
279186 | 279186 | 2020-06-27 | Perry | Missouri | 29157 | 123 | 0 |
272834 | 272834 | 2020-06-25 | Cass | Missouri | 29037 | 123 | 8 |
269693 | 269693 | 2020-06-24 | Cape Girardeau | Missouri | 29031 | 123 | 3 |
266560 | 266560 | 2020-06-23 | Cape Girardeau | Missouri | 29031 | 123 | 3 |
250933 | 250933 | 2020-06-18 | Audrain | Missouri | 29007 | 123 | 1 |
219962 | 219962 | 2020-06-08 | Scott | Missouri | 29201 | 123 | 10 |
179941 | 179941 | 2020-05-26 | Boone | Missouri | 29019 | 123 | 1 |
158697 | 158697 | 2020-05-19 | Clay | Missouri | 29047 | 123 | 1 |
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);