ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where cases = 50 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
737060 | 737060 | 2020-11-16 | Worth | Missouri | 29227 | 50 | 0 |
720791 | 720791 | 2020-11-11 | Mercer | Missouri | 29129 | 50 | 0 |
717548 | 717548 | 2020-11-10 | Mercer | Missouri | 29129 | 50 | 0 |
691630 | 691630 | 2020-11-02 | Schuyler | Missouri | 29197 | 50 | 0 |
633226 | 633226 | 2020-10-15 | Reynolds | Missouri | 29179 | 50 | 0 |
629981 | 629981 | 2020-10-14 | Reynolds | Missouri | 29179 | 50 | 0 |
581315 | 581315 | 2020-09-29 | Knox | Missouri | 29103 | 50 | 1 |
578074 | 578074 | 2020-09-28 | Knox | Missouri | 29103 | 50 | 1 |
574833 | 574833 | 2020-09-27 | Knox | Missouri | 29103 | 50 | 1 |
571590 | 571590 | 2020-09-26 | Knox | Missouri | 29103 | 50 | 1 |
568348 | 568348 | 2020-09-25 | Knox | Missouri | 29103 | 50 | 1 |
565108 | 565108 | 2020-09-24 | Knox | Missouri | 29103 | 50 | 1 |
561817 | 561817 | 2020-09-23 | Atchison | Missouri | 29005 | 50 | 0 |
555369 | 555369 | 2020-09-21 | Dade | Missouri | 29057 | 50 | 0 |
532740 | 532740 | 2020-09-14 | Linn | Missouri | 29115 | 50 | 1 |
529462 | 529462 | 2020-09-13 | Carter | Missouri | 29035 | 50 | 1 |
523032 | 523032 | 2020-09-11 | Linn | Missouri | 29115 | 50 | 1 |
516513 | 516513 | 2020-09-09 | Caldwell | Missouri | 29025 | 50 | 1 |
516564 | 516564 | 2020-09-09 | Maries | Missouri | 29125 | 50 | 0 |
513279 | 513279 | 2020-09-08 | Caldwell | Missouri | 29025 | 50 | 1 |
513289 | 513289 | 2020-09-08 | Clark | Missouri | 29045 | 50 | 0 |
510057 | 510057 | 2020-09-07 | Clark | Missouri | 29045 | 50 | 0 |
510098 | 510098 | 2020-09-07 | Maries | Missouri | 29125 | 50 | 0 |
506824 | 506824 | 2020-09-06 | Clark | Missouri | 29045 | 50 | 0 |
503591 | 503591 | 2020-09-05 | Clark | Missouri | 29045 | 50 | 0 |
490680 | 490680 | 2020-09-01 | Iron | Missouri | 29093 | 50 | 0 |
487477 | 487477 | 2020-08-31 | Oregon | Missouri | 29149 | 50 | 0 |
484243 | 484243 | 2020-08-30 | Oregon | Missouri | 29149 | 50 | 0 |
477797 | 477797 | 2020-08-28 | Shannon | Missouri | 29203 | 50 | 1 |
458349 | 458349 | 2020-08-22 | DeKalb | Missouri | 29063 | 50 | 1 |
455121 | 455121 | 2020-08-21 | DeKalb | Missouri | 29063 | 50 | 1 |
455133 | 455133 | 2020-08-21 | Holt | Missouri | 29087 | 50 | 0 |
426110 | 426110 | 2020-08-12 | Lewis | Missouri | 29111 | 50 | 1 |
413277 | 413277 | 2020-08-08 | Texas | Missouri | 29215 | 50 | 0 |
410057 | 410057 | 2020-08-07 | Texas | Missouri | 29215 | 50 | 0 |
397108 | 397108 | 2020-08-03 | Dallas | Missouri | 29059 | 50 | 1 |
384300 | 384300 | 2020-07-30 | Randolph | Missouri | 29175 | 50 | 1 |
381107 | 381107 | 2020-07-29 | Washington | Missouri | 29221 | 50 | 1 |
374571 | 374571 | 2020-07-27 | Bollinger | Missouri | 29017 | 50 | 0 |
371359 | 371359 | 2020-07-26 | Bollinger | Missouri | 29017 | 50 | 0 |
371377 | 371377 | 2020-07-26 | Cooper | Missouri | 29053 | 50 | 0 |
371392 | 371392 | 2020-07-26 | Henry | Missouri | 29083 | 50 | 3 |
364956 | 364956 | 2020-07-24 | Clinton | Missouri | 29049 | 50 | 0 |
361733 | 361733 | 2020-07-23 | Bollinger | Missouri | 29017 | 50 | 0 |
361792 | 361792 | 2020-07-23 | Miller | Missouri | 29131 | 50 | 0 |
361831 | 361831 | 2020-07-23 | Stone | Missouri | 29209 | 50 | 1 |
355400 | 355400 | 2020-07-21 | Pike | Missouri | 29163 | 50 | 1 |
352179 | 352179 | 2020-07-20 | Marion | Missouri | 29127 | 50 | 0 |
320308 | 320308 | 2020-07-10 | Webster | Missouri | 29225 | 50 | 1 |
285401 | 285401 | 2020-06-29 | Andrew | Missouri | 29003 | 50 | 0 |
285468 | 285468 | 2020-06-29 | Moniteau | Missouri | 29135 | 50 | 1 |
263433 | 263433 | 2020-06-22 | Camden | Missouri | 29029 | 50 | 1 |
257264 | 257264 | 2020-06-20 | St. Francois | Missouri | 29187 | 50 | 2 |
254143 | 254143 | 2020-06-19 | St. Francois | Missouri | 29187 | 50 | 2 |
216825 | 216825 | 2020-06-07 | Jasper | Missouri | 29097 | 50 | 0 |
189093 | 189093 | 2020-05-29 | Adair | Missouri | 29001 | 50 | 0 |
186107 | 186107 | 2020-05-28 | Perry | Missouri | 29157 | 50 | 0 |
183051 | 183051 | 2020-05-27 | Perry | Missouri | 29157 | 50 | 0 |
164790 | 164790 | 2020-05-21 | Mississippi | Missouri | 29133 | 50 | 0 |
143700 | 143700 | 2020-05-14 | Platte | Missouri | 29165 | 50 | 0 |
140705 | 140705 | 2020-05-13 | Platte | Missouri | 29165 | 50 | 0 |
137652 | 137652 | 2020-05-12 | Cape Girardeau | Missouri | 29031 | 50 | 1 |
119770 | 119770 | 2020-05-06 | Lafayette | Missouri | 29107 | 50 | 1 |
99578 | 99578 | 2020-04-29 | Cole | Missouri | 29051 | 50 | 1 |
96732 | 96732 | 2020-04-28 | Cole | Missouri | 29051 | 50 | 1 |
93896 | 93896 | 2020-04-27 | Cole | Missouri | 29051 | 50 | 1 |
91075 | 91075 | 2020-04-26 | Cole | Missouri | 29051 | 50 | 1 |
88259 | 88259 | 2020-04-25 | Cole | Missouri | 29051 | 50 | 1 |
74302 | 74302 | 2020-04-20 | Johnson | Missouri | 29101 | 50 | 0 |
74338 | 74338 | 2020-04-20 | Scott | Missouri | 29201 | 50 | 1 |
65983 | 65983 | 2020-04-17 | Cass | Missouri | 29037 | 50 | 5 |
18680 | 18680 | 2020-03-29 | Boone | Missouri | 29019 | 50 | 1 |
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);