ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 193,519
- Georgia 124,729
- Virginia 103,128
- Kentucky 92,452
- Missouri 89,483
- Illinois 79,399
- Kansas 79,188
- North Carolina 77,709
- Iowa 76,970
- Tennessee 74,719
- Indiana 71,828
- Nebraska 69,161
- Ohio 69,101
- Minnesota 67,795
- Michigan 65,118
- Mississippi 64,064
- Oklahoma 59,923
- Arkansas 58,956
- Puerto Rico 58,397
- Wisconsin 55,993
- Florida 53,294
- Pennsylvania 52,441
- Alabama 52,245
- Louisiana 50,837
- South Dakota 49,552
- Colorado 49,463
- California 45,635
- New York 45,634
- West Virginia 42,238
- Montana 40,600
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501586 | 2501586 | 2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 |
2501587 | 2501587 | 2022-05-13 | Barnes | North Dakota | 38003 | 3024 | 47 |
2501588 | 2501588 | 2022-05-13 | Benson | North Dakota | 38005 | 1980 | 23 |
2501589 | 2501589 | 2022-05-13 | Billings | North Dakota | 38007 | 145 | 1 |
2501590 | 2501590 | 2022-05-13 | Bottineau | North Dakota | 38009 | 1598 | 26 |
2501591 | 2501591 | 2022-05-13 | Bowman | North Dakota | 38011 | 828 | 9 |
2501592 | 2501592 | 2022-05-13 | Burke | North Dakota | 38013 | 433 | 3 |
2501593 | 2501593 | 2022-05-13 | Burleigh | North Dakota | 38015 | 35087 | 303 |
2501594 | 2501594 | 2022-05-13 | Cass | North Dakota | 38017 | 59940 | 333 |
2501595 | 2501595 | 2022-05-13 | Cavalier | North Dakota | 38019 | 822 | 7 |
2501596 | 2501596 | 2022-05-13 | Dickey | North Dakota | 38021 | 1496 | 39 |
2501597 | 2501597 | 2022-05-13 | Divide | North Dakota | 38023 | 459 | 4 |
2501598 | 2501598 | 2022-05-13 | Dunn | North Dakota | 38025 | 1041 | 8 |
2501599 | 2501599 | 2022-05-13 | Eddy | North Dakota | 38027 | 761 | 6 |
2501600 | 2501600 | 2022-05-13 | Emmons | North Dakota | 38029 | 728 | 18 |
2501601 | 2501601 | 2022-05-13 | Foster | North Dakota | 38031 | 992 | 23 |
2501602 | 2501602 | 2022-05-13 | Golden Valley | North Dakota | 38033 | 476 | 4 |
2501603 | 2501603 | 2022-05-13 | Grand Forks | North Dakota | 38035 | 22468 | 125 |
2501604 | 2501604 | 2022-05-13 | Grant | North Dakota | 38037 | 451 | 11 |
2501605 | 2501605 | 2022-05-13 | Griggs | North Dakota | 38039 | 583 | 2 |
2501606 | 2501606 | 2022-05-13 | Hettinger | North Dakota | 38041 | 828 | 8 |
2501607 | 2501607 | 2022-05-13 | Kidder | North Dakota | 38043 | 510 | 13 |
2501608 | 2501608 | 2022-05-13 | LaMoure | North Dakota | 38045 | 1015 | 20 |
2501609 | 2501609 | 2022-05-13 | Logan | North Dakota | 38047 | 435 | 12 |
2501610 | 2501610 | 2022-05-13 | McHenry | North Dakota | 38049 | 1318 | 31 |
2501611 | 2501611 | 2022-05-13 | McIntosh | North Dakota | 38051 | 688 | 9 |
2501612 | 2501612 | 2022-05-13 | McKenzie | North Dakota | 38053 | 3272 | 25 |
2501613 | 2501613 | 2022-05-13 | McLean | North Dakota | 38055 | 2737 | 49 |
2501614 | 2501614 | 2022-05-13 | Mercer | North Dakota | 38057 | 2577 | 24 |
2501615 | 2501615 | 2022-05-13 | Morton | North Dakota | 38059 | 11274 | 142 |
2501616 | 2501616 | 2022-05-13 | Mountrail | North Dakota | 38061 | 3254 | 37 |
2501617 | 2501617 | 2022-05-13 | Nelson | North Dakota | 38063 | 768 | 18 |
2501618 | 2501618 | 2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 |
2501619 | 2501619 | 2022-05-13 | Pembina | North Dakota | 38067 | 1996 | 16 |
2501620 | 2501620 | 2022-05-13 | Pierce | North Dakota | 38069 | 1065 | 32 |
2501621 | 2501621 | 2022-05-13 | Ramsey | North Dakota | 38071 | 3638 | 57 |
2501622 | 2501622 | 2022-05-13 | Ransom | North Dakota | 38073 | 1515 | 28 |
2501623 | 2501623 | 2022-05-13 | Renville | North Dakota | 38075 | 556 | 15 |
2501624 | 2501624 | 2022-05-13 | Richland | North Dakota | 38077 | 4108 | 23 |
2501625 | 2501625 | 2022-05-13 | Rolette | North Dakota | 38079 | 6121 | 43 |
2501626 | 2501626 | 2022-05-13 | Sargent | North Dakota | 38081 | 1031 | 9 |
2501627 | 2501627 | 2022-05-13 | Sheridan | North Dakota | 38083 | 299 | 7 |
2501628 | 2501628 | 2022-05-13 | Sioux | North Dakota | 38085 | 1350 | 19 |
2501629 | 2501629 | 2022-05-13 | Slope | North Dakota | 38087 | 63 | 0 |
2501630 | 2501630 | 2022-05-13 | Stark | North Dakota | 38089 | 11683 | 86 |
2501631 | 2501631 | 2022-05-13 | Steele | North Dakota | 38091 | 388 | 2 |
2501632 | 2501632 | 2022-05-13 | Stutsman | North Dakota | 38093 | 7113 | 97 |
2501633 | 2501633 | 2022-05-13 | Towner | North Dakota | 38095 | 641 | 12 |
2501634 | 2501634 | 2022-05-13 | Traill | North Dakota | 38097 | 2205 | 26 |
2501635 | 2501635 | 2022-05-13 | Unknown | North Dakota | 0 | 87 | |
2501636 | 2501636 | 2022-05-13 | Walsh | North Dakota | 38099 | 3374 | 34 |
2501637 | 2501637 | 2022-05-13 | Ward | North Dakota | 38101 | 20887 | 251 |
2501638 | 2501638 | 2022-05-13 | Wells | North Dakota | 38103 | 1018 | 12 |
2501639 | 2501639 | 2022-05-13 | Williams | North Dakota | 38105 | 10496 | 68 |
2501640 | 2501640 | 2022-05-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2501641 | 2501641 | 2022-05-13 | Saipan | Northern Mariana Islands | 69110 | 10397 | 33 |
2501642 | 2501642 | 2022-05-13 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2501643 | 2501643 | 2022-05-13 | Unknown | Northern Mariana Islands | 152 | 1 | |
2501644 | 2501644 | 2022-05-13 | Adams | Ohio | 39001 | 7022 | 148 |
2501645 | 2501645 | 2022-05-13 | Allen | Ohio | 39003 | 27636 | 478 |
2501646 | 2501646 | 2022-05-13 | Ashland | Ohio | 39005 | 12109 | 218 |
2501647 | 2501647 | 2022-05-13 | Ashtabula | Ohio | 39007 | 20537 | 431 |
2501648 | 2501648 | 2022-05-13 | Athens | Ohio | 39009 | 14852 | 142 |
2501649 | 2501649 | 2022-05-13 | Auglaize | Ohio | 39011 | 11642 | 189 |
2501650 | 2501650 | 2022-05-13 | Belmont | Ohio | 39013 | 15805 | 309 |
2501651 | 2501651 | 2022-05-13 | Brown | Ohio | 39015 | 11248 | 180 |
2501652 | 2501652 | 2022-05-13 | Butler | Ohio | 39017 | 93927 | 1157 |
2501653 | 2501653 | 2022-05-13 | Carroll | Ohio | 39019 | 5291 | 126 |
2501654 | 2501654 | 2022-05-13 | Champaign | Ohio | 39021 | 8819 | 147 |
2501655 | 2501655 | 2022-05-13 | Clark | Ohio | 39023 | 35217 | 586 |
2501656 | 2501656 | 2022-05-13 | Clermont | Ohio | 39025 | 51997 | 560 |
2501657 | 2501657 | 2022-05-13 | Clinton | Ohio | 39027 | 10410 | 168 |
2501658 | 2501658 | 2022-05-13 | Columbiana | Ohio | 39029 | 24651 | 486 |
2501659 | 2501659 | 2022-05-13 | Coshocton | Ohio | 39031 | 8008 | 159 |
2501660 | 2501660 | 2022-05-13 | Crawford | Ohio | 39033 | 11254 | 215 |
2501661 | 2501661 | 2022-05-13 | Cuyahoga | Ohio | 39035 | 276160 | 3794 |
2501662 | 2501662 | 2022-05-13 | Darke | Ohio | 39037 | 12442 | 239 |
2501663 | 2501663 | 2022-05-13 | Defiance | Ohio | 39039 | 10275 | 165 |
2501664 | 2501664 | 2022-05-13 | Delaware | Ohio | 39041 | 45538 | 272 |
2501665 | 2501665 | 2022-05-13 | Erie | Ohio | 39043 | 19730 | 267 |
2501666 | 2501666 | 2022-05-13 | Fairfield | Ohio | 39045 | 39082 | 430 |
2501667 | 2501667 | 2022-05-13 | Fayette | Ohio | 39047 | 7846 | 121 |
2501668 | 2501668 | 2022-05-13 | Franklin | Ohio | 39049 | 296037 | 2610 |
2501669 | 2501669 | 2022-05-13 | Fulton | Ohio | 39051 | 10436 | 180 |
2501670 | 2501670 | 2022-05-13 | Gallia | Ohio | 39053 | 7565 | 127 |
2501671 | 2501671 | 2022-05-13 | Geauga | Ohio | 39055 | 16413 | 265 |
2501672 | 2501672 | 2022-05-13 | Greene | Ohio | 39057 | 38049 | 513 |
2501673 | 2501673 | 2022-05-13 | Guernsey | Ohio | 39059 | 10567 | 151 |
2501674 | 2501674 | 2022-05-13 | Hamilton | Ohio | 39061 | 191030 | 2069 |
2501675 | 2501675 | 2022-05-13 | Hancock | Ohio | 39063 | 17253 | 277 |
2501676 | 2501676 | 2022-05-13 | Hardin | Ohio | 39065 | 7138 | 158 |
2501677 | 2501677 | 2022-05-13 | Harrison | Ohio | 39067 | 3263 | 74 |
2501678 | 2501678 | 2022-05-13 | Henry | Ohio | 39069 | 6485 | 106 |
2501679 | 2501679 | 2022-05-13 | Highland | Ohio | 39071 | 10675 | 184 |
2501680 | 2501680 | 2022-05-13 | Hocking | Ohio | 39073 | 6731 | 123 |
2501681 | 2501681 | 2022-05-13 | Holmes | Ohio | 39075 | 5135 | 182 |
2501682 | 2501682 | 2022-05-13 | Huron | Ohio | 39077 | 14626 | 222 |
2501683 | 2501683 | 2022-05-13 | Jackson | Ohio | 39079 | 8988 | 141 |
2501684 | 2501684 | 2022-05-13 | Jefferson | Ohio | 39081 | 14900 | 322 |
2501685 | 2501685 | 2022-05-13 | Knox | Ohio | 39083 | 13325 | 228 |
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);