ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 29095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921981 | 921981 | 2021-01-12 | Jackson | Missouri | 29095 | 25848 | 279 |
918736 | 918736 | 2021-01-11 | Jackson | Missouri | 29095 | 25548 | 264 |
915491 | 915491 | 2021-01-10 | Jackson | Missouri | 29095 | 25384 | 264 |
912246 | 912246 | 2021-01-09 | Jackson | Missouri | 29095 | 25179 | 264 |
909001 | 909001 | 2021-01-08 | Jackson | Missouri | 29095 | 24938 | 263 |
905755 | 905755 | 2021-01-07 | Jackson | Missouri | 29095 | 24721 | 262 |
902510 | 902510 | 2021-01-06 | Jackson | Missouri | 29095 | 24441 | 260 |
899265 | 899265 | 2021-01-05 | Jackson | Missouri | 29095 | 24252 | 258 |
896020 | 896020 | 2021-01-04 | Jackson | Missouri | 29095 | 24069 | 245 |
892773 | 892773 | 2021-01-03 | Jackson | Missouri | 29095 | 24069 | 245 |
889527 | 889527 | 2021-01-02 | Jackson | Missouri | 29095 | 23827 | 245 |
886281 | 886281 | 2021-01-01 | Jackson | Missouri | 29095 | 23679 | 245 |
883036 | 883036 | 2020-12-31 | Jackson | Missouri | 29095 | 23425 | 243 |
879791 | 879791 | 2020-12-30 | Jackson | Missouri | 29095 | 23183 | 239 |
876546 | 876546 | 2020-12-29 | Jackson | Missouri | 29095 | 23016 | 235 |
873301 | 873301 | 2020-12-28 | Jackson | Missouri | 29095 | 22842 | 230 |
870056 | 870056 | 2020-12-27 | Jackson | Missouri | 29095 | 22735 | 230 |
866811 | 866811 | 2020-12-26 | Jackson | Missouri | 29095 | 22654 | 230 |
863566 | 863566 | 2020-12-25 | Jackson | Missouri | 29095 | 22542 | 230 |
860321 | 860321 | 2020-12-24 | Jackson | Missouri | 29095 | 22368 | 229 |
857076 | 857076 | 2020-12-23 | Jackson | Missouri | 29095 | 22116 | 222 |
853831 | 853831 | 2020-12-22 | Jackson | Missouri | 29095 | 21876 | 217 |
850586 | 850586 | 2020-12-21 | Jackson | Missouri | 29095 | 21757 | 207 |
847341 | 847341 | 2020-12-20 | Jackson | Missouri | 29095 | 21519 | 207 |
844095 | 844095 | 2020-12-19 | Jackson | Missouri | 29095 | 21404 | 206 |
840850 | 840850 | 2020-12-18 | Jackson | Missouri | 29095 | 21257 | 207 |
837605 | 837605 | 2020-12-17 | Jackson | Missouri | 29095 | 21082 | 206 |
834359 | 834359 | 2020-12-16 | Jackson | Missouri | 29095 | 20918 | 205 |
831112 | 831112 | 2020-12-15 | Jackson | Missouri | 29095 | 20779 | 205 |
827866 | 827866 | 2020-12-14 | Jackson | Missouri | 29095 | 20584 | 197 |
824619 | 824619 | 2020-12-13 | Jackson | Missouri | 29095 | 20408 | 197 |
821373 | 821373 | 2020-12-12 | Jackson | Missouri | 29095 | 20291 | 197 |
818127 | 818127 | 2020-12-11 | Jackson | Missouri | 29095 | 19784 | 196 |
814881 | 814881 | 2020-12-10 | Jackson | Missouri | 29095 | 19784 | 196 |
811636 | 811636 | 2020-12-09 | Jackson | Missouri | 29095 | 19522 | 193 |
808391 | 808391 | 2020-12-08 | Jackson | Missouri | 29095 | 19335 | 193 |
805146 | 805146 | 2020-12-07 | Jackson | Missouri | 29095 | 19126 | 190 |
801901 | 801901 | 2020-12-06 | Jackson | Missouri | 29095 | 18944 | 190 |
798656 | 798656 | 2020-12-05 | Jackson | Missouri | 29095 | 18654 | 190 |
795411 | 795411 | 2020-12-04 | Jackson | Missouri | 29095 | 18369 | 186 |
792166 | 792166 | 2020-12-03 | Jackson | Missouri | 29095 | 18081 | 185 |
788921 | 788921 | 2020-12-02 | Jackson | Missouri | 29095 | 17812 | 184 |
785676 | 785676 | 2020-12-01 | Jackson | Missouri | 29095 | 17660 | 183 |
782432 | 782432 | 2020-11-30 | Jackson | Missouri | 29095 | 17379 | 180 |
779186 | 779186 | 2020-11-29 | Jackson | Missouri | 29095 | 17136 | 180 |
775941 | 775941 | 2020-11-28 | Jackson | Missouri | 29095 | 16937 | 177 |
772696 | 772696 | 2020-11-27 | Jackson | Missouri | 29095 | 16812 | 176 |
769451 | 769451 | 2020-11-26 | Jackson | Missouri | 29095 | 16601 | 176 |
766205 | 766205 | 2020-11-25 | Jackson | Missouri | 29095 | 16310 | 176 |
762960 | 762960 | 2020-11-24 | Jackson | Missouri | 29095 | 16106 | 175 |
759715 | 759715 | 2020-11-23 | Jackson | Missouri | 29095 | 15920 | 171 |
756468 | 756468 | 2020-11-22 | Jackson | Missouri | 29095 | 15695 | 171 |
753222 | 753222 | 2020-11-21 | Jackson | Missouri | 29095 | 15478 | 171 |
749976 | 749976 | 2020-11-20 | Jackson | Missouri | 29095 | 15213 | 170 |
746730 | 746730 | 2020-11-19 | Jackson | Missouri | 29095 | 14949 | 166 |
743483 | 743483 | 2020-11-18 | Jackson | Missouri | 29095 | 14701 | 165 |
740236 | 740236 | 2020-11-17 | Jackson | Missouri | 29095 | 14380 | 163 |
736992 | 736992 | 2020-11-16 | Jackson | Missouri | 29095 | 13966 | 155 |
733746 | 733746 | 2020-11-15 | Jackson | Missouri | 29095 | 13748 | 153 |
730501 | 730501 | 2020-11-14 | Jackson | Missouri | 29095 | 13748 | 153 |
727258 | 727258 | 2020-11-13 | Jackson | Missouri | 29095 | 13120 | 153 |
724015 | 724015 | 2020-11-12 | Jackson | Missouri | 29095 | 12890 | 152 |
720772 | 720772 | 2020-11-11 | Jackson | Missouri | 29095 | 12717 | 151 |
717529 | 717529 | 2020-11-10 | Jackson | Missouri | 29095 | 12493 | 150 |
714285 | 714285 | 2020-11-09 | Jackson | Missouri | 29095 | 12170 | 145 |
711041 | 711041 | 2020-11-08 | Jackson | Missouri | 29095 | 11979 | 145 |
707797 | 707797 | 2020-11-07 | Jackson | Missouri | 29095 | 11748 | 145 |
704554 | 704554 | 2020-11-06 | Jackson | Missouri | 29095 | 11493 | 144 |
701312 | 701312 | 2020-11-05 | Jackson | Missouri | 29095 | 11224 | 144 |
698068 | 698068 | 2020-11-04 | Jackson | Missouri | 29095 | 11002 | 144 |
694825 | 694825 | 2020-11-03 | Jackson | Missouri | 29095 | 10893 | 142 |
691583 | 691583 | 2020-11-02 | Jackson | Missouri | 29095 | 10777 | 140 |
688338 | 688338 | 2020-11-01 | Jackson | Missouri | 29095 | 10582 | 140 |
685094 | 685094 | 2020-10-31 | Jackson | Missouri | 29095 | 10480 | 140 |
681851 | 681851 | 2020-10-30 | Jackson | Missouri | 29095 | 10365 | 136 |
678607 | 678607 | 2020-10-29 | Jackson | Missouri | 29095 | 10290 | 133 |
675365 | 675365 | 2020-10-28 | Jackson | Missouri | 29095 | 10144 | 126 |
672122 | 672122 | 2020-10-27 | Jackson | Missouri | 29095 | 10033 | 123 |
668880 | 668880 | 2020-10-26 | Jackson | Missouri | 29095 | 9944 | 123 |
665636 | 665636 | 2020-10-25 | Jackson | Missouri | 29095 | 9855 | 123 |
662391 | 662391 | 2020-10-24 | Jackson | Missouri | 29095 | 9765 | 122 |
659147 | 659147 | 2020-10-23 | Jackson | Missouri | 29095 | 9662 | 118 |
655902 | 655902 | 2020-10-22 | Jackson | Missouri | 29095 | 9541 | 118 |
652657 | 652657 | 2020-10-21 | Jackson | Missouri | 29095 | 9384 | 117 |
649412 | 649412 | 2020-10-20 | Jackson | Missouri | 29095 | 9196 | 115 |
646168 | 646168 | 2020-10-19 | Jackson | Missouri | 29095 | 9196 | 115 |
642922 | 642922 | 2020-10-18 | Jackson | Missouri | 29095 | 9174 | 115 |
639674 | 639674 | 2020-10-17 | Jackson | Missouri | 29095 | 9088 | 116 |
636428 | 636428 | 2020-10-16 | Jackson | Missouri | 29095 | 9062 | 113 |
633182 | 633182 | 2020-10-15 | Jackson | Missouri | 29095 | 8977 | 113 |
629937 | 629937 | 2020-10-14 | Jackson | Missouri | 29095 | 8901 | 120 |
626693 | 626693 | 2020-10-13 | Jackson | Missouri | 29095 | 8319 | 116 |
623451 | 623451 | 2020-10-12 | Jackson | Missouri | 29095 | 8319 | 116 |
620208 | 620208 | 2020-10-11 | Jackson | Missouri | 29095 | 8319 | 116 |
616966 | 616966 | 2020-10-10 | Jackson | Missouri | 29095 | 8319 | 116 |
613725 | 613725 | 2020-10-09 | Jackson | Missouri | 29095 | 8069 | 113 |
610483 | 610483 | 2020-10-08 | Jackson | Missouri | 29095 | 7973 | 108 |
607241 | 607241 | 2020-10-07 | Jackson | Missouri | 29095 | 8365 | 107 |
603998 | 603998 | 2020-10-06 | Jackson | Missouri | 29095 | 8279 | 104 |
600756 | 600756 | 2020-10-05 | Jackson | Missouri | 29095 | 7629 | 103 |
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);