ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29097 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934963 | 934963 | 2021-01-16 | Jasper | Missouri | 29097 | 6662 | 94 |
931718 | 931718 | 2021-01-15 | Jasper | Missouri | 29097 | 6633 | 92 |
928473 | 928473 | 2021-01-14 | Jasper | Missouri | 29097 | 6606 | 92 |
925227 | 925227 | 2021-01-13 | Jasper | Missouri | 29097 | 6577 | 92 |
921982 | 921982 | 2021-01-12 | Jasper | Missouri | 29097 | 6506 | 92 |
918737 | 918737 | 2021-01-11 | Jasper | Missouri | 29097 | 6483 | 92 |
915492 | 915492 | 2021-01-10 | Jasper | Missouri | 29097 | 6465 | 92 |
912247 | 912247 | 2021-01-09 | Jasper | Missouri | 29097 | 6429 | 92 |
909002 | 909002 | 2021-01-08 | Jasper | Missouri | 29097 | 6381 | 87 |
905756 | 905756 | 2021-01-07 | Jasper | Missouri | 29097 | 6326 | 87 |
902511 | 902511 | 2021-01-06 | Jasper | Missouri | 29097 | 6267 | 87 |
899266 | 899266 | 2021-01-05 | Jasper | Missouri | 29097 | 6200 | 87 |
896021 | 896021 | 2021-01-04 | Jasper | Missouri | 29097 | 6165 | 86 |
892774 | 892774 | 2021-01-03 | Jasper | Missouri | 29097 | 6165 | 86 |
889528 | 889528 | 2021-01-02 | Jasper | Missouri | 29097 | 6121 | 86 |
886282 | 886282 | 2021-01-01 | Jasper | Missouri | 29097 | 6090 | 86 |
883037 | 883037 | 2020-12-31 | Jasper | Missouri | 29097 | 6020 | 84 |
879792 | 879792 | 2020-12-30 | Jasper | Missouri | 29097 | 5953 | 84 |
876547 | 876547 | 2020-12-29 | Jasper | Missouri | 29097 | 5902 | 84 |
873302 | 873302 | 2020-12-28 | Jasper | Missouri | 29097 | 5873 | 83 |
870057 | 870057 | 2020-12-27 | Jasper | Missouri | 29097 | 5843 | 83 |
866812 | 866812 | 2020-12-26 | Jasper | Missouri | 29097 | 5833 | 83 |
863567 | 863567 | 2020-12-25 | Jasper | Missouri | 29097 | 5819 | 83 |
860322 | 860322 | 2020-12-24 | Jasper | Missouri | 29097 | 5803 | 83 |
857077 | 857077 | 2020-12-23 | Jasper | Missouri | 29097 | 5776 | 83 |
853832 | 853832 | 2020-12-22 | Jasper | Missouri | 29097 | 5731 | 83 |
850587 | 850587 | 2020-12-21 | Jasper | Missouri | 29097 | 5719 | 80 |
847342 | 847342 | 2020-12-20 | Jasper | Missouri | 29097 | 5704 | 80 |
844096 | 844096 | 2020-12-19 | Jasper | Missouri | 29097 | 5667 | 80 |
840851 | 840851 | 2020-12-18 | Jasper | Missouri | 29097 | 5632 | 80 |
837606 | 837606 | 2020-12-17 | Jasper | Missouri | 29097 | 5590 | 80 |
834360 | 834360 | 2020-12-16 | Jasper | Missouri | 29097 | 5551 | 78 |
831113 | 831113 | 2020-12-15 | Jasper | Missouri | 29097 | 5509 | 78 |
827867 | 827867 | 2020-12-14 | Jasper | Missouri | 29097 | 5493 | 78 |
824620 | 824620 | 2020-12-13 | Jasper | Missouri | 29097 | 5471 | 78 |
821374 | 821374 | 2020-12-12 | Jasper | Missouri | 29097 | 5449 | 78 |
818128 | 818128 | 2020-12-11 | Jasper | Missouri | 29097 | 5383 | 74 |
814882 | 814882 | 2020-12-10 | Jasper | Missouri | 29097 | 5383 | 74 |
811637 | 811637 | 2020-12-09 | Jasper | Missouri | 29097 | 5346 | 74 |
808392 | 808392 | 2020-12-08 | Jasper | Missouri | 29097 | 5297 | 71 |
805147 | 805147 | 2020-12-07 | Jasper | Missouri | 29097 | 5252 | 71 |
801902 | 801902 | 2020-12-06 | Jasper | Missouri | 29097 | 5241 | 71 |
798657 | 798657 | 2020-12-05 | Jasper | Missouri | 29097 | 5208 | 71 |
795412 | 795412 | 2020-12-04 | Jasper | Missouri | 29097 | 5162 | 70 |
792167 | 792167 | 2020-12-03 | Jasper | Missouri | 29097 | 5122 | 68 |
788922 | 788922 | 2020-12-02 | Jasper | Missouri | 29097 | 5085 | 66 |
785677 | 785677 | 2020-12-01 | Jasper | Missouri | 29097 | 5009 | 65 |
782433 | 782433 | 2020-11-30 | Jasper | Missouri | 29097 | 4984 | 60 |
779187 | 779187 | 2020-11-29 | Jasper | Missouri | 29097 | 4956 | 60 |
775942 | 775942 | 2020-11-28 | Jasper | Missouri | 29097 | 4926 | 60 |
772697 | 772697 | 2020-11-27 | Jasper | Missouri | 29097 | 4925 | 60 |
769452 | 769452 | 2020-11-26 | Jasper | Missouri | 29097 | 4887 | 60 |
766206 | 766206 | 2020-11-25 | Jasper | Missouri | 29097 | 4843 | 60 |
762961 | 762961 | 2020-11-24 | Jasper | Missouri | 29097 | 4782 | 60 |
759716 | 759716 | 2020-11-23 | Jasper | Missouri | 29097 | 4761 | 59 |
756469 | 756469 | 2020-11-22 | Jasper | Missouri | 29097 | 4731 | 59 |
753223 | 753223 | 2020-11-21 | Jasper | Missouri | 29097 | 4660 | 59 |
749977 | 749977 | 2020-11-20 | Jasper | Missouri | 29097 | 4566 | 58 |
746731 | 746731 | 2020-11-19 | Jasper | Missouri | 29097 | 4503 | 58 |
743484 | 743484 | 2020-11-18 | Jasper | Missouri | 29097 | 4405 | 58 |
740237 | 740237 | 2020-11-17 | Jasper | Missouri | 29097 | 4311 | 55 |
736993 | 736993 | 2020-11-16 | Jasper | Missouri | 29097 | 4279 | 54 |
733747 | 733747 | 2020-11-15 | Jasper | Missouri | 29097 | 4233 | 54 |
730502 | 730502 | 2020-11-14 | Jasper | Missouri | 29097 | 4233 | 54 |
727259 | 727259 | 2020-11-13 | Jasper | Missouri | 29097 | 4072 | 54 |
724016 | 724016 | 2020-11-12 | Jasper | Missouri | 29097 | 4004 | 54 |
720773 | 720773 | 2020-11-11 | Jasper | Missouri | 29097 | 3921 | 54 |
717530 | 717530 | 2020-11-10 | Jasper | Missouri | 29097 | 3806 | 54 |
714286 | 714286 | 2020-11-09 | Jasper | Missouri | 29097 | 3762 | 50 |
711042 | 711042 | 2020-11-08 | Jasper | Missouri | 29097 | 3738 | 50 |
707798 | 707798 | 2020-11-07 | Jasper | Missouri | 29097 | 3672 | 51 |
704555 | 704555 | 2020-11-06 | Jasper | Missouri | 29097 | 3581 | 51 |
701313 | 701313 | 2020-11-05 | Jasper | Missouri | 29097 | 3533 | 49 |
698069 | 698069 | 2020-11-04 | Jasper | Missouri | 29097 | 3480 | 47 |
694826 | 694826 | 2020-11-03 | Jasper | Missouri | 29097 | 3428 | 45 |
691584 | 691584 | 2020-11-02 | Jasper | Missouri | 29097 | 3422 | 45 |
688339 | 688339 | 2020-11-01 | Jasper | Missouri | 29097 | 3400 | 45 |
685095 | 685095 | 2020-10-31 | Jasper | Missouri | 29097 | 3377 | 45 |
681852 | 681852 | 2020-10-30 | Jasper | Missouri | 29097 | 3339 | 45 |
678608 | 678608 | 2020-10-29 | Jasper | Missouri | 29097 | 3308 | 44 |
675366 | 675366 | 2020-10-28 | Jasper | Missouri | 29097 | 3276 | 44 |
672123 | 672123 | 2020-10-27 | Jasper | Missouri | 29097 | 3242 | 43 |
668881 | 668881 | 2020-10-26 | Jasper | Missouri | 29097 | 3201 | 41 |
665637 | 665637 | 2020-10-25 | Jasper | Missouri | 29097 | 3198 | 41 |
662392 | 662392 | 2020-10-24 | Jasper | Missouri | 29097 | 3151 | 41 |
659148 | 659148 | 2020-10-23 | Jasper | Missouri | 29097 | 3122 | 40 |
655903 | 655903 | 2020-10-22 | Jasper | Missouri | 29097 | 3081 | 40 |
652658 | 652658 | 2020-10-21 | Jasper | Missouri | 29097 | 3051 | 40 |
649413 | 649413 | 2020-10-20 | Jasper | Missouri | 29097 | 3013 | 40 |
646169 | 646169 | 2020-10-19 | Jasper | Missouri | 29097 | 3013 | 40 |
642923 | 642923 | 2020-10-18 | Jasper | Missouri | 29097 | 3007 | 40 |
639675 | 639675 | 2020-10-17 | Jasper | Missouri | 29097 | 2982 | 40 |
636429 | 636429 | 2020-10-16 | Jasper | Missouri | 29097 | 2907 | 36 |
633183 | 633183 | 2020-10-15 | Jasper | Missouri | 29097 | 2883 | 36 |
629938 | 629938 | 2020-10-14 | Jasper | Missouri | 29097 | 2848 | 36 |
626694 | 626694 | 2020-10-13 | Jasper | Missouri | 29097 | 2406 | 33 |
623452 | 623452 | 2020-10-12 | Jasper | Missouri | 29097 | 2406 | 33 |
620209 | 620209 | 2020-10-11 | Jasper | Missouri | 29097 | 2406 | 33 |
616967 | 616967 | 2020-10-10 | Jasper | Missouri | 29097 | 2406 | 33 |
613726 | 613726 | 2020-10-09 | Jasper | Missouri | 29097 | 2345 | 33 |
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);