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 139,392
- Georgia 90,649
- Virginia 74,793
- Kentucky 66,892
- Missouri 64,562
- Illinois 57,460
- Kansas 56,788
- North Carolina 56,409
- Iowa 55,670
- Tennessee 54,271
- Indiana 52,198
- Ohio 50,055
- Nebraska 49,139
- Minnesota 49,051
- Michigan 47,226
- Mississippi 46,542
- Oklahoma 43,231
- Arkansas 42,768
- Puerto Rico 41,549
- Wisconsin 40,657
- Florida 38,810
- Pennsylvania 38,103
- Alabama 37,974
- Louisiana 36,992
- Colorado 35,831
- South Dakota 35,494
- California 33,280
- New York 33,280
- West Virginia 30,523
- North Dakota 28,943
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1809221 | 1809221 | 2021-10-12 | Coamo | Puerto Rico | 72043 | 1405 | |
1809222 | 1809222 | 2021-10-12 | Comerio | Puerto Rico | 72045 | 1056 | |
1809223 | 1809223 | 2021-10-12 | Corozal | Puerto Rico | 72047 | 2427 | |
1809224 | 1809224 | 2021-10-12 | Culebra | Puerto Rico | 72049 | 56 | |
1809225 | 1809225 | 2021-10-12 | Dorado | Puerto Rico | 72051 | 3369 | |
1809226 | 1809226 | 2021-10-12 | Fajardo | Puerto Rico | 72053 | 2158 | |
1809227 | 1809227 | 2021-10-12 | Florida | Puerto Rico | 72054 | 996 | |
1809228 | 1809228 | 2021-10-12 | Guanica | Puerto Rico | 72055 | 439 | |
1809229 | 1809229 | 2021-10-12 | Guayama | Puerto Rico | 72057 | 1348 | |
1809230 | 1809230 | 2021-10-12 | Guayanilla | Puerto Rico | 72059 | 678 | |
1809231 | 1809231 | 2021-10-12 | Guaynabo | Puerto Rico | 72061 | 6775 | |
1809232 | 1809232 | 2021-10-12 | Gurabo | Puerto Rico | 72063 | 3045 | |
1809233 | 1809233 | 2021-10-12 | Hatillo | Puerto Rico | 72065 | 1864 | |
1809234 | 1809234 | 2021-10-12 | Hormigueros | Puerto Rico | 72067 | 694 | |
1809235 | 1809235 | 2021-10-12 | Humacao | Puerto Rico | 72069 | 3010 | |
1809236 | 1809236 | 2021-10-12 | Isabela | Puerto Rico | 72071 | 2529 | |
1809237 | 1809237 | 2021-10-12 | Jayuya | Puerto Rico | 72073 | 647 | |
1809238 | 1809238 | 2021-10-12 | Juana Diaz | Puerto Rico | 72075 | 1744 | |
1809239 | 1809239 | 2021-10-12 | Juncos | Puerto Rico | 72077 | 2981 | |
1809240 | 1809240 | 2021-10-12 | Lajas | Puerto Rico | 72079 | 801 | |
1809241 | 1809241 | 2021-10-12 | Lares | Puerto Rico | 72081 | 1402 | |
1809242 | 1809242 | 2021-10-12 | Las Marias | Puerto Rico | 72083 | 404 | |
1809243 | 1809243 | 2021-10-12 | Las Piedras | Puerto Rico | 72085 | 2272 | |
1809244 | 1809244 | 2021-10-12 | Loiza | Puerto Rico | 72087 | 1726 | |
1809245 | 1809245 | 2021-10-12 | Luquillo | Puerto Rico | 72089 | 1238 | |
1809246 | 1809246 | 2021-10-12 | Manati | Puerto Rico | 72091 | 2334 | |
1809247 | 1809247 | 2021-10-12 | Maricao | Puerto Rico | 72093 | 178 | |
1809248 | 1809248 | 2021-10-12 | Maunabo | Puerto Rico | 72095 | 557 | |
1809249 | 1809249 | 2021-10-12 | Mayaguez | Puerto Rico | 72097 | 3862 | |
1809250 | 1809250 | 2021-10-12 | Moca | Puerto Rico | 72099 | 2409 | |
1809251 | 1809251 | 2021-10-12 | Morovis | Puerto Rico | 72101 | 1975 | |
1809252 | 1809252 | 2021-10-12 | Naguabo | Puerto Rico | 72103 | 1484 | |
1809253 | 1809253 | 2021-10-12 | Naranjito | Puerto Rico | 72105 | 2372 | |
1809254 | 1809254 | 2021-10-12 | Orocovis | Puerto Rico | 72107 | 1202 | |
1809255 | 1809255 | 2021-10-12 | Patillas | Puerto Rico | 72109 | 556 | |
1809256 | 1809256 | 2021-10-12 | Penuelas | Puerto Rico | 72111 | 781 | |
1809257 | 1809257 | 2021-10-12 | Ponce | Puerto Rico | 72113 | 5514 | |
1809258 | 1809258 | 2021-10-12 | Quebradillas | Puerto Rico | 72115 | 1341 | |
1809259 | 1809259 | 2021-10-12 | Rincon | Puerto Rico | 72117 | 917 | |
1809260 | 1809260 | 2021-10-12 | Rio Grande | Puerto Rico | 72119 | 3241 | |
1809261 | 1809261 | 2021-10-12 | Sabana Grande | Puerto Rico | 72121 | 760 | |
1809262 | 1809262 | 2021-10-12 | Salinas | Puerto Rico | 72123 | 1432 | |
1809263 | 1809263 | 2021-10-12 | San German | Puerto Rico | 72125 | 1116 | |
1809264 | 1809264 | 2021-10-12 | San Juan | Puerto Rico | 72127 | 28661 | |
1809265 | 1809265 | 2021-10-12 | San Lorenzo | Puerto Rico | 72129 | 2394 | |
1809266 | 1809266 | 2021-10-12 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1809267 | 1809267 | 2021-10-12 | Santa Isabel | Puerto Rico | 72133 | 847 | |
1809268 | 1809268 | 2021-10-12 | Toa Alta | Puerto Rico | 72135 | 5696 | |
1809269 | 1809269 | 2021-10-12 | Toa Baja | Puerto Rico | 72137 | 6107 | |
1809270 | 1809270 | 2021-10-12 | Trujillo Alto | Puerto Rico | 72139 | 4540 | |
1809271 | 1809271 | 2021-10-12 | Unknown | Puerto Rico | 5405 | 3193 | |
1809272 | 1809272 | 2021-10-12 | Utuado | Puerto Rico | 72141 | 1359 | |
1809273 | 1809273 | 2021-10-12 | Vega Alta | Puerto Rico | 72143 | 2912 | |
1809274 | 1809274 | 2021-10-12 | Vega Baja | Puerto Rico | 72145 | 4389 | |
1809275 | 1809275 | 2021-10-12 | Vieques | Puerto Rico | 72147 | 266 | |
1809276 | 1809276 | 2021-10-12 | Villalba | Puerto Rico | 72149 | 1015 | |
1809277 | 1809277 | 2021-10-12 | Yabucoa | Puerto Rico | 72151 | 1627 | |
1809278 | 1809278 | 2021-10-12 | Yauco | Puerto Rico | 72153 | 1438 | |
1809279 | 1809279 | 2021-10-12 | Bristol | Rhode Island | 44001 | 5857 | 149 |
1809280 | 1809280 | 2021-10-12 | Kent | Rhode Island | 44003 | 21881 | 384 |
1809281 | 1809281 | 2021-10-12 | Newport | Rhode Island | 44005 | 8404 | 51 |
1809282 | 1809282 | 2021-10-12 | Providence | Rhode Island | 44007 | 111666 | 2075 |
1809283 | 1809283 | 2021-10-12 | Unknown | Rhode Island | 14078 | 21 | |
1809284 | 1809284 | 2021-10-12 | Washington | Rhode Island | 44009 | 13601 | 176 |
1809285 | 1809285 | 2021-10-12 | Abbeville | South Carolina | 45001 | 3738 | 47 |
1809286 | 1809286 | 2021-10-12 | Aiken | South Carolina | 45003 | 26477 | 321 |
1809287 | 1809287 | 2021-10-12 | Allendale | South Carolina | 45005 | 1340 | 21 |
1809288 | 1809288 | 2021-10-12 | Anderson | South Carolina | 45007 | 35691 | 699 |
1809289 | 1809289 | 2021-10-12 | Bamberg | South Carolina | 45009 | 2110 | 63 |
1809290 | 1809290 | 2021-10-12 | Barnwell | South Carolina | 45011 | 3842 | 82 |
1809291 | 1809291 | 2021-10-12 | Beaufort | South Carolina | 45013 | 26841 | 295 |
1809292 | 1809292 | 2021-10-12 | Berkeley | South Carolina | 45015 | 30604 | 318 |
1809293 | 1809293 | 2021-10-12 | Calhoun | South Carolina | 45017 | 1720 | 51 |
1809294 | 1809294 | 2021-10-12 | Charleston | South Carolina | 45019 | 64191 | 676 |
1809295 | 1809295 | 2021-10-12 | Cherokee | South Carolina | 45021 | 9790 | 230 |
1809296 | 1809296 | 2021-10-12 | Chester | South Carolina | 45023 | 6251 | 105 |
1809297 | 1809297 | 2021-10-12 | Chesterfield | South Carolina | 45025 | 7058 | 141 |
1809298 | 1809298 | 2021-10-12 | Clarendon | South Carolina | 45027 | 4945 | 135 |
1809299 | 1809299 | 2021-10-12 | Colleton | South Carolina | 45029 | 5578 | 188 |
1809300 | 1809300 | 2021-10-12 | Darlington | South Carolina | 45031 | 11736 | 223 |
1809301 | 1809301 | 2021-10-12 | Dillon | South Carolina | 45033 | 6320 | 111 |
1809302 | 1809302 | 2021-10-12 | Dorchester | South Carolina | 45035 | 33266 | 361 |
1809303 | 1809303 | 2021-10-12 | Edgefield | South Carolina | 45037 | 4362 | 53 |
1809304 | 1809304 | 2021-10-12 | Fairfield | South Carolina | 45039 | 3231 | 94 |
1809305 | 1809305 | 2021-10-12 | Florence | South Carolina | 45041 | 26248 | 520 |
1809306 | 1809306 | 2021-10-12 | Georgetown | South Carolina | 45043 | 9510 | 166 |
1809307 | 1809307 | 2021-10-12 | Greenville | South Carolina | 45045 | 102806 | 1340 |
1809308 | 1809308 | 2021-10-12 | Greenwood | South Carolina | 45047 | 11978 | 208 |
1809309 | 1809309 | 2021-10-12 | Hampton | South Carolina | 45049 | 3060 | 72 |
1809310 | 1809310 | 2021-10-12 | Horry | South Carolina | 45051 | 61012 | 839 |
1809311 | 1809311 | 2021-10-12 | Jasper | South Carolina | 45053 | 3896 | 77 |
1809312 | 1809312 | 2021-10-12 | Kershaw | South Carolina | 45055 | 11745 | 196 |
1809313 | 1809313 | 2021-10-12 | Lancaster | South Carolina | 45057 | 15623 | 219 |
1809314 | 1809314 | 2021-10-12 | Laurens | South Carolina | 45059 | 11250 | 209 |
1809315 | 1809315 | 2021-10-12 | Lee | South Carolina | 45061 | 2491 | 74 |
1809316 | 1809316 | 2021-10-12 | Lexington | South Carolina | 45063 | 53432 | 689 |
1809317 | 1809317 | 2021-10-12 | Marion | South Carolina | 45067 | 5372 | 134 |
1809318 | 1809318 | 2021-10-12 | Marlboro | South Carolina | 45069 | 4730 | 77 |
1809319 | 1809319 | 2021-10-12 | McCormick | South Carolina | 45065 | 1326 | 30 |
1809320 | 1809320 | 2021-10-12 | Newberry | South Carolina | 45071 | 7357 | 142 |
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);