ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Wayne" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922337 | 922337 | 2021-01-12 | Wayne | New York | 36117 | 3352 | 47 |
919092 | 919092 | 2021-01-11 | Wayne | New York | 36117 | 3310 | 46 |
915847 | 915847 | 2021-01-10 | Wayne | New York | 36117 | 3277 | 46 |
912602 | 912602 | 2021-01-09 | Wayne | New York | 36117 | 3192 | 46 |
909357 | 909357 | 2021-01-08 | Wayne | New York | 36117 | 3129 | 46 |
906112 | 906112 | 2021-01-07 | Wayne | New York | 36117 | 3029 | 46 |
902866 | 902866 | 2021-01-06 | Wayne | New York | 36117 | 2942 | 43 |
899621 | 899621 | 2021-01-05 | Wayne | New York | 36117 | 2886 | 43 |
896376 | 896376 | 2021-01-04 | Wayne | New York | 36117 | 2827 | 42 |
893130 | 893130 | 2021-01-03 | Wayne | New York | 36117 | 2768 | 41 |
889884 | 889884 | 2021-01-02 | Wayne | New York | 36117 | 2700 | 39 |
886637 | 886637 | 2021-01-01 | Wayne | New York | 36117 | 2632 | 39 |
883392 | 883392 | 2020-12-31 | Wayne | New York | 36117 | 2559 | 36 |
880147 | 880147 | 2020-12-30 | Wayne | New York | 36117 | 2477 | 35 |
876902 | 876902 | 2020-12-29 | Wayne | New York | 36117 | 2396 | 34 |
873657 | 873657 | 2020-12-28 | Wayne | New York | 36117 | 2352 | 34 |
870412 | 870412 | 2020-12-27 | Wayne | New York | 36117 | 2288 | 34 |
867167 | 867167 | 2020-12-26 | Wayne | New York | 36117 | 2262 | 33 |
863922 | 863922 | 2020-12-25 | Wayne | New York | 36117 | 2219 | 31 |
860677 | 860677 | 2020-12-24 | Wayne | New York | 36117 | 2154 | 31 |
857432 | 857432 | 2020-12-23 | Wayne | New York | 36117 | 2101 | 31 |
854187 | 854187 | 2020-12-22 | Wayne | New York | 36117 | 2047 | 30 |
850942 | 850942 | 2020-12-21 | Wayne | New York | 36117 | 2018 | 30 |
847697 | 847697 | 2020-12-20 | Wayne | New York | 36117 | 1977 | 29 |
844452 | 844452 | 2020-12-19 | Wayne | New York | 36117 | 1937 | 29 |
841206 | 841206 | 2020-12-18 | Wayne | New York | 36117 | 1881 | 28 |
837961 | 837961 | 2020-12-17 | Wayne | New York | 36117 | 1848 | 28 |
834715 | 834715 | 2020-12-16 | Wayne | New York | 36117 | 1790 | 28 |
831469 | 831469 | 2020-12-15 | Wayne | New York | 36117 | 1743 | 28 |
828222 | 828222 | 2020-12-14 | Wayne | New York | 36117 | 1709 | 25 |
824976 | 824976 | 2020-12-13 | Wayne | New York | 36117 | 1662 | 25 |
821729 | 821729 | 2020-12-12 | Wayne | New York | 36117 | 1625 | 23 |
818483 | 818483 | 2020-12-11 | Wayne | New York | 36117 | 1579 | 23 |
815237 | 815237 | 2020-12-10 | Wayne | New York | 36117 | 1532 | 22 |
811992 | 811992 | 2020-12-09 | Wayne | New York | 36117 | 1487 | 21 |
808747 | 808747 | 2020-12-08 | Wayne | New York | 36117 | 1437 | 21 |
805502 | 805502 | 2020-12-07 | Wayne | New York | 36117 | 1418 | 21 |
802257 | 802257 | 2020-12-06 | Wayne | New York | 36117 | 1392 | 19 |
799012 | 799012 | 2020-12-05 | Wayne | New York | 36117 | 1347 | 19 |
795767 | 795767 | 2020-12-04 | Wayne | New York | 36117 | 1300 | 18 |
792522 | 792522 | 2020-12-03 | Wayne | New York | 36117 | 1243 | 18 |
789277 | 789277 | 2020-12-02 | Wayne | New York | 36117 | 1206 | 16 |
786032 | 786032 | 2020-12-01 | Wayne | New York | 36117 | 1175 | 16 |
782788 | 782788 | 2020-11-30 | Wayne | New York | 36117 | 1148 | 15 |
779542 | 779542 | 2020-11-29 | Wayne | New York | 36117 | 1127 | 14 |
776297 | 776297 | 2020-11-28 | Wayne | New York | 36117 | 1095 | 12 |
773052 | 773052 | 2020-11-27 | Wayne | New York | 36117 | 1083 | 12 |
769807 | 769807 | 2020-11-26 | Wayne | New York | 36117 | 1052 | 12 |
766561 | 766561 | 2020-11-25 | Wayne | New York | 36117 | 1012 | 11 |
763316 | 763316 | 2020-11-24 | Wayne | New York | 36117 | 983 | 11 |
760071 | 760071 | 2020-11-23 | Wayne | New York | 36117 | 967 | 11 |
756825 | 756825 | 2020-11-22 | Wayne | New York | 36117 | 912 | 11 |
753578 | 753578 | 2020-11-21 | Wayne | New York | 36117 | 901 | 11 |
750332 | 750332 | 2020-11-20 | Wayne | New York | 36117 | 858 | 11 |
747086 | 747086 | 2020-11-19 | Wayne | New York | 36117 | 854 | 10 |
743840 | 743840 | 2020-11-18 | Wayne | New York | 36117 | 824 | 10 |
740593 | 740593 | 2020-11-17 | Wayne | New York | 36117 | 808 | 10 |
737348 | 737348 | 2020-11-16 | Wayne | New York | 36117 | 780 | 10 |
734104 | 734104 | 2020-11-15 | Wayne | New York | 36117 | 757 | 10 |
730858 | 730858 | 2020-11-14 | Wayne | New York | 36117 | 749 | 10 |
727614 | 727614 | 2020-11-13 | Wayne | New York | 36117 | 735 | 10 |
724370 | 724370 | 2020-11-12 | Wayne | New York | 36117 | 718 | 10 |
721127 | 721127 | 2020-11-11 | Wayne | New York | 36117 | 704 | 10 |
717884 | 717884 | 2020-11-10 | Wayne | New York | 36117 | 689 | 8 |
714641 | 714641 | 2020-11-09 | Wayne | New York | 36117 | 676 | 8 |
711397 | 711397 | 2020-11-08 | Wayne | New York | 36117 | 663 | 6 |
708153 | 708153 | 2020-11-07 | Wayne | New York | 36117 | 655 | 6 |
704910 | 704910 | 2020-11-06 | Wayne | New York | 36117 | 639 | 4 |
701667 | 701667 | 2020-11-05 | Wayne | New York | 36117 | 622 | 4 |
698423 | 698423 | 2020-11-04 | Wayne | New York | 36117 | 602 | 4 |
695180 | 695180 | 2020-11-03 | Wayne | New York | 36117 | 588 | 4 |
691938 | 691938 | 2020-11-02 | Wayne | New York | 36117 | 573 | 4 |
688694 | 688694 | 2020-11-01 | Wayne | New York | 36117 | 561 | 4 |
685449 | 685449 | 2020-10-31 | Wayne | New York | 36117 | 550 | 4 |
682206 | 682206 | 2020-10-30 | Wayne | New York | 36117 | 530 | 4 |
678963 | 678963 | 2020-10-29 | Wayne | New York | 36117 | 512 | 3 |
675720 | 675720 | 2020-10-28 | Wayne | New York | 36117 | 488 | 3 |
672477 | 672477 | 2020-10-27 | Wayne | New York | 36117 | 482 | 3 |
669235 | 669235 | 2020-10-26 | Wayne | New York | 36117 | 471 | 3 |
665991 | 665991 | 2020-10-25 | Wayne | New York | 36117 | 448 | 3 |
662746 | 662746 | 2020-10-24 | Wayne | New York | 36117 | 432 | 3 |
659502 | 659502 | 2020-10-23 | Wayne | New York | 36117 | 408 | 3 |
656258 | 656258 | 2020-10-22 | Wayne | New York | 36117 | 400 | 3 |
653013 | 653013 | 2020-10-21 | Wayne | New York | 36117 | 393 | 3 |
649768 | 649768 | 2020-10-20 | Wayne | New York | 36117 | 386 | 3 |
646524 | 646524 | 2020-10-19 | Wayne | New York | 36117 | 383 | 3 |
643278 | 643278 | 2020-10-18 | Wayne | New York | 36117 | 379 | 3 |
640030 | 640030 | 2020-10-17 | Wayne | New York | 36117 | 377 | 3 |
636784 | 636784 | 2020-10-16 | Wayne | New York | 36117 | 373 | 3 |
633538 | 633538 | 2020-10-15 | Wayne | New York | 36117 | 370 | 3 |
630293 | 630293 | 2020-10-14 | Wayne | New York | 36117 | 367 | 3 |
627049 | 627049 | 2020-10-13 | Wayne | New York | 36117 | 365 | 3 |
623807 | 623807 | 2020-10-12 | Wayne | New York | 36117 | 365 | 3 |
620564 | 620564 | 2020-10-11 | Wayne | New York | 36117 | 362 | 3 |
617322 | 617322 | 2020-10-10 | Wayne | New York | 36117 | 361 | 3 |
614080 | 614080 | 2020-10-09 | Wayne | New York | 36117 | 357 | 3 |
610839 | 610839 | 2020-10-08 | Wayne | New York | 36117 | 347 | 3 |
607597 | 607597 | 2020-10-07 | Wayne | New York | 36117 | 339 | 3 |
604354 | 604354 | 2020-10-06 | Wayne | New York | 36117 | 337 | 3 |
601112 | 601112 | 2020-10-05 | Wayne | New York | 36117 | 335 | 3 |
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);