ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 822 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Missouri · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1707747 | 1707747 | 2021-09-11 | Shelby | Missouri | 29205 | 822 | 8 |
1597232 | 1597232 | 2021-08-08 | Daviess | Missouri | 29061 | 822 | 12 |
1399165 | 1399165 | 2021-06-08 | Caldwell | Missouri | 29025 | 822 | 15 |
1314787 | 1314787 | 2021-05-13 | Gentry | Missouri | 29075 | 822 | 20 |
1311541 | 1311541 | 2021-05-12 | Gentry | Missouri | 29075 | 822 | 20 |
1308294 | 1308294 | 2021-05-11 | Gentry | Missouri | 29075 | 822 | 20 |
1305048 | 1305048 | 2021-05-10 | Gentry | Missouri | 29075 | 822 | 20 |
1301802 | 1301802 | 2021-05-09 | Gentry | Missouri | 29075 | 822 | 20 |
1298554 | 1298554 | 2021-05-08 | Gentry | Missouri | 29075 | 822 | 20 |
1295308 | 1295308 | 2021-05-07 | Gentry | Missouri | 29075 | 822 | 20 |
1292062 | 1292062 | 2021-05-06 | Gentry | Missouri | 29075 | 822 | 20 |
1288816 | 1288816 | 2021-05-05 | Gentry | Missouri | 29075 | 822 | 20 |
1285570 | 1285570 | 2021-05-04 | Gentry | Missouri | 29075 | 822 | 20 |
1282324 | 1282324 | 2021-05-03 | Gentry | Missouri | 29075 | 822 | 20 |
1279077 | 1279077 | 2021-05-02 | Gentry | Missouri | 29075 | 822 | 20 |
1275830 | 1275830 | 2021-05-01 | Gentry | Missouri | 29075 | 822 | 20 |
1272583 | 1272583 | 2021-04-30 | Gentry | Missouri | 29075 | 822 | 20 |
1269336 | 1269336 | 2021-04-29 | Gentry | Missouri | 29075 | 822 | 20 |
1266089 | 1266089 | 2021-04-28 | Gentry | Missouri | 29075 | 822 | 20 |
1262842 | 1262842 | 2021-04-27 | Gentry | Missouri | 29075 | 822 | 20 |
1259595 | 1259595 | 2021-04-26 | Gentry | Missouri | 29075 | 822 | 20 |
1256348 | 1256348 | 2021-04-25 | Gentry | Missouri | 29075 | 822 | 20 |
1253101 | 1253101 | 2021-04-24 | Gentry | Missouri | 29075 | 822 | 20 |
1249854 | 1249854 | 2021-04-23 | Gentry | Missouri | 29075 | 822 | 20 |
1246607 | 1246607 | 2021-04-22 | Gentry | Missouri | 29075 | 822 | 20 |
1243360 | 1243360 | 2021-04-21 | Gentry | Missouri | 29075 | 822 | 20 |
1240113 | 1240113 | 2021-04-20 | Gentry | Missouri | 29075 | 822 | 20 |
1236866 | 1236866 | 2021-04-19 | Gentry | Missouri | 29075 | 822 | 20 |
1233619 | 1233619 | 2021-04-18 | Gentry | Missouri | 29075 | 822 | 20 |
1230371 | 1230371 | 2021-04-17 | Gentry | Missouri | 29075 | 822 | 20 |
1097309 | 1097309 | 2021-03-07 | Wayne | Missouri | 29223 | 822 | 11 |
1093981 | 1093981 | 2021-03-06 | Dent | Missouri | 29065 | 822 | 17 |
1094062 | 1094062 | 2021-03-06 | Wayne | Missouri | 29223 | 822 | 11 |
1090735 | 1090735 | 2021-03-05 | Dent | Missouri | 29065 | 822 | 17 |
1087490 | 1087490 | 2021-03-04 | Dent | Missouri | 29065 | 822 | 17 |
766226 | 766226 | 2020-11-25 | Mississippi | Missouri | 29133 | 822 | 6 |
681915 | 681915 | 2020-10-30 | Warren | Missouri | 29219 | 822 | 3 |
649429 | 649429 | 2020-10-20 | Marion | Missouri | 29127 | 822 | 14 |
646185 | 646185 | 2020-10-19 | Marion | Missouri | 29127 | 822 | 14 |
626649 | 626649 | 2020-10-13 | Audrain | Missouri | 29007 | 822 | 5 |
497182 | 497182 | 2020-09-03 | Pettis | Missouri | 29159 | 822 | 9 |
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);