ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Crawford" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921961 | 921961 | 2021-01-12 | Crawford | Missouri | 29055 | 1865 | 21 |
918716 | 918716 | 2021-01-11 | Crawford | Missouri | 29055 | 1862 | 20 |
915471 | 915471 | 2021-01-10 | Crawford | Missouri | 29055 | 1855 | 20 |
912226 | 912226 | 2021-01-09 | Crawford | Missouri | 29055 | 1841 | 20 |
908981 | 908981 | 2021-01-08 | Crawford | Missouri | 29055 | 1823 | 20 |
905735 | 905735 | 2021-01-07 | Crawford | Missouri | 29055 | 1796 | 20 |
902490 | 902490 | 2021-01-06 | Crawford | Missouri | 29055 | 1782 | 20 |
899245 | 899245 | 2021-01-05 | Crawford | Missouri | 29055 | 1776 | 20 |
896000 | 896000 | 2021-01-04 | Crawford | Missouri | 29055 | 1765 | 19 |
892753 | 892753 | 2021-01-03 | Crawford | Missouri | 29055 | 1765 | 19 |
889507 | 889507 | 2021-01-02 | Crawford | Missouri | 29055 | 1741 | 19 |
886261 | 886261 | 2021-01-01 | Crawford | Missouri | 29055 | 1731 | 19 |
883016 | 883016 | 2020-12-31 | Crawford | Missouri | 29055 | 1706 | 19 |
879771 | 879771 | 2020-12-30 | Crawford | Missouri | 29055 | 1680 | 19 |
876526 | 876526 | 2020-12-29 | Crawford | Missouri | 29055 | 1666 | 19 |
873281 | 873281 | 2020-12-28 | Crawford | Missouri | 29055 | 1648 | 19 |
870036 | 870036 | 2020-12-27 | Crawford | Missouri | 29055 | 1637 | 19 |
866791 | 866791 | 2020-12-26 | Crawford | Missouri | 29055 | 1629 | 19 |
863546 | 863546 | 2020-12-25 | Crawford | Missouri | 29055 | 1608 | 19 |
860301 | 860301 | 2020-12-24 | Crawford | Missouri | 29055 | 1588 | 19 |
857056 | 857056 | 2020-12-23 | Crawford | Missouri | 29055 | 1561 | 19 |
853811 | 853811 | 2020-12-22 | Crawford | Missouri | 29055 | 1541 | 18 |
850566 | 850566 | 2020-12-21 | Crawford | Missouri | 29055 | 1532 | 15 |
847321 | 847321 | 2020-12-20 | Crawford | Missouri | 29055 | 1494 | 15 |
844075 | 844075 | 2020-12-19 | Crawford | Missouri | 29055 | 1478 | 15 |
840830 | 840830 | 2020-12-18 | Crawford | Missouri | 29055 | 1470 | 15 |
837585 | 837585 | 2020-12-17 | Crawford | Missouri | 29055 | 1459 | 15 |
834339 | 834339 | 2020-12-16 | Crawford | Missouri | 29055 | 1433 | 15 |
831092 | 831092 | 2020-12-15 | Crawford | Missouri | 29055 | 1424 | 15 |
827846 | 827846 | 2020-12-14 | Crawford | Missouri | 29055 | 1411 | 14 |
824599 | 824599 | 2020-12-13 | Crawford | Missouri | 29055 | 1399 | 14 |
821353 | 821353 | 2020-12-12 | Crawford | Missouri | 29055 | 1387 | 14 |
818107 | 818107 | 2020-12-11 | Crawford | Missouri | 29055 | 1348 | 14 |
814861 | 814861 | 2020-12-10 | Crawford | Missouri | 29055 | 1348 | 14 |
811616 | 811616 | 2020-12-09 | Crawford | Missouri | 29055 | 1330 | 14 |
808371 | 808371 | 2020-12-08 | Crawford | Missouri | 29055 | 1317 | 14 |
805126 | 805126 | 2020-12-07 | Crawford | Missouri | 29055 | 1312 | 14 |
801881 | 801881 | 2020-12-06 | Crawford | Missouri | 29055 | 1294 | 14 |
798636 | 798636 | 2020-12-05 | Crawford | Missouri | 29055 | 1277 | 14 |
795391 | 795391 | 2020-12-04 | Crawford | Missouri | 29055 | 1262 | 14 |
792146 | 792146 | 2020-12-03 | Crawford | Missouri | 29055 | 1239 | 14 |
788901 | 788901 | 2020-12-02 | Crawford | Missouri | 29055 | 1228 | 14 |
785656 | 785656 | 2020-12-01 | Crawford | Missouri | 29055 | 1217 | 14 |
782412 | 782412 | 2020-11-30 | Crawford | Missouri | 29055 | 1205 | 12 |
779166 | 779166 | 2020-11-29 | Crawford | Missouri | 29055 | 1191 | 12 |
775921 | 775921 | 2020-11-28 | Crawford | Missouri | 29055 | 1174 | 12 |
772676 | 772676 | 2020-11-27 | Crawford | Missouri | 29055 | 1171 | 12 |
769431 | 769431 | 2020-11-26 | Crawford | Missouri | 29055 | 1154 | 12 |
766185 | 766185 | 2020-11-25 | Crawford | Missouri | 29055 | 1136 | 12 |
762940 | 762940 | 2020-11-24 | Crawford | Missouri | 29055 | 1117 | 12 |
759695 | 759695 | 2020-11-23 | Crawford | Missouri | 29055 | 1112 | 11 |
756448 | 756448 | 2020-11-22 | Crawford | Missouri | 29055 | 1097 | 11 |
753202 | 753202 | 2020-11-21 | Crawford | Missouri | 29055 | 1077 | 11 |
749956 | 749956 | 2020-11-20 | Crawford | Missouri | 29055 | 1056 | 11 |
746710 | 746710 | 2020-11-19 | Crawford | Missouri | 29055 | 1029 | 10 |
743463 | 743463 | 2020-11-18 | Crawford | Missouri | 29055 | 1015 | 10 |
740216 | 740216 | 2020-11-17 | Crawford | Missouri | 29055 | 1005 | 10 |
736972 | 736972 | 2020-11-16 | Crawford | Missouri | 29055 | 983 | 10 |
733726 | 733726 | 2020-11-15 | Crawford | Missouri | 29055 | 961 | 10 |
730481 | 730481 | 2020-11-14 | Crawford | Missouri | 29055 | 961 | 10 |
727238 | 727238 | 2020-11-13 | Crawford | Missouri | 29055 | 907 | 10 |
723995 | 723995 | 2020-11-12 | Crawford | Missouri | 29055 | 892 | 10 |
720752 | 720752 | 2020-11-11 | Crawford | Missouri | 29055 | 852 | 10 |
717509 | 717509 | 2020-11-10 | Crawford | Missouri | 29055 | 846 | 10 |
714265 | 714265 | 2020-11-09 | Crawford | Missouri | 29055 | 838 | 9 |
711021 | 711021 | 2020-11-08 | Crawford | Missouri | 29055 | 824 | 9 |
707777 | 707777 | 2020-11-07 | Crawford | Missouri | 29055 | 795 | 9 |
704534 | 704534 | 2020-11-06 | Crawford | Missouri | 29055 | 771 | 9 |
701292 | 701292 | 2020-11-05 | Crawford | Missouri | 29055 | 752 | 9 |
698048 | 698048 | 2020-11-04 | Crawford | Missouri | 29055 | 730 | 9 |
694805 | 694805 | 2020-11-03 | Crawford | Missouri | 29055 | 722 | 9 |
691563 | 691563 | 2020-11-02 | Crawford | Missouri | 29055 | 718 | 9 |
688318 | 688318 | 2020-11-01 | Crawford | Missouri | 29055 | 695 | 9 |
685074 | 685074 | 2020-10-31 | Crawford | Missouri | 29055 | 685 | 9 |
681831 | 681831 | 2020-10-30 | Crawford | Missouri | 29055 | 675 | 8 |
678587 | 678587 | 2020-10-29 | Crawford | Missouri | 29055 | 665 | 8 |
675345 | 675345 | 2020-10-28 | Crawford | Missouri | 29055 | 646 | 8 |
672102 | 672102 | 2020-10-27 | Crawford | Missouri | 29055 | 639 | 8 |
668860 | 668860 | 2020-10-26 | Crawford | Missouri | 29055 | 629 | 8 |
665616 | 665616 | 2020-10-25 | Crawford | Missouri | 29055 | 621 | 8 |
662371 | 662371 | 2020-10-24 | Crawford | Missouri | 29055 | 609 | 8 |
659127 | 659127 | 2020-10-23 | Crawford | Missouri | 29055 | 593 | 7 |
655882 | 655882 | 2020-10-22 | Crawford | Missouri | 29055 | 583 | 7 |
652637 | 652637 | 2020-10-21 | Crawford | Missouri | 29055 | 563 | 7 |
649392 | 649392 | 2020-10-20 | Crawford | Missouri | 29055 | 554 | 7 |
646148 | 646148 | 2020-10-19 | Crawford | Missouri | 29055 | 554 | 7 |
642902 | 642902 | 2020-10-18 | Crawford | Missouri | 29055 | 545 | 7 |
639654 | 639654 | 2020-10-17 | Crawford | Missouri | 29055 | 531 | 7 |
636408 | 636408 | 2020-10-16 | Crawford | Missouri | 29055 | 518 | 6 |
633162 | 633162 | 2020-10-15 | Crawford | Missouri | 29055 | 511 | 6 |
629917 | 629917 | 2020-10-14 | Crawford | Missouri | 29055 | 500 | 6 |
626673 | 626673 | 2020-10-13 | Crawford | Missouri | 29055 | 481 | 7 |
623431 | 623431 | 2020-10-12 | Crawford | Missouri | 29055 | 481 | 7 |
620188 | 620188 | 2020-10-11 | Crawford | Missouri | 29055 | 481 | 7 |
616946 | 616946 | 2020-10-10 | Crawford | Missouri | 29055 | 481 | 7 |
613705 | 613705 | 2020-10-09 | Crawford | Missouri | 29055 | 451 | 7 |
610463 | 610463 | 2020-10-08 | Crawford | Missouri | 29055 | 443 | 5 |
607221 | 607221 | 2020-10-07 | Crawford | Missouri | 29055 | 434 | 5 |
603978 | 603978 | 2020-10-06 | Crawford | Missouri | 29055 | 432 | 5 |
600736 | 600736 | 2020-10-05 | Crawford | Missouri | 29055 | 426 | 5 |
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);