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,570
- Wisconsin 40,657
- Florida 38,810
- Pennsylvania 38,137
- 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 |
---|---|---|---|---|---|---|---|
1809166 | 1809166 | 2021-10-12 | Juniata | Pennsylvania | 42067 | 2737 | 111 |
1809167 | 1809167 | 2021-10-12 | Lackawanna | Pennsylvania | 42069 | 21903 | 508 |
1809168 | 1809168 | 2021-10-12 | Lancaster | Pennsylvania | 42071 | 68317 | 1270 |
1809169 | 1809169 | 2021-10-12 | Lawrence | Pennsylvania | 42073 | 10225 | 251 |
1809170 | 1809170 | 2021-10-12 | Lebanon | Pennsylvania | 42075 | 19786 | 318 |
1809171 | 1809171 | 2021-10-12 | Lehigh | Pennsylvania | 42077 | 47199 | 918 |
1809172 | 1809172 | 2021-10-12 | Luzerne | Pennsylvania | 42079 | 38912 | 891 |
1809173 | 1809173 | 2021-10-12 | Lycoming | Pennsylvania | 42081 | 15258 | 334 |
1809174 | 1809174 | 2021-10-12 | McKean | Pennsylvania | 42083 | 4789 | 81 |
1809175 | 1809175 | 2021-10-12 | Mercer | Pennsylvania | 42085 | 12816 | 303 |
1809176 | 1809176 | 2021-10-12 | Mifflin | Pennsylvania | 42087 | 6753 | 186 |
1809177 | 1809177 | 2021-10-12 | Monroe | Pennsylvania | 42089 | 18891 | 352 |
1809178 | 1809178 | 2021-10-12 | Montgomery | Pennsylvania | 42091 | 82840 | 1814 |
1809179 | 1809179 | 2021-10-12 | Montour | Pennsylvania | 42093 | 2366 | 70 |
1809180 | 1809180 | 2021-10-12 | Northampton | Pennsylvania | 42095 | 43262 | 774 |
1809181 | 1809181 | 2021-10-12 | Northumberland | Pennsylvania | 42097 | 12001 | 395 |
1809182 | 1809182 | 2021-10-12 | Perry | Pennsylvania | 42099 | 5010 | 113 |
1809183 | 1809183 | 2021-10-12 | Philadelphia | Pennsylvania | 42101 | 177651 | 3950 |
1809184 | 1809184 | 2021-10-12 | Pike | Pennsylvania | 42103 | 5120 | 59 |
1809185 | 1809185 | 2021-10-12 | Potter | Pennsylvania | 42105 | 1749 | 33 |
1809186 | 1809186 | 2021-10-12 | Schuylkill | Pennsylvania | 42107 | 18133 | 449 |
1809187 | 1809187 | 2021-10-12 | Snyder | Pennsylvania | 42109 | 4519 | 96 |
1809188 | 1809188 | 2021-10-12 | Somerset | Pennsylvania | 42111 | 10048 | 237 |
1809189 | 1809189 | 2021-10-12 | Sullivan | Pennsylvania | 42113 | 565 | 24 |
1809190 | 1809190 | 2021-10-12 | Susquehanna | Pennsylvania | 42115 | 3405 | 64 |
1809191 | 1809191 | 2021-10-12 | Tioga | Pennsylvania | 42117 | 4194 | 122 |
1809192 | 1809192 | 2021-10-12 | Union | Pennsylvania | 42119 | 7091 | 97 |
1809193 | 1809193 | 2021-10-12 | Venango | Pennsylvania | 42121 | 5791 | 118 |
1809194 | 1809194 | 2021-10-12 | Warren | Pennsylvania | 42123 | 3615 | 117 |
1809195 | 1809195 | 2021-10-12 | Washington | Pennsylvania | 42125 | 24039 | 372 |
1809196 | 1809196 | 2021-10-12 | Wayne | Pennsylvania | 42127 | 5402 | 102 |
1809197 | 1809197 | 2021-10-12 | Westmoreland | Pennsylvania | 42129 | 42552 | 860 |
1809198 | 1809198 | 2021-10-12 | Wyoming | Pennsylvania | 42131 | 2613 | 58 |
1809199 | 1809199 | 2021-10-12 | York | Pennsylvania | 42133 | 58929 | 927 |
1809200 | 1809200 | 2021-10-12 | Adjuntas | Puerto Rico | 72001 | 668 | |
1809201 | 1809201 | 2021-10-12 | Aguada | Puerto Rico | 72003 | 2414 | |
1809202 | 1809202 | 2021-10-12 | Aguadilla | Puerto Rico | 72005 | 3033 | |
1809203 | 1809203 | 2021-10-12 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1809204 | 1809204 | 2021-10-12 | Aibonito | Puerto Rico | 72009 | 1021 | |
1809205 | 1809205 | 2021-10-12 | Anasco | Puerto Rico | 72011 | 1418 | |
1809206 | 1809206 | 2021-10-12 | Arecibo | Puerto Rico | 72013 | 4578 | |
1809207 | 1809207 | 2021-10-12 | Arroyo | Puerto Rico | 72015 | 545 | |
1809208 | 1809208 | 2021-10-12 | Barceloneta | Puerto Rico | 72017 | 1182 | |
1809209 | 1809209 | 2021-10-12 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1809210 | 1809210 | 2021-10-12 | Bayamon | Puerto Rico | 72021 | 15672 | |
1809211 | 1809211 | 2021-10-12 | Cabo Rojo | Puerto Rico | 72023 | 1900 | |
1809212 | 1809212 | 2021-10-12 | Caguas | Puerto Rico | 72025 | 8884 | |
1809213 | 1809213 | 2021-10-12 | Camuy | Puerto Rico | 72027 | 1764 | |
1809214 | 1809214 | 2021-10-12 | Canovanas | Puerto Rico | 72029 | 3066 | |
1809215 | 1809215 | 2021-10-12 | Carolina | Puerto Rico | 72031 | 12923 | |
1809216 | 1809216 | 2021-10-12 | Catano | Puerto Rico | 72033 | 1908 | |
1809217 | 1809217 | 2021-10-12 | Cayey | Puerto Rico | 72035 | 1971 | |
1809218 | 1809218 | 2021-10-12 | Ceiba | Puerto Rico | 72037 | 663 | |
1809219 | 1809219 | 2021-10-12 | Ciales | Puerto Rico | 72039 | 1069 | |
1809220 | 1809220 | 2021-10-12 | Cidra | Puerto Rico | 72041 | 1891 | |
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 |
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);