ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jefferson" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948035 | 948035 | 2021-01-20 | Jefferson | Montana | 30043 | 901 | 7 |
944788 | 944788 | 2021-01-19 | Jefferson | Montana | 30043 | 891 | 7 |
941543 | 941543 | 2021-01-18 | Jefferson | Montana | 30043 | 891 | 7 |
938298 | 938298 | 2021-01-17 | Jefferson | Montana | 30043 | 883 | 7 |
935053 | 935053 | 2021-01-16 | Jefferson | Montana | 30043 | 882 | 7 |
931808 | 931808 | 2021-01-15 | Jefferson | Montana | 30043 | 871 | 7 |
928563 | 928563 | 2021-01-14 | Jefferson | Montana | 30043 | 866 | 7 |
925317 | 925317 | 2021-01-13 | Jefferson | Montana | 30043 | 865 | 5 |
922072 | 922072 | 2021-01-12 | Jefferson | Montana | 30043 | 855 | 5 |
918827 | 918827 | 2021-01-11 | Jefferson | Montana | 30043 | 851 | 4 |
915582 | 915582 | 2021-01-10 | Jefferson | Montana | 30043 | 850 | 4 |
912337 | 912337 | 2021-01-09 | Jefferson | Montana | 30043 | 851 | 4 |
909092 | 909092 | 2021-01-08 | Jefferson | Montana | 30043 | 844 | 4 |
905846 | 905846 | 2021-01-07 | Jefferson | Montana | 30043 | 827 | 4 |
902601 | 902601 | 2021-01-06 | Jefferson | Montana | 30043 | 818 | 4 |
899356 | 899356 | 2021-01-05 | Jefferson | Montana | 30043 | 812 | 4 |
896111 | 896111 | 2021-01-04 | Jefferson | Montana | 30043 | 800 | 4 |
892864 | 892864 | 2021-01-03 | Jefferson | Montana | 30043 | 779 | 4 |
889618 | 889618 | 2021-01-02 | Jefferson | Montana | 30043 | 779 | 4 |
886372 | 886372 | 2021-01-01 | Jefferson | Montana | 30043 | 777 | 4 |
883127 | 883127 | 2020-12-31 | Jefferson | Montana | 30043 | 777 | 4 |
879882 | 879882 | 2020-12-30 | Jefferson | Montana | 30043 | 773 | 4 |
876637 | 876637 | 2020-12-29 | Jefferson | Montana | 30043 | 765 | 4 |
873392 | 873392 | 2020-12-28 | Jefferson | Montana | 30043 | 757 | 3 |
870147 | 870147 | 2020-12-27 | Jefferson | Montana | 30043 | 738 | 3 |
866902 | 866902 | 2020-12-26 | Jefferson | Montana | 30043 | 738 | 3 |
863657 | 863657 | 2020-12-25 | Jefferson | Montana | 30043 | 736 | 3 |
860412 | 860412 | 2020-12-24 | Jefferson | Montana | 30043 | 736 | 3 |
857167 | 857167 | 2020-12-23 | Jefferson | Montana | 30043 | 726 | 3 |
853922 | 853922 | 2020-12-22 | Jefferson | Montana | 30043 | 718 | 3 |
850677 | 850677 | 2020-12-21 | Jefferson | Montana | 30043 | 701 | 3 |
847432 | 847432 | 2020-12-20 | Jefferson | Montana | 30043 | 689 | 3 |
844186 | 844186 | 2020-12-19 | Jefferson | Montana | 30043 | 689 | 3 |
840941 | 840941 | 2020-12-18 | Jefferson | Montana | 30043 | 687 | 2 |
837696 | 837696 | 2020-12-17 | Jefferson | Montana | 30043 | 672 | 2 |
834450 | 834450 | 2020-12-16 | Jefferson | Montana | 30043 | 660 | 2 |
831203 | 831203 | 2020-12-15 | Jefferson | Montana | 30043 | 651 | 1 |
827957 | 827957 | 2020-12-14 | Jefferson | Montana | 30043 | 638 | 1 |
824710 | 824710 | 2020-12-13 | Jefferson | Montana | 30043 | 638 | 1 |
821464 | 821464 | 2020-12-12 | Jefferson | Montana | 30043 | 632 | 1 |
818218 | 818218 | 2020-12-11 | Jefferson | Montana | 30043 | 620 | 1 |
814972 | 814972 | 2020-12-10 | Jefferson | Montana | 30043 | 597 | 1 |
811727 | 811727 | 2020-12-09 | Jefferson | Montana | 30043 | 588 | 2 |
808482 | 808482 | 2020-12-08 | Jefferson | Montana | 30043 | 583 | 1 |
805237 | 805237 | 2020-12-07 | Jefferson | Montana | 30043 | 566 | 1 |
801992 | 801992 | 2020-12-06 | Jefferson | Montana | 30043 | 552 | 1 |
798747 | 798747 | 2020-12-05 | Jefferson | Montana | 30043 | 551 | 1 |
795502 | 795502 | 2020-12-04 | Jefferson | Montana | 30043 | 540 | 1 |
792257 | 792257 | 2020-12-03 | Jefferson | Montana | 30043 | 521 | 1 |
789012 | 789012 | 2020-12-02 | Jefferson | Montana | 30043 | 518 | 1 |
785767 | 785767 | 2020-12-01 | Jefferson | Montana | 30043 | 500 | 0 |
782523 | 782523 | 2020-11-30 | Jefferson | Montana | 30043 | 472 | 0 |
779277 | 779277 | 2020-11-29 | Jefferson | Montana | 30043 | 470 | 0 |
776032 | 776032 | 2020-11-28 | Jefferson | Montana | 30043 | 470 | 0 |
772787 | 772787 | 2020-11-27 | Jefferson | Montana | 30043 | 465 | 0 |
769542 | 769542 | 2020-11-26 | Jefferson | Montana | 30043 | 465 | 0 |
766296 | 766296 | 2020-11-25 | Jefferson | Montana | 30043 | 450 | 0 |
763051 | 763051 | 2020-11-24 | Jefferson | Montana | 30043 | 437 | 0 |
759806 | 759806 | 2020-11-23 | Jefferson | Montana | 30043 | 411 | 0 |
756559 | 756559 | 2020-11-22 | Jefferson | Montana | 30043 | 411 | 0 |
753313 | 753313 | 2020-11-21 | Jefferson | Montana | 30043 | 409 | 0 |
750067 | 750067 | 2020-11-20 | Jefferson | Montana | 30043 | 392 | 0 |
746821 | 746821 | 2020-11-19 | Jefferson | Montana | 30043 | 371 | 0 |
743574 | 743574 | 2020-11-18 | Jefferson | Montana | 30043 | 357 | 0 |
740327 | 740327 | 2020-11-17 | Jefferson | Montana | 30043 | 333 | 0 |
737083 | 737083 | 2020-11-16 | Jefferson | Montana | 30043 | 311 | 0 |
733837 | 733837 | 2020-11-15 | Jefferson | Montana | 30043 | 310 | 0 |
730592 | 730592 | 2020-11-14 | Jefferson | Montana | 30043 | 296 | 0 |
727349 | 727349 | 2020-11-13 | Jefferson | Montana | 30043 | 280 | 0 |
724106 | 724106 | 2020-11-12 | Jefferson | Montana | 30043 | 263 | 0 |
720863 | 720863 | 2020-11-11 | Jefferson | Montana | 30043 | 263 | 0 |
717620 | 717620 | 2020-11-10 | Jefferson | Montana | 30043 | 250 | 0 |
714376 | 714376 | 2020-11-09 | Jefferson | Montana | 30043 | 235 | 0 |
711132 | 711132 | 2020-11-08 | Jefferson | Montana | 30043 | 235 | 0 |
707888 | 707888 | 2020-11-07 | Jefferson | Montana | 30043 | 231 | 0 |
704645 | 704645 | 2020-11-06 | Jefferson | Montana | 30043 | 221 | 0 |
701403 | 701403 | 2020-11-05 | Jefferson | Montana | 30043 | 211 | 0 |
698159 | 698159 | 2020-11-04 | Jefferson | Montana | 30043 | 197 | 0 |
694916 | 694916 | 2020-11-03 | Jefferson | Montana | 30043 | 197 | 0 |
691674 | 691674 | 2020-11-02 | Jefferson | Montana | 30043 | 186 | 0 |
688429 | 688429 | 2020-11-01 | Jefferson | Montana | 30043 | 186 | 0 |
685185 | 685185 | 2020-10-31 | Jefferson | Montana | 30043 | 184 | 0 |
681942 | 681942 | 2020-10-30 | Jefferson | Montana | 30043 | 180 | 0 |
678698 | 678698 | 2020-10-29 | Jefferson | Montana | 30043 | 174 | 0 |
675456 | 675456 | 2020-10-28 | Jefferson | Montana | 30043 | 168 | 0 |
672213 | 672213 | 2020-10-27 | Jefferson | Montana | 30043 | 165 | 0 |
668971 | 668971 | 2020-10-26 | Jefferson | Montana | 30043 | 156 | 0 |
665727 | 665727 | 2020-10-25 | Jefferson | Montana | 30043 | 150 | 0 |
662482 | 662482 | 2020-10-24 | Jefferson | Montana | 30043 | 141 | 0 |
659238 | 659238 | 2020-10-23 | Jefferson | Montana | 30043 | 141 | 0 |
655993 | 655993 | 2020-10-22 | Jefferson | Montana | 30043 | 140 | 0 |
652748 | 652748 | 2020-10-21 | Jefferson | Montana | 30043 | 139 | 0 |
649503 | 649503 | 2020-10-20 | Jefferson | Montana | 30043 | 137 | 0 |
646259 | 646259 | 2020-10-19 | Jefferson | Montana | 30043 | 134 | 0 |
643013 | 643013 | 2020-10-18 | Jefferson | Montana | 30043 | 130 | 0 |
639765 | 639765 | 2020-10-17 | Jefferson | Montana | 30043 | 124 | 0 |
636519 | 636519 | 2020-10-16 | Jefferson | Montana | 30043 | 119 | 0 |
633273 | 633273 | 2020-10-15 | Jefferson | Montana | 30043 | 117 | 0 |
630028 | 630028 | 2020-10-14 | Jefferson | Montana | 30043 | 112 | 0 |
626784 | 626784 | 2020-10-13 | Jefferson | Montana | 30043 | 111 | 0 |
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);