ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 194 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
870103 | 870103 | 2020-12-27 | Schuyler | Missouri | 29197 | 194 | 1 |
860361 | 860361 | 2020-12-24 | Putnam | Missouri | 29171 | 194 | 1 |
792214 | 792214 | 2020-12-03 | Scotland | Missouri | 29199 | 194 | 1 |
759670 | 759670 | 2020-11-23 | Atchison | Missouri | 29005 | 194 | 1 |
724068 | 724068 | 2020-11-12 | St. Clair | Missouri | 29185 | 194 | 1 |
691553 | 691553 | 2020-11-02 | Carter | Missouri | 29035 | 194 | 3 |
688303 | 688303 | 2020-11-01 | Caldwell | Missouri | 29025 | 194 | 1 |
652698 | 652698 | 2020-10-21 | Ralls | Missouri | 29173 | 194 | 0 |
642936 | 642936 | 2020-10-18 | Macon | Missouri | 29121 | 194 | 1 |
636411 | 636411 | 2020-10-16 | Daviess | Missouri | 29061 | 194 | 2 |
633165 | 633165 | 2020-10-15 | Daviess | Missouri | 29061 | 194 | 2 |
613768 | 613768 | 2020-10-09 | Ray | Missouri | 29177 | 194 | 2 |
584532 | 584532 | 2020-09-30 | Dallas | Missouri | 29059 | 194 | 1 |
581291 | 581291 | 2020-09-29 | Dallas | Missouri | 29059 | 194 | 1 |
578050 | 578050 | 2020-09-28 | Dallas | Missouri | 29059 | 194 | 1 |
542390 | 542390 | 2020-09-17 | Andrew | Missouri | 29003 | 194 | 1 |
471349 | 471349 | 2020-08-26 | Webster | Missouri | 29225 | 194 | 1 |
432559 | 432559 | 2020-08-14 | Lafayette | Missouri | 29107 | 194 | 2 |
400296 | 400296 | 2020-08-04 | Audrain | Missouri | 29007 | 194 | 1 |
400378 | 400378 | 2020-08-04 | Polk | Missouri | 29167 | 194 | 0 |
397082 | 397082 | 2020-08-03 | Audrain | Missouri | 29007 | 194 | 1 |
397152 | 397152 | 2020-08-03 | New Madrid | Missouri | 29143 | 194 | 1 |
390700 | 390700 | 2020-08-01 | Laclede | Missouri | 29105 | 194 | 1 |
384290 | 384290 | 2020-07-30 | Pemiscot | Missouri | 29155 | 194 | 8 |
384291 | 384291 | 2020-07-30 | Perry | Missouri | 29157 | 194 | 4 |
374567 | 374567 | 2020-07-27 | Barry | Missouri | 29009 | 194 | 0 |
371385 | 371385 | 2020-07-26 | Dunklin | Missouri | 29069 | 194 | 3 |
368174 | 368174 | 2020-07-25 | Dunklin | Missouri | 29069 | 194 | 3 |
336223 | 336223 | 2020-07-15 | St. Francois | Missouri | 29187 | 194 | 2 |
222975 | 222975 | 2020-06-09 | Boone | Missouri | 29019 | 194 | 1 |
216816 | 216816 | 2020-06-07 | Greene | Missouri | 29077 | 194 | 8 |
213728 | 213728 | 2020-06-06 | Greene | Missouri | 29077 | 194 | 8 |
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);