ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 495 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
866783 | 866783 | 2020-12-26 | Cedar | Missouri | 29039 | 495 | 8 |
847306 | 847306 | 2020-12-20 | Caldwell | Missouri | 29025 | 495 | 3 |
847370 | 847370 | 2020-12-20 | Oregon | Missouri | 29149 | 495 | 3 |
818117 | 818117 | 2020-12-11 | Gentry | Missouri | 29075 | 495 | 14 |
818120 | 818120 | 2020-12-11 | Harrison | Missouri | 29081 | 495 | 7 |
814871 | 814871 | 2020-12-10 | Gentry | Missouri | 29075 | 495 | 14 |
814874 | 814874 | 2020-12-10 | Harrison | Missouri | 29081 | 495 | 7 |
788910 | 788910 | 2020-12-02 | Gasconade | Missouri | 29073 | 495 | 24 |
759674 | 759674 | 2020-11-23 | Bates | Missouri | 29013 | 495 | 8 |
698089 | 698089 | 2020-11-04 | Mississippi | Missouri | 29133 | 495 | 6 |
668857 | 668857 | 2020-10-26 | Clinton | Missouri | 29049 | 495 | 17 |
571642 | 571642 | 2020-09-26 | Stoddard | Missouri | 29207 | 495 | 13 |
545699 | 545699 | 2020-09-18 | New Madrid | Missouri | 29143 | 495 | 14 |
170847 | 170847 | 2020-05-23 | Jackson | Missouri | 29095 | 495 | 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);