ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
452 rows where cases = 7 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Lewis 51
- Lawrence 38
- Montgomery 36
- Ste. Genevieve 20
- Bates 16
- Daviess 16
- Ray 16
- Macon 15
- Ripley 15
- Carroll 13
- Madison 12
- Laclede 9
- Morgan 9
- Bollinger 8
- Caldwell 8
- Stone 8
- Taney 8
- Wright 8
- Cooper 7
- Harrison 7
- Osage 7
- Crawford 6
- Mercer 6
- Oregon 6
- Randolph 6
- Carter 5
- Henry 5
- Livingston 5
- Maries 5
- Phelps 5
- …
state 1
- Missouri · 452 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
397157 | 397157 | 2020-08-03 | Ozark | Missouri | 29153 | 7 | 0 |
393941 | 393941 | 2020-08-02 | Ozark | Missouri | 29153 | 7 | 0 |
384298 | 384298 | 2020-07-30 | Putnam | Missouri | 29171 | 7 | 0 |
381110 | 381110 | 2020-07-29 | Worth | Missouri | 29227 | 7 | 0 |
361767 | 361767 | 2020-07-23 | Hickory | Missouri | 29085 | 7 | 0 |
361771 | 361771 | 2020-07-23 | Iron | Missouri | 29093 | 7 | 0 |
358522 | 358522 | 2020-07-22 | Atchison | Missouri | 29005 | 7 | 0 |
355411 | 355411 | 2020-07-21 | Schuyler | Missouri | 29197 | 7 | 0 |
352178 | 352178 | 2020-07-20 | Maries | Missouri | 29125 | 7 | 0 |
352185 | 352185 | 2020-07-20 | Monroe | Missouri | 29137 | 7 | 0 |
352213 | 352213 | 2020-07-20 | Shelby | Missouri | 29205 | 7 | 0 |
348978 | 348978 | 2020-07-19 | Maries | Missouri | 29125 | 7 | 0 |
348985 | 348985 | 2020-07-19 | Monroe | Missouri | 29137 | 7 | 0 |
349013 | 349013 | 2020-07-19 | Shelby | Missouri | 29205 | 7 | 0 |
342580 | 342580 | 2020-07-17 | Mercer | Missouri | 29129 | 7 | 0 |
339384 | 339384 | 2020-07-16 | Mercer | Missouri | 29129 | 7 | 0 |
336142 | 336142 | 2020-07-15 | Chariton | Missouri | 29041 | 7 | 0 |
336184 | 336184 | 2020-07-15 | Madison | Missouri | 29123 | 7 | 0 |
336192 | 336192 | 2020-07-15 | Monroe | Missouri | 29137 | 7 | 0 |
332949 | 332949 | 2020-07-14 | Chariton | Missouri | 29041 | 7 | 0 |
332991 | 332991 | 2020-07-14 | Madison | Missouri | 29123 | 7 | 0 |
332995 | 332995 | 2020-07-14 | Mercer | Missouri | 29129 | 7 | 0 |
329759 | 329759 | 2020-07-13 | Carter | Missouri | 29035 | 7 | 1 |
329804 | 329804 | 2020-07-13 | Madison | Missouri | 29123 | 7 | 0 |
329805 | 329805 | 2020-07-13 | Maries | Missouri | 29125 | 7 | 0 |
329808 | 329808 | 2020-07-13 | Mercer | Missouri | 29129 | 7 | 0 |
326573 | 326573 | 2020-07-12 | Carter | Missouri | 29035 | 7 | 1 |
326618 | 326618 | 2020-07-12 | Madison | Missouri | 29123 | 7 | 0 |
326619 | 326619 | 2020-07-12 | Maries | Missouri | 29125 | 7 | 0 |
326622 | 326622 | 2020-07-12 | Mercer | Missouri | 29129 | 7 | 0 |
323390 | 323390 | 2020-07-11 | Carter | Missouri | 29035 | 7 | 1 |
323435 | 323435 | 2020-07-11 | Madison | Missouri | 29123 | 7 | 0 |
323436 | 323436 | 2020-07-11 | Maries | Missouri | 29125 | 7 | 0 |
323439 | 323439 | 2020-07-11 | Mercer | Missouri | 29129 | 7 | 0 |
320211 | 320211 | 2020-07-10 | Carter | Missouri | 29035 | 7 | 1 |
320256 | 320256 | 2020-07-10 | Madison | Missouri | 29123 | 7 | 0 |
317036 | 317036 | 2020-07-09 | Carter | Missouri | 29035 | 7 | 1 |
317081 | 317081 | 2020-07-09 | Madison | Missouri | 29123 | 7 | 0 |
313907 | 313907 | 2020-07-08 | Madison | Missouri | 29123 | 7 | 0 |
310736 | 310736 | 2020-07-07 | Madison | Missouri | 29123 | 7 | 0 |
307568 | 307568 | 2020-07-06 | Madison | Missouri | 29123 | 7 | 0 |
304401 | 304401 | 2020-07-05 | Madison | Missouri | 29123 | 7 | 0 |
304448 | 304448 | 2020-07-05 | Texas | Missouri | 29215 | 7 | 0 |
301232 | 301232 | 2020-07-04 | Lewis | Missouri | 29111 | 7 | 1 |
301237 | 301237 | 2020-07-04 | Madison | Missouri | 29123 | 7 | 0 |
298069 | 298069 | 2020-07-03 | Lewis | Missouri | 29111 | 7 | 1 |
298088 | 298088 | 2020-07-03 | Oregon | Missouri | 29149 | 7 | 0 |
298089 | 298089 | 2020-07-03 | Osage | Missouri | 29151 | 7 | 0 |
294911 | 294911 | 2020-07-02 | Lewis | Missouri | 29111 | 7 | 1 |
294930 | 294930 | 2020-07-02 | Oregon | Missouri | 29149 | 7 | 0 |
294931 | 294931 | 2020-07-02 | Osage | Missouri | 29151 | 7 | 0 |
291757 | 291757 | 2020-07-01 | Lewis | Missouri | 29111 | 7 | 1 |
291776 | 291776 | 2020-07-01 | Oregon | Missouri | 29149 | 7 | 0 |
291777 | 291777 | 2020-07-01 | Osage | Missouri | 29151 | 7 | 0 |
288606 | 288606 | 2020-06-30 | Lewis | Missouri | 29111 | 7 | 1 |
288625 | 288625 | 2020-06-30 | Oregon | Missouri | 29149 | 7 | 0 |
288626 | 288626 | 2020-06-30 | Osage | Missouri | 29151 | 7 | 0 |
285456 | 285456 | 2020-06-29 | Lewis | Missouri | 29111 | 7 | 1 |
285476 | 285476 | 2020-06-29 | Osage | Missouri | 29151 | 7 | 0 |
285496 | 285496 | 2020-06-29 | Shannon | Missouri | 29203 | 7 | 0 |
282311 | 282311 | 2020-06-28 | Lewis | Missouri | 29111 | 7 | 1 |
282330 | 282330 | 2020-06-28 | Oregon | Missouri | 29149 | 7 | 0 |
282331 | 282331 | 2020-06-28 | Osage | Missouri | 29151 | 7 | 0 |
279163 | 279163 | 2020-06-27 | Lewis | Missouri | 29111 | 7 | 1 |
279167 | 279167 | 2020-06-27 | Macon | Missouri | 29121 | 7 | 0 |
279182 | 279182 | 2020-06-27 | Oregon | Missouri | 29149 | 7 | 0 |
279183 | 279183 | 2020-06-27 | Osage | Missouri | 29151 | 7 | 0 |
276015 | 276015 | 2020-06-26 | Lewis | Missouri | 29111 | 7 | 1 |
276019 | 276019 | 2020-06-26 | Macon | Missouri | 29121 | 7 | 0 |
272846 | 272846 | 2020-06-25 | Daviess | Missouri | 29061 | 7 | 0 |
272852 | 272852 | 2020-06-25 | Gasconade | Missouri | 29073 | 7 | 0 |
272872 | 272872 | 2020-06-25 | Lewis | Missouri | 29111 | 7 | 1 |
272876 | 272876 | 2020-06-25 | Macon | Missouri | 29121 | 7 | 0 |
269708 | 269708 | 2020-06-24 | Daviess | Missouri | 29061 | 7 | 0 |
269733 | 269733 | 2020-06-24 | Lewis | Missouri | 29111 | 7 | 1 |
269737 | 269737 | 2020-06-24 | Macon | Missouri | 29121 | 7 | 0 |
266575 | 266575 | 2020-06-23 | Daviess | Missouri | 29061 | 7 | 0 |
266600 | 266600 | 2020-06-23 | Lewis | Missouri | 29111 | 7 | 1 |
266603 | 266603 | 2020-06-23 | Livingston | Missouri | 29117 | 7 | 0 |
266604 | 266604 | 2020-06-23 | Macon | Missouri | 29121 | 7 | 0 |
266631 | 266631 | 2020-06-23 | Ralls | Missouri | 29173 | 7 | 0 |
263449 | 263449 | 2020-06-22 | Daviess | Missouri | 29061 | 7 | 0 |
263474 | 263474 | 2020-06-22 | Lewis | Missouri | 29111 | 7 | 1 |
263477 | 263477 | 2020-06-22 | Livingston | Missouri | 29117 | 7 | 0 |
263478 | 263478 | 2020-06-22 | Macon | Missouri | 29121 | 7 | 0 |
263499 | 263499 | 2020-06-22 | Phelps | Missouri | 29161 | 7 | 0 |
260321 | 260321 | 2020-06-21 | Daviess | Missouri | 29061 | 7 | 0 |
260346 | 260346 | 2020-06-21 | Lewis | Missouri | 29111 | 7 | 1 |
260349 | 260349 | 2020-06-21 | Livingston | Missouri | 29117 | 7 | 0 |
260350 | 260350 | 2020-06-21 | Macon | Missouri | 29121 | 7 | 0 |
260371 | 260371 | 2020-06-21 | Phelps | Missouri | 29161 | 7 | 0 |
257195 | 257195 | 2020-06-20 | Daviess | Missouri | 29061 | 7 | 0 |
257220 | 257220 | 2020-06-20 | Lewis | Missouri | 29111 | 7 | 1 |
257224 | 257224 | 2020-06-20 | Macon | Missouri | 29121 | 7 | 0 |
257245 | 257245 | 2020-06-20 | Phelps | Missouri | 29161 | 7 | 0 |
254075 | 254075 | 2020-06-19 | Daviess | Missouri | 29061 | 7 | 0 |
254100 | 254100 | 2020-06-19 | Lewis | Missouri | 29111 | 7 | 1 |
254104 | 254104 | 2020-06-19 | Macon | Missouri | 29121 | 7 | 0 |
250959 | 250959 | 2020-06-18 | Dallas | Missouri | 29059 | 7 | 0 |
250960 | 250960 | 2020-06-18 | Daviess | Missouri | 29061 | 7 | 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);