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 56
- Texas 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 77,900
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,809
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,201
- Nebraska 59,855
- Minnesota 59,083
- Michigan 56,802
- Mississippi 55,890
- Oklahoma 52,123
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,755
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 43,018
- California 39,892
- New York 39,892
- West Virginia 36,793
- North Dakota 35,099
- Montana 35,056
- South Carolina 31,537
- Idaho 28,784
- Washington 27,022
- Oregon 24,183
- New Mexico 22,087
- Utah 19,949
- Alaska 17,770
- Maryland 17,145
- Wyoming 15,538
- New Jersey 15,217
- Maine 11,398
- Nevada 11,107
- Arizona 10,419
- Massachusetts 10,414
- Vermont 10,273
- New Hampshire 7,512
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,437
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179767 | 2179767 | 2022-02-03 | Schuylkill | Pennsylvania | 42107 | 33137 | 632 |
2179768 | 2179768 | 2022-02-03 | Snyder | Pennsylvania | 42109 | 7782 | 146 |
2179769 | 2179769 | 2022-02-03 | Somerset | Pennsylvania | 42111 | 17951 | 378 |
2179770 | 2179770 | 2022-02-03 | Sullivan | Pennsylvania | 42113 | 1019 | 32 |
2179771 | 2179771 | 2022-02-03 | Susquehanna | Pennsylvania | 42115 | 7354 | 101 |
2179772 | 2179772 | 2022-02-03 | Tioga | Pennsylvania | 42117 | 7564 | 185 |
2179773 | 2179773 | 2022-02-03 | Union | Pennsylvania | 42119 | 11128 | 139 |
2179774 | 2179774 | 2022-02-03 | Venango | Pennsylvania | 42121 | 10868 | 222 |
2179775 | 2179775 | 2022-02-03 | Warren | Pennsylvania | 42123 | 6944 | 200 |
2179776 | 2179776 | 2022-02-03 | Washington | Pennsylvania | 42125 | 48761 | 588 |
2179777 | 2179777 | 2022-02-03 | Wayne | Pennsylvania | 42127 | 9632 | 154 |
2179778 | 2179778 | 2022-02-03 | Westmoreland | Pennsylvania | 42129 | 76320 | 1265 |
2179779 | 2179779 | 2022-02-03 | Wyoming | Pennsylvania | 42131 | 4826 | 96 |
2179780 | 2179780 | 2022-02-03 | York | Pennsylvania | 42133 | 114771 | 1388 |
2179781 | 2179781 | 2022-02-03 | Adjuntas | Puerto Rico | 72001 | 2077 | |
2179782 | 2179782 | 2022-02-03 | Aguada | Puerto Rico | 72003 | 5804 | |
2179783 | 2179783 | 2022-02-03 | Aguadilla | Puerto Rico | 72005 | 6720 | |
2179784 | 2179784 | 2022-02-03 | Aguas Buenas | Puerto Rico | 72007 | 3796 | |
2179785 | 2179785 | 2022-02-03 | Aibonito | Puerto Rico | 72009 | 3350 | |
2179786 | 2179786 | 2022-02-03 | Anasco | Puerto Rico | 72011 | 3315 | |
2179787 | 2179787 | 2022-02-03 | Arecibo | Puerto Rico | 72013 | 11821 | |
2179788 | 2179788 | 2022-02-03 | Arroyo | Puerto Rico | 72015 | 1745 | |
2179789 | 2179789 | 2022-02-03 | Barceloneta | Puerto Rico | 72017 | 3010 | |
2179790 | 2179790 | 2022-02-03 | Barranquitas | Puerto Rico | 72019 | 4414 | |
2179791 | 2179791 | 2022-02-03 | Bayamon | Puerto Rico | 72021 | 32326 | |
2179792 | 2179792 | 2022-02-03 | Cabo Rojo | Puerto Rico | 72023 | 4793 | |
2179793 | 2179793 | 2022-02-03 | Caguas | Puerto Rico | 72025 | 20514 | |
2179794 | 2179794 | 2022-02-03 | Camuy | Puerto Rico | 72027 | 4424 | |
2179795 | 2179795 | 2022-02-03 | Canovanas | Puerto Rico | 72029 | 6180 | |
2179796 | 2179796 | 2022-02-03 | Carolina | Puerto Rico | 72031 | 26510 | |
2179797 | 2179797 | 2022-02-03 | Catano | Puerto Rico | 72033 | 3950 | |
2179798 | 2179798 | 2022-02-03 | Cayey | Puerto Rico | 72035 | 5502 | |
2179799 | 2179799 | 2022-02-03 | Ceiba | Puerto Rico | 72037 | 1291 | |
2179800 | 2179800 | 2022-02-03 | Ciales | Puerto Rico | 72039 | 2408 | |
2179801 | 2179801 | 2022-02-03 | Cidra | Puerto Rico | 72041 | 5298 | |
2179802 | 2179802 | 2022-02-03 | Coamo | Puerto Rico | 72043 | 4204 | |
2179803 | 2179803 | 2022-02-03 | Comerio | Puerto Rico | 72045 | 2682 | |
2179804 | 2179804 | 2022-02-03 | Corozal | Puerto Rico | 72047 | 5872 | |
2179805 | 2179805 | 2022-02-03 | Culebra | Puerto Rico | 72049 | 160 | |
2179806 | 2179806 | 2022-02-03 | Dorado | Puerto Rico | 72051 | 6372 | |
2179807 | 2179807 | 2022-02-03 | Fajardo | Puerto Rico | 72053 | 4347 | |
2179808 | 2179808 | 2022-02-03 | Florida | Puerto Rico | 72054 | 2310 | |
2179809 | 2179809 | 2022-02-03 | Guanica | Puerto Rico | 72055 | 1378 | |
2179810 | 2179810 | 2022-02-03 | Guayama | Puerto Rico | 72057 | 4354 | |
2179811 | 2179811 | 2022-02-03 | Guayanilla | Puerto Rico | 72059 | 1918 | |
2179812 | 2179812 | 2022-02-03 | Guaynabo | Puerto Rico | 72061 | 14484 | |
2179813 | 2179813 | 2022-02-03 | Gurabo | Puerto Rico | 72063 | 6869 | |
2179814 | 2179814 | 2022-02-03 | Hatillo | Puerto Rico | 72065 | 4858 | |
2179815 | 2179815 | 2022-02-03 | Hormigueros | Puerto Rico | 72067 | 1708 | |
2179816 | 2179816 | 2022-02-03 | Humacao | Puerto Rico | 72069 | 7300 | |
2179817 | 2179817 | 2022-02-03 | Isabela | Puerto Rico | 72071 | 6185 | |
2179818 | 2179818 | 2022-02-03 | Jayuya | Puerto Rico | 72073 | 1966 | |
2179819 | 2179819 | 2022-02-03 | Juana Diaz | Puerto Rico | 72075 | 5449 | |
2179820 | 2179820 | 2022-02-03 | Juncos | Puerto Rico | 72077 | 5867 | |
2179821 | 2179821 | 2022-02-03 | Lajas | Puerto Rico | 72079 | 2329 | |
2179822 | 2179822 | 2022-02-03 | Lares | Puerto Rico | 72081 | 3500 | |
2179823 | 2179823 | 2022-02-03 | Las Marias | Puerto Rico | 72083 | 1015 | |
2179824 | 2179824 | 2022-02-03 | Las Piedras | Puerto Rico | 72085 | 5019 | |
2179825 | 2179825 | 2022-02-03 | Loiza | Puerto Rico | 72087 | 3058 | |
2179826 | 2179826 | 2022-02-03 | Luquillo | Puerto Rico | 72089 | 2375 | |
2179827 | 2179827 | 2022-02-03 | Manati | Puerto Rico | 72091 | 5633 | |
2179828 | 2179828 | 2022-02-03 | Maricao | Puerto Rico | 72093 | 508 | |
2179829 | 2179829 | 2022-02-03 | Maunabo | Puerto Rico | 72095 | 1310 | |
2179830 | 2179830 | 2022-02-03 | Mayaguez | Puerto Rico | 72097 | 9122 | |
2179831 | 2179831 | 2022-02-03 | Moca | Puerto Rico | 72099 | 5452 | |
2179832 | 2179832 | 2022-02-03 | Morovis | Puerto Rico | 72101 | 4344 | |
2179833 | 2179833 | 2022-02-03 | Naguabo | Puerto Rico | 72103 | 3138 | |
2179834 | 2179834 | 2022-02-03 | Naranjito | Puerto Rico | 72105 | 4810 | |
2179835 | 2179835 | 2022-02-03 | Orocovis | Puerto Rico | 72107 | 2713 | |
2179836 | 2179836 | 2022-02-03 | Patillas | Puerto Rico | 72109 | 1900 | |
2179837 | 2179837 | 2022-02-03 | Penuelas | Puerto Rico | 72111 | 2097 | |
2179838 | 2179838 | 2022-02-03 | Ponce | Puerto Rico | 72113 | 16399 | |
2179839 | 2179839 | 2022-02-03 | Quebradillas | Puerto Rico | 72115 | 3439 | |
2179840 | 2179840 | 2022-02-03 | Rincon | Puerto Rico | 72117 | 2057 | |
2179841 | 2179841 | 2022-02-03 | Rio Grande | Puerto Rico | 72119 | 7085 | |
2179842 | 2179842 | 2022-02-03 | Sabana Grande | Puerto Rico | 72121 | 2130 | |
2179843 | 2179843 | 2022-02-03 | Salinas | Puerto Rico | 72123 | 3242 | |
2179844 | 2179844 | 2022-02-03 | San German | Puerto Rico | 72125 | 3324 | |
2179845 | 2179845 | 2022-02-03 | San Juan | Puerto Rico | 72127 | 57953 | |
2179846 | 2179846 | 2022-02-03 | San Lorenzo | Puerto Rico | 72129 | 5072 | |
2179847 | 2179847 | 2022-02-03 | San Sebastian | Puerto Rico | 72131 | 5872 | |
2179848 | 2179848 | 2022-02-03 | Santa Isabel | Puerto Rico | 72133 | 2381 | |
2179849 | 2179849 | 2022-02-03 | Toa Alta | Puerto Rico | 72135 | 11406 | |
2179850 | 2179850 | 2022-02-03 | Toa Baja | Puerto Rico | 72137 | 12202 | |
2179851 | 2179851 | 2022-02-03 | Trujillo Alto | Puerto Rico | 72139 | 9423 | |
2179852 | 2179852 | 2022-02-03 | Unknown | Puerto Rico | 16281 | 3908 | |
2179853 | 2179853 | 2022-02-03 | Utuado | Puerto Rico | 72141 | 3122 | |
2179854 | 2179854 | 2022-02-03 | Vega Alta | Puerto Rico | 72143 | 5890 | |
2179855 | 2179855 | 2022-02-03 | Vega Baja | Puerto Rico | 72145 | 9905 | |
2179856 | 2179856 | 2022-02-03 | Vieques | Puerto Rico | 72147 | 677 | |
2179857 | 2179857 | 2022-02-03 | Villalba | Puerto Rico | 72149 | 2850 | |
2179858 | 2179858 | 2022-02-03 | Yabucoa | Puerto Rico | 72151 | 4105 | |
2179859 | 2179859 | 2022-02-03 | Yauco | Puerto Rico | 72153 | 3956 | |
2179860 | 2179860 | 2022-02-03 | Bristol | Rhode Island | 44001 | 12482 | 164 |
2179861 | 2179861 | 2022-02-03 | Kent | Rhode Island | 44003 | 45131 | 469 |
2179862 | 2179862 | 2022-02-03 | Newport | Rhode Island | 44005 | 18416 | 72 |
2179863 | 2179863 | 2022-02-03 | Providence | Rhode Island | 44007 | 209760 | 2392 |
2179864 | 2179864 | 2022-02-03 | Unknown | Rhode Island | 32011 | 33 | |
2179865 | 2179865 | 2022-02-03 | Washington | Rhode Island | 44009 | 29241 | 211 |
2179866 | 2179866 | 2022-02-03 | Abbeville | South Carolina | 45001 | 6327 | 61 |
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);