ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where cases = 230 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918783 | 918783 | 2021-01-11 | Schuyler | Missouri | 29197 | 230 | 1 |
915538 | 915538 | 2021-01-10 | Schuyler | Missouri | 29197 | 230 | 1 |
886329 | 886329 | 2021-01-01 | Scotland | Missouri | 29199 | 230 | 3 |
711065 | 711065 | 2020-11-08 | Montgomery | Missouri | 29139 | 230 | 2 |
698084 | 698084 | 2020-11-04 | Maries | Missouri | 29125 | 230 | 1 |
694841 | 694841 | 2020-11-03 | Maries | Missouri | 29125 | 230 | 1 |
694856 | 694856 | 2020-11-03 | Ozark | Missouri | 29153 | 230 | 1 |
665686 | 665686 | 2020-10-25 | Shannon | Missouri | 29203 | 230 | 4 |
652646 | 652646 | 2020-10-21 | Gasconade | Missouri | 29073 | 230 | 24 |
652654 | 652654 | 2020-10-21 | Howard | Missouri | 29089 | 230 | 2 |
649397 | 649397 | 2020-10-20 | Dent | Missouri | 29065 | 230 | 3 |
646153 | 646153 | 2020-10-19 | Dent | Missouri | 29065 | 230 | 3 |
642907 | 642907 | 2020-10-18 | Dent | Missouri | 29065 | 230 | 3 |
633174 | 633174 | 2020-10-15 | Grundy | Missouri | 29079 | 230 | 8 |
626685 | 626685 | 2020-10-13 | Grundy | Missouri | 29079 | 230 | 7 |
623443 | 623443 | 2020-10-12 | Grundy | Missouri | 29079 | 230 | 7 |
620200 | 620200 | 2020-10-11 | Grundy | Missouri | 29079 | 230 | 7 |
616958 | 616958 | 2020-10-10 | Grundy | Missouri | 29079 | 230 | 7 |
613785 | 613785 | 2020-10-09 | Sullivan | Missouri | 29211 | 230 | 0 |
610543 | 610543 | 2020-10-08 | Sullivan | Missouri | 29211 | 230 | 0 |
591097 | 591097 | 2020-10-02 | Wayne | Missouri | 29223 | 230 | 0 |
558579 | 558579 | 2020-09-22 | Andrew | Missouri | 29003 | 230 | 1 |
481000 | 481000 | 2020-08-29 | Mississippi | Missouri | 29133 | 230 | 0 |
455196 | 455196 | 2020-08-21 | Stone | Missouri | 29209 | 230 | 1 |
422917 | 422917 | 2020-08-11 | Pulaski | Missouri | 29169 | 230 | 1 |
419665 | 419665 | 2020-08-10 | Lawrence | Missouri | 29109 | 230 | 2 |
413241 | 413241 | 2020-08-08 | New Madrid | Missouri | 29143 | 230 | 1 |
410021 | 410021 | 2020-08-07 | New Madrid | Missouri | 29143 | 230 | 1 |
397083 | 397083 | 2020-08-03 | Barry | Missouri | 29009 | 230 | 0 |
77082 | 77082 | 2020-04-21 | Jefferson | Missouri | 29099 | 230 | 3 |
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);