ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
586 rows where fips = 30069 and state = "Montana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
600860 | 600860 | 2020-10-05 | Petroleum | Montana | 30069 | 1 | 0 |
604102 | 604102 | 2020-10-06 | Petroleum | Montana | 30069 | 1 | 0 |
607345 | 607345 | 2020-10-07 | Petroleum | Montana | 30069 | 1 | 0 |
610587 | 610587 | 2020-10-08 | Petroleum | Montana | 30069 | 1 | 0 |
613829 | 613829 | 2020-10-09 | Petroleum | Montana | 30069 | 1 | 0 |
617070 | 617070 | 2020-10-10 | Petroleum | Montana | 30069 | 2 | 0 |
620312 | 620312 | 2020-10-11 | Petroleum | Montana | 30069 | 2 | 0 |
623555 | 623555 | 2020-10-12 | Petroleum | Montana | 30069 | 3 | 0 |
626797 | 626797 | 2020-10-13 | Petroleum | Montana | 30069 | 3 | 0 |
630041 | 630041 | 2020-10-14 | Petroleum | Montana | 30069 | 3 | 0 |
633286 | 633286 | 2020-10-15 | Petroleum | Montana | 30069 | 3 | 0 |
636532 | 636532 | 2020-10-16 | Petroleum | Montana | 30069 | 3 | 0 |
639778 | 639778 | 2020-10-17 | Petroleum | Montana | 30069 | 3 | 0 |
643026 | 643026 | 2020-10-18 | Petroleum | Montana | 30069 | 3 | 0 |
646272 | 646272 | 2020-10-19 | Petroleum | Montana | 30069 | 3 | 0 |
649516 | 649516 | 2020-10-20 | Petroleum | Montana | 30069 | 3 | 0 |
652761 | 652761 | 2020-10-21 | Petroleum | Montana | 30069 | 3 | 0 |
656006 | 656006 | 2020-10-22 | Petroleum | Montana | 30069 | 3 | 0 |
659251 | 659251 | 2020-10-23 | Petroleum | Montana | 30069 | 3 | 0 |
662495 | 662495 | 2020-10-24 | Petroleum | Montana | 30069 | 3 | 0 |
665740 | 665740 | 2020-10-25 | Petroleum | Montana | 30069 | 3 | 0 |
668984 | 668984 | 2020-10-26 | Petroleum | Montana | 30069 | 3 | 0 |
672226 | 672226 | 2020-10-27 | Petroleum | Montana | 30069 | 3 | 0 |
675469 | 675469 | 2020-10-28 | Petroleum | Montana | 30069 | 3 | 0 |
678711 | 678711 | 2020-10-29 | Petroleum | Montana | 30069 | 3 | 0 |
681955 | 681955 | 2020-10-30 | Petroleum | Montana | 30069 | 3 | 0 |
685198 | 685198 | 2020-10-31 | Petroleum | Montana | 30069 | 3 | 0 |
688442 | 688442 | 2020-11-01 | Petroleum | Montana | 30069 | 4 | 0 |
691687 | 691687 | 2020-11-02 | Petroleum | Montana | 30069 | 4 | 0 |
694929 | 694929 | 2020-11-03 | Petroleum | Montana | 30069 | 4 | 0 |
698172 | 698172 | 2020-11-04 | Petroleum | Montana | 30069 | 4 | 0 |
701416 | 701416 | 2020-11-05 | Petroleum | Montana | 30069 | 4 | 0 |
704658 | 704658 | 2020-11-06 | Petroleum | Montana | 30069 | 4 | 0 |
707901 | 707901 | 2020-11-07 | Petroleum | Montana | 30069 | 5 | 0 |
711145 | 711145 | 2020-11-08 | Petroleum | Montana | 30069 | 5 | 0 |
714389 | 714389 | 2020-11-09 | Petroleum | Montana | 30069 | 5 | 0 |
717633 | 717633 | 2020-11-10 | Petroleum | Montana | 30069 | 4 | 0 |
720876 | 720876 | 2020-11-11 | Petroleum | Montana | 30069 | 4 | 0 |
724119 | 724119 | 2020-11-12 | Petroleum | Montana | 30069 | 4 | 0 |
727362 | 727362 | 2020-11-13 | Petroleum | Montana | 30069 | 5 | 0 |
730605 | 730605 | 2020-11-14 | Petroleum | Montana | 30069 | 4 | 0 |
733850 | 733850 | 2020-11-15 | Petroleum | Montana | 30069 | 5 | 0 |
737096 | 737096 | 2020-11-16 | Petroleum | Montana | 30069 | 5 | 0 |
740340 | 740340 | 2020-11-17 | Petroleum | Montana | 30069 | 5 | 0 |
743587 | 743587 | 2020-11-18 | Petroleum | Montana | 30069 | 5 | 0 |
746834 | 746834 | 2020-11-19 | Petroleum | Montana | 30069 | 5 | 0 |
750080 | 750080 | 2020-11-20 | Petroleum | Montana | 30069 | 5 | 0 |
753326 | 753326 | 2020-11-21 | Petroleum | Montana | 30069 | 6 | 0 |
756572 | 756572 | 2020-11-22 | Petroleum | Montana | 30069 | 6 | 0 |
759819 | 759819 | 2020-11-23 | Petroleum | Montana | 30069 | 6 | 0 |
763064 | 763064 | 2020-11-24 | Petroleum | Montana | 30069 | 6 | 0 |
766309 | 766309 | 2020-11-25 | Petroleum | Montana | 30069 | 7 | 0 |
769555 | 769555 | 2020-11-26 | Petroleum | Montana | 30069 | 7 | 0 |
772800 | 772800 | 2020-11-27 | Petroleum | Montana | 30069 | 7 | 0 |
776045 | 776045 | 2020-11-28 | Petroleum | Montana | 30069 | 7 | 1 |
779290 | 779290 | 2020-11-29 | Petroleum | Montana | 30069 | 7 | 1 |
782536 | 782536 | 2020-11-30 | Petroleum | Montana | 30069 | 8 | 1 |
785780 | 785780 | 2020-12-01 | Petroleum | Montana | 30069 | 8 | 1 |
789025 | 789025 | 2020-12-02 | Petroleum | Montana | 30069 | 8 | 1 |
792270 | 792270 | 2020-12-03 | Petroleum | Montana | 30069 | 8 | 1 |
795515 | 795515 | 2020-12-04 | Petroleum | Montana | 30069 | 8 | 1 |
798760 | 798760 | 2020-12-05 | Petroleum | Montana | 30069 | 10 | 1 |
802005 | 802005 | 2020-12-06 | Petroleum | Montana | 30069 | 10 | 1 |
805250 | 805250 | 2020-12-07 | Petroleum | Montana | 30069 | 10 | 1 |
808495 | 808495 | 2020-12-08 | Petroleum | Montana | 30069 | 10 | 1 |
811740 | 811740 | 2020-12-09 | Petroleum | Montana | 30069 | 10 | 1 |
814985 | 814985 | 2020-12-10 | Petroleum | Montana | 30069 | 10 | 1 |
818231 | 818231 | 2020-12-11 | Petroleum | Montana | 30069 | 10 | 1 |
821477 | 821477 | 2020-12-12 | Petroleum | Montana | 30069 | 10 | 1 |
824723 | 824723 | 2020-12-13 | Petroleum | Montana | 30069 | 10 | 1 |
827970 | 827970 | 2020-12-14 | Petroleum | Montana | 30069 | 10 | 1 |
831216 | 831216 | 2020-12-15 | Petroleum | Montana | 30069 | 10 | 1 |
834463 | 834463 | 2020-12-16 | Petroleum | Montana | 30069 | 10 | 1 |
837709 | 837709 | 2020-12-17 | Petroleum | Montana | 30069 | 10 | 1 |
840954 | 840954 | 2020-12-18 | Petroleum | Montana | 30069 | 10 | 1 |
844199 | 844199 | 2020-12-19 | Petroleum | Montana | 30069 | 10 | 1 |
847445 | 847445 | 2020-12-20 | Petroleum | Montana | 30069 | 10 | 1 |
850690 | 850690 | 2020-12-21 | Petroleum | Montana | 30069 | 10 | 1 |
853935 | 853935 | 2020-12-22 | Petroleum | Montana | 30069 | 10 | 1 |
857180 | 857180 | 2020-12-23 | Petroleum | Montana | 30069 | 10 | 1 |
860425 | 860425 | 2020-12-24 | Petroleum | Montana | 30069 | 10 | 1 |
863670 | 863670 | 2020-12-25 | Petroleum | Montana | 30069 | 10 | 1 |
866915 | 866915 | 2020-12-26 | Petroleum | Montana | 30069 | 10 | 1 |
870160 | 870160 | 2020-12-27 | Petroleum | Montana | 30069 | 10 | 1 |
873405 | 873405 | 2020-12-28 | Petroleum | Montana | 30069 | 10 | 1 |
876650 | 876650 | 2020-12-29 | Petroleum | Montana | 30069 | 10 | 1 |
879895 | 879895 | 2020-12-30 | Petroleum | Montana | 30069 | 10 | 1 |
883140 | 883140 | 2020-12-31 | Petroleum | Montana | 30069 | 10 | 1 |
886385 | 886385 | 2021-01-01 | Petroleum | Montana | 30069 | 10 | 1 |
889631 | 889631 | 2021-01-02 | Petroleum | Montana | 30069 | 10 | 1 |
892877 | 892877 | 2021-01-03 | Petroleum | Montana | 30069 | 10 | 1 |
896124 | 896124 | 2021-01-04 | Petroleum | Montana | 30069 | 11 | 1 |
899369 | 899369 | 2021-01-05 | Petroleum | Montana | 30069 | 11 | 1 |
902614 | 902614 | 2021-01-06 | Petroleum | Montana | 30069 | 11 | 1 |
905859 | 905859 | 2021-01-07 | Petroleum | Montana | 30069 | 11 | 1 |
909105 | 909105 | 2021-01-08 | Petroleum | Montana | 30069 | 11 | 1 |
912350 | 912350 | 2021-01-09 | Petroleum | Montana | 30069 | 11 | 1 |
915595 | 915595 | 2021-01-10 | Petroleum | Montana | 30069 | 11 | 1 |
918840 | 918840 | 2021-01-11 | Petroleum | Montana | 30069 | 11 | 1 |
922085 | 922085 | 2021-01-12 | Petroleum | Montana | 30069 | 11 | 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);