ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 1148 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2286351 | 2286351 | 2022-03-08 | Reynolds | Missouri | 29179 | 1148 | 25 |
2078210 | 2078210 | 2022-01-03 | Shelby | Missouri | 29205 | 1148 | 13 |
1909132 | 1909132 | 2021-11-12 | Harrison | Missouri | 29081 | 1148 | 17 |
1766232 | 1766232 | 2021-09-29 | Sullivan | Missouri | 29211 | 1148 | 14 |
1590817 | 1590817 | 2021-08-06 | Wayne | Missouri | 29223 | 1148 | 14 |
1555028 | 1555028 | 2021-07-26 | Lewis | Missouri | 29111 | 1148 | 20 |
1551781 | 1551781 | 2021-07-25 | Lewis | Missouri | 29111 | 1148 | 20 |
1525779 | 1525779 | 2021-07-17 | Douglas | Missouri | 29067 | 1148 | 30 |
1181646 | 1181646 | 2021-04-02 | DeKalb | Missouri | 29063 | 1148 | 30 |
1178399 | 1178399 | 2021-04-01 | DeKalb | Missouri | 29063 | 1148 | 30 |
1175152 | 1175152 | 2021-03-31 | DeKalb | Missouri | 29063 | 1148 | 30 |
1171905 | 1171905 | 2021-03-30 | DeKalb | Missouri | 29063 | 1148 | 30 |
1168657 | 1168657 | 2021-03-29 | DeKalb | Missouri | 29063 | 1148 | 30 |
1113432 | 1113432 | 2021-03-12 | Barton | Missouri | 29011 | 1148 | 12 |
1110186 | 1110186 | 2021-03-11 | Barton | Missouri | 29011 | 1148 | 12 |
902464 | 902464 | 2021-01-06 | Andrew | Missouri | 29003 | 1148 | 15 |
899286 | 899286 | 2021-01-05 | Mississippi | Missouri | 29133 | 1148 | 18 |
837641 | 837641 | 2020-12-17 | Pike | Missouri | 29163 | 1148 | 11 |
827928 | 827928 | 2020-12-14 | Texas | Missouri | 29215 | 1148 | 10 |
798688 | 798688 | 2020-12-05 | Pemiscot | Missouri | 29155 | 1148 | 19 |
711087 | 711087 | 2020-11-08 | Saline | Missouri | 29195 | 1148 | 11 |
578086 | 578086 | 2020-09-28 | McDonald | Missouri | 29119 | 1148 | 12 |
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);