ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where cases = 3 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Madison 49
- Carter 46
- Atchison 43
- Stone 42
- Howard 39
- DeKalb 32
- Livingston 30
- Iron 24
- Benton 22
- Caldwell 21
- Douglas 21
- Daviess 20
- Laclede 19
- Nodaway 18
- Putnam 16
- Bollinger 15
- Monroe 13
- Ripley 11
- Morgan 9
- Carroll 8
- Dallas 8
- McDonald 7
- Pettis 7
- Shelby 7
- Vernon 7
- Webster 7
- Linn 6
- Moniteau 6
- Pemiscot 6
- Unknown 6
- …
state 1
- Missouri · 704 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
381017 | 381017 | 2020-07-29 | Clark | Missouri | 29045 | 3 | 0 |
358562 | 358562 | 2020-07-22 | Hickory | Missouri | 29085 | 3 | 0 |
358598 | 358598 | 2020-07-22 | Ozark | Missouri | 29153 | 3 | 0 |
355370 | 355370 | 2020-07-21 | Knox | Missouri | 29103 | 3 | 0 |
355395 | 355395 | 2020-07-21 | Ozark | Missouri | 29153 | 3 | 0 |
352168 | 352168 | 2020-07-20 | Knox | Missouri | 29103 | 3 | 0 |
352193 | 352193 | 2020-07-20 | Ozark | Missouri | 29153 | 3 | 0 |
348993 | 348993 | 2020-07-19 | Ozark | Missouri | 29153 | 3 | 0 |
345760 | 345760 | 2020-07-18 | Iron | Missouri | 29093 | 3 | 0 |
342542 | 342542 | 2020-07-17 | Dade | Missouri | 29057 | 3 | 0 |
342560 | 342560 | 2020-07-17 | Iron | Missouri | 29093 | 3 | 0 |
342601 | 342601 | 2020-07-17 | Putnam | Missouri | 29171 | 3 | 0 |
339364 | 339364 | 2020-07-16 | Iron | Missouri | 29093 | 3 | 0 |
339405 | 339405 | 2020-07-16 | Putnam | Missouri | 29171 | 3 | 0 |
336168 | 336168 | 2020-07-15 | Iron | Missouri | 29093 | 3 | 0 |
336209 | 336209 | 2020-07-15 | Putnam | Missouri | 29171 | 3 | 0 |
332975 | 332975 | 2020-07-14 | Iron | Missouri | 29093 | 3 | 0 |
333016 | 333016 | 2020-07-14 | Putnam | Missouri | 29171 | 3 | 0 |
329788 | 329788 | 2020-07-13 | Iron | Missouri | 29093 | 3 | 0 |
329829 | 329829 | 2020-07-13 | Putnam | Missouri | 29171 | 3 | 0 |
326602 | 326602 | 2020-07-12 | Iron | Missouri | 29093 | 3 | 0 |
326643 | 326643 | 2020-07-12 | Putnam | Missouri | 29171 | 3 | 0 |
323419 | 323419 | 2020-07-11 | Iron | Missouri | 29093 | 3 | 0 |
323460 | 323460 | 2020-07-11 | Putnam | Missouri | 29171 | 3 | 0 |
320240 | 320240 | 2020-07-10 | Iron | Missouri | 29093 | 3 | 0 |
320281 | 320281 | 2020-07-10 | Putnam | Missouri | 29171 | 3 | 0 |
317065 | 317065 | 2020-07-09 | Iron | Missouri | 29093 | 3 | 0 |
317106 | 317106 | 2020-07-09 | Putnam | Missouri | 29171 | 3 | 0 |
317119 | 317119 | 2020-07-09 | St. Clair | Missouri | 29185 | 3 | 0 |
313891 | 313891 | 2020-07-08 | Iron | Missouri | 29093 | 3 | 0 |
313945 | 313945 | 2020-07-08 | St. Clair | Missouri | 29185 | 3 | 0 |
310720 | 310720 | 2020-07-07 | Iron | Missouri | 29093 | 3 | 0 |
307552 | 307552 | 2020-07-06 | Iron | Missouri | 29093 | 3 | 0 |
307593 | 307593 | 2020-07-06 | Putnam | Missouri | 29171 | 3 | 0 |
304385 | 304385 | 2020-07-05 | Iron | Missouri | 29093 | 3 | 0 |
304426 | 304426 | 2020-07-05 | Putnam | Missouri | 29171 | 3 | 0 |
301221 | 301221 | 2020-07-04 | Iron | Missouri | 29093 | 3 | 0 |
301262 | 301262 | 2020-07-04 | Putnam | Missouri | 29171 | 3 | 0 |
298058 | 298058 | 2020-07-03 | Iron | Missouri | 29093 | 3 | 0 |
298099 | 298099 | 2020-07-03 | Putnam | Missouri | 29171 | 3 | 0 |
294900 | 294900 | 2020-07-02 | Iron | Missouri | 29093 | 3 | 0 |
294941 | 294941 | 2020-07-02 | Putnam | Missouri | 29171 | 3 | 0 |
291703 | 291703 | 2020-07-01 | Atchison | Missouri | 29005 | 3 | 0 |
291746 | 291746 | 2020-07-01 | Iron | Missouri | 29093 | 3 | 0 |
291787 | 291787 | 2020-07-01 | Putnam | Missouri | 29171 | 3 | 0 |
288552 | 288552 | 2020-06-30 | Atchison | Missouri | 29005 | 3 | 0 |
288595 | 288595 | 2020-06-30 | Iron | Missouri | 29093 | 3 | 0 |
288636 | 288636 | 2020-06-30 | Putnam | Missouri | 29171 | 3 | 0 |
288647 | 288647 | 2020-06-30 | Shelby | Missouri | 29205 | 3 | 0 |
285402 | 285402 | 2020-06-29 | Atchison | Missouri | 29005 | 3 | 0 |
285445 | 285445 | 2020-06-29 | Iron | Missouri | 29093 | 3 | 0 |
285497 | 285497 | 2020-06-29 | Shelby | Missouri | 29205 | 3 | 0 |
282257 | 282257 | 2020-06-28 | Atchison | Missouri | 29005 | 3 | 0 |
282288 | 282288 | 2020-06-28 | Douglas | Missouri | 29067 | 3 | 0 |
282300 | 282300 | 2020-06-28 | Iron | Missouri | 29093 | 3 | 0 |
282352 | 282352 | 2020-06-28 | Shelby | Missouri | 29205 | 3 | 0 |
282367 | 282367 | 2020-06-28 | Wayne | Missouri | 29223 | 3 | 0 |
279109 | 279109 | 2020-06-27 | Atchison | Missouri | 29005 | 3 | 0 |
279139 | 279139 | 2020-06-27 | Dent | Missouri | 29065 | 3 | 0 |
279140 | 279140 | 2020-06-27 | Douglas | Missouri | 29067 | 3 | 0 |
279152 | 279152 | 2020-06-27 | Iron | Missouri | 29093 | 3 | 0 |
279204 | 279204 | 2020-06-27 | Shelby | Missouri | 29205 | 3 | 0 |
279219 | 279219 | 2020-06-27 | Wayne | Missouri | 29223 | 3 | 0 |
275961 | 275961 | 2020-06-26 | Atchison | Missouri | 29005 | 3 | 0 |
275991 | 275991 | 2020-06-26 | Dent | Missouri | 29065 | 3 | 0 |
275992 | 275992 | 2020-06-26 | Douglas | Missouri | 29067 | 3 | 0 |
276004 | 276004 | 2020-06-26 | Iron | Missouri | 29093 | 3 | 0 |
276020 | 276020 | 2020-06-26 | Madison | Missouri | 29123 | 3 | 0 |
276056 | 276056 | 2020-06-26 | Shelby | Missouri | 29205 | 3 | 0 |
276071 | 276071 | 2020-06-26 | Wayne | Missouri | 29223 | 3 | 0 |
272818 | 272818 | 2020-06-25 | Atchison | Missouri | 29005 | 3 | 0 |
272848 | 272848 | 2020-06-25 | Dent | Missouri | 29065 | 3 | 0 |
272849 | 272849 | 2020-06-25 | Douglas | Missouri | 29067 | 3 | 0 |
272877 | 272877 | 2020-06-25 | Madison | Missouri | 29123 | 3 | 0 |
272913 | 272913 | 2020-06-25 | Shelby | Missouri | 29205 | 3 | 0 |
272928 | 272928 | 2020-06-25 | Wayne | Missouri | 29223 | 3 | 0 |
269680 | 269680 | 2020-06-24 | Atchison | Missouri | 29005 | 3 | 0 |
269711 | 269711 | 2020-06-24 | Douglas | Missouri | 29067 | 3 | 0 |
269738 | 269738 | 2020-06-24 | Madison | Missouri | 29123 | 3 | 0 |
269774 | 269774 | 2020-06-24 | Shelby | Missouri | 29205 | 3 | 0 |
269790 | 269790 | 2020-06-24 | Wayne | Missouri | 29223 | 3 | 0 |
266547 | 266547 | 2020-06-23 | Atchison | Missouri | 29005 | 3 | 0 |
266578 | 266578 | 2020-06-23 | Douglas | Missouri | 29067 | 3 | 0 |
266605 | 266605 | 2020-06-23 | Madison | Missouri | 29123 | 3 | 0 |
266657 | 266657 | 2020-06-23 | Wayne | Missouri | 29223 | 3 | 0 |
263421 | 263421 | 2020-06-22 | Atchison | Missouri | 29005 | 3 | 0 |
263452 | 263452 | 2020-06-22 | Douglas | Missouri | 29067 | 3 | 0 |
263479 | 263479 | 2020-06-22 | Madison | Missouri | 29123 | 3 | 0 |
263480 | 263480 | 2020-06-22 | Maries | Missouri | 29125 | 3 | 0 |
260293 | 260293 | 2020-06-21 | Atchison | Missouri | 29005 | 3 | 0 |
260324 | 260324 | 2020-06-21 | Douglas | Missouri | 29067 | 3 | 0 |
260334 | 260334 | 2020-06-21 | Howard | Missouri | 29089 | 3 | 0 |
260351 | 260351 | 2020-06-21 | Madison | Missouri | 29123 | 3 | 0 |
257167 | 257167 | 2020-06-20 | Atchison | Missouri | 29005 | 3 | 0 |
257198 | 257198 | 2020-06-20 | Douglas | Missouri | 29067 | 3 | 0 |
257208 | 257208 | 2020-06-20 | Howard | Missouri | 29089 | 3 | 0 |
257225 | 257225 | 2020-06-20 | Madison | Missouri | 29123 | 3 | 0 |
254047 | 254047 | 2020-06-19 | Atchison | Missouri | 29005 | 3 | 0 |
254078 | 254078 | 2020-06-19 | Douglas | Missouri | 29067 | 3 | 0 |
254081 | 254081 | 2020-06-19 | Gasconade | Missouri | 29073 | 3 | 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);