ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 98 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
818146 | 818146 | 2020-12-11 | Mercer | Missouri | 29129 | 98 | 1 |
814900 | 814900 | 2020-12-10 | Mercer | Missouri | 29129 | 98 | 1 |
704509 | 704509 | 2020-11-06 | Atchison | Missouri | 29005 | 98 | 1 |
698112 | 698112 | 2020-11-04 | Reynolds | Missouri | 29179 | 98 | 1 |
665635 | 665635 | 2020-10-25 | Iron | Missouri | 29093 | 98 | 0 |
662390 | 662390 | 2020-10-24 | Iron | Missouri | 29093 | 98 | 0 |
655953 | 655953 | 2020-10-22 | Shelby | Missouri | 29205 | 98 | 1 |
636424 | 636424 | 2020-10-16 | Holt | Missouri | 29087 | 98 | 1 |
561845 | 561845 | 2020-09-23 | Daviess | Missouri | 29061 | 98 | 1 |
548870 | 548870 | 2020-09-19 | Bates | Missouri | 29013 | 98 | 1 |
497137 | 497137 | 2020-09-03 | Gasconade | Missouri | 29073 | 98 | 3 |
487510 | 487510 | 2020-08-31 | Texas | Missouri | 29215 | 98 | 1 |
484276 | 484276 | 2020-08-30 | Texas | Missouri | 29215 | 98 | 1 |
474529 | 474529 | 2020-08-27 | Madison | Missouri | 29123 | 98 | 0 |
468038 | 468038 | 2020-08-25 | Douglas | Missouri | 29067 | 98 | 2 |
464809 | 464809 | 2020-08-24 | Douglas | Missouri | 29067 | 98 | 2 |
448675 | 448675 | 2020-08-19 | Henry | Missouri | 29083 | 98 | 3 |
445480 | 445480 | 2020-08-18 | Morgan | Missouri | 29141 | 98 | 0 |
442254 | 442254 | 2020-08-17 | Morgan | Missouri | 29141 | 98 | 0 |
438956 | 438956 | 2020-08-16 | Andrew | Missouri | 29003 | 98 | 1 |
397105 | 397105 | 2020-08-03 | Cooper | Missouri | 29053 | 98 | 0 |
393879 | 393879 | 2020-08-02 | Carroll | Missouri | 29033 | 98 | 0 |
390662 | 390662 | 2020-08-01 | Carroll | Missouri | 29033 | 98 | 0 |
371396 | 371396 | 2020-07-26 | Howell | Missouri | 29091 | 98 | 0 |
368185 | 368185 | 2020-07-25 | Howell | Missouri | 29091 | 98 | 0 |
345787 | 345787 | 2020-07-18 | New Madrid | Missouri | 29143 | 98 | 1 |
339386 | 339386 | 2020-07-16 | Mississippi | Missouri | 29133 | 98 | 0 |
336190 | 336190 | 2020-07-15 | Mississippi | Missouri | 29133 | 98 | 0 |
320262 | 320262 | 2020-07-10 | Mississippi | Missouri | 29133 | 98 | 0 |
317087 | 317087 | 2020-07-09 | Mississippi | Missouri | 29133 | 98 | 0 |
304397 | 304397 | 2020-07-05 | Lincoln | Missouri | 29113 | 98 | 1 |
301233 | 301233 | 2020-07-04 | Lincoln | Missouri | 29113 | 98 | 1 |
298070 | 298070 | 2020-07-03 | Lincoln | Missouri | 29113 | 98 | 1 |
288584 | 288584 | 2020-06-30 | Dunklin | Missouri | 29069 | 98 | 3 |
260370 | 260370 | 2020-06-21 | Pettis | Missouri | 29159 | 98 | 1 |
257244 | 257244 | 2020-06-20 | Pettis | Missouri | 29159 | 98 | 1 |
244767 | 244767 | 2020-06-16 | McDonald | Missouri | 29119 | 98 | 0 |
229182 | 229182 | 2020-06-11 | Cape Girardeau | Missouri | 29031 | 98 | 3 |
186122 | 186122 | 2020-05-28 | Scott | Missouri | 29201 | 98 | 8 |
128675 | 128675 | 2020-05-09 | Boone | Missouri | 29019 | 98 | 1 |
125688 | 125688 | 2020-05-08 | Boone | Missouri | 29019 | 98 | 1 |
119732 | 119732 | 2020-05-06 | Boone | Missouri | 29019 | 98 | 1 |
93880 | 93880 | 2020-04-27 | Boone | Missouri | 29019 | 98 | 1 |
91059 | 91059 | 2020-04-26 | Boone | Missouri | 29019 | 98 | 1 |
88243 | 88243 | 2020-04-25 | Boone | Missouri | 29019 | 98 | 1 |
82629 | 82629 | 2020-04-23 | Boone | Missouri | 29019 | 98 | 1 |
71516 | 71516 | 2020-04-19 | Franklin | Missouri | 29071 | 98 | 5 |
44524 | 44524 | 2020-04-09 | Jefferson | Missouri | 29099 | 98 | 2 |
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);