ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where county = "Marion" and fips = 41047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055755 | 1055755 | 2021-02-22 | Marion | Oregon | 41047 | 18209 | 281 |
1052509 | 1052509 | 2021-02-21 | Marion | Oregon | 41047 | 18183 | 280 |
1049262 | 1049262 | 2021-02-20 | Marion | Oregon | 41047 | 18171 | 280 |
1046015 | 1046015 | 2021-02-19 | Marion | Oregon | 41047 | 18117 | 279 |
1042770 | 1042770 | 2021-02-18 | Marion | Oregon | 41047 | 18075 | 279 |
1039525 | 1039525 | 2021-02-17 | Marion | Oregon | 41047 | 18030 | 278 |
1036280 | 1036280 | 2021-02-16 | Marion | Oregon | 41047 | 18005 | 277 |
1033035 | 1033035 | 2021-02-15 | Marion | Oregon | 41047 | 17981 | 276 |
1029789 | 1029789 | 2021-02-14 | Marion | Oregon | 41047 | 17975 | 276 |
1026542 | 1026542 | 2021-02-13 | Marion | Oregon | 41047 | 17958 | 276 |
1023297 | 1023297 | 2021-02-12 | Marion | Oregon | 41047 | 17929 | 272 |
1020052 | 1020052 | 2021-02-11 | Marion | Oregon | 41047 | 17869 | 270 |
1016807 | 1016807 | 2021-02-10 | Marion | Oregon | 41047 | 17837 | 269 |
1013562 | 1013562 | 2021-02-09 | Marion | Oregon | 41047 | 17798 | 269 |
1010317 | 1010317 | 2021-02-08 | Marion | Oregon | 41047 | 17745 | 268 |
1007071 | 1007071 | 2021-02-07 | Marion | Oregon | 41047 | 17722 | 268 |
1003825 | 1003825 | 2021-02-06 | Marion | Oregon | 41047 | 17681 | 266 |
1000579 | 1000579 | 2021-02-05 | Marion | Oregon | 41047 | 17626 | 266 |
997333 | 997333 | 2021-02-04 | Marion | Oregon | 41047 | 17497 | 266 |
994087 | 994087 | 2021-02-03 | Marion | Oregon | 41047 | 17424 | 264 |
990841 | 990841 | 2021-02-02 | Marion | Oregon | 41047 | 17359 | 263 |
987595 | 987595 | 2021-02-01 | Marion | Oregon | 41047 | 17317 | 259 |
984348 | 984348 | 2021-01-31 | Marion | Oregon | 41047 | 17181 | 259 |
981101 | 981101 | 2021-01-30 | Marion | Oregon | 41047 | 17181 | 259 |
977855 | 977855 | 2021-01-29 | Marion | Oregon | 41047 | 17117 | 256 |
974610 | 974610 | 2021-01-28 | Marion | Oregon | 41047 | 17036 | 255 |
971365 | 971365 | 2021-01-27 | Marion | Oregon | 41047 | 16951 | 255 |
968120 | 968120 | 2021-01-26 | Marion | Oregon | 41047 | 16840 | 250 |
964876 | 964876 | 2021-01-25 | Marion | Oregon | 41047 | 16787 | 248 |
961631 | 961631 | 2021-01-24 | Marion | Oregon | 41047 | 16740 | 248 |
958386 | 958386 | 2021-01-23 | Marion | Oregon | 41047 | 16668 | 247 |
955140 | 955140 | 2021-01-22 | Marion | Oregon | 41047 | 16575 | 246 |
951895 | 951895 | 2021-01-21 | Marion | Oregon | 41047 | 16475 | 242 |
948650 | 948650 | 2021-01-20 | Marion | Oregon | 41047 | 16394 | 242 |
945404 | 945404 | 2021-01-19 | Marion | Oregon | 41047 | 16312 | 239 |
942157 | 942157 | 2021-01-18 | Marion | Oregon | 41047 | 16247 | 239 |
938912 | 938912 | 2021-01-17 | Marion | Oregon | 41047 | 16172 | 238 |
935667 | 935667 | 2021-01-16 | Marion | Oregon | 41047 | 16085 | 238 |
932422 | 932422 | 2021-01-15 | Marion | Oregon | 41047 | 15972 | 233 |
929177 | 929177 | 2021-01-14 | Marion | Oregon | 41047 | 15878 | 233 |
925932 | 925932 | 2021-01-13 | Marion | Oregon | 41047 | 15740 | 233 |
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 |
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);