ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and fips = 49053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637785 | 637785 | 2020-10-16 | Washington | Utah | 49053 | 4075 | 38 |
634540 | 634540 | 2020-10-15 | Washington | Utah | 49053 | 4034 | 38 |
631295 | 631295 | 2020-10-14 | Washington | Utah | 49053 | 3953 | 38 |
628051 | 628051 | 2020-10-13 | Washington | Utah | 49053 | 3932 | 38 |
624808 | 624808 | 2020-10-12 | Washington | Utah | 49053 | 3878 | 38 |
621565 | 621565 | 2020-10-11 | Washington | Utah | 49053 | 3791 | 35 |
618322 | 618322 | 2020-10-10 | Washington | Utah | 49053 | 3791 | 35 |
615080 | 615080 | 2020-10-09 | Washington | Utah | 49053 | 3726 | 34 |
611839 | 611839 | 2020-10-08 | Washington | Utah | 49053 | 3676 | 34 |
608597 | 608597 | 2020-10-07 | Washington | Utah | 49053 | 3652 | 33 |
605354 | 605354 | 2020-10-06 | Washington | Utah | 49053 | 3605 | 32 |
602112 | 602112 | 2020-10-05 | Washington | Utah | 49053 | 3576 | 32 |
598869 | 598869 | 2020-10-04 | Washington | Utah | 49053 | 3511 | 29 |
595626 | 595626 | 2020-10-03 | Washington | Utah | 49053 | 3511 | 29 |
592384 | 592384 | 2020-10-02 | Washington | Utah | 49053 | 3449 | 29 |
589144 | 589144 | 2020-10-01 | Washington | Utah | 49053 | 3411 | 28 |
585903 | 585903 | 2020-09-30 | Washington | Utah | 49053 | 3370 | 28 |
582663 | 582663 | 2020-09-29 | Washington | Utah | 49053 | 3331 | 27 |
579424 | 579424 | 2020-09-28 | Washington | Utah | 49053 | 3319 | 26 |
576183 | 576183 | 2020-09-27 | Washington | Utah | 49053 | 3292 | 26 |
572939 | 572939 | 2020-09-26 | Washington | Utah | 49053 | 3292 | 26 |
569697 | 569697 | 2020-09-25 | Washington | Utah | 49053 | 3269 | 26 |
566456 | 566456 | 2020-09-24 | Washington | Utah | 49053 | 3212 | 25 |
563215 | 563215 | 2020-09-23 | Washington | Utah | 49053 | 3181 | 25 |
559976 | 559976 | 2020-09-22 | Washington | Utah | 49053 | 3166 | 25 |
556740 | 556740 | 2020-09-21 | Washington | Utah | 49053 | 3146 | 25 |
553503 | 553503 | 2020-09-20 | Washington | Utah | 49053 | 3122 | 25 |
550264 | 550264 | 2020-09-19 | Washington | Utah | 49053 | 3122 | 25 |
547025 | 547025 | 2020-09-18 | Washington | Utah | 49053 | 3098 | 24 |
543788 | 543788 | 2020-09-17 | Washington | Utah | 49053 | 3065 | 24 |
540552 | 540552 | 2020-09-16 | Washington | Utah | 49053 | 3046 | 24 |
537315 | 537315 | 2020-09-15 | Washington | Utah | 49053 | 3029 | 24 |
534079 | 534079 | 2020-09-14 | Washington | Utah | 49053 | 3003 | 24 |
530844 | 530844 | 2020-09-13 | Washington | Utah | 49053 | 2985 | 24 |
527607 | 527607 | 2020-09-12 | Washington | Utah | 49053 | 2985 | 24 |
524371 | 524371 | 2020-09-11 | Washington | Utah | 49053 | 2965 | 24 |
521135 | 521135 | 2020-09-10 | Washington | Utah | 49053 | 2938 | 24 |
517898 | 517898 | 2020-09-09 | Washington | Utah | 49053 | 2932 | 24 |
514663 | 514663 | 2020-09-08 | Washington | Utah | 49053 | 2925 | 23 |
511430 | 511430 | 2020-09-07 | Washington | Utah | 49053 | 2921 | 23 |
508197 | 508197 | 2020-09-06 | Washington | Utah | 49053 | 2896 | 23 |
504965 | 504965 | 2020-09-05 | Washington | Utah | 49053 | 2896 | 23 |
501731 | 501731 | 2020-09-04 | Washington | Utah | 49053 | 2881 | 23 |
498497 | 498497 | 2020-09-03 | Washington | Utah | 49053 | 2860 | 22 |
495264 | 495264 | 2020-09-02 | Washington | Utah | 49053 | 2843 | 22 |
492030 | 492030 | 2020-09-01 | Washington | Utah | 49053 | 2822 | 22 |
488797 | 488797 | 2020-08-31 | Washington | Utah | 49053 | 2812 | 22 |
485564 | 485564 | 2020-08-30 | Washington | Utah | 49053 | 2786 | 22 |
482329 | 482329 | 2020-08-29 | Washington | Utah | 49053 | 2786 | 22 |
479095 | 479095 | 2020-08-28 | Washington | Utah | 49053 | 2764 | 22 |
475862 | 475862 | 2020-08-27 | Washington | Utah | 49053 | 2754 | 22 |
472629 | 472629 | 2020-08-26 | Washington | Utah | 49053 | 2748 | 22 |
469397 | 469397 | 2020-08-25 | Washington | Utah | 49053 | 2735 | 22 |
466168 | 466168 | 2020-08-24 | Washington | Utah | 49053 | 2715 | 21 |
462939 | 462939 | 2020-08-23 | Washington | Utah | 49053 | 2703 | 21 |
459710 | 459710 | 2020-08-22 | Washington | Utah | 49053 | 2703 | 21 |
456483 | 456483 | 2020-08-21 | Washington | Utah | 49053 | 2692 | 21 |
453255 | 453255 | 2020-08-20 | Washington | Utah | 49053 | 2673 | 21 |
450027 | 450027 | 2020-08-19 | Washington | Utah | 49053 | 2653 | 21 |
446799 | 446799 | 2020-08-18 | Washington | Utah | 49053 | 2631 | 21 |
443572 | 443572 | 2020-08-17 | Washington | Utah | 49053 | 2616 | 21 |
440346 | 440346 | 2020-08-16 | Washington | Utah | 49053 | 2591 | 21 |
437120 | 437120 | 2020-08-15 | Washington | Utah | 49053 | 2591 | 21 |
433894 | 433894 | 2020-08-14 | Washington | Utah | 49053 | 2570 | 21 |
430669 | 430669 | 2020-08-13 | Washington | Utah | 49053 | 2552 | 21 |
427441 | 427441 | 2020-08-12 | Washington | Utah | 49053 | 2541 | 21 |
424217 | 424217 | 2020-08-11 | Washington | Utah | 49053 | 2537 | 21 |
420996 | 420996 | 2020-08-10 | Washington | Utah | 49053 | 2522 | 21 |
417775 | 417775 | 2020-08-09 | Washington | Utah | 49053 | 2496 | 20 |
414554 | 414554 | 2020-08-08 | Washington | Utah | 49053 | 2496 | 20 |
411334 | 411334 | 2020-08-07 | Washington | Utah | 49053 | 2473 | 20 |
408115 | 408115 | 2020-08-06 | Washington | Utah | 49053 | 2446 | 20 |
404895 | 404895 | 2020-08-05 | Washington | Utah | 49053 | 2407 | 20 |
401677 | 401677 | 2020-08-04 | Washington | Utah | 49053 | 2383 | 20 |
398461 | 398461 | 2020-08-03 | Washington | Utah | 49053 | 2355 | 20 |
395245 | 395245 | 2020-08-02 | Washington | Utah | 49053 | 2302 | 20 |
392029 | 392029 | 2020-08-01 | Washington | Utah | 49053 | 2302 | 20 |
388812 | 388812 | 2020-07-31 | Washington | Utah | 49053 | 2274 | 20 |
385595 | 385595 | 2020-07-30 | Washington | Utah | 49053 | 2233 | 20 |
382377 | 382377 | 2020-07-29 | Washington | Utah | 49053 | 2215 | 20 |
379160 | 379160 | 2020-07-28 | Washington | Utah | 49053 | 2209 | 20 |
375944 | 375944 | 2020-07-27 | Washington | Utah | 49053 | 2186 | 19 |
372731 | 372731 | 2020-07-26 | Washington | Utah | 49053 | 2151 | 18 |
369519 | 369519 | 2020-07-25 | Washington | Utah | 49053 | 2151 | 18 |
366310 | 366310 | 2020-07-24 | Washington | Utah | 49053 | 2106 | 18 |
363104 | 363104 | 2020-07-23 | Washington | Utah | 49053 | 2046 | 17 |
359897 | 359897 | 2020-07-22 | Washington | Utah | 49053 | 2007 | 17 |
356692 | 356692 | 2020-07-21 | Washington | Utah | 49053 | 1954 | 17 |
353489 | 353489 | 2020-07-20 | Washington | Utah | 49053 | 1905 | 17 |
350287 | 350287 | 2020-07-19 | Washington | Utah | 49053 | 1842 | 17 |
347086 | 347086 | 2020-07-18 | Washington | Utah | 49053 | 1842 | 17 |
343886 | 343886 | 2020-07-17 | Washington | Utah | 49053 | 1799 | 15 |
340687 | 340687 | 2020-07-16 | Washington | Utah | 49053 | 1750 | 7 |
337491 | 337491 | 2020-07-15 | Washington | Utah | 49053 | 1709 | 7 |
334296 | 334296 | 2020-07-14 | Washington | Utah | 49053 | 1701 | 7 |
331103 | 331103 | 2020-07-13 | Washington | Utah | 49053 | 1671 | 7 |
327917 | 327917 | 2020-07-12 | Washington | Utah | 49053 | 1588 | 0 |
324732 | 324732 | 2020-07-11 | Washington | Utah | 49053 | 1588 | 0 |
321551 | 321551 | 2020-07-10 | Washington | Utah | 49053 | 1545 | 0 |
318372 | 318372 | 2020-07-09 | Washington | Utah | 49053 | 1494 | 0 |
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);