ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 102 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733752 | 733752 | 2020-11-15 | Knox | Missouri | 29103 | 102 | 1 |
730507 | 730507 | 2020-11-14 | Knox | Missouri | 29103 | 102 | 1 |
707752 | 707752 | 2020-11-07 | Atchison | Missouri | 29005 | 102 | 1 |
675364 | 675364 | 2020-10-28 | Iron | Missouri | 29093 | 102 | 0 |
662442 | 662442 | 2020-10-24 | Shelby | Missouri | 29205 | 102 | 1 |
565074 | 565074 | 2020-09-24 | Cedar | Missouri | 29039 | 102 | 0 |
561891 | 561891 | 2020-09-23 | Oregon | Missouri | 29149 | 102 | 0 |
513304 | 513304 | 2020-09-08 | Gentry | Missouri | 29075 | 102 | 9 |
510072 | 510072 | 2020-09-07 | Gentry | Missouri | 29075 | 102 | 9 |
506915 | 506915 | 2020-09-06 | Wayne | Missouri | 29223 | 102 | 0 |
503661 | 503661 | 2020-09-05 | Ripley | Missouri | 29181 | 102 | 0 |
484172 | 484172 | 2020-08-30 | Barton | Missouri | 29011 | 102 | 0 |
480937 | 480937 | 2020-08-29 | Barton | Missouri | 29011 | 102 | 0 |
474500 | 474500 | 2020-08-27 | Douglas | Missouri | 29067 | 102 | 2 |
458407 | 458407 | 2020-08-22 | Randolph | Missouri | 29175 | 102 | 1 |
448635 | 448635 | 2020-08-19 | Andrew | Missouri | 29003 | 102 | 1 |
445409 | 445409 | 2020-08-18 | Andrew | Missouri | 29003 | 102 | 1 |
435746 | 435746 | 2020-08-15 | Carroll | Missouri | 29033 | 102 | 0 |
435757 | 435757 | 2020-08-15 | Crawford | Missouri | 29055 | 102 | 0 |
432520 | 432520 | 2020-08-14 | Carroll | Missouri | 29033 | 102 | 0 |
429293 | 429293 | 2020-08-13 | Carroll | Missouri | 29033 | 102 | 0 |
426069 | 426069 | 2020-08-12 | Carroll | Missouri | 29033 | 102 | 0 |
381008 | 381008 | 2020-07-29 | Callaway | Missouri | 29027 | 102 | 1 |
381064 | 381064 | 2020-07-29 | Moniteau | Missouri | 29135 | 102 | 2 |
377842 | 377842 | 2020-07-28 | Marion | Missouri | 29127 | 102 | 1 |
377892 | 377892 | 2020-07-28 | Webster | Missouri | 29225 | 102 | 1 |
348929 | 348929 | 2020-07-19 | Camden | Missouri | 29029 | 102 | 2 |
332983 | 332983 | 2020-07-14 | Laclede | Missouri | 29105 | 102 | 1 |
329763 | 329763 | 2020-07-13 | Christian | Missouri | 29043 | 102 | 1 |
323428 | 323428 | 2020-07-11 | Lafayette | Missouri | 29107 | 102 | 2 |
313870 | 313870 | 2020-07-08 | Cole | Missouri | 29051 | 102 | 2 |
307564 | 307564 | 2020-07-06 | Lincoln | Missouri | 29113 | 102 | 1 |
269757 | 269757 | 2020-06-24 | Pettis | Missouri | 29159 | 102 | 1 |
269783 | 269783 | 2020-06-24 | Sullivan | Missouri | 29211 | 102 | 0 |
266624 | 266624 | 2020-06-23 | Pettis | Missouri | 29159 | 102 | 1 |
263501 | 263501 | 2020-06-22 | Platte | Missouri | 29165 | 102 | 4 |
263524 | 263524 | 2020-06-22 | Sullivan | Missouri | 29211 | 102 | 0 |
260369 | 260369 | 2020-06-21 | Perry | Missouri | 29157 | 102 | 0 |
260373 | 260373 | 2020-06-21 | Platte | Missouri | 29165 | 102 | 4 |
257247 | 257247 | 2020-06-20 | Platte | Missouri | 29165 | 102 | 4 |
254126 | 254126 | 2020-06-19 | Platte | Missouri | 29165 | 102 | 4 |
238559 | 238559 | 2020-06-14 | Pemiscot | Missouri | 29155 | 102 | 6 |
235452 | 235452 | 2020-06-13 | Pemiscot | Missouri | 29155 | 102 | 6 |
216797 | 216797 | 2020-06-07 | Cass | Missouri | 29037 | 102 | 8 |
213709 | 213709 | 2020-06-06 | Cass | Missouri | 29037 | 102 | 8 |
207530 | 207530 | 2020-06-04 | Audrain | Missouri | 29007 | 102 | 2 |
137660 | 137660 | 2020-05-12 | Clay | Missouri | 29047 | 102 | 1 |
111011 | 111011 | 2020-05-03 | Boone | Missouri | 29019 | 102 | 1 |
108140 | 108140 | 2020-05-02 | Boone | Missouri | 29019 | 102 | 1 |
105275 | 105275 | 2020-05-01 | Boone | Missouri | 29019 | 102 | 1 |
79856 | 79856 | 2020-04-22 | Franklin | Missouri | 29071 | 102 | 5 |
77070 | 77070 | 2020-04-21 | Franklin | Missouri | 29071 | 102 | 5 |
20755 | 20755 | 2020-03-30 | St. Louis city | Missouri | 29510 | 102 | 1 |
18701 | 18701 | 2020-03-29 | Kansas City | Missouri | 102 | 0 |
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);