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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
291808 | 291808 | 2020-07-01 | Taney | Missouri | 29213 | 63 | 2 |
294962 | 294962 | 2020-07-02 | Taney | Missouri | 29213 | 67 | 2 |
298120 | 298120 | 2020-07-03 | Taney | Missouri | 29213 | 74 | 2 |
301283 | 301283 | 2020-07-04 | Taney | Missouri | 29213 | 83 | 2 |
304447 | 304447 | 2020-07-05 | Taney | Missouri | 29213 | 84 | 2 |
307614 | 307614 | 2020-07-06 | Taney | Missouri | 29213 | 96 | 2 |
310782 | 310782 | 2020-07-07 | Taney | Missouri | 29213 | 105 | 2 |
313953 | 313953 | 2020-07-08 | Taney | Missouri | 29213 | 112 | 2 |
317127 | 317127 | 2020-07-09 | Taney | Missouri | 29213 | 119 | 2 |
320302 | 320302 | 2020-07-10 | Taney | Missouri | 29213 | 122 | 2 |
323481 | 323481 | 2020-07-11 | Taney | Missouri | 29213 | 123 | 3 |
326664 | 326664 | 2020-07-12 | Taney | Missouri | 29213 | 123 | 3 |
329850 | 329850 | 2020-07-13 | Taney | Missouri | 29213 | 126 | 3 |
333037 | 333037 | 2020-07-14 | Taney | Missouri | 29213 | 135 | 3 |
336230 | 336230 | 2020-07-15 | Taney | Missouri | 29213 | 142 | 3 |
339426 | 339426 | 2020-07-16 | Taney | Missouri | 29213 | 147 | 3 |
342622 | 342622 | 2020-07-17 | Taney | Missouri | 29213 | 155 | 3 |
345822 | 345822 | 2020-07-18 | Taney | Missouri | 29213 | 166 | 3 |
349023 | 349023 | 2020-07-19 | Taney | Missouri | 29213 | 174 | 3 |
352223 | 352223 | 2020-07-20 | Taney | Missouri | 29213 | 178 | 3 |
355425 | 355425 | 2020-07-21 | Taney | Missouri | 29213 | 184 | 3 |
358628 | 358628 | 2020-07-22 | Taney | Missouri | 29213 | 205 | 3 |
361833 | 361833 | 2020-07-23 | Taney | Missouri | 29213 | 212 | 3 |
365040 | 365040 | 2020-07-24 | Taney | Missouri | 29213 | 226 | 3 |
368248 | 368248 | 2020-07-25 | Taney | Missouri | 29213 | 237 | 3 |
371459 | 371459 | 2020-07-26 | Taney | Missouri | 29213 | 249 | 3 |
374671 | 374671 | 2020-07-27 | Taney | Missouri | 29213 | 267 | 3 |
377886 | 377886 | 2020-07-28 | Taney | Missouri | 29213 | 284 | 3 |
381103 | 381103 | 2020-07-29 | Taney | Missouri | 29213 | 304 | 3 |
384319 | 384319 | 2020-07-30 | Taney | Missouri | 29213 | 374 | 3 |
387537 | 387537 | 2020-07-31 | Taney | Missouri | 29213 | 391 | 3 |
390754 | 390754 | 2020-08-01 | Taney | Missouri | 29213 | 403 | 3 |
393971 | 393971 | 2020-08-02 | Taney | Missouri | 29213 | 428 | 3 |
397187 | 397187 | 2020-08-03 | Taney | Missouri | 29213 | 456 | 3 |
400401 | 400401 | 2020-08-04 | Taney | Missouri | 29213 | 480 | 3 |
403618 | 403618 | 2020-08-05 | Taney | Missouri | 29213 | 507 | 3 |
406836 | 406836 | 2020-08-06 | Taney | Missouri | 29213 | 521 | 3 |
410056 | 410056 | 2020-08-07 | Taney | Missouri | 29213 | 548 | 3 |
413276 | 413276 | 2020-08-08 | Taney | Missouri | 29213 | 548 | 3 |
416496 | 416496 | 2020-08-09 | Taney | Missouri | 29213 | 589 | 3 |
419717 | 419717 | 2020-08-10 | Taney | Missouri | 29213 | 616 | 3 |
422939 | 422939 | 2020-08-11 | Taney | Missouri | 29213 | 632 | 3 |
426161 | 426161 | 2020-08-12 | Taney | Missouri | 29213 | 658 | 3 |
429385 | 429385 | 2020-08-13 | Taney | Missouri | 29213 | 678 | 3 |
432612 | 432612 | 2020-08-14 | Taney | Missouri | 29213 | 685 | 3 |
435838 | 435838 | 2020-08-15 | Taney | Missouri | 29213 | 708 | 3 |
439063 | 439063 | 2020-08-16 | Taney | Missouri | 29213 | 739 | 3 |
442290 | 442290 | 2020-08-17 | Taney | Missouri | 29213 | 763 | 3 |
445516 | 445516 | 2020-08-18 | Taney | Missouri | 29213 | 778 | 3 |
448742 | 448742 | 2020-08-19 | Taney | Missouri | 29213 | 800 | 3 |
451970 | 451970 | 2020-08-20 | Taney | Missouri | 29213 | 816 | 3 |
455198 | 455198 | 2020-08-21 | Taney | Missouri | 29213 | 832 | 3 |
458426 | 458426 | 2020-08-22 | Taney | Missouri | 29213 | 846 | 3 |
461653 | 461653 | 2020-08-23 | Taney | Missouri | 29213 | 855 | 3 |
464884 | 464884 | 2020-08-24 | Taney | Missouri | 29213 | 864 | 3 |
468113 | 468113 | 2020-08-25 | Taney | Missouri | 29213 | 868 | 3 |
471343 | 471343 | 2020-08-26 | Taney | Missouri | 29213 | 879 | 3 |
474575 | 474575 | 2020-08-27 | Taney | Missouri | 29213 | 886 | 3 |
477808 | 477808 | 2020-08-28 | Taney | Missouri | 29213 | 893 | 11 |
481040 | 481040 | 2020-08-29 | Taney | Missouri | 29213 | 900 | 14 |
484275 | 484275 | 2020-08-30 | Taney | Missouri | 29213 | 906 | 14 |
487509 | 487509 | 2020-08-31 | Taney | Missouri | 29213 | 913 | 14 |
490742 | 490742 | 2020-09-01 | Taney | Missouri | 29213 | 914 | 14 |
493976 | 493976 | 2020-09-02 | Taney | Missouri | 29213 | 929 | 14 |
497209 | 497209 | 2020-09-03 | Taney | Missouri | 29213 | 933 | 14 |
500443 | 500443 | 2020-09-04 | Taney | Missouri | 29213 | 939 | 15 |
503677 | 503677 | 2020-09-05 | Taney | Missouri | 29213 | 953 | 19 |
506910 | 506910 | 2020-09-06 | Taney | Missouri | 29213 | 960 | 22 |
510143 | 510143 | 2020-09-07 | Taney | Missouri | 29213 | 964 | 22 |
513375 | 513375 | 2020-09-08 | Taney | Missouri | 29213 | 976 | 22 |
516609 | 516609 | 2020-09-09 | Taney | Missouri | 29213 | 993 | 22 |
519844 | 519844 | 2020-09-10 | Taney | Missouri | 29213 | 1008 | 22 |
523081 | 523081 | 2020-09-11 | Taney | Missouri | 29213 | 1021 | 22 |
526317 | 526317 | 2020-09-12 | Taney | Missouri | 29213 | 1034 | 22 |
529553 | 529553 | 2020-09-13 | Taney | Missouri | 29213 | 1050 | 22 |
532789 | 532789 | 2020-09-14 | Taney | Missouri | 29213 | 1053 | 22 |
536024 | 536024 | 2020-09-15 | Taney | Missouri | 29213 | 1061 | 22 |
539261 | 539261 | 2020-09-16 | Taney | Missouri | 29213 | 1075 | 22 |
542497 | 542497 | 2020-09-17 | Taney | Missouri | 29213 | 1091 | 22 |
545734 | 545734 | 2020-09-18 | Taney | Missouri | 29213 | 1102 | 24 |
548972 | 548972 | 2020-09-19 | Taney | Missouri | 29213 | 1116 | 28 |
552211 | 552211 | 2020-09-20 | Taney | Missouri | 29213 | 1127 | 28 |
555449 | 555449 | 2020-09-21 | Taney | Missouri | 29213 | 1135 | 28 |
558686 | 558686 | 2020-09-22 | Taney | Missouri | 29213 | 1142 | 28 |
561923 | 561923 | 2020-09-23 | Taney | Missouri | 29213 | 1157 | 31 |
565163 | 565163 | 2020-09-24 | Taney | Missouri | 29213 | 1172 | 31 |
568403 | 568403 | 2020-09-25 | Taney | Missouri | 29213 | 1184 | 31 |
571645 | 571645 | 2020-09-26 | Taney | Missouri | 29213 | 1193 | 31 |
574888 | 574888 | 2020-09-27 | Taney | Missouri | 29213 | 1213 | 31 |
578129 | 578129 | 2020-09-28 | Taney | Missouri | 29213 | 1219 | 31 |
581370 | 581370 | 2020-09-29 | Taney | Missouri | 29213 | 1219 | 31 |
584611 | 584611 | 2020-09-30 | Taney | Missouri | 29213 | 1317 | 36 |
587851 | 587851 | 2020-10-01 | Taney | Missouri | 29213 | 1339 | 36 |
591092 | 591092 | 2020-10-02 | Taney | Missouri | 29213 | 1354 | 36 |
594333 | 594333 | 2020-10-03 | Taney | Missouri | 29213 | 1376 | 36 |
597574 | 597574 | 2020-10-04 | Taney | Missouri | 29213 | 1387 | 36 |
600817 | 600817 | 2020-10-05 | Taney | Missouri | 29213 | 1405 | 36 |
604059 | 604059 | 2020-10-06 | Taney | Missouri | 29213 | 1414 | 36 |
607302 | 607302 | 2020-10-07 | Taney | Missouri | 29213 | 1422 | 37 |
610544 | 610544 | 2020-10-08 | Taney | Missouri | 29213 | 1439 | 37 |
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);