ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 18175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921227 | 921227 | 2021-01-12 | Washington | Indiana | 18175 | 1671 | 16 |
917982 | 917982 | 2021-01-11 | Washington | Indiana | 18175 | 1654 | 16 |
914737 | 914737 | 2021-01-10 | Washington | Indiana | 18175 | 1641 | 16 |
911492 | 911492 | 2021-01-09 | Washington | Indiana | 18175 | 1619 | 16 |
908247 | 908247 | 2021-01-08 | Washington | Indiana | 18175 | 1597 | 16 |
905001 | 905001 | 2021-01-07 | Washington | Indiana | 18175 | 1572 | 16 |
901756 | 901756 | 2021-01-06 | Washington | Indiana | 18175 | 1544 | 16 |
898511 | 898511 | 2021-01-05 | Washington | Indiana | 18175 | 1525 | 16 |
895266 | 895266 | 2021-01-04 | Washington | Indiana | 18175 | 1514 | 16 |
892019 | 892019 | 2021-01-03 | Washington | Indiana | 18175 | 1487 | 16 |
888773 | 888773 | 2021-01-02 | Washington | Indiana | 18175 | 1471 | 16 |
885527 | 885527 | 2021-01-01 | Washington | Indiana | 18175 | 1450 | 16 |
882282 | 882282 | 2020-12-31 | Washington | Indiana | 18175 | 1432 | 16 |
879037 | 879037 | 2020-12-30 | Washington | Indiana | 18175 | 1419 | 16 |
875792 | 875792 | 2020-12-29 | Washington | Indiana | 18175 | 1393 | 16 |
872547 | 872547 | 2020-12-28 | Washington | Indiana | 18175 | 1378 | 15 |
869302 | 869302 | 2020-12-27 | Washington | Indiana | 18175 | 1372 | 15 |
866057 | 866057 | 2020-12-26 | Washington | Indiana | 18175 | 1362 | 15 |
862812 | 862812 | 2020-12-25 | Washington | Indiana | 18175 | 1350 | 15 |
859567 | 859567 | 2020-12-24 | Washington | Indiana | 18175 | 1339 | 15 |
856322 | 856322 | 2020-12-23 | Washington | Indiana | 18175 | 1298 | 15 |
853077 | 853077 | 2020-12-22 | Washington | Indiana | 18175 | 1286 | 15 |
849832 | 849832 | 2020-12-21 | Washington | Indiana | 18175 | 1277 | 12 |
846587 | 846587 | 2020-12-20 | Washington | Indiana | 18175 | 1266 | 12 |
843341 | 843341 | 2020-12-19 | Washington | Indiana | 18175 | 1243 | 12 |
840096 | 840096 | 2020-12-18 | Washington | Indiana | 18175 | 1220 | 12 |
836851 | 836851 | 2020-12-17 | Washington | Indiana | 18175 | 1197 | 12 |
833605 | 833605 | 2020-12-16 | Washington | Indiana | 18175 | 1173 | 12 |
830358 | 830358 | 2020-12-15 | Washington | Indiana | 18175 | 1160 | 11 |
827112 | 827112 | 2020-12-14 | Washington | Indiana | 18175 | 1144 | 11 |
823865 | 823865 | 2020-12-13 | Washington | Indiana | 18175 | 1111 | 11 |
820619 | 820619 | 2020-12-12 | Washington | Indiana | 18175 | 1089 | 11 |
817373 | 817373 | 2020-12-11 | Washington | Indiana | 18175 | 1068 | 10 |
814127 | 814127 | 2020-12-10 | Washington | Indiana | 18175 | 1043 | 10 |
810882 | 810882 | 2020-12-09 | Washington | Indiana | 18175 | 1023 | 10 |
807637 | 807637 | 2020-12-08 | Washington | Indiana | 18175 | 1010 | 10 |
804392 | 804392 | 2020-12-07 | Washington | Indiana | 18175 | 984 | 9 |
801147 | 801147 | 2020-12-06 | Washington | Indiana | 18175 | 964 | 9 |
797902 | 797902 | 2020-12-05 | Washington | Indiana | 18175 | 940 | 9 |
794657 | 794657 | 2020-12-04 | Washington | Indiana | 18175 | 916 | 9 |
791412 | 791412 | 2020-12-03 | Washington | Indiana | 18175 | 901 | 9 |
788167 | 788167 | 2020-12-02 | Washington | Indiana | 18175 | 878 | 9 |
784923 | 784923 | 2020-12-01 | Washington | Indiana | 18175 | 865 | 8 |
781678 | 781678 | 2020-11-30 | Washington | Indiana | 18175 | 848 | 7 |
778432 | 778432 | 2020-11-29 | Washington | Indiana | 18175 | 838 | 7 |
775187 | 775187 | 2020-11-28 | Washington | Indiana | 18175 | 826 | 7 |
771942 | 771942 | 2020-11-27 | Washington | Indiana | 18175 | 812 | 7 |
768697 | 768697 | 2020-11-26 | Washington | Indiana | 18175 | 783 | 7 |
765451 | 765451 | 2020-11-25 | Washington | Indiana | 18175 | 752 | 7 |
762206 | 762206 | 2020-11-24 | Washington | Indiana | 18175 | 741 | 7 |
758961 | 758961 | 2020-11-23 | Washington | Indiana | 18175 | 717 | 6 |
755714 | 755714 | 2020-11-22 | Washington | Indiana | 18175 | 696 | 6 |
752468 | 752468 | 2020-11-21 | Washington | Indiana | 18175 | 675 | 6 |
749222 | 749222 | 2020-11-20 | Washington | Indiana | 18175 | 646 | 5 |
745976 | 745976 | 2020-11-19 | Washington | Indiana | 18175 | 620 | 5 |
742729 | 742729 | 2020-11-18 | Washington | Indiana | 18175 | 602 | 5 |
739482 | 739482 | 2020-11-17 | Washington | Indiana | 18175 | 590 | 5 |
736238 | 736238 | 2020-11-16 | Washington | Indiana | 18175 | 581 | 5 |
732992 | 732992 | 2020-11-15 | Washington | Indiana | 18175 | 571 | 5 |
729747 | 729747 | 2020-11-14 | Washington | Indiana | 18175 | 552 | 5 |
726504 | 726504 | 2020-11-13 | Washington | Indiana | 18175 | 542 | 5 |
723261 | 723261 | 2020-11-12 | Washington | Indiana | 18175 | 526 | 5 |
720018 | 720018 | 2020-11-11 | Washington | Indiana | 18175 | 504 | 4 |
716775 | 716775 | 2020-11-10 | Washington | Indiana | 18175 | 496 | 4 |
713531 | 713531 | 2020-11-09 | Washington | Indiana | 18175 | 487 | 4 |
710287 | 710287 | 2020-11-08 | Washington | Indiana | 18175 | 479 | 4 |
707043 | 707043 | 2020-11-07 | Washington | Indiana | 18175 | 471 | 4 |
703800 | 703800 | 2020-11-06 | Washington | Indiana | 18175 | 462 | 4 |
700558 | 700558 | 2020-11-05 | Washington | Indiana | 18175 | 455 | 3 |
697314 | 697314 | 2020-11-04 | Washington | Indiana | 18175 | 447 | 3 |
694072 | 694072 | 2020-11-03 | Washington | Indiana | 18175 | 438 | 3 |
690829 | 690829 | 2020-11-02 | Washington | Indiana | 18175 | 433 | 3 |
687584 | 687584 | 2020-11-01 | Washington | Indiana | 18175 | 428 | 3 |
684340 | 684340 | 2020-10-31 | Washington | Indiana | 18175 | 426 | 3 |
681097 | 681097 | 2020-10-30 | Washington | Indiana | 18175 | 422 | 3 |
677854 | 677854 | 2020-10-29 | Washington | Indiana | 18175 | 414 | 3 |
674611 | 674611 | 2020-10-28 | Washington | Indiana | 18175 | 398 | 3 |
671369 | 671369 | 2020-10-27 | Washington | Indiana | 18175 | 392 | 3 |
668126 | 668126 | 2020-10-26 | Washington | Indiana | 18175 | 387 | 3 |
664882 | 664882 | 2020-10-25 | Washington | Indiana | 18175 | 386 | 3 |
661637 | 661637 | 2020-10-24 | Washington | Indiana | 18175 | 384 | 3 |
658393 | 658393 | 2020-10-23 | Washington | Indiana | 18175 | 378 | 3 |
655148 | 655148 | 2020-10-22 | Washington | Indiana | 18175 | 375 | 3 |
651903 | 651903 | 2020-10-21 | Washington | Indiana | 18175 | 363 | 2 |
648659 | 648659 | 2020-10-20 | Washington | Indiana | 18175 | 359 | 2 |
645414 | 645414 | 2020-10-19 | Washington | Indiana | 18175 | 351 | 2 |
642167 | 642167 | 2020-10-18 | Washington | Indiana | 18175 | 345 | 2 |
638920 | 638920 | 2020-10-17 | Washington | Indiana | 18175 | 342 | 2 |
635674 | 635674 | 2020-10-16 | Washington | Indiana | 18175 | 339 | 2 |
632428 | 632428 | 2020-10-15 | Washington | Indiana | 18175 | 322 | 2 |
629184 | 629184 | 2020-10-14 | Washington | Indiana | 18175 | 317 | 2 |
625941 | 625941 | 2020-10-13 | Washington | Indiana | 18175 | 314 | 2 |
622699 | 622699 | 2020-10-12 | Washington | Indiana | 18175 | 310 | 2 |
619455 | 619455 | 2020-10-11 | Washington | Indiana | 18175 | 308 | 2 |
616213 | 616213 | 2020-10-10 | Washington | Indiana | 18175 | 305 | 2 |
612972 | 612972 | 2020-10-09 | Washington | Indiana | 18175 | 304 | 2 |
609730 | 609730 | 2020-10-08 | Washington | Indiana | 18175 | 298 | 2 |
606487 | 606487 | 2020-10-07 | Washington | Indiana | 18175 | 292 | 2 |
603245 | 603245 | 2020-10-06 | Washington | Indiana | 18175 | 290 | 2 |
600002 | 600002 | 2020-10-05 | Washington | Indiana | 18175 | 288 | 2 |
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);