ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29101 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636431 | 636431 | 2020-10-16 | Johnson | Missouri | 29101 | 1344 | 10 |
633185 | 633185 | 2020-10-15 | Johnson | Missouri | 29101 | 1335 | 10 |
629940 | 629940 | 2020-10-14 | Johnson | Missouri | 29101 | 1331 | 12 |
626696 | 626696 | 2020-10-13 | Johnson | Missouri | 29101 | 1272 | 10 |
623454 | 623454 | 2020-10-12 | Johnson | Missouri | 29101 | 1272 | 10 |
620211 | 620211 | 2020-10-11 | Johnson | Missouri | 29101 | 1272 | 10 |
616969 | 616969 | 2020-10-10 | Johnson | Missouri | 29101 | 1272 | 10 |
613728 | 613728 | 2020-10-09 | Johnson | Missouri | 29101 | 1051 | 10 |
610486 | 610486 | 2020-10-08 | Johnson | Missouri | 29101 | 1044 | 5 |
607244 | 607244 | 2020-10-07 | Johnson | Missouri | 29101 | 1027 | 5 |
604001 | 604001 | 2020-10-06 | Johnson | Missouri | 29101 | 1018 | 5 |
600759 | 600759 | 2020-10-05 | Johnson | Missouri | 29101 | 1017 | 5 |
597516 | 597516 | 2020-10-04 | Johnson | Missouri | 29101 | 1017 | 5 |
594275 | 594275 | 2020-10-03 | Johnson | Missouri | 29101 | 1008 | 5 |
591034 | 591034 | 2020-10-02 | Johnson | Missouri | 29101 | 988 | 5 |
587793 | 587793 | 2020-10-01 | Johnson | Missouri | 29101 | 978 | 5 |
584553 | 584553 | 2020-09-30 | Johnson | Missouri | 29101 | 974 | 5 |
581312 | 581312 | 2020-09-29 | Johnson | Missouri | 29101 | 1111 | 4 |
578071 | 578071 | 2020-09-28 | Johnson | Missouri | 29101 | 1111 | 4 |
574830 | 574830 | 2020-09-27 | Johnson | Missouri | 29101 | 1117 | 4 |
571587 | 571587 | 2020-09-26 | Johnson | Missouri | 29101 | 1101 | 4 |
568345 | 568345 | 2020-09-25 | Johnson | Missouri | 29101 | 1081 | 4 |
565105 | 565105 | 2020-09-24 | Johnson | Missouri | 29101 | 1065 | 4 |
561865 | 561865 | 2020-09-23 | Johnson | Missouri | 29101 | 1046 | 4 |
558628 | 558628 | 2020-09-22 | Johnson | Missouri | 29101 | 1020 | 4 |
555391 | 555391 | 2020-09-21 | Johnson | Missouri | 29101 | 995 | 4 |
552153 | 552153 | 2020-09-20 | Johnson | Missouri | 29101 | 984 | 4 |
548914 | 548914 | 2020-09-19 | Johnson | Missouri | 29101 | 975 | 4 |
545676 | 545676 | 2020-09-18 | Johnson | Missouri | 29101 | 969 | 4 |
542439 | 542439 | 2020-09-17 | Johnson | Missouri | 29101 | 966 | 4 |
539203 | 539203 | 2020-09-16 | Johnson | Missouri | 29101 | 911 | 4 |
535966 | 535966 | 2020-09-15 | Johnson | Missouri | 29101 | 905 | 4 |
532731 | 532731 | 2020-09-14 | Johnson | Missouri | 29101 | 888 | 4 |
529495 | 529495 | 2020-09-13 | Johnson | Missouri | 29101 | 853 | 4 |
526259 | 526259 | 2020-09-12 | Johnson | Missouri | 29101 | 800 | 4 |
523023 | 523023 | 2020-09-11 | Johnson | Missouri | 29101 | 777 | 4 |
519786 | 519786 | 2020-09-10 | Johnson | Missouri | 29101 | 768 | 4 |
516551 | 516551 | 2020-09-09 | Johnson | Missouri | 29101 | 767 | 4 |
513317 | 513317 | 2020-09-08 | Johnson | Missouri | 29101 | 733 | 4 |
510085 | 510085 | 2020-09-07 | Johnson | Missouri | 29101 | 717 | 4 |
506852 | 506852 | 2020-09-06 | Johnson | Missouri | 29101 | 699 | 4 |
503619 | 503619 | 2020-09-05 | Johnson | Missouri | 29101 | 643 | 4 |
500385 | 500385 | 2020-09-04 | Johnson | Missouri | 29101 | 622 | 4 |
497151 | 497151 | 2020-09-03 | Johnson | Missouri | 29101 | 609 | 3 |
493918 | 493918 | 2020-09-02 | Johnson | Missouri | 29101 | 599 | 3 |
490684 | 490684 | 2020-09-01 | Johnson | Missouri | 29101 | 597 | 3 |
487451 | 487451 | 2020-08-31 | Johnson | Missouri | 29101 | 595 | 3 |
484217 | 484217 | 2020-08-30 | Johnson | Missouri | 29101 | 592 | 3 |
480982 | 480982 | 2020-08-29 | Johnson | Missouri | 29101 | 587 | 3 |
477750 | 477750 | 2020-08-28 | Johnson | Missouri | 29101 | 582 | 3 |
474517 | 474517 | 2020-08-27 | Johnson | Missouri | 29101 | 568 | 3 |
471285 | 471285 | 2020-08-26 | Johnson | Missouri | 29101 | 560 | 3 |
468055 | 468055 | 2020-08-25 | Johnson | Missouri | 29101 | 551 | 3 |
464826 | 464826 | 2020-08-24 | Johnson | Missouri | 29101 | 551 | 3 |
461595 | 461595 | 2020-08-23 | Johnson | Missouri | 29101 | 543 | 3 |
458368 | 458368 | 2020-08-22 | Johnson | Missouri | 29101 | 542 | 3 |
455140 | 455140 | 2020-08-21 | Johnson | Missouri | 29101 | 537 | 3 |
451912 | 451912 | 2020-08-20 | Johnson | Missouri | 29101 | 527 | 3 |
448684 | 448684 | 2020-08-19 | Johnson | Missouri | 29101 | 523 | 3 |
445458 | 445458 | 2020-08-18 | Johnson | Missouri | 29101 | 520 | 3 |
442232 | 442232 | 2020-08-17 | Johnson | Missouri | 29101 | 517 | 3 |
439005 | 439005 | 2020-08-16 | Johnson | Missouri | 29101 | 513 | 3 |
435780 | 435780 | 2020-08-15 | Johnson | Missouri | 29101 | 507 | 3 |
432554 | 432554 | 2020-08-14 | Johnson | Missouri | 29101 | 504 | 3 |
429327 | 429327 | 2020-08-13 | Johnson | Missouri | 29101 | 501 | 3 |
426103 | 426103 | 2020-08-12 | Johnson | Missouri | 29101 | 499 | 3 |
422881 | 422881 | 2020-08-11 | Johnson | Missouri | 29101 | 494 | 2 |
419659 | 419659 | 2020-08-10 | Johnson | Missouri | 29101 | 489 | 2 |
416438 | 416438 | 2020-08-09 | Johnson | Missouri | 29101 | 487 | 2 |
413218 | 413218 | 2020-08-08 | Johnson | Missouri | 29101 | 486 | 2 |
409998 | 409998 | 2020-08-07 | Johnson | Missouri | 29101 | 486 | 2 |
406778 | 406778 | 2020-08-06 | Johnson | Missouri | 29101 | 476 | 2 |
403560 | 403560 | 2020-08-05 | Johnson | Missouri | 29101 | 474 | 2 |
400343 | 400343 | 2020-08-04 | Johnson | Missouri | 29101 | 473 | 2 |
397129 | 397129 | 2020-08-03 | Johnson | Missouri | 29101 | 473 | 2 |
393913 | 393913 | 2020-08-02 | Johnson | Missouri | 29101 | 464 | 2 |
390696 | 390696 | 2020-08-01 | Johnson | Missouri | 29101 | 463 | 2 |
387479 | 387479 | 2020-07-31 | Johnson | Missouri | 29101 | 454 | 2 |
384261 | 384261 | 2020-07-30 | Johnson | Missouri | 29101 | 445 | 2 |
381045 | 381045 | 2020-07-29 | Johnson | Missouri | 29101 | 437 | 2 |
377828 | 377828 | 2020-07-28 | Johnson | Missouri | 29101 | 427 | 2 |
374613 | 374613 | 2020-07-27 | Johnson | Missouri | 29101 | 417 | 2 |
371401 | 371401 | 2020-07-26 | Johnson | Missouri | 29101 | 417 | 2 |
368190 | 368190 | 2020-07-25 | Johnson | Missouri | 29101 | 416 | 2 |
364982 | 364982 | 2020-07-24 | Johnson | Missouri | 29101 | 411 | 2 |
361775 | 361775 | 2020-07-23 | Johnson | Missouri | 29101 | 397 | 2 |
358570 | 358570 | 2020-07-22 | Johnson | Missouri | 29101 | 389 | 2 |
355367 | 355367 | 2020-07-21 | Johnson | Missouri | 29101 | 381 | 2 |
352165 | 352165 | 2020-07-20 | Johnson | Missouri | 29101 | 372 | 2 |
348965 | 348965 | 2020-07-19 | Johnson | Missouri | 29101 | 354 | 2 |
345764 | 345764 | 2020-07-18 | Johnson | Missouri | 29101 | 350 | 2 |
342564 | 342564 | 2020-07-17 | Johnson | Missouri | 29101 | 322 | 2 |
339368 | 339368 | 2020-07-16 | Johnson | Missouri | 29101 | 309 | 2 |
336172 | 336172 | 2020-07-15 | Johnson | Missouri | 29101 | 309 | 2 |
332979 | 332979 | 2020-07-14 | Johnson | Missouri | 29101 | 309 | 2 |
329792 | 329792 | 2020-07-13 | Johnson | Missouri | 29101 | 309 | 2 |
326606 | 326606 | 2020-07-12 | Johnson | Missouri | 29101 | 246 | 2 |
323423 | 323423 | 2020-07-11 | Johnson | Missouri | 29101 | 238 | 2 |
320244 | 320244 | 2020-07-10 | Johnson | Missouri | 29101 | 238 | 1 |
317069 | 317069 | 2020-07-09 | Johnson | Missouri | 29101 | 215 | 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);