ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where cases = 35 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Camden 19
- Schuyler 7
- Andrew 5
- DeKalb 5
- Caldwell 4
- Butler 3
- Cole 3
- Harrison 3
- Maries 3
- New Madrid 3
- St. Francois 3
- Chariton 2
- Knox 2
- Lafayette 2
- Scotland 2
- Shannon 2
- Buchanan 1
- Cape Girardeau 1
- Cedar 1
- Christian 1
- Clinton 1
- Cooper 1
- Crawford 1
- Franklin 1
- Gentry 1
- Henry 1
- Hickory 1
- Jasper 1
- Johnson 1
- Lewis 1
- …
state 1
- Missouri · 103 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
685113 | 685113 | 2020-10-31 | Mercer | Missouri | 29129 | 35 | 0 |
655949 | 655949 | 2020-10-22 | Schuyler | Missouri | 29197 | 35 | 0 |
652704 | 652704 | 2020-10-21 | Schuyler | Missouri | 29197 | 35 | 0 |
649459 | 649459 | 2020-10-20 | Schuyler | Missouri | 29197 | 35 | 0 |
646215 | 646215 | 2020-10-19 | Schuyler | Missouri | 29197 | 35 | 0 |
642969 | 642969 | 2020-10-18 | Schuyler | Missouri | 29197 | 35 | 0 |
639721 | 639721 | 2020-10-17 | Schuyler | Missouri | 29197 | 35 | 0 |
636475 | 636475 | 2020-10-16 | Schuyler | Missouri | 29197 | 35 | 0 |
613765 | 613765 | 2020-10-09 | Putnam | Missouri | 29171 | 35 | 1 |
587838 | 587838 | 2020-10-01 | Scotland | Missouri | 29199 | 35 | 1 |
584598 | 584598 | 2020-09-30 | Scotland | Missouri | 29199 | 35 | 1 |
555432 | 555432 | 2020-09-21 | Reynolds | Missouri | 29179 | 35 | 0 |
503589 | 503589 | 2020-09-05 | Chariton | Missouri | 29041 | 35 | 0 |
500355 | 500355 | 2020-09-04 | Chariton | Missouri | 29041 | 35 | 0 |
497179 | 497179 | 2020-09-03 | Ozark | Missouri | 29153 | 35 | 0 |
468068 | 468068 | 2020-08-25 | Maries | Missouri | 29125 | 35 | 0 |
464839 | 464839 | 2020-08-24 | Maries | Missouri | 29125 | 35 | 0 |
461608 | 461608 | 2020-08-23 | Maries | Missouri | 29125 | 35 | 0 |
439017 | 439017 | 2020-08-16 | Madison | Missouri | 29123 | 35 | 0 |
435783 | 435783 | 2020-08-15 | Knox | Missouri | 29103 | 35 | 0 |
432557 | 432557 | 2020-08-14 | Knox | Missouri | 29103 | 35 | 0 |
426095 | 426095 | 2020-08-12 | Hickory | Missouri | 29085 | 35 | 0 |
426112 | 426112 | 2020-08-12 | Linn | Missouri | 29115 | 35 | 1 |
422843 | 422843 | 2020-08-11 | Caldwell | Missouri | 29025 | 35 | 1 |
419621 | 419621 | 2020-08-10 | Caldwell | Missouri | 29025 | 35 | 1 |
416400 | 416400 | 2020-08-09 | Caldwell | Missouri | 29025 | 35 | 1 |
416419 | 416419 | 2020-08-09 | DeKalb | Missouri | 29063 | 35 | 1 |
413199 | 413199 | 2020-08-08 | DeKalb | Missouri | 29063 | 35 | 1 |
409979 | 409979 | 2020-08-07 | DeKalb | Missouri | 29063 | 35 | 1 |
403541 | 403541 | 2020-08-05 | DeKalb | Missouri | 29063 | 35 | 1 |
403567 | 403567 | 2020-08-05 | Lewis | Missouri | 29111 | 35 | 1 |
400312 | 400312 | 2020-08-04 | Cedar | Missouri | 29039 | 35 | 0 |
400324 | 400324 | 2020-08-04 | DeKalb | Missouri | 29063 | 35 | 1 |
397091 | 397091 | 2020-08-03 | Caldwell | Missouri | 29025 | 35 | 1 |
393976 | 393976 | 2020-08-02 | Wayne | Missouri | 29223 | 35 | 0 |
390755 | 390755 | 2020-08-01 | Texas | Missouri | 29215 | 35 | 0 |
374590 | 374590 | 2020-07-27 | Crawford | Missouri | 29055 | 35 | 0 |
365036 | 365036 | 2020-07-24 | Ste. Genevieve | Missouri | 29186 | 35 | 1 |
358617 | 358617 | 2020-07-22 | Shannon | Missouri | 29203 | 35 | 0 |
355414 | 355414 | 2020-07-21 | Shannon | Missouri | 29203 | 35 | 0 |
352141 | 352141 | 2020-07-20 | Cooper | Missouri | 29053 | 35 | 0 |
352155 | 352155 | 2020-07-20 | Harrison | Missouri | 29081 | 35 | 1 |
348955 | 348955 | 2020-07-19 | Harrison | Missouri | 29081 | 35 | 1 |
345754 | 345754 | 2020-07-18 | Harrison | Missouri | 29081 | 35 | 1 |
342555 | 342555 | 2020-07-17 | Henry | Missouri | 29083 | 35 | 3 |
342575 | 342575 | 2020-07-17 | Macon | Missouri | 29121 | 35 | 0 |
342581 | 342581 | 2020-07-17 | Miller | Missouri | 29131 | 35 | 0 |
332953 | 332953 | 2020-07-14 | Clinton | Missouri | 29049 | 35 | 0 |
294968 | 294968 | 2020-07-02 | Webster | Missouri | 29225 | 35 | 1 |
288631 | 288631 | 2020-06-30 | Phelps | Missouri | 29161 | 35 | 0 |
269784 | 269784 | 2020-06-24 | Taney | Missouri | 29213 | 35 | 2 |
266566 | 266566 | 2020-06-23 | Christian | Missouri | 29043 | 35 | 0 |
247818 | 247818 | 2020-06-17 | Andrew | Missouri | 29003 | 35 | 0 |
244705 | 244705 | 2020-06-16 | Andrew | Missouri | 29003 | 35 | 0 |
241594 | 241594 | 2020-06-15 | Andrew | Missouri | 29003 | 35 | 0 |
241664 | 241664 | 2020-06-15 | New Madrid | Missouri | 29143 | 35 | 1 |
238485 | 238485 | 2020-06-14 | Andrew | Missouri | 29003 | 35 | 0 |
238554 | 238554 | 2020-06-14 | New Madrid | Missouri | 29143 | 35 | 1 |
235378 | 235378 | 2020-06-13 | Andrew | Missouri | 29003 | 35 | 0 |
235447 | 235447 | 2020-06-13 | New Madrid | Missouri | 29143 | 35 | 1 |
219941 | 219941 | 2020-06-08 | Newton | Missouri | 29145 | 35 | 1 |
207537 | 207537 | 2020-06-04 | Butler | Missouri | 29023 | 35 | 0 |
204456 | 204456 | 2020-06-03 | Butler | Missouri | 29023 | 35 | 0 |
201379 | 201379 | 2020-06-02 | Butler | Missouri | 29023 | 35 | 0 |
201414 | 201414 | 2020-06-02 | Jasper | Missouri | 29097 | 35 | 0 |
198331 | 198331 | 2020-06-01 | Gentry | Missouri | 29075 | 35 | 1 |
198390 | 198390 | 2020-06-01 | St. Francois | Missouri | 29187 | 35 | 2 |
195319 | 195319 | 2020-05-31 | St. Francois | Missouri | 29187 | 35 | 2 |
192249 | 192249 | 2020-05-30 | St. Francois | Missouri | 29187 | 35 | 2 |
128680 | 128680 | 2020-05-09 | Camden | Missouri | 29029 | 35 | 1 |
125693 | 125693 | 2020-05-08 | Camden | Missouri | 29029 | 35 | 1 |
122711 | 122711 | 2020-05-07 | Camden | Missouri | 29029 | 35 | 1 |
119737 | 119737 | 2020-05-06 | Camden | Missouri | 29029 | 35 | 1 |
116777 | 116777 | 2020-05-05 | Camden | Missouri | 29029 | 35 | 1 |
113895 | 113895 | 2020-05-04 | Camden | Missouri | 29029 | 35 | 1 |
113954 | 113954 | 2020-05-04 | Platte | Missouri | 29165 | 35 | 0 |
111016 | 111016 | 2020-05-03 | Camden | Missouri | 29029 | 35 | 1 |
108145 | 108145 | 2020-05-02 | Camden | Missouri | 29029 | 35 | 1 |
105280 | 105280 | 2020-05-01 | Camden | Missouri | 29029 | 35 | 1 |
102419 | 102419 | 2020-04-30 | Camden | Missouri | 29029 | 35 | 1 |
102474 | 102474 | 2020-04-30 | Pettis | Missouri | 29159 | 35 | 0 |
99567 | 99567 | 2020-04-29 | Camden | Missouri | 29029 | 35 | 1 |
96721 | 96721 | 2020-04-28 | Camden | Missouri | 29029 | 35 | 1 |
93885 | 93885 | 2020-04-27 | Camden | Missouri | 29029 | 35 | 1 |
93918 | 93918 | 2020-04-27 | Lafayette | Missouri | 29107 | 35 | 1 |
91064 | 91064 | 2020-04-26 | Camden | Missouri | 29029 | 35 | 1 |
91097 | 91097 | 2020-04-26 | Lafayette | Missouri | 29107 | 35 | 1 |
88248 | 88248 | 2020-04-25 | Camden | Missouri | 29029 | 35 | 1 |
85438 | 85438 | 2020-04-24 | Camden | Missouri | 29029 | 35 | 1 |
85483 | 85483 | 2020-04-24 | Moniteau | Missouri | 29135 | 35 | 0 |
82634 | 82634 | 2020-04-23 | Camden | Missouri | 29029 | 35 | 1 |
82669 | 82669 | 2020-04-23 | Lincoln | Missouri | 29113 | 35 | 1 |
79834 | 79834 | 2020-04-22 | Buchanan | Missouri | 29021 | 35 | 1 |
79838 | 79838 | 2020-04-22 | Camden | Missouri | 29029 | 35 | 1 |
77053 | 77053 | 2020-04-21 | Camden | Missouri | 29029 | 35 | 1 |
65981 | 65981 | 2020-04-17 | Cape Girardeau | Missouri | 29031 | 35 | 1 |
57866 | 57866 | 2020-04-14 | Saline | Missouri | 29195 | 35 | 0 |
52474 | 52474 | 2020-04-12 | Perry | Missouri | 29157 | 35 | 0 |
47117 | 47117 | 2020-04-10 | Cole | Missouri | 29051 | 35 | 1 |
44508 | 44508 | 2020-04-09 | Cole | Missouri | 29051 | 35 | 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);