ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Washington" and fips = 40147 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637106 | 637106 | 2020-10-16 | Washington | Oklahoma | 40147 | 1186 | 41 |
633860 | 633860 | 2020-10-15 | Washington | Oklahoma | 40147 | 1174 | 41 |
630615 | 630615 | 2020-10-14 | Washington | Oklahoma | 40147 | 1153 | 41 |
627371 | 627371 | 2020-10-13 | Washington | Oklahoma | 40147 | 1139 | 41 |
624129 | 624129 | 2020-10-12 | Washington | Oklahoma | 40147 | 1120 | 41 |
620886 | 620886 | 2020-10-11 | Washington | Oklahoma | 40147 | 1118 | 41 |
617644 | 617644 | 2020-10-10 | Washington | Oklahoma | 40147 | 1110 | 41 |
614402 | 614402 | 2020-10-09 | Washington | Oklahoma | 40147 | 1090 | 41 |
611161 | 611161 | 2020-10-08 | Washington | Oklahoma | 40147 | 1073 | 41 |
607919 | 607919 | 2020-10-07 | Washington | Oklahoma | 40147 | 1065 | 41 |
604676 | 604676 | 2020-10-06 | Washington | Oklahoma | 40147 | 1049 | 41 |
601434 | 601434 | 2020-10-05 | Washington | Oklahoma | 40147 | 1041 | 41 |
598191 | 598191 | 2020-10-04 | Washington | Oklahoma | 40147 | 1039 | 41 |
594948 | 594948 | 2020-10-03 | Washington | Oklahoma | 40147 | 1035 | 41 |
591707 | 591707 | 2020-10-02 | Washington | Oklahoma | 40147 | 1018 | 41 |
588466 | 588466 | 2020-10-01 | Washington | Oklahoma | 40147 | 1016 | 40 |
585226 | 585226 | 2020-09-30 | Washington | Oklahoma | 40147 | 1005 | 40 |
581986 | 581986 | 2020-09-29 | Washington | Oklahoma | 40147 | 1000 | 40 |
578746 | 578746 | 2020-09-28 | Washington | Oklahoma | 40147 | 993 | 40 |
575505 | 575505 | 2020-09-27 | Washington | Oklahoma | 40147 | 992 | 40 |
572261 | 572261 | 2020-09-26 | Washington | Oklahoma | 40147 | 989 | 40 |
569019 | 569019 | 2020-09-25 | Washington | Oklahoma | 40147 | 983 | 40 |
565778 | 565778 | 2020-09-24 | Washington | Oklahoma | 40147 | 976 | 40 |
562537 | 562537 | 2020-09-23 | Washington | Oklahoma | 40147 | 967 | 40 |
559300 | 559300 | 2020-09-22 | Washington | Oklahoma | 40147 | 954 | 40 |
556063 | 556063 | 2020-09-21 | Washington | Oklahoma | 40147 | 951 | 40 |
552826 | 552826 | 2020-09-20 | Washington | Oklahoma | 40147 | 952 | 40 |
549587 | 549587 | 2020-09-19 | Washington | Oklahoma | 40147 | 948 | 40 |
546348 | 546348 | 2020-09-18 | Washington | Oklahoma | 40147 | 942 | 40 |
543111 | 543111 | 2020-09-17 | Washington | Oklahoma | 40147 | 939 | 40 |
539875 | 539875 | 2020-09-16 | Washington | Oklahoma | 40147 | 934 | 40 |
536638 | 536638 | 2020-09-15 | Washington | Oklahoma | 40147 | 926 | 40 |
533402 | 533402 | 2020-09-14 | Washington | Oklahoma | 40147 | 916 | 40 |
530167 | 530167 | 2020-09-13 | Washington | Oklahoma | 40147 | 913 | 40 |
526930 | 526930 | 2020-09-12 | Washington | Oklahoma | 40147 | 907 | 40 |
523694 | 523694 | 2020-09-11 | Washington | Oklahoma | 40147 | 899 | 40 |
520458 | 520458 | 2020-09-10 | Washington | Oklahoma | 40147 | 896 | 40 |
517222 | 517222 | 2020-09-09 | Washington | Oklahoma | 40147 | 890 | 40 |
513987 | 513987 | 2020-09-08 | Washington | Oklahoma | 40147 | 888 | 40 |
510754 | 510754 | 2020-09-07 | Washington | Oklahoma | 40147 | 886 | 40 |
507521 | 507521 | 2020-09-06 | Washington | Oklahoma | 40147 | 872 | 40 |
504289 | 504289 | 2020-09-05 | Washington | Oklahoma | 40147 | 863 | 40 |
501055 | 501055 | 2020-09-04 | Washington | Oklahoma | 40147 | 846 | 40 |
497821 | 497821 | 2020-09-03 | Washington | Oklahoma | 40147 | 816 | 40 |
494588 | 494588 | 2020-09-02 | Washington | Oklahoma | 40147 | 803 | 40 |
491354 | 491354 | 2020-09-01 | Washington | Oklahoma | 40147 | 798 | 39 |
488121 | 488121 | 2020-08-31 | Washington | Oklahoma | 40147 | 795 | 39 |
484888 | 484888 | 2020-08-30 | Washington | Oklahoma | 40147 | 790 | 39 |
481653 | 481653 | 2020-08-29 | Washington | Oklahoma | 40147 | 780 | 39 |
478419 | 478419 | 2020-08-28 | Washington | Oklahoma | 40147 | 766 | 39 |
475186 | 475186 | 2020-08-27 | Washington | Oklahoma | 40147 | 761 | 39 |
471952 | 471952 | 2020-08-26 | Washington | Oklahoma | 40147 | 751 | 39 |
468720 | 468720 | 2020-08-25 | Washington | Oklahoma | 40147 | 746 | 39 |
465492 | 465492 | 2020-08-24 | Washington | Oklahoma | 40147 | 744 | 39 |
462263 | 462263 | 2020-08-23 | Washington | Oklahoma | 40147 | 740 | 39 |
459035 | 459035 | 2020-08-22 | Washington | Oklahoma | 40147 | 733 | 39 |
455807 | 455807 | 2020-08-21 | Washington | Oklahoma | 40147 | 729 | 39 |
452579 | 452579 | 2020-08-20 | Washington | Oklahoma | 40147 | 724 | 39 |
449351 | 449351 | 2020-08-19 | Washington | Oklahoma | 40147 | 716 | 39 |
446123 | 446123 | 2020-08-18 | Washington | Oklahoma | 40147 | 711 | 39 |
442897 | 442897 | 2020-08-17 | Washington | Oklahoma | 40147 | 705 | 39 |
439670 | 439670 | 2020-08-16 | Washington | Oklahoma | 40147 | 696 | 39 |
436445 | 436445 | 2020-08-15 | Washington | Oklahoma | 40147 | 690 | 39 |
433218 | 433218 | 2020-08-14 | Washington | Oklahoma | 40147 | 676 | 39 |
429992 | 429992 | 2020-08-13 | Washington | Oklahoma | 40147 | 661 | 39 |
426767 | 426767 | 2020-08-12 | Washington | Oklahoma | 40147 | 647 | 39 |
423544 | 423544 | 2020-08-11 | Washington | Oklahoma | 40147 | 642 | 39 |
420321 | 420321 | 2020-08-10 | Washington | Oklahoma | 40147 | 636 | 39 |
417101 | 417101 | 2020-08-09 | Washington | Oklahoma | 40147 | 632 | 39 |
413880 | 413880 | 2020-08-08 | Washington | Oklahoma | 40147 | 623 | 39 |
410660 | 410660 | 2020-08-07 | Washington | Oklahoma | 40147 | 616 | 39 |
407440 | 407440 | 2020-08-06 | Washington | Oklahoma | 40147 | 606 | 39 |
404221 | 404221 | 2020-08-05 | Washington | Oklahoma | 40147 | 593 | 39 |
401003 | 401003 | 2020-08-04 | Washington | Oklahoma | 40147 | 589 | 39 |
397788 | 397788 | 2020-08-03 | Washington | Oklahoma | 40147 | 575 | 39 |
394571 | 394571 | 2020-08-02 | Washington | Oklahoma | 40147 | 571 | 39 |
391355 | 391355 | 2020-08-01 | Washington | Oklahoma | 40147 | 566 | 39 |
388138 | 388138 | 2020-07-31 | Washington | Oklahoma | 40147 | 557 | 39 |
384921 | 384921 | 2020-07-30 | Washington | Oklahoma | 40147 | 556 | 39 |
381703 | 381703 | 2020-07-29 | Washington | Oklahoma | 40147 | 547 | 39 |
378486 | 378486 | 2020-07-28 | Washington | Oklahoma | 40147 | 540 | 39 |
375270 | 375270 | 2020-07-27 | Washington | Oklahoma | 40147 | 531 | 39 |
372057 | 372057 | 2020-07-26 | Washington | Oklahoma | 40147 | 534 | 39 |
368845 | 368845 | 2020-07-25 | Washington | Oklahoma | 40147 | 526 | 39 |
365636 | 365636 | 2020-07-24 | Washington | Oklahoma | 40147 | 516 | 39 |
362430 | 362430 | 2020-07-23 | Washington | Oklahoma | 40147 | 506 | 39 |
359224 | 359224 | 2020-07-22 | Washington | Oklahoma | 40147 | 505 | 39 |
356020 | 356020 | 2020-07-21 | Washington | Oklahoma | 40147 | 502 | 39 |
352817 | 352817 | 2020-07-20 | Washington | Oklahoma | 40147 | 496 | 39 |
349614 | 349614 | 2020-07-19 | Washington | Oklahoma | 40147 | 490 | 39 |
346414 | 346414 | 2020-07-18 | Washington | Oklahoma | 40147 | 490 | 39 |
343214 | 343214 | 2020-07-17 | Washington | Oklahoma | 40147 | 483 | 39 |
340016 | 340016 | 2020-07-16 | Washington | Oklahoma | 40147 | 479 | 39 |
336819 | 336819 | 2020-07-15 | Washington | Oklahoma | 40147 | 474 | 39 |
333625 | 333625 | 2020-07-14 | Washington | Oklahoma | 40147 | 465 | 39 |
330433 | 330433 | 2020-07-13 | Washington | Oklahoma | 40147 | 449 | 39 |
327247 | 327247 | 2020-07-12 | Washington | Oklahoma | 40147 | 448 | 39 |
324062 | 324062 | 2020-07-11 | Washington | Oklahoma | 40147 | 448 | 39 |
320882 | 320882 | 2020-07-10 | Washington | Oklahoma | 40147 | 445 | 39 |
317704 | 317704 | 2020-07-09 | Washington | Oklahoma | 40147 | 440 | 39 |
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);