ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Wayne" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922762 | 922762 | 2021-01-12 | Wayne | Pennsylvania | 42127 | 2281 | 28 |
919517 | 919517 | 2021-01-11 | Wayne | Pennsylvania | 42127 | 2257 | 27 |
916272 | 916272 | 2021-01-10 | Wayne | Pennsylvania | 42127 | 2232 | 25 |
913027 | 913027 | 2021-01-09 | Wayne | Pennsylvania | 42127 | 2197 | 24 |
909782 | 909782 | 2021-01-08 | Wayne | Pennsylvania | 42127 | 2167 | 22 |
906537 | 906537 | 2021-01-07 | Wayne | Pennsylvania | 42127 | 2111 | 21 |
903291 | 903291 | 2021-01-06 | Wayne | Pennsylvania | 42127 | 2046 | 19 |
900046 | 900046 | 2021-01-05 | Wayne | Pennsylvania | 42127 | 2029 | 19 |
896801 | 896801 | 2021-01-04 | Wayne | Pennsylvania | 42127 | 1971 | 18 |
893555 | 893555 | 2021-01-03 | Wayne | Pennsylvania | 42127 | 1968 | 18 |
890309 | 890309 | 2021-01-02 | Wayne | Pennsylvania | 42127 | 1951 | 18 |
887062 | 887062 | 2021-01-01 | Wayne | Pennsylvania | 42127 | 1867 | 18 |
883817 | 883817 | 2020-12-31 | Wayne | Pennsylvania | 42127 | 1829 | 18 |
880572 | 880572 | 2020-12-30 | Wayne | Pennsylvania | 42127 | 1796 | 18 |
877327 | 877327 | 2020-12-29 | Wayne | Pennsylvania | 42127 | 1720 | 18 |
874082 | 874082 | 2020-12-28 | Wayne | Pennsylvania | 42127 | 1698 | 17 |
870837 | 870837 | 2020-12-27 | Wayne | Pennsylvania | 42127 | 1689 | 17 |
867592 | 867592 | 2020-12-26 | Wayne | Pennsylvania | 42127 | 1665 | 17 |
864347 | 864347 | 2020-12-25 | Wayne | Pennsylvania | 42127 | 1587 | 17 |
861102 | 861102 | 2020-12-24 | Wayne | Pennsylvania | 42127 | 1504 | 16 |
857857 | 857857 | 2020-12-23 | Wayne | Pennsylvania | 42127 | 1443 | 15 |
854612 | 854612 | 2020-12-22 | Wayne | Pennsylvania | 42127 | 1367 | 15 |
851367 | 851367 | 2020-12-21 | Wayne | Pennsylvania | 42127 | 1358 | 15 |
848122 | 848122 | 2020-12-20 | Wayne | Pennsylvania | 42127 | 1288 | 15 |
844877 | 844877 | 2020-12-19 | Wayne | Pennsylvania | 42127 | 1274 | 15 |
841631 | 841631 | 2020-12-18 | Wayne | Pennsylvania | 42127 | 1241 | 15 |
838386 | 838386 | 2020-12-17 | Wayne | Pennsylvania | 42127 | 1209 | 15 |
835140 | 835140 | 2020-12-16 | Wayne | Pennsylvania | 42127 | 1175 | 15 |
831894 | 831894 | 2020-12-15 | Wayne | Pennsylvania | 42127 | 1092 | 15 |
828647 | 828647 | 2020-12-14 | Wayne | Pennsylvania | 42127 | 1073 | 14 |
825401 | 825401 | 2020-12-13 | Wayne | Pennsylvania | 42127 | 971 | 14 |
822154 | 822154 | 2020-12-12 | Wayne | Pennsylvania | 42127 | 893 | 14 |
818908 | 818908 | 2020-12-11 | Wayne | Pennsylvania | 42127 | 854 | 13 |
815662 | 815662 | 2020-12-10 | Wayne | Pennsylvania | 42127 | 772 | 13 |
812416 | 812416 | 2020-12-09 | Wayne | Pennsylvania | 42127 | 746 | 13 |
809172 | 809172 | 2020-12-08 | Wayne | Pennsylvania | 42127 | 721 | 13 |
805927 | 805927 | 2020-12-07 | Wayne | Pennsylvania | 42127 | 711 | 12 |
802682 | 802682 | 2020-12-06 | Wayne | Pennsylvania | 42127 | 705 | 12 |
799437 | 799437 | 2020-12-05 | Wayne | Pennsylvania | 42127 | 668 | 12 |
796192 | 796192 | 2020-12-04 | Wayne | Pennsylvania | 42127 | 640 | 12 |
792947 | 792947 | 2020-12-03 | Wayne | Pennsylvania | 42127 | 605 | 12 |
789702 | 789702 | 2020-12-02 | Wayne | Pennsylvania | 42127 | 585 | 12 |
786457 | 786457 | 2020-12-01 | Wayne | Pennsylvania | 42127 | 569 | 12 |
783213 | 783213 | 2020-11-30 | Wayne | Pennsylvania | 42127 | 538 | 12 |
779968 | 779968 | 2020-11-29 | Wayne | Pennsylvania | 42127 | 527 | 12 |
776722 | 776722 | 2020-11-28 | Wayne | Pennsylvania | 42127 | 481 | 12 |
773477 | 773477 | 2020-11-27 | Wayne | Pennsylvania | 42127 | 465 | 12 |
770232 | 770232 | 2020-11-26 | Wayne | Pennsylvania | 42127 | 449 | 12 |
766986 | 766986 | 2020-11-25 | Wayne | Pennsylvania | 42127 | 432 | 12 |
763741 | 763741 | 2020-11-24 | Wayne | Pennsylvania | 42127 | 417 | 12 |
760496 | 760496 | 2020-11-23 | Wayne | Pennsylvania | 42127 | 409 | 12 |
757251 | 757251 | 2020-11-22 | Wayne | Pennsylvania | 42127 | 404 | 12 |
754004 | 754004 | 2020-11-21 | Wayne | Pennsylvania | 42127 | 391 | 12 |
750758 | 750758 | 2020-11-20 | Wayne | Pennsylvania | 42127 | 383 | 12 |
747512 | 747512 | 2020-11-19 | Wayne | Pennsylvania | 42127 | 370 | 12 |
744266 | 744266 | 2020-11-18 | Wayne | Pennsylvania | 42127 | 360 | 12 |
741019 | 741019 | 2020-11-17 | Wayne | Pennsylvania | 42127 | 357 | 12 |
737773 | 737773 | 2020-11-16 | Wayne | Pennsylvania | 42127 | 351 | 12 |
734529 | 734529 | 2020-11-15 | Wayne | Pennsylvania | 42127 | 348 | 12 |
731283 | 731283 | 2020-11-14 | Wayne | Pennsylvania | 42127 | 340 | 12 |
728039 | 728039 | 2020-11-13 | Wayne | Pennsylvania | 42127 | 341 | 12 |
724795 | 724795 | 2020-11-12 | Wayne | Pennsylvania | 42127 | 333 | 12 |
721552 | 721552 | 2020-11-11 | Wayne | Pennsylvania | 42127 | 331 | 12 |
718309 | 718309 | 2020-11-10 | Wayne | Pennsylvania | 42127 | 326 | 12 |
715066 | 715066 | 2020-11-09 | Wayne | Pennsylvania | 42127 | 322 | 12 |
711822 | 711822 | 2020-11-08 | Wayne | Pennsylvania | 42127 | 318 | 12 |
708578 | 708578 | 2020-11-07 | Wayne | Pennsylvania | 42127 | 313 | 12 |
705335 | 705335 | 2020-11-06 | Wayne | Pennsylvania | 42127 | 308 | 12 |
702092 | 702092 | 2020-11-05 | Wayne | Pennsylvania | 42127 | 302 | 12 |
698848 | 698848 | 2020-11-04 | Wayne | Pennsylvania | 42127 | 299 | 12 |
695605 | 695605 | 2020-11-03 | Wayne | Pennsylvania | 42127 | 297 | 12 |
692363 | 692363 | 2020-11-02 | Wayne | Pennsylvania | 42127 | 294 | 12 |
689119 | 689119 | 2020-11-01 | Wayne | Pennsylvania | 42127 | 294 | 12 |
685874 | 685874 | 2020-10-31 | Wayne | Pennsylvania | 42127 | 293 | 12 |
682631 | 682631 | 2020-10-30 | Wayne | Pennsylvania | 42127 | 291 | 12 |
679388 | 679388 | 2020-10-29 | Wayne | Pennsylvania | 42127 | 289 | 12 |
676145 | 676145 | 2020-10-28 | Wayne | Pennsylvania | 42127 | 285 | 12 |
672902 | 672902 | 2020-10-27 | Wayne | Pennsylvania | 42127 | 283 | 12 |
669660 | 669660 | 2020-10-26 | Wayne | Pennsylvania | 42127 | 283 | 12 |
666416 | 666416 | 2020-10-25 | Wayne | Pennsylvania | 42127 | 283 | 12 |
663171 | 663171 | 2020-10-24 | Wayne | Pennsylvania | 42127 | 283 | 12 |
659927 | 659927 | 2020-10-23 | Wayne | Pennsylvania | 42127 | 283 | 12 |
656683 | 656683 | 2020-10-22 | Wayne | Pennsylvania | 42127 | 282 | 12 |
653438 | 653438 | 2020-10-21 | Wayne | Pennsylvania | 42127 | 281 | 12 |
650193 | 650193 | 2020-10-20 | Wayne | Pennsylvania | 42127 | 281 | 12 |
646949 | 646949 | 2020-10-19 | Wayne | Pennsylvania | 42127 | 279 | 12 |
643703 | 643703 | 2020-10-18 | Wayne | Pennsylvania | 42127 | 280 | 12 |
640455 | 640455 | 2020-10-17 | Wayne | Pennsylvania | 42127 | 280 | 12 |
637209 | 637209 | 2020-10-16 | Wayne | Pennsylvania | 42127 | 277 | 12 |
633963 | 633963 | 2020-10-15 | Wayne | Pennsylvania | 42127 | 273 | 12 |
630718 | 630718 | 2020-10-14 | Wayne | Pennsylvania | 42127 | 268 | 12 |
627474 | 627474 | 2020-10-13 | Wayne | Pennsylvania | 42127 | 266 | 12 |
624232 | 624232 | 2020-10-12 | Wayne | Pennsylvania | 42127 | 265 | 12 |
620989 | 620989 | 2020-10-11 | Wayne | Pennsylvania | 42127 | 265 | 12 |
617746 | 617746 | 2020-10-10 | Wayne | Pennsylvania | 42127 | 264 | 12 |
614504 | 614504 | 2020-10-09 | Wayne | Pennsylvania | 42127 | 263 | 12 |
611263 | 611263 | 2020-10-08 | Wayne | Pennsylvania | 42127 | 260 | 12 |
608021 | 608021 | 2020-10-07 | Wayne | Pennsylvania | 42127 | 260 | 11 |
604778 | 604778 | 2020-10-06 | Wayne | Pennsylvania | 42127 | 257 | 11 |
601536 | 601536 | 2020-10-05 | Wayne | Pennsylvania | 42127 | 256 | 11 |
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);