ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
244 rows where cases = 2144 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 20
- Missouri 17
- Arkansas 14
- Iowa 14
- Kentucky 14
- Illinois 12
- Mississippi 12
- North Carolina 11
- Wisconsin 11
- Alabama 9
- Minnesota 9
- Texas 9
- Georgia 7
- Puerto Rico 7
- Indiana 6
- Michigan 6
- Colorado 5
- Kansas 5
- Louisiana 5
- Ohio 5
- Tennessee 5
- West Virginia 5
- Idaho 4
- Pennsylvania 4
- California 3
- Florida 3
- Nebraska 3
- North Dakota 3
- Utah 3
- Nevada 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453500 | 2453500 | 2022-04-28 | Live Oak | Texas | 48297 | 2144 | 42 |
2419521 | 2419521 | 2022-04-18 | Jackson | Minnesota | 27063 | 2144 | 17 |
2378858 | 2378858 | 2022-04-05 | Northampton | Virginia | 51131 | 2144 | 62 |
2339821 | 2339821 | 2022-03-24 | Northampton | Virginia | 51131 | 2144 | 61 |
2336567 | 2336567 | 2022-03-23 | Northampton | Virginia | 51131 | 2144 | 61 |
2333313 | 2333313 | 2022-03-22 | Northampton | Virginia | 51131 | 2144 | 61 |
2330060 | 2330060 | 2022-03-21 | Northampton | Virginia | 51131 | 2144 | 61 |
2325133 | 2325133 | 2022-03-20 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2321879 | 2321879 | 2022-03-19 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2318625 | 2318625 | 2022-03-18 | Clearwater | Minnesota | 27029 | 2144 | 30 |
2316425 | 2316425 | 2022-03-17 | Rincon | Puerto Rico | 72117 | 2144 | |
2289543 | 2289543 | 2022-03-09 | DeKalb | Missouri | 29063 | 2144 | 44 |
2291030 | 2291030 | 2022-03-09 | Northumberland | Virginia | 51133 | 2144 | 43 |
2285727 | 2285727 | 2022-03-08 | Norton | Kansas | 20137 | 2144 | 37 |
2287778 | 2287778 | 2022-03-08 | Northumberland | Virginia | 51133 | 2144 | 43 |
2282475 | 2282475 | 2022-03-07 | Norton | Kansas | 20137 | 2144 | 37 |
2268263 | 2268263 | 2022-03-02 | Northumberland | Virginia | 51133 | 2144 | 43 |
2257035 | 2257035 | 2022-02-27 | Howard | Missouri | 29089 | 2144 | 24 |
2253784 | 2253784 | 2022-02-26 | Howard | Missouri | 29089 | 2144 | 24 |
2250533 | 2250533 | 2022-02-25 | Howard | Missouri | 29089 | 2144 | 24 |
2245900 | 2245900 | 2022-02-24 | Nevada | Arkansas | 5099 | 2144 | 44 |
2246319 | 2246319 | 2022-02-24 | Fremont | Idaho | 16043 | 2144 | 25 |
2242649 | 2242649 | 2022-02-23 | Nevada | Arkansas | 5099 | 2144 | 44 |
2243068 | 2243068 | 2022-02-23 | Fremont | Idaho | 16043 | 2144 | 25 |
2239817 | 2239817 | 2022-02-22 | Fremont | Idaho | 16043 | 2144 | 25 |
2224433 | 2224433 | 2022-02-17 | Kemper | Mississippi | 28069 | 2144 | 45 |
2194782 | 2194782 | 2022-02-08 | Livingston | Kentucky | 21139 | 2144 | 52 |
2196102 | 2196102 | 2022-02-08 | Penuelas | Puerto Rico | 72111 | 2144 | |
2196477 | 2196477 | 2022-02-08 | La Salle | Texas | 48283 | 2144 | 42 |
2196532 | 2196532 | 2022-02-08 | Red River | Texas | 48387 | 2144 | 62 |
2192401 | 2192401 | 2022-02-07 | Graham | North Carolina | 37075 | 2144 | 30 |
2178359 | 2178359 | 2022-02-03 | Cloud | Kansas | 20029 | 2144 | 35 |
2175106 | 2175106 | 2022-02-02 | Cloud | Kansas | 20029 | 2144 | 35 |
2152347 | 2152347 | 2022-01-26 | Grant | Kansas | 20067 | 2144 | 33 |
2145519 | 2145519 | 2022-01-24 | Brown | Illinois | 17009 | 2144 | 19 |
2089800 | 2089800 | 2022-01-07 | Stone | Arkansas | 5137 | 2144 | 49 |
2046496 | 2046496 | 2021-12-24 | Morovis | Puerto Rico | 72101 | 2144 | |
2043246 | 2043246 | 2021-12-23 | Morovis | Puerto Rico | 72101 | 2144 | |
2012464 | 2012464 | 2021-12-14 | Lyon | Iowa | 19119 | 2144 | 42 |
2009213 | 2009213 | 2021-12-13 | Lyon | Iowa | 19119 | 2144 | 42 |
2009934 | 2009934 | 2021-12-13 | Pemiscot | Missouri | 29155 | 2144 | 59 |
2005962 | 2005962 | 2021-12-12 | Lyon | Iowa | 19119 | 2144 | 42 |
2006683 | 2006683 | 2021-12-12 | Pemiscot | Missouri | 29155 | 2144 | 59 |
2002711 | 2002711 | 2021-12-11 | Lyon | Iowa | 19119 | 2144 | 42 |
1999461 | 1999461 | 2021-12-10 | Lyon | Iowa | 19119 | 2144 | 42 |
1996210 | 1996210 | 2021-12-09 | Lyon | Iowa | 19119 | 2144 | 42 |
1992959 | 1992959 | 2021-12-08 | Lyon | Iowa | 19119 | 2144 | 42 |
1974073 | 1974073 | 2021-12-02 | Perry | Mississippi | 28111 | 2144 | 56 |
1971473 | 1971473 | 2021-12-01 | Morgan | Ohio | 39115 | 2144 | 38 |
1972581 | 1972581 | 2021-12-01 | Big Horn | Wyoming | 56003 | 2144 | 56 |
1929411 | 1929411 | 2021-11-18 | Potter | Pennsylvania | 42105 | 2144 | 53 |
1902456 | 1902456 | 2021-11-10 | Kanabec | Minnesota | 27065 | 2144 | 32 |
1904075 | 1904075 | 2021-11-10 | Grayson | Virginia | 51077 | 2144 | 47 |
1899604 | 1899604 | 2021-11-09 | Unknown | Nebraska | 2144 | 185 | |
1882066 | 1882066 | 2021-11-04 | Jasper | Georgia | 13159 | 2144 | 59 |
1883051 | 1883051 | 2021-11-04 | Lawrence | Mississippi | 28077 | 2144 | 40 |
1871999 | 1871999 | 2021-11-01 | Lee | Arkansas | 5077 | 2144 | 49 |
1872547 | 1872547 | 2021-11-01 | Washington | Illinois | 17189 | 2144 | 35 |
1868750 | 1868750 | 2021-10-31 | Lee | Arkansas | 5077 | 2144 | 49 |
1863678 | 1863678 | 2021-10-29 | Osage | Missouri | 29151 | 2144 | 23 |
1846127 | 1846127 | 2021-10-24 | Grand | Colorado | 8049 | 2144 | 16 |
1846518 | 1846518 | 2021-10-24 | Mason | Illinois | 17125 | 2144 | 53 |
1842877 | 1842877 | 2021-10-23 | Grand | Colorado | 8049 | 2144 | 16 |
1843268 | 1843268 | 2021-10-23 | Mason | Illinois | 17125 | 2144 | 53 |
1839627 | 1839627 | 2021-10-22 | Grand | Colorado | 8049 | 2144 | 16 |
1840018 | 1840018 | 2021-10-22 | Mason | Illinois | 17125 | 2144 | 53 |
1836769 | 1836769 | 2021-10-21 | Mason | Illinois | 17125 | 2144 | 53 |
1836065 | 1836065 | 2021-10-20 | Richland | Wisconsin | 55103 | 2144 | 23 |
1805053 | 1805053 | 2021-10-11 | Greene | Mississippi | 28041 | 2144 | 48 |
1805183 | 1805183 | 2021-10-11 | Mississippi | Missouri | 29133 | 2144 | 38 |
1801934 | 1801934 | 2021-10-10 | Mississippi | Missouri | 29133 | 2144 | 38 |
1795404 | 1795404 | 2021-10-08 | Gasconade | Missouri | 29073 | 2144 | 49 |
1790537 | 1790537 | 2021-10-06 | Crawford | Wisconsin | 55023 | 2144 | 22 |
1769267 | 1769267 | 2021-09-30 | Redwood | Minnesota | 27127 | 2144 | 43 |
1745780 | 1745780 | 2021-09-23 | Johnson | Illinois | 17087 | 2144 | 30 |
1742903 | 1742903 | 2021-09-22 | Butler | Kentucky | 21031 | 2144 | 29 |
1728931 | 1728931 | 2021-09-18 | Macon | Alabama | 1087 | 2144 | 54 |
1714171 | 1714171 | 2021-09-13 | Dallas | Missouri | 29059 | 2144 | 38 |
1706166 | 1706166 | 2021-09-11 | Clay | Alabama | 1027 | 2144 | 60 |
1702696 | 1702696 | 2021-09-09 | Southampton | Virginia | 51175 | 2144 | 58 |
1694236 | 1694236 | 2021-09-07 | Mason | Kentucky | 21161 | 2144 | 44 |
1688703 | 1688703 | 2021-09-05 | Richland | North Dakota | 38077 | 2144 | 19 |
1678880 | 1678880 | 2021-09-02 | Northampton | North Carolina | 37131 | 2144 | 62 |
1675991 | 1675991 | 2021-09-01 | Wyoming | Pennsylvania | 42131 | 2144 | 54 |
1665028 | 1665028 | 2021-08-29 | Spencer | Kentucky | 21215 | 2144 | 26 |
1661780 | 1661780 | 2021-08-28 | Spencer | Kentucky | 21215 | 2144 | 26 |
1658532 | 1658532 | 2021-08-27 | Spencer | Kentucky | 21215 | 2144 | 26 |
1655303 | 1655303 | 2021-08-26 | Bienville | Louisiana | 22013 | 2144 | 84 |
1649508 | 1649508 | 2021-08-24 | Lincoln | New Mexico | 35027 | 2144 | 20 |
1644399 | 1644399 | 2021-08-22 | Vernon | Wisconsin | 55123 | 2144 | 45 |
1641149 | 1641149 | 2021-08-21 | Vernon | Wisconsin | 55123 | 2144 | 45 |
1637899 | 1637899 | 2021-08-20 | Vernon | Wisconsin | 55123 | 2144 | 45 |
1632838 | 1632838 | 2021-08-19 | Wabasha | Minnesota | 27157 | 2144 | 3 |
1634649 | 1634649 | 2021-08-19 | Vernon | Wisconsin | 55123 | 2144 | 45 |
1614333 | 1614333 | 2021-08-13 | Naranjito | Puerto Rico | 72105 | 2144 | |
1585862 | 1585862 | 2021-08-04 | Wyoming | West Virginia | 54109 | 2144 | 41 |
1577822 | 1577822 | 2021-08-02 | Wright | Missouri | 29229 | 2144 | 35 |
1538759 | 1538759 | 2021-07-21 | Clinton | Missouri | 29049 | 2144 | 65 |
1532038 | 1532038 | 2021-07-19 | Mason | Michigan | 26105 | 2144 | 37 |
1528791 | 1528791 | 2021-07-18 | Mason | Michigan | 26105 | 2144 | 37 |
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);