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,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
- Montana 35,056
- South Carolina 31,537
- Idaho 28,784
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,770
- Maryland 17,145
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,398
- Nevada 11,119
- Arizona 10,419
- Massachusetts 10,414
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179217 | 2179217 | 2022-02-03 | Esmeralda | Nevada | 32009 | 87 | 3 |
2179218 | 2179218 | 2022-02-03 | Eureka | Nevada | 32011 | 295 | 1 |
2179219 | 2179219 | 2022-02-03 | Humboldt | Nevada | 32013 | 4223 | 46 |
2179220 | 2179220 | 2022-02-03 | Lander | Nevada | 32015 | 1048 | 16 |
2179221 | 2179221 | 2022-02-03 | Lincoln | Nevada | 32017 | 929 | 5 |
2179222 | 2179222 | 2022-02-03 | Lyon | Nevada | 32019 | 10066 | 155 |
2179223 | 2179223 | 2022-02-03 | Mineral | Nevada | 32021 | 902 | 15 |
2179224 | 2179224 | 2022-02-03 | Nye | Nevada | 32023 | 6491 | 214 |
2179225 | 2179225 | 2022-02-03 | Pershing | Nevada | 32027 | 1368 | 29 |
2179226 | 2179226 | 2022-02-03 | Storey | Nevada | 32029 | 312 | 9 |
2179227 | 2179227 | 2022-02-03 | Washoe | Nevada | 32031 | 98428 | 1088 |
2179228 | 2179228 | 2022-02-03 | White Pine | Nevada | 32033 | 1834 | 18 |
2179229 | 2179229 | 2022-02-03 | Belknap | New Hampshire | 33001 | 12397 | 159 |
2179230 | 2179230 | 2022-02-03 | Carroll | New Hampshire | 33003 | 8472 | 50 |
2179231 | 2179231 | 2022-02-03 | Cheshire | New Hampshire | 33005 | 13027 | 92 |
2179232 | 2179232 | 2022-02-03 | Coos | New Hampshire | 33007 | 6267 | 93 |
2179233 | 2179233 | 2022-02-03 | Grafton | New Hampshire | 33009 | 15246 | 54 |
2179234 | 2179234 | 2022-02-03 | Hillsborough | New Hampshire | 33011 | 90820 | 838 |
2179235 | 2179235 | 2022-02-03 | Merrimack | New Hampshire | 33013 | 29460 | 202 |
2179236 | 2179236 | 2022-02-03 | Rockingham | New Hampshire | 33015 | 61978 | 473 |
2179237 | 2179237 | 2022-02-03 | Strafford | New Hampshire | 33017 | 25832 | 189 |
2179238 | 2179238 | 2022-02-03 | Sullivan | New Hampshire | 33019 | 8320 | 62 |
2179239 | 2179239 | 2022-02-03 | Unknown | New Hampshire | 8023 | 27 | |
2179240 | 2179240 | 2022-02-03 | Atlantic | New Jersey | 34001 | 66594 | 928 |
2179241 | 2179241 | 2022-02-03 | Bergen | New Jersey | 34003 | 214015 | 3325 |
2179242 | 2179242 | 2022-02-03 | Burlington | New Jersey | 34005 | 98068 | 1107 |
2179243 | 2179243 | 2022-02-03 | Camden | New Jersey | 34007 | 121581 | 1688 |
2179244 | 2179244 | 2022-02-03 | Cape May | New Jersey | 34009 | 21258 | 277 |
2179245 | 2179245 | 2022-02-03 | Cumberland | New Jersey | 34011 | 37137 | 562 |
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 |
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);