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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388175 | 388175 | 2020-07-31 | Washington | Oregon | 41067 | 2740 | 22 |
384958 | 384958 | 2020-07-30 | Washington | Oregon | 41067 | 2700 | 22 |
381740 | 381740 | 2020-07-29 | Washington | Oregon | 41067 | 2638 | 22 |
378523 | 378523 | 2020-07-28 | Washington | Oregon | 41067 | 2583 | 22 |
375307 | 375307 | 2020-07-27 | Washington | Oregon | 41067 | 2553 | 22 |
372094 | 372094 | 2020-07-26 | Washington | Oregon | 41067 | 2496 | 22 |
368882 | 368882 | 2020-07-25 | Washington | Oregon | 41067 | 2457 | 22 |
365673 | 365673 | 2020-07-24 | Washington | Oregon | 41067 | 2408 | 22 |
362467 | 362467 | 2020-07-23 | Washington | Oregon | 41067 | 2354 | 22 |
359261 | 359261 | 2020-07-22 | Washington | Oregon | 41067 | 2319 | 22 |
356057 | 356057 | 2020-07-21 | Washington | Oregon | 41067 | 2276 | 22 |
352854 | 352854 | 2020-07-20 | Washington | Oregon | 41067 | 2248 | 21 |
349651 | 349651 | 2020-07-19 | Washington | Oregon | 41067 | 2210 | 21 |
346451 | 346451 | 2020-07-18 | Washington | Oregon | 41067 | 2152 | 21 |
343251 | 343251 | 2020-07-17 | Washington | Oregon | 41067 | 2106 | 21 |
340053 | 340053 | 2020-07-16 | Washington | Oregon | 41067 | 2071 | 21 |
336856 | 336856 | 2020-07-15 | Washington | Oregon | 41067 | 1995 | 21 |
333662 | 333662 | 2020-07-14 | Washington | Oregon | 41067 | 1946 | 21 |
330470 | 330470 | 2020-07-13 | Washington | Oregon | 41067 | 1892 | 21 |
327284 | 327284 | 2020-07-12 | Washington | Oregon | 41067 | 1847 | 21 |
324099 | 324099 | 2020-07-11 | Washington | Oregon | 41067 | 1815 | 20 |
320919 | 320919 | 2020-07-10 | Washington | Oregon | 41067 | 1764 | 20 |
317741 | 317741 | 2020-07-09 | Washington | Oregon | 41067 | 1720 | 20 |
314568 | 314568 | 2020-07-08 | Washington | Oregon | 41067 | 1676 | 20 |
311396 | 311396 | 2020-07-07 | Washington | Oregon | 41067 | 1645 | 20 |
308227 | 308227 | 2020-07-06 | Washington | Oregon | 41067 | 1620 | 20 |
305060 | 305060 | 2020-07-05 | Washington | Oregon | 41067 | 1586 | 20 |
301897 | 301897 | 2020-07-04 | Washington | Oregon | 41067 | 1534 | 20 |
298733 | 298733 | 2020-07-03 | Washington | Oregon | 41067 | 1491 | 20 |
295574 | 295574 | 2020-07-02 | Washington | Oregon | 41067 | 1446 | 20 |
292418 | 292418 | 2020-07-01 | Washington | Oregon | 41067 | 1379 | 20 |
289266 | 289266 | 2020-06-30 | Washington | Oregon | 41067 | 1331 | 20 |
286115 | 286115 | 2020-06-29 | Washington | Oregon | 41067 | 1315 | 20 |
282970 | 282970 | 2020-06-28 | Washington | Oregon | 41067 | 1287 | 20 |
279824 | 279824 | 2020-06-27 | Washington | Oregon | 41067 | 1258 | 20 |
276676 | 276676 | 2020-06-26 | Washington | Oregon | 41067 | 1252 | 20 |
273529 | 273529 | 2020-06-25 | Washington | Oregon | 41067 | 1175 | 20 |
270390 | 270390 | 2020-06-24 | Washington | Oregon | 41067 | 1151 | 20 |
267256 | 267256 | 2020-06-23 | Washington | Oregon | 41067 | 1120 | 20 |
264128 | 264128 | 2020-06-22 | Washington | Oregon | 41067 | 1078 | 20 |
261000 | 261000 | 2020-06-21 | Washington | Oregon | 41067 | 1051 | 20 |
257873 | 257873 | 2020-06-20 | Washington | Oregon | 41067 | 1029 | 20 |
254747 | 254747 | 2020-06-19 | Washington | Oregon | 41067 | 992 | 20 |
251632 | 251632 | 2020-06-18 | Washington | Oregon | 41067 | 975 | 20 |
248517 | 248517 | 2020-06-17 | Washington | Oregon | 41067 | 950 | 20 |
245404 | 245404 | 2020-06-16 | Washington | Oregon | 41067 | 928 | 20 |
242292 | 242292 | 2020-06-15 | Washington | Oregon | 41067 | 891 | 20 |
239183 | 239183 | 2020-06-14 | Washington | Oregon | 41067 | 876 | 20 |
236075 | 236075 | 2020-06-13 | Washington | Oregon | 41067 | 863 | 20 |
232970 | 232970 | 2020-06-12 | Washington | Oregon | 41067 | 849 | 19 |
229865 | 229865 | 2020-06-11 | Washington | Oregon | 41067 | 828 | 18 |
226761 | 226761 | 2020-06-10 | Washington | Oregon | 41067 | 821 | 18 |
223661 | 223661 | 2020-06-09 | Washington | Oregon | 41067 | 815 | 18 |
220566 | 220566 | 2020-06-08 | Washington | Oregon | 41067 | 800 | 18 |
217474 | 217474 | 2020-06-07 | Washington | Oregon | 41067 | 798 | 18 |
214384 | 214384 | 2020-06-06 | Washington | Oregon | 41067 | 790 | 18 |
211298 | 211298 | 2020-06-05 | Washington | Oregon | 41067 | 775 | 18 |
208216 | 208216 | 2020-06-04 | Washington | Oregon | 41067 | 755 | 18 |
205135 | 205135 | 2020-06-03 | Washington | Oregon | 41067 | 752 | 18 |
202058 | 202058 | 2020-06-02 | Washington | Oregon | 41067 | 747 | 18 |
198983 | 198983 | 2020-06-01 | Washington | Oregon | 41067 | 743 | 17 |
195910 | 195910 | 2020-05-31 | Washington | Oregon | 41067 | 739 | 17 |
192841 | 192841 | 2020-05-30 | Washington | Oregon | 41067 | 734 | 17 |
189776 | 189776 | 2020-05-29 | Washington | Oregon | 41067 | 722 | 17 |
186715 | 186715 | 2020-05-28 | Washington | Oregon | 41067 | 715 | 17 |
183658 | 183658 | 2020-05-27 | Washington | Oregon | 41067 | 703 | 17 |
180608 | 180608 | 2020-05-26 | Washington | Oregon | 41067 | 698 | 17 |
177565 | 177565 | 2020-05-25 | Washington | Oregon | 41067 | 695 | 17 |
174521 | 174521 | 2020-05-24 | Washington | Oregon | 41067 | 690 | 17 |
171479 | 171479 | 2020-05-23 | Washington | Oregon | 41067 | 673 | 17 |
168440 | 168440 | 2020-05-22 | Washington | Oregon | 41067 | 669 | 17 |
165404 | 165404 | 2020-05-21 | Washington | Oregon | 41067 | 659 | 17 |
162375 | 162375 | 2020-05-20 | Washington | Oregon | 41067 | 658 | 17 |
159348 | 159348 | 2020-05-19 | Washington | Oregon | 41067 | 644 | 15 |
156327 | 156327 | 2020-05-18 | Washington | Oregon | 41067 | 638 | 15 |
153310 | 153310 | 2020-05-17 | Washington | Oregon | 41067 | 628 | 15 |
150299 | 150299 | 2020-05-16 | Washington | Oregon | 41067 | 628 | 15 |
147292 | 147292 | 2020-05-15 | Washington | Oregon | 41067 | 620 | 15 |
144291 | 144291 | 2020-05-14 | Washington | Oregon | 41067 | 616 | 15 |
141295 | 141295 | 2020-05-13 | Washington | Oregon | 41067 | 614 | 14 |
138299 | 138299 | 2020-05-12 | Washington | Oregon | 41067 | 601 | 13 |
135309 | 135309 | 2020-05-11 | Washington | Oregon | 41067 | 587 | 13 |
132318 | 132318 | 2020-05-10 | Washington | Oregon | 41067 | 573 | 12 |
129329 | 129329 | 2020-05-09 | Washington | Oregon | 41067 | 562 | 12 |
126340 | 126340 | 2020-05-08 | Washington | Oregon | 41067 | 556 | 12 |
123357 | 123357 | 2020-05-07 | Washington | Oregon | 41067 | 548 | 12 |
120380 | 120380 | 2020-05-06 | Washington | Oregon | 41067 | 537 | 12 |
117418 | 117418 | 2020-05-05 | Washington | Oregon | 41067 | 531 | 12 |
114537 | 114537 | 2020-05-04 | Washington | Oregon | 41067 | 526 | 11 |
111655 | 111655 | 2020-05-03 | Washington | Oregon | 41067 | 516 | 11 |
108781 | 108781 | 2020-05-02 | Washington | Oregon | 41067 | 509 | 11 |
105914 | 105914 | 2020-05-01 | Washington | Oregon | 41067 | 500 | 11 |
103051 | 103051 | 2020-04-30 | Washington | Oregon | 41067 | 491 | 11 |
100198 | 100198 | 2020-04-29 | Washington | Oregon | 41067 | 481 | 11 |
97349 | 97349 | 2020-04-28 | Washington | Oregon | 41067 | 474 | 11 |
94510 | 94510 | 2020-04-27 | Washington | Oregon | 41067 | 475 | 11 |
91683 | 91683 | 2020-04-26 | Washington | Oregon | 41067 | 466 | 10 |
88867 | 88867 | 2020-04-25 | Washington | Oregon | 41067 | 459 | 10 |
86053 | 86053 | 2020-04-24 | Washington | Oregon | 41067 | 451 | 10 |
83249 | 83249 | 2020-04-23 | Washington | Oregon | 41067 | 443 | 10 |
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);