ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 104 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
827934 | 827934 | 2020-12-14 | Worth | Missouri | 29227 | 104 | 0 |
736998 | 736998 | 2020-11-16 | Knox | Missouri | 29103 | 104 | 1 |
659122 | 659122 | 2020-10-23 | Clark | Missouri | 29045 | 104 | 0 |
655877 | 655877 | 2020-10-22 | Clark | Missouri | 29045 | 104 | 0 |
649387 | 649387 | 2020-10-20 | Clark | Missouri | 29045 | 104 | 0 |
646143 | 646143 | 2020-10-19 | Clark | Missouri | 29045 | 104 | 0 |
571554 | 571554 | 2020-09-26 | Carter | Missouri | 29035 | 104 | 1 |
571634 | 571634 | 2020-09-26 | Shannon | Missouri | 29203 | 104 | 1 |
565061 | 565061 | 2020-09-24 | Bates | Missouri | 29013 | 104 | 2 |
542420 | 542420 | 2020-09-17 | DeKalb | Missouri | 29063 | 104 | 2 |
529506 | 529506 | 2020-09-13 | Macon | Missouri | 29121 | 104 | 0 |
526286 | 526286 | 2020-09-12 | Osage | Missouri | 29151 | 104 | 1 |
516538 | 516538 | 2020-09-09 | Gentry | Missouri | 29075 | 104 | 9 |
506894 | 506894 | 2020-09-06 | Ripley | Missouri | 29181 | 104 | 0 |
503685 | 503685 | 2020-09-05 | Wright | Missouri | 29229 | 104 | 0 |
474496 | 474496 | 2020-08-27 | Dallas | Missouri | 29059 | 104 | 1 |
455091 | 455091 | 2020-08-21 | Andrew | Missouri | 29003 | 104 | 1 |
455162 | 455162 | 2020-08-21 | Morgan | Missouri | 29141 | 104 | 0 |
445424 | 445424 | 2020-08-18 | Carroll | Missouri | 29033 | 104 | 0 |
442198 | 442198 | 2020-08-17 | Carroll | Missouri | 29033 | 104 | 0 |
438971 | 438971 | 2020-08-16 | Carroll | Missouri | 29033 | 104 | 0 |
429359 | 429359 | 2020-08-13 | Phelps | Missouri | 29161 | 104 | 0 |
419616 | 419616 | 2020-08-10 | Benton | Missouri | 29015 | 104 | 1 |
397146 | 397146 | 2020-08-03 | Miller | Missouri | 29131 | 104 | 0 |
355385 | 355385 | 2020-07-21 | Mississippi | Missouri | 29133 | 104 | 0 |
352171 | 352171 | 2020-07-20 | Lawrence | Missouri | 29109 | 104 | 2 |
336177 | 336177 | 2020-07-15 | Lafayette | Missouri | 29107 | 104 | 2 |
332984 | 332984 | 2020-07-14 | Lafayette | Missouri | 29107 | 104 | 2 |
326556 | 326556 | 2020-07-12 | Adair | Missouri | 29001 | 104 | 0 |
323373 | 323373 | 2020-07-11 | Adair | Missouri | 29001 | 104 | 0 |
320194 | 320194 | 2020-07-10 | Adair | Missouri | 29001 | 104 | 0 |
317019 | 317019 | 2020-07-09 | Adair | Missouri | 29001 | 104 | 0 |
313845 | 313845 | 2020-07-08 | Adair | Missouri | 29001 | 104 | 0 |
310675 | 310675 | 2020-07-07 | Adair | Missouri | 29001 | 104 | 0 |
291735 | 291735 | 2020-07-01 | Dunklin | Missouri | 29069 | 104 | 3 |
263497 | 263497 | 2020-06-22 | Perry | Missouri | 29157 | 104 | 0 |
247893 | 247893 | 2020-06-17 | Pemiscot | Missouri | 29155 | 104 | 6 |
244780 | 244780 | 2020-06-16 | Pemiscot | Missouri | 29155 | 104 | 6 |
241669 | 241669 | 2020-06-15 | Pemiscot | Missouri | 29155 | 104 | 6 |
238499 | 238499 | 2020-06-14 | Cape Girardeau | Missouri | 29031 | 104 | 3 |
235392 | 235392 | 2020-06-13 | Cape Girardeau | Missouri | 29031 | 104 | 3 |
219889 | 219889 | 2020-06-08 | Cass | Missouri | 29037 | 104 | 8 |
152651 | 152651 | 2020-05-17 | Boone | Missouri | 29019 | 104 | 1 |
140666 | 140666 | 2020-05-13 | Greene | Missouri | 29077 | 104 | 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);