ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Adams" and fips = 53001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923494 | 923494 | 2021-01-12 | Adams | Washington | 53001 | 1689 | 16 |
920249 | 920249 | 2021-01-11 | Adams | Washington | 53001 | 1689 | 16 |
917004 | 917004 | 2021-01-10 | Adams | Washington | 53001 | 1684 | 16 |
913759 | 913759 | 2021-01-09 | Adams | Washington | 53001 | 1684 | 16 |
910514 | 910514 | 2021-01-08 | Adams | Washington | 53001 | 1675 | 16 |
907269 | 907269 | 2021-01-07 | Adams | Washington | 53001 | 1669 | 16 |
904023 | 904023 | 2021-01-06 | Adams | Washington | 53001 | 1656 | 16 |
900778 | 900778 | 2021-01-05 | Adams | Washington | 53001 | 1647 | 16 |
897533 | 897533 | 2021-01-04 | Adams | Washington | 53001 | 1643 | 16 |
894287 | 894287 | 2021-01-03 | Adams | Washington | 53001 | 1643 | 16 |
891041 | 891041 | 2021-01-02 | Adams | Washington | 53001 | 1627 | 16 |
887794 | 887794 | 2021-01-01 | Adams | Washington | 53001 | 1627 | 16 |
884549 | 884549 | 2020-12-31 | Adams | Washington | 53001 | 1627 | 16 |
881304 | 881304 | 2020-12-30 | Adams | Washington | 53001 | 1611 | 16 |
878059 | 878059 | 2020-12-29 | Adams | Washington | 53001 | 1600 | 16 |
874814 | 874814 | 2020-12-28 | Adams | Washington | 53001 | 1594 | 16 |
871569 | 871569 | 2020-12-27 | Adams | Washington | 53001 | 1595 | 16 |
868324 | 868324 | 2020-12-26 | Adams | Washington | 53001 | 1595 | 16 |
865079 | 865079 | 2020-12-25 | Adams | Washington | 53001 | 1590 | 16 |
861834 | 861834 | 2020-12-24 | Adams | Washington | 53001 | 1590 | 16 |
858589 | 858589 | 2020-12-23 | Adams | Washington | 53001 | 1585 | 16 |
855344 | 855344 | 2020-12-22 | Adams | Washington | 53001 | 1571 | 16 |
852099 | 852099 | 2020-12-21 | Adams | Washington | 53001 | 1573 | 16 |
848854 | 848854 | 2020-12-20 | Adams | Washington | 53001 | 1549 | 16 |
845609 | 845609 | 2020-12-19 | Adams | Washington | 53001 | 1549 | 16 |
842363 | 842363 | 2020-12-18 | Adams | Washington | 53001 | 1548 | 16 |
839118 | 839118 | 2020-12-17 | Adams | Washington | 53001 | 1535 | 16 |
835872 | 835872 | 2020-12-16 | Adams | Washington | 53001 | 1489 | 15 |
832626 | 832626 | 2020-12-15 | Adams | Washington | 53001 | 1489 | 15 |
829379 | 829379 | 2020-12-14 | Adams | Washington | 53001 | 1484 | 13 |
826133 | 826133 | 2020-12-13 | Adams | Washington | 53001 | 1483 | 13 |
822886 | 822886 | 2020-12-12 | Adams | Washington | 53001 | 1481 | 13 |
819640 | 819640 | 2020-12-11 | Adams | Washington | 53001 | 1467 | 13 |
816394 | 816394 | 2020-12-10 | Adams | Washington | 53001 | 1458 | 13 |
813148 | 813148 | 2020-12-09 | Adams | Washington | 53001 | 1442 | 13 |
809904 | 809904 | 2020-12-08 | Adams | Washington | 53001 | 1429 | 12 |
806659 | 806659 | 2020-12-07 | Adams | Washington | 53001 | 1419 | 12 |
803414 | 803414 | 2020-12-06 | Adams | Washington | 53001 | 1391 | 12 |
800169 | 800169 | 2020-12-05 | Adams | Washington | 53001 | 1387 | 12 |
796924 | 796924 | 2020-12-04 | Adams | Washington | 53001 | 1379 | 12 |
793679 | 793679 | 2020-12-03 | Adams | Washington | 53001 | 1369 | 12 |
790434 | 790434 | 2020-12-02 | Adams | Washington | 53001 | 1358 | 12 |
787189 | 787189 | 2020-12-01 | Adams | Washington | 53001 | 1350 | 12 |
783945 | 783945 | 2020-11-30 | Adams | Washington | 53001 | 1347 | 12 |
780700 | 780700 | 2020-11-29 | Adams | Washington | 53001 | 1341 | 12 |
777454 | 777454 | 2020-11-28 | Adams | Washington | 53001 | 1336 | 12 |
774209 | 774209 | 2020-11-27 | Adams | Washington | 53001 | 1332 | 12 |
770964 | 770964 | 2020-11-26 | Adams | Washington | 53001 | 1310 | 12 |
767718 | 767718 | 2020-11-25 | Adams | Washington | 53001 | 1310 | 12 |
764473 | 764473 | 2020-11-24 | Adams | Washington | 53001 | 1303 | 12 |
761228 | 761228 | 2020-11-23 | Adams | Washington | 53001 | 1293 | 12 |
757983 | 757983 | 2020-11-22 | Adams | Washington | 53001 | 1243 | 11 |
754736 | 754736 | 2020-11-21 | Adams | Washington | 53001 | 1243 | 11 |
751490 | 751490 | 2020-11-20 | Adams | Washington | 53001 | 1232 | 11 |
748244 | 748244 | 2020-11-19 | Adams | Washington | 53001 | 1200 | 11 |
744998 | 744998 | 2020-11-18 | Adams | Washington | 53001 | 1162 | 11 |
741751 | 741751 | 2020-11-17 | Adams | Washington | 53001 | 1147 | 11 |
738504 | 738504 | 2020-11-16 | Adams | Washington | 53001 | 1130 | 11 |
735260 | 735260 | 2020-11-15 | Adams | Washington | 53001 | 1122 | 11 |
732014 | 732014 | 2020-11-14 | Adams | Washington | 53001 | 1096 | 11 |
728769 | 728769 | 2020-11-13 | Adams | Washington | 53001 | 1075 | 11 |
725526 | 725526 | 2020-11-12 | Adams | Washington | 53001 | 1030 | 11 |
722283 | 722283 | 2020-11-11 | Adams | Washington | 53001 | 993 | 11 |
719040 | 719040 | 2020-11-10 | Adams | Washington | 53001 | 993 | 11 |
715797 | 715797 | 2020-11-09 | Adams | Washington | 53001 | 991 | 11 |
712553 | 712553 | 2020-11-08 | Adams | Washington | 53001 | 989 | 11 |
709309 | 709309 | 2020-11-07 | Adams | Washington | 53001 | 988 | 11 |
706065 | 706065 | 2020-11-06 | Adams | Washington | 53001 | 987 | 11 |
702822 | 702822 | 2020-11-05 | Adams | Washington | 53001 | 959 | 11 |
699579 | 699579 | 2020-11-04 | Adams | Washington | 53001 | 956 | 11 |
696335 | 696335 | 2020-11-03 | Adams | Washington | 53001 | 943 | 11 |
693093 | 693093 | 2020-11-02 | Adams | Washington | 53001 | 939 | 11 |
689849 | 689849 | 2020-11-01 | Adams | Washington | 53001 | 935 | 11 |
686604 | 686604 | 2020-10-31 | Adams | Washington | 53001 | 935 | 11 |
683361 | 683361 | 2020-10-30 | Adams | Washington | 53001 | 928 | 11 |
680118 | 680118 | 2020-10-29 | Adams | Washington | 53001 | 924 | 11 |
676875 | 676875 | 2020-10-28 | Adams | Washington | 53001 | 922 | 12 |
673632 | 673632 | 2020-10-27 | Adams | Washington | 53001 | 917 | 10 |
670390 | 670390 | 2020-10-26 | Adams | Washington | 53001 | 917 | 10 |
667147 | 667147 | 2020-10-25 | Adams | Washington | 53001 | 913 | 10 |
663902 | 663902 | 2020-10-24 | Adams | Washington | 53001 | 913 | 10 |
660658 | 660658 | 2020-10-23 | Adams | Washington | 53001 | 912 | 10 |
657414 | 657414 | 2020-10-22 | Adams | Washington | 53001 | 912 | 10 |
654169 | 654169 | 2020-10-21 | Adams | Washington | 53001 | 910 | 10 |
650924 | 650924 | 2020-10-20 | Adams | Washington | 53001 | 908 | 10 |
647680 | 647680 | 2020-10-19 | Adams | Washington | 53001 | 909 | 10 |
644434 | 644434 | 2020-10-18 | Adams | Washington | 53001 | 908 | 10 |
641186 | 641186 | 2020-10-17 | Adams | Washington | 53001 | 906 | 10 |
637939 | 637939 | 2020-10-16 | Adams | Washington | 53001 | 902 | 10 |
634694 | 634694 | 2020-10-15 | Adams | Washington | 53001 | 899 | 10 |
631449 | 631449 | 2020-10-14 | Adams | Washington | 53001 | 897 | 10 |
628205 | 628205 | 2020-10-13 | Adams | Washington | 53001 | 897 | 10 |
624962 | 624962 | 2020-10-12 | Adams | Washington | 53001 | 887 | 10 |
621719 | 621719 | 2020-10-11 | Adams | Washington | 53001 | 887 | 10 |
618476 | 618476 | 2020-10-10 | Adams | Washington | 53001 | 887 | 10 |
615234 | 615234 | 2020-10-09 | Adams | Washington | 53001 | 885 | 10 |
611993 | 611993 | 2020-10-08 | Adams | Washington | 53001 | 879 | 10 |
608751 | 608751 | 2020-10-07 | Adams | Washington | 53001 | 878 | 10 |
605508 | 605508 | 2020-10-06 | Adams | Washington | 53001 | 877 | 10 |
602266 | 602266 | 2020-10-05 | Adams | Washington | 53001 | 877 | 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);