ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Umatilla" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
254743 | 254743 | 2020-06-19 | Umatilla | Oregon | 41059 | 243 | 4 |
257869 | 257869 | 2020-06-20 | Umatilla | Oregon | 41059 | 243 | 4 |
260996 | 260996 | 2020-06-21 | Umatilla | Oregon | 41059 | 268 | 4 |
264124 | 264124 | 2020-06-22 | Umatilla | Oregon | 41059 | 304 | 4 |
267252 | 267252 | 2020-06-23 | Umatilla | Oregon | 41059 | 334 | 4 |
270386 | 270386 | 2020-06-24 | Umatilla | Oregon | 41059 | 344 | 4 |
273525 | 273525 | 2020-06-25 | Umatilla | Oregon | 41059 | 371 | 4 |
276672 | 276672 | 2020-06-26 | Umatilla | Oregon | 41059 | 428 | 4 |
279820 | 279820 | 2020-06-27 | Umatilla | Oregon | 41059 | 428 | 4 |
282966 | 282966 | 2020-06-28 | Umatilla | Oregon | 41059 | 467 | 4 |
286111 | 286111 | 2020-06-29 | Umatilla | Oregon | 41059 | 497 | 5 |
289262 | 289262 | 2020-06-30 | Umatilla | Oregon | 41059 | 524 | 5 |
292414 | 292414 | 2020-07-01 | Umatilla | Oregon | 41059 | 615 | 5 |
295570 | 295570 | 2020-07-02 | Umatilla | Oregon | 41059 | 664 | 5 |
298729 | 298729 | 2020-07-03 | Umatilla | Oregon | 41059 | 667 | 6 |
301893 | 301893 | 2020-07-04 | Umatilla | Oregon | 41059 | 716 | 6 |
305056 | 305056 | 2020-07-05 | Umatilla | Oregon | 41059 | 757 | 6 |
308223 | 308223 | 2020-07-06 | Umatilla | Oregon | 41059 | 783 | 6 |
311392 | 311392 | 2020-07-07 | Umatilla | Oregon | 41059 | 834 | 7 |
314564 | 314564 | 2020-07-08 | Umatilla | Oregon | 41059 | 882 | 7 |
317737 | 317737 | 2020-07-09 | Umatilla | Oregon | 41059 | 938 | 7 |
320915 | 320915 | 2020-07-10 | Umatilla | Oregon | 41059 | 984 | 7 |
324095 | 324095 | 2020-07-11 | Umatilla | Oregon | 41059 | 987 | 7 |
327280 | 327280 | 2020-07-12 | Umatilla | Oregon | 41059 | 1013 | 7 |
330466 | 330466 | 2020-07-13 | Umatilla | Oregon | 41059 | 1114 | 8 |
333658 | 333658 | 2020-07-14 | Umatilla | Oregon | 41059 | 1139 | 8 |
336852 | 336852 | 2020-07-15 | Umatilla | Oregon | 41059 | 1183 | 8 |
340049 | 340049 | 2020-07-16 | Umatilla | Oregon | 41059 | 1214 | 9 |
343247 | 343247 | 2020-07-17 | Umatilla | Oregon | 41059 | 1261 | 9 |
346447 | 346447 | 2020-07-18 | Umatilla | Oregon | 41059 | 1338 | 9 |
349647 | 349647 | 2020-07-19 | Umatilla | Oregon | 41059 | 1340 | 9 |
352850 | 352850 | 2020-07-20 | Umatilla | Oregon | 41059 | 1434 | 9 |
356053 | 356053 | 2020-07-21 | Umatilla | Oregon | 41059 | 1551 | 11 |
359257 | 359257 | 2020-07-22 | Umatilla | Oregon | 41059 | 1500 | 13 |
362463 | 362463 | 2020-07-23 | Umatilla | Oregon | 41059 | 1548 | 15 |
365669 | 365669 | 2020-07-24 | Umatilla | Oregon | 41059 | 1624 | 16 |
368878 | 368878 | 2020-07-25 | Umatilla | Oregon | 41059 | 1638 | 16 |
372090 | 372090 | 2020-07-26 | Umatilla | Oregon | 41059 | 1678 | 16 |
375303 | 375303 | 2020-07-27 | Umatilla | Oregon | 41059 | 1757 | 16 |
378519 | 378519 | 2020-07-28 | Umatilla | Oregon | 41059 | 1807 | 19 |
381736 | 381736 | 2020-07-29 | Umatilla | Oregon | 41059 | 1886 | 20 |
384954 | 384954 | 2020-07-30 | Umatilla | Oregon | 41059 | 1929 | 22 |
388171 | 388171 | 2020-07-31 | Umatilla | Oregon | 41059 | 1961 | 23 |
391388 | 391388 | 2020-08-01 | Umatilla | Oregon | 41059 | 1977 | 24 |
394604 | 394604 | 2020-08-02 | Umatilla | Oregon | 41059 | 1996 | 24 |
397821 | 397821 | 2020-08-03 | Umatilla | Oregon | 41059 | 2089 | 24 |
401036 | 401036 | 2020-08-04 | Umatilla | Oregon | 41059 | 2122 | 25 |
404254 | 404254 | 2020-08-05 | Umatilla | Oregon | 41059 | 2141 | 27 |
407473 | 407473 | 2020-08-06 | Umatilla | Oregon | 41059 | 2192 | 27 |
410693 | 410693 | 2020-08-07 | Umatilla | Oregon | 41059 | 2243 | 27 |
413913 | 413913 | 2020-08-08 | Umatilla | Oregon | 41059 | 2251 | 28 |
417134 | 417134 | 2020-08-09 | Umatilla | Oregon | 41059 | 2290 | 28 |
420354 | 420354 | 2020-08-10 | Umatilla | Oregon | 41059 | 2302 | 30 |
423577 | 423577 | 2020-08-11 | Umatilla | Oregon | 41059 | 2319 | 31 |
426800 | 426800 | 2020-08-12 | Umatilla | Oregon | 41059 | 2349 | 31 |
430025 | 430025 | 2020-08-13 | Umatilla | Oregon | 41059 | 2377 | 32 |
433251 | 433251 | 2020-08-14 | Umatilla | Oregon | 41059 | 2398 | 32 |
436478 | 436478 | 2020-08-15 | Umatilla | Oregon | 41059 | 2435 | 32 |
439703 | 439703 | 2020-08-16 | Umatilla | Oregon | 41059 | 2450 | 32 |
442930 | 442930 | 2020-08-17 | Umatilla | Oregon | 41059 | 2465 | 32 |
446156 | 446156 | 2020-08-18 | Umatilla | Oregon | 41059 | 2477 | 32 |
449384 | 449384 | 2020-08-19 | Umatilla | Oregon | 41059 | 2495 | 32 |
452612 | 452612 | 2020-08-20 | Umatilla | Oregon | 41059 | 2508 | 32 |
455840 | 455840 | 2020-08-21 | Umatilla | Oregon | 41059 | 2528 | 32 |
459068 | 459068 | 2020-08-22 | Umatilla | Oregon | 41059 | 2530 | 32 |
462296 | 462296 | 2020-08-23 | Umatilla | Oregon | 41059 | 2537 | 32 |
465525 | 465525 | 2020-08-24 | Umatilla | Oregon | 41059 | 2566 | 35 |
468753 | 468753 | 2020-08-25 | Umatilla | Oregon | 41059 | 2587 | 35 |
471985 | 471985 | 2020-08-26 | Umatilla | Oregon | 41059 | 2598 | 35 |
475219 | 475219 | 2020-08-27 | Umatilla | Oregon | 41059 | 2613 | 37 |
478452 | 478452 | 2020-08-28 | Umatilla | Oregon | 41059 | 2631 | 37 |
481686 | 481686 | 2020-08-29 | Umatilla | Oregon | 41059 | 2634 | 37 |
484921 | 484921 | 2020-08-30 | Umatilla | Oregon | 41059 | 2674 | 37 |
488154 | 488154 | 2020-08-31 | Umatilla | Oregon | 41059 | 2690 | 38 |
491387 | 491387 | 2020-09-01 | Umatilla | Oregon | 41059 | 2706 | 38 |
494621 | 494621 | 2020-09-02 | Umatilla | Oregon | 41059 | 2717 | 38 |
497854 | 497854 | 2020-09-03 | Umatilla | Oregon | 41059 | 2741 | 38 |
501088 | 501088 | 2020-09-04 | Umatilla | Oregon | 41059 | 2757 | 39 |
504322 | 504322 | 2020-09-05 | Umatilla | Oregon | 41059 | 2767 | 39 |
507554 | 507554 | 2020-09-06 | Umatilla | Oregon | 41059 | 2781 | 39 |
510787 | 510787 | 2020-09-07 | Umatilla | Oregon | 41059 | 2785 | 39 |
514020 | 514020 | 2020-09-08 | Umatilla | Oregon | 41059 | 2795 | 40 |
517255 | 517255 | 2020-09-09 | Umatilla | Oregon | 41059 | 2802 | 41 |
520491 | 520491 | 2020-09-10 | Umatilla | Oregon | 41059 | 2809 | 41 |
523727 | 523727 | 2020-09-11 | Umatilla | Oregon | 41059 | 2835 | 41 |
526963 | 526963 | 2020-09-12 | Umatilla | Oregon | 41059 | 2839 | 41 |
530200 | 530200 | 2020-09-13 | Umatilla | Oregon | 41059 | 2844 | 41 |
533435 | 533435 | 2020-09-14 | Umatilla | Oregon | 41059 | 2871 | 41 |
536671 | 536671 | 2020-09-15 | Umatilla | Oregon | 41059 | 2874 | 41 |
539908 | 539908 | 2020-09-16 | Umatilla | Oregon | 41059 | 2880 | 41 |
543144 | 543144 | 2020-09-17 | Umatilla | Oregon | 41059 | 2889 | 41 |
546381 | 546381 | 2020-09-18 | Umatilla | Oregon | 41059 | 2904 | 41 |
549620 | 549620 | 2020-09-19 | Umatilla | Oregon | 41059 | 2905 | 41 |
552859 | 552859 | 2020-09-20 | Umatilla | Oregon | 41059 | 2913 | 41 |
556096 | 556096 | 2020-09-21 | Umatilla | Oregon | 41059 | 2920 | 41 |
559333 | 559333 | 2020-09-22 | Umatilla | Oregon | 41059 | 2926 | 41 |
562570 | 562570 | 2020-09-23 | Umatilla | Oregon | 41059 | 2938 | 41 |
565811 | 565811 | 2020-09-24 | Umatilla | Oregon | 41059 | 2943 | 41 |
569052 | 569052 | 2020-09-25 | Umatilla | Oregon | 41059 | 2962 | 41 |
572294 | 572294 | 2020-09-26 | Umatilla | Oregon | 41059 | 2962 | 41 |
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);