ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 65 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
701352 | 701352 | 2020-11-05 | Putnam | Missouri | 29171 | 65 | 1 |
698108 | 698108 | 2020-11-04 | Putnam | Missouri | 29171 | 65 | 1 |
681857 | 681857 | 2020-10-30 | Knox | Missouri | 29103 | 65 | 1 |
678613 | 678613 | 2020-10-29 | Knox | Missouri | 29103 | 65 | 1 |
662435 | 662435 | 2020-10-24 | Reynolds | Missouri | 29179 | 65 | 1 |
659191 | 659191 | 2020-10-23 | Reynolds | Missouri | 29179 | 65 | 1 |
613680 | 613680 | 2020-10-09 | Atchison | Missouri | 29005 | 65 | 0 |
607240 | 607240 | 2020-10-07 | Iron | Missouri | 29093 | 65 | 0 |
581284 | 581284 | 2020-09-29 | Clark | Missouri | 29045 | 65 | 0 |
578043 | 578043 | 2020-09-28 | Clark | Missouri | 29045 | 65 | 0 |
574802 | 574802 | 2020-09-27 | Clark | Missouri | 29045 | 65 | 0 |
571559 | 571559 | 2020-09-26 | Clark | Missouri | 29045 | 65 | 0 |
545643 | 545643 | 2020-09-18 | Carter | Missouri | 29035 | 65 | 1 |
523044 | 523044 | 2020-09-11 | Montgomery | Missouri | 29139 | 65 | 1 |
519755 | 519755 | 2020-09-10 | Cedar | Missouri | 29039 | 65 | 0 |
519807 | 519807 | 2020-09-10 | Montgomery | Missouri | 29139 | 65 | 1 |
513324 | 513324 | 2020-09-08 | Lewis | Missouri | 29111 | 65 | 2 |
510092 | 510092 | 2020-09-07 | Lewis | Missouri | 29111 | 65 | 2 |
510113 | 510113 | 2020-09-07 | Ozark | Missouri | 29153 | 65 | 0 |
506859 | 506859 | 2020-09-06 | Lewis | Missouri | 29111 | 65 | 2 |
487432 | 487432 | 2020-08-31 | DeKalb | Missouri | 29063 | 65 | 1 |
484198 | 484198 | 2020-08-30 | DeKalb | Missouri | 29063 | 65 | 1 |
474473 | 474473 | 2020-08-27 | Bates | Missouri | 29013 | 65 | 1 |
474507 | 474507 | 2020-08-27 | Harrison | Missouri | 29081 | 65 | 1 |
474537 | 474537 | 2020-08-27 | Monroe | Missouri | 29137 | 65 | 0 |
448722 | 448722 | 2020-08-19 | Ralls | Missouri | 29173 | 65 | 0 |
445468 | 445468 | 2020-08-18 | Livingston | Missouri | 29117 | 65 | 1 |
442242 | 442242 | 2020-08-17 | Livingston | Missouri | 29117 | 65 | 0 |
435839 | 435839 | 2020-08-15 | Texas | Missouri | 29215 | 65 | 1 |
435843 | 435843 | 2020-08-15 | Wayne | Missouri | 29223 | 65 | 0 |
432548 | 432548 | 2020-08-14 | Howard | Missouri | 29089 | 65 | 0 |
426169 | 426169 | 2020-08-12 | Wright | Missouri | 29229 | 65 | 0 |
400317 | 400317 | 2020-08-04 | Clinton | Missouri | 29049 | 65 | 0 |
397084 | 397084 | 2020-08-03 | Barton | Missouri | 29011 | 65 | 0 |
397103 | 397103 | 2020-08-03 | Clinton | Missouri | 29049 | 65 | 0 |
393868 | 393868 | 2020-08-02 | Barton | Missouri | 29011 | 65 | 0 |
390651 | 390651 | 2020-08-01 | Barton | Missouri | 29011 | 65 | 0 |
387434 | 387434 | 2020-07-31 | Barton | Missouri | 29011 | 65 | 0 |
381078 | 381078 | 2020-07-29 | Pike | Missouri | 29163 | 65 | 1 |
377804 | 377804 | 2020-07-28 | Cooper | Missouri | 29053 | 65 | 0 |
377860 | 377860 | 2020-07-28 | Phelps | Missouri | 29161 | 65 | 0 |
355362 | 355362 | 2020-07-21 | Howell | Missouri | 29091 | 65 | 0 |
348916 | 348916 | 2020-07-19 | Andrew | Missouri | 29003 | 65 | 1 |
336178 | 336178 | 2020-07-15 | Lawrence | Missouri | 29109 | 65 | 2 |
250964 | 250964 | 2020-06-18 | Dunklin | Missouri | 29069 | 65 | 3 |
223012 | 223012 | 2020-06-09 | Jasper | Missouri | 29097 | 65 | 0 |
223030 | 223030 | 2020-06-09 | Mississippi | Missouri | 29133 | 65 | 0 |
213792 | 213792 | 2020-06-06 | Sullivan | Missouri | 29211 | 65 | 0 |
207601 | 207601 | 2020-06-04 | Perry | Missouri | 29157 | 65 | 0 |
164804 | 164804 | 2020-05-21 | Platte | Missouri | 29165 | 65 | 1 |
140676 | 140676 | 2020-05-13 | Johnson | Missouri | 29101 | 65 | 0 |
140679 | 140679 | 2020-05-13 | Lafayette | Missouri | 29107 | 65 | 1 |
137682 | 137682 | 2020-05-12 | Johnson | Missouri | 29101 | 65 | 0 |
137706 | 137706 | 2020-05-12 | Pemiscot | Missouri | 29155 | 65 | 3 |
134716 | 134716 | 2020-05-11 | Pemiscot | Missouri | 29155 | 65 | 3 |
116781 | 116781 | 2020-05-05 | Cass | Missouri | 29037 | 65 | 6 |
88257 | 88257 | 2020-04-25 | Clay | Missouri | 29047 | 65 | 1 |
25006 | 25006 | 2020-04-01 | Boone | Missouri | 29019 | 65 | 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);