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,264
- Georgia 124,569
- Virginia 102,995
- Kentucky 92,332
- Missouri 89,366
- Illinois 79,296
- Kansas 79,082
- North Carolina 77,609
- Iowa 76,870
- Tennessee 74,623
- Indiana 71,735
- Nebraska 69,067
- Ohio 68,923
- Minnesota 67,707
- Michigan 65,034
- Mississippi 63,981
- Oklahoma 59,767
- Arkansas 58,880
- Puerto Rico 58,297
- Wisconsin 55,921
- Florida 53,226
- Pennsylvania 52,307
- Alabama 52,178
- Louisiana 50,772
- South Dakota 49,486
- Colorado 49,399
- California 45,577
- New York 45,576
- West Virginia 42,183
- Montana 40,544
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498677 | 2498677 | 2022-05-12 | Coamo | Puerto Rico | 72043 | 5899 | |
2498678 | 2498678 | 2022-05-12 | Comerio | Puerto Rico | 72045 | 3327 | |
2498679 | 2498679 | 2022-05-12 | Corozal | Puerto Rico | 72047 | 7208 | |
2498680 | 2498680 | 2022-05-12 | Culebra | Puerto Rico | 72049 | 207 | |
2498681 | 2498681 | 2022-05-12 | Dorado | Puerto Rico | 72051 | 7773 | |
2498682 | 2498682 | 2022-05-12 | Fajardo | Puerto Rico | 72053 | 5353 | |
2498683 | 2498683 | 2022-05-12 | Florida | Puerto Rico | 72054 | 2886 | |
2498684 | 2498684 | 2022-05-12 | Guanica | Puerto Rico | 72055 | 1760 | |
2498685 | 2498685 | 2022-05-12 | Guayama | Puerto Rico | 72057 | 6246 | |
2498686 | 2498686 | 2022-05-12 | Guayanilla | Puerto Rico | 72059 | 2743 | |
2498687 | 2498687 | 2022-05-12 | Guaynabo | Puerto Rico | 72061 | 18340 | |
2498688 | 2498688 | 2022-05-12 | Gurabo | Puerto Rico | 72063 | 8609 | |
2498689 | 2498689 | 2022-05-12 | Hatillo | Puerto Rico | 72065 | 6232 | |
2498690 | 2498690 | 2022-05-12 | Hormigueros | Puerto Rico | 72067 | 2450 | |
2498691 | 2498691 | 2022-05-12 | Humacao | Puerto Rico | 72069 | 9147 | |
2498692 | 2498692 | 2022-05-12 | Isabela | Puerto Rico | 72071 | 7631 | |
2498693 | 2498693 | 2022-05-12 | Jayuya | Puerto Rico | 72073 | 2885 | |
2498694 | 2498694 | 2022-05-12 | Juana Diaz | Puerto Rico | 72075 | 7613 | |
2498695 | 2498695 | 2022-05-12 | Juncos | Puerto Rico | 72077 | 7251 | |
2498696 | 2498696 | 2022-05-12 | Lajas | Puerto Rico | 72079 | 3322 | |
2498697 | 2498697 | 2022-05-12 | Lares | Puerto Rico | 72081 | 4980 | |
2498698 | 2498698 | 2022-05-12 | Las Marias | Puerto Rico | 72083 | 1375 | |
2498699 | 2498699 | 2022-05-12 | Las Piedras | Puerto Rico | 72085 | 6314 | |
2498700 | 2498700 | 2022-05-12 | Loiza | Puerto Rico | 72087 | 3806 | |
2498701 | 2498701 | 2022-05-12 | Luquillo | Puerto Rico | 72089 | 2912 | |
2498702 | 2498702 | 2022-05-12 | Manati | Puerto Rico | 72091 | 7140 | |
2498703 | 2498703 | 2022-05-12 | Maricao | Puerto Rico | 72093 | 704 | |
2498704 | 2498704 | 2022-05-12 | Maunabo | Puerto Rico | 72095 | 1638 | |
2498705 | 2498705 | 2022-05-12 | Mayaguez | Puerto Rico | 72097 | 11704 | |
2498706 | 2498706 | 2022-05-12 | Moca | Puerto Rico | 72099 | 7068 | |
2498707 | 2498707 | 2022-05-12 | Morovis | Puerto Rico | 72101 | 5601 | |
2498708 | 2498708 | 2022-05-12 | Naguabo | Puerto Rico | 72103 | 3902 | |
2498709 | 2498709 | 2022-05-12 | Naranjito | Puerto Rico | 72105 | 5775 | |
2498710 | 2498710 | 2022-05-12 | Orocovis | Puerto Rico | 72107 | 3417 | |
2498711 | 2498711 | 2022-05-12 | Patillas | Puerto Rico | 72109 | 2739 | |
2498712 | 2498712 | 2022-05-12 | Penuelas | Puerto Rico | 72111 | 2770 | |
2498713 | 2498713 | 2022-05-12 | Ponce | Puerto Rico | 72113 | 21697 | |
2498714 | 2498714 | 2022-05-12 | Quebradillas | Puerto Rico | 72115 | 4727 | |
2498715 | 2498715 | 2022-05-12 | Rincon | Puerto Rico | 72117 | 2547 | |
2498716 | 2498716 | 2022-05-12 | Rio Grande | Puerto Rico | 72119 | 8585 | |
2498717 | 2498717 | 2022-05-12 | Sabana Grande | Puerto Rico | 72121 | 2954 | |
2498718 | 2498718 | 2022-05-12 | Salinas | Puerto Rico | 72123 | 4232 | |
2498719 | 2498719 | 2022-05-12 | San German | Puerto Rico | 72125 | 4647 | |
2498720 | 2498720 | 2022-05-12 | San Juan | Puerto Rico | 72127 | 67106 | |
2498721 | 2498721 | 2022-05-12 | San Lorenzo | Puerto Rico | 72129 | 6402 | |
2498722 | 2498722 | 2022-05-12 | San Sebastian | Puerto Rico | 72131 | 7195 | |
2498723 | 2498723 | 2022-05-12 | Santa Isabel | Puerto Rico | 72133 | 3310 | |
2498724 | 2498724 | 2022-05-12 | Toa Alta | Puerto Rico | 72135 | 13772 | |
2498725 | 2498725 | 2022-05-12 | Toa Baja | Puerto Rico | 72137 | 14714 | |
2498726 | 2498726 | 2022-05-12 | Trujillo Alto | Puerto Rico | 72139 | 11656 | |
2498727 | 2498727 | 2022-05-12 | Unknown | Puerto Rico | 20803 | 4245 | |
2498728 | 2498728 | 2022-05-12 | Utuado | Puerto Rico | 72141 | 4048 | |
2498729 | 2498729 | 2022-05-12 | Vega Alta | Puerto Rico | 72143 | 7127 | |
2498730 | 2498730 | 2022-05-12 | Vega Baja | Puerto Rico | 72145 | 11837 | |
2498731 | 2498731 | 2022-05-12 | Vieques | Puerto Rico | 72147 | 924 | |
2498732 | 2498732 | 2022-05-12 | Villalba | Puerto Rico | 72149 | 3990 | |
2498733 | 2498733 | 2022-05-12 | Yabucoa | Puerto Rico | 72151 | 5436 | |
2498734 | 2498734 | 2022-05-12 | Yauco | Puerto Rico | 72153 | 5389 | |
2498735 | 2498735 | 2022-05-12 | Bristol | Rhode Island | 44001 | 14360 | 169 |
2498736 | 2498736 | 2022-05-12 | Kent | Rhode Island | 44003 | 50938 | 513 |
2498737 | 2498737 | 2022-05-12 | Newport | Rhode Island | 44005 | 21237 | 94 |
2498738 | 2498738 | 2022-05-12 | Providence | Rhode Island | 44007 | 229262 | 2535 |
2498739 | 2498739 | 2022-05-12 | Unknown | Rhode Island | 30344 | 13 | |
2498740 | 2498740 | 2022-05-12 | Washington | Rhode Island | 44009 | 34243 | 224 |
2498741 | 2498741 | 2022-05-12 | Abbeville | South Carolina | 45001 | 6655 | 69 |
2498742 | 2498742 | 2022-05-12 | Aiken | South Carolina | 45003 | 41767 | 437 |
2498743 | 2498743 | 2022-05-12 | Allendale | South Carolina | 45005 | 2093 | 24 |
2498744 | 2498744 | 2022-05-12 | Anderson | South Carolina | 45007 | 58025 | 998 |
2498745 | 2498745 | 2022-05-12 | Bamberg | South Carolina | 45009 | 3446 | 75 |
2498746 | 2498746 | 2022-05-12 | Barnwell | South Carolina | 45011 | 5834 | 103 |
2498747 | 2498747 | 2022-05-12 | Beaufort | South Carolina | 45013 | 43530 | 380 |
2498748 | 2498748 | 2022-05-12 | Berkeley | South Carolina | 45015 | 52240 | 450 |
2498749 | 2498749 | 2022-05-12 | Calhoun | South Carolina | 45017 | 2799 | 61 |
2498750 | 2498750 | 2022-05-12 | Charleston | South Carolina | 45019 | 112905 | 945 |
2498751 | 2498751 | 2022-05-12 | Cherokee | South Carolina | 45021 | 14761 | 322 |
2498752 | 2498752 | 2022-05-12 | Chester | South Carolina | 45023 | 10134 | 153 |
2498753 | 2498753 | 2022-05-12 | Chesterfield | South Carolina | 45025 | 11836 | 191 |
2498754 | 2498754 | 2022-05-12 | Clarendon | South Carolina | 45027 | 8776 | 159 |
2498755 | 2498755 | 2022-05-12 | Colleton | South Carolina | 45029 | 8913 | 221 |
2498756 | 2498756 | 2022-05-12 | Darlington | South Carolina | 45031 | 18939 | 311 |
2498757 | 2498757 | 2022-05-12 | Dillon | South Carolina | 45033 | 9729 | 144 |
2498758 | 2498758 | 2022-05-12 | Dorchester | South Carolina | 45035 | 56325 | 496 |
2498759 | 2498759 | 2022-05-12 | Edgefield | South Carolina | 45037 | 6779 | 71 |
2498760 | 2498760 | 2022-05-12 | Fairfield | South Carolina | 45039 | 6007 | 107 |
2498761 | 2498761 | 2022-05-12 | Florence | South Carolina | 45041 | 41861 | 631 |
2498762 | 2498762 | 2022-05-12 | Georgetown | South Carolina | 45043 | 15958 | 227 |
2498763 | 2498763 | 2022-05-12 | Greenville | South Carolina | 45045 | 173338 | 2008 |
2498764 | 2498764 | 2022-05-12 | Greenwood | South Carolina | 45047 | 22607 | 305 |
2498765 | 2498765 | 2022-05-12 | Hampton | South Carolina | 45049 | 5024 | 86 |
2498766 | 2498766 | 2022-05-12 | Horry | South Carolina | 45051 | 97534 | 1159 |
2498767 | 2498767 | 2022-05-12 | Jasper | South Carolina | 45053 | 5924 | 93 |
2498768 | 2498768 | 2022-05-12 | Kershaw | South Carolina | 45055 | 21623 | 261 |
2498769 | 2498769 | 2022-05-12 | Lancaster | South Carolina | 45057 | 25276 | 281 |
2498770 | 2498770 | 2022-05-12 | Laurens | South Carolina | 45059 | 18667 | 295 |
2498771 | 2498771 | 2022-05-12 | Lee | South Carolina | 45061 | 4272 | 95 |
2498772 | 2498772 | 2022-05-12 | Lexington | South Carolina | 45063 | 96569 | 872 |
2498773 | 2498773 | 2022-05-12 | Marion | South Carolina | 45067 | 8564 | 163 |
2498774 | 2498774 | 2022-05-12 | Marlboro | South Carolina | 45069 | 7880 | 105 |
2498775 | 2498775 | 2022-05-12 | McCormick | South Carolina | 45065 | 2244 | 40 |
2498776 | 2498776 | 2022-05-12 | Newberry | South Carolina | 45071 | 13355 | 195 |
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);