ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 106 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
847409 | 847409 | 2020-12-20 | Worth | Missouri | 29227 | 106 | 1 |
844163 | 844163 | 2020-12-19 | Worth | Missouri | 29227 | 106 | 1 |
840918 | 840918 | 2020-12-18 | Worth | Missouri | 29227 | 106 | 0 |
831180 | 831180 | 2020-12-15 | Worth | Missouri | 29227 | 106 | 0 |
746770 | 746770 | 2020-11-19 | Putnam | Missouri | 29171 | 106 | 1 |
710996 | 710996 | 2020-11-08 | Atchison | Missouri | 29005 | 106 | 1 |
678606 | 678606 | 2020-10-29 | Iron | Missouri | 29093 | 106 | 0 |
642918 | 642918 | 2020-10-18 | Holt | Missouri | 29087 | 106 | 1 |
613741 | 613741 | 2020-10-09 | Maries | Missouri | 29125 | 106 | 0 |
565085 | 565085 | 2020-09-24 | Daviess | Missouri | 29061 | 106 | 1 |
565095 | 565095 | 2020-09-24 | Harrison | Missouri | 29081 | 106 | 1 |
542421 | 542421 | 2020-09-17 | Dent | Missouri | 29065 | 106 | 0 |
532742 | 532742 | 2020-09-14 | Macon | Missouri | 29121 | 106 | 0 |
510148 | 510148 | 2020-09-07 | Wayne | Missouri | 29223 | 106 | 0 |
506912 | 506912 | 2020-09-06 | Vernon | Missouri | 29217 | 106 | 0 |
477733 | 477733 | 2020-08-28 | Douglas | Missouri | 29067 | 106 | 2 |
477788 | 477788 | 2020-08-28 | Ralls | Missouri | 29173 | 106 | 0 |
474511 | 474511 | 2020-08-27 | Howard | Missouri | 29089 | 106 | 0 |
461586 | 461586 | 2020-08-23 | Henry | Missouri | 29083 | 106 | 3 |
458359 | 458359 | 2020-08-22 | Henry | Missouri | 29083 | 106 | 3 |
458390 | 458390 | 2020-08-22 | Morgan | Missouri | 29141 | 106 | 0 |
419692 | 419692 | 2020-08-10 | Pike | Missouri | 29163 | 106 | 1 |
403616 | 403616 | 2020-08-05 | Stone | Missouri | 29209 | 106 | 1 |
384224 | 384224 | 2020-07-30 | Callaway | Missouri | 29027 | 106 | 1 |
384280 | 384280 | 2020-07-30 | Moniteau | Missouri | 29135 | 106 | 2 |
355373 | 355373 | 2020-07-21 | Lawrence | Missouri | 29109 | 106 | 2 |
313903 | 313903 | 2020-07-08 | Lincoln | Missouri | 29113 | 106 | 1 |
294889 | 294889 | 2020-07-02 | Dunklin | Missouri | 29069 | 106 | 3 |
291712 | 291712 | 2020-07-01 | Butler | Missouri | 29023 | 106 | 0 |
266622 | 266622 | 2020-06-23 | Pemiscot | Missouri | 29155 | 106 | 6 |
266627 | 266627 | 2020-06-23 | Platte | Missouri | 29165 | 106 | 4 |
266629 | 266629 | 2020-06-23 | Pulaski | Missouri | 29169 | 106 | 1 |
263496 | 263496 | 2020-06-22 | Pemiscot | Missouri | 29155 | 106 | 6 |
263503 | 263503 | 2020-06-22 | Pulaski | Missouri | 29169 | 106 | 1 |
260375 | 260375 | 2020-06-21 | Pulaski | Missouri | 29169 | 106 | 1 |
257249 | 257249 | 2020-06-20 | Pulaski | Missouri | 29169 | 106 | 1 |
254128 | 254128 | 2020-06-19 | Pulaski | Missouri | 29169 | 106 | 1 |
251013 | 251013 | 2020-06-18 | Pulaski | Missouri | 29169 | 106 | 1 |
247900 | 247900 | 2020-06-17 | Pulaski | Missouri | 29169 | 106 | 1 |
244787 | 244787 | 2020-06-16 | Pulaski | Missouri | 29169 | 106 | 1 |
241676 | 241676 | 2020-06-15 | Pulaski | Missouri | 29169 | 106 | 1 |
238566 | 238566 | 2020-06-14 | Pulaski | Missouri | 29169 | 106 | 1 |
235459 | 235459 | 2020-06-13 | Pulaski | Missouri | 29169 | 106 | 1 |
232353 | 232353 | 2020-06-12 | Pulaski | Missouri | 29169 | 106 | 1 |
229249 | 229249 | 2020-06-11 | Pulaski | Missouri | 29169 | 106 | 1 |
226146 | 226146 | 2020-06-10 | Pulaski | Missouri | 29169 | 106 | 1 |
226165 | 226165 | 2020-06-10 | Stoddard | Missouri | 29207 | 106 | 5 |
219971 | 219971 | 2020-06-08 | Stoddard | Missouri | 29207 | 106 | 5 |
216879 | 216879 | 2020-06-07 | Stoddard | Missouri | 29207 | 106 | 5 |
213790 | 213790 | 2020-06-06 | Stoddard | Missouri | 29207 | 106 | 5 |
161709 | 161709 | 2020-05-20 | Boone | Missouri | 29019 | 106 | 1 |
158683 | 158683 | 2020-05-19 | Boone | Missouri | 29019 | 106 | 1 |
140654 | 140654 | 2020-05-13 | Clay | Missouri | 29047 | 106 | 1 |
93903 | 93903 | 2020-04-27 | Franklin | Missouri | 29071 | 106 | 6 |
91082 | 91082 | 2020-04-26 | Franklin | Missouri | 29071 | 106 | 6 |
88266 | 88266 | 2020-04-25 | Franklin | Missouri | 29071 | 106 | 6 |
85456 | 85456 | 2020-04-24 | Franklin | Missouri | 29071 | 106 | 5 |
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);