ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 41059 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 617 ✖
- 2 15
- 5 5
- 15087 5
- 8401 4
- 8707 4
- 11795 4
- 15337 4
- 15664 4
- 17891 4
- 22078 4
- 22289 4
- 22369 4
- 4 3
- 8 3
- 16 3
- 85 3
- 116 3
- 7709 3
- 7757 3
- 7816 3
- 7859 3
- 7884 3
- 7917 3
- 7968 3
- 8029 3
- 8089 3
- 8140 3
- 8236 3
- 8328 3
- 8469 3
- 8517 3
- 8593 3
- 8645 3
- 8776 3
- 8935 3
- 9182 3
- 9587 3
- 10030 3
- 10541 3
- 10988 3
- 11398 3
- 12204 3
- 12552 3
- 13006 3
- 13516 3
- 13890 3
- 14241 3
- 14492 3
- 14673 3
- 14820 3
- 14945 3
- 15042 3
- 15144 3
- 15209 3
- 15278 3
- 16525 3
- 19500 3
- 20801 3
- 21573 3
- 21886 3
- 22176 3
- 22243 3
- 22270 3
- 22308 3
- 22327 3
- 22353 3
- 22405 3
- 22433 3
- 22466 3
- 11 2
- 29 2
- 36 2
- 77 2
- 93 2
- 115 2
- 243 2
- 428 2
- 2962 2
- 3158 2
- 7150 2
- 7581 2
- 7871 2
- 14923 2
- 1 1
- 3 1
- 7 1
- 14 1
- 17 1
- 22 1
- 23 1
- 25 1
- 26 1
- 27 1
- 30 1
- 32 1
- 35 1
- 37 1
- 45 1
- 50 1
- 57 1
- 61 1
- 64 1
- 70 1
- 73 1
- 80 1
- 84 1
- 86 1
- 88 1
- 91 1
- 98 1
- 101 1
- 105 1
- 107 1
- 108 1
- 110 1
- 111 1
- 112 1
- 113 1
- 121 1
- 123 1
- 124 1
- 125 1
- 130 1
- 131 1
- 136 1
- 146 1
- 149 1
- 150 1
- 156 1
- 158 1
- 170 1
- 171 1
- 183 1
- 187 1
- 203 1
- 223 1
- 268 1
- 304 1
- 334 1
- 344 1
- 371 1
- 467 1
- 497 1
- 524 1
- 615 1
- 664 1
- 667 1
- 716 1
- 757 1
- 783 1
- 834 1
- 882 1
- 938 1
- 984 1
- 987 1
- 1013 1
- 1114 1
- 1139 1
- 1183 1
- 1214 1
- 1261 1
- 1338 1
- 1340 1
- 1434 1
- 1500 1
- 1548 1
- 1551 1
- 1624 1
- 1638 1
- 1678 1
- 1757 1
- 1807 1
- 1886 1
- 1929 1
- 1961 1
- 1977 1
- 1996 1
- 2089 1
- 2122 1
- 2141 1
- 2192 1
- 2243 1
- 2251 1
- 2290 1
- 2302 1
- 2319 1
- 2349 1
- 2377 1
- 2398 1
- 2435 1
- 2450 1
- 2465 1
- 2477 1
- 2495 1
- 2508 1
- 2528 1
- 2530 1
- 2537 1
- 2566 1
- 2587 1
- 2598 1
- 2613 1
- 2631 1
- 2634 1
- 2674 1
- 2690 1
- 2706 1
- 2717 1
- 2741 1
- 2757 1
- 2767 1
- 2781 1
- 2785 1
- 2795 1
- 2802 1
- 2809 1
- 2835 1
- 2839 1
- 2844 1
- 2871 1
- 2874 1
- 2880 1
- 2889 1
- 2904 1
- 2905 1
- 2913 1
- 2920 1
- 2926 1
- 2938 1
- 2943 1
- 2976 1
- 2988 1
- 3004 1
- 3049 1
- 3055 1
- 3081 1
- 3084 1
- 3095 1
- 3109 1
- 3116 1
- 3132 1
- 3143 1
- 3170 1
- 3187 1
- 3202 1
- 3223 1
- 3236 1
- 3253 1
- 3255 1
- 3258 1
- 3272 1
- 3288 1
- 3307 1
- 3323 1
- 3337 1
- 3344 1
- 3349 1
- 3372 1
- 3389 1
- 3393 1
- 3435 1
- 3461 1
- 3476 1
- 3481 1
- 3493 1
- 3509 1
- 3530 1
- 3556 1
- 3593 1
- 3618 1
- 3642 1
- 3653 1
- 3674 1
- 3705 1
- 3748 1
- 3788 1
- 3827 1
- 3873 1
- 3883 1
- 3924 1
- 3952 1
- 3969 1
- 4013 1
- 4052 1
- 4099 1
- 4156 1
- 4190 1
- 4212 1
- 4256 1
- 4301 1
- 4325 1
- 4343 1
- 4384 1
- 4402 1
- 4468 1
- 4502 1
- 4576 1
- 4622 1
- 4659 1
- 4674 1
- 4714 1
- 4741 1
- 4772 1
- 4810 1
- 4845 1
- 4881 1
- 4904 1
- 4946 1
- 4981 1
- 5014 1
- 5073 1
- 5121 1
- 5164 1
- 5186 1
- 5249 1
- 5268 1
- 5300 1
- 5342 1
- 5379 1
- 5407 1
- 5417 1
- 5441 1
- 5497 1
- 5640 1
- 5697 1
- 5750 1
- 5840 1
- 5863 1
- 5938 1
- 5988 1
- 6146 1
- 6187 1
- 6270 1
- 6304 1
- 6367 1
- 6421 1
- 6470 1
- 6530 1
- 6641 1
- 6709 1
- 6765 1
- 6793 1
- 6803 1
- 6856 1
- 6890 1
- 6941 1
- 6976 1
- 6992 1
- 7011 1
- 7028 1
- 7058 1
- 7082 1
- 7115 1
- 7167 1
- 7191 1
- 7222 1
- 7277 1
- 7307 1
- 7337 1
- 7350 1
- 7355 1
- 7384 1
- 7393 1
- 7420 1
- 7438 1
- 7453 1
- 7458 1
- 7461 1
- 7465 1
- 7475 1
- 7496 1
- 7508 1
- 7580 1
- 7600 1
- 7614 1
- 7631 1
- 7639 1
- 7651 1
- 7659 1
- 7660 1
- 7671 1
- 7678 1
- 7696 1
- 7707 1
- 7726 1
- 7732 1
- 7745 1
- 7748 1
- 7775 1
- 7788 1
- 7795 1
- 7809 1
- 7826 1
- 7833 1
- 7844 1
- 7851 1
- 7868 1
- 7878 1
- 7893 1
- 7898 1
- 7904 1
- 7914 1
- 7926 1
- 7935 1
- 7944 1
- 7953 1
- 7984 1
- 8000 1
- 8008 1
- 8021 1
- 8044 1
- 8061 1
- 8071 1
- 8080 1
- 8104 1
- 8112 1
- 8121 1
- 8131 1
- 8166 1
- 8185 1
- 8202 1
- 8219 1
- 8262 1
- 8271 1
- 8294 1
- 8317 1
- 8349 1
- 8355 1
- 8372 1
- 8388 1
- 8427 1
- 8442 1
- 8454 1
- 8482 1
- 8489 1
- 8497 1
- 8507 1
- 8531 1
- 8544 1
- 8564 1
- 8592 1
- 8609 1
- 8616 1
- 8627 1
- 8641 1
- 8666 1
- 8689 1
- 8700 1
- 8720 1
- 8740 1
- 8760 1
- 8815 1
- 8845 1
- 8874 1
- 8906 1
- 8958 1
- 9031 1
- 9079 1
- 9149 1
- 9232 1
- 9342 1
- 9396 1
- 9505 1
- 9700 1
- 9798 1
- 9883 1
- 9970 1
- 10115 1
- 10217 1
- 10337 1
- 10458 1
- 10647 1
- 10730 1
- 10815 1
- 10884 1
- 11057 1
- 11144 1
- 11213 1
- 11324 1
- 11476 1
- 11562 1
- 11640 1
- 11724 1
- 11885 1
- 11999 1
- 12118 1
- 12289 1
- 12366 1
- 12424 1
- 12487 1
- 12602 1
- 12736 1
- 12808 1
- 12914 1
- 13107 1
- 13275 1
- 13356 1
- 13457 1
- 13596 1
- 13708 1
- 13763 1
- 13834 1
- 13985 1
- 14081 1
- 14139 1
- 14214 1
- 14286 1
- 14358 1
- 14401 1
- 14451 1
- 14521 1
- 14567 1
- 14616 1
- 14645 1
- 14696 1
- 14728 1
- 14758 1
- 14785 1
- 14849 1
- 14896 1
- 14973 1
- 14994 1
- 15004 1
- 15020 1
- 15057 1
- 15072 1
- 15098 1
- 15126 1
- 15135 1
- 15141 1
- 15155 1
- 15178 1
- 15191 1
- 15198 1
- 15217 1
- 15239 1
- 15254 1
- 15268 1
- 15287 1
- 15299 1
- 15312 1
- 15373 1
- 15452 1
- 15542 1
- 15725 1
- 15834 1
- 16051 1
- 16357 1
- 16738 1
- 17052 1
- 17375 1
- 17642 1
- 18593 1
- 18893 1
- 19183 1
- 20036 1
- 20245 1
- 20443 1
- 20623 1
- 21069 1
- 21164 1
- 21278 1
- 21465 1
- 21672 1
- 21739 1
- 21785 1
- 21848 1
- 21945 1
- 21995 1
- 22019 1
- 22047 1
- 22132 1
- 22153 1
- 22163 1
- 22190 1
- 22206 1
- 22224 1
- 22229 1
- 22256 1
- 22258 1
- 22266 1
- 22267 1
- 22278 1
- 22285 1
- 22287 1
- 22290 1
- 22295 1
- 22296 1
- 22307 1
- 22312 1
- 22314 1
- 22317 1
- 22320 1
- 22330 1
- 22335 1
- 22344 1
- 22347 1
- 22359 1
- 22361 1
- 22362 1
- 22366 1
- 22383 1
- 22392 1
- 22398 1
- 22411 1
- 22414 1
- 22419 1
- 22429 1
- 22435 1
- 22446 1
- 22452 1
- 22462 1
- 22501 1
- 22512 1
- 22518 1
- 22532 1
- 22545 1
state 1
- Oregon 794
fips 1
- 41059 · 794 ✖
county 1
- Umatilla 794
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1306 | 1306 | 2020-03-11 | Umatilla | Oregon | 41059 | 1 | 0 |
1550 | 1550 | 2020-03-12 | Umatilla | Oregon | 41059 | 2 | 0 |
1846 | 1846 | 2020-03-13 | Umatilla | Oregon | 41059 | 2 | 0 |
2207 | 2207 | 2020-03-14 | Umatilla | Oregon | 41059 | 2 | 0 |
2626 | 2626 | 2020-03-15 | Umatilla | Oregon | 41059 | 2 | 0 |
3091 | 3091 | 2020-03-16 | Umatilla | Oregon | 41059 | 2 | 0 |
3620 | 3620 | 2020-03-17 | Umatilla | Oregon | 41059 | 2 | 0 |
4235 | 4235 | 2020-03-18 | Umatilla | Oregon | 41059 | 2 | 0 |
4974 | 4974 | 2020-03-19 | Umatilla | Oregon | 41059 | 2 | 0 |
5842 | 5842 | 2020-03-20 | Umatilla | Oregon | 41059 | 2 | 0 |
6844 | 6844 | 2020-03-21 | Umatilla | Oregon | 41059 | 2 | 0 |
7959 | 7959 | 2020-03-22 | Umatilla | Oregon | 41059 | 2 | 0 |
9169 | 9169 | 2020-03-23 | Umatilla | Oregon | 41059 | 2 | 0 |
10488 | 10488 | 2020-03-24 | Umatilla | Oregon | 41059 | 2 | 0 |
11950 | 11950 | 2020-03-25 | Umatilla | Oregon | 41059 | 2 | 0 |
13567 | 13567 | 2020-03-26 | Umatilla | Oregon | 41059 | 2 | 0 |
15313 | 15313 | 2020-03-27 | Umatilla | Oregon | 41059 | 3 | 0 |
17160 | 17160 | 2020-03-28 | Umatilla | Oregon | 41059 | 4 | 0 |
19098 | 19098 | 2020-03-29 | Umatilla | Oregon | 41059 | 4 | 0 |
21148 | 21148 | 2020-03-30 | Umatilla | Oregon | 41059 | 4 | 0 |
23282 | 23282 | 2020-03-31 | Umatilla | Oregon | 41059 | 5 | 0 |
25480 | 25480 | 2020-04-01 | Umatilla | Oregon | 41059 | 5 | 0 |
27752 | 27752 | 2020-04-02 | Umatilla | Oregon | 41059 | 5 | 0 |
30085 | 30085 | 2020-04-03 | Umatilla | Oregon | 41059 | 5 | 0 |
32475 | 32475 | 2020-04-04 | Umatilla | Oregon | 41059 | 5 | 0 |
34910 | 34910 | 2020-04-05 | Umatilla | Oregon | 41059 | 7 | 0 |
37385 | 37385 | 2020-04-06 | Umatilla | Oregon | 41059 | 8 | 0 |
39906 | 39906 | 2020-04-07 | Umatilla | Oregon | 41059 | 8 | 0 |
42466 | 42466 | 2020-04-08 | Umatilla | Oregon | 41059 | 8 | 0 |
45052 | 45052 | 2020-04-09 | Umatilla | Oregon | 41059 | 11 | 0 |
47669 | 47669 | 2020-04-10 | Umatilla | Oregon | 41059 | 11 | 0 |
50326 | 50326 | 2020-04-11 | Umatilla | Oregon | 41059 | 14 | 0 |
52999 | 52999 | 2020-04-12 | Umatilla | Oregon | 41059 | 16 | 0 |
55684 | 55684 | 2020-04-13 | Umatilla | Oregon | 41059 | 16 | 0 |
58387 | 58387 | 2020-04-14 | Umatilla | Oregon | 41059 | 16 | 0 |
61102 | 61102 | 2020-04-15 | Umatilla | Oregon | 41059 | 17 | 0 |
63828 | 63828 | 2020-04-16 | Umatilla | Oregon | 41059 | 22 | 0 |
66574 | 66574 | 2020-04-17 | Umatilla | Oregon | 41059 | 23 | 0 |
69332 | 69332 | 2020-04-18 | Umatilla | Oregon | 41059 | 25 | 0 |
72099 | 72099 | 2020-04-19 | Umatilla | Oregon | 41059 | 26 | 0 |
74874 | 74874 | 2020-04-20 | Umatilla | Oregon | 41059 | 27 | 0 |
77656 | 77656 | 2020-04-21 | Umatilla | Oregon | 41059 | 29 | 0 |
80446 | 80446 | 2020-04-22 | Umatilla | Oregon | 41059 | 29 | 0 |
83245 | 83245 | 2020-04-23 | Umatilla | Oregon | 41059 | 30 | 0 |
86049 | 86049 | 2020-04-24 | Umatilla | Oregon | 41059 | 32 | 0 |
88863 | 88863 | 2020-04-25 | Umatilla | Oregon | 41059 | 35 | 0 |
91679 | 91679 | 2020-04-26 | Umatilla | Oregon | 41059 | 36 | 0 |
94506 | 94506 | 2020-04-27 | Umatilla | Oregon | 41059 | 36 | 0 |
97345 | 97345 | 2020-04-28 | Umatilla | Oregon | 41059 | 37 | 0 |
100194 | 100194 | 2020-04-29 | Umatilla | Oregon | 41059 | 45 | 0 |
103047 | 103047 | 2020-04-30 | Umatilla | Oregon | 41059 | 50 | 0 |
105910 | 105910 | 2020-05-01 | Umatilla | Oregon | 41059 | 57 | 0 |
108777 | 108777 | 2020-05-02 | Umatilla | Oregon | 41059 | 61 | 1 |
111651 | 111651 | 2020-05-03 | Umatilla | Oregon | 41059 | 64 | 1 |
114533 | 114533 | 2020-05-04 | Umatilla | Oregon | 41059 | 70 | 1 |
117414 | 117414 | 2020-05-05 | Umatilla | Oregon | 41059 | 73 | 1 |
120376 | 120376 | 2020-05-06 | Umatilla | Oregon | 41059 | 77 | 1 |
123353 | 123353 | 2020-05-07 | Umatilla | Oregon | 41059 | 77 | 1 |
126336 | 126336 | 2020-05-08 | Umatilla | Oregon | 41059 | 80 | 1 |
129325 | 129325 | 2020-05-09 | Umatilla | Oregon | 41059 | 84 | 1 |
132314 | 132314 | 2020-05-10 | Umatilla | Oregon | 41059 | 85 | 1 |
135305 | 135305 | 2020-05-11 | Umatilla | Oregon | 41059 | 85 | 2 |
138295 | 138295 | 2020-05-12 | Umatilla | Oregon | 41059 | 85 | 2 |
141291 | 141291 | 2020-05-13 | Umatilla | Oregon | 41059 | 86 | 2 |
144287 | 144287 | 2020-05-14 | Umatilla | Oregon | 41059 | 88 | 2 |
147288 | 147288 | 2020-05-15 | Umatilla | Oregon | 41059 | 91 | 2 |
150295 | 150295 | 2020-05-16 | Umatilla | Oregon | 41059 | 93 | 2 |
153306 | 153306 | 2020-05-17 | Umatilla | Oregon | 41059 | 93 | 2 |
156323 | 156323 | 2020-05-18 | Umatilla | Oregon | 41059 | 98 | 2 |
159344 | 159344 | 2020-05-19 | Umatilla | Oregon | 41059 | 101 | 3 |
162371 | 162371 | 2020-05-20 | Umatilla | Oregon | 41059 | 105 | 3 |
165400 | 165400 | 2020-05-21 | Umatilla | Oregon | 41059 | 107 | 3 |
168436 | 168436 | 2020-05-22 | Umatilla | Oregon | 41059 | 108 | 3 |
171475 | 171475 | 2020-05-23 | Umatilla | Oregon | 41059 | 110 | 3 |
174517 | 174517 | 2020-05-24 | Umatilla | Oregon | 41059 | 111 | 3 |
177561 | 177561 | 2020-05-25 | Umatilla | Oregon | 41059 | 112 | 3 |
180604 | 180604 | 2020-05-26 | Umatilla | Oregon | 41059 | 113 | 3 |
183654 | 183654 | 2020-05-27 | Umatilla | Oregon | 41059 | 115 | 3 |
186711 | 186711 | 2020-05-28 | Umatilla | Oregon | 41059 | 115 | 3 |
189772 | 189772 | 2020-05-29 | Umatilla | Oregon | 41059 | 116 | 3 |
192837 | 192837 | 2020-05-30 | Umatilla | Oregon | 41059 | 116 | 3 |
195906 | 195906 | 2020-05-31 | Umatilla | Oregon | 41059 | 116 | 3 |
198979 | 198979 | 2020-06-01 | Umatilla | Oregon | 41059 | 121 | 3 |
202054 | 202054 | 2020-06-02 | Umatilla | Oregon | 41059 | 124 | 3 |
205131 | 205131 | 2020-06-03 | Umatilla | Oregon | 41059 | 123 | 3 |
208212 | 208212 | 2020-06-04 | Umatilla | Oregon | 41059 | 125 | 3 |
211294 | 211294 | 2020-06-05 | Umatilla | Oregon | 41059 | 130 | 3 |
214380 | 214380 | 2020-06-06 | Umatilla | Oregon | 41059 | 131 | 3 |
217470 | 217470 | 2020-06-07 | Umatilla | Oregon | 41059 | 136 | 3 |
220562 | 220562 | 2020-06-08 | Umatilla | Oregon | 41059 | 146 | 3 |
223657 | 223657 | 2020-06-09 | Umatilla | Oregon | 41059 | 149 | 3 |
226757 | 226757 | 2020-06-10 | Umatilla | Oregon | 41059 | 150 | 3 |
229861 | 229861 | 2020-06-11 | Umatilla | Oregon | 41059 | 156 | 3 |
232966 | 232966 | 2020-06-12 | Umatilla | Oregon | 41059 | 158 | 4 |
236071 | 236071 | 2020-06-13 | Umatilla | Oregon | 41059 | 170 | 4 |
239179 | 239179 | 2020-06-14 | Umatilla | Oregon | 41059 | 171 | 4 |
242288 | 242288 | 2020-06-15 | Umatilla | Oregon | 41059 | 183 | 4 |
245400 | 245400 | 2020-06-16 | Umatilla | Oregon | 41059 | 187 | 4 |
248513 | 248513 | 2020-06-17 | Umatilla | Oregon | 41059 | 203 | 4 |
251628 | 251628 | 2020-06-18 | Umatilla | Oregon | 41059 | 223 | 4 |
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);