ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 639 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1905886 | 1905886 | 2021-11-11 | Holt | Missouri | 29087 | 639 | 16 |
1902637 | 1902637 | 2021-11-10 | Holt | Missouri | 29087 | 639 | 16 |
1899387 | 1899387 | 2021-11-09 | Holt | Missouri | 29087 | 639 | 16 |
1896137 | 1896137 | 2021-11-08 | Holt | Missouri | 29087 | 639 | 16 |
1792121 | 1792121 | 2021-10-07 | Atchison | Missouri | 29005 | 639 | 7 |
1509607 | 1509607 | 2021-07-12 | Shannon | Missouri | 29203 | 639 | 12 |
1506361 | 1506361 | 2021-07-11 | Shannon | Missouri | 29203 | 639 | 12 |
1483567 | 1483567 | 2021-07-04 | Dade | Missouri | 29057 | 639 | 31 |
1331046 | 1331046 | 2021-05-18 | Maries | Missouri | 29125 | 639 | 8 |
1236871 | 1236871 | 2021-04-19 | Hickory | Missouri | 29085 | 639 | 15 |
1233624 | 1233624 | 2021-04-18 | Hickory | Missouri | 29085 | 639 | 15 |
1230376 | 1230376 | 2021-04-17 | Hickory | Missouri | 29085 | 639 | 15 |
1126435 | 1126435 | 2021-03-16 | Clark | Missouri | 29045 | 639 | 6 |
1100485 | 1100485 | 2021-03-08 | Hickory | Missouri | 29085 | 639 | 13 |
1055015 | 1055015 | 2021-02-22 | Caldwell | Missouri | 29025 | 639 | 10 |
1051768 | 1051768 | 2021-02-21 | Caldwell | Missouri | 29025 | 639 | 10 |
1048521 | 1048521 | 2021-02-20 | Caldwell | Missouri | 29025 | 639 | 10 |
704623 | 704623 | 2020-11-06 | Wright | Missouri | 29229 | 639 | 9 |
672102 | 672102 | 2020-10-27 | Crawford | Missouri | 29055 | 639 | 8 |
571651 | 571651 | 2020-09-26 | Webster | Missouri | 29225 | 639 | 5 |
435811 | 435811 | 2020-08-15 | Pettis | Missouri | 29159 | 639 | 5 |
317028 | 317028 | 2020-07-09 | Boone | Missouri | 29019 | 639 | 2 |
119808 | 119808 | 2020-05-06 | St. Charles | Missouri | 29183 | 639 | 45 |
55176 | 55176 | 2020-04-13 | St. Louis city | Missouri | 29510 | 639 | 24 |
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);