ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29213 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536024 | 536024 | 2020-09-15 | Taney | Missouri | 29213 | 1061 | 22 |
532789 | 532789 | 2020-09-14 | Taney | Missouri | 29213 | 1053 | 22 |
529553 | 529553 | 2020-09-13 | Taney | Missouri | 29213 | 1050 | 22 |
526317 | 526317 | 2020-09-12 | Taney | Missouri | 29213 | 1034 | 22 |
523081 | 523081 | 2020-09-11 | Taney | Missouri | 29213 | 1021 | 22 |
519844 | 519844 | 2020-09-10 | Taney | Missouri | 29213 | 1008 | 22 |
516609 | 516609 | 2020-09-09 | Taney | Missouri | 29213 | 993 | 22 |
513375 | 513375 | 2020-09-08 | Taney | Missouri | 29213 | 976 | 22 |
510143 | 510143 | 2020-09-07 | Taney | Missouri | 29213 | 964 | 22 |
506910 | 506910 | 2020-09-06 | Taney | Missouri | 29213 | 960 | 22 |
503677 | 503677 | 2020-09-05 | Taney | Missouri | 29213 | 953 | 19 |
500443 | 500443 | 2020-09-04 | Taney | Missouri | 29213 | 939 | 15 |
497209 | 497209 | 2020-09-03 | Taney | Missouri | 29213 | 933 | 14 |
493976 | 493976 | 2020-09-02 | Taney | Missouri | 29213 | 929 | 14 |
490742 | 490742 | 2020-09-01 | Taney | Missouri | 29213 | 914 | 14 |
487509 | 487509 | 2020-08-31 | Taney | Missouri | 29213 | 913 | 14 |
484275 | 484275 | 2020-08-30 | Taney | Missouri | 29213 | 906 | 14 |
481040 | 481040 | 2020-08-29 | Taney | Missouri | 29213 | 900 | 14 |
477808 | 477808 | 2020-08-28 | Taney | Missouri | 29213 | 893 | 11 |
474575 | 474575 | 2020-08-27 | Taney | Missouri | 29213 | 886 | 3 |
471343 | 471343 | 2020-08-26 | Taney | Missouri | 29213 | 879 | 3 |
468113 | 468113 | 2020-08-25 | Taney | Missouri | 29213 | 868 | 3 |
464884 | 464884 | 2020-08-24 | Taney | Missouri | 29213 | 864 | 3 |
461653 | 461653 | 2020-08-23 | Taney | Missouri | 29213 | 855 | 3 |
458426 | 458426 | 2020-08-22 | Taney | Missouri | 29213 | 846 | 3 |
455198 | 455198 | 2020-08-21 | Taney | Missouri | 29213 | 832 | 3 |
451970 | 451970 | 2020-08-20 | Taney | Missouri | 29213 | 816 | 3 |
448742 | 448742 | 2020-08-19 | Taney | Missouri | 29213 | 800 | 3 |
445516 | 445516 | 2020-08-18 | Taney | Missouri | 29213 | 778 | 3 |
442290 | 442290 | 2020-08-17 | Taney | Missouri | 29213 | 763 | 3 |
439063 | 439063 | 2020-08-16 | Taney | Missouri | 29213 | 739 | 3 |
435838 | 435838 | 2020-08-15 | Taney | Missouri | 29213 | 708 | 3 |
432612 | 432612 | 2020-08-14 | Taney | Missouri | 29213 | 685 | 3 |
429385 | 429385 | 2020-08-13 | Taney | Missouri | 29213 | 678 | 3 |
426161 | 426161 | 2020-08-12 | Taney | Missouri | 29213 | 658 | 3 |
422939 | 422939 | 2020-08-11 | Taney | Missouri | 29213 | 632 | 3 |
419717 | 419717 | 2020-08-10 | Taney | Missouri | 29213 | 616 | 3 |
416496 | 416496 | 2020-08-09 | Taney | Missouri | 29213 | 589 | 3 |
413276 | 413276 | 2020-08-08 | Taney | Missouri | 29213 | 548 | 3 |
410056 | 410056 | 2020-08-07 | Taney | Missouri | 29213 | 548 | 3 |
406836 | 406836 | 2020-08-06 | Taney | Missouri | 29213 | 521 | 3 |
403618 | 403618 | 2020-08-05 | Taney | Missouri | 29213 | 507 | 3 |
400401 | 400401 | 2020-08-04 | Taney | Missouri | 29213 | 480 | 3 |
397187 | 397187 | 2020-08-03 | Taney | Missouri | 29213 | 456 | 3 |
393971 | 393971 | 2020-08-02 | Taney | Missouri | 29213 | 428 | 3 |
390754 | 390754 | 2020-08-01 | Taney | Missouri | 29213 | 403 | 3 |
387537 | 387537 | 2020-07-31 | Taney | Missouri | 29213 | 391 | 3 |
384319 | 384319 | 2020-07-30 | Taney | Missouri | 29213 | 374 | 3 |
381103 | 381103 | 2020-07-29 | Taney | Missouri | 29213 | 304 | 3 |
377886 | 377886 | 2020-07-28 | Taney | Missouri | 29213 | 284 | 3 |
374671 | 374671 | 2020-07-27 | Taney | Missouri | 29213 | 267 | 3 |
371459 | 371459 | 2020-07-26 | Taney | Missouri | 29213 | 249 | 3 |
368248 | 368248 | 2020-07-25 | Taney | Missouri | 29213 | 237 | 3 |
365040 | 365040 | 2020-07-24 | Taney | Missouri | 29213 | 226 | 3 |
361833 | 361833 | 2020-07-23 | Taney | Missouri | 29213 | 212 | 3 |
358628 | 358628 | 2020-07-22 | Taney | Missouri | 29213 | 205 | 3 |
355425 | 355425 | 2020-07-21 | Taney | Missouri | 29213 | 184 | 3 |
352223 | 352223 | 2020-07-20 | Taney | Missouri | 29213 | 178 | 3 |
349023 | 349023 | 2020-07-19 | Taney | Missouri | 29213 | 174 | 3 |
345822 | 345822 | 2020-07-18 | Taney | Missouri | 29213 | 166 | 3 |
342622 | 342622 | 2020-07-17 | Taney | Missouri | 29213 | 155 | 3 |
339426 | 339426 | 2020-07-16 | Taney | Missouri | 29213 | 147 | 3 |
336230 | 336230 | 2020-07-15 | Taney | Missouri | 29213 | 142 | 3 |
333037 | 333037 | 2020-07-14 | Taney | Missouri | 29213 | 135 | 3 |
329850 | 329850 | 2020-07-13 | Taney | Missouri | 29213 | 126 | 3 |
326664 | 326664 | 2020-07-12 | Taney | Missouri | 29213 | 123 | 3 |
323481 | 323481 | 2020-07-11 | Taney | Missouri | 29213 | 123 | 3 |
320302 | 320302 | 2020-07-10 | Taney | Missouri | 29213 | 122 | 2 |
317127 | 317127 | 2020-07-09 | Taney | Missouri | 29213 | 119 | 2 |
313953 | 313953 | 2020-07-08 | Taney | Missouri | 29213 | 112 | 2 |
310782 | 310782 | 2020-07-07 | Taney | Missouri | 29213 | 105 | 2 |
307614 | 307614 | 2020-07-06 | Taney | Missouri | 29213 | 96 | 2 |
304447 | 304447 | 2020-07-05 | Taney | Missouri | 29213 | 84 | 2 |
301283 | 301283 | 2020-07-04 | Taney | Missouri | 29213 | 83 | 2 |
298120 | 298120 | 2020-07-03 | Taney | Missouri | 29213 | 74 | 2 |
294962 | 294962 | 2020-07-02 | Taney | Missouri | 29213 | 67 | 2 |
291808 | 291808 | 2020-07-01 | Taney | Missouri | 29213 | 63 | 2 |
288657 | 288657 | 2020-06-30 | Taney | Missouri | 29213 | 60 | 2 |
285507 | 285507 | 2020-06-29 | Taney | Missouri | 29213 | 60 | 2 |
282362 | 282362 | 2020-06-28 | Taney | Missouri | 29213 | 56 | 2 |
279214 | 279214 | 2020-06-27 | Taney | Missouri | 29213 | 48 | 2 |
276066 | 276066 | 2020-06-26 | Taney | Missouri | 29213 | 40 | 2 |
272923 | 272923 | 2020-06-25 | Taney | Missouri | 29213 | 39 | 2 |
269784 | 269784 | 2020-06-24 | Taney | Missouri | 29213 | 35 | 2 |
266651 | 266651 | 2020-06-23 | Taney | Missouri | 29213 | 34 | 2 |
263525 | 263525 | 2020-06-22 | Taney | Missouri | 29213 | 32 | 2 |
260397 | 260397 | 2020-06-21 | Taney | Missouri | 29213 | 30 | 2 |
257271 | 257271 | 2020-06-20 | Taney | Missouri | 29213 | 30 | 2 |
254150 | 254150 | 2020-06-19 | Taney | Missouri | 29213 | 30 | 2 |
251035 | 251035 | 2020-06-18 | Taney | Missouri | 29213 | 29 | 2 |
247922 | 247922 | 2020-06-17 | Taney | Missouri | 29213 | 27 | 2 |
244809 | 244809 | 2020-06-16 | Taney | Missouri | 29213 | 26 | 2 |
241698 | 241698 | 2020-06-15 | Taney | Missouri | 29213 | 24 | 2 |
238588 | 238588 | 2020-06-14 | Taney | Missouri | 29213 | 15 | 2 |
235481 | 235481 | 2020-06-13 | Taney | Missouri | 29213 | 15 | 2 |
232375 | 232375 | 2020-06-12 | Taney | Missouri | 29213 | 15 | 2 |
229271 | 229271 | 2020-06-11 | Taney | Missouri | 29213 | 15 | 2 |
226168 | 226168 | 2020-06-10 | Taney | Missouri | 29213 | 13 | 2 |
223069 | 223069 | 2020-06-09 | Taney | Missouri | 29213 | 13 | 2 |
219974 | 219974 | 2020-06-08 | Taney | Missouri | 29213 | 13 | 2 |
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);