ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 997 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1782393 | 1782393 | 2021-10-04 | Chariton | Missouri | 29041 | 997 | 8 |
1779143 | 1779143 | 2021-10-03 | Chariton | Missouri | 29041 | 997 | 8 |
1626447 | 1626447 | 2021-08-17 | Caldwell | Missouri | 29025 | 997 | 18 |
1590804 | 1590804 | 2021-08-06 | St. Clair | Missouri | 29185 | 997 | 8 |
1590811 | 1590811 | 2021-08-06 | Sullivan | Missouri | 29211 | 997 | 14 |
1366730 | 1366730 | 2021-05-29 | Dent | Missouri | 29065 | 997 | 17 |
1334269 | 1334269 | 2021-05-19 | Grundy | Missouri | 29079 | 997 | 34 |
1308327 | 1308327 | 2021-05-11 | Monroe | Missouri | 29137 | 997 | 12 |
1305081 | 1305081 | 2021-05-10 | Monroe | Missouri | 29137 | 997 | 12 |
1301835 | 1301835 | 2021-05-09 | Monroe | Missouri | 29137 | 997 | 12 |
1298587 | 1298587 | 2021-05-08 | Monroe | Missouri | 29137 | 997 | 12 |
1246627 | 1246627 | 2021-04-22 | Lewis | Missouri | 29111 | 997 | 13 |
1113515 | 1113515 | 2021-03-12 | Ralls | Missouri | 29173 | 997 | 12 |
737034 | 737034 | 2020-11-16 | Randolph | Missouri | 29175 | 997 | 4 |
724080 | 724080 | 2020-11-12 | Washington | Missouri | 29221 | 997 | 21 |
704511 | 704511 | 2020-11-06 | Barry | Missouri | 29009 | 997 | 18 |
649399 | 649399 | 2020-10-20 | Dunklin | Missouri | 29069 | 997 | 12 |
646155 | 646155 | 2020-10-19 | Dunklin | Missouri | 29069 | 997 | 12 |
400358 | 400358 | 2020-08-04 | McDonald | Missouri | 29119 | 997 | 7 |
397144 | 397144 | 2020-08-03 | McDonald | Missouri | 29119 | 997 | 7 |
361773 | 361773 | 2020-07-23 | Jasper | Missouri | 29097 | 997 | 3 |
358530 | 358530 | 2020-07-22 | Buchanan | Missouri | 29021 | 997 | 9 |
269775 | 269775 | 2020-06-24 | St. Charles | Missouri | 29183 | 997 | 73 |
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);