ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
288 rows where cases = 1945 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 31
- Texas 23
- Puerto Rico 19
- Georgia 14
- North Carolina 12
- Alabama 11
- Arkansas 11
- Kentucky 11
- Illinois 9
- Michigan 9
- Missouri 9
- Pennsylvania 9
- Virginia 9
- Ohio 8
- Tennessee 8
- Kansas 7
- Mississippi 7
- Rhode Island 7
- West Virginia 7
- Indiana 6
- Louisiana 6
- South Dakota 6
- Wisconsin 6
- Montana 5
- Florida 4
- Oregon 4
- Nevada 3
- New Mexico 3
- North Dakota 3
- Oklahoma 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2375725 | 2375725 | 2022-04-04 | Pendleton | West Virginia | 54071 | 1945 | 18 |
2336397 | 2336397 | 2022-03-23 | Swisher | Texas | 48437 | 1945 | 34 |
2333143 | 2333143 | 2022-03-22 | Swisher | Texas | 48437 | 1945 | 34 |
2329890 | 2329890 | 2022-03-21 | Swisher | Texas | 48437 | 1945 | 34 |
2326638 | 2326638 | 2022-03-20 | Swisher | Texas | 48437 | 1945 | 34 |
2323385 | 2323385 | 2022-03-19 | Swisher | Texas | 48437 | 1945 | 34 |
2291216 | 2291216 | 2022-03-09 | Pepin | Wisconsin | 55091 | 1945 | 18 |
2287964 | 2287964 | 2022-03-08 | Pepin | Wisconsin | 55091 | 1945 | 18 |
2267027 | 2267027 | 2022-03-02 | White Pine | Nevada | 32033 | 1945 | 19 |
2262939 | 2262939 | 2022-03-01 | Kingman | Kansas | 20095 | 1945 | 26 |
2263776 | 2263776 | 2022-03-01 | White Pine | Nevada | 32033 | 1945 | 19 |
2259688 | 2259688 | 2022-02-28 | Kingman | Kansas | 20095 | 1945 | 26 |
2245909 | 2245909 | 2022-02-24 | Prairie | Arkansas | 5117 | 1945 | 39 |
2244528 | 2244528 | 2022-02-23 | Pembina | North Dakota | 38067 | 1945 | 16 |
2222121 | 2222121 | 2022-02-16 | Patillas | Puerto Rico | 72109 | 1945 | |
2217391 | 2217391 | 2022-02-15 | Clay | Kansas | 20027 | 1945 | 32 |
2214140 | 2214140 | 2022-02-14 | Clay | Kansas | 20027 | 1945 | 32 |
2197512 | 2197512 | 2022-02-09 | Wilcox | Georgia | 13315 | 1945 | 63 |
2199330 | 2199330 | 2022-02-09 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2196076 | 2196076 | 2022-02-08 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2192822 | 2192822 | 2022-02-07 | Guayanilla | Puerto Rico | 72059 | 1945 | |
2187697 | 2187697 | 2022-02-06 | Montgomery | Georgia | 13209 | 1945 | 47 |
2184444 | 2184444 | 2022-02-05 | Montgomery | Georgia | 13209 | 1945 | 47 |
2181192 | 2181192 | 2022-02-04 | Montgomery | Georgia | 13209 | 1945 | 47 |
2176878 | 2176878 | 2022-02-02 | Dallam | Texas | 48111 | 1945 | 35 |
2177305 | 2177305 | 2022-02-02 | Doddridge | West Virginia | 54017 | 1945 | 16 |
2155188 | 2155188 | 2022-01-27 | Stewart | Georgia | 13259 | 1945 | 31 |
2148799 | 2148799 | 2022-01-25 | Hamilton | Illinois | 17065 | 1945 | 29 |
2136676 | 2136676 | 2022-01-21 | DeKalb | Missouri | 29063 | 1945 | 40 |
2132359 | 2132359 | 2022-01-20 | Heard | Georgia | 13149 | 1945 | 43 |
2133315 | 2133315 | 2022-01-20 | Benton | Mississippi | 28009 | 1945 | 42 |
2126435 | 2126435 | 2022-01-18 | Hancock | Kentucky | 21091 | 1945 | 19 |
2110698 | 2110698 | 2022-01-13 | Montgomery | Missouri | 29139 | 1945 | 35 |
2098592 | 2098592 | 2022-01-09 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2095340 | 2095340 | 2022-01-08 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2092088 | 2092088 | 2022-01-07 | Bon Homme | South Dakota | 46009 | 1945 | 31 |
2088710 | 2088710 | 2022-01-06 | Barceloneta | Puerto Rico | 72017 | 1945 | |
2020144 | 2020144 | 2021-12-16 | Mercer | North Dakota | 38057 | 1945 | 21 |
2011625 | 2011625 | 2021-12-14 | Conecuh | Alabama | 1035 | 1945 | 62 |
2004001 | 2004001 | 2021-12-11 | Vinton | Ohio | 39163 | 1945 | 40 |
1991197 | 1991197 | 2021-12-07 | Cabo Rojo | Puerto Rico | 72023 | 1945 | |
1987946 | 1987946 | 2021-12-06 | Cabo Rojo | Puerto Rico | 72023 | 1945 | |
1984696 | 1984696 | 2021-12-05 | Cabo Rojo | Puerto Rico | 72023 | 1945 | |
1978762 | 1978762 | 2021-12-03 | Addison | Vermont | 50001 | 1945 | 10 |
1928481 | 1928481 | 2021-11-18 | Pope | Minnesota | 27121 | 1945 | 10 |
1917075 | 1917075 | 2021-11-14 | Greensville | Virginia | 51081 | 1945 | 26 |
1913825 | 1913825 | 2021-11-13 | Greensville | Virginia | 51081 | 1945 | 26 |
1909943 | 1909943 | 2021-11-12 | Catano | Puerto Rico | 72033 | 1945 | |
1910498 | 1910498 | 2021-11-12 | Unknown | Utah | 1945 | 38 | |
1910575 | 1910575 | 2021-11-12 | Greensville | Virginia | 51081 | 1945 | 26 |
1850180 | 1850180 | 2021-10-25 | Lyon | Kentucky | 21143 | 1945 | 26 |
1847849 | 1847849 | 2021-10-24 | Swain | North Carolina | 37173 | 1945 | 23 |
1844599 | 1844599 | 2021-10-23 | Swain | North Carolina | 37173 | 1945 | 23 |
1839954 | 1839954 | 2021-10-22 | Shoshone | Idaho | 16079 | 1945 | 59 |
1841349 | 1841349 | 2021-10-22 | Swain | North Carolina | 37173 | 1945 | 23 |
1842047 | 1842047 | 2021-10-22 | Duval | Texas | 48131 | 1945 | 57 |
1838798 | 1838798 | 2021-10-21 | Duval | Texas | 48131 | 1945 | 57 |
1819979 | 1819979 | 2021-10-16 | Bradley | Arkansas | 5011 | 1945 | 41 |
1816592 | 1816592 | 2021-10-14 | Big Horn | Wyoming | 56003 | 1945 | 46 |
1812807 | 1812807 | 2021-10-13 | Duval | Texas | 48131 | 1945 | 55 |
1806308 | 1806308 | 2021-10-11 | Duval | Texas | 48131 | 1945 | 55 |
1802334 | 1802334 | 2021-10-10 | Mitchell | North Carolina | 37121 | 1945 | 18 |
1803058 | 1803058 | 2021-10-10 | Duval | Texas | 48131 | 1945 | 55 |
1799085 | 1799085 | 2021-10-09 | Mitchell | North Carolina | 37121 | 1945 | 18 |
1795836 | 1795836 | 2021-10-08 | Mitchell | North Carolina | 37121 | 1945 | 18 |
1784105 | 1784105 | 2021-10-04 | Converse | Wyoming | 56009 | 1945 | 30 |
1774256 | 1774256 | 2021-10-01 | Monroe | West Virginia | 54063 | 1945 | 25 |
1768027 | 1768027 | 2021-09-30 | Little River | Arkansas | 5081 | 1945 | 45 |
1770806 | 1770806 | 2021-09-30 | Alleghany | Virginia | 51005 | 1945 | 61 |
1764034 | 1764034 | 2021-09-28 | Camp | Texas | 48063 | 1945 | 60 |
1732257 | 1732257 | 2021-09-19 | Chicot | Arkansas | 5017 | 1945 | 44 |
1723051 | 1723051 | 2021-09-16 | Massac | Illinois | 17127 | 1945 | 47 |
1719801 | 1719801 | 2021-09-15 | Mason | Illinois | 17125 | 1945 | 52 |
1720201 | 1720201 | 2021-09-15 | Knott | Kentucky | 21119 | 1945 | 28 |
1718275 | 1718275 | 2021-09-14 | Morovis | Puerto Rico | 72101 | 1945 | |
1718481 | 1718481 | 2021-09-14 | Meigs | Tennessee | 47121 | 1945 | 24 |
1718834 | 1718834 | 2021-09-14 | Buchanan | Virginia | 51027 | 1945 | 47 |
1719057 | 1719057 | 2021-09-14 | Crawford | Wisconsin | 55023 | 1945 | 22 |
1713278 | 1713278 | 2021-09-13 | Greene | Illinois | 17061 | 1945 | 50 |
1715027 | 1715027 | 2021-09-13 | Morovis | Puerto Rico | 72101 | 1945 | |
1698637 | 1698637 | 2021-09-08 | Clatsop | Oregon | 41007 | 1945 | 21 |
1689780 | 1689780 | 2021-09-05 | Lincoln | West Virginia | 54043 | 1945 | 29 |
1674816 | 1674816 | 2021-09-01 | Madison | Louisiana | 22065 | 1945 | 48 |
1658447 | 1658447 | 2021-08-27 | Casey | Kentucky | 21045 | 1945 | 43 |
1654799 | 1654799 | 2021-08-26 | Edgar | Illinois | 17045 | 1945 | 62 |
1649735 | 1649735 | 2021-08-24 | Walsh | North Dakota | 38099 | 1945 | 27 |
1643431 | 1643431 | 2021-08-22 | Lincoln | Oregon | 41041 | 1945 | 23 |
1640181 | 1640181 | 2021-08-21 | Lincoln | Oregon | 41041 | 1945 | 23 |
1640290 | 1640290 | 2021-08-21 | Fajardo | Puerto Rico | 72053 | 1945 | |
1636931 | 1636931 | 2021-08-20 | Lincoln | Oregon | 41041 | 1945 | 23 |
1628327 | 1628327 | 2021-08-18 | Howard | Arkansas | 5061 | 1945 | 28 |
1623695 | 1623695 | 2021-08-16 | Yancey | North Carolina | 37199 | 1945 | 28 |
1624166 | 1624166 | 2021-08-16 | Clay | South Dakota | 46027 | 1945 | 15 |
1608010 | 1608010 | 2021-08-11 | Grundy | Tennessee | 47061 | 1945 | 35 |
1600479 | 1600479 | 2021-08-09 | Dallas | Missouri | 29059 | 1945 | 35 |
1601622 | 1601622 | 2021-08-09 | Colorado | Texas | 48089 | 1945 | 33 |
1588826 | 1588826 | 2021-08-05 | Wilbarger | Texas | 48487 | 1945 | 56 |
1585576 | 1585576 | 2021-08-04 | Wilbarger | Texas | 48487 | 1945 | 56 |
1567569 | 1567569 | 2021-07-30 | Russell | Kentucky | 21207 | 1945 | 47 |
1568843 | 1568843 | 2021-07-30 | Manati | Puerto Rico | 72091 | 1945 |
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);