ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Douglas" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923502 | 923502 | 2021-01-12 | Douglas | Washington | 53017 | 2910 | 15 |
920257 | 920257 | 2021-01-11 | Douglas | Washington | 53017 | 2864 | 15 |
917012 | 917012 | 2021-01-10 | Douglas | Washington | 53017 | 2852 | 15 |
913767 | 913767 | 2021-01-09 | Douglas | Washington | 53017 | 2852 | 15 |
910522 | 910522 | 2021-01-08 | Douglas | Washington | 53017 | 2852 | 15 |
907277 | 907277 | 2021-01-07 | Douglas | Washington | 53017 | 2834 | 15 |
904031 | 904031 | 2021-01-06 | Douglas | Washington | 53017 | 2819 | 15 |
900786 | 900786 | 2021-01-05 | Douglas | Washington | 53017 | 2782 | 15 |
897541 | 897541 | 2021-01-04 | Douglas | Washington | 53017 | 2716 | 15 |
894295 | 894295 | 2021-01-03 | Douglas | Washington | 53017 | 2716 | 15 |
891049 | 891049 | 2021-01-02 | Douglas | Washington | 53017 | 2716 | 15 |
887802 | 887802 | 2021-01-01 | Douglas | Washington | 53017 | 2716 | 15 |
884557 | 884557 | 2020-12-31 | Douglas | Washington | 53017 | 2716 | 15 |
881312 | 881312 | 2020-12-30 | Douglas | Washington | 53017 | 2625 | 15 |
878067 | 878067 | 2020-12-29 | Douglas | Washington | 53017 | 2625 | 14 |
874822 | 874822 | 2020-12-28 | Douglas | Washington | 53017 | 2587 | 14 |
871577 | 871577 | 2020-12-27 | Douglas | Washington | 53017 | 2558 | 14 |
868332 | 868332 | 2020-12-26 | Douglas | Washington | 53017 | 2558 | 14 |
865087 | 865087 | 2020-12-25 | Douglas | Washington | 53017 | 2558 | 14 |
861842 | 861842 | 2020-12-24 | Douglas | Washington | 53017 | 2558 | 14 |
858597 | 858597 | 2020-12-23 | Douglas | Washington | 53017 | 2558 | 14 |
855352 | 855352 | 2020-12-22 | Douglas | Washington | 53017 | 2498 | 14 |
852107 | 852107 | 2020-12-21 | Douglas | Washington | 53017 | 2465 | 14 |
848862 | 848862 | 2020-12-20 | Douglas | Washington | 53017 | 2449 | 14 |
845617 | 845617 | 2020-12-19 | Douglas | Washington | 53017 | 2449 | 14 |
842371 | 842371 | 2020-12-18 | Douglas | Washington | 53017 | 2449 | 14 |
839126 | 839126 | 2020-12-17 | Douglas | Washington | 53017 | 2421 | 14 |
835880 | 835880 | 2020-12-16 | Douglas | Washington | 53017 | 2410 | 11 |
832634 | 832634 | 2020-12-15 | Douglas | Washington | 53017 | 2391 | 11 |
829387 | 829387 | 2020-12-14 | Douglas | Washington | 53017 | 2352 | 11 |
826141 | 826141 | 2020-12-13 | Douglas | Washington | 53017 | 2328 | 11 |
822894 | 822894 | 2020-12-12 | Douglas | Washington | 53017 | 2328 | 11 |
819648 | 819648 | 2020-12-11 | Douglas | Washington | 53017 | 2328 | 11 |
816402 | 816402 | 2020-12-10 | Douglas | Washington | 53017 | 2298 | 11 |
813156 | 813156 | 2020-12-09 | Douglas | Washington | 53017 | 2274 | 13 |
809912 | 809912 | 2020-12-08 | Douglas | Washington | 53017 | 2229 | 13 |
806667 | 806667 | 2020-12-07 | Douglas | Washington | 53017 | 2181 | 13 |
803422 | 803422 | 2020-12-06 | Douglas | Washington | 53017 | 2152 | 13 |
800177 | 800177 | 2020-12-05 | Douglas | Washington | 53017 | 2152 | 13 |
796932 | 796932 | 2020-12-04 | Douglas | Washington | 53017 | 2152 | 13 |
793687 | 793687 | 2020-12-03 | Douglas | Washington | 53017 | 2071 | 13 |
790442 | 790442 | 2020-12-02 | Douglas | Washington | 53017 | 2054 | 13 |
787197 | 787197 | 2020-12-01 | Douglas | Washington | 53017 | 2011 | 13 |
783953 | 783953 | 2020-11-30 | Douglas | Washington | 53017 | 1966 | 12 |
780708 | 780708 | 2020-11-29 | Douglas | Washington | 53017 | 1935 | 12 |
777462 | 777462 | 2020-11-28 | Douglas | Washington | 53017 | 1935 | 12 |
774217 | 774217 | 2020-11-27 | Douglas | Washington | 53017 | 1935 | 12 |
770972 | 770972 | 2020-11-26 | Douglas | Washington | 53017 | 1893 | 12 |
767726 | 767726 | 2020-11-25 | Douglas | Washington | 53017 | 1893 | 12 |
764481 | 764481 | 2020-11-24 | Douglas | Washington | 53017 | 1855 | 12 |
761236 | 761236 | 2020-11-23 | Douglas | Washington | 53017 | 1796 | 12 |
757991 | 757991 | 2020-11-22 | Douglas | Washington | 53017 | 1772 | 12 |
754744 | 754744 | 2020-11-21 | Douglas | Washington | 53017 | 1772 | 12 |
751498 | 751498 | 2020-11-20 | Douglas | Washington | 53017 | 1772 | 12 |
748252 | 748252 | 2020-11-19 | Douglas | Washington | 53017 | 1743 | 12 |
745006 | 745006 | 2020-11-18 | Douglas | Washington | 53017 | 1710 | 12 |
741759 | 741759 | 2020-11-17 | Douglas | Washington | 53017 | 1679 | 12 |
738512 | 738512 | 2020-11-16 | Douglas | Washington | 53017 | 1641 | 11 |
735268 | 735268 | 2020-11-15 | Douglas | Washington | 53017 | 1611 | 12 |
732022 | 732022 | 2020-11-14 | Douglas | Washington | 53017 | 1611 | 12 |
728777 | 728777 | 2020-11-13 | Douglas | Washington | 53017 | 1611 | 12 |
725534 | 725534 | 2020-11-12 | Douglas | Washington | 53017 | 1553 | 11 |
722291 | 722291 | 2020-11-11 | Douglas | Washington | 53017 | 1553 | 11 |
719048 | 719048 | 2020-11-10 | Douglas | Washington | 53017 | 1520 | 11 |
715805 | 715805 | 2020-11-09 | Douglas | Washington | 53017 | 1505 | 11 |
712561 | 712561 | 2020-11-08 | Douglas | Washington | 53017 | 1488 | 11 |
709317 | 709317 | 2020-11-07 | Douglas | Washington | 53017 | 1488 | 11 |
706073 | 706073 | 2020-11-06 | Douglas | Washington | 53017 | 1488 | 11 |
702830 | 702830 | 2020-11-05 | Douglas | Washington | 53017 | 1477 | 12 |
699587 | 699587 | 2020-11-04 | Douglas | Washington | 53017 | 1458 | 12 |
696343 | 696343 | 2020-11-03 | Douglas | Washington | 53017 | 1442 | 12 |
693101 | 693101 | 2020-11-02 | Douglas | Washington | 53017 | 1432 | 12 |
689857 | 689857 | 2020-11-01 | Douglas | Washington | 53017 | 1426 | 12 |
686612 | 686612 | 2020-10-31 | Douglas | Washington | 53017 | 1426 | 12 |
683369 | 683369 | 2020-10-30 | Douglas | Washington | 53017 | 1426 | 12 |
680126 | 680126 | 2020-10-29 | Douglas | Washington | 53017 | 1422 | 12 |
676883 | 676883 | 2020-10-28 | Douglas | Washington | 53017 | 1414 | 12 |
673640 | 673640 | 2020-10-27 | Douglas | Washington | 53017 | 1408 | 12 |
670398 | 670398 | 2020-10-26 | Douglas | Washington | 53017 | 1401 | 10 |
667155 | 667155 | 2020-10-25 | Douglas | Washington | 53017 | 1398 | 10 |
663910 | 663910 | 2020-10-24 | Douglas | Washington | 53017 | 1398 | 10 |
660666 | 660666 | 2020-10-23 | Douglas | Washington | 53017 | 1398 | 10 |
657422 | 657422 | 2020-10-22 | Douglas | Washington | 53017 | 1394 | 10 |
654177 | 654177 | 2020-10-21 | Douglas | Washington | 53017 | 1391 | 10 |
650932 | 650932 | 2020-10-20 | Douglas | Washington | 53017 | 1390 | 10 |
647688 | 647688 | 2020-10-19 | Douglas | Washington | 53017 | 1380 | 10 |
644442 | 644442 | 2020-10-18 | Douglas | Washington | 53017 | 1377 | 10 |
641194 | 641194 | 2020-10-17 | Douglas | Washington | 53017 | 1377 | 10 |
637947 | 637947 | 2020-10-16 | Douglas | Washington | 53017 | 1377 | 10 |
634702 | 634702 | 2020-10-15 | Douglas | Washington | 53017 | 1372 | 10 |
631457 | 631457 | 2020-10-14 | Douglas | Washington | 53017 | 1369 | 10 |
628213 | 628213 | 2020-10-13 | Douglas | Washington | 53017 | 1364 | 10 |
624970 | 624970 | 2020-10-12 | Douglas | Washington | 53017 | 1351 | 10 |
621727 | 621727 | 2020-10-11 | Douglas | Washington | 53017 | 1345 | 10 |
618484 | 618484 | 2020-10-10 | Douglas | Washington | 53017 | 1345 | 10 |
615242 | 615242 | 2020-10-09 | Douglas | Washington | 53017 | 1345 | 10 |
612001 | 612001 | 2020-10-08 | Douglas | Washington | 53017 | 1337 | 10 |
608759 | 608759 | 2020-10-07 | Douglas | Washington | 53017 | 1336 | 10 |
605516 | 605516 | 2020-10-06 | Douglas | Washington | 53017 | 1329 | 10 |
602274 | 602274 | 2020-10-05 | Douglas | Washington | 53017 | 1319 | 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);