ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where cases = 3135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wyoming 19
- Georgia 14
- Michigan 12
- Texas 12
- Virginia 12
- Alabama 9
- Indiana 9
- Iowa 9
- Arkansas 8
- Minnesota 5
- Mississippi 5
- Tennessee 5
- Illinois 4
- Kentucky 4
- Louisiana 4
- Missouri 4
- Oklahoma 4
- Pennsylvania 4
- South Carolina 4
- South Dakota 4
- North Carolina 3
- North Dakota 3
- Ohio 3
- Oregon 3
- Puerto Rico 3
- West Virginia 3
- Arizona 1
- Colorado 1
- Maine 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444189 | 2444189 | 2022-04-25 | Converse | Wyoming | 56009 | 3135 | 55 |
2440933 | 2440933 | 2022-04-24 | Converse | Wyoming | 56009 | 3135 | 55 |
2437677 | 2437677 | 2022-04-23 | Converse | Wyoming | 56009 | 3135 | 55 |
2434421 | 2434421 | 2022-04-22 | Converse | Wyoming | 56009 | 3135 | 55 |
2431165 | 2431165 | 2022-04-21 | Converse | Wyoming | 56009 | 3135 | 55 |
2427909 | 2427909 | 2022-04-20 | Converse | Wyoming | 56009 | 3135 | 55 |
2424653 | 2424653 | 2022-04-19 | Converse | Wyoming | 56009 | 3135 | 55 |
2421397 | 2421397 | 2022-04-18 | Converse | Wyoming | 56009 | 3135 | 55 |
2418141 | 2418141 | 2022-04-17 | Converse | Wyoming | 56009 | 3135 | 55 |
2414885 | 2414885 | 2022-04-16 | Converse | Wyoming | 56009 | 3135 | 55 |
2411629 | 2411629 | 2022-04-15 | Converse | Wyoming | 56009 | 3135 | 55 |
2408373 | 2408373 | 2022-04-14 | Converse | Wyoming | 56009 | 3135 | 55 |
2405117 | 2405117 | 2022-04-13 | Converse | Wyoming | 56009 | 3135 | 55 |
2401862 | 2401862 | 2022-04-12 | Converse | Wyoming | 56009 | 3135 | 55 |
2375821 | 2375821 | 2022-04-04 | Converse | Wyoming | 56009 | 3135 | 55 |
2372569 | 2372569 | 2022-04-03 | Converse | Wyoming | 56009 | 3135 | 55 |
2369316 | 2369316 | 2022-04-02 | Converse | Wyoming | 56009 | 3135 | 55 |
2366063 | 2366063 | 2022-04-01 | Converse | Wyoming | 56009 | 3135 | 55 |
2330189 | 2330189 | 2022-03-21 | Roane | West Virginia | 54087 | 3135 | 37 |
2319664 | 2319664 | 2022-03-18 | Loiza | Puerto Rico | 72087 | 3135 | |
2316410 | 2316410 | 2022-03-17 | Loiza | Puerto Rico | 72087 | 3135 | |
2290687 | 2290687 | 2022-03-09 | Comanche | Texas | 48093 | 3135 | 78 |
2202256 | 2202256 | 2022-02-10 | Mountrail | North Dakota | 38061 | 3135 | 34 |
2148347 | 2148347 | 2022-01-25 | Van Buren | Arkansas | 5141 | 3135 | 47 |
2144136 | 2144136 | 2022-01-23 | Clay | South Dakota | 46027 | 3135 | 18 |
2140881 | 2140881 | 2022-01-22 | Clay | South Dakota | 46027 | 3135 | 18 |
2137625 | 2137625 | 2022-01-21 | Clay | South Dakota | 46027 | 3135 | 18 |
2121866 | 2121866 | 2022-01-16 | Greene | Virginia | 51079 | 3135 | 47 |
2118614 | 2118614 | 2022-01-15 | Greene | Virginia | 51079 | 3135 | 47 |
2115362 | 2115362 | 2022-01-14 | Greene | Virginia | 51079 | 3135 | 47 |
2104671 | 2104671 | 2022-01-11 | Richland | North Dakota | 38077 | 3135 | 21 |
2080945 | 2080945 | 2022-01-04 | Mason | Kentucky | 21161 | 3135 | 82 |
2083105 | 2083105 | 2022-01-04 | Lincoln | Wyoming | 56023 | 3135 | 27 |
2079298 | 2079298 | 2022-01-03 | DeWitt | Texas | 48123 | 3135 | 86 |
2060489 | 2060489 | 2021-12-29 | Cross | Arkansas | 5037 | 3135 | 70 |
2051378 | 2051378 | 2021-12-26 | Perry | Indiana | 18123 | 3135 | 59 |
2048128 | 2048128 | 2021-12-25 | Perry | Indiana | 18123 | 3135 | 59 |
2044878 | 2044878 | 2021-12-24 | Perry | Indiana | 18123 | 3135 | 59 |
2041629 | 2041629 | 2021-12-23 | Perry | Indiana | 18123 | 3135 | 59 |
2038379 | 2038379 | 2021-12-22 | Perry | Indiana | 18123 | 3135 | 59 |
2037425 | 2037425 | 2021-12-21 | Asotin | Washington | 53003 | 3135 | 52 |
2012432 | 2012432 | 2021-12-14 | Delaware | Iowa | 19055 | 3135 | 56 |
2009181 | 2009181 | 2021-12-13 | Delaware | Iowa | 19055 | 3135 | 56 |
2005930 | 2005930 | 2021-12-12 | Delaware | Iowa | 19055 | 3135 | 56 |
2002679 | 2002679 | 2021-12-11 | Delaware | Iowa | 19055 | 3135 | 56 |
1999429 | 1999429 | 2021-12-10 | Delaware | Iowa | 19055 | 3135 | 56 |
1996178 | 1996178 | 2021-12-09 | Delaware | Iowa | 19055 | 3135 | 56 |
1992927 | 1992927 | 2021-12-08 | Delaware | Iowa | 19055 | 3135 | 56 |
1974967 | 1974967 | 2021-12-02 | Gurabo | Puerto Rico | 72063 | 3135 | |
1937248 | 1937248 | 2021-11-21 | Brantley | Georgia | 13025 | 3135 | 88 |
1933998 | 1933998 | 2021-11-20 | Brantley | Georgia | 13025 | 3135 | 88 |
1930746 | 1930746 | 2021-11-19 | Brantley | Georgia | 13025 | 3135 | 88 |
1927496 | 1927496 | 2021-11-18 | Brantley | Georgia | 13025 | 3135 | 87 |
1920899 | 1920899 | 2021-11-16 | Teller | Colorado | 8119 | 3135 | 39 |
1899037 | 1899037 | 2021-11-09 | Hancock | Maine | 23009 | 3135 | 50 |
1862135 | 1862135 | 2021-10-29 | Hale | Alabama | 1065 | 3135 | 88 |
1861768 | 1861768 | 2021-10-28 | Franklin | Vermont | 50011 | 3135 | 50 |
1861815 | 1861815 | 2021-10-28 | Dinwiddie | Virginia | 51053 | 3135 | 52 |
1849836 | 1849836 | 2021-10-25 | Fulton | Indiana | 18049 | 3135 | 68 |
1839220 | 1839220 | 2021-10-21 | Hampshire | West Virginia | 54027 | 3135 | 47 |
1834494 | 1834494 | 2021-10-20 | Hill | Montana | 30041 | 3135 | 60 |
1816667 | 1816667 | 2021-10-15 | Pickens | Alabama | 1107 | 3135 | 81 |
1809635 | 1809635 | 2021-10-12 | Lavaca | Texas | 48285 | 3135 | 93 |
1768024 | 1768024 | 2021-09-30 | Lawrence | Arkansas | 5075 | 3135 | 52 |
1770882 | 1770882 | 2021-09-30 | Mecklenburg | Virginia | 51117 | 3135 | 75 |
1759213 | 1759213 | 2021-09-27 | Meade | Kentucky | 21163 | 3135 | 30 |
1748289 | 1748289 | 2021-09-23 | Wyoming | West Virginia | 54109 | 3135 | 46 |
1715463 | 1715463 | 2021-09-13 | Reeves | Texas | 48389 | 3135 | 47 |
1695923 | 1695923 | 2021-09-07 | Lampasas | Texas | 48281 | 3135 | 44 |
1691481 | 1691481 | 2021-09-06 | Nodaway | Missouri | 29147 | 3135 | 31 |
1688231 | 1688231 | 2021-09-05 | Nodaway | Missouri | 29147 | 3135 | 31 |
1684981 | 1684981 | 2021-09-04 | Nodaway | Missouri | 29147 | 3135 | 31 |
1681730 | 1681730 | 2021-09-03 | Nodaway | Missouri | 29147 | 3135 | 31 |
1677309 | 1677309 | 2021-09-02 | Berrien | Georgia | 13019 | 3135 | 53 |
1671751 | 1671751 | 2021-08-31 | Cass | Minnesota | 27021 | 3135 | 34 |
1670154 | 1670154 | 2021-08-30 | Hopewell city | Virginia | 51670 | 3135 | 80 |
1665400 | 1665400 | 2021-08-29 | Stone | Mississippi | 28131 | 3135 | 44 |
1662152 | 1662152 | 2021-08-28 | Stone | Mississippi | 28131 | 3135 | 44 |
1658904 | 1658904 | 2021-08-27 | Stone | Mississippi | 28131 | 3135 | 44 |
1653370 | 1653370 | 2021-08-25 | Jasper | South Carolina | 45053 | 3135 | 55 |
1647202 | 1647202 | 2021-08-23 | Limestone | Texas | 48293 | 3135 | 85 |
1643302 | 1643302 | 2021-08-22 | Morrow | Ohio | 39117 | 3135 | 47 |
1643790 | 1643790 | 2021-08-22 | Smith | Tennessee | 47159 | 3135 | 40 |
1640540 | 1640540 | 2021-08-21 | Smith | Tennessee | 47159 | 3135 | 40 |
1637290 | 1637290 | 2021-08-20 | Smith | Tennessee | 47159 | 3135 | 40 |
1634131 | 1634131 | 2021-08-19 | Fayette | Texas | 48149 | 3135 | 73 |
1606548 | 1606548 | 2021-08-11 | Perry | Kentucky | 21193 | 3135 | 68 |
1602995 | 1602995 | 2021-08-10 | Wells | Indiana | 18179 | 3135 | 83 |
1561412 | 1561412 | 2021-07-28 | Itawamba | Mississippi | 28057 | 3135 | 80 |
1553926 | 1553926 | 2021-07-26 | Gilmer | Georgia | 13123 | 3135 | 90 |
1516829 | 1516829 | 2021-07-14 | Tioga | Pennsylvania | 42117 | 3135 | 112 |
1501008 | 1501008 | 2021-07-09 | Hockley | Texas | 48219 | 3135 | 104 |
1459363 | 1459363 | 2021-06-27 | Lawrence | Alabama | 1079 | 3135 | 100 |
1456118 | 1456118 | 2021-06-26 | Lawrence | Alabama | 1079 | 3135 | 100 |
1452873 | 1452873 | 2021-06-25 | Lawrence | Alabama | 1079 | 3135 | 100 |
1449627 | 1449627 | 2021-06-24 | Lawrence | Alabama | 1079 | 3135 | 100 |
1446382 | 1446382 | 2021-06-23 | Lawrence | Alabama | 1079 | 3135 | 100 |
1440284 | 1440284 | 2021-06-21 | Dawson | Georgia | 13085 | 3135 | 50 |
1437037 | 1437037 | 2021-06-20 | Dawson | Georgia | 13085 | 3135 | 50 |
1418401 | 1418401 | 2021-06-14 | Houghton | Michigan | 26061 | 3135 | 43 |
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);