ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,026 rows where deaths = 0 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sherman 380
- Tillamook 285
- Clatsop 260
- Grant 244
- Hood River 207
- Harney 206
- Coos 200
- Curry 193
- Lake 182
- Gilliam 156
- Jackson 144
- Columbia 139
- Douglas 129
- Deschutes 126
- Klamath 117
- Wallowa 109
- Baker 106
- Jefferson 105
- Union 98
- Crook 97
- Lincoln 89
- Morrow 86
- Wheeler 80
- Malheur 68
- Umatilla 52
- Wasco 31
- Polk 23
- Josephine 21
- Washington 19
- Benton 15
- …
state 1
- Oregon · 4,026 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2166697 | 2166697 | 2022-01-30 | Unknown | Oregon | 1 | 0 | |
2163442 | 2163442 | 2022-01-29 | Unknown | Oregon | 1 | 0 | |
2160187 | 2160187 | 2022-01-28 | Unknown | Oregon | 1 | 0 | |
1747395 | 1747395 | 2021-09-23 | Unknown | Oregon | 1 | 0 | |
1299279 | 1299279 | 2021-05-08 | Unknown | Oregon | 90 | 0 | |
1237587 | 1237587 | 2021-04-19 | Sherman | Oregon | 41055 | 57 | 0 |
1234340 | 1234340 | 2021-04-18 | Sherman | Oregon | 41055 | 57 | 0 |
1231092 | 1231092 | 2021-04-17 | Sherman | Oregon | 41055 | 57 | 0 |
1227844 | 1227844 | 2021-04-16 | Sherman | Oregon | 41055 | 57 | 0 |
1224596 | 1224596 | 2021-04-15 | Sherman | Oregon | 41055 | 57 | 0 |
1221349 | 1221349 | 2021-04-14 | Sherman | Oregon | 41055 | 57 | 0 |
1218101 | 1218101 | 2021-04-13 | Sherman | Oregon | 41055 | 56 | 0 |
1214853 | 1214853 | 2021-04-12 | Sherman | Oregon | 41055 | 56 | 0 |
1211606 | 1211606 | 2021-04-11 | Sherman | Oregon | 41055 | 56 | 0 |
1208357 | 1208357 | 2021-04-10 | Sherman | Oregon | 41055 | 56 | 0 |
1205109 | 1205109 | 2021-04-09 | Sherman | Oregon | 41055 | 56 | 0 |
1201861 | 1201861 | 2021-04-08 | Sherman | Oregon | 41055 | 56 | 0 |
1198612 | 1198612 | 2021-04-07 | Sherman | Oregon | 41055 | 56 | 0 |
1195363 | 1195363 | 2021-04-06 | Sherman | Oregon | 41055 | 54 | 0 |
1192115 | 1192115 | 2021-04-05 | Sherman | Oregon | 41055 | 53 | 0 |
1188866 | 1188866 | 2021-04-04 | Sherman | Oregon | 41055 | 53 | 0 |
1185619 | 1185619 | 2021-04-03 | Sherman | Oregon | 41055 | 53 | 0 |
1182372 | 1182372 | 2021-04-02 | Sherman | Oregon | 41055 | 53 | 0 |
1179125 | 1179125 | 2021-04-01 | Sherman | Oregon | 41055 | 53 | 0 |
1175878 | 1175878 | 2021-03-31 | Sherman | Oregon | 41055 | 53 | 0 |
1172631 | 1172631 | 2021-03-30 | Sherman | Oregon | 41055 | 53 | 0 |
1169384 | 1169384 | 2021-03-29 | Sherman | Oregon | 41055 | 53 | 0 |
1166136 | 1166136 | 2021-03-28 | Sherman | Oregon | 41055 | 53 | 0 |
1162888 | 1162888 | 2021-03-27 | Sherman | Oregon | 41055 | 53 | 0 |
1159639 | 1159639 | 2021-03-26 | Sherman | Oregon | 41055 | 53 | 0 |
1156392 | 1156392 | 2021-03-25 | Sherman | Oregon | 41055 | 53 | 0 |
1153145 | 1153145 | 2021-03-24 | Sherman | Oregon | 41055 | 53 | 0 |
1149898 | 1149898 | 2021-03-23 | Sherman | Oregon | 41055 | 53 | 0 |
1146651 | 1146651 | 2021-03-22 | Sherman | Oregon | 41055 | 53 | 0 |
1143404 | 1143404 | 2021-03-21 | Sherman | Oregon | 41055 | 53 | 0 |
1140157 | 1140157 | 2021-03-20 | Sherman | Oregon | 41055 | 53 | 0 |
1136911 | 1136911 | 2021-03-19 | Sherman | Oregon | 41055 | 53 | 0 |
1133665 | 1133665 | 2021-03-18 | Sherman | Oregon | 41055 | 53 | 0 |
1130417 | 1130417 | 2021-03-17 | Sherman | Oregon | 41055 | 53 | 0 |
1127170 | 1127170 | 2021-03-16 | Sherman | Oregon | 41055 | 53 | 0 |
1123924 | 1123924 | 2021-03-15 | Sherman | Oregon | 41055 | 53 | 0 |
1120678 | 1120678 | 2021-03-14 | Sherman | Oregon | 41055 | 53 | 0 |
1117431 | 1117431 | 2021-03-13 | Sherman | Oregon | 41055 | 53 | 0 |
1114184 | 1114184 | 2021-03-12 | Sherman | Oregon | 41055 | 53 | 0 |
1110938 | 1110938 | 2021-03-11 | Sherman | Oregon | 41055 | 53 | 0 |
1107692 | 1107692 | 2021-03-10 | Sherman | Oregon | 41055 | 53 | 0 |
1104446 | 1104446 | 2021-03-09 | Sherman | Oregon | 41055 | 53 | 0 |
1101200 | 1101200 | 2021-03-08 | Sherman | Oregon | 41055 | 53 | 0 |
1097954 | 1097954 | 2021-03-07 | Sherman | Oregon | 41055 | 53 | 0 |
1094706 | 1094706 | 2021-03-06 | Sherman | Oregon | 41055 | 53 | 0 |
1091460 | 1091460 | 2021-03-05 | Sherman | Oregon | 41055 | 53 | 0 |
1088214 | 1088214 | 2021-03-04 | Sherman | Oregon | 41055 | 53 | 0 |
1084969 | 1084969 | 2021-03-03 | Sherman | Oregon | 41055 | 53 | 0 |
1081723 | 1081723 | 2021-03-02 | Sherman | Oregon | 41055 | 53 | 0 |
1078477 | 1078477 | 2021-03-01 | Sherman | Oregon | 41055 | 53 | 0 |
1075232 | 1075232 | 2021-02-28 | Sherman | Oregon | 41055 | 53 | 0 |
1071986 | 1071986 | 2021-02-27 | Sherman | Oregon | 41055 | 53 | 0 |
1068740 | 1068740 | 2021-02-26 | Sherman | Oregon | 41055 | 53 | 0 |
1065495 | 1065495 | 2021-02-25 | Sherman | Oregon | 41055 | 53 | 0 |
1062250 | 1062250 | 2021-02-24 | Sherman | Oregon | 41055 | 53 | 0 |
1059005 | 1059005 | 2021-02-23 | Sherman | Oregon | 41055 | 52 | 0 |
1055759 | 1055759 | 2021-02-22 | Sherman | Oregon | 41055 | 52 | 0 |
1052513 | 1052513 | 2021-02-21 | Sherman | Oregon | 41055 | 52 | 0 |
1049266 | 1049266 | 2021-02-20 | Sherman | Oregon | 41055 | 52 | 0 |
1046019 | 1046019 | 2021-02-19 | Sherman | Oregon | 41055 | 52 | 0 |
1042774 | 1042774 | 2021-02-18 | Sherman | Oregon | 41055 | 52 | 0 |
1039529 | 1039529 | 2021-02-17 | Sherman | Oregon | 41055 | 52 | 0 |
1036284 | 1036284 | 2021-02-16 | Sherman | Oregon | 41055 | 52 | 0 |
1033039 | 1033039 | 2021-02-15 | Sherman | Oregon | 41055 | 52 | 0 |
1029793 | 1029793 | 2021-02-14 | Sherman | Oregon | 41055 | 52 | 0 |
1026546 | 1026546 | 2021-02-13 | Sherman | Oregon | 41055 | 52 | 0 |
1023301 | 1023301 | 2021-02-12 | Sherman | Oregon | 41055 | 52 | 0 |
1020056 | 1020056 | 2021-02-11 | Sherman | Oregon | 41055 | 52 | 0 |
1016811 | 1016811 | 2021-02-10 | Sherman | Oregon | 41055 | 52 | 0 |
1013566 | 1013566 | 2021-02-09 | Sherman | Oregon | 41055 | 52 | 0 |
1010321 | 1010321 | 2021-02-08 | Sherman | Oregon | 41055 | 52 | 0 |
1007075 | 1007075 | 2021-02-07 | Sherman | Oregon | 41055 | 52 | 0 |
1003829 | 1003829 | 2021-02-06 | Sherman | Oregon | 41055 | 52 | 0 |
1000583 | 1000583 | 2021-02-05 | Sherman | Oregon | 41055 | 52 | 0 |
997337 | 997337 | 2021-02-04 | Sherman | Oregon | 41055 | 52 | 0 |
994091 | 994091 | 2021-02-03 | Sherman | Oregon | 41055 | 52 | 0 |
990845 | 990845 | 2021-02-02 | Sherman | Oregon | 41055 | 52 | 0 |
987599 | 987599 | 2021-02-01 | Sherman | Oregon | 41055 | 49 | 0 |
984352 | 984352 | 2021-01-31 | Sherman | Oregon | 41055 | 49 | 0 |
981105 | 981105 | 2021-01-30 | Sherman | Oregon | 41055 | 49 | 0 |
977859 | 977859 | 2021-01-29 | Sherman | Oregon | 41055 | 49 | 0 |
974614 | 974614 | 2021-01-28 | Sherman | Oregon | 41055 | 48 | 0 |
971369 | 971369 | 2021-01-27 | Sherman | Oregon | 41055 | 48 | 0 |
968124 | 968124 | 2021-01-26 | Sherman | Oregon | 41055 | 48 | 0 |
964880 | 964880 | 2021-01-25 | Sherman | Oregon | 41055 | 47 | 0 |
961635 | 961635 | 2021-01-24 | Sherman | Oregon | 41055 | 47 | 0 |
958390 | 958390 | 2021-01-23 | Sherman | Oregon | 41055 | 47 | 0 |
955144 | 955144 | 2021-01-22 | Sherman | Oregon | 41055 | 47 | 0 |
951899 | 951899 | 2021-01-21 | Sherman | Oregon | 41055 | 47 | 0 |
948654 | 948654 | 2021-01-20 | Sherman | Oregon | 41055 | 47 | 0 |
945408 | 945408 | 2021-01-19 | Sherman | Oregon | 41055 | 47 | 0 |
942161 | 942161 | 2021-01-18 | Sherman | Oregon | 41055 | 47 | 0 |
938916 | 938916 | 2021-01-17 | Sherman | Oregon | 41055 | 47 | 0 |
935671 | 935671 | 2021-01-16 | Sherman | Oregon | 41055 | 47 | 0 |
932426 | 932426 | 2021-01-15 | Sherman | Oregon | 41055 | 47 | 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);