ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Marion" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922686 | 922686 | 2021-01-12 | Marion | Oregon | 41047 | 15643 | 231 |
919441 | 919441 | 2021-01-11 | Marion | Oregon | 41047 | 15550 | 222 |
916196 | 916196 | 2021-01-10 | Marion | Oregon | 41047 | 15440 | 223 |
912951 | 912951 | 2021-01-09 | Marion | Oregon | 41047 | 15211 | 223 |
909706 | 909706 | 2021-01-08 | Marion | Oregon | 41047 | 15103 | 220 |
906461 | 906461 | 2021-01-07 | Marion | Oregon | 41047 | 14927 | 219 |
903215 | 903215 | 2021-01-06 | Marion | Oregon | 41047 | 14793 | 218 |
899970 | 899970 | 2021-01-05 | Marion | Oregon | 41047 | 14660 | 218 |
896725 | 896725 | 2021-01-04 | Marion | Oregon | 41047 | 14561 | 215 |
893479 | 893479 | 2021-01-03 | Marion | Oregon | 41047 | 14483 | 215 |
890233 | 890233 | 2021-01-02 | Marion | Oregon | 41047 | 14261 | 213 |
886986 | 886986 | 2021-01-01 | Marion | Oregon | 41047 | 14128 | 213 |
883741 | 883741 | 2020-12-31 | Marion | Oregon | 41047 | 13928 | 210 |
880496 | 880496 | 2020-12-30 | Marion | Oregon | 41047 | 13741 | 208 |
877251 | 877251 | 2020-12-29 | Marion | Oregon | 41047 | 13620 | 207 |
874006 | 874006 | 2020-12-28 | Marion | Oregon | 41047 | 13462 | 207 |
870761 | 870761 | 2020-12-27 | Marion | Oregon | 41047 | 13462 | 207 |
867516 | 867516 | 2020-12-26 | Marion | Oregon | 41047 | 13104 | 206 |
864271 | 864271 | 2020-12-25 | Marion | Oregon | 41047 | 13101 | 206 |
861026 | 861026 | 2020-12-24 | Marion | Oregon | 41047 | 12976 | 203 |
857781 | 857781 | 2020-12-23 | Marion | Oregon | 41047 | 12895 | 201 |
854536 | 854536 | 2020-12-22 | Marion | Oregon | 41047 | 12771 | 201 |
851291 | 851291 | 2020-12-21 | Marion | Oregon | 41047 | 12610 | 195 |
848046 | 848046 | 2020-12-20 | Marion | Oregon | 41047 | 12543 | 195 |
844801 | 844801 | 2020-12-19 | Marion | Oregon | 41047 | 12343 | 195 |
841555 | 841555 | 2020-12-18 | Marion | Oregon | 41047 | 12184 | 192 |
838310 | 838310 | 2020-12-17 | Marion | Oregon | 41047 | 12038 | 190 |
835064 | 835064 | 2020-12-16 | Marion | Oregon | 41047 | 11892 | 188 |
831818 | 831818 | 2020-12-15 | Marion | Oregon | 41047 | 11714 | 186 |
828571 | 828571 | 2020-12-14 | Marion | Oregon | 41047 | 11577 | 180 |
825325 | 825325 | 2020-12-13 | Marion | Oregon | 41047 | 11389 | 180 |
822078 | 822078 | 2020-12-12 | Marion | Oregon | 41047 | 11246 | 179 |
818832 | 818832 | 2020-12-11 | Marion | Oregon | 41047 | 11114 | 176 |
815586 | 815586 | 2020-12-10 | Marion | Oregon | 41047 | 10938 | 174 |
812340 | 812340 | 2020-12-09 | Marion | Oregon | 41047 | 10787 | 172 |
809096 | 809096 | 2020-12-08 | Marion | Oregon | 41047 | 10598 | 170 |
805851 | 805851 | 2020-12-07 | Marion | Oregon | 41047 | 10492 | 164 |
802606 | 802606 | 2020-12-06 | Marion | Oregon | 41047 | 10332 | 163 |
799361 | 799361 | 2020-12-05 | Marion | Oregon | 41047 | 10118 | 161 |
796116 | 796116 | 2020-12-04 | Marion | Oregon | 41047 | 9933 | 158 |
792871 | 792871 | 2020-12-03 | Marion | Oregon | 41047 | 9745 | 153 |
789626 | 789626 | 2020-12-02 | Marion | Oregon | 41047 | 9634 | 147 |
786381 | 786381 | 2020-12-01 | Marion | Oregon | 41047 | 9514 | 146 |
783137 | 783137 | 2020-11-30 | Marion | Oregon | 41047 | 9370 | 142 |
779891 | 779891 | 2020-11-29 | Marion | Oregon | 41047 | 9207 | 140 |
776646 | 776646 | 2020-11-28 | Marion | Oregon | 41047 | 9082 | 139 |
773401 | 773401 | 2020-11-27 | Marion | Oregon | 41047 | 9017 | 137 |
770156 | 770156 | 2020-11-26 | Marion | Oregon | 41047 | 8849 | 137 |
766910 | 766910 | 2020-11-25 | Marion | Oregon | 41047 | 8650 | 135 |
763665 | 763665 | 2020-11-24 | Marion | Oregon | 41047 | 8548 | 131 |
760420 | 760420 | 2020-11-23 | Marion | Oregon | 41047 | 8436 | 130 |
757175 | 757175 | 2020-11-22 | Marion | Oregon | 41047 | 8321 | 127 |
753928 | 753928 | 2020-11-21 | Marion | Oregon | 41047 | 8145 | 127 |
750682 | 750682 | 2020-11-20 | Marion | Oregon | 41047 | 8025 | 127 |
747436 | 747436 | 2020-11-19 | Marion | Oregon | 41047 | 7914 | 127 |
744190 | 744190 | 2020-11-18 | Marion | Oregon | 41047 | 7830 | 127 |
740943 | 740943 | 2020-11-17 | Marion | Oregon | 41047 | 7747 | 127 |
737697 | 737697 | 2020-11-16 | Marion | Oregon | 41047 | 7600 | 124 |
734453 | 734453 | 2020-11-15 | Marion | Oregon | 41047 | 7500 | 124 |
731207 | 731207 | 2020-11-14 | Marion | Oregon | 41047 | 7324 | 124 |
727963 | 727963 | 2020-11-13 | Marion | Oregon | 41047 | 7266 | 124 |
724719 | 724719 | 2020-11-12 | Marion | Oregon | 41047 | 7146 | 122 |
721476 | 721476 | 2020-11-11 | Marion | Oregon | 41047 | 7045 | 121 |
718233 | 718233 | 2020-11-10 | Marion | Oregon | 41047 | 6963 | 119 |
714990 | 714990 | 2020-11-09 | Marion | Oregon | 41047 | 6878 | 118 |
711746 | 711746 | 2020-11-08 | Marion | Oregon | 41047 | 6796 | 117 |
708502 | 708502 | 2020-11-07 | Marion | Oregon | 41047 | 6685 | 117 |
705259 | 705259 | 2020-11-06 | Marion | Oregon | 41047 | 6610 | 116 |
702016 | 702016 | 2020-11-05 | Marion | Oregon | 41047 | 6533 | 115 |
698772 | 698772 | 2020-11-04 | Marion | Oregon | 41047 | 6458 | 115 |
695529 | 695529 | 2020-11-03 | Marion | Oregon | 41047 | 6375 | 114 |
692287 | 692287 | 2020-11-02 | Marion | Oregon | 41047 | 6311 | 112 |
689043 | 689043 | 2020-11-01 | Marion | Oregon | 41047 | 6252 | 112 |
685798 | 685798 | 2020-10-31 | Marion | Oregon | 41047 | 6121 | 112 |
682555 | 682555 | 2020-10-30 | Marion | Oregon | 41047 | 6068 | 109 |
679312 | 679312 | 2020-10-29 | Marion | Oregon | 41047 | 6024 | 109 |
676069 | 676069 | 2020-10-28 | Marion | Oregon | 41047 | 5963 | 108 |
672826 | 672826 | 2020-10-27 | Marion | Oregon | 41047 | 5929 | 108 |
669584 | 669584 | 2020-10-26 | Marion | Oregon | 41047 | 5858 | 108 |
666340 | 666340 | 2020-10-25 | Marion | Oregon | 41047 | 5819 | 108 |
663095 | 663095 | 2020-10-24 | Marion | Oregon | 41047 | 5733 | 108 |
659851 | 659851 | 2020-10-23 | Marion | Oregon | 41047 | 5684 | 107 |
656607 | 656607 | 2020-10-22 | Marion | Oregon | 41047 | 5627 | 106 |
653362 | 653362 | 2020-10-21 | Marion | Oregon | 41047 | 5590 | 106 |
650117 | 650117 | 2020-10-20 | Marion | Oregon | 41047 | 5547 | 106 |
646873 | 646873 | 2020-10-19 | Marion | Oregon | 41047 | 5509 | 105 |
643627 | 643627 | 2020-10-18 | Marion | Oregon | 41047 | 5470 | 105 |
640379 | 640379 | 2020-10-17 | Marion | Oregon | 41047 | 5437 | 105 |
637133 | 637133 | 2020-10-16 | Marion | Oregon | 41047 | 5388 | 104 |
633887 | 633887 | 2020-10-15 | Marion | Oregon | 41047 | 5353 | 104 |
630642 | 630642 | 2020-10-14 | Marion | Oregon | 41047 | 5321 | 102 |
627398 | 627398 | 2020-10-13 | Marion | Oregon | 41047 | 5258 | 102 |
624156 | 624156 | 2020-10-12 | Marion | Oregon | 41047 | 5224 | 101 |
620913 | 620913 | 2020-10-11 | Marion | Oregon | 41047 | 5205 | 101 |
617671 | 617671 | 2020-10-10 | Marion | Oregon | 41047 | 5156 | 101 |
614429 | 614429 | 2020-10-09 | Marion | Oregon | 41047 | 5106 | 101 |
611188 | 611188 | 2020-10-08 | Marion | Oregon | 41047 | 5059 | 101 |
607946 | 607946 | 2020-10-07 | Marion | Oregon | 41047 | 5034 | 101 |
604703 | 604703 | 2020-10-06 | Marion | Oregon | 41047 | 5010 | 101 |
601461 | 601461 | 2020-10-05 | Marion | Oregon | 41047 | 4976 | 99 |
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);