ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
806 rows where fips = 41067 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 273 ✖
- 20 29
- 230 21
- 0 19
- 253 19
- 231 14
- 17 13
- 259 13
- 588 13
- 221 12
- 252 12
- 257 12
- 22 11
- 18 10
- 21 9
- 11 8
- 3 7
- 58 7
- 60 7
- 213 7
- 237 7
- 266 7
- 538 7
- 1 6
- 6 6
- 7 6
- 10 6
- 12 6
- 15 6
- 27 6
- 89 6
- 194 6
- 219 6
- 258 6
- 272 6
- 460 6
- 486 6
- 67 5
- 140 5
- 218 5
- 240 5
- 267 5
- 327 5
- 393 5
- 461 5
- 553 5
- 585 5
- 4 4
- 23 4
- 25 4
- 32 4
- 70 4
- 78 4
- 207 4
- 209 4
- 223 4
- 242 4
- 262 4
- 263 4
- 270 4
- 280 4
- 285 4
- 301 4
- 324 4
- 429 4
- 439 4
- 442 4
- 453 4
- 472 4
- 492 4
- 511 4
- 546 4
- 593 4
- 594 4
- 24 3
- 36 3
- 49 3
- 52 3
- 59 3
- 61 3
- 96 3
- 99 3
- 116 3
- 143 3
- 155 3
- 171 3
- 208 3
- 225 3
- 235 3
- 244 3
- 254 3
- 313 3
- 342 3
- 364 3
- 380 3
- 405 3
- 415 3
- 440 3
- 482 3
- 503 3
- 531 3
- 570 3
- 2 2
- 8 2
- 13 2
- 46 2
- 47 2
- 50 2
- 68 2
- 74 2
- 75 2
- 79 2
- 82 2
- 88 2
- 95 2
- 98 2
- 104 2
- 108 2
- 114 2
- 134 2
- 139 2
- 142 2
- 147 2
- 152 2
- 160 2
- 166 2
- 179 2
- 185 2
- 191 2
- 197 2
- 238 2
- 245 2
- 250 2
- 277 2
- 281 2
- 312 2
- 317 2
- 360 2
- 395 2
- 451 2
- 459 2
- 481 2
- 483 2
- 507 2
- 562 2
- 584 2
- 5 1
- 14 1
- 19 1
- 30 1
- 31 1
- 39 1
- 41 1
- 42 1
- 43 1
- 53 1
- 55 1
- 56 1
- 57 1
- 62 1
- 63 1
- 65 1
- 72 1
- 73 1
- 76 1
- 77 1
- 80 1
- 83 1
- 87 1
- 91 1
- 92 1
- 94 1
- 101 1
- 102 1
- 103 1
- 107 1
- 109 1
- 111 1
- 119 1
- 120 1
- 128 1
- 129 1
- 131 1
- 135 1
- 138 1
- 164 1
- 173 1
- 175 1
- 176 1
- 178 1
- 180 1
- 183 1
- 188 1
- 195 1
- 198 1
- 200 1
- 206 1
- 212 1
- 216 1
- 220 1
- 226 1
- 228 1
- 232 1
- 233 1
- 255 1
- 261 1
- 264 1
- 265 1
- 269 1
- 271 1
- 276 1
- 278 1
- 287 1
- 297 1
- 299 1
- 304 1
- 310 1
- 316 1
- 322 1
- 325 1
- 326 1
- 329 1
- 336 1
- 341 1
- 351 1
- 353 1
- 372 1
- 374 1
- 376 1
- 379 1
- 382 1
- 389 1
- 398 1
- 402 1
- 406 1
- 408 1
- 409 1
- 413 1
- 418 1
- 426 1
- 427 1
- 428 1
- 434 1
- 437 1
- 443 1
- 450 1
- 465 1
- 469 1
- 471 1
- 474 1
- 475 1
- 485 1
- 490 1
- 491 1
- 496 1
- 497 1
- 502 1
- 506 1
- 515 1
- 519 1
- 524 1
- 530 1
- 535 1
- 537 1
- 540 1
- 549 1
- 552 1
- 561 1
- 567 1
- 571 1
- 586 1
- 589 1
- 591 1
- 592 1
state 1
- Oregon 806
fips 1
- 41067 · 806 ✖
county 1
- Washington 806
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
370 | 370 | 2020-02-28 | Washington | Oregon | 41067 | 1 | 0 |
392 | 392 | 2020-02-29 | Washington | Oregon | 41067 | 1 | 0 |
418 | 418 | 2020-03-01 | Washington | Oregon | 41067 | 2 | 0 |
450 | 450 | 2020-03-02 | Washington | Oregon | 41067 | 2 | 0 |
485 | 485 | 2020-03-03 | Washington | Oregon | 41067 | 2 | 0 |
522 | 522 | 2020-03-04 | Washington | Oregon | 41067 | 2 | 0 |
569 | 569 | 2020-03-05 | Washington | Oregon | 41067 | 2 | 0 |
634 | 634 | 2020-03-06 | Washington | Oregon | 41067 | 2 | 0 |
725 | 725 | 2020-03-07 | Washington | Oregon | 41067 | 3 | 0 |
834 | 834 | 2020-03-08 | Washington | Oregon | 41067 | 8 | 0 |
962 | 962 | 2020-03-09 | Washington | Oregon | 41067 | 8 | 0 |
1114 | 1114 | 2020-03-10 | Washington | Oregon | 41067 | 8 | 0 |
1307 | 1307 | 2020-03-11 | Washington | Oregon | 41067 | 8 | 0 |
1551 | 1551 | 2020-03-12 | Washington | Oregon | 41067 | 10 | 0 |
1847 | 1847 | 2020-03-13 | Washington | Oregon | 41067 | 10 | 0 |
2208 | 2208 | 2020-03-14 | Washington | Oregon | 41067 | 13 | 0 |
2627 | 2627 | 2020-03-15 | Washington | Oregon | 41067 | 13 | 0 |
3092 | 3092 | 2020-03-16 | Washington | Oregon | 41067 | 14 | 0 |
3621 | 3621 | 2020-03-17 | Washington | Oregon | 41067 | 21 | 0 |
4236 | 4236 | 2020-03-18 | Washington | Oregon | 41067 | 23 | 1 |
4975 | 4975 | 2020-03-19 | Washington | Oregon | 41067 | 25 | 1 |
5844 | 5844 | 2020-03-20 | Washington | Oregon | 41067 | 31 | 1 |
6846 | 6846 | 2020-03-21 | Washington | Oregon | 41067 | 42 | 1 |
7961 | 7961 | 2020-03-22 | Washington | Oregon | 41067 | 55 | 1 |
9171 | 9171 | 2020-03-23 | Washington | Oregon | 41067 | 69 | 1 |
10490 | 10490 | 2020-03-24 | Washington | Oregon | 41067 | 76 | 2 |
11952 | 11952 | 2020-03-25 | Washington | Oregon | 41067 | 96 | 2 |
13570 | 13570 | 2020-03-26 | Washington | Oregon | 41067 | 104 | 3 |
15316 | 15316 | 2020-03-27 | Washington | Oregon | 41067 | 122 | 3 |
17163 | 17163 | 2020-03-28 | Washington | Oregon | 41067 | 140 | 3 |
19101 | 19101 | 2020-03-29 | Washington | Oregon | 41067 | 154 | 3 |
21151 | 21151 | 2020-03-30 | Washington | Oregon | 41067 | 168 | 3 |
23286 | 23286 | 2020-03-31 | Washington | Oregon | 41067 | 186 | 3 |
25484 | 25484 | 2020-04-01 | Washington | Oregon | 41067 | 189 | 3 |
27756 | 27756 | 2020-04-02 | Washington | Oregon | 41067 | 211 | 4 |
30089 | 30089 | 2020-04-03 | Washington | Oregon | 41067 | 228 | 4 |
32479 | 32479 | 2020-04-04 | Washington | Oregon | 41067 | 247 | 4 |
34914 | 34914 | 2020-04-05 | Washington | Oregon | 41067 | 259 | 4 |
37389 | 37389 | 2020-04-06 | Washington | Oregon | 41067 | 271 | 5 |
39910 | 39910 | 2020-04-07 | Washington | Oregon | 41067 | 282 | 6 |
42470 | 42470 | 2020-04-08 | Washington | Oregon | 41067 | 295 | 6 |
45056 | 45056 | 2020-04-09 | Washington | Oregon | 41067 | 311 | 6 |
47673 | 47673 | 2020-04-10 | Washington | Oregon | 41067 | 320 | 6 |
50330 | 50330 | 2020-04-11 | Washington | Oregon | 41067 | 330 | 6 |
53003 | 53003 | 2020-04-12 | Washington | Oregon | 41067 | 348 | 6 |
55688 | 55688 | 2020-04-13 | Washington | Oregon | 41067 | 360 | 7 |
58391 | 58391 | 2020-04-14 | Washington | Oregon | 41067 | 365 | 7 |
61106 | 61106 | 2020-04-15 | Washington | Oregon | 41067 | 364 | 7 |
63832 | 63832 | 2020-04-16 | Washington | Oregon | 41067 | 376 | 7 |
66578 | 66578 | 2020-04-17 | Washington | Oregon | 41067 | 383 | 7 |
69336 | 69336 | 2020-04-18 | Washington | Oregon | 41067 | 387 | 7 |
72103 | 72103 | 2020-04-19 | Washington | Oregon | 41067 | 399 | 8 |
74878 | 74878 | 2020-04-20 | Washington | Oregon | 41067 | 408 | 8 |
77660 | 77660 | 2020-04-21 | Washington | Oregon | 41067 | 415 | 10 |
80450 | 80450 | 2020-04-22 | Washington | Oregon | 41067 | 425 | 10 |
83249 | 83249 | 2020-04-23 | Washington | Oregon | 41067 | 443 | 10 |
86053 | 86053 | 2020-04-24 | Washington | Oregon | 41067 | 451 | 10 |
88867 | 88867 | 2020-04-25 | Washington | Oregon | 41067 | 459 | 10 |
91683 | 91683 | 2020-04-26 | Washington | Oregon | 41067 | 466 | 10 |
94510 | 94510 | 2020-04-27 | Washington | Oregon | 41067 | 475 | 11 |
97349 | 97349 | 2020-04-28 | Washington | Oregon | 41067 | 474 | 11 |
100198 | 100198 | 2020-04-29 | Washington | Oregon | 41067 | 481 | 11 |
103051 | 103051 | 2020-04-30 | Washington | Oregon | 41067 | 491 | 11 |
105914 | 105914 | 2020-05-01 | Washington | Oregon | 41067 | 500 | 11 |
108781 | 108781 | 2020-05-02 | Washington | Oregon | 41067 | 509 | 11 |
111655 | 111655 | 2020-05-03 | Washington | Oregon | 41067 | 516 | 11 |
114537 | 114537 | 2020-05-04 | Washington | Oregon | 41067 | 526 | 11 |
117418 | 117418 | 2020-05-05 | Washington | Oregon | 41067 | 531 | 12 |
120380 | 120380 | 2020-05-06 | Washington | Oregon | 41067 | 537 | 12 |
123357 | 123357 | 2020-05-07 | Washington | Oregon | 41067 | 548 | 12 |
126340 | 126340 | 2020-05-08 | Washington | Oregon | 41067 | 556 | 12 |
129329 | 129329 | 2020-05-09 | Washington | Oregon | 41067 | 562 | 12 |
132318 | 132318 | 2020-05-10 | Washington | Oregon | 41067 | 573 | 12 |
135309 | 135309 | 2020-05-11 | Washington | Oregon | 41067 | 587 | 13 |
138299 | 138299 | 2020-05-12 | Washington | Oregon | 41067 | 601 | 13 |
141295 | 141295 | 2020-05-13 | Washington | Oregon | 41067 | 614 | 14 |
144291 | 144291 | 2020-05-14 | Washington | Oregon | 41067 | 616 | 15 |
147292 | 147292 | 2020-05-15 | Washington | Oregon | 41067 | 620 | 15 |
150299 | 150299 | 2020-05-16 | Washington | Oregon | 41067 | 628 | 15 |
153310 | 153310 | 2020-05-17 | Washington | Oregon | 41067 | 628 | 15 |
156327 | 156327 | 2020-05-18 | Washington | Oregon | 41067 | 638 | 15 |
159348 | 159348 | 2020-05-19 | Washington | Oregon | 41067 | 644 | 15 |
162375 | 162375 | 2020-05-20 | Washington | Oregon | 41067 | 658 | 17 |
165404 | 165404 | 2020-05-21 | Washington | Oregon | 41067 | 659 | 17 |
168440 | 168440 | 2020-05-22 | Washington | Oregon | 41067 | 669 | 17 |
171479 | 171479 | 2020-05-23 | Washington | Oregon | 41067 | 673 | 17 |
174521 | 174521 | 2020-05-24 | Washington | Oregon | 41067 | 690 | 17 |
177565 | 177565 | 2020-05-25 | Washington | Oregon | 41067 | 695 | 17 |
180608 | 180608 | 2020-05-26 | Washington | Oregon | 41067 | 698 | 17 |
183658 | 183658 | 2020-05-27 | Washington | Oregon | 41067 | 703 | 17 |
186715 | 186715 | 2020-05-28 | Washington | Oregon | 41067 | 715 | 17 |
189776 | 189776 | 2020-05-29 | Washington | Oregon | 41067 | 722 | 17 |
192841 | 192841 | 2020-05-30 | Washington | Oregon | 41067 | 734 | 17 |
195910 | 195910 | 2020-05-31 | Washington | Oregon | 41067 | 739 | 17 |
198983 | 198983 | 2020-06-01 | Washington | Oregon | 41067 | 743 | 17 |
202058 | 202058 | 2020-06-02 | Washington | Oregon | 41067 | 747 | 18 |
205135 | 205135 | 2020-06-03 | Washington | Oregon | 41067 | 752 | 18 |
208216 | 208216 | 2020-06-04 | Washington | Oregon | 41067 | 755 | 18 |
211298 | 211298 | 2020-06-05 | Washington | Oregon | 41067 | 775 | 18 |
214384 | 214384 | 2020-06-06 | Washington | Oregon | 41067 | 790 | 18 |
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);