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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-02-28 1
- 2020-02-29 1
- 2020-03-01 1
- 2020-03-02 1
- 2020-03-03 1
- 2020-03-04 1
- 2020-03-05 1
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 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);