ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Monroe" and state = "Missouri" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
183042 | 183042 | 2020-05-27 | Monroe | Missouri | 29137 | 2 | 0 |
186098 | 186098 | 2020-05-28 | Monroe | Missouri | 29137 | 2 | 0 |
189156 | 189156 | 2020-05-29 | Monroe | Missouri | 29137 | 2 | 0 |
192220 | 192220 | 2020-05-30 | Monroe | Missouri | 29137 | 2 | 0 |
195290 | 195290 | 2020-05-31 | Monroe | Missouri | 29137 | 2 | 0 |
198361 | 198361 | 2020-06-01 | Monroe | Missouri | 29137 | 2 | 0 |
201434 | 201434 | 2020-06-02 | Monroe | Missouri | 29137 | 2 | 0 |
204511 | 204511 | 2020-06-03 | Monroe | Missouri | 29137 | 2 | 0 |
207592 | 207592 | 2020-06-04 | Monroe | Missouri | 29137 | 2 | 0 |
210673 | 210673 | 2020-06-05 | Monroe | Missouri | 29137 | 2 | 0 |
213757 | 213757 | 2020-06-06 | Monroe | Missouri | 29137 | 3 | 0 |
216845 | 216845 | 2020-06-07 | Monroe | Missouri | 29137 | 3 | 0 |
219937 | 219937 | 2020-06-08 | Monroe | Missouri | 29137 | 3 | 0 |
223032 | 223032 | 2020-06-09 | Monroe | Missouri | 29137 | 3 | 0 |
226131 | 226131 | 2020-06-10 | Monroe | Missouri | 29137 | 3 | 0 |
229234 | 229234 | 2020-06-11 | Monroe | Missouri | 29137 | 3 | 0 |
232338 | 232338 | 2020-06-12 | Monroe | Missouri | 29137 | 3 | 0 |
235444 | 235444 | 2020-06-13 | Monroe | Missouri | 29137 | 3 | 0 |
238551 | 238551 | 2020-06-14 | Monroe | Missouri | 29137 | 3 | 0 |
241661 | 241661 | 2020-06-15 | Monroe | Missouri | 29137 | 3 | 0 |
244772 | 244772 | 2020-06-16 | Monroe | Missouri | 29137 | 3 | 0 |
247885 | 247885 | 2020-06-17 | Monroe | Missouri | 29137 | 3 | 0 |
250998 | 250998 | 2020-06-18 | Monroe | Missouri | 29137 | 3 | 0 |
254113 | 254113 | 2020-06-19 | Monroe | Missouri | 29137 | 4 | 0 |
257233 | 257233 | 2020-06-20 | Monroe | Missouri | 29137 | 5 | 0 |
260359 | 260359 | 2020-06-21 | Monroe | Missouri | 29137 | 5 | 0 |
263487 | 263487 | 2020-06-22 | Monroe | Missouri | 29137 | 5 | 0 |
266613 | 266613 | 2020-06-23 | Monroe | Missouri | 29137 | 5 | 0 |
269746 | 269746 | 2020-06-24 | Monroe | Missouri | 29137 | 5 | 0 |
272885 | 272885 | 2020-06-25 | Monroe | Missouri | 29137 | 5 | 0 |
276028 | 276028 | 2020-06-26 | Monroe | Missouri | 29137 | 5 | 0 |
279176 | 279176 | 2020-06-27 | Monroe | Missouri | 29137 | 5 | 0 |
282324 | 282324 | 2020-06-28 | Monroe | Missouri | 29137 | 5 | 0 |
285469 | 285469 | 2020-06-29 | Monroe | Missouri | 29137 | 5 | 0 |
288619 | 288619 | 2020-06-30 | Monroe | Missouri | 29137 | 5 | 0 |
291770 | 291770 | 2020-07-01 | Monroe | Missouri | 29137 | 5 | 0 |
294924 | 294924 | 2020-07-02 | Monroe | Missouri | 29137 | 5 | 0 |
298082 | 298082 | 2020-07-03 | Monroe | Missouri | 29137 | 5 | 0 |
301245 | 301245 | 2020-07-04 | Monroe | Missouri | 29137 | 5 | 0 |
304409 | 304409 | 2020-07-05 | Monroe | Missouri | 29137 | 5 | 0 |
307576 | 307576 | 2020-07-06 | Monroe | Missouri | 29137 | 5 | 0 |
310744 | 310744 | 2020-07-07 | Monroe | Missouri | 29137 | 5 | 0 |
313915 | 313915 | 2020-07-08 | Monroe | Missouri | 29137 | 5 | 0 |
317089 | 317089 | 2020-07-09 | Monroe | Missouri | 29137 | 5 | 0 |
320264 | 320264 | 2020-07-10 | Monroe | Missouri | 29137 | 5 | 0 |
323443 | 323443 | 2020-07-11 | Monroe | Missouri | 29137 | 5 | 0 |
326626 | 326626 | 2020-07-12 | Monroe | Missouri | 29137 | 5 | 0 |
329812 | 329812 | 2020-07-13 | Monroe | Missouri | 29137 | 5 | 0 |
332999 | 332999 | 2020-07-14 | Monroe | Missouri | 29137 | 6 | 0 |
336192 | 336192 | 2020-07-15 | Monroe | Missouri | 29137 | 7 | 0 |
339388 | 339388 | 2020-07-16 | Monroe | Missouri | 29137 | 6 | 0 |
342584 | 342584 | 2020-07-17 | Monroe | Missouri | 29137 | 6 | 0 |
345784 | 345784 | 2020-07-18 | Monroe | Missouri | 29137 | 6 | 0 |
348985 | 348985 | 2020-07-19 | Monroe | Missouri | 29137 | 7 | 0 |
352185 | 352185 | 2020-07-20 | Monroe | Missouri | 29137 | 7 | 0 |
355387 | 355387 | 2020-07-21 | Monroe | Missouri | 29137 | 8 | 0 |
358590 | 358590 | 2020-07-22 | Monroe | Missouri | 29137 | 8 | 0 |
361795 | 361795 | 2020-07-23 | Monroe | Missouri | 29137 | 9 | 0 |
365002 | 365002 | 2020-07-24 | Monroe | Missouri | 29137 | 9 | 0 |
368210 | 368210 | 2020-07-25 | Monroe | Missouri | 29137 | 9 | 0 |
371421 | 371421 | 2020-07-26 | Monroe | Missouri | 29137 | 9 | 0 |
374633 | 374633 | 2020-07-27 | Monroe | Missouri | 29137 | 9 | 0 |
377848 | 377848 | 2020-07-28 | Monroe | Missouri | 29137 | 11 | 0 |
381065 | 381065 | 2020-07-29 | Monroe | Missouri | 29137 | 12 | 0 |
384281 | 384281 | 2020-07-30 | Monroe | Missouri | 29137 | 13 | 0 |
387499 | 387499 | 2020-07-31 | Monroe | Missouri | 29137 | 14 | 0 |
390716 | 390716 | 2020-08-01 | Monroe | Missouri | 29137 | 17 | 0 |
393933 | 393933 | 2020-08-02 | Monroe | Missouri | 29137 | 17 | 0 |
397149 | 397149 | 2020-08-03 | Monroe | Missouri | 29137 | 21 | 0 |
400363 | 400363 | 2020-08-04 | Monroe | Missouri | 29137 | 22 | 0 |
403580 | 403580 | 2020-08-05 | Monroe | Missouri | 29137 | 24 | 0 |
406798 | 406798 | 2020-08-06 | Monroe | Missouri | 29137 | 26 | 0 |
410018 | 410018 | 2020-08-07 | Monroe | Missouri | 29137 | 27 | 0 |
413238 | 413238 | 2020-08-08 | Monroe | Missouri | 29137 | 27 | 0 |
416458 | 416458 | 2020-08-09 | Monroe | Missouri | 29137 | 29 | 0 |
419679 | 419679 | 2020-08-10 | Monroe | Missouri | 29137 | 31 | 0 |
422901 | 422901 | 2020-08-11 | Monroe | Missouri | 29137 | 31 | 0 |
426123 | 426123 | 2020-08-12 | Monroe | Missouri | 29137 | 33 | 0 |
429347 | 429347 | 2020-08-13 | Monroe | Missouri | 29137 | 33 | 0 |
432574 | 432574 | 2020-08-14 | Monroe | Missouri | 29137 | 34 | 0 |
435800 | 435800 | 2020-08-15 | Monroe | Missouri | 29137 | 36 | 0 |
439025 | 439025 | 2020-08-16 | Monroe | Missouri | 29137 | 37 | 0 |
442252 | 442252 | 2020-08-17 | Monroe | Missouri | 29137 | 37 | 0 |
445478 | 445478 | 2020-08-18 | Monroe | Missouri | 29137 | 37 | 0 |
448704 | 448704 | 2020-08-19 | Monroe | Missouri | 29137 | 38 | 0 |
451932 | 451932 | 2020-08-20 | Monroe | Missouri | 29137 | 40 | 0 |
455160 | 455160 | 2020-08-21 | Monroe | Missouri | 29137 | 45 | 0 |
458388 | 458388 | 2020-08-22 | Monroe | Missouri | 29137 | 51 | 0 |
461615 | 461615 | 2020-08-23 | Monroe | Missouri | 29137 | 53 | 0 |
464846 | 464846 | 2020-08-24 | Monroe | Missouri | 29137 | 55 | 0 |
468075 | 468075 | 2020-08-25 | Monroe | Missouri | 29137 | 56 | 0 |
471305 | 471305 | 2020-08-26 | Monroe | Missouri | 29137 | 62 | 0 |
474537 | 474537 | 2020-08-27 | Monroe | Missouri | 29137 | 65 | 0 |
477770 | 477770 | 2020-08-28 | Monroe | Missouri | 29137 | 66 | 0 |
481002 | 481002 | 2020-08-29 | Monroe | Missouri | 29137 | 68 | 0 |
484237 | 484237 | 2020-08-30 | Monroe | Missouri | 29137 | 68 | 0 |
487471 | 487471 | 2020-08-31 | Monroe | Missouri | 29137 | 69 | 0 |
490704 | 490704 | 2020-09-01 | Monroe | Missouri | 29137 | 70 | 0 |
493938 | 493938 | 2020-09-02 | Monroe | Missouri | 29137 | 72 | 0 |
497171 | 497171 | 2020-09-03 | Monroe | Missouri | 29137 | 72 | 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);