ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 171 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1412249 | 1412249 | 2021-06-12 | Worth | Missouri | 29227 | 171 | 2 |
1009631 | 1009631 | 2021-02-08 | Mercer | Missouri | 29129 | 171 | 2 |
977156 | 977156 | 2021-01-29 | Knox | Missouri | 29103 | 171 | 2 |
973911 | 973911 | 2021-01-28 | Knox | Missouri | 29103 | 171 | 2 |
717525 | 717525 | 2020-11-10 | Holt | Missouri | 29087 | 171 | 2 |
714338 | 714338 | 2020-11-09 | St. Clair | Missouri | 29185 | 171 | 1 |
681863 | 681863 | 2020-10-30 | Linn | Missouri | 29115 | 171 | 4 |
668845 | 668845 | 2020-10-26 | Caldwell | Missouri | 29025 | 171 | 1 |
649422 | 649422 | 2020-10-20 | Lewis | Missouri | 29111 | 171 | 2 |
646178 | 646178 | 2020-10-19 | Lewis | Missouri | 29111 | 171 | 2 |
642891 | 642891 | 2020-10-18 | Carroll | Missouri | 29033 | 171 | 2 |
642912 | 642912 | 2020-10-18 | Gentry | Missouri | 29075 | 171 | 10 |
642915 | 642915 | 2020-10-18 | Harrison | Missouri | 29081 | 171 | 1 |
636423 | 636423 | 2020-10-16 | Hickory | Missouri | 29085 | 171 | 3 |
613684 | 613684 | 2020-10-09 | Bates | Missouri | 29013 | 171 | 3 |
607225 | 607225 | 2020-10-07 | DeKalb | Missouri | 29063 | 171 | 2 |
526298 | 526298 | 2020-09-12 | Randolph | Missouri | 29175 | 171 | 1 |
519819 | 519819 | 2020-09-10 | Pike | Missouri | 29163 | 171 | 2 |
519845 | 519845 | 2020-09-10 | Texas | Missouri | 29215 | 171 | 2 |
477807 | 477807 | 2020-08-28 | Sullivan | Missouri | 29211 | 171 | 0 |
474574 | 474574 | 2020-08-27 | Sullivan | Missouri | 29211 | 171 | 0 |
455204 | 455204 | 2020-08-21 | Webster | Missouri | 29225 | 171 | 1 |
406783 | 406783 | 2020-08-06 | Lafayette | Missouri | 29107 | 171 | 2 |
406792 | 406792 | 2020-08-06 | Marion | Missouri | 29127 | 171 | 1 |
387502 | 387502 | 2020-07-31 | New Madrid | Missouri | 29143 | 171 | 1 |
371405 | 371405 | 2020-07-26 | Laclede | Missouri | 29105 | 171 | 1 |
371437 | 371437 | 2020-07-26 | Pulaski | Missouri | 29169 | 171 | 1 |
352220 | 352220 | 2020-07-20 | Stoddard | Missouri | 29207 | 171 | 9 |
304358 | 304358 | 2020-07-05 | Cass | Missouri | 29037 | 171 | 9 |
291716 | 291716 | 2020-07-01 | Cape Girardeau | Missouri | 29031 | 171 | 3 |
192179 | 192179 | 2020-05-30 | Clay | Missouri | 29047 | 171 | 3 |
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);