ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 453 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1655725 | 1655725 | 2021-08-26 | Knox | Missouri | 29103 | 453 | 3 |
1454372 | 1454372 | 2021-06-25 | Holt | Missouri | 29087 | 453 | 14 |
1003094 | 1003094 | 2021-02-06 | Clark | Missouri | 29045 | 453 | 6 |
999849 | 999849 | 2021-02-05 | Clark | Missouri | 29045 | 453 | 6 |
954434 | 954434 | 2021-01-22 | Iron | Missouri | 29093 | 453 | 1 |
951189 | 951189 | 2021-01-21 | Iron | Missouri | 29093 | 453 | 1 |
944696 | 944696 | 2021-01-19 | Iron | Missouri | 29093 | 453 | 1 |
941451 | 941451 | 2021-01-18 | Iron | Missouri | 29093 | 453 | 1 |
876562 | 876562 | 2020-12-29 | Maries | Missouri | 29125 | 453 | 6 |
873317 | 873317 | 2020-12-28 | Maries | Missouri | 29125 | 453 | 6 |
860304 | 860304 | 2020-12-24 | Daviess | Missouri | 29061 | 453 | 9 |
801894 | 801894 | 2020-12-06 | Harrison | Missouri | 29081 | 453 | 3 |
753267 | 753267 | 2020-11-21 | Ripley | Missouri | 29181 | 453 | 5 |
724075 | 724075 | 2020-11-12 | Sullivan | Missouri | 29211 | 453 | 4 |
717572 | 717572 | 2020-11-10 | Ray | Missouri | 29177 | 453 | 2 |
688296 | 688296 | 2020-11-01 | Barton | Missouri | 29011 | 453 | 4 |
633135 | 633135 | 2020-10-15 | Adair | Missouri | 29001 | 453 | 0 |
629890 | 629890 | 2020-10-14 | Adair | Missouri | 29001 | 453 | 0 |
539207 | 539207 | 2020-09-16 | Laclede | Missouri | 29105 | 453 | 2 |
480996 | 480996 | 2020-08-29 | Marion | Missouri | 29127 | 453 | 3 |
397130 | 397130 | 2020-08-03 | Joplin | Missouri | 453 | 21 |
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);