ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 1140 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2257082 | 2257082 | 2022-02-27 | Reynolds | Missouri | 29179 | 1140 | 23 |
2253831 | 2253831 | 2022-02-26 | Reynolds | Missouri | 29179 | 1140 | 23 |
2250580 | 2250580 | 2022-02-25 | Reynolds | Missouri | 29179 | 1140 | 23 |
2026172 | 2026172 | 2021-12-18 | Maries | Missouri | 29125 | 1140 | 22 |
1977447 | 1977447 | 2021-12-03 | Shannon | Missouri | 29203 | 1140 | 27 |
1974197 | 1974197 | 2021-12-02 | Shannon | Missouri | 29203 | 1140 | 27 |
1870111 | 1870111 | 2021-10-31 | Caldwell | Missouri | 29025 | 1140 | 20 |
1714242 | 1714242 | 2021-09-13 | St. Clair | Missouri | 29185 | 1140 | 9 |
1678453 | 1678453 | 2021-09-02 | Iron | Missouri | 29093 | 1140 | 10 |
1587568 | 1587568 | 2021-08-05 | Wayne | Missouri | 29223 | 1140 | 14 |
1555015 | 1555015 | 2021-07-26 | Howard | Missouri | 29089 | 1140 | 9 |
1555042 | 1555042 | 2021-07-26 | Montgomery | Missouri | 29139 | 1140 | 14 |
1431639 | 1431639 | 2021-06-18 | DeKalb | Missouri | 29063 | 1140 | 32 |
1428394 | 1428394 | 2021-06-17 | DeKalb | Missouri | 29063 | 1140 | 32 |
1408908 | 1408908 | 2021-06-11 | Cedar | Missouri | 29039 | 1140 | 21 |
1376443 | 1376443 | 2021-06-01 | Bollinger | Missouri | 29017 | 1140 | 14 |
1373197 | 1373197 | 2021-05-31 | Bollinger | Missouri | 29017 | 1140 | 14 |
1106966 | 1106966 | 2021-03-10 | DeKalb | Missouri | 29063 | 1140 | 27 |
1103720 | 1103720 | 2021-03-09 | DeKalb | Missouri | 29063 | 1140 | 27 |
1100474 | 1100474 | 2021-03-08 | DeKalb | Missouri | 29063 | 1140 | 27 |
967429 | 967429 | 2021-01-26 | Macon | Missouri | 29121 | 1140 | 10 |
918749 | 918749 | 2021-01-11 | Livingston | Missouri | 29117 | 1140 | 24 |
899219 | 899219 | 2021-01-05 | Andrew | Missouri | 29003 | 1140 | 15 |
886324 | 886324 | 2021-01-01 | Ray | Missouri | 29177 | 1140 | 8 |
736948 | 736948 | 2020-11-16 | Audrain | Missouri | 29007 | 1140 | 11 |
720780 | 720780 | 2020-11-11 | Lafayette | Missouri | 29107 | 1140 | 27 |
668878 | 668878 | 2020-10-26 | Howell | Missouri | 29091 | 1140 | 10 |
665674 | 665674 | 2020-10-25 | Polk | Missouri | 29167 | 1140 | 19 |
662429 | 662429 | 2020-10-24 | Polk | Missouri | 29167 | 1140 | 19 |
659185 | 659185 | 2020-10-23 | Polk | Missouri | 29167 | 1140 | 19 |
487419 | 487419 | 2020-08-31 | Cass | Missouri | 29037 | 1140 | 16 |
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);