ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 268 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 17
county 17
- Saline 6
- Audrain 2
- Jackson 2
- Schuyler 2
- Shelby 2
- Chariton 1
- Daviess 1
- Douglas 1
- Joplin 1
- Mississippi 1
- Pemiscot 1
- Pike 1
- Ralls 1
- St. Francois 1
- Ste. Genevieve 1
- Vernon 1
- Washington 1
state 1
- Missouri · 26 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1071323 | 1071323 | 2021-02-27 | Schuyler | Missouri | 29197 | 268 | 3 |
1068078 | 1068078 | 2021-02-26 | Schuyler | Missouri | 29197 | 268 | 3 |
837656 | 837656 | 2020-12-17 | Shelby | Missouri | 29205 | 268 | 1 |
834410 | 834410 | 2020-12-16 | Shelby | Missouri | 29205 | 268 | 1 |
808364 | 808364 | 2020-12-08 | Chariton | Missouri | 29041 | 268 | 0 |
720755 | 720755 | 2020-11-11 | Daviess | Missouri | 29061 | 268 | 5 |
714326 | 714326 | 2020-11-09 | Ralls | Missouri | 29173 | 268 | 0 |
642908 | 642908 | 2020-10-18 | Douglas | Missouri | 29067 | 268 | 6 |
636485 | 636485 | 2020-10-16 | Ste. Genevieve | Missouri | 29186 | 268 | 1 |
630000 | 630000 | 2020-10-14 | Vernon | Missouri | 29217 | 268 | 3 |
613761 | 613761 | 2020-10-09 | Pike | Missouri | 29163 | 268 | 4 |
532749 | 532749 | 2020-09-14 | Mississippi | Missouri | 29133 | 268 | 3 |
506914 | 506914 | 2020-09-06 | Washington | Missouri | 29221 | 268 | 1 |
490637 | 490637 | 2020-09-01 | Audrain | Missouri | 29007 | 268 | 1 |
487404 | 487404 | 2020-08-31 | Audrain | Missouri | 29007 | 268 | 1 |
442261 | 442261 | 2020-08-17 | Pemiscot | Missouri | 29155 | 268 | 9 |
377879 | 377879 | 2020-07-28 | St. Francois | Missouri | 29187 | 268 | 2 |
329793 | 329793 | 2020-07-13 | Joplin | Missouri | 268 | 14 | |
213778 | 213778 | 2020-06-06 | Saline | Missouri | 29195 | 268 | 2 |
210694 | 210694 | 2020-06-05 | Saline | Missouri | 29195 | 268 | 2 |
207613 | 207613 | 2020-06-04 | Saline | Missouri | 29195 | 268 | 2 |
204532 | 204532 | 2020-06-03 | Saline | Missouri | 29195 | 268 | 2 |
201455 | 201455 | 2020-06-02 | Saline | Missouri | 29195 | 268 | 2 |
198382 | 198382 | 2020-06-01 | Saline | Missouri | 29195 | 268 | 2 |
71526 | 71526 | 2020-04-19 | Jackson | Missouri | 29095 | 268 | 11 |
68759 | 68759 | 2020-04-18 | Jackson | Missouri | 29095 | 268 | 11 |
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);