ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
503 rows where cases = 6 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Chariton 59
- Bates 36
- Harrison 33
- Lewis 22
- Carter 20
- Shannon 20
- Barry 17
- Atchison 15
- Mercer 15
- DeKalb 14
- Maries 14
- Pike 14
- Bollinger 12
- Henry 12
- Macon 10
- Oregon 10
- Dallas 9
- Ste. Genevieve 9
- Holt 8
- Montgomery 8
- Phelps 8
- Douglas 7
- Newton 7
- Linn 6
- Livingston 6
- Osage 6
- Caldwell 5
- Cass 5
- Madison 5
- Andrew 4
- …
state 1
- Missouri · 503 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
406771 | 406771 | 2020-08-06 | Holt | Missouri | 29087 | 6 | 0 |
403553 | 403553 | 2020-08-05 | Holt | Missouri | 29087 | 6 | 0 |
400336 | 400336 | 2020-08-04 | Holt | Missouri | 29087 | 6 | 0 |
397122 | 397122 | 2020-08-03 | Holt | Missouri | 29087 | 6 | 0 |
393906 | 393906 | 2020-08-02 | Holt | Missouri | 29087 | 6 | 0 |
390689 | 390689 | 2020-08-01 | Holt | Missouri | 29087 | 6 | 0 |
390724 | 390724 | 2020-08-01 | Ozark | Missouri | 29153 | 6 | 0 |
387472 | 387472 | 2020-07-31 | Holt | Missouri | 29087 | 6 | 0 |
387507 | 387507 | 2020-07-31 | Ozark | Missouri | 29153 | 6 | 0 |
384254 | 384254 | 2020-07-30 | Holt | Missouri | 29087 | 6 | 0 |
384289 | 384289 | 2020-07-30 | Ozark | Missouri | 29153 | 6 | 0 |
381048 | 381048 | 2020-07-29 | Knox | Missouri | 29103 | 6 | 0 |
381082 | 381082 | 2020-07-29 | Putnam | Missouri | 29171 | 6 | 0 |
358566 | 358566 | 2020-07-22 | Iron | Missouri | 29093 | 6 | 0 |
355319 | 355319 | 2020-07-21 | Atchison | Missouri | 29005 | 6 | 0 |
352117 | 352117 | 2020-07-20 | Atchison | Missouri | 29005 | 6 | 0 |
352209 | 352209 | 2020-07-20 | Schuyler | Missouri | 29197 | 6 | 0 |
348917 | 348917 | 2020-07-19 | Atchison | Missouri | 29005 | 6 | 0 |
349009 | 349009 | 2020-07-19 | Schuyler | Missouri | 29197 | 6 | 0 |
345716 | 345716 | 2020-07-18 | Atchison | Missouri | 29005 | 6 | 0 |
345777 | 345777 | 2020-07-18 | Maries | Missouri | 29125 | 6 | 0 |
345784 | 345784 | 2020-07-18 | Monroe | Missouri | 29137 | 6 | 0 |
345812 | 345812 | 2020-07-18 | Shelby | Missouri | 29205 | 6 | 0 |
342516 | 342516 | 2020-07-17 | Atchison | Missouri | 29005 | 6 | 0 |
342577 | 342577 | 2020-07-17 | Maries | Missouri | 29125 | 6 | 0 |
342584 | 342584 | 2020-07-17 | Monroe | Missouri | 29137 | 6 | 0 |
342612 | 342612 | 2020-07-17 | Shelby | Missouri | 29205 | 6 | 0 |
342614 | 342614 | 2020-07-17 | St. Clair | Missouri | 29185 | 6 | 0 |
339320 | 339320 | 2020-07-16 | Atchison | Missouri | 29005 | 6 | 0 |
339381 | 339381 | 2020-07-16 | Maries | Missouri | 29125 | 6 | 0 |
339388 | 339388 | 2020-07-16 | Monroe | Missouri | 29137 | 6 | 0 |
339418 | 339418 | 2020-07-16 | St. Clair | Missouri | 29185 | 6 | 0 |
336124 | 336124 | 2020-07-15 | Atchison | Missouri | 29005 | 6 | 0 |
336185 | 336185 | 2020-07-15 | Maries | Missouri | 29125 | 6 | 0 |
336222 | 336222 | 2020-07-15 | St. Clair | Missouri | 29185 | 6 | 0 |
332931 | 332931 | 2020-07-14 | Atchison | Missouri | 29005 | 6 | 0 |
332992 | 332992 | 2020-07-14 | Maries | Missouri | 29125 | 6 | 0 |
332999 | 332999 | 2020-07-14 | Monroe | Missouri | 29137 | 6 | 0 |
333029 | 333029 | 2020-07-14 | St. Clair | Missouri | 29185 | 6 | 0 |
333042 | 333042 | 2020-07-14 | Wayne | Missouri | 29223 | 6 | 0 |
329744 | 329744 | 2020-07-13 | Atchison | Missouri | 29005 | 6 | 0 |
329762 | 329762 | 2020-07-13 | Chariton | Missouri | 29041 | 6 | 0 |
329855 | 329855 | 2020-07-13 | Wayne | Missouri | 29223 | 6 | 0 |
326558 | 326558 | 2020-07-12 | Atchison | Missouri | 29005 | 6 | 0 |
326576 | 326576 | 2020-07-12 | Chariton | Missouri | 29041 | 6 | 0 |
323375 | 323375 | 2020-07-11 | Atchison | Missouri | 29005 | 6 | 0 |
323393 | 323393 | 2020-07-11 | Chariton | Missouri | 29041 | 6 | 0 |
323464 | 323464 | 2020-07-11 | Reynolds | Missouri | 29179 | 6 | 0 |
320196 | 320196 | 2020-07-10 | Atchison | Missouri | 29005 | 6 | 0 |
320214 | 320214 | 2020-07-10 | Chariton | Missouri | 29041 | 6 | 0 |
320257 | 320257 | 2020-07-10 | Maries | Missouri | 29125 | 6 | 0 |
320260 | 320260 | 2020-07-10 | Mercer | Missouri | 29129 | 6 | 0 |
317021 | 317021 | 2020-07-09 | Atchison | Missouri | 29005 | 6 | 0 |
317039 | 317039 | 2020-07-09 | Chariton | Missouri | 29041 | 6 | 0 |
317082 | 317082 | 2020-07-09 | Maries | Missouri | 29125 | 6 | 0 |
317085 | 317085 | 2020-07-09 | Mercer | Missouri | 29129 | 6 | 0 |
313847 | 313847 | 2020-07-08 | Atchison | Missouri | 29005 | 6 | 0 |
313862 | 313862 | 2020-07-08 | Carter | Missouri | 29035 | 6 | 1 |
313865 | 313865 | 2020-07-08 | Chariton | Missouri | 29041 | 6 | 0 |
313878 | 313878 | 2020-07-08 | Douglas | Missouri | 29067 | 6 | 0 |
313908 | 313908 | 2020-07-08 | Maries | Missouri | 29125 | 6 | 0 |
313911 | 313911 | 2020-07-08 | Mercer | Missouri | 29129 | 6 | 0 |
310677 | 310677 | 2020-07-07 | Atchison | Missouri | 29005 | 6 | 0 |
310692 | 310692 | 2020-07-07 | Carter | Missouri | 29035 | 6 | 1 |
310695 | 310695 | 2020-07-07 | Chariton | Missouri | 29041 | 6 | 0 |
310708 | 310708 | 2020-07-07 | Douglas | Missouri | 29067 | 6 | 0 |
310737 | 310737 | 2020-07-07 | Maries | Missouri | 29125 | 6 | 0 |
310740 | 310740 | 2020-07-07 | Mercer | Missouri | 29129 | 6 | 0 |
307524 | 307524 | 2020-07-06 | Carter | Missouri | 29035 | 6 | 1 |
307527 | 307527 | 2020-07-06 | Chariton | Missouri | 29041 | 6 | 0 |
307540 | 307540 | 2020-07-06 | Douglas | Missouri | 29067 | 6 | 0 |
307569 | 307569 | 2020-07-06 | Maries | Missouri | 29125 | 6 | 0 |
307572 | 307572 | 2020-07-06 | Mercer | Missouri | 29129 | 6 | 0 |
304357 | 304357 | 2020-07-05 | Carter | Missouri | 29035 | 6 | 1 |
304360 | 304360 | 2020-07-05 | Chariton | Missouri | 29041 | 6 | 0 |
304373 | 304373 | 2020-07-05 | Douglas | Missouri | 29067 | 6 | 0 |
304402 | 304402 | 2020-07-05 | Maries | Missouri | 29125 | 6 | 0 |
304405 | 304405 | 2020-07-05 | Mercer | Missouri | 29129 | 6 | 0 |
301193 | 301193 | 2020-07-04 | Carter | Missouri | 29035 | 6 | 1 |
301196 | 301196 | 2020-07-04 | Chariton | Missouri | 29041 | 6 | 0 |
301209 | 301209 | 2020-07-04 | Douglas | Missouri | 29067 | 6 | 0 |
301238 | 301238 | 2020-07-04 | Maries | Missouri | 29125 | 6 | 0 |
301241 | 301241 | 2020-07-04 | Mercer | Missouri | 29129 | 6 | 0 |
301284 | 301284 | 2020-07-04 | Texas | Missouri | 29215 | 6 | 0 |
298030 | 298030 | 2020-07-03 | Carter | Missouri | 29035 | 6 | 1 |
298033 | 298033 | 2020-07-03 | Chariton | Missouri | 29041 | 6 | 0 |
298046 | 298046 | 2020-07-03 | Douglas | Missouri | 29067 | 6 | 0 |
298074 | 298074 | 2020-07-03 | Madison | Missouri | 29123 | 6 | 0 |
298075 | 298075 | 2020-07-03 | Maries | Missouri | 29125 | 6 | 0 |
298078 | 298078 | 2020-07-03 | Mercer | Missouri | 29129 | 6 | 0 |
298121 | 298121 | 2020-07-03 | Texas | Missouri | 29215 | 6 | 0 |
294872 | 294872 | 2020-07-02 | Carter | Missouri | 29035 | 6 | 1 |
294875 | 294875 | 2020-07-02 | Chariton | Missouri | 29041 | 6 | 0 |
294888 | 294888 | 2020-07-02 | Douglas | Missouri | 29067 | 6 | 0 |
294916 | 294916 | 2020-07-02 | Madison | Missouri | 29123 | 6 | 0 |
294917 | 294917 | 2020-07-02 | Maries | Missouri | 29125 | 6 | 0 |
294920 | 294920 | 2020-07-02 | Mercer | Missouri | 29129 | 6 | 0 |
294963 | 294963 | 2020-07-02 | Texas | Missouri | 29215 | 6 | 0 |
291718 | 291718 | 2020-07-01 | Carter | Missouri | 29035 | 6 | 1 |
291721 | 291721 | 2020-07-01 | Chariton | Missouri | 29041 | 6 | 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);