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 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 77,900
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,909
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,290
- Nebraska 59,855
- Minnesota 59,083
- Michigan 56,802
- Mississippi 55,890
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,402
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179246 | 2179246 | 2022-02-03 | Essex | New Jersey | 34013 | 205976 | 3472 |
2179247 | 2179247 | 2022-02-03 | Gloucester | New Jersey | 34015 | 67452 | 881 |
2179248 | 2179248 | 2022-02-03 | Hudson | New Jersey | 34017 | 164926 | 2638 |
2179249 | 2179249 | 2022-02-03 | Hunterdon | New Jersey | 34019 | 23535 | 253 |
2179250 | 2179250 | 2022-02-03 | Mercer | New Jersey | 34021 | 72830 | 1191 |
2179251 | 2179251 | 2022-02-03 | Middlesex | New Jersey | 34023 | 184424 | 2773 |
2179252 | 2179252 | 2022-02-03 | Monmouth | New Jersey | 34025 | 158429 | 2027 |
2179253 | 2179253 | 2022-02-03 | Morris | New Jersey | 34027 | 113815 | 1462 |
2179254 | 2179254 | 2022-02-03 | Ocean | New Jersey | 34029 | 156846 | 2773 |
2179255 | 2179255 | 2022-02-03 | Passaic | New Jersey | 34031 | 140200 | 2247 |
2179256 | 2179256 | 2022-02-03 | Salem | New Jersey | 34033 | 13866 | 235 |
2179257 | 2179257 | 2022-02-03 | Somerset | New Jersey | 34035 | 65022 | 944 |
2179258 | 2179258 | 2022-02-03 | Sussex | New Jersey | 34037 | 32738 | 436 |
2179259 | 2179259 | 2022-02-03 | Union | New Jersey | 34039 | 137975 | 2233 |
2179260 | 2179260 | 2022-02-03 | Unknown | New Jersey | 3482 | 0 | |
2179261 | 2179261 | 2022-02-03 | Warren | New Jersey | 34041 | 23038 | 317 |
2179262 | 2179262 | 2022-02-03 | Bernalillo | New Mexico | 35001 | 137682 | 1524 |
2179263 | 2179263 | 2022-02-03 | Catron | New Mexico | 35003 | 386 | 13 |
2179264 | 2179264 | 2022-02-03 | Chaves | New Mexico | 35005 | 21101 | 274 |
2179265 | 2179265 | 2022-02-03 | Cibola | New Mexico | 35006 | 7213 | 168 |
2179266 | 2179266 | 2022-02-03 | Colfax | New Mexico | 35007 | 2546 | 60 |
2179267 | 2179267 | 2022-02-03 | Curry | New Mexico | 35009 | 11989 | 161 |
2179268 | 2179268 | 2022-02-03 | De Baca | New Mexico | 35011 | 530 | 5 |
2179269 | 2179269 | 2022-02-03 | Doña Ana | New Mexico | 35013 | 59317 | 671 |
2179270 | 2179270 | 2022-02-03 | Eddy | New Mexico | 35015 | 16412 | 244 |
2179271 | 2179271 | 2022-02-03 | Grant | New Mexico | 35017 | 6071 | 71 |
2179272 | 2179272 | 2022-02-03 | Guadalupe | New Mexico | 35019 | 1270 | 16 |
2179273 | 2179273 | 2022-02-03 | Harding | New Mexico | 35021 | 72 | 4 |
2179274 | 2179274 | 2022-02-03 | Hidalgo | New Mexico | 35023 | 1012 | 12 |
2179275 | 2179275 | 2022-02-03 | Lea | New Mexico | 35025 | 19599 | 306 |
2179276 | 2179276 | 2022-02-03 | Lincoln | New Mexico | 35027 | 4964 | 58 |
2179277 | 2179277 | 2022-02-03 | Los Alamos | New Mexico | 35028 | 2448 | 12 |
2179278 | 2179278 | 2022-02-03 | Luna | New Mexico | 35029 | 6320 | 111 |
2179279 | 2179279 | 2022-02-03 | McKinley | New Mexico | 35031 | 24304 | 557 |
2179280 | 2179280 | 2022-02-03 | Mora | New Mexico | 35033 | 701 | 16 |
2179281 | 2179281 | 2022-02-03 | Otero | New Mexico | 35035 | 14489 | 159 |
2179282 | 2179282 | 2022-02-03 | Quay | New Mexico | 35037 | 1918 | 39 |
2179283 | 2179283 | 2022-02-03 | Rio Arriba | New Mexico | 35039 | 9337 | 112 |
2179284 | 2179284 | 2022-02-03 | Roosevelt | New Mexico | 35041 | 4701 | 88 |
2179285 | 2179285 | 2022-02-03 | San Juan | New Mexico | 35045 | 38110 | 696 |
2179286 | 2179286 | 2022-02-03 | San Miguel | New Mexico | 35047 | 5321 | 46 |
2179287 | 2179287 | 2022-02-03 | Sandoval | New Mexico | 35043 | 31029 | 346 |
2179288 | 2179288 | 2022-02-03 | Santa Fe | New Mexico | 35049 | 26544 | 234 |
2179289 | 2179289 | 2022-02-03 | Sierra | New Mexico | 35051 | 1902 | 69 |
2179290 | 2179290 | 2022-02-03 | Socorro | New Mexico | 35053 | 3606 | 79 |
2179291 | 2179291 | 2022-02-03 | Taos | New Mexico | 35055 | 4999 | 81 |
2179292 | 2179292 | 2022-02-03 | Torrance | New Mexico | 35057 | 2886 | 48 |
2179293 | 2179293 | 2022-02-03 | Union | New Mexico | 35059 | 948 | 12 |
2179294 | 2179294 | 2022-02-03 | Valencia | New Mexico | 35061 | 17877 | 226 |
2179295 | 2179295 | 2022-02-03 | Albany | New York | 36001 | 56072 | 485 |
2179296 | 2179296 | 2022-02-03 | Allegany | New York | 36003 | 8406 | 144 |
2179297 | 2179297 | 2022-02-03 | Broome | New York | 36007 | 42744 | 494 |
2179298 | 2179298 | 2022-02-03 | Cattaraugus | New York | 36009 | 14635 | 207 |
2179299 | 2179299 | 2022-02-03 | Cayuga | New York | 36011 | 15128 | 133 |
2179300 | 2179300 | 2022-02-03 | Chautauqua | New York | 36013 | 22642 | 257 |
2179301 | 2179301 | 2022-02-03 | Chemung | New York | 36015 | 20313 | 221 |
2179302 | 2179302 | 2022-02-03 | Chenango | New York | 36017 | 8734 | 114 |
2179303 | 2179303 | 2022-02-03 | Clinton | New York | 36019 | 15134 | 69 |
2179304 | 2179304 | 2022-02-03 | Columbia | New York | 36021 | 9522 | 135 |
2179305 | 2179305 | 2022-02-03 | Cortland | New York | 36023 | 9915 | 108 |
2179306 | 2179306 | 2022-02-03 | Delaware | New York | 36025 | 7279 | 67 |
2179307 | 2179307 | 2022-02-03 | Dutchess | New York | 36027 | 61983 | 617 |
2179308 | 2179308 | 2022-02-03 | Erie | New York | 36029 | 201442 | 2485 |
2179309 | 2179309 | 2022-02-03 | Essex | New York | 36031 | 5179 | 52 |
2179310 | 2179310 | 2022-02-03 | Franklin | New York | 36033 | 8519 | 40 |
2179311 | 2179311 | 2022-02-03 | Fulton | New York | 36035 | 11793 | 154 |
2179312 | 2179312 | 2022-02-03 | Genesee | New York | 36037 | 13241 | 177 |
2179313 | 2179313 | 2022-02-03 | Greene | New York | 36039 | 8195 | 113 |
2179314 | 2179314 | 2022-02-03 | Hamilton | New York | 36041 | 797 | 5 |
2179315 | 2179315 | 2022-02-03 | Herkimer | New York | 36043 | 13109 | 181 |
2179316 | 2179316 | 2022-02-03 | Jefferson | New York | 36045 | 18722 | 126 |
2179317 | 2179317 | 2022-02-03 | Lewis | New York | 36049 | 5922 | 45 |
2179318 | 2179318 | 2022-02-03 | Livingston | New York | 36051 | 11092 | 105 |
2179319 | 2179319 | 2022-02-03 | Madison | New York | 36053 | 12184 | 121 |
2179320 | 2179320 | 2022-02-03 | Monroe | New York | 36055 | 146232 | 1486 |
2179321 | 2179321 | 2022-02-03 | Montgomery | New York | 36057 | 11241 | 187 |
2179322 | 2179322 | 2022-02-03 | Nassau | New York | 36059 | 392767 | 3735 |
2179323 | 2179323 | 2022-02-03 | New York City | New York | 2243326 | 38677 | |
2179324 | 2179324 | 2022-02-03 | Niagara | New York | 36063 | 46187 | 539 |
2179325 | 2179325 | 2022-02-03 | Oneida | New York | 36065 | 50523 | 752 |
2179326 | 2179326 | 2022-02-03 | Onondaga | New York | 36067 | 103195 | 983 |
2179327 | 2179327 | 2022-02-03 | Ontario | New York | 36069 | 18758 | 166 |
2179328 | 2179328 | 2022-02-03 | Orange | New York | 36071 | 103581 | 918 |
2179329 | 2179329 | 2022-02-03 | Orleans | New York | 36073 | 8334 | 108 |
2179330 | 2179330 | 2022-02-03 | Oswego | New York | 36075 | 23641 | 162 |
2179331 | 2179331 | 2022-02-03 | Otsego | New York | 36077 | 9203 | 81 |
2179332 | 2179332 | 2022-02-03 | Putnam | New York | 36079 | 22912 | 118 |
2179333 | 2179333 | 2022-02-03 | Rensselaer | New York | 36083 | 29695 | 237 |
2179334 | 2179334 | 2022-02-03 | Rockland | New York | 36087 | 89909 | 883 |
2179335 | 2179335 | 2022-02-03 | Saratoga | New York | 36091 | 43541 | 307 |
2179336 | 2179336 | 2022-02-03 | Schenectady | New York | 36093 | 31349 | 287 |
2179337 | 2179337 | 2022-02-03 | Schoharie | New York | 36095 | 4717 | 33 |
2179338 | 2179338 | 2022-02-03 | Schuyler | New York | 36097 | 3256 | 23 |
2179339 | 2179339 | 2022-02-03 | Seneca | New York | 36099 | 5480 | 88 |
2179340 | 2179340 | 2022-02-03 | St. Lawrence | New York | 36089 | 19345 | 167 |
2179341 | 2179341 | 2022-02-03 | Steuben | New York | 36101 | 18707 | 233 |
2179342 | 2179342 | 2022-02-03 | Suffolk | New York | 36103 | 417188 | 4232 |
2179343 | 2179343 | 2022-02-03 | Sullivan | New York | 36105 | 17734 | 119 |
2179344 | 2179344 | 2022-02-03 | Tioga | New York | 36107 | 10119 | 81 |
2179345 | 2179345 | 2022-02-03 | Tompkins | New York | 36109 | 16534 | 77 |
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);