ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,325 rows where county = "Wyoming" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- New York 214
- Pennsylvania 196
- West Virginia 193
county 1
- Wyoming · 603 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636786 | 636786 | 2020-10-16 | Wyoming | New York | 36121 | 160 | 5 |
637211 | 637211 | 2020-10-16 | Wyoming | Pennsylvania | 42131 | 96 | 8 |
638033 | 638033 | 2020-10-16 | Wyoming | West Virginia | 54109 | 161 | 5 |
633540 | 633540 | 2020-10-15 | Wyoming | New York | 36121 | 156 | 5 |
633965 | 633965 | 2020-10-15 | Wyoming | Pennsylvania | 42131 | 93 | 8 |
634788 | 634788 | 2020-10-15 | Wyoming | West Virginia | 54109 | 152 | 5 |
630295 | 630295 | 2020-10-14 | Wyoming | New York | 36121 | 156 | 5 |
630720 | 630720 | 2020-10-14 | Wyoming | Pennsylvania | 42131 | 92 | 8 |
631543 | 631543 | 2020-10-14 | Wyoming | West Virginia | 54109 | 144 | 5 |
627051 | 627051 | 2020-10-13 | Wyoming | New York | 36121 | 153 | 5 |
627476 | 627476 | 2020-10-13 | Wyoming | Pennsylvania | 42131 | 91 | 8 |
628299 | 628299 | 2020-10-13 | Wyoming | West Virginia | 54109 | 143 | 5 |
623809 | 623809 | 2020-10-12 | Wyoming | New York | 36121 | 152 | 5 |
624234 | 624234 | 2020-10-12 | Wyoming | Pennsylvania | 42131 | 85 | 8 |
625056 | 625056 | 2020-10-12 | Wyoming | West Virginia | 54109 | 138 | 5 |
620566 | 620566 | 2020-10-11 | Wyoming | New York | 36121 | 152 | 5 |
620991 | 620991 | 2020-10-11 | Wyoming | Pennsylvania | 42131 | 82 | 8 |
621813 | 621813 | 2020-10-11 | Wyoming | West Virginia | 54109 | 137 | 5 |
617324 | 617324 | 2020-10-10 | Wyoming | New York | 36121 | 150 | 5 |
617748 | 617748 | 2020-10-10 | Wyoming | Pennsylvania | 42131 | 81 | 8 |
618570 | 618570 | 2020-10-10 | Wyoming | West Virginia | 54109 | 136 | 5 |
614082 | 614082 | 2020-10-09 | Wyoming | New York | 36121 | 150 | 5 |
614506 | 614506 | 2020-10-09 | Wyoming | Pennsylvania | 42131 | 81 | 8 |
615328 | 615328 | 2020-10-09 | Wyoming | West Virginia | 54109 | 135 | 5 |
610841 | 610841 | 2020-10-08 | Wyoming | New York | 36121 | 147 | 5 |
611265 | 611265 | 2020-10-08 | Wyoming | Pennsylvania | 42131 | 81 | 8 |
612087 | 612087 | 2020-10-08 | Wyoming | West Virginia | 54109 | 132 | 5 |
607599 | 607599 | 2020-10-07 | Wyoming | New York | 36121 | 147 | 5 |
608023 | 608023 | 2020-10-07 | Wyoming | Pennsylvania | 42131 | 80 | 8 |
608845 | 608845 | 2020-10-07 | Wyoming | West Virginia | 54109 | 130 | 5 |
604356 | 604356 | 2020-10-06 | Wyoming | New York | 36121 | 144 | 5 |
604780 | 604780 | 2020-10-06 | Wyoming | Pennsylvania | 42131 | 80 | 8 |
605602 | 605602 | 2020-10-06 | Wyoming | West Virginia | 54109 | 130 | 4 |
601114 | 601114 | 2020-10-05 | Wyoming | New York | 36121 | 142 | 5 |
601538 | 601538 | 2020-10-05 | Wyoming | Pennsylvania | 42131 | 80 | 8 |
602360 | 602360 | 2020-10-05 | Wyoming | West Virginia | 54109 | 130 | 4 |
597871 | 597871 | 2020-10-04 | Wyoming | New York | 36121 | 141 | 5 |
598295 | 598295 | 2020-10-04 | Wyoming | Pennsylvania | 42131 | 80 | 8 |
599117 | 599117 | 2020-10-04 | Wyoming | West Virginia | 54109 | 129 | 4 |
594628 | 594628 | 2020-10-03 | Wyoming | New York | 36121 | 140 | 5 |
595052 | 595052 | 2020-10-03 | Wyoming | Pennsylvania | 42131 | 79 | 8 |
595874 | 595874 | 2020-10-03 | Wyoming | West Virginia | 54109 | 129 | 4 |
591387 | 591387 | 2020-10-02 | Wyoming | New York | 36121 | 137 | 5 |
591811 | 591811 | 2020-10-02 | Wyoming | Pennsylvania | 42131 | 79 | 8 |
592632 | 592632 | 2020-10-02 | Wyoming | West Virginia | 54109 | 127 | 4 |
588146 | 588146 | 2020-10-01 | Wyoming | New York | 36121 | 137 | 5 |
588570 | 588570 | 2020-10-01 | Wyoming | Pennsylvania | 42131 | 78 | 8 |
589392 | 589392 | 2020-10-01 | Wyoming | West Virginia | 54109 | 121 | 4 |
584906 | 584906 | 2020-09-30 | Wyoming | New York | 36121 | 137 | 5 |
585330 | 585330 | 2020-09-30 | Wyoming | Pennsylvania | 42131 | 78 | 8 |
586151 | 586151 | 2020-09-30 | Wyoming | West Virginia | 54109 | 119 | 4 |
581665 | 581665 | 2020-09-29 | Wyoming | New York | 36121 | 137 | 5 |
582090 | 582090 | 2020-09-29 | Wyoming | Pennsylvania | 42131 | 78 | 8 |
582911 | 582911 | 2020-09-29 | Wyoming | West Virginia | 54109 | 118 | 4 |
578425 | 578425 | 2020-09-28 | Wyoming | New York | 36121 | 137 | 5 |
578850 | 578850 | 2020-09-28 | Wyoming | Pennsylvania | 42131 | 78 | 8 |
579672 | 579672 | 2020-09-28 | Wyoming | West Virginia | 54109 | 118 | 3 |
575184 | 575184 | 2020-09-27 | Wyoming | New York | 36121 | 137 | 5 |
575609 | 575609 | 2020-09-27 | Wyoming | Pennsylvania | 42131 | 76 | 8 |
576431 | 576431 | 2020-09-27 | Wyoming | West Virginia | 54109 | 115 | 3 |
571940 | 571940 | 2020-09-26 | Wyoming | New York | 36121 | 136 | 5 |
572365 | 572365 | 2020-09-26 | Wyoming | Pennsylvania | 42131 | 75 | 8 |
573187 | 573187 | 2020-09-26 | Wyoming | West Virginia | 54109 | 114 | 3 |
568698 | 568698 | 2020-09-25 | Wyoming | New York | 36121 | 135 | 5 |
569123 | 569123 | 2020-09-25 | Wyoming | Pennsylvania | 42131 | 74 | 8 |
569945 | 569945 | 2020-09-25 | Wyoming | West Virginia | 54109 | 110 | 3 |
565457 | 565457 | 2020-09-24 | Wyoming | New York | 36121 | 134 | 5 |
565882 | 565882 | 2020-09-24 | Wyoming | Pennsylvania | 42131 | 73 | 8 |
566704 | 566704 | 2020-09-24 | Wyoming | West Virginia | 54109 | 108 | 3 |
562216 | 562216 | 2020-09-23 | Wyoming | New York | 36121 | 132 | 5 |
562641 | 562641 | 2020-09-23 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
563463 | 563463 | 2020-09-23 | Wyoming | West Virginia | 54109 | 103 | 3 |
558979 | 558979 | 2020-09-22 | Wyoming | New York | 36121 | 132 | 5 |
559404 | 559404 | 2020-09-22 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
560224 | 560224 | 2020-09-22 | Wyoming | West Virginia | 54109 | 103 | 3 |
555742 | 555742 | 2020-09-21 | Wyoming | New York | 36121 | 132 | 5 |
556167 | 556167 | 2020-09-21 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
556988 | 556988 | 2020-09-21 | Wyoming | West Virginia | 54109 | 101 | 3 |
552505 | 552505 | 2020-09-20 | Wyoming | New York | 36121 | 132 | 5 |
552930 | 552930 | 2020-09-20 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
553751 | 553751 | 2020-09-20 | Wyoming | West Virginia | 54109 | 101 | 3 |
549266 | 549266 | 2020-09-19 | Wyoming | New York | 36121 | 132 | 5 |
549691 | 549691 | 2020-09-19 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
550512 | 550512 | 2020-09-19 | Wyoming | West Virginia | 54109 | 96 | 3 |
546027 | 546027 | 2020-09-18 | Wyoming | New York | 36121 | 131 | 5 |
546452 | 546452 | 2020-09-18 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
547273 | 547273 | 2020-09-18 | Wyoming | West Virginia | 54109 | 94 | 3 |
542790 | 542790 | 2020-09-17 | Wyoming | New York | 36121 | 130 | 5 |
543215 | 543215 | 2020-09-17 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
544036 | 544036 | 2020-09-17 | Wyoming | West Virginia | 54109 | 88 | 3 |
539554 | 539554 | 2020-09-16 | Wyoming | New York | 36121 | 130 | 5 |
539979 | 539979 | 2020-09-16 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
540800 | 540800 | 2020-09-16 | Wyoming | West Virginia | 54109 | 83 | 3 |
536317 | 536317 | 2020-09-15 | Wyoming | New York | 36121 | 130 | 5 |
536742 | 536742 | 2020-09-15 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
537563 | 537563 | 2020-09-15 | Wyoming | West Virginia | 54109 | 82 | 3 |
533081 | 533081 | 2020-09-14 | Wyoming | New York | 36121 | 130 | 5 |
533506 | 533506 | 2020-09-14 | Wyoming | Pennsylvania | 42131 | 72 | 8 |
534327 | 534327 | 2020-09-14 | Wyoming | West Virginia | 54109 | 80 | 3 |
529846 | 529846 | 2020-09-13 | Wyoming | New York | 36121 | 128 | 5 |
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);