ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 255 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
967462 | 967462 | 2021-01-26 | Schuyler | Missouri | 29197 | 255 | 1 |
857031 | 857031 | 2020-12-23 | Atchison | Missouri | 29005 | 255 | 5 |
853786 | 853786 | 2020-12-22 | Atchison | Missouri | 29005 | 255 | 5 |
850541 | 850541 | 2020-12-21 | Atchison | Missouri | 29005 | 255 | 4 |
847296 | 847296 | 2020-12-20 | Atchison | Missouri | 29005 | 255 | 4 |
844050 | 844050 | 2020-12-19 | Atchison | Missouri | 29005 | 255 | 4 |
840805 | 840805 | 2020-12-18 | Atchison | Missouri | 29005 | 255 | 4 |
811687 | 811687 | 2020-12-09 | Shelby | Missouri | 29205 | 255 | 1 |
701322 | 701322 | 2020-11-05 | Lewis | Missouri | 29111 | 255 | 2 |
688333 | 688333 | 2020-11-01 | Hickory | Missouri | 29085 | 255 | 4 |
678566 | 678566 | 2020-10-29 | Bates | Missouri | 29013 | 255 | 6 |
659139 | 659139 | 2020-10-23 | Grundy | Missouri | 29079 | 255 | 9 |
626756 | 626756 | 2020-10-13 | Vernon | Missouri | 29217 | 255 | 2 |
623514 | 623514 | 2020-10-12 | Vernon | Missouri | 29217 | 255 | 2 |
620271 | 620271 | 2020-10-11 | Vernon | Missouri | 29217 | 255 | 2 |
617029 | 617029 | 2020-10-10 | Vernon | Missouri | 29217 | 255 | 2 |
604034 | 604034 | 2020-10-06 | Pike | Missouri | 29163 | 255 | 4 |
600792 | 600792 | 2020-10-05 | Pike | Missouri | 29163 | 255 | 4 |
542451 | 542451 | 2020-09-17 | Madison | Missouri | 29123 | 255 | 0 |
519804 | 519804 | 2020-09-10 | Mississippi | Missouri | 29133 | 255 | 3 |
484212 | 484212 | 2020-08-30 | Howell | Missouri | 29091 | 255 | 3 |
477703 | 477703 | 2020-08-28 | Audrain | Missouri | 29007 | 255 | 1 |
435809 | 435809 | 2020-08-15 | Pemiscot | Missouri | 29155 | 255 | 9 |
435810 | 435810 | 2020-08-15 | Perry | Missouri | 29157 | 255 | 4 |
397113 | 397113 | 2020-08-03 | Dunklin | Missouri | 29069 | 255 | 4 |
222989 | 222989 | 2020-06-09 | Clay | Missouri | 29047 | 255 | 3 |
96751 | 96751 | 2020-04-28 | Jefferson | Missouri | 29099 | 255 | 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);