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,009
- Georgia 124,409
- Virginia 102,862
- Kentucky 92,212
- Missouri 89,249
- Illinois 79,193
- Kansas 78,976
- North Carolina 77,609
- Iowa 76,770
- Tennessee 74,527
- Indiana 71,642
- Nebraska 68,973
- Ohio 68,923
- Minnesota 67,619
- Michigan 64,950
- Mississippi 63,898
- Oklahoma 59,767
- Arkansas 58,804
- Puerto Rico 58,239
- Wisconsin 55,849
- Florida 53,158
- Pennsylvania 52,307
- Alabama 52,111
- Louisiana 50,707
- South Dakota 49,420
- Colorado 49,335
- New York 45,576
- California 45,519
- West Virginia 42,128
- Montana 40,488
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494843 | 2494843 | 2022-05-11 | Washoe | Nevada | 32031 | 105973 | 1202 |
2494844 | 2494844 | 2022-05-11 | White Pine | Nevada | 32033 | 1693 | 20 |
2494845 | 2494845 | 2022-05-11 | Belknap | New Hampshire | 33001 | 14099 | 177 |
2494846 | 2494846 | 2022-05-11 | Carroll | New Hampshire | 33003 | 9815 | 61 |
2494847 | 2494847 | 2022-05-11 | Cheshire | New Hampshire | 33005 | 15599 | 112 |
2494848 | 2494848 | 2022-05-11 | Coos | New Hampshire | 33007 | 7134 | 113 |
2494849 | 2494849 | 2022-05-11 | Grafton | New Hampshire | 33009 | 19145 | 68 |
2494850 | 2494850 | 2022-05-11 | Hillsborough | New Hampshire | 33011 | 101372 | 914 |
2494851 | 2494851 | 2022-05-11 | Merrimack | New Hampshire | 33013 | 33294 | 230 |
2494852 | 2494852 | 2022-05-11 | Rockingham | New Hampshire | 33015 | 70065 | 540 |
2494853 | 2494853 | 2022-05-11 | Strafford | New Hampshire | 33017 | 30838 | 209 |
2494854 | 2494854 | 2022-05-11 | Sullivan | New Hampshire | 33019 | 9699 | 67 |
2494855 | 2494855 | 2022-05-11 | Unknown | New Hampshire | 4387 | 2 | |
2494856 | 2494856 | 2022-05-11 | Atlantic | New Jersey | 34001 | 70222 | 996 |
2494857 | 2494857 | 2022-05-11 | Bergen | New Jersey | 34003 | 237703 | 3452 |
2494858 | 2494858 | 2022-05-11 | Burlington | New Jersey | 34005 | 106147 | 1208 |
2494859 | 2494859 | 2022-05-11 | Camden | New Jersey | 34007 | 129462 | 1807 |
2494860 | 2494860 | 2022-05-11 | Cape May | New Jersey | 34009 | 22701 | 304 |
2494861 | 2494861 | 2022-05-11 | Cumberland | New Jersey | 34011 | 40276 | 605 |
2494862 | 2494862 | 2022-05-11 | Essex | New Jersey | 34013 | 221477 | 3611 |
2494863 | 2494863 | 2022-05-11 | Gloucester | New Jersey | 34015 | 71513 | 968 |
2494864 | 2494864 | 2022-05-11 | Hudson | New Jersey | 34017 | 178250 | 2721 |
2494865 | 2494865 | 2022-05-11 | Hunterdon | New Jersey | 34019 | 25817 | 275 |
2494866 | 2494866 | 2022-05-11 | Mercer | New Jersey | 34021 | 80363 | 1261 |
2494867 | 2494867 | 2022-05-11 | Middlesex | New Jersey | 34023 | 203132 | 2877 |
2494868 | 2494868 | 2022-05-11 | Monmouth | New Jersey | 34025 | 171404 | 2179 |
2494869 | 2494869 | 2022-05-11 | Morris | New Jersey | 34027 | 125170 | 1547 |
2494870 | 2494870 | 2022-05-11 | Ocean | New Jersey | 34029 | 167598 | 2974 |
2494871 | 2494871 | 2022-05-11 | Passaic | New Jersey | 34031 | 149168 | 2337 |
2494872 | 2494872 | 2022-05-11 | Salem | New Jersey | 34033 | 14629 | 249 |
2494873 | 2494873 | 2022-05-11 | Somerset | New Jersey | 34035 | 71849 | 975 |
2494874 | 2494874 | 2022-05-11 | Sussex | New Jersey | 34037 | 35296 | 475 |
2494875 | 2494875 | 2022-05-11 | Union | New Jersey | 34039 | 150301 | 2354 |
2494876 | 2494876 | 2022-05-11 | Unknown | New Jersey | 3207 | 0 | |
2494877 | 2494877 | 2022-05-11 | Warren | New Jersey | 34041 | 24722 | 342 |
2494878 | 2494878 | 2022-05-11 | Bernalillo | New Mexico | 35001 | 149232 | 1850 |
2494879 | 2494879 | 2022-05-11 | Catron | New Mexico | 35003 | 420 | 14 |
2494880 | 2494880 | 2022-05-11 | Chaves | New Mexico | 35005 | 21758 | 327 |
2494881 | 2494881 | 2022-05-11 | Cibola | New Mexico | 35006 | 8034 | 189 |
2494882 | 2494882 | 2022-05-11 | Colfax | New Mexico | 35007 | 2707 | 65 |
2494883 | 2494883 | 2022-05-11 | Curry | New Mexico | 35009 | 12782 | 197 |
2494884 | 2494884 | 2022-05-11 | De Baca | New Mexico | 35011 | 588 | 6 |
2494885 | 2494885 | 2022-05-11 | Doña Ana | New Mexico | 35013 | 63890 | 772 |
2494886 | 2494886 | 2022-05-11 | Eddy | New Mexico | 35015 | 17061 | 281 |
2494887 | 2494887 | 2022-05-11 | Grant | New Mexico | 35017 | 6731 | 90 |
2494888 | 2494888 | 2022-05-11 | Guadalupe | New Mexico | 35019 | 1481 | 17 |
2494889 | 2494889 | 2022-05-11 | Harding | New Mexico | 35021 | 85 | 4 |
2494890 | 2494890 | 2022-05-11 | Hidalgo | New Mexico | 35023 | 1103 | 15 |
2494891 | 2494891 | 2022-05-11 | Lea | New Mexico | 35025 | 20169 | 341 |
2494892 | 2494892 | 2022-05-11 | Lincoln | New Mexico | 35027 | 5292 | 67 |
2494893 | 2494893 | 2022-05-11 | Los Alamos | New Mexico | 35028 | 2869 | 16 |
2494894 | 2494894 | 2022-05-11 | Luna | New Mexico | 35029 | 6722 | 129 |
2494895 | 2494895 | 2022-05-11 | McKinley | New Mexico | 35031 | 25986 | 589 |
2494896 | 2494896 | 2022-05-11 | Mora | New Mexico | 35033 | 772 | 18 |
2494897 | 2494897 | 2022-05-11 | Otero | New Mexico | 35035 | 15594 | 187 |
2494898 | 2494898 | 2022-05-11 | Quay | New Mexico | 35037 | 2005 | 54 |
2494899 | 2494899 | 2022-05-11 | Rio Arriba | New Mexico | 35039 | 9956 | 135 |
2494900 | 2494900 | 2022-05-11 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2494901 | 2494901 | 2022-05-11 | San Juan | New Mexico | 35045 | 40924 | 754 |
2494902 | 2494902 | 2022-05-11 | San Miguel | New Mexico | 35047 | 5917 | 63 |
2494903 | 2494903 | 2022-05-11 | Sandoval | New Mexico | 35043 | 34055 | 435 |
2494904 | 2494904 | 2022-05-11 | Santa Fe | New Mexico | 35049 | 29388 | 286 |
2494905 | 2494905 | 2022-05-11 | Sierra | New Mexico | 35051 | 2041 | 73 |
2494906 | 2494906 | 2022-05-11 | Socorro | New Mexico | 35053 | 3826 | 88 |
2494907 | 2494907 | 2022-05-11 | Taos | New Mexico | 35055 | 5417 | 90 |
2494908 | 2494908 | 2022-05-11 | Torrance | New Mexico | 35057 | 3148 | 55 |
2494909 | 2494909 | 2022-05-11 | Union | New Mexico | 35059 | 1008 | 16 |
2494910 | 2494910 | 2022-05-11 | Unknown | New Mexico | 65 | 0 | |
2494911 | 2494911 | 2022-05-11 | Valencia | New Mexico | 35061 | 19200 | 276 |
2494912 | 2494912 | 2022-05-11 | Albany | New York | 36001 | 63241 | 522 |
2494913 | 2494913 | 2022-05-11 | Allegany | New York | 36003 | 9258 | 154 |
2494914 | 2494914 | 2022-05-11 | Broome | New York | 36007 | 48812 | 519 |
2494915 | 2494915 | 2022-05-11 | Cattaraugus | New York | 36009 | 16081 | 222 |
2494916 | 2494916 | 2022-05-11 | Cayuga | New York | 36011 | 17345 | 152 |
2494917 | 2494917 | 2022-05-11 | Chautauqua | New York | 36013 | 24499 | 302 |
2494918 | 2494918 | 2022-05-11 | Chemung | New York | 36015 | 22545 | 232 |
2494919 | 2494919 | 2022-05-11 | Chenango | New York | 36017 | 9836 | 120 |
2494920 | 2494920 | 2022-05-11 | Clinton | New York | 36019 | 17976 | 90 |
2494921 | 2494921 | 2022-05-11 | Columbia | New York | 36021 | 10734 | 140 |
2494922 | 2494922 | 2022-05-11 | Cortland | New York | 36023 | 11346 | 120 |
2494923 | 2494923 | 2022-05-11 | Delaware | New York | 36025 | 8239 | 72 |
2494924 | 2494924 | 2022-05-11 | Dutchess | New York | 36027 | 66790 | 659 |
2494925 | 2494925 | 2022-05-11 | Erie | New York | 36029 | 226159 | 2647 |
2494926 | 2494926 | 2022-05-11 | Essex | New York | 36031 | 6103 | 60 |
2494927 | 2494927 | 2022-05-11 | Franklin | New York | 36033 | 10026 | 46 |
2494928 | 2494928 | 2022-05-11 | Fulton | New York | 36035 | 13402 | 169 |
2494929 | 2494929 | 2022-05-11 | Genesee | New York | 36037 | 14363 | 187 |
2494930 | 2494930 | 2022-05-11 | Greene | New York | 36039 | 9044 | 129 |
2494931 | 2494931 | 2022-05-11 | Hamilton | New York | 36041 | 919 | 5 |
2494932 | 2494932 | 2022-05-11 | Herkimer | New York | 36043 | 14798 | 193 |
2494933 | 2494933 | 2022-05-11 | Jefferson | New York | 36045 | 21358 | 137 |
2494934 | 2494934 | 2022-05-11 | Lewis | New York | 36049 | 6397 | 49 |
2494935 | 2494935 | 2022-05-11 | Livingston | New York | 36051 | 12295 | 118 |
2494936 | 2494936 | 2022-05-11 | Madison | New York | 36053 | 14290 | 127 |
2494937 | 2494937 | 2022-05-11 | Monroe | New York | 36055 | 163022 | 1583 |
2494938 | 2494938 | 2022-05-11 | Montgomery | New York | 36057 | 12444 | 205 |
2494939 | 2494939 | 2022-05-11 | Nassau | New York | 36059 | 424236 | 3851 |
2494940 | 2494940 | 2022-05-11 | New York City | New York | 2411431 | 40256 | |
2494941 | 2494941 | 2022-05-11 | Niagara | New York | 36063 | 50889 | 583 |
2494942 | 2494942 | 2022-05-11 | Oneida | New York | 36065 | 58246 | 801 |
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);