ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
358 rows where cases = 8 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Crawford 44
- Randolph 44
- Ste. Genevieve 21
- Scotland 18
- Benton 16
- Mercer 16
- Washington 10
- Lewis 9
- Macon 9
- Morgan 8
- Carroll 7
- Harrison 7
- New Madrid 7
- Caldwell 6
- Carter 6
- Cass 5
- Henry 5
- Holt 5
- Montgomery 5
- Oregon 5
- Stone 5
- Daviess 4
- Hickory 4
- Marion 4
- Nodaway 4
- Taney 4
- Worth 4
- Andrew 3
- Barry 3
- Buchanan 3
- …
state 1
- Missouri · 358 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
422874 | 422874 | 2020-08-11 | Holt | Missouri | 29087 | 8 | 0 |
419652 | 419652 | 2020-08-10 | Holt | Missouri | 29087 | 8 | 0 |
416431 | 416431 | 2020-08-09 | Holt | Missouri | 29087 | 8 | 0 |
413211 | 413211 | 2020-08-08 | Holt | Missouri | 29087 | 8 | 0 |
409991 | 409991 | 2020-08-07 | Holt | Missouri | 29087 | 8 | 0 |
403588 | 403588 | 2020-08-05 | Ozark | Missouri | 29153 | 8 | 0 |
400371 | 400371 | 2020-08-04 | Ozark | Missouri | 29153 | 8 | 0 |
393978 | 393978 | 2020-08-02 | Worth | Missouri | 29227 | 8 | 0 |
390712 | 390712 | 2020-08-01 | Mercer | Missouri | 29129 | 8 | 0 |
390761 | 390761 | 2020-08-01 | Worth | Missouri | 29227 | 8 | 0 |
387495 | 387495 | 2020-07-31 | Mercer | Missouri | 29129 | 8 | 0 |
387516 | 387516 | 2020-07-31 | Putnam | Missouri | 29171 | 8 | 1 |
387544 | 387544 | 2020-07-31 | Worth | Missouri | 29227 | 8 | 0 |
384233 | 384233 | 2020-07-30 | Clark | Missouri | 29045 | 8 | 0 |
384277 | 384277 | 2020-07-30 | Mercer | Missouri | 29129 | 8 | 0 |
384326 | 384326 | 2020-07-30 | Worth | Missouri | 29227 | 8 | 0 |
381061 | 381061 | 2020-07-29 | Mercer | Missouri | 29129 | 8 | 0 |
377844 | 377844 | 2020-07-28 | Mercer | Missouri | 29129 | 8 | 0 |
374605 | 374605 | 2020-07-27 | Hickory | Missouri | 29085 | 8 | 0 |
374629 | 374629 | 2020-07-27 | Mercer | Missouri | 29129 | 8 | 0 |
371393 | 371393 | 2020-07-26 | Hickory | Missouri | 29085 | 8 | 0 |
371417 | 371417 | 2020-07-26 | Mercer | Missouri | 29129 | 8 | 0 |
368182 | 368182 | 2020-07-25 | Hickory | Missouri | 29085 | 8 | 0 |
368186 | 368186 | 2020-07-25 | Iron | Missouri | 29093 | 8 | 0 |
368206 | 368206 | 2020-07-25 | Mercer | Missouri | 29129 | 8 | 0 |
364974 | 364974 | 2020-07-24 | Hickory | Missouri | 29085 | 8 | 0 |
364978 | 364978 | 2020-07-24 | Iron | Missouri | 29093 | 8 | 0 |
364998 | 364998 | 2020-07-24 | Mercer | Missouri | 29129 | 8 | 0 |
361791 | 361791 | 2020-07-23 | Mercer | Missouri | 29129 | 8 | 0 |
361838 | 361838 | 2020-07-23 | Wayne | Missouri | 29223 | 8 | 0 |
358583 | 358583 | 2020-07-22 | Maries | Missouri | 29125 | 8 | 0 |
358586 | 358586 | 2020-07-22 | Mercer | Missouri | 29129 | 8 | 0 |
358590 | 358590 | 2020-07-22 | Monroe | Missouri | 29137 | 8 | 0 |
358614 | 358614 | 2020-07-22 | Schuyler | Missouri | 29197 | 8 | 0 |
358618 | 358618 | 2020-07-22 | Shelby | Missouri | 29205 | 8 | 0 |
355380 | 355380 | 2020-07-21 | Maries | Missouri | 29125 | 8 | 0 |
355383 | 355383 | 2020-07-21 | Mercer | Missouri | 29129 | 8 | 0 |
355387 | 355387 | 2020-07-21 | Monroe | Missouri | 29137 | 8 | 0 |
355415 | 355415 | 2020-07-21 | Shelby | Missouri | 29205 | 8 | 0 |
352181 | 352181 | 2020-07-20 | Mercer | Missouri | 29129 | 8 | 0 |
348932 | 348932 | 2020-07-19 | Carter | Missouri | 29035 | 8 | 1 |
348981 | 348981 | 2020-07-19 | Mercer | Missouri | 29129 | 8 | 0 |
345731 | 345731 | 2020-07-18 | Carter | Missouri | 29035 | 8 | 1 |
345780 | 345780 | 2020-07-18 | Mercer | Missouri | 29129 | 8 | 0 |
342531 | 342531 | 2020-07-17 | Carter | Missouri | 29035 | 8 | 1 |
342576 | 342576 | 2020-07-17 | Madison | Missouri | 29123 | 8 | 0 |
339335 | 339335 | 2020-07-16 | Carter | Missouri | 29035 | 8 | 1 |
339338 | 339338 | 2020-07-16 | Chariton | Missouri | 29041 | 8 | 0 |
339362 | 339362 | 2020-07-16 | Howard | Missouri | 29089 | 8 | 0 |
339380 | 339380 | 2020-07-16 | Madison | Missouri | 29123 | 8 | 0 |
336139 | 336139 | 2020-07-15 | Carter | Missouri | 29035 | 8 | 1 |
336166 | 336166 | 2020-07-15 | Howard | Missouri | 29089 | 8 | 0 |
336179 | 336179 | 2020-07-15 | Lewis | Missouri | 29111 | 8 | 1 |
336188 | 336188 | 2020-07-15 | Mercer | Missouri | 29129 | 8 | 0 |
332946 | 332946 | 2020-07-14 | Carter | Missouri | 29035 | 8 | 1 |
326613 | 326613 | 2020-07-12 | Lewis | Missouri | 29111 | 8 | 1 |
323430 | 323430 | 2020-07-11 | Lewis | Missouri | 29111 | 8 | 1 |
320251 | 320251 | 2020-07-10 | Lewis | Missouri | 29111 | 8 | 1 |
317052 | 317052 | 2020-07-09 | Douglas | Missouri | 29067 | 8 | 0 |
317076 | 317076 | 2020-07-09 | Lewis | Missouri | 29111 | 8 | 1 |
313902 | 313902 | 2020-07-08 | Lewis | Missouri | 29111 | 8 | 1 |
310731 | 310731 | 2020-07-07 | Lewis | Missouri | 29111 | 8 | 1 |
310750 | 310750 | 2020-07-07 | Oregon | Missouri | 29149 | 8 | 0 |
307563 | 307563 | 2020-07-06 | Lewis | Missouri | 29111 | 8 | 1 |
307567 | 307567 | 2020-07-06 | Macon | Missouri | 29121 | 8 | 0 |
307582 | 307582 | 2020-07-06 | Oregon | Missouri | 29149 | 8 | 0 |
304396 | 304396 | 2020-07-05 | Lewis | Missouri | 29111 | 8 | 1 |
304400 | 304400 | 2020-07-05 | Macon | Missouri | 29121 | 8 | 0 |
304415 | 304415 | 2020-07-05 | Oregon | Missouri | 29149 | 8 | 0 |
301236 | 301236 | 2020-07-04 | Macon | Missouri | 29121 | 8 | 0 |
301251 | 301251 | 2020-07-04 | Oregon | Missouri | 29149 | 8 | 0 |
298073 | 298073 | 2020-07-03 | Macon | Missouri | 29121 | 8 | 0 |
294915 | 294915 | 2020-07-02 | Macon | Missouri | 29121 | 8 | 0 |
291761 | 291761 | 2020-07-01 | Macon | Missouri | 29121 | 8 | 0 |
291797 | 291797 | 2020-07-01 | Shannon | Missouri | 29203 | 8 | 0 |
288610 | 288610 | 2020-06-30 | Macon | Missouri | 29121 | 8 | 0 |
288646 | 288646 | 2020-06-30 | Shannon | Missouri | 29203 | 8 | 0 |
285430 | 285430 | 2020-06-29 | Daviess | Missouri | 29061 | 8 | 0 |
285460 | 285460 | 2020-06-29 | Macon | Missouri | 29121 | 8 | 0 |
285475 | 285475 | 2020-06-29 | Oregon | Missouri | 29149 | 8 | 0 |
282285 | 282285 | 2020-06-28 | Daviess | Missouri | 29061 | 8 | 0 |
282315 | 282315 | 2020-06-28 | Macon | Missouri | 29121 | 8 | 0 |
279137 | 279137 | 2020-06-27 | Daviess | Missouri | 29061 | 8 | 0 |
275989 | 275989 | 2020-06-26 | Daviess | Missouri | 29061 | 8 | 0 |
272910 | 272910 | 2020-06-25 | Scotland | Missouri | 29199 | 8 | 1 |
269771 | 269771 | 2020-06-24 | Scotland | Missouri | 29199 | 8 | 1 |
266625 | 266625 | 2020-06-23 | Phelps | Missouri | 29161 | 8 | 0 |
266638 | 266638 | 2020-06-23 | Scotland | Missouri | 29199 | 8 | 1 |
263512 | 263512 | 2020-06-22 | Scotland | Missouri | 29199 | 8 | 1 |
260384 | 260384 | 2020-06-21 | Scotland | Missouri | 29199 | 8 | 1 |
257258 | 257258 | 2020-06-20 | Scotland | Missouri | 29199 | 8 | 1 |
254057 | 254057 | 2020-06-19 | Caldwell | Missouri | 29025 | 8 | 0 |
254110 | 254110 | 2020-06-19 | Miller | Missouri | 29131 | 8 | 0 |
254137 | 254137 | 2020-06-19 | Scotland | Missouri | 29199 | 8 | 1 |
250942 | 250942 | 2020-06-18 | Caldwell | Missouri | 29025 | 8 | 0 |
250995 | 250995 | 2020-06-18 | Miller | Missouri | 29131 | 8 | 0 |
251022 | 251022 | 2020-06-18 | Scotland | Missouri | 29199 | 8 | 1 |
251033 | 251033 | 2020-06-18 | Stone | Missouri | 29209 | 8 | 0 |
247829 | 247829 | 2020-06-17 | Caldwell | Missouri | 29025 | 8 | 0 |
247871 | 247871 | 2020-06-17 | Lawrence | Missouri | 29109 | 8 | 0 |
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);